| | |
| | | /// <param name="palletNo">托盘号</param> |
| | | /// <param name="boxNo">箱码</param> |
| | | /// <returns></returns> |
| | | public async Task<List<StockDetailWithQtyDto>> GetStockQueryList(string locatNo, string palletNo, string boxNo) |
| | | public List<StockDetailWithQtyDto> GetStockQueryList(string locatNo, string palletNo, string boxNo) |
| | | { |
| | | string dataSql = "", whereStr = ""; |
| | | |
| | |
| | | group by a.SkuName,a.SkuNo,a.LotNo,b.LocatNo,a.PalletNo |
| | | order by a.SkuNo,a.LotNo"; |
| | | } |
| | | DataTable dataDt = await Db.Ado.GetDataTableAsync(dataSql); |
| | | DataTable dataDt = Db.Ado.GetDataTable(dataSql); |
| | | |
| | | var result = dataDt.Rows.Cast<DataRow>().Select(e => new StockDetailWithQtyDto |
| | | { |