From e5e137185302c8a72d4aec22878c029137c4890e Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期五, 12 四月 2024 17:43:14 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/WebAPIController.cs | 49 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 49 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 18070fc..47dc70b 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -1281,6 +1281,55 @@ return objjson; } } + + + /// <summary> + /// 鑾峰彇鐢熶骇璧勬簮鍒楄〃 + /// </summary> + /// <returns></returns> + [Route("Web/GetSouceList_Json")] + [HttpGet] + public object GetSouceList_Json(string HMaterID,string Value, Int64 HOrgID) + { + sWhere = " and HStopFlag=0 and HUSEORGID =" + HOrgID + ""; + if (Value != "" && Value != null) + { + sWhere = sWhere + " and ( HNumber like '%" + Value + "%' or HName like '%" + Value + "%' or HUSEORGID like '%" + HOrgID + "%' ) "; + } + try + { + string sql = "EXEC h_p_Gy_SouceViewList " + HMaterID+",'"+ sWhere + "'"; + ds = oCN.RunProcReturn(sql, "h_p_Gy_SouceViewList"); + + 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 = "0"; + 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> -- Gitblit v1.9.1