From a3a36252fe9f1ada8fdc908b019349bf570feaff Mon Sep 17 00:00:00 2001
From: lg <123456>
Date: 星期三, 17 十二月 2025 13:51:18 +0800
Subject: [PATCH] 集成了pda权限
---
WebApi/Gs.Sys/Services/RoleController.cs | 17 ++++++++---------
1 files changed, 8 insertions(+), 9 deletions(-)
diff --git a/WebApi/Gs.Sys/Services/RoleController.cs b/WebApi/Gs.Sys/Services/RoleController.cs
index 97f5763..fcde2d9 100644
--- a/WebApi/Gs.Sys/Services/RoleController.cs
+++ b/WebApi/Gs.Sys/Services/RoleController.cs
@@ -172,7 +172,7 @@
/// <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(" 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(" 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