From 02893d929e7d2b650dc32ff14e6b12e6ca39dc75 Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期二, 02 十二月 2025 17:15:40 +0800
Subject: [PATCH] 1.新增获取巡检单所有不良描述
---
StandardPda/MESApplication/Controllers/QC/SJController.cs | 85 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 85 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MESApplication/Controllers/QC/SJController.cs b/StandardPda/MESApplication/Controllers/QC/SJController.cs
index 33fa226..7ac7a40 100644
--- a/StandardPda/MESApplication/Controllers/QC/SJController.cs
+++ b/StandardPda/MESApplication/Controllers/QC/SJController.cs
@@ -6,9 +6,12 @@
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
+using SixLabors.ImageSharp.Drawing;
+using SqlSugar;
using System.Collections.Generic;
using System.Data;
using System.Dynamic;
+using DbType = System.Data.DbType;
namespace MESApplication.Controllers.QC;
@@ -447,7 +450,79 @@
dynamic resultInfos = new ExpandoObject();
var tbBillList = new SJService().SJQaSubmit(rkjDto);
resultInfos.tbBillList = tbBillList;
+ //================= 鍒ゆ柇妫�楠屽悎鏍肩敓鎴愬贰妫�鍗� =========
+ var sqlPass1 = $@"
+ SELECT
+ IS_PASS
+ FROM QS_ITEM_IPI_REQ
+ WHERE ID = '{rkjDto.gid}'
+ ";
+ var dtPass1 = SQLHelper.ExecuteQuery(sqlPass1);
+
+ var sqlPass3 = $@"select C.ID from QS_ITEM_IPI_REQ A
+LEFT JOIN V_MES_SJ B on b.BILL_NO = A.BILL_NO
+LEFT JOIN WOMDAA C on C.DAA001 = B.DAA001
+WHERE A.ID = '{rkjDto.gid}'
+";
+
+ var dtPass3 = SQLHelper.ExecuteQuery(sqlPass3);
+
+ var value4 = dtPass3.Rows[0][0];
+ int sqlPass2 = Convert.ToInt32(value4);
+
+
+ bool isPass = false;
+
+ if (dtPass1 != null && dtPass1.Rows.Count > 0)
+ {
+ var value = dtPass1.Rows[0]["IS_PASS"]?.ToString();
+
+ // 鍒ゆ柇涓哄悎鏍硷紙IS_PASS = 1锛�
+ if (value == "1")
+ {
+ isPass = true;
+ }
+ }
+
+ // 濡傛灉鍚堟牸锛屾墽琛屽瓨鍌ㄨ繃绋�
+ if (isPass)
+ {
+ var db = SqlSugarHelper.GetInstance();
+
+ // ===== 杈撳嚭鍙傛暟 =====
+ var outFlag = new SugarParameter("P_FLAG", null,
+ DbType.Int32, ParameterDirection.Output, 10);
+
+ var outText = new SugarParameter("P_TEXT", null,
+ DbType.String, ParameterDirection.Output, 4000);
+
+ // ===== 杈撳叆鍙傛暟 =====
+ var parameters = new List<SugarParameter>
+ {
+ new SugarParameter("P_ID", sqlPass2, DbType.Int64, ParameterDirection.Input),
+ new SugarParameter("P_USER", rkjDto.userNo, DbType.String, ParameterDirection.Input),
+ new SugarParameter("P_ISH", 0, DbType.Int64, ParameterDirection.Input),
+
+ // 杈撳嚭鍙傛暟蹇呴』甯︿笂
+ outFlag,
+ outText
+ };
+
+ // ===== 鎵ц瀛樺偍杩囩▼ =====
+ db.Ado.ExecuteCommand(
+ "BEGIN PRC_XJ_GENERATE(:P_ID, :P_USER, :P_ISH, :P_FLAG, :P_TEXT); END;",
+ parameters);
+
+ // ===== 璇诲彇杈撳嚭鍙傛暟骞惰浆鎹㈡垚 ResponseResult =====
+ var result = new ResponseResult
+ {
+ status = outFlag.Value?.ToString() == "1" ? 1 : 0, // 0 琛ㄧず鎴愬姛锛�1 琛ㄧず澶辫触
+ message = outText.Value?.ToString()
+ };
+
+ return result;
+ }
return new ResponseResult
{
status = 0,
@@ -455,6 +530,7 @@
data = resultInfos
};
}
+
catch (Exception ex)
{
return ResponseResult.ResponseError(ex);
@@ -462,6 +538,15 @@
}
+
+
+
+
+
+
+
+
+
/// <summary>
/// 鑾峰彇涓�鑷存�ф牳瀵归」鐩�
/// </summary>
--
Gitblit v1.9.3