From 612b2285b823072809d811d456787432a3234fc3 Mon Sep 17 00:00:00 2001
From: zyf <1071160500@qq.com>
Date: 星期五, 21 十一月 2025 15:04:19 +0800
Subject: [PATCH] 首检巡检功能优化
---
MES.Service/service/QC/SJService.cs | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/MES.Service/service/QC/SJService.cs b/MES.Service/service/QC/SJService.cs
index 48017cf..cfa9c93 100644
--- a/MES.Service/service/QC/SJService.cs
+++ b/MES.Service/service/QC/SJService.cs
@@ -550,6 +550,24 @@
// withOracle += autoResult(detail);
+ var db = SqlSugarHelper.GetInstance();
+ // 鍒涘缓鍙傛暟
+ var FId= new SugarParameter("P_ID", detail.Gid);
+
+ // 杈撳嚭鍙傛暟
+ var FRes = new SugarParameter("c_result", null, true);
+ var FMsg = new SugarParameter("c_msg", null, true);
+
+ // 鎵ц瀛樺偍杩囩▼
+ db.Ado.UseStoredProcedure().GetDataTable("PRC_SJ_UPDATE_RESU", FId, FRes, FMsg);
+
+ // 鑾峰彇杈撳嚭缁撴灉
+ var Res = Convert.ToInt32(FRes.Value);
+ var Msg = FMsg.Value?.ToString();
+
+ Console.WriteLine($"缁撴灉: {Res}, 杩斿洖娑堟伅: {Msg}");
+
+
return withOracle;
}
@@ -685,6 +703,15 @@
/// <returns>鏇存柊褰卞搷鐨勮鏁�</returns>
public int UpdateQsItemIpiItemIsPass(decimal id, decimal isPass)
{
+ SqlSugarHelper.UseTransactionWithOracle(db =>
+ {
+ return db.Updateable<QsItemIpiItemDetail>()
+ .SetColumns(s => s.FcheckResu == isPass.ToString())
+ .SetColumns(s => s.Fstand == ((isPass == 1) ? "鈭�" : "0"))
+ .Where(s => s.Pid == id)
+ .ExecuteCommand();
+ });
+
return SqlSugarHelper.UseTransactionWithOracle(db =>
{
return db.Updateable<QsItemIpiItem>()
@@ -692,6 +719,8 @@
.Where(s => s.Id == id)
.ExecuteCommand();
});
+
+
}
/// <summary>
--
Gitblit v1.9.3