public bool CheckLoginName(string loginName) { sql = string.Format("select * from OAuth.UserInfo where LoginName='{0}'", loginName); var b = new MySqlHelper().FindToList <UserInfo>(sql); return(b.Any()); }
public bool CheckPhoneNumber(string phoneNumber) { sql = string.Format("select * from OAuth.UserInfo where PhoneNumber='{0}'", phoneNumber); var b = new MySqlHelper().FindToList <UserInfo>(sql); return(b.Any()); }
public string UpdatePassWord(string newPwd, string oldPwd, int userId) { sql = "select * from oauth.UserPassword where UserID=@UserID and Password=@Password ;"; var param = new DynamicParameters(); param.Add("@UserID", userId, DbType.Int32); param.Add("@Password", oldPwd.GetMD5(), DbType.String); var b = new MySqlHelper().FindToList <UserPassword>(sql, param); if (b.Any()) { sql = " update oauth.UserPassword set Password=@Password where UserID=@UserID;"; param = new DynamicParameters(); param.Add("@UserID", userId, DbType.Int32); param.Add("@Password", newPwd.GetMD5(), DbType.String); var flag = new MySqlHelper().ExcuteNonQuery(sql, param); return(flag > 0 ? "更新成功。" : "更新失败。"); } else { return("原始密码错误。"); } }