110,534
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [tb_Auth] (
[cAuth_Id] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cAuth_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cSupAuth_Id] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [aaaaaUA_Auth_PK] PRIMARY KEY NONCLUSTERED
(
[cAuth_Id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
insert into tb_Auth
SELECT 'P01','基础设置','P' UNION ALL
SELECT 'P02','运行管理','P' UNION ALL
SELECT 'P03','查询分析','P' UNION ALL
SELECT 'P0101','档案','P01' UNION ALL
SELECT 'P0102','人员','P01' UNION ALL
SELECT 'P0201','启动','P02' UNION ALL
SELECT 'P0202','终止','P02' UNION ALL
SELECT 'P0203','调整','P02' UNION ALL
SELECT 'P020301','延时','P0203' UNION ALL
SELECT 'P020302','复制','P0203'
private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
MessageBox.Show(e.ClickedItem.Name.ToString());
}
private void button1_Click( object sender, EventArgs e )
{
DataTable dt = GetTable();
//从顶级菜单开始加载
LoadSubMenu( dt, "P", menuStrip1.Items );
}
/// <summary>
/// 递归加载子菜单
/// </summary>
/// <param name="dt">菜单数据表</param>
/// <param name="supauthid">父菜单ID</param>
/// <param name="parent">父菜单集合</param>
private void LoadSubMenu( DataTable dt, string supauthid, ToolStripItemCollection parent )
{
DataRow[] rows = dt.Select( string.Format( "cSupAuth_Id='{0}'", supauthid ) );
foreach ( var item in rows )
{
ToolStripMenuItem menu = new ToolStripMenuItem( item["cAuth_Name"].ToString() );
parent.Add( menu );
LoadSubMenu( dt, item["cAuth_Id"].ToString(), menu.DropDownItems );
if ( menu.DropDownItems.Count == 0 )
{
//如果没有子菜单,则绑定事件
menu.Click += new EventHandler( menu_Click );
}
}
}
/// <summary>
/// 菜单单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void menu_Click( object sender, EventArgs e )
{
//这里放置你的菜单单击代码
ToolStripMenuItem menu = sender as ToolStripMenuItem;
MessageBox.Show( menu.Text );
}
/// <summary>
/// 构造测试表
/// </summary>
/// <returns></returns>
private DataTable GetTable()
{
DataTable dt = new DataTable();
DataColumn col = new DataColumn( "cAuth_Id", typeof( string ) );
dt.Columns.Add( col );
col = new DataColumn( "cAuth_Name", typeof( string ) );
dt.Columns.Add( col );
col = new DataColumn( "cSupAuth_Id", typeof( string ) );
dt.Columns.Add( col );
DataRow dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P01";
dr["cAuth_Name"] = "基础设置";
dr["cSupAuth_Id"] = "P";
dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P02";
dr["cAuth_Name"] = "运行管理";
dr["cSupAuth_Id"] = "P";
dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P03";
dr["cAuth_Name"] = "查询分析";
dr["cSupAuth_Id"] = "P";
dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P0101";
dr["cAuth_Name"] = "档案";
dr["cSupAuth_Id"] = "P01";
dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P0102";
dr["cAuth_Name"] = "人员";
dr["cSupAuth_Id"] = "P01";
dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P0201";
dr["cAuth_Name"] = "启动";
dr["cSupAuth_Id"] = "P02";
dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P0202";
dr["cAuth_Name"] = "终止";
dr["cSupAuth_Id"] = "P02";
dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P0203";
dr["cAuth_Name"] = "调整";
dr["cSupAuth_Id"] = "P02";
dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P020301";
dr["cAuth_Name"] = "延时";
dr["cSupAuth_Id"] = "P0203";
dr = dt.NewRow();
dt.Rows.Add( dr );
dr["cAuth_Id"] = "P020302";
dr["cAuth_Name"] = "复制";
dr["cSupAuth_Id"] = "P0203";
return dt;
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace WindowsApplication178
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
DataTable DT = new DataTable();
DT.Columns.Add("cAuth_Id");
DT.Columns.Add("cAuth_Name");
DT.Columns.Add("cSupAuth_Id");
DT.Rows.Add(new Object[] { "P01", "基础设置", "P" });
DT.Rows.Add(new Object[] { "P02", "运行管理", "P" });
DT.Rows.Add(new Object[] { "P03", "查询分析", "P" });
DT.Rows.Add(new Object[] { "P0101", "档案", "P01" });
DT.Rows.Add(new Object[] { "P0102", "人员", "P01" });
DT.Rows.Add(new Object[] { "P0201", "启动", "P02" });
DT.Rows.Add(new Object[] { "P0202", "终止", "P02" });
DT.Rows.Add(new Object[] { "P0203", "调整", "P02" });
DT.Rows.Add(new Object[] { "P020301", "延时", "P0203" });
DT.Rows.Add(new Object[] { "P020302", "复制", "P0203" });
SetMenuItems(DT, menuStrip1.Items, "P");
}
void SetMenuItems(DataTable DT, ToolStripItemCollection TSIC, String S)
{
DataRow[] DRS = DT.Select("cSupAuth_Id='" + S + "'");
foreach (DataRow DR in DRS)
{
ToolStripMenuItem MI = new ToolStripMenuItem(DR["cAuth_Name"].ToString());
TSIC.Add(MI);
SetMenuItems(DT, MI.DropDownItems, DR["cAuth_Id"].ToString());
}
}
}
}
#region void MakeToolStripItems(ToolStripItemCollection TSIC, ToolStripItemCollection CMSIC) // 递归创建主窗口工具条项目
/// <summary>
/// 递归创建主窗口工具条项目
/// </summary>
/// <param name="TSIC">主窗口工具条菜单项</param>
/// <param name="CMSIC">快捷菜单菜单项</param>
void MakeToolStripItems(ToolStripItemCollection TSIC, ToolStripItemCollection CMSIC)
{
for (int i = 0; i < CMSIC.Count; i++)
{
ToolStripItem Item = null;
if (CMSIC[i] is ToolStripSeparator)
{
Item = new ToolStripSeparator();
TSIC.Add(Item);
}
else
{
if (((ToolStripMenuItem)CMSIC[i]).DropDownItems.Count == 0)
Item = new ToolStripButton();
else
Item = new ToolStripDropDownButton();
Item.Text = CMSIC[i].Text;
Item.Enabled = CMSIC[i].Enabled;
Item.DisplayStyle = ToolStripItemDisplayStyle.ImageAndText;
Item.Image = CMSIC[i].Image;
Item.Tag = CMSIC[i];
CMSIC[i].Tag = Item;
ItemClick PDoItemClick = new ItemClick(DoItemClick);
Item.Click += new EventHandler(PDoItemClick);
ItemEnableChanged PDoItemEnableChanged = new ItemEnableChanged(DoItemEnableChanged);
Item.EnabledChanged += new EventHandler(PDoItemEnableChanged);
TSIC.Add(Item);
if (Item is ToolStripDropDownButton)
MakeToolStripItems(((ToolStripDropDownButton)Item).DropDownItems, ((ToolStripMenuItem)CMSIC[i]).DropDownItems);
}
}
}
#endregion