From 175b53e6f0adb40a0d861981f56f120615d55897 Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期三, 13 十一月 2024 14:52:31 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/LookingForBillController.cs | 46 ++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 46 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/LookingForBillController.cs b/WebAPI/Controllers/LookingForBillController.cs index 119212f..1118a59 100644 --- a/WebAPI/Controllers/LookingForBillController.cs +++ b/WebAPI/Controllers/LookingForBillController.cs @@ -339,6 +339,46 @@ } /// <summary> + /// 鏍规嵁浠撳簱浜岀淮鐮佷粨搴撶浉鍏充俊鎭� + /// </summary> + /// <returns></returns> + [Route("LookingFor/getWHName_Json")] + [HttpGet] + public object getWHName_Json(string HBarCode) + { + try + { + long HWHID = int.Parse(HBarCode.Remove(0, 3)); + string sWhere = " Where HItemID = " + HWHID + ""; + ds = getWhName_Json_s(sWhere); + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "杩斿洖璁板綍鎴愬姛锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + } + catch (Exception ex) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + + /// <summary> /// 鍚敤mes浠撲綅锛屾牴鎹�佷粨搴撹浆鎹㈡垚鏂颁粨搴� /// </summary> /// <returns></returns> @@ -530,6 +570,12 @@ return new SQLHelper.ClsCN().RunProcReturn("select HWHID,* from h_v_IF_StockPlace " + sWhere, "h_v_IF_StockPlace"); } + //鏍规嵁浠撳簱浜岀淮鐮佸甫鍑轰粨搴撶浉鍏充俊鎭� + public static DataSet getWhName_Json_s(string sWhere) + { + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_Warehouse " + sWhere, "h_v_IF_Warehouse"); + } + //鍚敤mes浠撲綅锛屾牴鎹�佷粨搴撹浆鎹㈡垚鏂颁粨搴� public static DataSet GetSpNameMES_Json_s(string HERPWHID) { -- Gitblit v1.9.1