/* public IEnumerable<Audit.PersonInfo> GetPersonInfoList(Audit.PersonInfo.Criteria criteria) * => _zdDBContext.ProspectPerson * .OrderByDescending(x => x.CreateDate) * .Include(p => p.Operator) * .Sort(criteria.SortField, criteria.IsOrderByDesc) * .FilterBy(criteria) * .AsNoTracking() * .MapToList<Audit.PersonInfo>(); */ public IEnumerable <Audit.PersonInfo> GetPersonInfoList(Audit.PersonInfo.Criteria criteria) { var personList = ( from person in _zdDBContext.ProspectPerson.Include(x => x.Operator).FilterBy(criteria, false) join record in _zdDBContext.AuditRecord.Include(a => a.Operator) on new { ID = person.Id.ToString(), AuditType = AuditType.Person.ToValue(), IdNotEqualNull = person.Id.ToString() != null } equals new { ID = record.AuditId, record.AuditType, IdNotEqualNull = true } into cr from a in cr.DefaultIfEmpty() orderby person.CreateDate descending select new Audit.PersonInfo { Id = person.Id, Person = person.Person, Company = person.Company, Position = person.Position, Industry = person.Industry, Region = person.Region, Address = person.Address, Telphone = person.Telphone, Status = person.Status, Remark = person.Remark, CreateDate = person.CreateDate, UpdateDate = person.UpdateDate, OperatorId = person.OperatorId, Operator = person.Operator.Name, IsContact = (int)person.IsContact, ContactedState = person.ContactedState, Auditor = a.Operator.Name }); return(personList .Sort(criteria.SortField, criteria.IsOrderByDesc) .PaginationBy(criteria) .AsNoTracking() .ToList()); }
public IActionResult ExportUserIDCardList([FromBody] Audit.PersonInfo.Criteria criteria) => TryCatch(() => File(_personInfoRepo.GetPersonInfoList(criteria.SetMaxPageSize()).ToExcel(ExportMappings.PersonExportConfig), "application/vnd.ms-excel"));
public IActionResult GetUserReportList(Audit.PersonInfo.Criteria criteria) => TryCatch(() => criteria.PageOf(x => _personInfoRepo.GetPersonInfoList(criteria)));