From 4ab7a22f8049a160e6fe847f0c12af8d2290dfef Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期一, 06 五月 2024 13:34:44 +0800 Subject: [PATCH] 销售订单:查询时、获取编辑数据时,根据子表id升序排列 --- 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