From ac8b13e15a96d757c9e563246fc662e8c186eaac Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期五, 19 十二月 2025 21:33:45 +0800
Subject: [PATCH] Merge branch 'master' of http://43.142.96.171:8080/r/~hyx/FD_NewPdaSqlServer
---
service/base/LoginService.cs | 18 +++++++++++++-----
1 files changed, 13 insertions(+), 5 deletions(-)
diff --git a/service/base/LoginService.cs b/service/base/LoginService.cs
index 30d082b..3407eb1 100644
--- a/service/base/LoginService.cs
+++ b/service/base/LoginService.cs
@@ -59,11 +59,19 @@
}
else
{
- string sql = string.Format(@"SELECT A.* FROM MES_SYS_PAGEVIEW A
- LEFT JOIN SYS_USER_BIND B ON CAST(A.guid AS VARCHAR(100)) = B.aboutGuid
- LEFT JOIN SYS_USER C ON C.GUID = B.userGuid
- WHERE C.ACCOUNT = '{0}'", name);
- pageViewList = Db.Ado.SqlQuery<MesSysPageview>(sql);
+ //2025-12-17 鏀逛负闆嗘垚pc鍜宲da
+ // string sql = string.Format(@"SELECT A.* FROM MES_SYS_PAGEVIEW A
+ // LEFT JOIN SYS_USER_BIND B ON CAST(A.guid AS VARCHAR(100)) = B.aboutGuid
+ // LEFT JOIN SYS_USER C ON C.GUID = B.userGuid
+ //WHERE C.ACCOUNT = '{0}'", name);
+
+ System.Text.StringBuilder sbSql = new System.Text.StringBuilder();
+ sbSql.Append(" select * from MES_SYS_PAGEVIEW where guid in ");
+ sbSql.Append(" ( select MENU_ACTION_GUID from [sys_Role_Menu_Action] ");
+ sbSql.Append(" where [ROLE_GUID]= (select top 1 guid from SYS_USER c where c.ACCOUNT='" + name + "') ");
+ sbSql.Append(" ) ");
+
+ pageViewList = Db.Ado.SqlQuery<MesSysPageview>(sbSql.ToString());
}
//if(pageViewList.Count < 0)
--
Gitblit v1.9.3