From eb65436c2312821e3e513ab9ada41dd486d6d7cf Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 09 九月 2025 15:35:41 +0800
Subject: [PATCH] 同步为祈禧的代码
---
WebApi/GS.QC/Service/MesQcExceptionalManager.cs | 111 ++-----------------------------------------------------
1 files changed, 4 insertions(+), 107 deletions(-)
diff --git a/WebApi/GS.QC/Service/MesQcExceptionalManager.cs b/WebApi/GS.QC/Service/MesQcExceptionalManager.cs
index 2474328..2ef1c13 100644
--- a/WebApi/GS.QC/Service/MesQcExceptionalManager.cs
+++ b/WebApi/GS.QC/Service/MesQcExceptionalManager.cs
@@ -1,14 +1,12 @@
-锘縰sing Gs.Toolbox;
+锘縰sing System.Data;
+using System.Data.SqlClient;
+using System.Dynamic;
+using Gs.Toolbox;
using Gs.Toolbox.ApiCore.Abstract.Mvc;
using Gs.Toolbox.ApiCore.Common.Mvc;
using Gs.Toolbox.ApiCore.Group;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
-using Newtonsoft.Json.Linq;
-using System.Data;
-using System.Data.SqlClient;
-using System.Dynamic;
-using System.Text;
using static Gs.Toolbox.UtilityHelper;
namespace Gs.Wom.Service;
@@ -185,107 +183,6 @@
}
}
return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "鎿嶄綔鎴愬姛锛�");
- }
-
- /// <summary>
- /// 澧炲姞鎴栫紪杈戝疄浣�-浠呭鐞嗘槑缁嗘暟鎹殑缂栬緫鎿嶄綔
- /// </summary>
- /// <param name="model">鍖呭惈鏄庣粏鍒楄〃鐨勬ā鍨�</param>
- /// <returns>澶勭悊缁撴灉</returns>
- [RequestMethod(RequestMethods.POST)]
- public ReturnDto<ExpandoObject> EditModel([FromBody] dynamic model)
- {
- // 鍒濆鍖栧瓧绗︿覆鏋勫缓鍣ㄥ鐞嗘槑缁嗘暟鎹�
- Guid? guid = model.guid; //涓婚敭
- var _sb = new StringBuilder();
- var _split = "|"; // 瀛楁鍒嗛殧绗�
- var _lineSeparator = "~"; // 琛屽垎闅旂
-
- // 澶勭悊鏄庣粏鍒楄〃锛岃浆鎹负瀛樺偍杩囩▼鎵�闇�鏍煎紡
- foreach (var m in model.list)
- {
- // 鑾峰彇鏄庣粏椤逛富閿紙鍙负绌猴紝鏂板鏃朵负绌猴級
- string _guid = m.Guid?.ToString() ?? Guid.Empty.ToString();
-
-
- // 鎷兼帴鍗曡鏄庣粏鏁版嵁锛殀鐢宠鏁伴噺|澶囨敞|鏄庣粏GUID
- var _line = m.BatchQty + _split + m.GfRkqty + _split + m.LfRkqtyz + _split + m.HandResult + _split
- + m.ChooseType + _split + m.Process + _split
- + (UtilityHelper.CheckGuid(_guid) ? _guid : Guid.Empty.ToString());
-
- // 澶氭潯鏄庣粏闂存坊鍔犲垎闅旂
- if (_sb.Length > 0)
- _sb.Append(_lineSeparator);
- _sb.Append(_line);
- }
-
- // 鍑嗗杩斿洖缁撴灉瀵硅薄
- dynamic mObj = new ExpandoObject();
- mObj.outMsg = ""; // 鎿嶄綔娑堟伅
- mObj.outSum = -1; // 鎿嶄綔缁撴灉鐘舵�侊紙-1琛ㄧず澶辫触锛�
- mObj.outGuid = ""; // 鍙繚鐣欑敤浜庤繑鍥炴槑缁嗙浉鍏崇殑GUID
- mObj.outNo = ""; // 鍙繚鐣欑敤浜庤繑鍥炴槑缁嗙浉鍏崇殑缂栧彿
-
- // 璋冪敤瀛樺偍杩囩▼澶勭悊鏄庣粏鏁版嵁
- using (var conn = new SqlConnection(DbHelperSQL.strConn))
- {
- using (var cmd = new SqlCommand("[prc_Qcyc_edt]", conn)) // 寤鸿淇敼瀛樺偍杩囩▼鍚嶄负鏄庣粏涓撶敤
- {
- try
- {
- conn.Open();
- cmd.CommandType = CommandType.StoredProcedure;
-
- // 瀹氫箟瀛樺偍杩囩▼鍙傛暟锛堜粎淇濈暀涓庢槑缁嗙浉鍏崇殑鍙傛暟锛�
- SqlParameter[] parameters =
- {
- new("@outMsg", SqlDbType.NVarChar, 300), // 杈撳嚭锛氭搷浣滄秷鎭�
- new("@outSum", SqlDbType.Int), // 杈撳嚭锛氱粨鏋滅姸鎬侊紙>0琛ㄧず鎴愬姛锛�
- new("@outGuid", SqlDbType.UniqueIdentifier),// 杈撳嚭锛氬彲杩斿洖澶勭悊鍚庣殑鏄庣粏鍏宠仈ID
- new("@outNo", SqlDbType.NVarChar, 300), // 杈撳嚭锛氬彲杩斿洖鏄庣粏鐩稿叧缂栧彿
- new("@inOrderGuid",UtilityHelper.CheckGuid(guid)? guid : DBNull.Value),//涓昏〃GUID
- new("@inEdtUserGuid", _userGuid), // 杈撳叆锛氭搷浣滅敤鎴稧UID
- new("@inLineList", _sb.ToString()) // 杈撳叆锛氬鐞嗗悗鐨勬槑缁嗗瓧绗︿覆
- };
-
- // 璁剧疆杈撳嚭鍙傛暟鏂瑰悜
- parameters[0].Direction = ParameterDirection.Output;
- parameters[1].Direction = ParameterDirection.Output;
- parameters[2].Direction = ParameterDirection.Output;
- parameters[3].Direction = ParameterDirection.Output;
-
- // 娣诲姞鍙傛暟鍒板懡浠ゅ璞�
- foreach (var parameter in parameters)
- cmd.Parameters.Add(parameter);
-
- // 鎵ц瀛樺偍杩囩▼
- cmd.ExecuteNonQuery();
-
- // 浠庤緭鍑哄弬鏁拌幏鍙栫粨鏋�
- mObj.outMsg = parameters[0].Value?.ToString() ?? "澶勭悊鎴愬姛";
- mObj.outSum = int.TryParse(parameters[1].Value?.ToString(), out int sum) ? sum : -1;
- mObj.outGuid = parameters[2].Value?.ToString() ?? "";
- mObj.outNo = parameters[3].Value?.ToString() ?? "";
- }
- catch (Exception ex)
- {
- // 璁板綍寮傚父鏃ュ織
- LogHelper.Debug(ToString(), $"澶勭悊鏄庣粏鏃跺嚭閿欙細{ex.Message}");
- mObj.outMsg = ex.Message;
- mObj.outSum = -1;
- }
- finally
- {
- conn.Close();
- }
- }
- }
-
- // 鏍规嵁澶勭悊缁撴灉杩斿洖瀵瑰簲鐘舵��
- if (mObj.outSum <= 0)
- return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg);
-
- return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg);
}
--
Gitblit v1.9.3