From 0b9e0918369c3b7daca72180357620ccdc0a2d86 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期五, 28 三月 2025 11:07:59 +0800
Subject: [PATCH] 1.根据账号信息获取对应权限的菜单
---
Controllers/LoginController.cs | 29 ++++++++++++++
service/base/LoginService.cs | 55 ++++++++++++++++++++++-----
2 files changed, 74 insertions(+), 10 deletions(-)
diff --git a/Controllers/LoginController.cs b/Controllers/LoginController.cs
index edb595b..19ca7d3 100644
--- a/Controllers/LoginController.cs
+++ b/Controllers/LoginController.cs
@@ -105,4 +105,33 @@
return ResponseResult.ResponseError(ex);
}
}
+
+
+ /// <summary>
+ /// 鑾峰彇璐﹀彿淇℃伅
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
+ [HttpPost("getUserInfo")]
+ public ResponseResult getUserInfo([FromBody] dynamic model)
+ {
+ //鐧诲綍
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ var tbBillList =
+ new LoginService().getUserInfo(model.Guid);
+ resultInfos.tbBillList = tbBillList;
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
}
\ No newline at end of file
diff --git a/service/base/LoginService.cs b/service/base/LoginService.cs
index cd24096..c483032 100644
--- a/service/base/LoginService.cs
+++ b/service/base/LoginService.cs
@@ -24,15 +24,33 @@
public List<dynamic> getUserMenu(string name)
{
- var pageViewList = Db.Queryable<MesSysPageview>()
- .Where(s => s.PageStatus == true)
- .OrderBy(s => s.PageIdx)
- .ToList();
-
- var result = new List<dynamic>();
-
+ var pageViewList = new List<MesSysPageview>();
if ("admin".Equals(name))
{
+ pageViewList = Db.Queryable<MesSysPageview>()
+ .Where(s => s.PageStatus == true)
+ .OrderBy(s => s.PageIdx)
+ .ToList();
+ }
+ else
+ {
+ string sql = string.Format(@"SELECT A.* FROM MES_SYS_PAGEVIEW A
+ LEFT JOIN SYS_USER_BIND B ON A.guid = B.aboutGuid
+ LEFT JOIN SYS_USER C ON C.GUID = B.userGuid
+ WHERE C.ACCOUNT = '{0}'", name);
+ pageViewList = Db.Ado.SqlQuery<MesSysPageview>(sql);
+ }
+
+ //if(pageViewList.Count < 0)
+ //{
+ // throw new Exception("璇ョ敤鎴锋病鏈夋潈闄愯闂�");
+ //}
+
+ try
+ {
+ var result = new List<dynamic>();
+
+
var groupedPageViews = pageViewList
.GroupBy(p =>
string.IsNullOrEmpty(p.PageGroup) ? "鏈垎缁�" : p.PageGroup)
@@ -70,10 +88,12 @@
}
return result;
+
}
-
-
- return null;
+ catch(Exception e)
+ {
+ throw new Exception(e.Message);
+ }
}
public int resetPassword(string newPwd, string name, string pwd)
@@ -86,4 +106,19 @@
.Where(s => s.Account == name)
.ExecuteCommand();
}
+
+
+ public List<dynamic> getUserInfo(string userGuid)
+ {
+
+ //string sql = string.Format(@"SELECT A.* FROM MES_SYS_PAGEVIEW A
+ // LEFT JOIN SYS_USER_BIND B ON A.guid = B.aboutGuid
+ // LEFT JOIN SYS_USER C ON C.GUID = B.userGuid
+ //WHERE C.ACCOUNT = '{0}'", userGuid);
+ //var sysUser = Db.Ado.SqlQuery<dynamic>(sql);
+
+
+ //return sysUser;
+ return null;
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3