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