callmenu.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>
	/// callmenu 的摘要说明。
	/// </summary>
	public partial class callmenu : System.Web.UI.Page
	{
	
		DbHelperSQL meth=new DbHelperSQL();

		protected void Page_Load(object sender, System.EventArgs e)
		{
			if(!this.IsPostBack)
			{
				try
				{
					int id=Convert.ToInt32(Request.QueryString["type"].Trim());
					string parstring="select ColunmnName from t_Column where  ColumnId='"+id+"'";			
					labinfo.Text=meth.Query(parstring).Tables[0].Rows[0][0].ToString();
				}
				catch
				{}
			}
		}

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

		}
		#endregion

		protected void Button1_Click(object sender, System.EventArgs e)
		{
			try
			{
				if(TextBox1.Text.Trim()!="")
				{
					int id=Convert.ToInt32(Request.QueryString["type"].Trim());
			
					if(RadioButtonList1.SelectedIndex==0)//增加同级菜单
					{
						string parstring="select ColumnFatherld from t_Column where  ColumnId='"+id+"'";
						int parid= Convert.ToInt32(meth.Query(parstring).Tables[0].Rows[0][0].ToString());//取得父级ID
						string sqlAdd="insert into t_Column(ColumnFatherld,ColunmnName) values ('"+parid+"','"+TextBox1.Text.Trim()+"')";
						int Column= meth.ExecuteSql(sqlAdd);
						if(Column==1)
						{
							Response.Write("<script language='javascript'> alert('成功增加同级菜单！');window.open('index.aspx','_parent')</script>");
					
						}
					}
					else
					{
						string sqlAdd="insert into t_Column(ColumnFatherld,ColunmnName) values ('"+id+"','"+TextBox1.Text.Trim()+"')";
						int Column= meth.ExecuteSql(sqlAdd);
						if(Column==1)
						{
							Response.Write("<script language='javascript'> alert('成功增加子级菜单！');window.open('index.aspx','_parent')</script>");					
						}
					}
				}
			}
			catch{}

		}

		protected void Button2_Click(object sender, System.EventArgs e)
		{
			try
			{
				int id=Convert.ToInt32(Request.QueryString["type"].Trim());
				string delSql="delete t_Column  where ColumnId ='"+id+"'";
				int Column= meth.ExecuteSql(delSql);
				if(Column==1)
				{
					 Response.Write("<script language='javascript'> alert('成功删除当前菜单！');window.open('index.aspx','_parent')</script>");	
				
				}
			}
			catch{}
		}


	}
}
//5_1_a_s_p_x.c_o_m