/// <summary> /// 系统菜单 /// </summary> /// <returns></returns> public ActionResult Menu() { List <Sys_Menu> model = new List <Sys_Menu>(); string sql = "select * from Sys_Menu"; model = _sys_MenuService.SelectData <Sys_Menu>(sql); return(View(model)); }
public BasePageController() { CacheHelper cache = new CacheHelper(); _rootList = cache.Get <List <MenuModel> >("webRootMenuList"); if (_rootList == null || _rootList.Count <= 0) { this._sys_MenuService = new Sys_MenuService(); List <MenuModel> RootList = _sys_MenuService.SelectData <MenuModel>("select * from Sys_Menu where ParentID=0 and Visible='True'"); foreach (MenuModel item in RootList) { item.SonMenuList = _sys_MenuService.SelectData <MenuModel>("select * from Sys_Menu where ParentID=" + item.pk_Menu); } _rootList = RootList; CacheHelper.SetCache("webRootMenuList", RootList); } }