public PagedResultDto <SearchCustomerInfoDto> GetPagedCustomerInfos(SearchCustomerInfoInput input) { //public string MerchandiserName { get; set; } // public long MerchandiserId { get; set; } bool isa; bool canAssignInspectionToOther = PermissionChecker.IsGranted(PermissionNames.Pages_Inspection); if (!canAssignInspectionToOther) { isa = PermissionChecker.IsGranted(PermissionNames.Pages_Staff_Merchandiser); } //条件过滤 var query = _CustomerinfoRepository.GetAll().Where(t => t.IsCandidate == false) .WhereIf(!input.InvoiceType.IsNullOrEmpty(), t => t.InvoiceType == input.InvoiceType) .WhereIf(!input.CompanyName.IsNullOrEmpty(), t => t.CompanyName == input.CompanyName) .WhereIf(!input.CompanyAbbreviation.IsNullOrEmpty(), t => t.CompanyName.Contains(input.CompanyAbbreviation)) .OrderByDescending(t => t.CustomerID); //获取数据总数 var tasksCount = query.Count(); //默认的分页方式 source.Skip(pageIndex * pageSize).Take(pageSize).ToList(); var taskList = query.Skip((input.pageIndex - 1) * input.pageSize).Take(input.pageSize).ToList(); return(new PagedResultDto <SearchCustomerInfoDto>(tasksCount, taskList.MapTo <List <SearchCustomerInfoDto> >())); }
public PagedResultDto <SearchCustomerInfoDto> GetPagedCustomerInfos(SearchCustomerInfoInput input) { //条件过滤 var query = _CustomerinfoRepository.GetAll() .WhereIf(!input.InvoiceType.IsNullOrEmpty(), t => t.InvoiceType == input.InvoiceType) .WhereIf(!input.CompanyName.IsNullOrEmpty(), t => t.CompanyName == input.CompanyName) .WhereIf(!input.CompanyAbbreviation.IsNullOrEmpty(), t => t.CompanyName.Contains(input.CompanyAbbreviation)) .OrderByDescending(t => t.CustomerID); //获取数据总数 var tasksCount = query.Count(); //默认的分页方式 source.Skip(pageIndex * pageSize).Take(pageSize).ToList(); var taskList = query.Skip((input.pageIndex - 1) * input.pageSize).Take(input.pageSize).ToList(); return(new PagedResultDto <SearchCustomerInfoDto>(tasksCount, taskList.MapTo <List <SearchCustomerInfoDto> >())); }