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 | 13 +++++++++----
1 files changed, 9 insertions(+), 4 deletions(-)
diff --git a/kingdee/icInventory.go b/kingdee/icInventory.go
index bd824a5..14f35cf 100644
--- a/kingdee/icInventory.go
+++ b/kingdee/icInventory.go
@@ -1,9 +1,12 @@
package kingdee
+// 搴撳瓨鏌ヨ
+
type Inventory struct {
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,25 +22,27 @@
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,
ti.FName AS FUnit,
CONVERT (FLOAT, i.FQty) AS FUnitQty,
ti2.FName AS FSec,
- i.FQty AS FQty
+ i.FQty AS FQty
FROM
ICInventory AS i
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
- WHERE
- (i.FQty <> 0)
+ --WHERE
+ -- (i.FQty <> 0)
ORDER BY
- item.FNumber
+ item.FNumber
`
var result []Inventory
--
Gitblit v1.8.0