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 PagedData <User> Query(int page, int pageSize, UserQuery query) { var users = _fetcher.Query <User>(); if (!string.IsNullOrEmpty(query.Username)) { users = users.Where(x => x.Username.Contains(query.Username)); } if (!string.IsNullOrEmpty(query.RealName)) { users = users.Where(x => x.RealName.Contains(query.RealName.Trim())); } if (!string.IsNullOrEmpty(query.Email)) { users = users.Where(x => x.Email.Contains(query.Email)); } if (query.RoleType != null) { users = users.Where(x => x.RoleType == (RoleType)query.RoleType.Value); } //if (query.RoleId.HasValue) //{ // users = users.Where(x => x.Roles.Select(s => s.Id).Contains(query.RoleId.Value)); //} if (query.IsEnabled.HasValue) { users = users.Where(x => x.IsEnabled == query.IsEnabled); } return(_fetcher.QueryPaged <User>(users.OrderBy(x => x.RoleType).ThenBy(x => x.CreatedOn), page, pageSize)); }
public PagedData <EquipmentCategory> Query(int page, int pageSize, EquipmentCategoryQuery query) { var productCategorys = _fetcher.Query <EquipmentCategory>(); if (!string.IsNullOrWhiteSpace(query.Name)) { productCategorys = productCategorys.Where(x => x.Name.Contains(query.Name)); } if (query.Published.HasValue) { productCategorys = productCategorys.Where(x => x.Published == query.Published); } return(productCategorys.ToPagedData(page, pageSize)); }
public IEnumerable <Role> QueryAll() { return(_fetcher.Query <Role>()); }