From f2b71fe1d3c2b7651d525a5b5bbe66fad602ea06 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 09 九月 2025 18:46:28 +0800
Subject: [PATCH] 代码清理
---
WebApi/Gs.Sys/Services/RoleController.cs | 46 ++++++++++++++++++++++++++++++++--------------
1 files changed, 32 insertions(+), 14 deletions(-)
diff --git a/WebApi/Gs.Sys/Services/RoleController.cs b/WebApi/Gs.Sys/Services/RoleController.cs
index 97f5763..c1ed67e 100644
--- a/WebApi/Gs.Sys/Services/RoleController.cs
+++ b/WebApi/Gs.Sys/Services/RoleController.cs
@@ -179,10 +179,14 @@
public ReturnDto<PageList<dynamic>> GetListByRole([FromBody] dynamic model)
{
string roleGuid = model.roleGuid;
- System.Text.StringBuilder sbSql = new System.Text.StringBuilder();
- sbSql.Append("select ma.guid,ma.up_Guid as upGuid ,ma.name,ma.is_Status as isStatus,ma.idx");
- sbSql.Append(",(select count(1) from [dbo].[sys_Role_Menu_Action] act where act.role_Guid='" + roleGuid + "' and act.MENU_ACTION_GUID=ma.guid) as isCK");
- sbSql.Append(" from sys_Menu_Action ma where ma.is_Status=1 order by ma.IDX asc");
+ var sbSql = new StringBuilder();
+ sbSql.Append(
+ "select ma.guid,ma.up_Guid as upGuid ,ma.name,ma.is_Status as isStatus,ma.idx");
+ sbSql.Append(
+ ",(select count(1) from [dbo].[sys_Role_Menu_Action] act where act.role_Guid='" +
+ roleGuid + "' and act.MENU_ACTION_GUID=ma.guid) as isCK");
+ sbSql.Append(
+ " from sys_Menu_Action ma where ma.is_Status=1 order by ma.IDX asc");
var dset = new DataSet();
try
{
@@ -191,8 +195,10 @@
catch (Exception ex)
{
LogHelper.Debug(ToString(), "GetListByRole error锛�" + ex.Message);
- return ReturnDto<PageList<dynamic>>.QuickReturn(default(PageList<dynamic>), ReturnCode.Exception, "璇诲彇澶辫触");
+ return ReturnDto<PageList<dynamic>>.QuickReturn(
+ default(PageList<dynamic>), ReturnCode.Exception, "璇诲彇澶辫触");
}
+
var _pglist = new PageList<dynamic>
{
total = 0,
@@ -211,6 +217,7 @@
var _dy = dset.Tables[0].TableToDynamicList();
_pglist.list = _dy;
}
+
return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
ReturnCode.Success, "璇诲彇鎴愬姛");
}
@@ -372,15 +379,21 @@
var sbSql = new StringBuilder();
sbSql.Append(" ; with cet as (");
- sbSql.Append(" select ma.guid,ma.up_Guid,ma.name,ma.is_Status as isStatus,ma.idx");
- sbSql.Append(" , (select count(1) from[dbo].[sys_Role_Menu_Action] act left join sys_User_Role u on act.role_Guid = u.role_Guid");
- sbSql.Append(" where u.user_Guid = '"+ userGuid + "' and act.menu_Action_Guid = ma.guid) as isCK");
+ sbSql.Append(
+ " select ma.guid,ma.up_Guid,ma.name,ma.is_Status as isStatus,ma.idx");
+ sbSql.Append(
+ " , (select count(1) from[dbo].[sys_Role_Menu_Action] act left join sys_User_Role u on act.role_Guid = u.role_Guid");
+ sbSql.Append(" where u.user_Guid = '" + userGuid +
+ "' and act.menu_Action_Guid = ma.guid) as isCK");
sbSql.Append(" from sys_Menu_Action ma where ma.[is_Status] = 1");
sbSql.Append(" ),cet2 as (");
- sbSql.Append(" select ma.guid,ma.up_Guid,ma.name,ma.is_Status as isStatus,ma.idx");
- sbSql.Append(" , (select count(1) from[dbo].[sys_Role_Menu_Action] act left join sys_User u on act.role_Guid = u.GUID");
- sbSql.Append(" where u.GUID = '"+ userGuid + "' and act.menu_Action_Guid = ma.guid) as isCK");
+ sbSql.Append(
+ " select ma.guid,ma.up_Guid,ma.name,ma.is_Status as isStatus,ma.idx");
+ sbSql.Append(
+ " , (select count(1) from[dbo].[sys_Role_Menu_Action] act left join sys_User u on act.role_Guid = u.GUID");
+ sbSql.Append(" where u.GUID = '" + userGuid +
+ "' and act.menu_Action_Guid = ma.guid) as isCK");
sbSql.Append(" from sys_Menu_Action ma where ma.[is_Status] = 1");
sbSql.Append(" ),cet3 as (");
sbSql.Append(" select * from cet2 where isCK > 0");
@@ -394,7 +407,8 @@
sbSql.Append("),cet6 as (");
sbSql.Append(" SELECT");
sbSql.Append(" *,");
- sbSql.Append(" ROW_NUMBER() OVER(PARTITION BY guid ORDER BY isck DESC) AS rn");
+ sbSql.Append(
+ " ROW_NUMBER() OVER(PARTITION BY guid ORDER BY isck DESC) AS rn");
sbSql.Append(" FROM");
sbSql.Append(" cet5");
sbSql.Append(")");
@@ -406,9 +420,12 @@
}
catch (Exception ex)
{
- LogHelper.Debug(ToString(), "GetUserMenuAction error锛�" + ex.Message);
- return ReturnDto<PageList<dynamic>>.QuickReturn(default(PageList<dynamic>), ReturnCode.Exception, "璇诲彇澶辫触");
+ LogHelper.Debug(ToString(),
+ "GetUserMenuAction error锛�" + ex.Message);
+ return ReturnDto<PageList<dynamic>>.QuickReturn(
+ default(PageList<dynamic>), ReturnCode.Exception, "璇诲彇澶辫触");
}
+
var _pglist = new PageList<dynamic>
{
total = 0,
@@ -427,6 +444,7 @@
var _dy = dset.Tables[0].TableToDynamicList();
_pglist.list = _dy;
}
+
return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
ReturnCode.Success, "璇诲彇鎴愬姛");
}
--
Gitblit v1.9.3