From efb92d737774650854cb79b37677b0ac4924f37d Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期二, 15 八月 2023 18:10:05 +0800
Subject: [PATCH] 修复channel的初始化
---
kingdee/icInventory.go | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/kingdee/icInventory.go b/kingdee/icInventory.go
index 498eaf2..14f35cf 100644
--- a/kingdee/icInventory.go
+++ b/kingdee/icInventory.go
@@ -1,5 +1,7 @@
package kingdee
+// 搴撳瓨鏌ヨ
+
type Inventory struct {
FNumber string `gorm:"column:FNumber" json:"FNumber"` // 鐗╂枡浠ｇ爜
FName string `gorm:"column:FName" json:"FName"` // 鐗╂枡鍚嶇О
@@ -20,7 +22,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 +35,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