protected void Add_Click(object sender, EventArgs e)
{
_ueEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_ueEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_ueEntity.LogMessages.Username = UserSession.Current.UserDspName;
_ueEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
string usersList = "";
string roleId = Request.QueryString["roleid"];
for (int i = 0; i < this.SmartGridView2.Rows.Count; i++)
{
CheckBox ck = (CheckBox)this.SmartGridView2.Rows[i].FindControl("checkitem2");
if (ck.Checked == true)
{
string strUser = this.SmartGridView2.Rows[i].Cells[1].Text.Trim();
usersList += strUser + ",";
}
}
if (usersList != "")
{
usersList = usersList.TrimEnd(',');
string[] usersArry = usersList.Split(',');
for (int i = 0; i < usersArry.Length; i++)
{
//string sql = "insert into [CMS_SYS_USER_ELEMENT]([Role_ID],[User_Account],[UE_Type],[UE_Creator]) values ("+ roleId + ",'" + usersArry[i].ToString() + "',0,'" + UserSession.Current.UserAccount + "')";
//DbHelperSQL.ExecuteSql(sql);
_ueEntity.UserElementDBEntity = new List<UserElementDBEntity>();
UserElementDBEntity ueDBEntity = new UserElementDBEntity();
ueDBEntity.RoleID = roleId;
ueDBEntity.UserAccount = usersArry[i].ToString();
ueDBEntity.UEType = "0";
ueDBEntity.UECreator = UserSession.Current.UserAccount;
_ueEntity.UserElementDBEntity.Add(ueDBEntity);
int intResult = UserElementBP.Insert(_ueEntity);
}
}
BindGridView1();
BindGridView2();
}
protected void Delete_Click(object sender, EventArgs e)
{
_ueEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_ueEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_ueEntity.LogMessages.Username = UserSession.Current.UserDspName;
_ueEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
string usersList = "";
string roleId = Request.QueryString["roleid"];
for (int i = 0; i < this.SmartGridView1.Rows.Count; i++)
{
CheckBox ck = (CheckBox)this.SmartGridView1.Rows[i].FindControl("checkitem1");
if (ck.Checked == true)
{
string strUser = this.SmartGridView1.Rows[i].Cells[1].Text.Trim();
usersList += strUser + ",";
}
}
if (usersList != "")
{
usersList = usersList.TrimEnd(',');
string[] iTempDel = usersList.Split(',');
for (int i = 0; i < iTempDel.Length; i++)
{
//string sql = "delete from CMS_SYS_USER_ELEMENT where role_id=" + int.Parse(roleId) + " and User_Account='" + iTempDel[i].ToString() + "'";
//DbHelperSQL.ExecuteSql(sql);
_ueEntity.UserElementDBEntity = new List<UserElementDBEntity>();
UserElementDBEntity ueDBEntity = new UserElementDBEntity();
ueDBEntity.RoleID = roleid;
ueDBEntity.UserAccount = iTempDel[i].ToString();
_ueEntity.UserElementDBEntity.Add(ueDBEntity);
int intResult = UserElementBP.Delete(_ueEntity);
}
}
BindGridView1();
BindGridView2();
}
//显示在该角色中的用户
private void BindGridView1()
{
//string Sql = " SELECT * FROM CMS_SYS_USERS where [User_Active]=1 and User_Account in ( SELECT User_Account FROM CMS_SYS_USER_ELEMENT WHERE role_id = " + roleid + ")";
//DataTable dtUser = DbHelperSQL.Query(Sql).Tables[0];
//GridviewControl.GridViewDataBind(this.SmartGridView1, dtUser);
_ueEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_ueEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_ueEntity.LogMessages.Username = UserSession.Current.UserDspName;
_ueEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_ueEntity.UserElementDBEntity = new List<UserElementDBEntity>();
UserElementDBEntity ueDBEntity = new UserElementDBEntity();
ueDBEntity.RoleID = roleid;
//cityDBEntity.Name_CN = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Name_CN"].ToString())) ? null : ViewState["Name_CN"].ToString();
//cityDBEntity.OnlineStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OnlineStatus"].ToString())) ? null : ViewState["OnlineStatus"].ToString();
//cityDBEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString();
//cityDBEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString();
_ueEntity.UserElementDBEntity.Add(ueDBEntity);
DataSet dsResult = UserElementBP.SelectInRole(_ueEntity).QueryResult;
DataTable dtUser = dsResult.Tables[0];
GridviewControl.GridViewDataBind(this.SmartGridView1, dtUser);
}
//显示不在该角色中的用户
private void BindGridView2()
{
string account = "";
string dspname = "";
string getStr = string.Empty;
account = CommonFunction.StringFilter(txtAccount.Text.Trim());
dspname = CommonFunction.StringFilter(txtDspName.Text.Trim());
if (account.Length > 0 || dspname.Length > 0)
{
if (account.Length > 0)
{
getStr += string.Format(" and USER_Account like '%{0}%' ", account);
}
if (dspname.Length > 0)
{
getStr += string.Format(" and USER_DspName like '%{0}%' ", dspname);
}
}
//string Sql = " SELECT * FROM CMS_SYS_USERS where [User_Active]=1 and User_Account not in ( SELECT User_Account FROM CMS_SYS_USER_ELEMENT WHERE role_id = " + roleid + ")" + getStr;
//DataTable dtUser = DbHelperSQL.Query(Sql).Tables[0];
//GridviewControl.GridViewDataBind(this.SmartGridView2, dtUser);
_ueEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_ueEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_ueEntity.LogMessages.Username = UserSession.Current.UserDspName;
_ueEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_ueEntity.UserElementDBEntity = new List<UserElementDBEntity>();
UserElementDBEntity ueDBEntity = new UserElementDBEntity();
ueDBEntity.RoleID = roleid;
_ueEntity.UserElementDBEntity.Add(ueDBEntity);
DataSet dsResult = UserElementBP.SelectNotInRole(_ueEntity,getStr).QueryResult;
DataTable dtUser = dsResult.Tables[0];
GridviewControl.GridViewDataBind(this.SmartGridView2, dtUser);
}
//增加新用户，执行方法
private void addUser(string strUserAccount, string strUserName, string strEmail, string strPwd, string strHRID, string strTel, string strTitle, string strUserManager)
{
strUserAccount = CommonFunction.StringFilter(strUserAccount);
strUserName = CommonFunction.StringFilter(strUserName);
strEmail = CommonFunction.StringFilter(strEmail);
DataCommand cmd = DataCommandManager.GetDataCommand("InsertCmsUser");
cmd.SetParameterValue("@User_Account", strUserAccount);
cmd.SetParameterValue("@User_Pwd", strPwd);
cmd.SetParameterValue("@User_DspName", strUserName);
cmd.SetParameterValue("@User_Email", strEmail);
cmd.SetParameterValue("@User_HRID", strHRID);
cmd.SetParameterValue("@User_Tel", strTel);
cmd.SetParameterValue("@User_Title", strTitle);
cmd.SetParameterValue("@User_Manager", strUserManager);
int i = cmd.ExecuteNonQuery();
if (!String.IsNullOrEmpty(ddpRole.SelectedValue))
{
UserElementEntity _ueEntity = new UserElementEntity();
_ueEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_ueEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_ueEntity.LogMessages.Username = UserSession.Current.UserDspName;
_ueEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_ueEntity.UserElementDBEntity = new List<UserElementDBEntity>();
UserElementDBEntity ueDBEntity = new UserElementDBEntity();
ueDBEntity.RoleID = ddpRole.SelectedValue;
ueDBEntity.UserAccount = strUserAccount;
ueDBEntity.UEType = "0";
ueDBEntity.UECreator = UserSession.Current.UserAccount;
_ueEntity.UserElementDBEntity.Add(ueDBEntity);
int intResult = UserElementBP.Insert(_ueEntity);
}
}
