From 3b3d2378bd52268dad426c70b853473eccee3b87 Mon Sep 17 00:00:00 2001 From: xwt <2740516069@qq.com> Date: 星期一, 15 九月 2025 09:24:03 +0800 Subject: [PATCH] 首检穴模数 --- StandardInterface/MES.Service/service/WomcaaManager.cs | 49 +++++++++++++++++++++++++------------------------ 1 files changed, 25 insertions(+), 24 deletions(-) diff --git a/StandardInterface/MES.Service/service/WomcaaManager.cs b/StandardInterface/MES.Service/service/WomcaaManager.cs index 84b5753..ef9344e 100644 --- a/StandardInterface/MES.Service/service/WomcaaManager.cs +++ b/StandardInterface/MES.Service/service/WomcaaManager.cs @@ -98,8 +98,30 @@ List<Womcab> mesWomcabs) { + //瀹氫箟杈撳叆鍙傛暟 + var inputParam1 = new SugarParameter("P_WORK_NO", mesWomcaa.Caa001); + // 瀹氫箟杈撳嚭鍙傛暟 + var outParam1 = new SugarParameter("c_Result", null, true); + var outParam2 = new SugarParameter("C_MSG", null, true); + // 浣跨敤 SqlSugar 鎵ц瀛樺偍杩囩▼ + Db.Ado.ExecuteCommand( + "BEGIN PRC_UPDATE_DAA2(:P_WORK_NO,:c_Result,:C_MSG); END;", + inputParam1, outParam1, outParam2); + // 鑾峰彇杈撳嚭鍙傛暟鐨勫�� + var result = int.Parse((string)outParam1.Value); + var message = outParam2.Value == DBNull.Value + ? string.Empty + : (string)outParam2.Value; + if (result == 1) + { + //瀛樺偍杩囩▼澶辫触鍒欎簨鍔¤繘琛屽洖婊� + db.Ado.RollbackTran(); + throw new Exception(message); + } - + // 鎻愪氦浜嬪姟 + db.Ado.CommitTran(); + var decimals = mesWomcabs.Select(s => s.Id).ToArray(); @@ -119,29 +141,7 @@ if (update && insertOrUpdate) { - //瀹氫箟杈撳叆鍙傛暟 - var inputParam1 = new SugarParameter("P_WORK_NO", mesWomcaa.Caa001); - // 瀹氫箟杈撳嚭鍙傛暟 - var outParam1 = new SugarParameter("c_Result", null, true); - var outParam2 = new SugarParameter("C_MSG", null, true); - // 浣跨敤 SqlSugar 鎵ц瀛樺偍杩囩▼ - Db.Ado.ExecuteCommand( - "BEGIN PRC_UPDATE_DAA2(:P_WORK_NO,:c_Result,:C_MSG); END;", - inputParam1, outParam1, outParam2); - // 鑾峰彇杈撳嚭鍙傛暟鐨勫�� - var result = int.Parse((string)outParam1.Value); - var message = outParam2.Value == DBNull.Value - ? string.Empty - : (string)outParam2.Value; - if (result == 1) - { - //瀛樺偍杩囩▼澶辫触鍒欎簨鍔¤繘琛屽洖婊� - db.Ado.RollbackTran(); - throw new Exception(message); - } - - // 鎻愪氦浜嬪姟 - db.Ado.CommitTran(); + return true; } throw new NotImplementedException("鏇存柊澶辫触"); @@ -278,6 +278,7 @@ Sjxs=dto.SJ_xs, Nextgx=dto.NEXT_Gx, Rks=dto.RKS, + Khwlbm=dto.KHWLBM, //娌冨皵鏂板 // WR_F_SCDD_SCTZD = dto.F_SCDD_SCTZD //WR_F_SCDD_XH = dto.F_SCDD_XH -- Gitblit v1.9.3