public ActionResult ModifyPassword(UserModifyPasswordModel model)
{
if (ModelState.IsValid)
{
model.ID = base.CurrentUserID;
var result = UserBLL.ModifyPassword(model);
if (result.Success)//修改成功需要重定向到注销页面
{
result.Url = Url.Content("~/Account/Logout");
}
return(Json(result));
}
else
{
return(PartialView("_ModifyPassword", model));
}
}
/// <summary>
/// 修改密码
/// </summary>
public static OperationResult ModifyPassword(UserModifyPasswordModel model)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@originalPwd", SqlDbType.Char, 32),
new SqlParameter("@newPwd", SqlDbType.Char, 32),
};
paras[0].Value = model.ID;
paras[1].Value = MD5Helper.GetMD5Str(model.OriginalPassword);
paras[2].Value = MD5Helper.GetMD5Str(model.NewPassword);
#region SQL
string sql = @"UPDATE dbo.Users SET UserPassword=@newPwd WHERE ID=@ID AND UserPassword=@originalPwd";
#endregion
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}