LoginRepository.cs 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. 
  2. using OASystem.Domain;
  3. using OASystem.Domain.Dtos;
  4. using OASystem.Domain.Entities.System;
  5. namespace OASystem.Infrastructure.Repositories.Login
  6. {
  7. public class LoginRepository : BaseRepository<Sys_Users, LoginView>
  8. {
  9. public LoginRepository(SqlSugarClient sqlSugar) : base(sqlSugar)
  10. {
  11. }
  12. /// <summary>
  13. /// 用户登录
  14. /// 返回Token
  15. /// </summary>
  16. /// <param name="_loginRep"></param>
  17. /// <param name="loginDto"></param>
  18. /// <returns></returns>
  19. public async Task<Result> Login(LoginRepository _loginRep, LoginDto loginDto)
  20. {
  21. Result result = new Result();
  22. string SQLWhere = string.Format("Where Number='{0}' And Password='{1}'", loginDto.Number, loginDto.Password);
  23. string sql = string.Format("Select * From Sys_Users With(NoLock) {0}", SQLWhere);
  24. var _entity = await _loginRep.GetSingleInfoBySqlWithNolockAsync(sql);
  25. if (_entity == null)
  26. {
  27. result.Code = -2;
  28. result.Message = "暂无该账号信息!";
  29. return result;
  30. }
  31. result.Code = 0;
  32. result.Message = "成功!";
  33. result.Data = _entity;
  34. return result;
  35. }
  36. }
  37. }