From 00a72fff219241eb5b0405a066cc859d07cf7735 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 17 九月 2025 10:23:44 +0800
Subject: [PATCH] 1111
---
service/Warehouse/MesOaToMesManager.cs | 60 ++++++++++++++++++++++++++++++------------------------------
1 files changed, 30 insertions(+), 30 deletions(-)
diff --git a/service/Warehouse/MesOaToMesManager.cs b/service/Warehouse/MesOaToMesManager.cs
index f52146e..a9b21c6 100644
--- a/service/Warehouse/MesOaToMesManager.cs
+++ b/service/Warehouse/MesOaToMesManager.cs
@@ -3,7 +3,9 @@
using Masuit.Tools;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
-using NewPdaSqlServer.util;
+using NewPdaSqlServer.entity;
+using NewPdaSqlServer.entity.Base;
+using SqlSugar;
namespace NewPdaSqlServer.service.Warehouse;
@@ -17,15 +19,14 @@
{
// 鍙傛暟鏍￠獙澧炲己
if (query.iqcExNo.IsNullOrEmpty()) throw new Exception("寮傚父鍗曞彿涓嶅厑璁镐负绌�");
- if (query.dataJson == null || !query.dataJson.Any())
- throw new Exception("妫�楠屾暟鎹笉鑳戒负绌�");
+ if (query.dataJson == null || !query.dataJson.Any()) throw new Exception("妫�楠屾暟鎹笉鑳戒负绌�");
using (var cmd = new SqlCommand("[iqc_ycd_oa_mes]", conn))
{
try
{
conn.Open();
-
+
//// 鏍￠獙MES妫�楠屽崟
//var checkSql = @"SELECT B.releaseNo AS jydNo
// FROM Mes_QC_Exceptional_Detail B
@@ -57,28 +58,27 @@
{
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
- SqlParameter[] parameters =
+ SqlParameter[] parameters =
{
- new("@outMsg", SqlDbType.NVarChar, 150)
- { Direction = ParameterDirection.Output },
- new("@outSum", SqlDbType.Int)
- { Direction = ParameterDirection.Output },
- new("@ycdNo", query.iqcExNo),
- new("@jydNo", item.jyd),
- new("@xblb", item.xblb),
- new("@clyj", item.clyj),
- new("@jssl", item.jssl),
- new("@inFieldValue", 1)
+ new SqlParameter("@outMsg", SqlDbType.NVarChar, 150) { Direction = ParameterDirection.Output },
+ new SqlParameter("@outSum", SqlDbType.Int) { Direction = ParameterDirection.Output },
+ new SqlParameter("@ycdNo", query.iqcExNo),
+ new SqlParameter("@jydNo", item.jyd),
+ new SqlParameter("@xblb", item.xblb),
+ new SqlParameter("@clyj", item.clyj),
+ new SqlParameter("@jssl", item.jssl),
+ new SqlParameter("@inFieldValue", 1)
};
cmd.Parameters.AddRange(parameters);
cmd.ExecuteNonQuery();
_intSum += (int)parameters[1].Value;
if ((int)parameters[1].Value <= 0)
+ {
throw new Exception(parameters[0].Value.ToString());
+ }
}
-
- var rtnMsg = $"{query.iqcExNo}瀹℃壒鎺ㄩ�丮ES鎴愬姛锛�";
+ string rtnMsg = $"{query.iqcExNo}瀹℃壒鎺ㄩ�丮ES鎴愬姛锛�";
return rtnMsg;
}
@@ -110,29 +110,29 @@
try
{
conn.Open();
- var inFieldValue = 0;
+ int inFieldValue = 0;
cmd.CommandType = CommandType.StoredProcedure;
- SqlParameter[] parameters =
+ SqlParameter[] parameters =
{
- new("@outMsg", SqlDbType.NVarChar, 150)
- { Direction = ParameterDirection.Output },
- new("@outSum", SqlDbType.Int)
- { Direction = ParameterDirection.Output },
- new("@ycdNo", query.iqcExNo),
- new("@jydNo", DBNull.Value),
- new("@xblb", DBNull.Value),
- new("@clyj", DBNull.Value),
- new("@jssl", DBNull.Value),
- new("@inFieldValue", inFieldValue)
+ new SqlParameter("@outMsg", SqlDbType.NVarChar, 150) { Direction = ParameterDirection.Output },
+ new SqlParameter("@outSum", SqlDbType.Int) { Direction = ParameterDirection.Output },
+ new SqlParameter("@ycdNo", query.iqcExNo),
+ new SqlParameter("@jydNo", DBNull.Value),
+ new SqlParameter("@xblb", DBNull.Value),
+ new SqlParameter("@clyj", DBNull.Value),
+ new SqlParameter("@jssl", DBNull.Value),
+ new SqlParameter("@inFieldValue", inFieldValue)
};
cmd.Parameters.AddRange(parameters);
cmd.ExecuteNonQuery();
_intSum = (int)parameters[1].Value;
if (_intSum <= 0)
+ {
throw new Exception(parameters[0].Value.ToString());
-
+ }
+
return $"{query.iqcExNo}閫�鍥炴搷浣滄垚鍔燂紒褰卞搷璁板綍鏁帮細{_intSum}";
}
catch (Exception ex)
--
Gitblit v1.9.3