From 89793cb2f9d4eb80582d0b5dda465881ff9a8382 Mon Sep 17 00:00:00 2001 From: chenhaozhe <cgz@hz-kingdee.com> Date: 星期三, 21 五月 2025 19:58:54 +0800 Subject: [PATCH] feat: 系统参数 Xt_SystemParameter 添加删除方法 Xt_SystemParameterDelete --- WebAPI/Controllers/BaseSet/Gy_ProcessController.cs | 27 +++++++++++++++++++++++++-- 1 files changed, 25 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs b/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs index 4d21c5d..a6522b0 100644 --- a/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs @@ -771,6 +771,18 @@ if (HItemID == 0) { oCN.BeginTran(); + //鍒ゆ柇浠g爜鏄惁閲嶅 + DataSet dss; + dss = oCN.RunProcReturn("select * from Gy_Process where HNumber='" + HNumber + "'", "Gy_Process"); + //鍒ゆ柇鏄惁鍙紪杈� + if (dss.Tables[0].Rows.Count!=0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁浠g爜閲嶅涓嶅厑璁告柊澧�"; + objJsonResult.data = null; + return objJsonResult; + } //淇濆瓨鍓嶆帶鍒�========================================= string sql1 = "exec h_p_Gy_Process_BeforeSaveCtrl " + HMakeEmp + ",'" + 1 + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Gy_Process_BeforeSaveCtrl"); @@ -845,7 +857,18 @@ { //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCN.BeginTran(); - + //宸插鏍镐笉鍏佽淇敼 + DataSet dss; + dss = oCN.RunProcReturn("select * from Gy_Process where HItemID=" + HItemID, "Gy_Process"); + //鍒ゆ柇鏄惁鍙紪杈� + if (dss.Tables[0].Rows[0]["HCheckEmp"].ToString() != "" ) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹姸鎬佸凡缁忓鏍革紝涓嶅厑璁镐慨鏀癸紒"; + objJsonResult.data = null; + return objJsonResult; + } //淇濆瓨鍓嶆帶鍒�========================================= string sql1 = "exec h_p_Gy_Process_BeforeSaveCtrl " + HMakeEmp + ",'" + 2 + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Gy_Process_BeforeSaveCtrl"); @@ -880,7 +903,7 @@ ",HTypeCount= '" + HTypeCount + "'" + ",HDeptNumber='" + HDeptNumber + "'" + ",HSNo= " + HSNo + - ",HUseFlag= " + HUseFlag + + ",HUseFlag= '" + HUseFlag + "'" + ",HLevel= " + HLevel + ",HEndFlag= '" + HEndFlag + "'" + ",HTProcessFlag= '" + HTProcessFlag + "'" + -- Gitblit v1.9.1