示例#1
0
        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> >()));
        }
示例#2
0
        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> >()));
        }