left.aspx.cs

一个非常实用的无限级菜单源码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace test
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public partial class Left : System.Web.UI.Page
	{
		public string htmlr="";
		DbHelperSQL meth=new DbHelperSQL();
		protected void Page_Load(object sender, System.EventArgs e)
		{
			ptberu();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
		}
		#endregion


		private void ptberu()
		{
			htmlr = "<ul id='containerul'>";
       
			string sqlstr = "select ColumnId,ColunmnName  from [t_Column] where ColumnFatherld=0";
			DataTable tabfa=meth.Query(sqlstr).Tables[0];
			for (int i = 0; i < tabfa.Rows.Count; i++)//循环判断首节点
			{
				string bigClass = tabfa.Rows[i]["ColunmnName"].ToString();
				int ParentID = Convert.ToInt32(meth.Query(sqlstr).Tables[0].Rows[i]["ColumnId"].ToString());
				 
				htmlr += "<li><a href='callmenu.aspx?type=" + ParentID + "' target='main'><FONT   size=3>" + bigClass + "</font></a>";

				sonPhtion(ParentID);
				htmlr += "</li>";				 

			}
				htmlr+= "</ul>";


			htmlr +="<script type='text/javascript'>";
			htmlr +="initiate()";		// This must be placed immediately after the menu in order to format it properly.
			htmlr +="</script>";
		}



		private void sonPhtion(int ParentID)
		{
			string sontab = "select ColumnId,ColunmnName  from [t_Column] where ColumnFatherld=" + ParentID;
			DataTable tabson = meth.Query(sontab).Tables[0];
			if(tabson.Rows.Count>0)
			{
				htmlr += "<ul>";
				for (int j = 0; j < tabson.Rows.Count; j++)//循环判断子节点
				{
					string smallName = tabson.Rows[j]["ColunmnName"].ToString();

					int samllNum = Convert.ToInt32(tabson.Rows[j]["ColumnId"].ToString());
					htmlr += "<li><a href='callmenu.aspx?type=" + samllNum + "' target='main'><FONT   size=3>" + smallName + "</font></a>";
					sonPhtion(samllNum);
					htmlr += "</li>";
				}	
				htmlr += "</ul>";

			}
		}
	}
}