using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using HySoft.Common;
namespace HySoft.BaseCallCenter.Web.sysmanage
{
public partial class userAllocationRole : System.Web.UI.Page
{
string roleId = "";
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
roleId = Request.QueryString["ResetRole"];
getUserRoleNmae(roleId);
}
//初始化方法
}
///
/// 初始化方法
///
///
public void getUserRoleNmae(string userid) {
string sql = "select * from t_sys_userAccount where F_UserId ='" + userid + "'";
DataTable dt = DBUtility.DbHelperSQL.Query(sql).Tables[0];
if (dt.Rows.Count > 0)
{
txtWorkingCode.Text = dt.Rows[0]["F_UserCode"].ToString();
txtRealName.Text = dt.Rows[0]["F_UserName"].ToString();
}
BindDropListRoles();
}
#region 绑定下拉列表
///
/// 绑定下拉列表角色
///
private void BindDropListRoles()
{
DataTable dt = new DataTable();
try
{
this.DropDownListRole.Items.Clear();
dt = new HySoft.BaseCallCenter.BLL.T_Sys_RoleInfo().GetList("1=1").Tables[0];
foreach (DataRow dr in dt.Rows)
{
DropDownListRole.Items.Add(new ListItem(dr["F_RoleName"].ToString(), dr["F_RoleId"].ToString()));
}
this.DropDownListRole.Items.Insert(0, new ListItem("--请选择--", ""));
}
catch (Exception ex)
{
SysLog.WriteLog(ex);
}
finally
{
dt.Clear();
dt.Dispose();
}
}
#endregion
///
/// 保存方法
///
///
///
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string sql = "";
string sqlstr = "";
int reslust = 0;
if (!string.IsNullOrEmpty(DropDownListRole.Text))
{
//根据用户id和原密码确定用户是否存在
sqlstr = "select * from t_sys_userAccount where F_UserId='" + Request.QueryString["ResetRole"] + "'";
DataTable dt = DBUtility.DbHelperSQL.Query(sqlstr).Tables[0];
if (dt.Rows.Count > 0)
{
sql = "update t_sys_userAccount set F_RoleId='" + hfRoleName.Value + "' where F_UserId ='" + Request.QueryString["ResetRole"] + "'";
reslust = DBUtility.DbHelperSQL.ExecuteSql(sql);
if (reslust > 0)
{
MessageBoxToWindow("分配角色成功", "提示!", "success");
}
else
{
MessageBoxToWindow("分配角色失败", "提示!", "error");
}
}
else
{
MessageBoxToWindow("不存在此用户", "提示!", "error");
}
}
}
catch (Exception ex)
{
}
}
#region 弹出对话框
///
/// 弹出对话框
///
///
///
///
public void MessageBoxToWindow(string title, string content, string type)
{
string script = "";
switch (type)
{
case "error"://失败
type = "error";
script = "";
break;
case "success"://成功
type = "info";
script = "";
break;
case "catch"://异常
type = "warning";
script = "";
break;
default:
type = "question";
break;
}
ClientScript.RegisterClientScriptBlock(this.GetType(), "", script);
}
#endregion
}
}