File was renamed from FlexJobApi.User.Application/Enterprises/Queries/EnterprisesQueryHandler.cs |
| | |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | |
| | | namespace FlexJobApi.User.Application |
| | | namespace FlexJobApi.UserServer.Application |
| | | { |
| | | /// <summary> |
| | | /// 企业查询处理器 |
| | |
| | | q = q.Where(it => (it.IsCheckedBankCard && it.RealAccess.HasValue && it.SmsAccess.HasValue) == request.IsConfigured); |
| | | } |
| | | var s = (from e in q |
| | | join a in repEnterpriseAuth.AsQueryable().AsNoTracking() on e.EnterpriseAuthId equals a.Id |
| | | join p in repDictionaryData.AsQueryable().AsNoTracking() on e.ProvinceCode equals p.Code into pg |
| | | from pgi in pg.DefaultIfEmpty() |
| | | join c in repDictionaryData.AsQueryable().AsNoTracking() on e.CityCode equals c.Code into cg |
| | |
| | | select new GetEnterprisesQueryResultItem |
| | | { |
| | | Id = e.Id, |
| | | EnterpriseName = a.EnterpriseName, |
| | | LegalPerson = a.LegalPerson, |
| | | SocietyCreditCode = a.SocietyCreditCode, |
| | | EnterpriseName = e.EnterpriseName, |
| | | LegalPerson = e.LegalPerson, |
| | | SocietyCreditCode = e.SocietyCreditCode, |
| | | Contacts = e.Contacts, |
| | | ContactPhoneNumber = e.ContactPhoneNumber, |
| | | ProvinceContent = pgi.Content, |
| | | CityContent = cgi.Content, |
| | | IndustryTypeContent = igi.Content, |
| | | IsReal = a.IsReal, |
| | | IsReal = e.IsReal, |
| | | IsConfigured = e.IsCheckedBankCard && e.RealAccess.HasValue && e.SmsAccess.HasValue |
| | | }); |
| | | return request.PageModel.GetPagedListAsync(s, cancellationToken: cancellationToken); |
| | |
| | | .ProjectToType<GetEnterpriseQueryResult>() |
| | | .FirstOrDefaultAsync(cancellationToken); |
| | | if (model == null) throw Oops.Oh(EnumErrorCodeType.s404, "该企业"); |
| | | model.UserName = await rep.Change<UserInfo>().AsQueryable().AsNoTracking() |
| | | .Include(it => it.UserAuth) |
| | | model.UserName = await rep.Change<User>().AsQueryable().AsNoTracking() |
| | | .Where(it => it.EnterpriseId == model.Id) |
| | | .Select(it => it.UserAuth.UserName) |
| | | .Select(it => it.UserName) |
| | | .FirstOrDefaultAsync(cancellationToken); |
| | | return model; |
| | | } |