From 6773d107b6d63e8db137e415035a5c14d6b9ba89 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期二, 28 十一月 2023 12:09:50 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs | 41 +++++++++++++++++++++++++++++++++++++++++ 1 files changed, 41 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs index d2be264..f845d74 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs @@ -413,6 +413,45 @@ } #endregion + #region[璁惧淇濆吇璁″垝琛ㄧ紪杈戞椂鑾峰彇琛ㄤ綋鏁版嵁--淇濆吇璁″垝] + [Route("Sb_EquipMaintainPlanBill/GetPlanList")] + [HttpGet] + public object GetPlanList(string sqlWhere) + { + DataSet ds; + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + if (sqlWhere == null || sqlWhere.Equals("")) + { + ds = oCN.RunProcReturn("select * from h_v_Sb_EquipMaintainPlanList", "h_v_Sb_EquipMaintainPlanList"); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.data = ds.Tables[0]; + } + else + { + string sql1 = "select * from h_v_Sb_EquipMaintainPlanList where 1 = 1 "; + string sql = sql1 + sqlWhere; + ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipMaintainPlanList"); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.data = ds.Tables[0]; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁″垝锛�" + e.ToString(); + objJsonResult.data = null; + } + return objJsonResult; + } + #endregion + #region 璁惧淇濆吇璁″垝鍗曞鏍�/鍙嶅鏍稿姛鑳� [Route("Sb_EquipMaintainPlanBill/CheckSb_EquipMaintainPlanBill")] [HttpGet] @@ -453,6 +492,8 @@ objJsonResult.data = null; return objJsonResult; } + //鑷姩鐢熸垚鐐规璁″垝鍗� + oCN.RunProc("exec h_p_Sb_EquipMaintainPlan_Auto " + HInterID); } else { -- Gitblit v1.9.1