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));
}
