public bool UpdatePassword(string logName, string passWord) { var szPassword = CommonLib.HashEncrypt.BgPassWord(HashEncrypt.md5(passWord)); string sql = string.Format("UPDATE Users SET Password='******',OperateDate=getdate() where UserName in ({1})", szPassword, logName); return(DbHelperSql.ExecuteNonQuery(sql) > 0); }
public bool ResetPassword(string[] ids) { if (ids == null || ids.Length <= 0) { return(false); } var szPassword = CommonLib.HashEncrypt.BgPassWord(HashEncrypt.md5(Config.SystemInitPassword)); var buf = new System.Text.StringBuilder(); foreach (var s in ids) { buf.AppendFormat("'{0}',", s); } string szIds = buf.ToString().TrimEnd(','); string sql = string.Format("UPDATE Users SET Password='******',OperateDate=getdate() where UserID in ({1})", szPassword, szIds); return(DbHelperSql.ExecuteNonQuery(sql) > 0); }
public JsonResult AddOrUpdate() { #region 权限控制 int[] iRangePage = { AddPageNodeId, EditPageNodeId, DetailPageNodeId }; int iCurrentPageNodeId = RequestParameters.Pint("NodeId"); bool isAdd = iCurrentPageNodeId == AddPageNodeId ? true : false; int iCurrentButtonId = (int)EButtonType.Save; var tempNoAuth = Utits.IsOperateAuth(iRangePage, iCurrentPageNodeId, iCurrentButtonId); if (tempNoAuth.ErrorType != 1) { return(Json(tempNoAuth)); } #endregion #region AddOrUpdate var welfareCentreId = Utits.WelfareCentreID; string UserCode = RequestParameters.Pstring("UserCode"); string UserName = RequestParameters.Pstring("UserName"); string RealName = RequestParameters.Pstring("RealName"); string Password = RequestParameters.Pstring("Password"); Guid DeptId = RequestParameters.PGuid("DeptId"); Guid RoleId = RequestParameters.PGuid("RoleId"); int UserType = RequestParameters.Pint("UserType"); string Remark = RequestParameters.Pstring("Remark"); string IcCardNO = RequestParameters.Pstring("IcCardNO"); if (UserName.Length <= 0) { var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 0; sRetrunModel.MessageContent = "用户名不能为空."; return(Json(sRetrunModel)); } var cBll = new UsersBll(); Guid ID = RequestParameters.PGuid("ID"); bool isFlagValidation = false; if (ID == Guid.Empty) { isFlagValidation = cBll.ValidationUserName(UserName, welfareCentreId); } else { isFlagValidation = cBll.ValidationUserName(ID, UserName, welfareCentreId); } if (!isFlagValidation) { var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 0; sRetrunModel.MessageContent = "用户名已存在."; return(Json(sRetrunModel)); } if (RealName.Length <= 0) { var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 0; sRetrunModel.MessageContent = "真实姓名不能为空."; return(Json(sRetrunModel)); } if (DeptId == Guid.Empty) { var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 0; sRetrunModel.MessageContent = "部门参数错误,请返回列表页面重新操作."; return(Json(sRetrunModel)); } if (RoleId == Guid.Empty) { var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 0; sRetrunModel.MessageContent = "角色参数错误,请返回列表页面重新操作."; return(Json(sRetrunModel)); } var item = new Users(); if (ID == Guid.Empty) { item.UserID = Guid.NewGuid(); item.CreateDate = DateTime.Now; item.IsValid = 1; if (Password.Length <= 0) { Password = HashEncrypt.md5(CommonLib.Config.SystemInitPassword); } item.Password = CommonLib.HashEncrypt.BgPassWord(Password); } else { item.UserID = ID; if (Password.Length > 0) { item.Password = CommonLib.HashEncrypt.BgPassWord(Password); } } item.WelfareCentreID = welfareCentreId; item.OperateDate = DateTime.Now; item.UserCode = UserCode; item.UserName = UserName; item.RealName = RealName; item.DeptID = DeptId; item.RoleID = RoleId; item.Remark = Remark; item.UserType = UserType; item.IcCardNo = IcCardNO; ParamState = "1"; ParamID = item.UserID.ToString(); bool IsFlag = cBll.AddOrUpdate(item); if (IsFlag) { var cLog = new LogsBll(); cLog.Log(ParamID, ParamName, ParamState, Utits.CurrentUserID.ToString(), Utits.CurrentRealName.ToString(), Utits.WelfareCentreID.ToString(), Utits.ClientIPAddress.ToString()); var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 1; sRetrunModel.MessageContent = "操作成功."; return(Json(sRetrunModel)); } else { var sRetrunModel = new ResultMessage(); sRetrunModel.ErrorType = 0; sRetrunModel.MessageContent = "操作失败."; return(Json(sRetrunModel)); } #endregion }