xinjiang/SGGL/BLL/SysManage/SysMenuService.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web.UI.WebControls;

namespace BLL
{
   public static class SysMenuService
    {
       public static Model.SGGLDB db = Funs.DB;

       /// <summary>
       /// 根据MenuId获取菜单名称项
       /// </summary>
       /// <param name="menuId"></param>
       /// <returns></returns>
       public static List<Model.Sys_Menu> GetSupMenuListBySuperMenu(string superMenu)
       {
           var list = (from x in Funs.DB.Sys_Menu where x.SuperMenu == superMenu orderby x.SortIndex select x).ToList();          
           return list;
       }

       /// <summary>
       /// 根据MenuId获取菜单名称项
       /// </summary>
       /// <param name="menuId"></param>
       /// <returns></returns>
       public static Model.Sys_Menu GetSupMenuBySuperMenu(string superMenu)
       {
           return Funs.DB.Sys_Menu.FirstOrDefault(x => x.SuperMenu == superMenu);    
       }

       /// <summary>
       /// 根据MenuId获取菜单名称项
       /// </summary>
       /// <param name="menuId"></param>
       /// <returns></returns>
       public static Model.Sys_Menu GetSysMenuByMenuId(string menuId)
       {
           return Funs.DB.Sys_Menu.FirstOrDefault(x => x.MenuId == menuId);
       }

       /// <summary>
       /// 根据MenuType获取菜单集合
       /// </summary>
       /// <param name="menuId"></param>
       /// <returns></returns>
       public static List<Model.Sys_Menu> GetMenuListByMenuType(string menuType)
       {
           var list = (from x in Funs.DB.Sys_Menu where x.MenuType == menuType orderby x.SortIndex select x).ToList();
           return list;
       }

        /// <summary>
        /// 根据MenuType获取菜单集合
        /// </summary>
        /// <param name="menuId"></param>
        /// <returns></returns>
        public static List<Model.Sys_Menu> GetIsUsedMenuListByMenuType(string menuType)
        {
            var list = (from x in Funs.DB.Sys_Menu
                        where (x.MenuType == menuType || menuType == null) && x.IsUsed == true
                        orderby x.SortIndex
                        select x).Distinct().ToList();
            return list;
        }

        /// <summary>
        /// 根据MenuType获取菜单集合
        /// </summary>
        /// <param name="menuId"></param>
        /// <returns></returns>
        public static List<Model.Sys_Menu> GetIsUsedMenuListBySupType(string menuType)
        {
            List<Model.Sys_Menu> lists = new List<Model.Sys_Menu>();

            if (menuType == "MenuType_S")
            {
                lists = (from x in Funs.DB.Sys_Menu
                         where x.IsOffice == true && x.IsUsed == true
                         orderby x.SortIndex
                         select x).Distinct().ToList();
            }
            else
            {
                lists = (from x in Funs.DB.Sys_Menu
                         where x.IsOffice == false && x.IsUsed == true
                         orderby x.SortIndex
                         select x).Distinct().ToList();
            }
            
            return lists;
        }       
    }
}