From ebfaee5cff4080a59ee294fced93bbdcf659348b Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期三, 20 十月 2021 22:12:01 +0800
Subject: [PATCH] 用户关联供应商基础资料

---
 WebAPI/Controllers/PublicPageMethodController.cs |   49 ++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 44 insertions(+), 5 deletions(-)

diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs
index 95086de..c9f1e67 100644
--- a/WebAPI/Controllers/PublicPageMethodController.cs
+++ b/WebAPI/Controllers/PublicPageMethodController.cs
@@ -122,9 +122,9 @@
 
         #endregion
 
-        #region 閫夋嫨鐢ㄦ埛鍩虹璧勬枡
+        #region 閫夋嫨鑱屽憳鍩虹璧勬枡
 
-        #region 鏉′欢鏌ヨ鐢ㄦ埛鍒楄〃
+        #region 鏉′欢鏌ヨ鑱屽憳鍒楄〃
         [Route("PublicPageMethod/UserList")]
         [HttpGet]
         public object UserList(string sWhere)
@@ -161,7 +161,7 @@
         }
         #endregion
 
-        #region  鏍规嵁鏍戝瀷id鏌ユ壘鐢ㄦ埛鍒楄〃   
+        #region  鏍规嵁鏍戝瀷id鏌ユ壘鑱屽憳鍒楄〃   
         [Route("Gy_MaintenanceMode/UserCX")]
         [HttpGet]
         public object UserCX(long HInterID)
@@ -198,7 +198,7 @@
         }
         #endregion
 
-        #region 鏍戝瀷鍒楄〃鐢ㄦ埛鍒楄〃鏁版嵁    
+        #region 鏍戝瀷鍒楄〃鑱屽憳鍒楄〃鏁版嵁    
         [Route("Gy_MaintenanceMode/UserLoadTree")]
         [HttpGet]
         public object UserLoadTree(string sWhere)
@@ -3097,7 +3097,46 @@
 
         #endregion
 
-       
+        #region 閫夋嫨鐢ㄦ埛鍩虹璧勬枡
 
+        #region 鏉′欢鏌ヨ鐢ㄦ埛鍒楄〃
+        [Route("PublicPageMethod/PeopleList")]
+        [HttpGet]
+        public object PeopleList(string sWhere)
+        {
+            try
+            {
+
+                ds = oCN.RunProcReturn("Select czybm HNumber,czymc HName from h_v_Gy_UserList " + sWhere + " Order by czybm ", "h_v_Gy_UserList");
+                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 = "Sucess锛�";
+                    objJsonResult.data = ds.Tables[0];
+                    return objJsonResult;
+                }
+            }
+            catch (Exception e)
+            {
+                objJsonResult.code = "0";
+                objJsonResult.count = 0;
+                objJsonResult.Message = "Exception锛�" + e.ToString();
+                objJsonResult.data = null;
+                return objJsonResult;
+            }
+        }
+
+        #endregion
+
+        #endregion
     }
 }

--
Gitblit v1.9.1