From bb8b85d77d5001adb3d2a55639a264e666d03b18 Mon Sep 17 00:00:00 2001 From: llj <132905093+newwwwwwtree@users.noreply.github.com> Date: 星期四, 07 八月 2025 11:23:44 +0800 Subject: [PATCH] 11 --- WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs | 7 +++++++ 1 files changed, 7 insertions(+), 0 deletions(-) diff --git a/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs b/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs index 48342c9..f819add 100644 --- a/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs +++ b/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs @@ -137,6 +137,13 @@ omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCn.BeginTran(); + DataSet _ds = oCn.RunProcReturn("select HInterID from Sb_EquipMaintainRuleBillMain where HBillNo = N'" + omodel.HBillNo + "'", "Sb_EquipMaintainRuleBillMain"); + if(_ds.Tables[0].Rows.Count > 0) + { + sReturn = "鍗曟嵁鍙烽噸澶嶏紒"; + oCn.RollBack(); + return false; + } //涓昏〃 oCn.RunProc("Insert Into Sb_EquipMaintainRuleBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + -- Gitblit v1.9.1