public PagedData <EquipmentInfo> Query(int page, int pageSize, EquipmentInfoQuery query) { var equipmentInfos = _fetcher.Query <EquipmentInfo>(); if (query.CategoryId.HasValue && query.CategoryId.Value > 0) { equipmentInfos = equipmentInfos.Where(x => x.EquipmentCategory.Id == query.CategoryId); } if (!string.IsNullOrEmpty(query.Name)) { equipmentInfos = equipmentInfos.Where(x => x.Name.Contains(query.Name)); } if (query.BatchNum.HasValue) { equipmentInfos = equipmentInfos.Where(x => x.BatchNum == query.BatchNum.Value); } if (query.CategoryId1.HasValue && query.CategoryId1.Value > 0) { equipmentInfos = equipmentInfos.Where(x => x.EquipmentCategory1.Id == query.CategoryId1); } if (!string.IsNullOrEmpty(query.IdentifierNo)) { equipmentInfos = equipmentInfos.Where(x => x.IdentifierNo.Contains(query.IdentifierNo)); } if (query.OutDateTime.HasValue) { equipmentInfos = equipmentInfos.Where(x => x.OutDateTime == query.OutDateTime); } return(equipmentInfos.ToPagedData(page, pageSize)); }
public IEnumerable <EquipmentInfo> Query(EquipmentInfoQuery query) { var equipmentInfos = _fetcher.Query <EquipmentInfo>(); if (query.CategoryId.HasValue) { equipmentInfos = equipmentInfos.Where(x => x.EquipmentCategory.Id == query.CategoryId); } return(equipmentInfos.ToList()); }
public ActionResult Index(int page = 1, int pageSize = PPM.Web.Common.PaginationSetttings.PageSize, EquipmentInfoQuery query = null) { var categories = _categoryQueryService.QueryAllValid().ToList(); var viewModel = new IndexViewModel(Url) { Query = query, Items = _equipmentInfoQueryService.Query(page, pageSize, query), ProductCategoryTreeView = new EquipmentCategoryTreeView().GetProductCategoryTreeView(categories), CategoryText = query.CategoryId.HasValue ? categories.SingleOrDefault(x => x.Id == query.CategoryId).Name : string.Empty, CategoryText1 = query.CategoryId1.HasValue ? categories.SingleOrDefault(x => x.Id == query.CategoryId1).Name : string.Empty }; foreach (var equipmentInfo in viewModel.Items) { equipmentInfo.QrCodeImage = _host + equipmentInfo.QrCodeImage; } return(View("~/Views/Equipment/Info/Index.cshtml", viewModel)); }