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