From 0aba0d5e0e3ae3570ac9f26440e9763a20d3721d Mon Sep 17 00:00:00 2001 From: black-goat-me <226547893@qq.com> Date: 星期三, 17 五月 2023 09:23:12 +0800 Subject: [PATCH] 按钮隐藏功能 --- WebAPI/Controllers/PublicPageMethodController.cs | 108 ++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 88 insertions(+), 20 deletions(-) diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs index 463036c..2c8564e 100644 --- a/WebAPI/Controllers/PublicPageMethodController.cs +++ b/WebAPI/Controllers/PublicPageMethodController.cs @@ -1481,6 +1481,48 @@ } #endregion + + + #region 鍑哄簱鐢宠鍗曟煡璇㈠垪琛� + [Route("OtherOutRequestBillList/CX")] + [HttpGet] + public object CX(string sWhere) + { + try + { + + string sql1 = "Select * from AIS20220914133941..T_STK_OUTSTOCKAPPLY where fdocumentstatus = 'C' and FCloseStatus = 'A'"; + string sql2 = "order by Fdate asc"; + string sql = sql1 + sWhere + sql2; + ds = oCN.RunProcReturn(sql, "T_STK_OUTSTOCKAPPLY"); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "false锛�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #region 鏍规嵁鏍戝瀷id鏌ユ壘璁惧鍒楄〃 [Route("Gy_MaintenanceMode/EqpCX")] [HttpGet] @@ -2028,7 +2070,7 @@ } else { - string sql1 = "Select HItemID,HParentID,HNumber,HName from h_v_IF_Unit "; + string sql1 = "Select HItemID,HParentID,HNumber,HName from h_v_IF_Unit "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_IF_Unit"); } @@ -2146,22 +2188,12 @@ string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_Property"); } - if (ds == null || ds.Tables[0].Rows.Count == 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "false锛�"; - objJsonResult.data = null; - return objJsonResult; - } - else - { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "Sucess锛�"; - objJsonResult.data = ds.Tables[0]; - return objJsonResult; - } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; } catch (Exception e) { @@ -3614,13 +3646,13 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrj where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrj"); + ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrjGroup"); } else { - string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrj where HStopflag=0 "; + string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 "; string sql = sql1 + sWhere; - ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrj"); + ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup"); } //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); @@ -3654,5 +3686,41 @@ } #endregion + #region 閫夋嫨宸ュ簭鍩虹璧勬枡 + [Route("PublicPageMethod/ProcessList")] + [HttpGet] + public object ProcessList(string sWhere) + { + try + { + ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_Process " + sWhere + " Order by HItemID", "Gy_Process"); + //if (ds == null || ds.Tables[0].Rows.Count == 0) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "false锛�"; + // objJsonResult.data = null; + // return objJsonResult; + //} + //else + //{ + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + //} + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + } } -- Gitblit v1.9.1