From 81046c3fe28867d4f05a150cc62f0a77bdf0c05b Mon Sep 17 00:00:00 2001
From: wbc <2597324127@qq.com>
Date: 星期三, 17 十二月 2025 16:15:30 +0800
Subject: [PATCH] 权限修改2
---
WebApi/Gs.Sys/Services/RoleController.cs | 23 +++++++++++------------
1 files changed, 11 insertions(+), 12 deletions(-)
diff --git a/WebApi/Gs.Sys/Services/RoleController.cs b/WebApi/Gs.Sys/Services/RoleController.cs
index 97f5763..72187da 100644
--- a/WebApi/Gs.Sys/Services/RoleController.cs
+++ b/WebApi/Gs.Sys/Services/RoleController.cs
@@ -169,10 +169,10 @@
"璇诲彇鎴愬姛锛�");
return ReturnDto<SysRole>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�");
}
-
+
/// <summary>
- /// 鏍规嵁瑙掕壊roleGuid璇诲彇鏉冮檺
+ /// 鏍规嵁瑙掕壊鎴栦釜浜簉oleGuid璇诲彇鏉冮檺锛�2025-12-17闆嗘垚浜唒da
/// </summary>
/// <returns></returns>
[RequestMethod(RequestMethods.POST)]
@@ -180,9 +180,9 @@
{
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 ma.guid,ma.upGuid as upGuid ,ma.name,ma.isStatus 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");
+ sbSql.Append(" from v_pc闆嗘垚pda鑿滃崟 ma where ma.isStatus=1 order by ma.IDX asc");
var dset = new DataSet();
try
{
@@ -360,7 +360,7 @@
}
/// <summary>
- /// 鏍规嵁鐢ㄦ埛璇诲彇鏉冮檺
+ /// 鏍规嵁鐢ㄦ埛璇诲彇鏉冮檺锛�2025-12-17闆嗘垚浜唒da
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
@@ -372,16 +372,15 @@
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 ma.guid,ma.upGuid,ma.name,ma.isStatus 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(" where u.user_Guid = '" + userGuid + "' and act.menu_Action_Guid = ma.guid) as isCK");
+ sbSql.Append(" from v_pc闆嗘垚pda鑿滃崟 ma where ma.[isStatus] = 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 ma.guid,ma.upGuid,ma.name,ma.isStatus 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(" where u.GUID = '" + userGuid + "' and act.menu_Action_Guid = ma.guid) as isCK");
+ sbSql.Append(" from v_pc闆嗘垚pda鑿滃崟 ma where ma.[isStatus] = 1");
sbSql.Append(" ),cet3 as (");
sbSql.Append(" select * from cet2 where isCK > 0");
sbSql.Append(" ),cet4 as (");
--
Gitblit v1.9.3