public IEnumerable <Audit.UserIDCard> GetUserIDcardList(Audit.UserIDCard.Criteria criteria) { var userIDCardList = (from card in _zdDBContext.UserIdcard.Include(x => x.User).FilterBy(criteria, false) join record in _zdDBContext.AuditRecord.Include(a => a.Operator) on new { UserId = card.UserId.ToString(), AuditType = AuditType.IDCard.ToValue(), UserIdNotEqualsNull = card.UserId != null } equals new { UserId = record.AuditId, record.AuditType, UserIdNotEqualsNull = true } into cr from a in cr.DefaultIfEmpty() where string.IsNullOrEmpty(criteria.Auditor) || a.Operator.Name == criteria.Auditor orderby card.UpdateTime descending select new Audit.UserIDCard { ID = Guid.NewGuid(), UserID = card.UserId, UserName = card.UserName, Gender = card.Gender ?? 0, Nation = card.Nation, Birthday = card.Birthday, Address = card.Address, IdCardNumber = card.IdcardNo, IssuingAgency = card.IssuingAgency, ValidityStartTime = card.ValidityStartTime, ValidityEndTime = card.ValidityEndTime, IdcardFrontUrl = card.IdcardFrontUrl, IdcardBackUrl = card.IdcardBackUrl, CreateTime = card.CreateTime, UpdateTime = card.UpdateTime ?? null, Status = card.Status ?? 0, Phone = card.User.Telphone, Auditor = a.Operator.Name, AuditDate = a.AuditDate }); return(userIDCardList .Sort(criteria.SortField, criteria.IsOrderByDesc) .PaginationBy(criteria) .AsNoTracking() .ToList()); }
public IActionResult ExportUserIDCardList([FromBody] Audit.UserIDCard.Criteria criteria) => File(_userIDCardRepo.GetUserIDcardList(criteria.SetMaxPageSize()).ToExcel(ExportMappings.UserIDCardExportConfig), "application/vnd.ms-excel");
public IActionResult GetUserIdcardList(Audit.UserIDCard.Criteria criteria) => criteria.PageOf(x => _userIDCardRepo.GetUserIDcardList(x));