public List <ActionURLViewModel> GetNavigation(string AccountUsername)
{
string SQLString = "SELECT * FROM ActionURL WHERE ID IN (SELECT ActionURLID FROM RoleActionURL_Mapping WHERE RoleID=(select RoleID from Account where Username=@Username )) AND Showable=1";
var Lists = CurrentDBSession.ExcuteQuery <ActionURLViewModel>(SQLString, new System.Data.SqlClient.SqlParameter("@Username", AccountUsername));
var MenuLists = new List <ActionURLViewModel>();
//RootLists:
//1 系统设置 0 fa fa-flash 1 1 1
//5 员工管理 0 fa fa-flash 2 1 1
var RootLists = Lists.FindAll(a => a.ParentID == 0 && a.IsRoot == true);
foreach (var FirstLevelitem in RootLists)
{
var FirstLevelMenu = new ActionURLViewModel();
FirstLevelMenu.ID = FirstLevelitem.ID;
FirstLevelMenu.MenuName = FirstLevelitem.MenuName;
FirstLevelMenu.Icon = FirstLevelitem.Icon;
FirstLevelMenu.URL = FirstLevelitem.URL;
//含有子菜单(2级菜单)
var SecondLevelMenuLists = Lists.FindAll(a => a.ParentID == FirstLevelMenu.ID && a.IsRoot == true);
FirstLevelMenu.Childrens = SecondLevelMenuLists;
foreach (var Seconditem in SecondLevelMenuLists)
{
var SecondLevelMenu = new ActionURLViewModel();
SecondLevelMenu.ID = Seconditem.ID;
SecondLevelMenu.MenuName = Seconditem.MenuName;
SecondLevelMenu.Icon = Seconditem.Icon;
SecondLevelMenu.URL = Seconditem.URL;
//含有子菜单三级菜单
var ThirdLevelMenuLists = Lists.FindAll(a => a.ParentID == SecondLevelMenu.ID && a.IsRoot == false);
if (ThirdLevelMenuLists.Count > 0)
{
foreach (var Thirditem in ThirdLevelMenuLists)
{
var ThirdLevelMenu = new ActionURLViewModel();
ThirdLevelMenu.ID = Thirditem.ID;
ThirdLevelMenu.MenuName = Thirditem.MenuName;
ThirdLevelMenu.Icon = Thirditem.Icon;
ThirdLevelMenu.URL = Thirditem.URL;
}
Seconditem.Childrens = ThirdLevelMenuLists;
}
}
MenuLists.Add(FirstLevelMenu);
}
return(MenuLists);
}
public List <ActionURL> GetActionURLs(string Filter = "")
{
string SQLString = "SELECT * FROM ActionURL" + (string.IsNullOrEmpty(Filter)?"":" WHERE " + Filter);
return(CurrentDBSession.ExcuteQuery <ActionURL>(SQLString));
}
public List <int> GetAllTopActionURLIDS()
{
string SQLString = "SELECT ID FROM ActionURL WHERE ParentID=0";
return(CurrentDBSession.ExcuteQuery <int>(SQLString));
}