public ActionResult GetMenuList(Menu Menumodel) { List <Menu> temp; List <MenuDo> menuDoList = new List <MenuDo> { }; if (string.IsNullOrEmpty(Menumodel.Menu_Name)) { temp = db.Queryable <Menu>().ToList(); } else { temp = db.Queryable <Menu>().Where(it => it.Menu_Name == Menumodel.Menu_Name).ToList(); } foreach (var item in temp) { var templist = db.Queryable <Menu_Button>() .Where(it => it.Menu_ID == item.Menu_ID) .Select <MenuMappingButton>(c => new MenuMappingButton { ButtonID = c.Button_ID, ID = c.ID, MenuID = c.Menu_ID, OrderBy = c.OrderBy }).ToList(); var tempMenuDo = new MenuDo { MenuID = item.Menu_ID, MenuName = item.Menu_Name, MenuUrl = item.Menu_Url, MenuOrder = item.Menu_Order, MenuIcon = item.Menu_Icon, CreateTime = item.Create_Time, mbList = templist }; var tempItem = temp.FirstOrDefault(it => it.Menu_ID == item.Menu_ParentID); if (tempItem != null) { tempMenuDo.MenuParentName = tempItem.Menu_Name; } menuDoList.Add(tempMenuDo); } var jsonresult = SerializeObject(new ResultEntity { recordsFiltered = menuDoList.Count, recordsTotal = menuDoList.Count, dataList = menuDoList }); return(Content(jsonresult)); }
// GET: Menu public ActionResult Index() { using (var db = new ProjectWebEntities()) { var model = new MenuDo(); // model.ListMenuMultiLevel = db.Tbl_MenuMultiLevel.Where(p=>p.Tbl_MenuMultiLevel1.Any()).ToList(); var list = new List <Tbl_MenuMultiLevel>(); foreach (var item in db.Tbl_MenuMultiLevel.Include(p => p.Tbl_MenuMultiLevel1)) { if (item.Tbl_MenuMultiLevel1.Any()) { list.Add(item); } } model.ListMenuMultiLevel = list; return(View(model)); } }
//public List<MenuVM> GetMenuTree(int? parent) //{ // using (var db = new ProjectWebEntities()) // { // var query = db.Tbl_MenuMultiLevel.AsEnumerable(); // query = parent == null ? query.Where(t => t.ParentId == null).ToList() : query.Where(t => t.ParentId == parent).ToList(); // var result = new List<MenuVM>(); // foreach (var m in query.OrderBy(p => p.MenuCode)) // { // var tmp = new MenuVM(); // tmp.Id = m.MenuId; // tmp.MenuCode = m.MenuCode; // tmp.Name = m.Menu; // tmp.ParentId = m.ParentId; // tmp.Children = GetMenuTree(m.MenuId); // tmp.Url = m.Url; // tmp.PageId = m.PageId; // tmp.PageChildId = m.PageChildId; // result.Add(tmp); // } // return result; // } //} public ActionResult Create(int id) { using (var db = new ProjectWebEntities()) { var model = new MenuDo(); model.ListMenuLink = db.Tbl_MenuLink.ToList(); model.ListIntroduces = db.Tbl_Introduce.Where(p => p.IsDisable == false).OrderBy(p => p.Title).ToList(); model.ListNewses = db.Tbl_News.Where(p => p.IsDisable == false && p.IsIndividualPage == false && p.IsAbout == false).OrderBy(p => p.Title).ToList(); model.ListSinglePage = db.Tbl_News.Where(p => p.IsDisable == false && p.IsIndividualPage && p.IsAbout == false).OrderBy(p => p.Title).ToList(); //model.ListNewsTypes = db.Tbl_NewsType.Where(p => p.IsDisable == false).OrderBy(p => p.Name).ToList(); //model.ListProducts = db.Tbl_Product.Where(p => p.IsDisable == false).OrderBy(p => p.Name).ToList(); model.ListProductTypes = db.Tbl_ProductType.Where(p => p.IsDisable == false).OrderBy(p => p.Name).ToList(); var parent = db.Tbl_MenuMultiLevel.Include(p => p.Tbl_MenuMultiLevel1).FirstOrDefault(p => p.MenuId == id); var entry = db.Entry(parent); entry.Collection(p => p.Tbl_MenuMultiLevel1).Query().OrderBy(p => p.MenuCode).Load(); model.ItemMenu = entry.Entity; return(View(model)); } }