From 942f3416b333304bde50f0dca5581595f397eafa Mon Sep 17 00:00:00 2001 From: gigibox <gigibox@163.com> Date: 星期一, 19 六月 2023 16:27:26 +0800 Subject: [PATCH] 完善功能,添加日志,添加nsq tcp上报 --- kingdee/icInventory.go | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/kingdee/icInventory.go b/kingdee/icInventory.go index bd824a5..b60a7a2 100644 --- a/kingdee/icInventory.go +++ b/kingdee/icInventory.go @@ -25,7 +25,7 @@ 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 @@ -34,10 +34,10 @@ 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