From c418ccde908642c73f86ff43cc999be835a1e77d Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期一, 12 五月 2025 09:51:19 +0800
Subject: [PATCH] 1.首检认证信息输入 2.现场收料优化
---
service/QC/OaApi.cs | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/service/QC/OaApi.cs b/service/QC/OaApi.cs
index a126489..62f6d3f 100644
--- a/service/QC/OaApi.cs
+++ b/service/QC/OaApi.cs
@@ -112,7 +112,9 @@
C.item_name AS jzmcwlmc,
D.supp_name AS khgys,
B.bill_no AS dhdhmes,
- A.remark AS bhgpqxms
+ (SELECT STRING_AGG(releaseNo+':' + mx.fng_desc+'\n', ',') AS OrderIDs
+FROM [Mes_QC_Exceptional_Detail] mx where mx.pGuid=a.guid
+) AS bhgpqxms
FROM Mes_QC_Exceptional A
LEFT JOIN MES_INV_ITEM_ARN B ON A.aboutGuid = b.guid
LEFT JOIN MES_ITEMS C ON A.itemId = c.item_id
--
Gitblit v1.9.3