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
}
