From c2b8d20496542254930431e8e6a2954826a95910 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期三, 26 十一月 2025 18:44:52 +0800
Subject: [PATCH] 查看所有图片、查看所有不良描述、首检提交时防呆（是否上传图片，是否检验完成等）
---
StandardPda/MESApplication/Controllers/QC/SJController.cs | 133 +++++++++++++++++++++++++++++++++++++++++---
1 files changed, 123 insertions(+), 10 deletions(-)
diff --git a/StandardPda/MESApplication/Controllers/QC/SJController.cs b/StandardPda/MESApplication/Controllers/QC/SJController.cs
index 9ca90c1..33fa226 100644
--- a/StandardPda/MESApplication/Controllers/QC/SJController.cs
+++ b/StandardPda/MESApplication/Controllers/QC/SJController.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.service.QC;
@@ -323,7 +323,7 @@
return ResponseResult.ResponseError(ex);
}
}
-
+
//IqcQaSubmit
[HttpPost("SJQaSubmit")]
public ResponseResult SJQaSubmit(LLJDto rkjDto)
@@ -331,26 +331,33 @@
try
{
OracleSQLHelper SQLHelper = new();
+
+ //------------------ SN鎵爜鏍￠獙 ------------------
var sql1 =
- string.Format(
- @"select SCAN_ITEM from ZMZ_TEST.MES_SJ_SCAN_ITEM_CK where mid='" + rkjDto.gid + "' and sn_no is null");
+ @"select SCAN_ITEM
+ from ZMZ_TEST.MES_SJ_SCAN_ITEM_CK
+ where mid='" + rkjDto.gid + "' and sn_no is null";
+
var dataTable1 = SQLHelper.ExecuteQuery(sql1);
string msg = "";
for (var i = 0; i < dataTable1.Rows.Count; i++)
{
- msg = msg + "銆�"+dataTable1.Rows[i]["SCAN_ITEM"].ToString()+"銆�";
+ msg += "銆�" + dataTable1.Rows[i]["SCAN_ITEM"].ToString() + "銆�";
}
- if (msg != null && msg != "")
+
+ if (!string.IsNullOrEmpty(msg))
{
return new ResponseResult
{
status = 1,
- message = msg+"鏈繘琛孲N鎵爜纭!",
+ message = msg + "鏈繘琛孲N鎵爜纭!",
data = ""
};
}
+
+ //------------------ 鍥惧儚涓�鑷存�ф牎楠� ------------------
var msg1 = new SJService().YzxImgVerify(rkjDto.gid.ToString());
- if (msg1[0]=="1")
+ if (msg1[0] == "1")
{
return new ResponseResult
{
@@ -359,10 +366,88 @@
data = ""
};
}
+
+ //------------------ 涓嶅悎鏍煎浘鐗囨槸鍚︿笂浼犳牎楠� ------------------
+ var sql2 =
+ @"select A.id, A.PROJ_NAME, B.id as id2
+ from QS_ITEM_IPI_ITEM A
+ left join MES_QS_IMAGE B on 777 || A.ID = B.FID
+ where A.PID = '" + rkjDto.gid + @"'
+ and B.id is null
+ and IS_PASS = 0";
+
+ var dt2 = SQLHelper.ExecuteQuery(sql2);
+ if (dt2.Rows.Count > 0)
+ {
+ string err = "";
+ for (int i = 0; i < dt2.Rows.Count; i++)
+ {
+ err += "銆�" + dt2.Rows[i]["PROJ_NAME"].ToString() + "銆�";
+ }
+
+ return new ResponseResult
+ {
+ status = 1,
+ message = err + "涓嶅悎鏍煎浘鐗囨湭涓婁紶锛�",
+ data = ""
+ };
+ }
+
+ //------------------ 蹇呭～椤瑰浘鐗囨槸鍚︿笂浼犳牎楠� ------------------
+ var sql3 =
+ @"select A.id, A.PROJ_NAME, B.id as id2
+ from QS_ITEM_IPI_ITEM A
+ left join MES_QS_IMAGE B on 777 || A.ID = B.FID
+ where A.PID = '" + rkjDto.gid + @"'
+ and B.id is null
+ and UP_FILE = 1";
+
+ var dt3 = SQLHelper.ExecuteQuery(sql3);
+ if (dt3.Rows.Count > 0)
+ {
+ string err = "";
+ for (int i = 0; i < dt3.Rows.Count; i++)
+ {
+ err += "銆�" + dt3.Rows[i]["PROJ_NAME"].ToString() + "銆�";
+ }
+
+ return new ResponseResult
+ {
+ status = 1,
+ message = err + "蹇呭～椤瑰浘鐗囨湭涓婁紶锛�",
+ data = ""
+ };
+ }
+
+ //------------------ 鏂板鏍￠獙锛氭鏌ユ槸鍚﹀瓨鍦ㄦ湭瀹屾垚锛圛S_PASS is null锛� ------------------
+ var sqlPass =
+ @"select ID, PROJ_NAME
+ from QS_ITEM_IPI_ITEM
+ where PID = '" + rkjDto.gid + @"'
+ and IS_PASS is null";
+
+ var dtPass = SQLHelper.ExecuteQuery(sqlPass);
+ if (dtPass.Rows.Count > 0)
+ {
+ string err = "";
+ for (int i = 0; i < dtPass.Rows.Count; i++)
+ {
+ err += "銆�" + dtPass.Rows[i]["PROJ_NAME"].ToString() + "銆�";
+ }
+
+ return new ResponseResult
+ {
+ status = 1,
+ message = err + "椤圭洰鏈畬鎴愶紝涓嶅厑璁告彁浜ゆ楠岋紒",
+ data = ""
+ };
+ }
+
+ //------------------ 涓讳笟鍔￠�昏緫锛氭彁浜� ------------------
dynamic resultInfos = new ExpandoObject();
- var tbBillList =
- new SJService().SJQaSubmit(rkjDto);
+ var tbBillList = new SJService().SJQaSubmit(rkjDto);
resultInfos.tbBillList = tbBillList;
+
return new ResponseResult
{
status = 0,
@@ -375,6 +460,7 @@
return ResponseResult.ResponseError(ex);
}
}
+
/// <summary>
/// 鑾峰彇涓�鑷存�ф牳瀵归」鐩�
@@ -557,4 +643,31 @@
}
}
+ /// <summary>
+ /// 鑾峰彇棣栨鍗曟墍鏈変笉鑹弿杩�
+ /// </summary>
+ /// <param name="data"></param>
+ /// <returns></returns>
+ [HttpPost("getQSBlmsItem")]
+ public ResponseResult getQSBlmsItem([FromBody] JObject data)
+ {
+ var id = data["id"]?.ToString();
+
+ try
+ {
+ var tbBillList = new SJService().getBlmsItem(id);
+
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = tbBillList
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
}
\ No newline at end of file
--
Gitblit v1.9.3