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("原始密码错误。");
}
}
