From 01656f0ff2bf7b62ef0fb039e24be888849ad728 Mon Sep 17 00:00:00 2001
From: lg <999544862qq.com>
Date: 星期五, 30 八月 2024 11:06:44 +0800
Subject: [PATCH] 权限
---
WebApi/Gs.User/Service/MenuActionController.cs | 72 ++++++++++++++++++++++++++++++++++++
1 files changed, 72 insertions(+), 0 deletions(-)
diff --git a/WebApi/Gs.User/Service/MenuActionController.cs b/WebApi/Gs.User/Service/MenuActionController.cs
index ab42aa4..035b1e4 100644
--- a/WebApi/Gs.User/Service/MenuActionController.cs
+++ b/WebApi/Gs.User/Service/MenuActionController.cs
@@ -9,6 +9,7 @@
using System.Text;
using System.Threading.Tasks;
using Gs.User.Modes;
+using Microsoft.Extensions.Primitives;
namespace Gs.User.Service
{
@@ -213,5 +214,76 @@
return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�");
}
}
+
+
+ /// <summary>
+ /// 璇诲彇鍔熻兘鑿滃崟鍒楄〃锛屽垎缁勭粐灞曠幇鏉冮檺鑿滃崟
+ /// </summary>
+ /// <returns></returns>
+ [RequestMethod(RequestMethods.POST)]
+ public ReturnDto<PageList<MenuAction>> GetListPageByOrg()
+ {
+ System.Text.StringBuilder _orgSql = new StringBuilder();
+ _orgSql.Append("select org.guid,null as upGuid,org.name,org.status from [dbo].[sys_Organization] org where upGuid is not null ");
+ DataSet _orgDset = new DataSet();
+ System.Text.StringBuilder sbSql = new StringBuilder();
+ try
+ {
+ _orgDset = Gs.Toolbox.DbHelperSQL.Query(_orgSql.ToString());
+ foreach (DataRow row in _orgDset.Tables[0].Rows)
+ {
+ if (sbSql.Length > 0)
+ sbSql.Append(" union all");
+ sbSql.Append(" select org.guid,null as upGuid,org.name,org.status,'"+ row["guid"].ToString() + "' as orgGuid from [dbo].[sys_Organization] org where org.guid ='" + row["guid"].ToString() + "'");
+ sbSql.Append(" union all");
+ sbSql.Append(" select ma.guid,isnull(ma.upGuid,'" + row["guid"].ToString() + "') as upGuid,ma.name,ma.status,'"+ row["guid"].ToString() + "' as orgGuid from sys_MenuAction ma");
+ }
+ }
+ catch (Exception ex)
+ {
+ Gs.Toolbox.LogHelper.Debug(this.ToString(), "GetListPage error锛�" + ex.Message);
+ return ReturnDto<PageList<MenuAction>>.QuickReturn(default(PageList<MenuAction>), ReturnCode.Exception, "璇诲彇澶辫触");
+ }
+ DataSet dset = new DataSet();
+ try
+ {
+ dset = Gs.Toolbox.DbHelperSQL.Query(sbSql.ToString());
+ }
+ catch (Exception ex)
+ {
+ Gs.Toolbox.LogHelper.Debug(this.ToString(), "GetListPage error锛�" + ex.Message);
+ return ReturnDto<PageList<MenuAction>>.QuickReturn(default(PageList<MenuAction>), ReturnCode.Exception, "璇诲彇澶辫触");
+ }
+ PageList<MenuAction> _pglist = new PageList<MenuAction>
+ {
+ total = 0,
+ everyPageSize = 0,
+ pages = 0,
+ list = new List<MenuAction>()
+ };
+ if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0)//鏈夋暟鎹�
+ {
+ int intTotal = 999;
+ int pages = 1;
+ _pglist.total = intTotal;
+ _pglist.everyPageSize = 1;
+ _pglist.pages = pages;
+ foreach (DataRow dr in dset.Tables[0].Rows)
+ {
+ _pglist.list.Add(
+ new MenuAction()
+ {
+ guid = Guid.Parse(dr["guid"].ToString()),
+ upGuid = dr["upGuid"].ToString().Length > 0 ? Guid.Parse(dr["upGuid"].ToString()) : null,
+ name = dr["name"].ToString(),
+ status = int.Parse(dr["status"].ToString()),
+ orgGuid = dr["orgGuid"].ToString(),
+ }
+ );
+ }
+ }
+ return ReturnDto<PageList<MenuAction>>.QuickReturn(_pglist, ReturnCode.Success, "璇诲彇鎴愬姛");
+ }
+
}
}
--
Gitblit v1.9.3