protected void Page_Load(object sender, EventArgs e) { //Do przekazania z drzewa - co jest rozwinięte (strategia, cel czy dzialanie) i id tego czegos rozwiniętego // jezeli bedzie kilka galezi rozwiniętch jednoczesnie? (? lista parametrow? po przecinku ?) int strategyNr = 3, targetNr = 16, subtargetNr = 27, dzialNr = 6;// do testow DataFetcher dataFetcher = new DataFetcher(); String query; //Wszystkie strategie query = "SELECT id, id_parent, lp, nazwa_strategii AS tresc, nazwa_jednostki, widocznosc FROM strategia"; SqlDataAdapter strategies = dataFetcher.getSelectResultsAsSQLDataAdapter(query); //wszystkie cele query = "SELECT id, lp, id_strategii, id_parent, tresc, widocznosc FROM cel WHERE id_parent is null"; SqlDataAdapter targets = dataFetcher.getSelectResultsAsSQLDataAdapter(query); //podcele do konkretnego celu query = "SELECT id, lp, id_strategii, id_parent, tresc, widocznosc FROM cel " + "WHERE id_parent = " + targetNr + ";"; SqlDataAdapter subTargets = dataFetcher.getSelectResultsAsSQLDataAdapter(query); //dzialania do konkretnego celu/podcelu query = "SELECT * FROM dzialanie_cel INNER JOIN dzialanie " + "ON dzialanie_cel.id_celu = " + targetNr +";"; SqlDataAdapter operations = dataFetcher.getSelectResultsAsSQLDataAdapter(query); DataTable dt = dataFetcher.getSelectResultsAsDataTable("SELECT id, lp, tresc from cel where id_strategii = " + strategyNr + ";"); int no = dt.Rows.Count; for (int i=0; i<no; i++) // dla wszytskich wyciagnietych wierszy { TableRow row = new TableRow(); String id = dt.Rows[0]["id"].ToString(); //liczba porządkowa TableCell lpCell = new TableCell(); lpCell.CssClass = "lpCells"; lpCell.Controls.Add(new LiteralControl(strategyNr + "." + dt.Rows[i]["lp"].ToString())); row.Cells.Add(lpCell); //tresc TableCell contentCell = new TableCell(); contentCell.CssClass = "contentCells"; contentCell.Controls.Add(new LiteralControl(dt.Rows[i]["tresc"].ToString())); row.Cells.Add(contentCell); // wszystkie guziki TableCell buttonCell = new TableCell(); buttonCell.CssClass = "buttonCells"; buttonCell.Width = 66; //dodaj ImageButton addButton = new ImageButton(); // addButton.ID = "addButton_" + id; addButton.ImageUrl = "add.png"; addButton.Enabled = true; addButton.Visible = true; addButton.Height = 22; addButton.Width = 22; addButton.OnClientClick = "javascript:Popup(" + id + "," + strategyNr + "," + 0 + ");"; buttonCell.Controls.Add(addButton); //edytuj ImageButton editButton = new ImageButton(); // editButton.ID = "editButton_" + id; editButton.ImageUrl = "edit.png"; editButton.Enabled = true; editButton.Visible = true; editButton.Height = 22; editButton.Width = 22; editButton.OnClientClick = "javascript:Popup(" + id + "," + strategyNr + "," + 1 + ");"; buttonCell.Controls.Add(editButton); //usun //niebezpiczne usuwanie ImageButton deleteButton = new ImageButton(); // deleteButton.ID = "deleteButton_" + id; deleteButton.ImageUrl = "delete.png"; deleteButton.Enabled = true; deleteButton.Visible = true; deleteButton.Height = 22; deleteButton.Width = 22; deleteButton.OnClientClick = "javascript:Popup(" + id + "," + strategyNr + "," + 1 + ");"; buttonCell.Controls.Add(deleteButton); row.Cells.Add(buttonCell); TargetTable.Rows.Add(row); } }