-------------------------------------
源代碼下載/Files/singlepine/topmenu.rar
public class TopMenu : System.Web.UI.Page
{
protected DataRow[] father;
protected DataRow[] first;
protected DataRow[] second;
private void Page_Load(object sender, System.EventArgs e)
{
}
public static string ConnectionString=System.Configuration .ConfigurationSettings .AppSettings["ConnectionString"];
GetDataSet#region GetDataSet
public static DataSet GetDataSet(string sql)
{
SqlDataAdapter sda =new SqlDataAdapter(sql,ConnectionString);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
#endregion
Web Form Designer generated code#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/**//**//**//// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
LoadTopMenu#region LoadTopMenu
protected string LoadTopMenu()
{
//IsBoot設(shè)置菜單級(jí)別,0一級(jí),1二級(jí),2三級(jí),依此類(lèi)推.
string sqlFather="select * from topmenu order by IsBoot";
DataSet dsFather=GetDataSet(sqlFather);
father=dsFather.Tables[0].Select("IsBoot=0","IsBoot");
string menu="";
int one=0;
int two=1;
int three=1;
foreach(DataRow drfather in father)
{
menu+="mpmenu"+one+"=new mMenu("+"'"+drfather["text"]+"'"+",'/','self','','','','');";
first=dsFather.Tables[0].Select("ParentID='"+Convert.ToInt32(drfather["ID"])+"' and IsBoot=1","IsBoot");
foreach(DataRow drfirst in first)
{
second=dsFather.Tables[0].Select("ParentID='"+Convert.ToInt32(drfirst["ID"])+"' and IsBoot=2","IsBoot");
if(second.Length==0)
{
menu+="mpmenu"+one+".addItem(new mMenuItem("+"'"+drfirst["text"]+"'";//description
menu+=","+"'"+drfirst["url"]+"'"+",";//url
menu+="'"+drfirst["target"]+"'"+",";//target
menu+=""+drfirst["visible"]+",";//是否可見(jiàn),false可見(jiàn),true不可見(jiàn)
menu+="'"+drfirst["status"]+"'"+",";//狀態(tài)條
menu+="null,'','','',''));";
}
foreach(DataRow drsecond in second)
{
menu+="msub"+two+"=new mMenuItem("+"'"+drfirst["text"]+"','',"+"'"+drfirst["target"]+"'";
menu+=","+drfirst["visible"]+",";//是否可見(jiàn),false可見(jiàn),true不可見(jiàn)
menu+="'','1','','','','');";
menu+="msub"+three+".addsubItem(new mMenuItem("+"'"+drsecond["text"]+"'";//description
menu+=","+"'"+drsecond["url"]+"'"+",";//url
menu+="'"+drsecond["target"]+"'"+",";//target
menu+=""+drsecond["visible"]+",";//是否可見(jiàn),false可見(jiàn),true不可見(jiàn)
menu+="'"+drsecond["status"]+"'"+",";//狀態(tài)條
menu+="null,'','','',''));";
menu+="mpmenu"+one+".addItem(msub"+two+");";//addItem
three++;
}
two++;
}
one++;
}
return menu;
}
#endregion
}
3.數(shù)據(jù)庫(kù)腳本
--建表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[topmenu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[topmenu]
GO
CREATE TABLE [dbo].[topmenu] (
[ID] [int] NOT NULL ,
[parentId] [int] NOT NULL ,
[text] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[target] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[IsBoot] [int] NULL ,
[visible] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
--插入測(cè)試數(shù)據(jù)
insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(1,0,'深圳','http://singlepine.cnblogs.com/articles/259955.html','self',0,'false','深圳')
insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(2,1,'南山','http://singlepine.cnblogs.com/articles/259955.html','self',1,'false','南山')
insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(3,1,'福田','http://singlepine.cnblogs.com/articles/259955.html','self',1,'false','福田')
insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(4,2,'科技園','http://singlepine.cnblogs.com/articles/259955.html','self',2,'false','科技園')
insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(5,3,'塞格','http://singlepine.cnblogs.com/articles/259955.html','self',2,'false','塞格')
insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(6,0,'廣州','http://singlepine.cnblogs.com/articles/259955.html','self',0,'false','廣州')
insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(7,6,'廣州火車(chē)站','http://singlepine.cnblogs.com/articles/259955.html','self',1,'false','廣州火車(chē)站')