From d586211dd69b25e73593576b1a36616a2ae294b7 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期一, 10 三月 2025 19:15:52 +0800 Subject: [PATCH] 仓库列表 增加 仓库类型字段 班次 ,,点检项目,维修项目,维修验收项目,设备档案,器具主档维护,检验项目分类,检验项目,检验值,检验仪器,异常反馈类型,工艺路线大类,维修验收项目分类,维修项目分类,保养项目分类 审核 反审核 禁用 反禁用 删除前 删除后 控制 增加页签 增加字段 增加点检项目分类字段 保养项目 维修项目 维修验收项目 增加树形图 --- WebAPI/Controllers/PublicPageMethodController.cs | 61 ++++++++++++++++++++++++++++++ 1 files changed, 60 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs index 45881d2..d6dfe93 100644 --- a/WebAPI/Controllers/PublicPageMethodController.cs +++ b/WebAPI/Controllers/PublicPageMethodController.cs @@ -918,6 +918,35 @@ return objJsonResult; } } + + [Route("PublicPageMethod/Gy_RepairList_PDA")] + [HttpGet] + public object Gy_RepairList_PDA(string sWhere) + { + try + { + if (sWhere != "" && sWhere != null) + { + sWhere = " and ( HNumber like '%" + sWhere + "%' or HName like '%" + sWhere + "%' ) "; + } + string sql1 = string.Format(@"Select HItemID,HParentID,HNumber,HName from Gy_Repair where HStopflag=0"); + ds = oCN.RunProcReturn(sql1 + sWhere + " order by HItemID ", "Gy_Repair"); + + 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鏌ユ壘缁翠慨椤圭洰鍒楄〃 @@ -1365,7 +1394,37 @@ return objJsonResult; } } - #endregion + //鏁呴殰鍘熷洜椤甸潰浼樺寲鍚庢煡璇� 20250113 + [Route("PublicPageMethod/Gy_ConkReasonList_PDA")] + [HttpGet] + public object List_PDA(string sWhere) + { + try + { + if (sWhere != "" && sWhere != null) + { + sWhere = " and ( HNumber like '%" + sWhere + "%' or HName like '%" + sWhere + "%' ) "; + } + string sql1 = string.Format(@"Select HItemID,HParentID,HNumber,HName from Gy_ConkReason where HStopflag=0"); + ds = oCN.RunProcReturn(sql1 + sWhere + " order by HItemID ", "Gy_ConkReason"); + + 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/FaultReasonCX")] -- Gitblit v1.9.1