From 006bdc80aaef11128f85c66406dda178b2a296f3 Mon Sep 17 00:00:00 2001 From: yxj <yxj@hz-kingdee.com> Date: 星期四, 06 七月 2023 14:21:10 +0800 Subject: [PATCH] 采购入库上传方法日期递入值修改 --- 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