Own.DAL/Sys/Sys_Web_Dal.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using Own.Models;
using Own.Models.Sys;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Own.DAL.Sys
{
    /// <summary>
    /// Web Site分部类
    /// </summary>
    public partial class Sys_Web_Dal
    {
        /// <summary>
        /// 获取Web站点的子类（菜单分类和菜单分类的子类菜单归属）
        /// </summary>
        /// <returns></returns>
        #region
        public List<Sys_Web_Entity> GetSys_Web_Tree()
        {
            //获取Web站点和其子类
            List<Sys_Web_Entity> entityList = (from a in Context.Sys_Menu_Class
                                               join b in Context.Sys_Web on a.WId equals b.Id
                                               where  "启用".Equals(b.Status)
                                               select new Sys_Web_Entity
                                               {
                                                   Id = b.Id,
                                                   Title = b.Title,
                                                   ENTitle = b.ENTitle,
                                                   Num = b.Num,
                                                   menu_class = new List<Sys_Menu_Class_Entity>()
                                                   {
                                                       new Sys_Menu_Class_Entity()
                                                       {
                                                           Id = a.Id,
                                                           Title = a.Title,
                                                           EnTitle = a.EnTitle,
                                                           Num = a.Num
                                                       }
                                                   }

                                               }).ToList();
            return entityList;
        } 
        #endregion


    }
}