/// <summary> /// 获取用户所能查看的易诺用户池客户类型 /// </summary> /// <param name="model">系统用户实体</param> private EyouSoft.Model.SystemStructure.SystemUser GetSysUserCustomerTypeIds(EyouSoft.Model.SystemStructure.SystemUser model) { if (model == null || model.ID <= 0) { return(model); } IList <int> CustomerTypeIds = new List <int>(); string strSql = " SELECT [CustomerId] FROM [tbl_UserCustomerType] where UserId = @ID; "; DbCommand dc = base.PoolStore.GetSqlStringCommand(strSql); base.PoolStore.AddInParameter(dc, "ID", DbType.Int32, model.ID); using (IDataReader dr = DbHelper.ExecuteReader(dc, base.PoolStore)) { while (dr.Read()) { if (!dr.IsDBNull(0)) { CustomerTypeIds.Add(dr.GetInt32(0)); } } } model.CustomerTypeIds = CustomerTypeIds; return(model); }
protected void LoadUserInfo(int userId) { EyouSoft.Model.SystemStructure.SystemUser userModel = userBll.GetSystemUserModel(userId); us_txtFax.Value = userModel.ContactFax; us_txtMoible.Value = userModel.ContactMobile; us_txtRealName.Value = userModel.ContactName; us_txtTel.Value = userModel.ContactTel; us_txtUserName1.Value = userModel.UserName; us_txtUserName1.Attributes.Add("readonly", "readonly"); userPermitList = userModel.PermissionList;//账户权限 userTypes = userModel.CustomerTypeIds; //获取账户负责区域列表 EyouSoft.IBLL.SystemStructure.ISysCity cityBll = EyouSoft.BLL.SystemStructure.SysCity.CreateInstance(); StringBuilder areaBuilder = new StringBuilder(); if (userModel.AreaId != null) { foreach (int areaId in userModel.AreaId) { EyouSoft.Model.SystemStructure.SysCity cityModel = cityBll.GetSysCityModel(areaId); areaBuilder.Append(string.Format("<input type='checkbox' checked='checked' id='ckSale_{0}' name='ckSellCity' value='{0}' /><label for='ckSale_{0}'>{1}</label>", areaId.ToString(), cityModel != null ? cityModel.CityName : "暂无")); } } areaHTML = areaBuilder.ToString(); //绑定类别 }
/// <summary> /// 新增系统管理员用户 /// </summary> /// <param name="model">系统用户实体</param> /// <returns>返回新加用户的ID</returns> public virtual int AddSystemUser(EyouSoft.Model.SystemStructure.SystemUser model) { if (model == null) { return(0); } DbCommand dc = base.SystemStore.GetSqlStringCommand(Sql_SystemUser_Add); #region 参数赋值 base.SystemStore.AddInParameter(dc, "UserName", DbType.String, model.UserName); base.SystemStore.AddInParameter(dc, "PassWord", DbType.String, model.PassWordInfo.NoEncryptPassword); base.SystemStore.AddInParameter(dc, "MD5Password", DbType.String, model.PassWordInfo.MD5Password); base.SystemStore.AddInParameter(dc, "EncryptPassword", DbType.String, model.PassWordInfo.SHAPassword); base.SystemStore.AddInParameter(dc, "ContactName", DbType.String, model.ContactName); base.SystemStore.AddInParameter(dc, "ContactTel", DbType.String, model.ContactTel); base.SystemStore.AddInParameter(dc, "ContactFax", DbType.String, model.ContactFax); base.SystemStore.AddInParameter(dc, "ContactMobile", DbType.String, model.ContactMobile); base.SystemStore.AddInParameter(dc, "IsDisable", DbType.String, model.IsDisable ? "1" : "0"); base.SystemStore.AddInParameter(dc, "PermissionList", DbType.String, model.PermissionList); base.SystemStore.AddInParameter(dc, "IssueTime", DbType.DateTime, DateTime.Now); #endregion object obj = DbHelper.GetSingle(dc, base.SystemStore); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 根据用户ID获取用户信息 /// </summary> /// <param name="SystemUserId">用户ID</param> /// <returns>返回用户实体</returns> public virtual EyouSoft.Model.SystemStructure.SystemUser GetSystemUserModel(int SystemUserId) { Model.SystemStructure.SystemUser model = new EyouSoft.Model.SystemStructure.SystemUser(); string strWhere = Sql_SystemUser_Select + " where ID = @ID; "; strWhere += " select AreaId from tbl_SysUserAreaControl where UserId = @ID; "; DbCommand dc = base.SystemStore.GetSqlStringCommand(strWhere); base.SystemStore.AddInParameter(dc, "ID", DbType.Int32, SystemUserId); using (IDataReader dr = DbHelper.ExecuteReader(dc, base.SystemStore)) { if (dr.Read()) { if (!string.IsNullOrEmpty(dr[0].ToString())) { model.ID = int.Parse(dr[0].ToString()); } model.UserName = dr[1].ToString(); model.PassWordInfo.NoEncryptPassword = dr[2].ToString(); model.ContactName = dr[3].ToString(); model.ContactTel = dr[4].ToString(); model.ContactFax = dr[5].ToString(); model.ContactMobile = dr[6].ToString(); model.PermissionList = dr[7].ToString(); if (!string.IsNullOrEmpty(dr[8].ToString())) { if (dr[8].ToString() == "1") { model.IsDisable = true; } else { model.IsDisable = false; } } if (!string.IsNullOrEmpty(dr[9].ToString())) { model.IssueTime = DateTime.Parse(dr[9].ToString()); } } dr.NextResult(); IList <int> AreaIds = new List <int>(); while (dr.Read()) { if (!dr.IsDBNull(0)) { AreaIds.Add(dr.GetInt32(0)); } } model.AreaId = AreaIds; } return(GetSysUserCustomerTypeIds(model)); }
protected void Page_Load(object sender, EventArgs e) { string method = Utils.GetQueryStringValue("method"); userName = MasterUserInfo.UserName; if (!CheckMasterGrant(YuYingPermission.帐户管理_管理该栏目, YuYingPermission.帐户管理_修改密码)) { Utils.ResponseNoPermit(YuYingPermission.帐户管理_修改密码, true); return; } if (!CheckMasterGrant(YuYingPermission.帐户管理_管理该栏目, YuYingPermission.帐户管理_修改密码)) { haveUpdate = false; } if (method == "update") { if (!haveUpdate) { Utils.ResponseMeg(false, "对不起,你没有修改密码的权限!"); return; } string oldPass = Utils.GetQueryStringValue("oldpass"); string newPass1 = Utils.GetQueryStringValue("newpass1"); string newPass2 = Utils.GetQueryStringValue("newpass2"); if (oldPass == "" || newPass1 == "" || newPass2 == "") { Utils.ResponseMegNoComplete(); return; } if (newPass1 != newPass2) { Utils.ResponseMeg(false, "前后两次密码不匹配!"); return; } EyouSoft.IBLL.SystemStructure.ISystemUser userBll = EyouSoft.BLL.SystemStructure.SystemUser.CreateInstance(); EyouSoft.Model.SystemStructure.SystemUser userModel = userBll.GetSystemUserModel(MasterUserInfo.ID); if (userModel != null && userModel.PassWordInfo.NoEncryptPassword == oldPass) { if (userBll.UpdateUserPassWord(MasterUserInfo.ID, newPass1) > 0) { Utils.ResponseMeg(true, "密码已修改,请妥善保管!"); } else { Utils.ResponseMegError(); } } else { Utils.ResponseMeg(false, "原密码不正确!"); } } }
protected void AddUser() { EyouSoft.Model.SystemStructure.SystemUser userModel = new EyouSoft.Model.SystemStructure.SystemUser(); userModel.UserName = Utils.GetFormValue(us_txtUserName1.UniqueID, 16); string pass1 = Utils.GetFormValue(us_txtPass1.UniqueID); string pass2 = Utils.GetFormValue(us_txtPass2.UniqueID); userModel.PassWordInfo.NoEncryptPassword = pass1; userModel.ContactName = Utils.GetFormValue(us_txtRealName.UniqueID, 16); userModel.ContactTel = Utils.GetFormValue(us_txtTel.UniqueID); if (userModel.UserName == "" || pass1 == "" || pass2 == "" || userModel.ContactName == "" || userModel.ContactTel == "") { MessageBox.Show(this, "数据请填写完整!"); return; } if (pass1 != pass2) { MessageBox.Show(this, "两次密码不一致!"); return; } EyouSoft.IBLL.SystemStructure.ISystemUser sysUserBll = EyouSoft.BLL.SystemStructure.SystemUser.CreateInstance(); if (sysUserBll.ExistsByUserName(userModel.UserName)) { MessageBox.Show(this, "用户名已存在!"); return; } string areaIds = Utils.GetFormValue("ckSellCity"); userModel.ContactMobile = Utils.GetFormValue(us_txtMoible.UniqueID); userModel.ContactFax = Utils.GetFormValue(us_txtFax.UniqueID, 30); userModel.PermissionList = Utils.GetFormValue("chk_Permit"); if (areaIds != "") { userModel.AreaId = areaIds.Split(',').Select(i => Utils.GetInt(i)).ToList <int>(); } //获取绑定的用户类型 IList <int> custTypeList = Utils.GetFormValues("chkCustType").Select(i => int.Parse(i)).ToList(); userModel.CustomerTypeIds = custTypeList; if (EyouSoft.BLL.SystemStructure.SystemUser.CreateInstance().AddSystemUser(userModel) > 0) { MessageBox.ShowAndRedirect(this, "保存成功!", "UserListManage.aspx"); } else { MessageBox.Show(this, "保存失败!"); } }
/// <summary> /// 绑定列表的时候,根据ID编号获取审核人姓名 /// </summary> /// <param name="id"></param> /// <returns></returns> protected string GetSysUserName(int id) { string userName = MasterUserInfo.ContactName; if (id != 0) { EyouSoft.Model.SystemStructure.SystemUser userModel = userBll.GetSystemUserModel(id); if (userModel != null) { userName = userModel.ContactName; } } return(userName); }
protected void UpdateUser(int userId) { string userName = Utils.GetFormValue(us_txtUserName1.UniqueID, 16); string pass1 = Utils.GetFormValue(us_txtPass1.UniqueID); string pass2 = Utils.GetFormValue(us_txtPass2.UniqueID); string realName = Utils.GetFormValue(us_txtRealName.UniqueID, 16); string userTel = Utils.GetFormValue(us_txtTel.UniqueID); if (userName == "" || realName == "" || userTel == "") { MessageBox.Show(this, "数据请填写完整!"); return; } if (pass1 != pass2) { MessageBox.Show(this, "两次密码不一致!"); return; } EyouSoft.Model.SystemStructure.SystemUser userModel = userBll.GetSystemUserModel(userId); if (userModel != null) { string areaIds = Utils.GetFormValue("ckSellCity"); if (areaIds != "") { userModel.AreaId = areaIds.Split(',').Select(i => Utils.GetInt(i)).ToList <int>(); } userModel.UserName = userName; userModel.ContactFax = Utils.GetFormValue(us_txtFax.UniqueID, 30); userModel.ContactMobile = Utils.GetFormValue(us_txtMoible.UniqueID); userModel.ContactTel = userTel; userModel.ContactName = realName; userModel.PermissionList = Utils.GetFormValue("chk_Permit"); //获取绑定的用户类型 IList <int> custTypeList = Utils.GetFormValues("chkCustType").Select(i => int.Parse(i)).ToList(); userModel.CustomerTypeIds = custTypeList; if (pass1 != "") { userBll.UpdateUserPassWord(userModel.ID, pass1); } } if (userBll.UpdateSystemUser(userModel) > 0) { MessageBox.ShowAndRedirect(this, "保存成功!", "UserListManage.aspx"); } else { MessageBox.Show(this, "保存失败!"); } }
/// <summary> /// 修改系统用户 /// </summary> /// <param name="model">系统用户实体(区域ID集合为null或者count小于等于0不修改用户和区域的关系)</param> /// <returns>-3:新增管理员区域失败;-2:删除旧用户和区域关系失败;-1:新增用户失败;0:用户实体为空;1:Success</returns> public int UpdateSystemUser(EyouSoft.Model.SystemStructure.SystemUser model) { if (model == null) { return(0); } int Result = 0; using (TransactionScope AddTran = new TransactionScope()) { Result = dal.UpdateSystemUser(model); if (Result <= 0) { return(-1); } IList <int> Ids = new List <int>(); Ids.Add(model.ID); if (model.AreaId != null && model.AreaId.Count > 0) { Result = dal.DeleteSysUserAreaControl(Ids); Result = dal.AddSysUserAreaControl(model.ID, model.AreaId); if (Result <= 0) { return(-3); } } if (model.CustomerTypeIds != null && model.CustomerTypeIds.Count > 0) { Result = dal.DeleteSysUserCustomerType(Ids); Result = dal.AddSysUserCustomerType(model.ID, model.CustomerTypeIds); if (Result <= 0) { return(-4); } } Ids.Clear(); Ids = null; Result = 1; AddTran.Complete(); } return(Result); }
/// <summary> /// 修改用户信息(只修改联系人、电话、传真、手机、权限) /// </summary> /// <param name="model">用户实体</param> /// <returns>返回受影响行数</returns> public virtual int UpdateSystemUser(EyouSoft.Model.SystemStructure.SystemUser model) { if (model == null) { return(0); } DbCommand dc = base.SystemStore.GetSqlStringCommand(Sql_SystemUser_Update); base.SystemStore.AddInParameter(dc, "ContactName", DbType.String, model.ContactName); base.SystemStore.AddInParameter(dc, "ContactTel", DbType.String, model.ContactTel); base.SystemStore.AddInParameter(dc, "ContactFax", DbType.String, model.ContactFax); base.SystemStore.AddInParameter(dc, "ContactMobile", DbType.String, model.ContactMobile); base.SystemStore.AddInParameter(dc, "PermissionList", DbType.String, model.PermissionList); base.SystemStore.AddInParameter(dc, "ID", DbType.Int32, model.ID); return(DbHelper.ExecuteSql(dc, base.SystemStore)); }
/// <summary> /// 新增系统用户(管理员区域ID集合为null或者count小于等于0不添加) /// </summary> /// <param name="model">系统用户实体</param> /// <returns>-2:新增管理员区域失败;-1:新增用户失败;0:用户实体为空;1:Success</returns> public int AddSystemUser(EyouSoft.Model.SystemStructure.SystemUser model) { if (model == null) { return(0); } //设置所有的密码 model.PassWordInfo = EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance().InitPassWordModel(model.PassWordInfo.NoEncryptPassword); int Result = 0; using (TransactionScope AddTran = new TransactionScope()) { Result = dal.AddSystemUser(model); model.ID = Result; if (Result <= 0) { return(-1); } if (model.AreaId != null && model.AreaId.Count > 0) { Result = dal.AddSysUserAreaControl(Result, model.AreaId); if (Result <= 0) { return(-2); } } if (model.CustomerTypeIds != null && model.CustomerTypeIds.Count > 0) { Result = dal.AddSysUserCustomerType(model.ID, model.CustomerTypeIds); if (Result <= 0) { return(-3); } } Result = 1; AddTran.Complete(); } return(Result); }
/// <summary> /// 验证用户是否存在(存在返回该用户实体,不存在返回null) /// </summary> /// <param name="UserName">用户名</param> /// <param name="PassWord">密码</param> /// <returns>存在返回该用户实体,不存在返回null</returns> public virtual Model.SystemStructure.SystemUser ExistsByUserName(string UserName, string PassWord) { if (string.IsNullOrEmpty(UserName) || string.IsNullOrEmpty(PassWord)) { return(null); } Model.SystemStructure.SystemUser model = new EyouSoft.Model.SystemStructure.SystemUser(); string strWhere = Sql_SystemUser_Select + " where [UserName] = @UserName and [PassWord] = @PassWord; "; strWhere += " select [AreaId] from [tbl_SysUserAreaControl] where [UserId] = (select top 1 ID from [tbl_SystemUser] where [UserName] = @UserName and [PassWord] = @PassWord) order by [AreaId] asc ; "; DbCommand dc = base.SystemStore.GetSqlStringCommand(strWhere); base.SystemStore.AddInParameter(dc, "UserName", DbType.String, UserName); base.SystemStore.AddInParameter(dc, "PassWord", DbType.String, PassWord); using (IDataReader dr = DbHelper.ExecuteReader(dc, base.SystemStore)) { while (dr.Read()) { if (!string.IsNullOrEmpty(dr[0].ToString())) { model.ID = int.Parse(dr[0].ToString()); } model.UserName = dr[1].ToString(); model.PassWordInfo.NoEncryptPassword = dr[2].ToString(); model.ContactName = dr[3].ToString(); model.ContactTel = dr[4].ToString(); model.ContactFax = dr[5].ToString(); model.ContactMobile = dr[6].ToString(); model.PermissionList = dr[7].ToString(); if (!string.IsNullOrEmpty(dr[8].ToString())) { if (dr[8].ToString() == "1") { model.IsDisable = true; } else { model.IsDisable = false; } } if (!string.IsNullOrEmpty(dr[9].ToString())) { model.IssueTime = DateTime.Parse(dr[9].ToString()); } break; } dr.NextResult(); while (dr.Read()) { if (!dr.IsDBNull(0)) { model.AreaId.Add(dr.GetInt32(0)); } } } return(model); }
/// <summary> /// 获取系统用户列表 /// </summary> /// <param name="PageSize">每页记录数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">总记录数</param> /// <param name="OrderIndex">排序索引,0添加时间升序,1添加时间降序</param> /// <param name="AreaId">线路区域ID</param> /// <param name="UserName">用户名(模糊查询)</param> /// <param name="ContactName">联系人(模糊查询)</param> /// <returns>系统用户实体集合</returns> public virtual IList <EyouSoft.Model.SystemStructure.SystemUser> GetSystemUserList(int PageSize, int PageIndex, ref int RecordCount, int OrderIndex, int AreaId, string UserName, string ContactName) { IList <EyouSoft.Model.SystemStructure.SystemUser> list = new List <EyouSoft.Model.SystemStructure.SystemUser>(); bool IsWhere = false; string strWhere = string.Empty; string strFiles = " [ID],[UserName],[PassWord],[ContactName],[ContactTel],[ContactFax],[ContactMobile],[PermissionList],[IsDisable],[IssueTime] "; string strOrder = string.Empty; if (AreaId > 0) { strWhere += string.Format(" ID in (select distinct [UserId] from [tbl_SysUserAreaControl] where [AreaId] = {0}) ", AreaId); IsWhere = true; } if (!string.IsNullOrEmpty(UserName)) { if (IsWhere) { strWhere += " and "; } strWhere += string.Format(" [UserName] like '%{0}%' ", UserName.Replace("'", "")); IsWhere = true; } if (!string.IsNullOrEmpty(ContactName)) { if (IsWhere) { strWhere += " and "; } strWhere += string.Format(" [ContactName] like '%{0}%' ", ContactName.Replace("'", "")); IsWhere = true; } switch (OrderIndex) { case 0: strOrder = " [IssueTime] asc "; break; case 1: strOrder = " [IssueTime] desc "; break; default: strOrder = " [IssueTime] desc "; break; } using (IDataReader dr = DbHelper.ExecuteReader(base.SystemStore, PageSize, PageIndex, ref RecordCount, "tbl_SystemUser", "[ID]", strFiles, strWhere, strOrder)) { Model.SystemStructure.SystemUser model = null; while (dr.Read()) { model = new EyouSoft.Model.SystemStructure.SystemUser(); if (!string.IsNullOrEmpty(dr[0].ToString())) { model.ID = int.Parse(dr[0].ToString()); } model.UserName = dr[1].ToString(); model.PassWordInfo.NoEncryptPassword = dr[2].ToString(); model.ContactName = dr[3].ToString(); model.ContactTel = dr[4].ToString(); model.ContactFax = dr[5].ToString(); model.ContactMobile = dr[6].ToString(); model.PermissionList = dr[7].ToString(); if (!string.IsNullOrEmpty(dr[8].ToString())) { if (dr[8].ToString() == "1") { model.IsDisable = true; } else { model.IsDisable = false; } } if (!string.IsNullOrEmpty(dr[9].ToString())) { model.IssueTime = DateTime.Parse(dr[9].ToString()); } list.Add(model); } model = null; } return(list); }