如何绑定动态菜单 [英] How Do I Bind Dynamic Menu
问题描述
hi
我想用Linq创建动态菜单,
我有三张桌子
1.Menu_master
menu_id | menu_name
2.SubmenuParent_master
Parent_Menu_id | Parent_menu_name | menu_id
3.Submenu_child_master
child_menu_id | child_menu_name | Parent_Menu_id
其中所有三个表都用外键连接
hi
I wanna create dynamic menu using Linq ,
I have three tables
1.Menu_master
menu_id|menu_name
2.SubmenuParent_master
Parent_Menu_id | Parent_menu_name| menu_id
3.Submenu_child_master
child_menu_id |child_menu_name| Parent_Menu_id
where all three tables connected with foreign key
public object[] bindParentMenu(SubmenuParent_master obj)
{
object[] parentmenu = (from p in db.Parent_masters
select p).ToArray();
return parentmenu;
}
public object[] bindchildMenu(chaild_master obj)
{
object[] childmenu = (from p in db.chaild_masters
select p).ToArray();
return childmenu;
}
请指导我为子菜单编写linq查询
谢谢
please Guide me to write linq query for sub menu
thank you
推荐答案
首先,不要使用object []
s。在适用的情况下,仿制药应该是您的首选。
如果你使用linq到sql,你可以从 DataContext [ ^ ]如:
first of all, do not useobject[]
s. generics should be your first choice when applicable.
If you use linq to sql, you can select values from DataContext [^] like :
var level0 = dataContext.Menu_masters.ToList();
var level1 = dataContext.SubmenuParent_masters.ToList();
var level2 = dataContext.Submenu_child_masters.ToList();
但存在更好。如果你的意思是菜单为 MainMenu [ ^ ],
然后您可以将所有菜单项存储在一个具有外键值的表中。您可以使用此表创建菜单。
but there exists better. If you mean by "menu" as MainMenu[^],
then you can store all your menu items in one table with foreign key values. you can use this table to create your menu.
这篇关于如何绑定动态菜单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!