用户菜单权限管理

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using ShangGu;

namespace WindowsApp
{
 /// <summary>
 /// Form1 的摘要说明。
 /// </summary>
 public class Form1 : System.Windows.Forms.Form
 {
  private System.Windows.Forms.MainMenu mainMenu1;
  private System.Windows.Forms.Button button1;
  private System.Windows.Forms.Button button2;
  private System.Windows.Forms.MenuItem menuItem1;
  private System.Windows.Forms.MenuItem menuItem2;
  private System.Windows.Forms.MenuItem menuItem3;
  private System.Windows.Forms.MenuItem menuItem4;
  private System.Windows.Forms.MenuItem menuItem5;
  private System.Windows.Forms.MenuItem menuItem6;
  private System.Windows.Forms.MenuItem menuItem7;
  private System.Windows.Forms.MenuItem menuItem8;
  private System.Windows.Forms.MenuItem menuItem9;
  private System.Windows.Forms.MenuItem menuItem10;
  private System.Windows.Forms.MenuItem menuItem11;
  /// <summary>
  /// 必需的设计器变量。
  /// </summary>
  private System.ComponentModel.Container components = null;

  public Form1()
  {
   //
   // Windows 窗体设计器支持所必需的
   //
   InitializeComponent();

   //
   // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
   //
  }

  /// <summary>
  /// 清理所有正在使用的资源。
  /// </summary>
  protected override void Dispose( bool disposing )
  {
   if( disposing )
   {
    if (components != null)
    {
     components.Dispose();
    }
   }
   base.Dispose( disposing );
  }

  #region Windows 窗体设计器生成的代码
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.mainMenu1 = new System.Windows.Forms.MainMenu();
   this.menuItem1 = new System.Windows.Forms.MenuItem();
   this.menuItem2 = new System.Windows.Forms.MenuItem();
   this.menuItem7 = new System.Windows.Forms.MenuItem();
   this.menuItem8 = new System.Windows.Forms.MenuItem();
   this.menuItem3 = new System.Windows.Forms.MenuItem();
   this.menuItem5 = new System.Windows.Forms.MenuItem();
   this.menuItem4 = new System.Windows.Forms.MenuItem();
   this.menuItem6 = new System.Windows.Forms.MenuItem();
   this.button1 = new System.Windows.Forms.Button();
   this.button2 = new System.Windows.Forms.Button();
   this.menuItem9 = new System.Windows.Forms.MenuItem();
   this.menuItem10 = new System.Windows.Forms.MenuItem();
   this.menuItem11 = new System.Windows.Forms.MenuItem();
   this.SuspendLayout();
   //
   // mainMenu1
   //
   this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
                       this.menuItem1,
                       this.menuItem3,
                       this.menuItem4});
   //
   // menuItem1
   //
   this.menuItem1.Index = 0;
   this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
                       this.menuItem2,
                       this.menuItem9,
                       this.menuItem10});
   this.menuItem1.Text = "hjj";
   //
   // menuItem2
   //
   this.menuItem2.Index = 0;
   this.menuItem2.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
                       this.menuItem7});
   this.menuItem2.Text = "ppp";
   //
   // menuItem7
   //
   this.menuItem7.Index = 0;
   this.menuItem7.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
                       this.menuItem8});
   this.menuItem7.Text = "yyy";
   //
   // menuItem8
   //
   this.menuItem8.Index = 0;
   this.menuItem8.Text = "yyyyy";
   //
   // menuItem3
   //
   this.menuItem3.Index = 1;
   this.menuItem3.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
                       this.menuItem5});
   this.menuItem3.Text = "hhh";
   //
   // menuItem5
   //
   this.menuItem5.Index = 0;
   this.menuItem5.Text = "yy";
   //
   // menuItem4
   //
   this.menuItem4.Index = 2;
   this.menuItem4.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
                       this.menuItem6});
   this.menuItem4.Text = "hhghf";
   //
   // menuItem6
   //
   this.menuItem6.Index = 0;
   this.menuItem6.Text = "udhdfh";
   //
   // button1
   //
   this.button1.Location = new System.Drawing.Point(48, 104);
   this.button1.Name = "button1";
   this.button1.TabIndex = 0;
   this.button1.Text = "用户授权";
   this.button1.Click += new System.EventHandler(this.button1_Click);
   //
   // button2
   //
   this.button2.Location = new System.Drawing.Point(48, 136);
   this.button2.Name = "button2";
   this.button2.TabIndex = 1;
   this.button2.Text = "用户登录";
   this.button2.Click += new System.EventHandler(this.button2_Click);
   //
   // menuItem9
   //
   this.menuItem9.Index = 1;
   this.menuItem9.Text = "ghgfh";
   //
   // menuItem10
   //
   this.menuItem10.Index = 2;
   this.menuItem10.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
                        this.menuItem11});
   this.menuItem10.Text = "gfhdfh";
   //
   // menuItem11
   //
   this.menuItem11.Index = 0;
   this.menuItem11.Text = "hdfh";
   //
   // Form1
   //
   this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
   this.ClientSize = new System.Drawing.Size(292, 273);
   this.Controls.Add(this.button2);
   this.Controls.Add(this.button1);
   this.Menu = this.mainMenu1;
   this.Name = "Form1";
   this.Text = "Form1";
   this.ResumeLayout(false);

  }
  #endregion

  /// <summary>
  /// 应用程序的主入口点。
  /// </summary>
  [STAThread]
  static void Main()
  {
   Application.Run(new Form1());
  }

  

  
  private void button2_Click(object sender, System.EventArgs e)
  {
   string con=@"Auto Translate=True;User ID=sa;Tag with column collation when possible=False;Data Source=ZHANGJING;Password=sa;Initial Catalog=hotop100;Use Procedure for Prepare=1;Provider=""SQLOLEDB.1"";Persist Security Info=True;Workstation ID=ZHANGJING;Use Encryption for Data=False;Packet Size=4096";
   
   ShangGu.UserMenuManage.stTableInfo userTableinfo=new UserMenuManage.stTableInfo();
   userTableinfo.TableName="users";
   userTableinfo.Field01="usernumber";
   userTableinfo.Field02="username";
   ShangGu.UserMenuManage.stTableInfo MenuTableinfo=new UserMenuManage.stTableInfo();
   MenuTableinfo.TableName="usermenu";
   MenuTableinfo.Field01="usernumber";
   MenuTableinfo.Field02="Menu";
   ShangGu.UserMenuManage ouserMenuManage=new UserMenuManage(con,userTableinfo,MenuTableinfo,this.mainMenu1);
   ouserMenuManage.ShowUserMenu("1");
  }

  private void button1_Click(object sender, System.EventArgs e)
  {
   string con=@"Auto Translate=True;User ID=sa;Tag with column collation when possible=False;Data Source=ZHANGJING;Password=sa;Initial Catalog=hotop100;Use Procedure for Prepare=1;Provider=""SQLOLEDB.1"";Persist Security Info=True;Workstation ID=ZHANGJING;Use Encryption for Data=False;Packet Size=4096";
   
   ShangGu.UserMenuManage.stTableInfo userTableinfo=new UserMenuManage.stTableInfo();
   userTableinfo.TableName="users";
   userTableinfo.Field01="usernumber";
   userTableinfo.Field02="username";
   ShangGu.UserMenuManage.stTableInfo MenuTableinfo=new UserMenuManage.stTableInfo();
   MenuTableinfo.TableName="usermenu";
   MenuTableinfo.Field01="usernumber";
   MenuTableinfo.Field02="Menu";
   ShangGu.UserMenuManage ouserMenuManage=new UserMenuManage(con,userTableinfo,MenuTableinfo,this.mainMenu1);
   ShangGu.frmMenuManage frmu=new frmMenuManage(ouserMenuManage);
   frmu.Show();
  }

  
 }
}