/// <summary>
/// 忘记密码
/// </summary>
/// <param name="username">用户名</param>
/// <param name="password">密码</param>
/// <param name="smscode">短信验证码</param>
/// <returns>返回结果</returns>
public virtual UserResponseModel <string> ForgetPassword(string username, string password, string smscode)
{
////判断验证码
if (!(UserCache.Contains(username) && UserCache.GetValue(username) == smscode))
{
return new UserResponseModel <string> {
Code = Code.ValCodeError, Msg = "验证码错误"
}
}
;
var result = DbHelper.QuerySql <List <Dictionary <string, object> > >($"SELECT * FROM `user` WHERE account_name='{username}'");
if (result == null)
{
return new UserResponseModel <string> {
Code = Code.AccountExsit, Msg = "帐号不存在"
}
}
;
var userid = Guid.NewGuid();
var resultInt = DbHelper.ExcuteSql($"UPDATE `user` SET passwrod='{password.Replace("'", "''")}' WHERE account_name='{username.Replace("'", "''")}'; ");
if (resultInt > 0)
{
UserCache.RefreshCache();
return(new UserResponseModel <string> {
Code = Code.Sucess, Msg = "更改成功"
});
}
return(new UserResponseModel <string> {
Code = Code.SystemException, Msg = "更改失败"
});
}
/// <summary>
/// 注册
/// </summary>
/// <param name="username">用户名</param>
/// <param name="password">密码</param>
/// <param name="smscode">短信验证码</param>
/// <param name="realname">真实姓名</param>
/// <returns>返回注册结果</returns>
public virtual UserResponseModel <string> Register(string username, string password, string smscode, string realname)
{
////判断验证码
if (!(UserCache.Contains(username) && UserCache.GetValue(username) == smscode))
{
return new UserResponseModel <string> {
Code = Code.ValCodeError, Msg = "验证码错误"
}
}
;
var result = DbHelper.QuerySql <List <Dictionary <string, object> > >($"SELECT * FROM `user` WHERE account_name='{username}'");
if (result != null && result.Any())
{
return new UserResponseModel <string> {
Code = Code.AccountExsit, Msg = "帐号已存在"
}
}
;
var userid = Guid.NewGuid();
var resultInt = DbHelper.ExcuteSql($"INSERT INTO `user` (id,account_name,passwrod,account_type,realname) VALUES ('{userid}','{username}','{password}','手机','{realname}')");
if (resultInt > 0)
{
UserCache.RefreshCache();
return(new UserResponseModel <string> {
Code = Code.Sucess, Msg = "注册成功"
});
}
return(new UserResponseModel <string> {
Code = Code.SystemException, Msg = "注册失败"
});
}
