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 | 36 ++++++++++++++++++++++++++++++++++-- 1 files changed, 34 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 8ef882c..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) { @@ -10330,6 +10331,37 @@ } + /// <summary> + /// 鑾峰彇閫夊崟鍙风殑婧愬崟绫诲瀷 + /// </summary> + /// <returns></returns> + [Route("Web/GetHSourceBillName")] + [HttpGet] + public object GetHSourceBillName(string HBillType) + { + try + { + ClsCN oCn = new ClsCN(); + DataSet oDs = new DataSet(); + //========== + oDs = oCn.RunProcReturn("select * from xt_BillType where HNumber='" + HBillType + "'", "xt_BillType"); + objjson.code = "1"; + objjson.count = 1; + objjson.Message = "鑾峰彇鎴愬姛锛�"; + objjson.data = oDs.Tables[0]; + return objjson; ; + } + catch (Exception e) + { + + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触锛佸紓甯�" + e.ToString(); + objjson.data = null; + return objjson; ; + } + } + #region [浠庢暟鎹簱鍔犺浇鑿滃崟] public class MenuLoad { -- Gitblit v1.9.1