From 5c45b5f97c1365b6f89da2a0897a7c93fe16cb63 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期三, 17 十二月 2025 18:09:01 +0800
Subject: [PATCH] 首检巡检
---
WebApi/GS.QC/Service/FqcItemsManager.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/WebApi/GS.QC/Service/FqcItemsManager.cs b/WebApi/GS.QC/Service/FqcItemsManager.cs
index 3d55749..fa7c3d7 100644
--- a/WebApi/GS.QC/Service/FqcItemsManager.cs
+++ b/WebApi/GS.QC/Service/FqcItemsManager.cs
@@ -104,7 +104,7 @@
try
{
// 鏌ヨ涓昏〃鏁版嵁
- string sqlMain = $"SELECT A.*,B.Name as OrgName FROM MES_FQC_ITEMS A LEFT JOIN SYS_ORGANIZATION b ON A.OrgId = b.FID WHERE a.GUID='{guid}'";
+ string sqlMain = $"SELECT A.*,B.Name as OrgName,C.staff_name AS JY_NAME FROM MES_FQC_ITEMS A LEFT JOIN SYS_ORGANIZATION b ON A.OrgId = b.FID LEFT JOIN MES_STAFF C ON C.staff_no = A.JY_USER WHERE a.GUID='{guid}'";
var dsMain = DbHelperSQL.Query(sqlMain);
if (dsMain != null && dsMain.Tables.Count > 0 && dsMain.Tables[0].Rows.Count > 0)
{
@@ -239,8 +239,10 @@
+ m.RPB017 + _split
+ m.RPB018 + _split
+ m.RPB019 + _split
+ + m.RPB020 + _split
+ m.Remark + _split
- + (CheckGuid(_guid) ? _guid : Guid.Empty.ToString());
+ + (CheckGuid(_guid) ? _guid : Guid.Empty.ToString()) + _split
+ + m.Seq;
if (_sb1.Length > 0)
_sb1.Append("~");
_sb1.Append(_line);
--
Gitblit v1.9.3