From 40154d1c7f35eb62e19e1c5901cfb288213980e3 Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期三, 18 六月 2025 20:25:19 +0800 Subject: [PATCH] 添加通用查询方法(一次查询多表) --- WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs b/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs index 0406334..f340c09 100644 --- a/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs +++ b/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs @@ -220,7 +220,7 @@ string BillType = "3843"; - if (OperationType == 1)//鏂板 + if (OperationType == 1 || OperationType == 2)//鏂板 { //淇濆瓨鍓嶆帶鍒� objJsonResult = BeforeSave_MouldRepairSendWorkBill(omodel.HInterID, omodel.HBillNo, 1); @@ -247,7 +247,6 @@ ",'" + omodel.HCycleUnit + "'," + omodel.HPlanTimes.ToString() + "," + omodel.HTimes.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + omodel.HMouldID.ToString() + ", " + omodel.HSupID.ToString() + ",'" + omodel.HRepairType + "','" + omodel.HNewModel + "'," + omodel.HNewDesignLife.ToString() + ",'" + omodel.HMainSourceBillType + "'," + omodel.HMainSourceInterID.ToString() + "," + omodel.HMainSourceEntryID.ToString() + - ",1) "); } else if (OperationType == 3) @@ -295,6 +294,7 @@ ",HNewDesignLife=" + omodel.HNewDesignLife.ToString() + " where HInterID=" + omodel.HInterID.ToString()); + //鍒犻櫎瀛愯〃 oCN.RunProc("delete from Sc_MouldRepairSendWorkBillSub where HInterID='" + omodel.HInterID.ToString() + "'"); } -- Gitblit v1.9.1