From ca835dc991b53a63971d1f811c3b7de2793b7b8f Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 27 十一月 2024 23:12:14 +0800
Subject: [PATCH] 1
---
entity/MesSysPageview.cs | 36 +++++++++++++----
service/base/LoginService.cs | 41 +++++++++++++++++++-
2 files changed, 65 insertions(+), 12 deletions(-)
diff --git a/entity/MesSysPageview.cs b/entity/MesSysPageview.cs
index 83b4b98..7440f0a 100644
--- a/entity/MesSysPageview.cs
+++ b/entity/MesSysPageview.cs
@@ -9,27 +9,45 @@
public class MesSysPageview
{
/// <summary>
- /// 涓婚敭
- /// 榛樿鍊�: (newid())
- /// </summary>
+ /// 涓婚敭
+ /// 榛樿鍊�: (newid())
+ ///</summary>
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
public Guid Guid { get; set; }
/// <summary>
- /// 椤甸潰涓枃鍚�
- /// </summary>
+ /// 椤甸潰涓枃鍚�
+ ///</summary>
[SugarColumn(ColumnName = "PAGE_VIEW")]
public string PageView { get; set; }
/// <summary>
- /// 椤甸潰璺緞
- /// </summary>
+ /// 椤甸潰璺緞
+ ///</summary>
[SugarColumn(ColumnName = "PATH")]
public string Path { get; set; }
/// <summary>
- /// 椤甸潰鍥炬爣
- /// </summary>
+ /// 椤甸潰鍥炬爣
+ ///</summary>
[SugarColumn(ColumnName = "ICOIMG")]
public string Icoimg { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "PAGE_GROUP")]
+ public string PageGroup { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "PAGE_IDX")]
+ public int? PageIdx { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "PAGE_STATUS")]
+ public bool? PageStatus { get; set; }
}
\ No newline at end of file
diff --git a/service/base/LoginService.cs b/service/base/LoginService.cs
index 5c4fa83..cc50b04 100644
--- a/service/base/LoginService.cs
+++ b/service/base/LoginService.cs
@@ -1,4 +1,5 @@
-锘縰sing NewPdaSqlServer.DB;
+锘縰sing System.Dynamic;
+using NewPdaSqlServer.DB;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.util;
@@ -21,13 +22,47 @@
return sysUser;
}
- public List<MesSysPageview> getUserMenu(string name)
+ public List<dynamic> getUserMenu(string name)
{
var sql = "";
+ var pageViewList = Db.Queryable<MesSysPageview>()
+ .Where(s=>s.PageStatus == true).ToList();
+
+ var result = new List<dynamic>();
+
if ("admin".Equals(name))
- return Db.Queryable<MesSysPageview>()
+ {
+ var groupedPageViews = pageViewList
+ .GroupBy(p => string.IsNullOrEmpty(p.PageGroup) ? "鏈垎缁�" : p.PageGroup)
.ToList();
+
+ foreach (var group in groupedPageViews)
+ {
+ dynamic groupObj = new ExpandoObject();
+ groupObj.groupName = group.Key; // 鍒嗙粍鍚�
+ groupObj.child = new List<MesSysPageview>();
+
+ foreach (var pageView in group)
+ {
+ groupObj.child.Add(new MesSysPageview()
+ {
+ Guid = pageView.Guid,
+ PageView = pageView.PageView,
+ Path = pageView.Path,
+ Icoimg = pageView.Icoimg,
+ PageGroup = pageView.PageGroup,
+ PageIdx = pageView.PageIdx,
+ PageStatus = pageView.PageStatus
+ });
+ }
+
+ result.Add(groupObj);
+ }
+
+ return result;
+ }
+
return null;
}
--
Gitblit v1.9.3