From 21045e8ff4be6b94ebfc0a9ad69a2c8258db2818 Mon Sep 17 00:00:00 2001
From: huawei <huawei@2214094776>
Date: 星期三, 10 十二月 2025 17:39:32 +0800
Subject: [PATCH] Merge branch 'master' of http://43.142.96.171:8080/r/~cnf/JH/JH_PdaService
---
service/Warehouse/TransferOutManager.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/service/Warehouse/TransferOutManager.cs b/service/Warehouse/TransferOutManager.cs
index 8442c3a..946dc6c 100644
--- a/service/Warehouse/TransferOutManager.cs
+++ b/service/Warehouse/TransferOutManager.cs
@@ -232,7 +232,8 @@
// 鏌ヨ鏉＄爜搴撳瓨淇℃伅骞堕獙璇�
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}");
@@ -427,7 +428,8 @@
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();
--
Gitblit v1.9.3