From 80aa0cb51bc007f85c74c2cad0fb8e24a60cb371 Mon Sep 17 00:00:00 2001
From: cnf <3200815559@qq.com>
Date: 星期四, 11 九月 2025 17:30:19 +0800
Subject: [PATCH] 销售与其他出入库功能挪移
---
service/Wom/WomdaahbManager.cs | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/service/Wom/WomdaahbManager.cs b/service/Wom/WomdaahbManager.cs
index 4c4edc2..4540be1 100644
--- a/service/Wom/WomdaahbManager.cs
+++ b/service/Wom/WomdaahbManager.cs
@@ -238,7 +238,8 @@
left join mes_items m on M.ID = b.dab003
left join MES_UNIT u on u.id = ahbl.UNIT
left join [dbo].[v_caa] v on v.guid = a.guid
- WHERE ahb.daahb001 = '{0}' AND D.ISSUE_TYPE = 1
+ LEFT JOIN MES_BACK_FLASH F ON b.dab003 = F.ItemId
+ WHERE ahb.daahb001 = '{0}' AND D.ISSUE_TYPE = 1 AND (F.ItemId is null OR F.checkStatus<>1)
group by m.item_no
ORDER BY m.item_no
", query.hbNo);
@@ -983,7 +984,7 @@
C.item_no,
C.item_name,
C.item_model
-FROM MES_INV_ITEM_OUTS A
+ FROM MES_INV_ITEM_OUTS A
LEFT JOIN MES_INV_ITEM_OUT_C_DETAILS B ON A.GUID = B.ITEM_OUT_ID
LEFT JOIN MES_ITEMS C ON B.ITEM_ID = C.item_id
LEFT JOIN SYS_USER D ON A.create_by = D.ACCOUNT
--
Gitblit v1.9.3