From bb48e7fb2979e4cb57a2fe6b744ae58016936d25 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期三, 06 三月 2024 09:16:52 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- 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