public MenusubResponse get_Menusub(Menusub menusub)
{
MenusubResponse menusubResponse = new MenusubResponse();
try
{
NCH.Fwk.Bd.MySql.Coneccion = NCH.Fwk.Configuration.SettingsServices.MysqlConect;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SP_CONS_MENUSUB";
cmd.Parameters.AddWithValue("@in_idmenusub", menusub.idmenusub);
cmd.Parameters.AddWithValue("@in_navigateurlsub", menusub.navigateurlsub);
cmd.Parameters.AddWithValue("@in_textsub", menusub.textsub);
cmd.Parameters.AddWithValue("@in_estadosub", menusub.estadosub);
cmd.Parameters.AddWithValue("@in_menus_idmenus", menusub.menus_idmenus);
cmd.Parameters.AddWithValue("@in_prioridadsub", menusub.prioridadsub);
menusubResponse.Result = NCH.Fwk.Bd.MySql.executar(cmd).ToList <Menusub>();
menusubResponse.ErrorCode = NCH.Fwk.Bd.MySql.ErrorCode;
menusubResponse.ErrorDescription = NCH.Fwk.Bd.MySql.ErrorDescription;
}
catch (Exception ex)
{
menusubResponse.ErrorCode = "16";
menusubResponse.ErrorDescription = ex.Message;
}
return(menusubResponse);
}
protected void RepMenuMain_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item)
{
Label lblMainMenuid = (Label)e.Item.FindControl("lblmainmenuid");
Repeater rept = (Repeater)e.Item.FindControl("RepSubMenu");
rept.DataSource = Menusub.Get_Sub_Menu_By_MainMenu_ID(Convert.ToInt32(lblMainMenuid.Text.Trim()));
rept.DataBind();
}
}
protected void RepMenuMain_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
Label lblMainMenuid = (Label)e.Item.FindControl("lblmainmenuid");
Repeater rept = (Repeater)e.Item.FindControl("RepSubMenu");
DataSet ds = Menusub.Get_Sub_Menu_By_MainMenu_ID(Convert.ToInt32(lblMainMenuid.Text.Trim()));
if (ds.Tables[0].Rows.Count > 0)
{
rept.DataSource = ds;
rept.DataBind();
}
}
