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(); } }