From 4898b449851ea0af3ff4d884b3099dfa07e89356 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期三, 08 十月 2025 15:44:37 +0800
Subject: [PATCH] 工单查物料修改
---
service/Wom/WomdaaManager.cs | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/service/Wom/WomdaaManager.cs b/service/Wom/WomdaaManager.cs
index c5dff00..a1bf622 100644
--- a/service/Wom/WomdaaManager.cs
+++ b/service/Wom/WomdaaManager.cs
@@ -289,7 +289,8 @@
LEFT JOIN WOMDAA A ON A.guid = B.daaGuid
LEFT JOIN MES_ITEMS C ON B.dab003 = C.item_id
LEFT JOIN WOMCAB D ON B.erpid = D.ERPID
- WHERE daa001 = '{0}' AND ISSUE_TYPE = 1 ORDER BY DAB002", query.daa001);
+ LEFT JOIN MES_BACK_FLASH F ON b.dab003 = F.ItemId
+ WHERE daa001 = '{0}' AND ISSUE_TYPE = 1 ORDER BY DAB002 AND (F.ItemId is null OR F.checkStatus<>1)", query.daa001);
var womdabs = Db.Ado.SqlQuery<ItemDetailModel>(sql);
--
Gitblit v1.9.3