From 60c33d122fed78adebb7cb9e85ab8dff3d7aa72a Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期四, 12 六月 2025 16:26:25 +0800 Subject: [PATCH] 1 --- 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