From 1413158ae9f0fc5ac7eb39deeab7d5cc09950ad1 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 01 二月 2024 10:57:51 +0800 Subject: [PATCH] 工序流转卡派工单删除方法,增加调用删除 前控制h_p_Sc_ProcExchSendWorkBill_BeforeDelCtrl 和删除 后控制h_p_Sc_ProcExchSendWorkBill_AfterDelCtrl 的存储过程。 工序委外派工单删除方法,增加 调用删除前控制h_p_WW_EntrustWorkOrderBill_BeforeDelCtrl 和删除后控制h_p_WW_EntrustWorkOrderBill_AfterDelCtrl 的存储过程。 工序进站接收单删除方法,增加调用删除前控制h_p_Sc_StationInBill_BeforeDelCtrl 和删除后控制h_p_Sc_StationInBill_AfterDelCtrl 的存储过程。 工序出站汇报单删除方法,增加调用删除前控制h_p_Sc_StationOutBill_BeforeDelCtrl 和删除后控制h_p_Sc_StationOutBill_AfterDelCtrl 的存储过程 --- WebAPI/Controllers/Open_PrintTemController.cs | 21 +++++++++++++++++++-- 1 files changed, 19 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/Open_PrintTemController.cs b/WebAPI/Controllers/Open_PrintTemController.cs index 12b2343..11ac7be 100644 --- a/WebAPI/Controllers/Open_PrintTemController.cs +++ b/WebAPI/Controllers/Open_PrintTemController.cs @@ -73,12 +73,20 @@ /// <returns></returns> [Route("Open_PrintTem/SaveOpenTmp")] [HttpGet] - public object SaveOpenTmp(string HNumber, string HName) + public object SaveOpenTmp(string HNumber, string HName,string user) { //ClsCNSRM oCn = new ClsCNSRM(); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { + if (!DBUtility.ClsPub.Security_Log("OpenPrintTmp_Edit", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } oCn.BeginTran(); oCn.RunProc("Insert into SRM_OpenTmp " + @@ -112,11 +120,20 @@ /// <returns></returns> [Route("Open_PrintTem/DelOpenTmp")] [HttpGet] - public object DelOpenTmp(string HItemID) + public object DelOpenTmp(string HItemID, string user) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { + if (!DBUtility.ClsPub.Security_Log("OpenPrintTmp_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + oCn.BeginTran(); oCn.RunProc("Delete from SRM_OpenTmp where HItemID='" + DBUtility.ClsPub.isLong(HItemID) + "'", ref DBUtility.ClsPub.sExeReturnInfo); oCn.Commit(); -- Gitblit v1.9.1