From 671b60339271875c3d15357e7c792727d67e6c91 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期二, 06 五月 2025 09:46:54 +0800
Subject: [PATCH] 1.现场收料 2.MES->OA优化 3.采购入库新增日志。
---
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