public IPagedList <CompanySubOrder> Search(CompanySubOrderSearchModel companySubOrderSearchModel)
{
var query = _context.CompanySubOrder
.Where(x => (companySubOrderSearchModel.CompanyId == null || x.Company.Id == companySubOrderSearchModel.CompanyId) &&
(companySubOrderSearchModel.SelectedBookStatus == null || x.BookStatus.Id == companySubOrderSearchModel.SelectedBookStatus) &&
(companySubOrderSearchModel.MaxSearchTime == null || x.EndDate <= companySubOrderSearchModel.MaxSearchTime) &&
(companySubOrderSearchModel.MinSearchTime == null || x.StartDate >= companySubOrderSearchModel.MinSearchTime)
).OrderByDescending(x => x.StartDate)
.ThenByDescending(x => x.UpdatedDate);
var count = query.Count();
var result = query.Skip((companySubOrderSearchModel.PageIndex - 1) * companySubOrderSearchModel.PageSize).Take(companySubOrderSearchModel.PageSize).ToList();
return(new PagedList <CompanySubOrder>(result, companySubOrderSearchModel.PageIndex, companySubOrderSearchModel.PageSize, count));
}
private void InitModelSubOrders(CompanyOrderCreateViewModel model)
{
var companyId = WorkContext.CurrentMembershipUser.Company.Id;
var searchSubOrderModel = new CompanySubOrderSearchModel
{
CompanyId = companyId,
SelectedBookStatus = 18,
PageIndex = 1,
PageSize = int.MaxValue
};
var subOrders = _companySubOrderService.Search(searchSubOrderModel);
LoadSubOrders(model, subOrders);
}
public IPagedList <CompanySubOrder> Search(CompanySubOrderSearchModel companySubOrderSearchModel)
{
return(_companySubOrderRepository.Search(companySubOrderSearchModel));
}
