From bd7f147b15efd57c5f054e537e715486c53c25dc Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期五, 28 十一月 2025 17:08:34 +0800
Subject: [PATCH] 标准版
---
WebApi/GS.QC/Service/MesQaItemsDetect01Manager.cs | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/WebApi/GS.QC/Service/MesQaItemsDetect01Manager.cs b/WebApi/GS.QC/Service/MesQaItemsDetect01Manager.cs
index 24411b0..83c3e97 100644
--- a/WebApi/GS.QC/Service/MesQaItemsDetect01Manager.cs
+++ b/WebApi/GS.QC/Service/MesQaItemsDetect01Manager.cs
@@ -146,7 +146,10 @@
m.list = new List<dynamic>();
m.list2 = new List<dynamic>();
System.Text.StringBuilder sb = new StringBuilder();
- sb.Append("select * from MES_QA_ITEMS_DETECT_DETAIL12 where parent_guid='" + guid + "' order by fstand asc");
+ sb.Append("select * ,cj.USER_NAME as createByName " +
+ "from MES_QA_ITEMS_DETECT_DETAIL12 a " +
+ "left join SYS_USER cj on cj.ACCOUNT=a.create_by " +
+ "where parent_guid='" + guid + "' order by fstand asc");
sb.Append(" select d13.*,d5.fcheck_item as fcheckItemd5,d5.ybsl from MES_QA_ITEMS_DETECT_DETAIL13 d13 left join[dbo].[MES_QA_ITEMS_DETECT_DETAIL5] d5 on d13.parent_guid = d5.guid");
sb.Append(" where d13.parent_guid = '" + guid + "'");
sb.Append(" order by d13.fcheck_item asc");
--
Gitblit v1.9.3