/// <summary>
/// 管理员注册
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static async Task <bool> ManagerRegisterAsync(T_ActivityManagerUserInfo_xhrModel request)
{
string sql = @"
INSERT INTO Activity.dbo.T_ActivityManagerUserInfo_xhr
(
[Name],
[PassWordsSalt],
[PassWords],
[CreateTime],
[CreateUser],
[ManagerStatus]
)
VALUES
( @Name,
@PassWordsSalt,
@PassWords,
GETDATE(),
'xhr',
1
);";
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Name", request.Name);
cmd.Parameters.AddWithValue("@PassWordsSalt", request.PassWordsSalt);
cmd.Parameters.AddWithValue("@PassWords", request.PassWords);
return((await DbHelper.ExecuteNonQueryAsync(cmd)) > 0);
}
}
/// <summary>
/// 获取密码盐
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static string GetPassWordsSalt(T_ActivityManagerUserInfo_xhrModel request)
{
try
{
return(DalActivity.GetPassWordsSalt(request));
}
catch (Exception ex)
{
Logger.Error($"GetPassWordsSalt", ex);
throw ex;
}
}
/// <summary>
/// 管理员注册
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static async Task <bool> ManagerRegisterAsync(T_ActivityManagerUserInfo_xhrModel request)
{
try
{
return(await DalActivity.ManagerRegisterAsync(request));
}
catch (Exception ex)
{
Logger.Error($"ManagerRegister", ex);
throw ex;
}
}
/// <summary>
/// 获取密码盐
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static string GetPassWordsSalt(T_ActivityManagerUserInfo_xhrModel request)
{
var sql = @"SELECT TOP 1 PassWordsSalt
FROM Activity.[dbo].[T_ActivityManagerUserInfo_xhr] WITH(NOLOCK)
WHERE [Name]=@Name AND ManagerStatus=1;";
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Name", request.Name);
var salt = DbHelper.ExecuteScalar(true, cmd);
var result = (salt == null?"": salt).ToString();
return(result);
}
}
/// <summary>
/// 管理员登录
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static async Task <string> ManagerLoginAsync(T_ActivityManagerUserInfo_xhrModel request)
{
var sql = @"SELECT TOP 1 ManagerId
FROM Activity.[dbo].[T_ActivityManagerUserInfo_xhr] WITH(NOLOCK)
WHERE [Name]=@Name AND [PassWords]=@PassWords AND ManagerStatus=1;";
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Name", request.Name);
cmd.Parameters.AddWithValue("@PassWords", request.PassWords);
var managerId = await DbHelper.ExecuteScalarAsync(true, cmd);
var result = (managerId == null ? "" : managerId).ToString();
return(result);
}
}
/// <summary>
/// 管理员登录
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <OperationResult <string> > ManagerLoginAsync(T_ActivityManagerUserInfo_xhrModel request)
{
if (string.IsNullOrWhiteSpace(request.Name))
{
return(OperationResult.FromError <string>("-31", string.Format(Resource.ParameterError_IsRequired, "账号")));
}
if (string.IsNullOrWhiteSpace(request.PassWords))
{
return(OperationResult.FromError <string>("-31", string.Format(Resource.ParameterError_IsRequired, "密码")));
}
string passWordsSalt = ActivityManager.GetPassWordsSalt(request);
if (string.IsNullOrWhiteSpace(passWordsSalt))
{
return(OperationResult.FromError <string>("-31", "用户名或密码不正确"));
}
request.PassWordsSalt = passWordsSalt;
request.PassWords = HashSecurityHelper.Sha1Encrypt(request.PassWords + request.PassWordsSalt);
return(OperationResult.FromResult <string>(await ActivityManager.ManagerLoginAsync(request)));
}
/// <summary>
/// 管理员注册
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <OperationResult <bool> > ManagerRegisterAsync(T_ActivityManagerUserInfo_xhrModel request)
{
if (string.IsNullOrWhiteSpace(request.Name))
{
return(OperationResult.FromError <bool>("-31", string.Format(Resource.ParameterError_IsRequired, "账号")));
}
if (string.IsNullOrWhiteSpace(request.PassWords))
{
return(OperationResult.FromError <bool>("-31", string.Format(Resource.ParameterError_IsRequired, "密码")));
}
string passWordsSalt = ActivityManager.GetPassWordsSalt(request);
if (!string.IsNullOrWhiteSpace(passWordsSalt))
{
return(OperationResult.FromError <bool>("-31", "用户名已存在"));
}
request.PassWordsSalt = Guid.NewGuid().ToString();
request.PassWords = HashSecurityHelper.Sha1Encrypt(request.PassWords + request.PassWordsSalt);
//if(request.PassWords.Length>0)
//return OperationResult.FromError<bool>("-31", "密码"+ request.PassWords+"密码盐"+ request.PassWordsSalt);
return(OperationResult.FromResult <bool>(await ActivityManager.ManagerRegisterAsync(request)));
}
///<summary>管理员注册</summary> public Task <OperationResult <bool> > ManagerRegisterAsync(T_ActivityManagerUserInfo_xhrModel request) => InvokeAsync(_ => _.ManagerRegisterAsync(request));
///<summary>管理员注册</summary> public OperationResult <bool> ManagerRegister(T_ActivityManagerUserInfo_xhrModel request) => Invoke(_ => _.ManagerRegister(request));
///<summary>管理员登录</summary> public Task <OperationResult <string> > ManagerLoginAsync(T_ActivityManagerUserInfo_xhrModel request) => InvokeAsync(_ => _.ManagerLoginAsync(request));
///<summary>管理员登录</summary> public OperationResult <string> ManagerLogin(T_ActivityManagerUserInfo_xhrModel request) => Invoke(_ => _.ManagerLogin(request));
