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/WomdaaManager.cs | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/service/Wom/WomdaaManager.cs b/service/Wom/WomdaaManager.cs
index 4522f26..c5dff00 100644
--- a/service/Wom/WomdaaManager.cs
+++ b/service/Wom/WomdaaManager.cs
@@ -192,8 +192,10 @@
FROM WOMDAB B
LEFT JOIN WOMDAA A ON A.guid = B.daaGuid
LEFT JOIN MES_ITEMS C ON B.dab003 = C.item_id
+ LEFT JOIN MES_BACK_FLASH F ON b.dab003 = F.ItemId
LEFT JOIN WOMCAB D ON B.erpid = D.ERPID
- WHERE daa001 = '{0}' AND F_WPVT_BASE_QTR='{1}' AND ISSUE_TYPE = 1 ORDER BY DAB002", query.daa001,query.userName);
+ left join SYS_USER e on e.sid = c.F_WPVT_BASE_QTR
+ WHERE daa001 = '{0}' AND e.account='{1}' AND ISSUE_TYPE = 1 AND (F.ItemId is null OR F.checkStatus<>1) ORDER BY DAB002", query.daa001,query.userName);
var womdabs = Db.Ado.SqlQuery<ItemDetailModel>(sql);
--
Gitblit v1.9.3