From 94d0b18fa47a92a1cb4d1fef4520d35ef2c2c322 Mon Sep 17 00:00:00 2001
From: wbc <2597324127@qq.com>
Date: 星期二, 16 十二月 2025 21:56:49 +0800
Subject: [PATCH] 产能排产相关后端更新
---
WebApi/Gs.Sys/Services/RoleController.cs | 46 ++++++++++++++--------------------------------
1 files changed, 14 insertions(+), 32 deletions(-)
diff --git a/WebApi/Gs.Sys/Services/RoleController.cs b/WebApi/Gs.Sys/Services/RoleController.cs
index c1ed67e..97f5763 100644
--- a/WebApi/Gs.Sys/Services/RoleController.cs
+++ b/WebApi/Gs.Sys/Services/RoleController.cs
@@ -179,14 +179,10 @@
public ReturnDto<PageList<dynamic>> GetListByRole([FromBody] dynamic model)
{
string roleGuid = model.roleGuid;
- 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");
+ 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 dset = new DataSet();
try
{
@@ -195,10 +191,8 @@
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,
@@ -217,7 +211,6 @@
var _dy = dset.Tables[0].TableToDynamicList();
_pglist.list = _dy;
}
-
return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
ReturnCode.Success, "璇诲彇鎴愬姛");
}
@@ -379,21 +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 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");
@@ -407,8 +394,7 @@
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(")");
@@ -420,12 +406,9 @@
}
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,
@@ -444,7 +427,6 @@
var _dy = dset.Tables[0].TableToDynamicList();
_pglist.list = _dy;
}
-
return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
ReturnCode.Success, "璇诲彇鎴愬姛");
}
--
Gitblit v1.9.3