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 }); }