From 179635da5c03219f833cc145595369d2e9b85e14 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期四, 31 十月 2024 16:38:31 +0800 Subject: [PATCH] 工序返工申请单:增加字段 HBillOperationType 审核时根据HBillOperationType进行相关反写 --- WebAPI/Controllers/BaseSet/Gy_MaintenanceAcceptItemController.cs | 7 ++++--- 1 files changed, 4 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_MaintenanceAcceptItemController.cs b/WebAPI/Controllers/BaseSet/Gy_MaintenanceAcceptItemController.cs index eaf0ba1..7a2c41f 100644 --- a/WebAPI/Controllers/BaseSet/Gy_MaintenanceAcceptItemController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_MaintenanceAcceptItemController.cs @@ -81,7 +81,8 @@ try { - ds = oCN.RunProcReturn("select * from h_v_IF_RepairCheckList where HitemID=" + HInterID, "h_v_IF_RepairCheckList"); + //ds = oCN.RunProcReturn("select * from h_v_IF_RepairCheckList where HitemID=" + HInterID, "h_v_IF_RepairCheckList"); + ds = oCN.RunProcReturn(string.Format(@"WITH a AS (SELECT * FROM dbo.h_v_IF_RepairCheckList WHERE HitemID=" + HInterID + " UNION ALL SELECT s.* FROM dbo.h_v_IF_RepairCheckList AS s,a WHERE s.parentid=a.HitemID) SELECT * FROM a"), "h_v_IF_RepairCheckList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; @@ -122,7 +123,7 @@ DAL.ClsGy_RepairCheck_View oDeptHlp = new DAL.ClsGy_RepairCheck_View(); try { - if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, User)) + if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, User)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -314,7 +315,7 @@ //鍒ゆ柇鏉冮檺 - if (!ClsPub.Security_Log(msg5, 1, true, msg4)) + if (!ClsPub.Security_Log(msg5, 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; -- Gitblit v1.9.1