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