public void ListaMenu()
    {
        MenuItem menu = new MenuItem();
        BEMenu eMenu = new BEMenu();
        BERolMenu eRolMenu = new BERolMenu();
        DataTable dt = new DataTable();

        eRolUsuario.Cod_Personal = Session["IDPERSONAL"].ToString();

        try
        {
            eRolMenu.Id_Rol = Convert.ToInt32(Session["RolElegido"].ToString());
            eMenu.Id_Padre = 0;

            dt = objMenu.ConsultarMenu(eMenu, eRolMenu);
            if (dt.Rows.Count > 0)
            {
                Session["NewRol"] = Convert.ToInt32(Session["RolElegido"].ToString());
                CargaMenu(dt);
            }
        }
        catch (Exception ex)
        {
            NetAjax.JsMensajeAlert(this.Page, ex.Message);
        }
    }
예제 #2
0
        public DataTable ConsultarMenu(BEMenu eMenu, BERolMenu eRolMenu)
        {
            DataTable dt = new DataTable();
            MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Database=MECANICSWEB; Uid=Administrador; Pwd=admin");
            MySqlCommand command = new MySqlCommand("`mecanicsweb`.`ConsultarMenu`", conn);

            command.CommandType = CommandType.StoredProcedure;
            command.Parameters.Add(ObjSqlParameter("N_IDRol", eRolMenu.Id_Rol, ParameterDirection.Input, System.Data.DbType.Int32));
            command.Parameters.Add(ObjSqlParameter("N_IDPadre", eMenu.Id_Padre, ParameterDirection.Input, System.Data.DbType.Int32));
            conn.Open();
            IDataReader dr = command.ExecuteReader();
            dt.Load(dr);
            conn.Close();
            return dt;
        }
    public void CargaMenu(DataTable dt)
    {
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            MenuItem menuItem = new MenuItem();

            menuItem.Value = dt.Rows[i]["ID"].ToString();
            menuItem.Text = dt.Rows[i]["Nombre"].ToString();
            menuItem.NavigateUrl = dt.Rows[i]["Pagina"].ToString();
            menuItem.Selectable = false;
            DataTable dt2 = new DataTable();
            BEMenu eMenu = new BEMenu();
            BERolMenu eRolMenu = new BERolMenu();
            eRolMenu.Id_Rol = Convert.ToInt32(Session["NewRol"]);
            eMenu.Id_Padre = Convert.ToInt32(dt.Rows[i].ItemArray[0].ToString());
            dt2 = objMenu.ConsultarMenu(eMenu, eRolMenu);

            NavigationMenu.Items.Add(menuItem);
            AddMenuItem(menuItem, dt2);
        }
    }
예제 #4
0
 public DataTable ConsultarMenu(BEMenu objEMEnu, BERolMenu eRolMenu)
 {
     return objMenu.ConsultarMenu(objEMEnu, eRolMenu);
 }