From bc1dda419b3cef845ed90f6c31c6bda82743e19a Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 07 三月 2024 10:19:16 +0800
Subject: [PATCH] 器具档案列表 增加 左边树形 器具分类,点击分类,根据分类来过滤,方便选择  器具档案里,增加字段 HMouldClass varchar(50) 器具类型 下拉框 (模具、工装、夹具、刀具、检具、周转器具、其他)

---
 WebAPI/Controllers/WebAPIController.cs |    5 +++--
 1 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index c82d6ef..abc503b 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -9984,7 +9984,7 @@
         /// <returns></returns>
         [Route("Web/GetItemByEquipFile")]
         [HttpGet]
-        public object GetItemByEquipFile(int EquipProjectID,string Type)
+        public object GetItemByEquipFile(int EquipProjectID,string Type,string HDate)
         {
             if (EquipProjectID <= 0)
             {
@@ -10014,7 +10014,8 @@
                 }
 
                 SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
-                string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID);
+                //string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID);
+                string sql = string.Format(@"Exec h_p_Sb_GetCheckItem_PDA '" + EquipProjectID + "','" + Type + "','" + HDate + "'");
                 ds = oCN.RunProcReturn(sql, HView);
                 if (ds == null || ds.Tables[0].Rows.Count <= 0)
                 {

--
Gitblit v1.9.1