From 8552aecdfdf50a4eba5bb5df30bc32c8f5882763 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期一, 18 十月 2021 11:06:34 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/WebAPIController.cs | 51 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 51 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 73c88c0..e783b85 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -1,6 +1,8 @@ 锘縰sing DAL; using DBUtility; using Model; +using Newtonsoft.Json; +using Newtonsoft.Json.Converters; using Newtonsoft.Json.Linq; using SQLHelper; using System; @@ -2195,6 +2197,55 @@ } } + + #region [鏌ヨ鑿滃崟鍒楄〃] + [Route("Web/MenuList")] + [HttpGet] + public object MenuList() + { + try + { + List<Menu> mu = new List<Menu>(); + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); + ds = oCn.RunProcReturn("Select * from Gy_Menu Order by HItemID ", "Gy_Menu"); + //List<Menu> mu1 = ds.Tables[0].AsEnumerable().Select(t => new Menu()).ToList(); + //List<Menu> users = ModelConvertHelper<Menu>.ConvertToModel(ds.Tables[0]); + //var dd = ToHierarchy.ToHierarchyList(users); + //string json = JsonConvert.SerializeObject(dd); + for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //杩欓噷鏄惊鐜墍鏈� + { + if (ds.Tables[0].Rows[i]["HPartentID"].ToString()=="0" || ds.Tables[0].Rows[i]["HitemID"].ToString() == ds.Tables[0].Rows[i]["HPartentID"].ToString()) //鍒ゆ柇鏄惁鏈�澶栧眰鏍硅妭鐐� + { + Menu tbj = new Menu(); + tbj.HitemID = ds.Tables[0].Rows[i]["HitemID"].ToString(); + tbj.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString(); + tbj.HName = ds.Tables[0].Rows[i]["HName"].ToString(); + tbj.HPartentID =ds.Tables[0].Rows[i]["HPartentID"].ToString(); + tbj.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString()); + tbj.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString(); + mu.Add(tbj); + } + } + ToHierarchy.digui(ds.Tables[0], mu); + + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍒犻櫎鎴愬姛锛�"; + objJsonResult.data =Newtonsoft.Json.JsonConvert.SerializeObject(mu); + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍒犻櫎澶辫触锛�"; + objJsonResult.data = e.ToString(); + return objJsonResult; + } + } + #endregion + } } -- Gitblit v1.9.1