From 18bf65577b174d574b36c5fb5ab4364a14c7724a Mon Sep 17 00:00:00 2001 From: yxj <yxj@hz-kingdee.com> Date: 星期三, 03 七月 2024 15:09:13 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/WebAPIController.cs | 97 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 96 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index e2c8636..b91b18a 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -119,7 +119,7 @@ //----------鍒涘缓铏氳〃------------------------ DataTable dt_Main = new DataTable("Json"); dt_Main.Columns.Add("HBillNo", typeof(string)); - dt_Main.Columns.Add("HInterID", typeof(int)); + dt_Main.Columns.Add("HInterID", typeof(Int64)); //---------鍒涘缓鏂拌------------------------ DataRow dr_main = dt_Main.NewRow();//鍒涘缓鏂拌 dt_Main.Rows.Add(dr_main);//灏嗘柊琛屽姞鍏ュ埌琛ㄤ腑 @@ -12580,6 +12580,101 @@ } } + /// <summary> + /// 鏍规嵁鍣ㄥ叿鐐规瑙勭▼鏄剧ず鍣ㄥ叿鐐规绋嬮」鐩� + /// </summary> + /// <returns></returns> + [Route("Web/GetDotCheckRuleItemByDotCheckRuleID/Mould")] + [HttpGet] + public object GetDotCheckRuleItemByDotCheckRuleIDForMould(int HDotCheckRuleInterID) + { + if (HDotCheckRuleInterID <= 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鍣ㄥ叿鐐规瑙勭▼鏈�夋嫨"; + objjson.data = null; + return objjson; + } + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + string sql = string.Format(@"select * from h_v_Sc_MouldDotCheckRuleBillList_PDA where HInterID=" + HDotCheckRuleInterID); + ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldDotCheckRuleBillList_PDA"); + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + DBUtility.ClsPub.sErrInfo; + objjson.data = null; + return objjson; + } + else + { + objjson.code = "1"; + objjson.count = 1; + objjson.Message = "鑾峰彇鎴愬姛!"; + objjson.data = ds.Tables[0]; + return objjson; + } + } + catch (Exception ex) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + ex.ToString(); + objjson.data = null; + return objjson; + } + } + + /// <summary> + /// 鏍规嵁鍣ㄥ叿淇濆吇瑙勭▼鏄剧ず鍣ㄥ叿淇濆吇绋嬮」鐩� + /// </summary> + /// <returns></returns> + [Route("Web/GetMaintainItemByMaintainRuleID/Mould")] + [HttpGet] + public object GetMaintainItemByMaintainRuleIDForMould(int HMouldMaintainRuleInterID) + { + if (HMouldMaintainRuleInterID <= 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鍣ㄥ叿淇濆吇瑙勭▼鏈�夋嫨"; + objjson.data = null; + return objjson; + } + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + string sql = string.Format(@"select * from h_v_Sb_MouldMaintainRuleBillList_PDA where HInterID=" + HMouldMaintainRuleInterID); + ds = oCN.RunProcReturn(sql, "h_v_Sb_MouldMaintainRuleBillList_PDA"); + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + DBUtility.ClsPub.sErrInfo; + objjson.data = null; + return objjson; + } + else + { + objjson.code = "1"; + objjson.count = 1; + objjson.Message = "鑾峰彇鎴愬姛!"; + objjson.data = ds.Tables[0]; + return objjson; + } + } + catch (Exception ex) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + ex.ToString(); + objjson.data = null; + return objjson; + } + } /// <summary> /// 鑾峰彇缁翠慨椤圭洰鍒楄〃 -- Gitblit v1.9.1