本代碼是根據用戶的權限來動態生成的。
public class MenuEvent
{
private static string _flag="";
private static Form _mdi=null;
public static string flag
{
get {return _flag;}
set {_flag = value;}
}
public static Form mdi
{
get {return _mdi;}
set {_mdi = value;}
}
public MenuEvent()
{
//
// TODO: Add constructor logic here
//
}
//創建第一級菜單
public static void MakeMenuItem(ref System.Windows.Forms.MainMenu MainMenu,string strUserName,string strDeptNo)
{
flag = "";
MainMenu.MenuItems.Clear();
MenuItem m = new MenuItem();
string strSQL = "SELECT distinct y.mkbm,y.mkmc,y.sjmkbm,y.sfzjd FROM "
+ "(select a.js,b.mkbm from b_czryjs a inner join b_qxqd b on a.js=b.js "
+ "where a.yhm='"+strUserName+"' and a.bmbh='"+strDeptNo+"')x,b_mkqd y "
+ "where x.mkbm=y.mkbm order by y.mkbm";
SqlDataAdapter da = new SqlDataAdapter(strSQL,DB.SQLServer.GetConnection());
DataTable MenuTemp = new DataTable();
da.Fill(MenuTemp);
da.Dispose();