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