From 0aa54059b26e6641196e9953490dd18616e916e3 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 10 九月 2025 17:26:47 +0800
Subject: [PATCH] 精简修正代码
---
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 a9b21c6..f52146e 100644
--- a/service/Warehouse/MesOaToMesManager.cs
+++ b/service/Warehouse/MesOaToMesManager.cs
@@ -3,9 +3,7 @@
using Masuit.Tools;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
-using NewPdaSqlServer.entity;
-using NewPdaSqlServer.entity.Base;
-using SqlSugar;
+using NewPdaSqlServer.util;
namespace NewPdaSqlServer.service.Warehouse;
@@ -19,14 +17,15 @@
{
// 鍙傛暟鏍￠獙澧炲己
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
@@ -58,27 +57,28 @@
{
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
- SqlParameter[] parameters =
+ SqlParameter[] parameters =
{
- 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)
+ 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)
};
cmd.Parameters.AddRange(parameters);
cmd.ExecuteNonQuery();
_intSum += (int)parameters[1].Value;
if ((int)parameters[1].Value <= 0)
- {
throw new Exception(parameters[0].Value.ToString());
- }
}
- string rtnMsg = $"{query.iqcExNo}瀹℃壒鎺ㄩ�丮ES鎴愬姛锛�";
+
+ var rtnMsg = $"{query.iqcExNo}瀹℃壒鎺ㄩ�丮ES鎴愬姛锛�";
return rtnMsg;
}
@@ -110,29 +110,29 @@
try
{
conn.Open();
- int inFieldValue = 0;
+ var inFieldValue = 0;
cmd.CommandType = CommandType.StoredProcedure;
- SqlParameter[] parameters =
+ SqlParameter[] parameters =
{
- 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)
+ 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)
};
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