From 6922ceb192bfcb15f840409bb5f0707d3ee448e9 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期五, 21 六月 2024 18:09:57 +0800
Subject: [PATCH] 菜单权限更新

---
 Tiger.Api/Controllers/Test/TestController.R.cs |  124 ++++++++++++++++++++++++++---------------
 1 files changed, 79 insertions(+), 45 deletions(-)

diff --git a/Tiger.Api/Controllers/Test/TestController.R.cs b/Tiger.Api/Controllers/Test/TestController.R.cs
index 07a9de2..10a486a 100644
--- a/Tiger.Api/Controllers/Test/TestController.R.cs
+++ b/Tiger.Api/Controllers/Test/TestController.R.cs
@@ -18,6 +18,9 @@
 using Tiger.Model.Sharetronic.Shelf;
 using Newtonsoft.Json.Linq;
 using Tiger.Api.iBiz;
+using System.Net;
+using System.Reflection;
+using Swifter.Tools;
 
 namespace Tiger.Api.Controllers.Test
 {
@@ -34,6 +37,21 @@
         public IActionResult GetDBSchemaAsync()
         {
             return Ok(Biz.Db.DbMaintenance.GetTableInfoList());
+        }
+
+        [HttpGet]
+        public IActionResult GetEntitys(string AssemblyName, string NameSpace)
+        {
+            Assembly assembly = Assembly.Load(AssemblyName);
+            Type[] types = assembly.GetTypes();
+            var entitys = types.Where(q => q.GetInterfaces().Contains(typeof(iEntity)) && q.IsClass).ToList();
+            var data = entitys.Select(q => new
+            {
+                q.Namespace,
+                q.FullName,
+                Properties = q.GetProperties().Select(p => new { p.Name, Type = p.PropertyType.Name }).ToList()
+            });
+            return Ok(data);
         }
 
         /// <summary>
@@ -140,9 +158,9 @@
             //Biz.Db.Fastest<WMS_WAREHOUSE>().BulkUpdate(data, new string[] { "ID" }, new string[] { "UPDATE_TIME", "UPDATE_USER" });
             //Biz.Db.Insertable(data, "Interface").ExecuteCommand();
 
-            //var root = new SugarParameter("root", "system01");
-            //var dt = Biz.Db.Ado.UseStoredProcedure().GetDataTable("PKG_SYS_GET_MENU", root);//杩斿洖dt
-            //var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<SYS_MENU>("PKG_SYS_GET_MENU", root);//杩斿洖List
+            var root = new SugarParameter("root", "system01");
+            var dt = Biz.Db.Ado.UseStoredProcedure().GetDataTable("SP_SYS_GET_MENU", root);//杩斿洖dt
+            var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<SYS_MENU>("SP_SYS_GET_MENU", root);//杩斿洖List
             ;
             //var data = Biz.Db.Queryable<BIZ_SRM_DLVY>()
             //    .IncludesAllFirstLayer()
@@ -172,7 +190,7 @@
             //{
             //    throw dbTran.ErrorException;
             //}
-            return Ok("");
+            return Ok(data);
         }
         /// <summary>
         /// 
@@ -231,46 +249,6 @@
             return Ok($"璁剧疆{param}鎴愬姛");
         }
 
-        /// <summary>
-        /// SendMQTTAsync
-        /// </summary>
-        /// <param name="action"></param>
-        /// <returns></returns>
-        [HttpPost]
-        public async Task<IActionResult> SendMQTTAsync([FromBody] ApiAction action)
-        {
-            string msg = "";
-            await Task.Run(() =>
-            {
-                msg = action.ID;
-                MQTTHelper.Send("TestSendMQTT001", new MQTTMessage()
-                {
-                    Type = "TestSendMQTT001",
-                    Content = "TestSendMQTT001锛屾祴璇曟秷鎭紒",
-                    Data = "",
-                    DataType = typeof(String).Name,
-                    IsSuccessed = true,
-                });
-            });
-            return Ok(MQTTHelper.Send(action.GetResponse(msg)));
-        }
-
-        /// <summary>
-        /// DeleteMQTTTopicAsync
-        /// </summary>
-        /// <param name="action"></param>
-        /// <returns></returns>
-        [HttpPost]
-        public async Task<IActionResult> DeleteMQTTTopicAsync([FromBody] ApiAction action)
-        {
-            string msg = "";
-            await Task.Run(() =>
-            {
-                msg = MQTTHelper.DeleteTopic(action.ID) ? "鍒犻櫎Topic鎴愬姛" : "鍒犻櫎Topic澶辫触";
-            });
-            return Ok(action.GetResponse(msg));
-        }
-
         [HttpPost]
         public async Task<IActionResult> TestTask([FromBody] ApiAction action)
         {
@@ -320,7 +298,6 @@
     [Route("api/[controller]/[action]")]
     public partial class _TestController : ControllerBase
     {
-
         [HttpGet]
         public async Task<IActionResult> DoSomething(int duration)
         {
@@ -336,4 +313,61 @@
             return Ok($"{begin:mmssfff} completed");
         }
     }
+
+    /// <summary>
+    /// MQTT娴嬭瘯鎺у埗鍣�
+    /// </summary>
+    [ApiController]
+    [Route("api/[controller]/[action]")]
+    public partial class _MqttTestController : ControllerBase
+    {
+        [HttpGet]
+        public async Task<IActionResult> DoSomething1(int duration)
+        {
+            var begin = DateTime.Now;
+
+            return Ok($"{begin:mmssfff} completed");
+        }
+
+        /// <summary>
+        /// SendMQTTAsync
+        /// </summary>
+        /// <param name="action"></param>
+        /// <returns></returns>
+        //[HttpPost]
+        //public async Task<IActionResult> SendMQTTAsync([FromBody] ApiAction action)
+        //{
+        //    string msg = "";
+        //    await Task.Run(() =>
+        //    {
+        //        msg = action.ID;
+        //        MQTTHelper.Send("TestSendMQTT001", new MQTTMessage()
+        //        {
+        //            Type = "TestSendMQTT001",
+        //            Content = "TestSendMQTT001锛屾祴璇曟秷鎭紒",
+        //            Data = "",
+        //            DataType = typeof(String).Name,
+        //            IsSuccessed = true,
+        //        });
+        //    });
+        //    return Ok(MQTTHelper.Send(action.GetResponse(msg)));
+        //}
+
+        /// <summary>
+        /// DeleteMQTTTopicAsync
+        /// </summary>
+        /// <param name="action"></param>
+        /// <returns></returns>
+        [HttpPost]
+        public async Task<IActionResult> DeleteMQTTTopicAsync([FromBody] ApiAction action)
+        {
+            string msg = "";
+            await Task.Run(() =>
+            {
+                //msg = MQTTHelper.DeleteTopic(action.ID) ? "鍒犻櫎Topic鎴愬姛" : "鍒犻櫎Topic澶辫触";
+            });
+            
+            return Ok(action.GetResponse(msg));
+        }
+    }
 }

--
Gitblit v1.9.3