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