From 52843c5560ea2e91b8f79c7ce28b762aadf3ee7a Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期四, 30 六月 2022 12:26:29 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/基础资料/基础资料/Gy_DotCheckBillController.cs | 44 +++++++++++++++++++++++--------------------- 1 files changed, 23 insertions(+), 21 deletions(-) diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_DotCheckBillController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_DotCheckBillController.cs" index 11b7e70..562e9ca 100644 --- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_DotCheckBillController.cs" +++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_DotCheckBillController.cs" @@ -29,7 +29,7 @@ { try { - if (!DBUtility.ClsPub.Security_Log("Gy_DotCheck", 1, true, user)) + if (!DBUtility.ClsPub.Security_Log("Gy_DotCheck", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -37,23 +37,24 @@ objJsonResult.data = null; return objJsonResult; } - ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_DotCheck where 1=1 " + sWhere, "Gy_DotCheck"); - if (ds == null || ds.Tables[0].Rows.Count == 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鏃犱繚鍏婚」鐩暟鎹紒"; - objJsonResult.data = null; - return objJsonResult; - } - else - { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "鏌ユ壘鎴愬姛锛�"; - objJsonResult.data = ds.Tables[0]; - return objJsonResult; - } + ds = oCN.RunProcReturn("select HItemID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_DotCheck where 1=1 " + sWhere+ " order by HNumber", "Gy_DotCheck"); + + //if (ds.Tables[0].Rows.Count != 0 || ds != null) + //{ + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + //} + //else + //{ + //objJsonResult.code = "0"; + //objJsonResult.count = 0; + //objJsonResult.Message = "鏃犳暟鎹�"; + //objJsonResult.data = null; + //return objJsonResult; + //} } catch (Exception e) { @@ -74,7 +75,7 @@ try { - if (!DBUtility.ClsPub.Security_Log("Gy_DotCheck", 1, true, User)) + if (!DBUtility.ClsPub.Security_Log("Gy_DotCheck_Delete", 1, false, User)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -82,6 +83,7 @@ objJsonResult.data = null; return objJsonResult; } + ds = oCN.RunProcReturn("Select * from Gy_DotCheck Where HItemID='" + HItemID + "'", "Gy_DotCheck", ref DBUtility.ClsPub.sExeReturnInfo); if (ds.Tables[0].Rows.Count != 0) { @@ -167,7 +169,7 @@ string HUseFlag = list[0].HUseFlag; //鍒ゆ柇鏉冮檺 - if (!ClsPub.Security_Log("Gy_DotCheck", 1, true, msg4)) + if (!ClsPub.Security_Log("Gy_DotCheck_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -257,7 +259,7 @@ bool HEndFlag = list[0].HEndFlag; //鍒ゆ柇鏉冮檺 - if (!ClsPub.Security_Log("Gy_DotCheck", 1, true, msg3)) + if (!ClsPub.Security_Log("Gy_DotCheck_Edit", 1, false, msg3)) { objJsonResult.code = "0"; objJsonResult.count = 0; -- Gitblit v1.9.1