| | |
|---|
| | | |
|---|
| | | // 查询条码库存信息并验证 |
|---|
| | | var stock = Db.Queryable<MesInvItemStocks>() |
|---|
| | | .Where(x => x.ItemBarcode == p_item_barcode |
|---|
| | | .LeftJoin<MesInvItemBarcodes>((stocks, items) => stocks.ItemBarcode == items.ItemBarcode) |
|---|
| | | .Where((x,b) => (x.ItemBarcode == p_item_barcode || b.ItemBarcodeTb == p_item_barcode) |
|---|
| | | && x.Quantity > 0) |
|---|
| | | .First(); |
|---|
| | | if (stock == null) throw new Exception($"库存中无此条码，请核对！{p_item_barcode}"); |
|---|
| | |
|---|
| | | var p_item_barcode = query.barcode; |
|---|
| | | |
|---|
| | | var barinfo = Db.Queryable<MesInvItemStocks>() |
|---|
| | | .Where(x => x.ItemBarcode == p_item_barcode) |
|---|
| | | .LeftJoin<MesInvItemBarcodes>((stocks, items) => stocks.ItemBarcode == items.ItemBarcode) |
|---|
| | | .Where((x, b) => (x.ItemBarcode == p_item_barcode || b.ItemBarcodeTb == p_item_barcode)) |
|---|
| | | .First(); |
|---|
| | | |
|---|
| | | |
|---|
