/// <summary> /// 绑定用户数据 /// </summary> private void BindUsers() { UsersEO usersEO = GetUser(); // 获取登录用户的信息 int leave = GetUserLeave(); // 获取用户级别 StringBuilder strWhere = new StringBuilder(); IList <MySqlParameter> parm = new List <MySqlParameter>(); string beginTime = this.txtBeginTime.Text.Trim(); string endTime = this.txtEndTime.Text.Trim(); string queryId = this.txtdId.Text.Trim(); int curGameId = 0; if (!string.IsNullOrEmpty(Session["currentgameid"].ToString())) { curGameId = Convert.ToInt32(Session["currentgameid"].ToString()); } if (curGameId != 0) { this.txtdId.Visible = false; bool isFirst = true; strWhere.Append(string.Format(" Wx_duid = '{0}'", curGameId)); if (!string.IsNullOrEmpty(beginTime)) { strWhere.Append(string.Format(" And Wx_bindtime > '{0}'", beginTime)); isFirst = false; } if (!string.IsNullOrEmpty(endTime)) { if (isFirst) { strWhere.Append(string.Format(" And Wx_bindtime < '{0}'", endTime)); } else { strWhere.Append(string.Format(" And Wx_bindtime < '{0}'", endTime)); } } } else { //管理员 this.txtdId.Visible = true; bool isQuereIdNull = true; if (!string.IsNullOrEmpty(queryId)) { strWhere.Append(string.Format(" Wx_duid = '{0}'", queryId)); isQuereIdNull = false; } if (!string.IsNullOrEmpty(beginTime)) { if (isQuereIdNull) { strWhere.Append(string.Format(" Wx_bindtime > '{0}'", beginTime)); } else { strWhere.Append(string.Format(" And Wx_bindtime > '{0}'", beginTime)); } } if (!string.IsNullOrEmpty(endTime)) { strWhere.Append(string.Format(" And Wx_bindtime < '{0}'", endTime)); } } DataView view = wxUserManage.GetTable(strWhere.ToString(), parm).DefaultView; string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"]; view.Sort = sort; this.gvUsers.DataSource = view; this.gvUsers.DataBind(); }
/// <summary> /// 添加、修改数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnOK_Click(object sender, EventArgs e) { if (Page.IsValid) { #region 验证表单合法性 if (this.CheckForms() == false) { CloseDivImplementation(); return; } #endregion #region 初始化数据 UsersEO usersEO = new UsersEO(); RoleuserEO rluEO = new RoleuserEO(); if (Request.QueryString["State"] == "U") { usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]); if (cbk_password.Checked) { usersEO.UrPass = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密 } } usersEO.UrLoginName = this.txtLoginName.Text.Trim(); usersEO.UrName = this.txtName.Text.Trim(); usersEO.UrParent = this.txtParent.Text.Trim(); usersEO.UrPhone = "";//this.txtPhone.Text.Trim(); usersEO.UrZone = this.txtZone.Text.Trim(); usersEO.UrPeople = this.txtContactPeople.Text.Trim(); usersEO.UrContact = this.txtContact.Text.Trim(); usersEO.UrGameId = this.txtGameId.Text.Trim(); usersEO.UrDiamondNum = this.txtDiamondNum.Text.Trim(); usersEO.UrBankName = ""; //this.txtBankName.Text.Trim(); usersEO.UrBank = ""; //this.txtBank.Text.Trim(); usersEO.UrPercent = this.txtPercent.Text.Trim(); usersEO.UrBankNo = ""; //this.txtBankNo.Text.Trim(); usersEO.UrIntroducer = ""; //this.txtIntrdouce.Text.Trim(); usersEO.UrName = this.txtName.Text.Trim(); usersEO.UrName = this.txtName.Text.Trim(); usersEO.UrRolestate = this.ddlDepartment.SelectedIndex.ToString(); usersEO.UrDepartment = this.ddlDepartment.SelectedIndex.ToString(); usersEO.UrState = this.rblState.SelectedValue; usersEO.UrLockBindIp = this.txtUserIps.Text.ToString().Trim(); //usersEO.UrText1 = this.ddlUserLeave.Text.ToString().Trim(); // 用户级别 #endregion #region 设置用户账号归属管理 //用户角色信息 int itemCount = 0; // 选择的数量 string strAccountManagement = ""; for (int i = 0; i < this.cbAccountManagement.Items.Count; i++) { if (this.cbAccountManagement.Items[i].Selected) { strAccountManagement += this.cbAccountManagement.Items[i].Value; strAccountManagement += ";"; itemCount++; } } usersEO.UrText2 = strAccountManagement; if (itemCount > 5) { this.divAlert.Visible = true; this.lblAlert.Text = "账号管理归属最多选择4个人"; CloseDivImplementation(); return; } #endregion #region 创建用户 if (Request.QueryString["State"] == "A") { //判断用户账号是否存在 if (this.CheckUserLoginName() == false) { //Jswork.Alert("用户账号【" + this.txtLoginName.Text.Trim() + "】已存在", this.Page); this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.User_account1 + this.txtLoginName.Text.Trim() + Resources.Resource.Already_exist; CloseDivImplementation(); return; } //用户信息 usersEO.UrId = GetBigGuid(); usersEO.UrPass = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密 usersEO.UrDel = "0"; usersEO.UrAddUser = GetUserID(); usersEO.UrAddTime = DateTime.Now; usersEO.UrLockTime = DateTime.Now; //用户角色信息 for (int i = 0; i < this.cblRoles.Items.Count; i++) { if (this.cblRoles.Items[i].Selected) { rluEO.UrId = usersEO.UrId; rluEO.RlId = this.cblRoles.Items[i].Value; rluEO.RuAddUser = GetUserID(); rluEO.RuAddTime = DateTime.Now; rluManage.AddRoleUser(rluEO); } } if (userManage.AddUser(usersEO) > 0) { //插入操作日志 InsertLog(Resources.Resource.Create_user, string.Format("username:{0},id:{1}", usersEO.UrName, usersEO.UrId), 4, GetPlatformIdByValue(1)); CloseDivImplementation(); Jswork.Alert(Resources.Resource.User_information_creation_success, "UsersList.aspx"); } else { //Jswork.Alert("用户信息创建失败", this.Page); this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.User_information_creation_failed;//"用户信息创建失败"; } } #endregion #region 修改用户 if (Request.QueryString["State"] == "U") { //修改时判断账号是否存在 if (hfLoginName.Value != this.txtLoginName.Text.Trim()) { //判断用户账号是否存在 if (this.CheckUserLoginName() == false) { //Jswork.Alert("用户账号【" + this.txtLoginName.Text.Trim() + "】已存在", this.Page); this.divAlert.Visible = true; //this.lblAlert.Text = "用户账号【" + this.txtLoginName.Text.Trim() + "】已存在"; this.lblAlert.Text = Resources.Resource.User_account1 + this.txtLoginName.Text.Trim() + Resources.Resource.Already_exist; CloseDivImplementation(); return; } } //用户角色信息 rluManage.RemoveByPK(Request.QueryString["Urid"]); //插入用户角色关系表数据前先删除数据 for (int i = 0; i < this.cblRoles.Items.Count; i++) { if (this.cblRoles.Items[i].Selected) { rluEO.UrId = usersEO.UrId; rluEO.RlId = this.cblRoles.Items[i].Value; rluEO.RuAddUser = GetUserID(); rluEO.RuAddTime = DateTime.Now; rluManage.AddRoleUser(rluEO); } } if (userManage.EditUser(usersEO) > 0) { if (usersEO.UrState == "0") // 启用状态 { UserUnFreeZing(usersEO.UrId, DateTime.Now.AddMonths(-1)); } //插入操作日志 InsertLog(Resources.Resource.Modify_user, string.Format("username:{0},id:{1}", usersEO.UrName, usersEO.UrId), 2, GetPlatformIdByValue(1)); CloseDivImplementation(); Jswork.Alert(Resources.Resource.Success_of_user_information_modification, "UsersList.aspx"); } else { //Jswork.Alert("用户信息修改失败", this.Page); this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.User_information_modification_failed;//"用户信息修改失败"; } } #endregion CloseDivImplementation(); } }
private void BindUsers1() { UsersEO usersEO = GetUser(); // 获取登录用户的信息 int leave = GetUserLeave(); // 获取用户级别 StringBuilder strWhere = new StringBuilder(); IList <MySqlParameter> parm = new List <MySqlParameter>(); if (!string.IsNullOrEmpty(this.ddlRoleName.SelectedValue)) // 角色 { strWhere.Append("( "); } strWhere.Append(" ( 1=1 "); if (!string.IsNullOrEmpty(this.txtLoginName.Text.Trim())) { //strWhere.Append(string.Format(" And AUser.Ur_loginName like '%{0}%'",this.txtLoginName.Text.Trim())); strWhere.Append(" And AUser.Ur_loginName like @Cnname"); parm.Add(new MySqlParameter("@Cnname", "%" + this.txtLoginName.Text.Trim() + "%")); } if (!string.IsNullOrEmpty(this.txtName.Text.Trim())) { //strWhere.Append(string.Format(" And AUser.Ur_name like '%{0}%'", this.txtName.Text.Trim())); strWhere.Append(" And AUser.Ur_name like @Nnname"); parm.Add(new MySqlParameter("@Nnname", "%" + this.txtName.Text.Trim() + "%")); } if (!string.IsNullOrEmpty(this.ddlDepartment.SelectedValue)) { //strWhere.Append(string.Format(" And AUser.Ur_department = '{0}' ", ddlDepartment.SelectedValue)); strWhere.Append(" And AUser.Ur_department= @Snname"); parm.Add(new MySqlParameter("@Snname", ddlDepartment.SelectedValue)); } //strWhere.Append(string.Format(" And AUser.Ur_state = '{0}'", this.rblState.SelectedValue));//0启用1停用2冻结 默认0 strWhere.Append(" And AUser.Ur_state = @RBnname"); parm.Add(new MySqlParameter("@RBnname", this.rblState.SelectedValue)); if (leave < 200) { strWhere.Append(" And cast(AUser.Ur_text1 as signed ) <= @Bnname"); parm.Add(new MySqlParameter("@Bnname", Convert.ToInt32(usersEO.UrText1))); //strWhere.Append(string.Format(" And cast(AUser.Ur_text1 as int ) <= {0} ", Convert.ToInt32(usersEO.UrText1))); } if (leave < 90) // 根据用户账号管理权限显示归属内的账号 { //strWhere.Append(" And AUser.Ur_text2 like '%" + usersEO.UrId + ";%' "); strWhere.Append(" And AUser.Ur_text2 like @URnname"); parm.Add(new MySqlParameter("@URnname", usersEO.UrId)); } strWhere.Append(" And AUser.Ur_del = 0 ) "); if (leave >= 80) // 显示自己的账号 { //strWhere.Append(" or AUser.Ur_id = '" + usersEO.UrId + "' "); strWhere.Append(" or AUser.Ur_id = @URID"); parm.Add(new MySqlParameter("@URID", usersEO.UrId)); } if (!string.IsNullOrEmpty(this.ddlRoleName.SelectedValue)) // 角色 { //strWhere.Append(" ) " + " and ARole.Rl_id = '" + this.ddlRoleName.SelectedValue + "' and cast(AUser.Ur_text1 as int ) <= 90 "); strWhere.Append(" ) and 'ARole.Rl_id' = @RONAME and cast(AUser.Ur_text1 as signed ) <= 90"); parm.Add(new MySqlParameter("@RONAME", this.ddlRoleName.SelectedValue)); } DataView view = userManage.GetList(strWhere.ToString(), parm).DefaultView; string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"]; view.Sort = sort; this.gvUsers.DataSource = view; this.gvUsers.DataBind(); }
/// <summary> /// 添加、修改数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnOK_Click(object sender, EventArgs e) { if (Page.IsValid) { #region 验证表单合法性 if (this.CheckForms() == false) { CloseDivImplementation(); return; } #endregion //判断用户账号是否存在 if (this.CheckUserLoginName() == false) { ShowCommonDlg("账户名已存在!"); CloseDivImplementation(); return; } #region 初始化数据 UsersEO usersEO = new UsersEO(); RoleuserEO rluEO = new RoleuserEO(); //if (Request.QueryString["State"] == "U") //{ // usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]); // if (cbk_password.Checked) // { // } //} usersEO.UrPass = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密 usersEO.UrLoginName = this.txtLoginName.Text.Trim(); usersEO.UrName = this.txtName.Text.Trim(); usersEO.UrParent = this.txtParent.Text.Trim(); usersEO.UrPhone = "";//this.txtPhone.Text.Trim(); usersEO.UrZone = this.txtZone.Text.Trim(); usersEO.UrPeople = this.txtContactPeople.Text.Trim(); usersEO.UrContact = this.txtContact.Text.Trim(); usersEO.UrGameId = this.txtGameId.Text.Trim(); usersEO.UrDiamondNum = "0"; usersEO.UrBankName = ""; //this.txtBankName.Text.Trim(); usersEO.UrBank = ""; //this.txtBank.Text.Trim(); usersEO.UrPercent = "0"; usersEO.UrBankNo = ""; //this.txtBankNo.Text.Trim(); usersEO.UrIntroducer = ""; //this.txtIntrdouce.Text.Trim(); usersEO.UrRolestate = "3"; usersEO.UrDepartment = "3"; usersEO.UrState = "0"; usersEO.UrLockBindIp = ""; usersEO.UrText1 = "0"; // 用户级别 #endregion #region 创建用户 //if (Request.QueryString["State"] == "A") { //用户信息 usersEO.UrId = GetBigGuid(); usersEO.UrPass = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密 usersEO.UrDel = "0"; usersEO.UrAddUser = GetUserID(); usersEO.UrAddTime = DateTime.Now; usersEO.UrLockTime = DateTime.Now; //用户角色信息 //for (int i = 0; i < this.cblRoles.Items.Count; i++) { //if (this.cblRoles.Items[i].Selected) { rluEO.UrId = usersEO.UrId; rluEO.RlId = "0468a29f20160413170700";//this.cblRoles.Items[i].Value; rluEO.RuAddUser = GetUserID(); rluEO.RuAddTime = DateTime.Now; rluManage.AddRoleUser(rluEO); } } if (userManage.AddUser(usersEO) > 0) { //插入操作日志 InsertLog(Resources.Resource.Create_user, string.Format("username:{0},id:{1}", usersEO.UrName, usersEO.UrId), 4, GetPlatformIdByValue(1)); CloseDivImplementation(); Jswork.Alert("代理信息创建成功!", "UsersAgentList.aspx"); //ShowCommonDlg("代理信息创建成功!"); } else { //Jswork.Alert("用户信息创建失败", this.Page); //this.divAlert.Visible = true; //this.lblAlert.Text = Resources.Resource.User_information_creation_failed;//"用户信息创建失败"; ShowCommonDlg("代理信息创建失败!"); } } #endregion CloseDivImplementation(); } }
/// <summary> /// 修改用户 /// </summary> /// <param name="item"></param> /// <returns></returns> public int EditUser(UsersEO item) { return(usersMO.UpdateUser(item)); }
/// <summary> /// 创建用户 /// </summary> /// <param name="item"></param> /// <returns></returns> public int AddUser(UsersEO item) { return(usersMO.Add(item)); }