private void InitData()
{
if (this.SelectedDrugInventoryRecords == null)
{
this.SelectedDrugInventoryRecords = new List <DrugInventoryRecord>();
}
this.SelectedDrugInventoryRecords.Clear();
QueryModel = new QueryDrugInventoryRecordBusinessModel();
}
/// <summary>
/// 分页查询所有的药物库存为选择窗口
/// </summary>
/// <returns></returns>
public List <DrugInventoryRecord> QueryPagedAllDrugInventoryRecordSelector
(
QueryDrugInventoryRecordBusinessModel queryModel,
int index, int size,
out PagerInfo pager
)
{
pager = PagerInfo.Validate(new PagerInfo {
Index = index, Size = size
});
try
{
List <DrugInventoryRecord> records = new List <DrugInventoryRecord>();
var queryBuilder = QueryBuilder.Create <DrugInventoryRecord>();
Expression <Func <DrugInventoryRecord, bool> > expression = dir => true;
//处理排序
var query = this.Queryable;
query = query.Where(PreparePredicate(queryBuilder.Expression)); //过滤一下
pager.RecordCount = query.Count(); //处理总录条数
query = query.OrderBy(dir => dir.PruductDate)
.OrderBy(dir => dir.OutValidDate)
.OrderBy(dir => dir.InInventoryCount)
.OrderBy(dir => dir.SalesCount)
.OrderBy(dir => dir.RetailCount);
records = query
.Skip((pager.Index - 1) * pager.Size)
.Take(pager.Size)
.ToList();
return(records);
}
catch (Exception ex)
{
return(this.HandleException <List <DrugInventoryRecord> >("分页查询所有的药物库存失败", ex));
}
finally
{
this.Dispose();
}
}
