/// <summary> /// 更新数据 /// </summary> /// <param name = "item">要更新的实体对象</param> /// <param name="tm">事务管理对象</param> /// <return>受影响的行数</return> public virtual int UpdateUser(OrganizeEO item, TransactionManager tm = null) { const string sql = @"UPDATE organize SET Ur_Name=@Ur_Name, Ur_UserName=@Ur_UserName, Ur_PassWord=@Ur_PassWord, Ur_zone=@Ur_zone, Ur_people=@Ur_people, Ur_Contact=@Ur_Contact, Ur_percent=@Ur_percent, Ur_bankName=@Ur_bankName,Ur_bank=@Ur_bank,Ur_bankNo=@Ur_bankNo,Ur_introducer=@Ur_introducer,Ur_errorlogin=@Ur_errorlogin, Ur_lockTime=@Ur_lockTime, Ur_lockBindIp=@Ur_lockBindIp, Ur_text1=@Ur_text1, Ur_text2=@Ur_text2 WHERE Ur_id=@Ur_id"; return(Database.CreateSqlDao(sql) .AddInParameter("@Ur_Name", item.UrName != null ? (object)item.UrName : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_UserName", item.UrUserName != null ? (object)item.UrUserName : DBNull.Value, DbType.String, 100) .AddInParameter("@Ur_PassWord", item.UrPassWord != null ? (object)item.UrPassWord : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_zone", item.UrZone != null ? (object)item.UrZone : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_people", item.UrPeople != null ? (object)item.UrPeople : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_Contact", item.UrContact != null ? (object)item.UrContact : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_percent", item.UrPercent != null ? (object)item.UrPercent : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_bankName", item.UrBankName != null ? (object)item.UrBankName : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_bank", item.UrBank != null ? (object)item.UrBank : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_bankNo", item.UrBankNo != null ? (object)item.UrBankNo : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_introducer", item.UrIntroducer != null ? (object)item.UrIntroducer : DBNull.Value, DbType.String, 50) .AddInParameter("@Ur_addTime", item.UrAddTime, DbType.DateTime, 8) .AddInParameter("@Ur_state", item.UrState, DbType.AnsiStringFixedLength, 1) .AddInParameter("@Ur_del", item.UrDel, DbType.AnsiStringFixedLength, 1) .AddInParameter("@Ur_errorlogin", item.UrErrorlogin != null ? (object)item.UrErrorlogin : DBNull.Value, DbType.String, 100) .AddInParameter("@Ur_lockTime", item.UrLockTime, DbType.DateTime, 8) .AddInParameter("@Ur_lockBindIp", item.UrLockBindIp != null ? (object)item.UrLockBindIp : DBNull.Value, DbType.String, 500) .AddInParameter("@Ur_text1", item.UrText1 != null ? (object)item.UrText1 : DBNull.Value, DbType.String, 100) .AddInParameter("@Ur_text2", item.UrText2 != null ? (object)item.UrText2 : DBNull.Value, DbType.String, 100) .AddInParameter("@Ur_id", item.UrId, DbType.String, 50) .ExecNonQuery(tm)); //return 0; }
/// <summary> /// 加载用户角色信息 /// </summary> private void LoadRoleUser() { IList <MySqlParameter> parm = new List <MySqlParameter>(); StringBuilder strWhere = new StringBuilder(); strWhere.Append(" Ur_id= @Rl_name "); parm.Add(new MySqlParameter("@Rl_name", Request.QueryString["Urid"])); DataTable dt = rluManage.GetTable(strWhere.ToString(), parm); OrganizeEO userEO = userManage.GetUser(Request.QueryString["Urid"]); try { ddlUserLeave.SelectedValue = userEO.UrText1; } catch { } if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < this.cblRoles.Items.Count; i++) { for (int j = 0; j < dt.Rows.Count; j++) { if (this.cblRoles.Items[i].Value == dt.Rows[j]["Rl_id"].ToString()) { this.cblRoles.Items[i].Selected = true; } } } } SetRoleListColor(); }
/// <summary> /// 加载角色信息 /// </summary> private void LoadRoles() { OrganizeEO userEO = GetOrgnizeUser(); int leave = GetUserLeave(); // 获取用户等级 // 根据级别绑定用户可选的级别信息 BindddlUserLeave(leave); // 判断开发管理员以上的用户可以对任何用户进行编辑 if (leave >= 90) { this.cblRoles.DataSource = rlManage.Get(" Rl_del = 0", null); } else { IList <MySqlParameter> parm = new List <MySqlParameter>(); StringBuilder strWhere = new StringBuilder(); strWhere.Append(" Rl_id in ( select Rl_id from roleuser where Ur_id =@Ur_id ) and Rl_del = 0 and Rl_name <> @UserEditName "); parm.Add(new MySqlParameter("@Ur_id", GetUserID())); parm.Add(new MySqlParameter("@UserEditName", ConfigurationManager.AppSettings["UserEditName"].ToString())); this.cblRoles.DataSource = rlManage.Get(strWhere.ToString(), parm); //this.cblRoles.DataSource = rlManage.Get(" Rl_id in ( select Rl_id from roleuser where Ur_id = '" + GetUserID() + "') and Rl_del = 0 and Rl_name <> '" + ConfigurationManager.AppSettings["UserEditName"].ToString() + "' "); // 根据用户级别判断该用户是否有用户账号管理的权限 cbAccountManagement.Enabled = false; cbAccountManagement.SelectedValue = userEO.UrId; } this.cblRoles.DataTextField = "Rlname"; this.cblRoles.DataValueField = "RlId"; this.cblRoles.DataBind(); if (this.cblRoles.Items.Count == 0) { this.lkRoleEdit.Visible = true; } }
/// <summary> /// 获取机构用户基本信息 /// </summary> /// <returns></returns> public OrganizeEO GetOrgnizeUser() { OrganizeEO usersEO = new OrganizeEO(); if (GetUserID() != "") { usersEO = organizeManage.GetUser(GetUserID()); } return(usersEO); }
/// <summary> /// 加载 /// </summary> private void Loads() { OrganizeEO usersEO = new OrganizeEO(); usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]); if (!string.IsNullOrEmpty(usersEO.UrId)) { this.lblUser.Text = usersEO.UrUserName;//显示用户账号 } }
/// <summary> /// 根据用户名和密码查询用户信息 /// </summary> /// <param name="username">用户名</param> /// <param name="password">密码</param> /// <returns></returns> public OrganizeEO GetUser(string username, string password) { OrganizeEO UsersEO = new OrganizeEO(); foreach (OrganizeEO tsersEOs in usersMO.Get(" Ur_loginName = @Ur_loginName and Ur_pass = @Ur_pass and Ur_del = 0 ", username, password)) { UsersEO = tsersEOs; break; } return(UsersEO); }
/// <summary> /// 加载用户信息 /// </summary> private void LoadUsers() { OrganizeEO usersEO = new OrganizeEO(); int leave = GetUserLeave(); // 获取用户级别 usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]); if (!string.IsNullOrEmpty(usersEO.UrId)) { this.txtOrganizeNo.Text = usersEO.UrNo; this.txtOrganizeName.Text = usersEO.UrName; this.txtLoginName.Text = usersEO.UrUserName; this.hfLoginName.Value = usersEO.UrUserName; this.txtZone.Text = usersEO.UrZone; this.txtPeople.Text = usersEO.UrPeople; this.txtContact.Text = usersEO.UrContact; this.txtBack.Text = usersEO.UrBank; this.txtBackName.Text = usersEO.UrBankName; this.txtBackNo.Text = usersEO.UrBankNo; this.txtPercent.Text = usersEO.UrPercent; this.txtIntroducer.Text = usersEO.UrIntroducer; this.txtUserIps.Text = usersEO.UrLockBindIp; this.rblState.SelectedValue = usersEO.UrState; this.ddlUserLeave.Text = usersEO.UrText1; // 用户级别 } this.trPass.Visible = false; if (leave >= 90) { this.cbk_password.Visible = true; } // 加载用户账号归属 if (usersEO.UrText2 != null) { foreach (string AccountManagementmessage in usersEO.UrText2.Split(';')) { if (AccountManagementmessage != "") { for (int i = 0; i < this.cbAccountManagement.Items.Count; i++) { if (this.cbAccountManagement.Items[i].Value == AccountManagementmessage) { this.cbAccountManagement.Items[i].Selected = true; } } } } } }
/// <summary> /// 修改用户 /// </summary> /// <param name="item"></param> /// <returns></returns> public int EditUser(OrganizeEO item) { return(usersMO.UpdateUser(item)); }
/// <summary> /// 创建用户 /// </summary> /// <param name="item"></param> /// <returns></returns> public int AddUser(OrganizeEO item) { return(usersMO.Add(item)); }
/// <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 初始化数据 OrganizeEO usersEO = new OrganizeEO(); RoleuserEO rluEO = new RoleuserEO(); if (Request.QueryString["State"] == "U") { usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]); if (cbk_password.Checked) { usersEO.UrPassWord = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密 } } usersEO.UrNo = this.txtOrganizeNo.Text.Trim(); usersEO.UrName = this.txtOrganizeName.Text.Trim(); usersEO.UrUserName = this.txtLoginName.Text.Trim(); //usersEO.UrDepartment = this.ddlDepartment.SelectedValue; usersEO.UrZone = this.txtZone.Text.Trim(); usersEO.UrPeople = this.txtPeople.Text.Trim(); usersEO.UrContact = this.txtContact.Text.Trim(); usersEO.UrBank = this.txtBack.Text.Trim(); usersEO.UrBankName = this.txtBackName.Text.Trim(); usersEO.UrBankNo = this.txtBackNo.Text.Trim(); usersEO.UrPercent = this.txtPercent.Text.Trim(); usersEO.UrIntroducer = this.txtIntroducer.Text.Trim(); 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.UrPassWord = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密 usersEO.UrDel = "0"; usersEO.UrIntroducer = 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, "OrganizersList.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, "OrganizersList.aspx"); } else { //Jswork.Alert("用户信息修改失败", this.Page); this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.User_information_modification_failed;//"用户信息修改失败"; } } #endregion CloseDivImplementation(); } }