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, 3 insertions(+), 0 deletions(-) diff --git a/kingdee/icInventory.go b/kingdee/icInventory.go index b60a7a2..eb1129b 100644 --- a/kingdee/icInventory.go +++ b/kingdee/icInventory.go @@ -4,6 +4,7 @@ FNumber string `gorm:"column:FNumber" json:"FNumber"` // 鐗╂枡浠ｇ爜 FName string `gorm:"column:FName" json:"FName"` // 鐗╂枡鍚嶇О FModel string `gorm:"column:FModel" json:"FModel"` // 瑙勬牸鍨嬪彿 + FSource string `gorm:"column:FSource" json:"FSource"` // 鐢熶骇杞﹂棿缂栧彿 FBatchNo string `gorm:"column:FBatchNo" json:"FBatchNo"` // 鎵瑰彿 FStockNo string `gorm:"column:FStockNo" json:"FStockNo"` // 浠撳簱浠ｇ爜 FStockName string `gorm:"column:FStockName" json:"FStockName"` // 浠撳簱鍚嶇О @@ -19,6 +20,7 @@ TOP (100) PERCENT item.FNumber AS FNumber, item.FName AS FName, item.FModel AS FModel, + ti1.FNumber AS FSource, i.FBatchNo AS FBatchNo, s.FNumber AS FStockNo, s.FName AS FStockName, @@ -31,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