1

啊鑫

2024-11-27 ca835dc991b53a63971d1f811c3b7de2793b7b8f

1

 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; }
}

 service/base/LoginService.cs

@@ -1,4 +1,5 @@
using NewPdaSqlServer.DB;
using 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;
    }