From c2b8d20496542254930431e8e6a2954826a95910 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期三, 26 十一月 2025 18:44:52 +0800
Subject: [PATCH] 查看所有图片、查看所有不良描述、首检提交时防呆（是否上传图片，是否检验完成等）
---
StandardPda/MES.Service/service/QC/SJService.cs | 20 ++++++++++++++++++--
1 files changed, 18 insertions(+), 2 deletions(-)
diff --git a/StandardPda/MES.Service/service/QC/SJService.cs b/StandardPda/MES.Service/service/QC/SJService.cs
index 2e2c364..2426cf7 100644
--- a/StandardPda/MES.Service/service/QC/SJService.cs
+++ b/StandardPda/MES.Service/service/QC/SJService.cs
@@ -1,4 +1,4 @@
-锘縰sing MES.Service.DB;
+锘匡豢using MES.Service.DB;
using MES.Service.Dto.service;
using MES.Service.Modes;
using MES.Service.util;
@@ -135,7 +135,7 @@
Picture = b.Picture,
Picturename = b.Picturename,
result = "鏈娴�",
- isCheck = 0
+ isCheck = 0,UP_FILE=b.UP_FILE
}).ToList();
}
@@ -769,6 +769,22 @@
return msg;
}
+ /// <summary>
+ /// 鑾峰彇棣栨鍗曟墍鏈変笉鑹弿杩�
+ /// </summary>
+ /// <param name="id">妫�楠屽崟ID</param>
+ /// <returns>涓嶈壇鎻忚堪鏁版嵁琛�</returns>
+ public DataTable getBlmsItem(string id)
+ {
+ OracleSQLHelper SQLHelper = new();
+ // 鏌ヨ棣栨妫�楠屽崟鐨勪笉鑹弿杩�
+ var sql1 = string.Format(
+ @"select PROJ_NAME, REMARKS
+ from QS_ITEM_IPI_ITEM f
+ where PID = '" + id + "' and REMARKS is not null order by PROJ_NAME");
+
+ return SQLHelper.ExecuteQuery(sql1);
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3