private void getMenu() { EMPLOYEE_NO = Request.QueryString["EMPLOYEE_NO"]; DEPARTMENT_NO = Request.QueryString["DEP_NO"]; rootCfg = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/petroneeds"); connection = rootCfg.ConnectionStrings.ConnectionStrings["petroneedsConnectionString2"].ConnectionString.ToString(); conn = new SqlConnection(connection); conn.ConnectionString = connection; conn.Open(); DataTable table = new DataTable(); string sql = "Select * from tbl_WebMenu INNER JOIN User_Check ON (tbl_WebMenu.MenuID = User_Check.MenuID)" + //"AND (User_Check.MenuID = tbl_WebMenu.ParentID)" + "AND (User_Check.EmpNumber = '" + EMPLOYEE_NO + "' ) AND (User_Check.STATUS = '" + 1 + "')"; SqlDataAdapter da = new SqlDataAdapter(sql, conn); da.Fill(table); DataView view = new DataView(table); view.RowFilter = "ParentID=0"; foreach (DataRowView row in view) { MenuItem menuItem = new MenuItem(row["MenuName"].ToString(), row["MenuID"].ToString()); menuItem.NavigateUrl = row["MenuID"].ToString() + row["MenuLocation"] + "?EMPLOYEE_NO=" + EMPLOYEE_NO.ToString() + "&DEP_NO=" + DEPARTMENT_NO.ToString(); menuBar.Items.Add(menuItem); AddChildItems(table, menuItem); } conn.Close(); }
private void AddChildItems(DataTable table, MenuItem menuItem) { DataView viewItem = new DataView(table); viewItem.RowFilter = "ParentID=" + menuItem.Value; foreach (DataRowView childView in viewItem) { MenuItem childItem = new MenuItem(childView["MenuName"].ToString(), childView["MenuID"].ToString()); // childItem.NavigateUrl = childView["MenuLocation"].ToString(); childItem.NavigateUrl = childView["MenuLocation"].ToString() + "?EMPLOYEE_NO=" + EMPLOYEE_NO.ToString() + "&DEP_NO=" + DEPARTMENT_NO.ToString(); menuItem.ChildItems.Add(childItem); AddChildItems(table, childItem); } }
private void getMenu() { EMPLOYEE_NO = Request.QueryString["EMPLOYEE_NO"]; DEPARTMENT_NO = Request.QueryString["DEP_NO"]; rootCfg = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/petroneeds"); connection = rootCfg.ConnectionStrings.ConnectionStrings["petroneedsConnectionString2"].ConnectionString.ToString(); sqlconn = new SqlConnection(connection); sqlconn.ConnectionString = connection; sqlconn.Open(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); //string sql = "Select * from tbl_WebMenu"; string sql = "Select * from tbl_WebMenu INNER JOIN User_Check ON (tbl_WebMenu.MenuID = User_Check.MenuID)" + //"AND (User_Check.MenuID = tbl_WebMenu.ParentID)" + "AND (User_Check.EmpNumber = '" + EMPLOYEE_NO + "' ) AND (User_Check.STATUS = '" + 1 + "')"; SqlDataAdapter da = new SqlDataAdapter(sql, sqlconn); da.Fill(ds); dt = ds.Tables[0]; DataRow[] drowpar = dt.Select("ParentID=" + 0); foreach (DataRow dr in drowpar) { menuBar.Items.Add(new System.Web.UI.WebControls.MenuItem(dr["MenuName"].ToString(), dr["MenuID"].ToString(), "", dr["MenuLocation"].ToString())); } foreach (DataRow dr in dt.Select("ParentID >" + 0)) { System.Web.UI.WebControls.MenuItem mnu = new System.Web.UI.WebControls.MenuItem(dr["MenuName"].ToString(), //dr["MenuID"].ToString(), "", dr["MenuLocation"] + "?EMPLOYEE_NO=" + EMPLOYEE_NO.ToString()); //dr["MenuID"].ToString(),"", dr["MenuLocation"].ToString()); dr["MenuID"].ToString(), "", dr["MenuLocation"] + "?EMPLOYEE_NO=" + EMPLOYEE_NO.ToString() + "&DEP_NO=" + DEPARTMENT_NO.ToString()); //dr["MenuID"].ToString(),"", dr["MenuLocation"].ToString()); menuBar.FindItem(dr["ParentID"].ToString()).ChildItems.Add(mnu); } sqlconn.Close(); }