public async Task <JsonResult <dynamic> > ModifyPassword(MemberMidifyPassword model) { //if (!ModelState.IsValid) //{ // return new JsonResult<dynamic> // { // status = false, // Message = ModelState.FirstModelStateError() // }; //} bool isTrue = await _memberService.IsTrueOldPassword(model); if (!isTrue) { return new JsonResult <dynamic> { status = false, Message = "原密码错误" } } ; bool flag = await _memberService.ModifyPassword(model); return(new JsonResult <dynamic> { status = flag, Message = flag ? "修改成功" : "修改失败" }); }
/// <summary> /// 判断原密码是否正确 /// </summary> /// <param name="account"></param> /// <returns></returns> public async Task <bool> IsTrueOldPassword(MemberMidifyPassword model) { string sql = "select count(*) from Members where MemberID = @MemberID and Password=@Password"; int result = await DbHelper.QuerySingleAsync <int>(sql, new { MemberID = model.MemberID, Password = model.HashOldPassword }); return(result > 0); }
/// <summary> /// 修改密码 /// </summary> /// <param name="account"></param> /// <returns></returns> public async Task <bool> ModifyPassword(MemberMidifyPassword model) { string sql = "update Members set Password = @Password where MemberID = @MemberID"; DbParameter[] parameters = new DbParameter[] { new SqlParameter("@MemberID", model.MemberID), new SqlParameter("@Password", model.HashNewPassword) }; int result = await DbHelper.ExecuteSqlCommandAsync(sql, parameters); return(result > 0); }