public ActionResult loadTreeMenuDetail(Guid menuId)
{
return(JsonHandle.GetResult(_db.Queryable <SysBest_MenuAddress>()
.Where(it => it.MenuId == menuId)
.Where("IsDeleted = @IsDeleted",
new { IsDeleted = 0 }).ToList()));
}
public ActionResult loadTreeMenu()
{
var menuList = new List <TreeViewModel>();
//查出SysBest_Menu表的所有数据按创建时间倒序
var data = _db.SqlQuery <SysBest_Menu>("select * from SysBest_Menu order by Sort asc,CreateTime desc;").ToList();
foreach (SysBest_Menu it in data)
{
var model = new TreeViewModel();
model.id = it.Id.TryToString().Replace("/", "_");
model.parentid = it.ParentId.TryToString().Replace("/", "_");
model.text = $"{it.Id.TryToString()}\t{it.MenuName.TryToString()}";
model.value = it.TreeId;
menuList.Add(model);
}
return(JsonHandle.GetResult(menuList));
}
public ActionResult LoadLanguages()
{
return(JsonHandle.GetResult(_db.Queryable <SysBest_Language>().OrderBy(m => m.Sort).ToList()));
}
