public async Task <DataResultDto <UserDto> > CheckUser(UserDto userDto)
{
DataResultDto <UserDto> dataResultDto = new DataResultDto <UserDto>();
User user = null;
string sql = "select UserId,LoginName,UserName,Password,Status,IsAdmin from `user` where LoginName=@LoginName and IsDelete=0 ";
using (var connect = CreateConnection())
{
user = await connect.QueryFirstOrDefaultAsync <User>(sql, new { LoginName = userDto.LoginName });
}
if (user == null)
{
dataResultDto.Code = 1;
dataResultDto.Msg = "登陆失败，用户名不正确！";
}
else
{
if (user.Status == 0)
{
string pwd = $"{userDto.Password}{this._webStaticConfig.MD5Code}";
string spwd = SecurityTool.MD5Hash(pwd);
if (spwd.ToUpper() == user.Password.ToUpper())
{
UserDto quserDto = new UserDto();
quserDto = Mapper.Map <User, UserDto>(user);
dataResultDto.Code = 0;
dataResultDto.Msg = "登陆成功!";
dataResultDto.DataList = quserDto;
}
else
{
dataResultDto.Code = 1;
dataResultDto.Msg = "登陆失败，用户名或者密码不对!";
}
}
else if (user.Status == 1)
{
dataResultDto.Code = 1;
dataResultDto.Msg = "登陆失败，用户正在审核中！";
}
else if (user.Status == 2)
{
dataResultDto.Code = 1;
dataResultDto.Msg = "登陆失败，用户已冻结,请联系管理员！";
}
else if (user.Status == 3)
{
dataResultDto.Code = 1;
dataResultDto.Msg = "登陆失败，用户已禁用,请联系管理员！";
}
else
{
dataResultDto.Code = 1;
dataResultDto.Msg = "登陆失败，用户名或者密码错误！";
}
}
return(dataResultDto);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="userDto"></param>
/// <returns></returns>
public async Task <bool> AddUserAsync(UserDto userDto)
{
string pwd = $"{userDto.Password}{this._webStaticConfig.MD5Code}";
string spwd = SecurityTool.MD5Hash(pwd);
userDto.Password = spwd;
userDto.UserHeadImaUrl = "/upload/user-head/default.jpg";
string sql = "insert into `user`(LoginName,UserName,`Password`) VALUES(@LoginName,@UserName,@Password) ";
using (var connect = CreateConnection())
{
return(await connect.ExecuteAsync(sql, new { LoginName = userDto.LoginName, UserName = userDto.UserName, Password = userDto.Password }) > 0);
}
}