From 89ce2bc6b71ea331c219c295074a289d09c808af Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期四, 13 七月 2023 16:06:34 +0800
Subject: [PATCH] 修改车间代码的查询方式，返回正确的车间代码

---
 kingdee/icInventory.go |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/kingdee/icInventory.go b/kingdee/icInventory.go
index 498eaf2..eb1129b 100644
--- a/kingdee/icInventory.go
+++ b/kingdee/icInventory.go
@@ -20,7 +20,7 @@
 		TOP (100) PERCENT item.FNumber AS FNumber,
 		item.FName AS FName,
 		item.FModel AS FModel,
-		item.FSource AS FSource,
+		ti1.FNumber AS FSource,
 		i.FBatchNo AS FBatchNo,
 		s.FNumber AS FStockNo,
 		s.FName AS FStockName,
@@ -33,6 +33,7 @@
 	LEFT OUTER JOIN t_ICItem AS item ON i.FItemID = item.FItemID
 	LEFT OUTER JOIN t_Stock AS s ON i.FStockID = s.FItemID
 	LEFT OUTER JOIN t_Item AS ti ON item.FUnitID = ti.FItemID
+	LEFT OUTER JOIN t_Item AS ti1 ON item.FSource = ti1.FItemID
 	LEFT OUTER JOIN t_Item AS ti2 ON item.FStoreUnitID = ti2.FItemID
 	LEFT OUTER JOIN t_Item AS ti3 ON LEFT (item.FNumber, 5) = ti3.FNumber
 	AND ti3.FItemClassID = 4

--
Gitblit v1.8.0