| | |
| | | } |
| | | |
| | | //获取库存明细信息(盘点选择明细数据源) |
| | | public List<StockDetailDto> GetCheckStockDetailList(string houseNo, string roadwayNo, string locateNo, string msg) |
| | | public List<StockDetailDto> GetCheckStockDetailList(string houseNo, string roadwayNo, string locateNo, string msg, int page, int limit, out int count) |
| | | { |
| | | try |
| | | { |
| | |
| | | .And(m => m.IsDel == "0" && m.SkuNo != "100099" && m.Status == "0") |
| | | .ToExpression();//注意 这一句 不能少 |
| | | |
| | | |
| | | var total = 0; |
| | | var list = Db.Queryable<DataStockDetail>().Where(item).GroupBy(m => new { m.SkuNo, m.SkuName, m.Standard, m.LotNo, m.LotText, m.SupplierLot, m.LocatNo, m.PalletNo }) |
| | | .Select(a => new StockDetailDto() |
| | | { |
| | |
| | | Qty = SqlFunc.AggregateSum(a.Qty), |
| | | LocatNo = a.LocatNo, |
| | | PalletNo = a.PalletNo |
| | | }).ToList(); |
| | | }).ToOffsetPage(page, limit, ref total); |
| | | count = total; |
| | | |
| | | return list; |
| | | } |