protected void odswiez()
{
string idDzialu = (string)Session["id_dzialu"];
string txt = string.Empty;
DataTable tabelkaGW1 = new DataTable();
DataTable tabelkaGW2 = new DataTable();
DataTable tabelkaGW3 = new DataTable();
DataTable tabelkaGW4 = new DataTable();
DataTable tabelkaGW5 = new DataTable();
DataTable tabelkaGW6 = new DataTable();
DataTable tabelkaGW7 = new DataTable();
DataTable tabelkaGW8 = new DataTable();
try
{
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 1");
tabelkaGW1 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse((string)Session["id_dzialu"]), 1, Date1.Date, Date2.Date, 30, tenPlik);
Session["tabelka001"] = tabelkaGW1;
Tabela1.DataSource = null;
Tabela1.DataSourceID = null;
Tabela1.DataSource = tabelkaGW1;
Tabela1.DataBind();
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 2");
tabelkaGW2 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse((string)Session["id_dzialu"]), 2, Date1.Date, Date2.Date, 30, tenPlik);
Session["tabelka002"] = tabelkaGW2;
Gridview2.DataSource = null;
Gridview2.DataSourceID = null;
Gridview2.DataSource = tabelkaGW2;
Gridview2.DataBind();
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 3");
tabelkaGW3 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse((string)Session["id_dzialu"]), 3, Date1.Date, Date2.Date, 30, tenPlik);
Session["tabelka003"] = tabelkaGW3;
Gridview3.DataSource = null;
Gridview3.DataSourceID = null;
Gridview3.DataSource = tabelkaGW3;
Gridview3.DataBind();
try
{
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 4");
tabelkaGW4 = dr.generuj_dane_do_tabeli_wierszy2018(Date1.Date, Date2.Date, (string)Session["id_dzialu"], 4, 1, 8, tenPlik);
Session["tabelka004"] = tabelkaGW4;
//pisz("tab_05_", 10, 9, tabela02);
tab_05_w01_c1.Text = tabelkaGW4.Rows[0][1].ToString().Trim();
tab_05_w01_c2.Text = tabelkaGW4.Rows[0][2].ToString().Trim();
tab_05_w01_c3.Text = tabelkaGW4.Rows[0][3].ToString().Trim();
tab_05_w01_c4.Text = tabelkaGW4.Rows[0][4].ToString().Trim();
tab_05_w01_c5.Text = tabelkaGW4.Rows[0][5].ToString().Trim();
tab_05_w01_c6.Text = tabelkaGW4.Rows[0][6].ToString().Trim();
tab_05_w01_c7.Text = tabelkaGW4.Rows[0][7].ToString().Trim();
}
catch (Exception ex)
{
cm.log.Error(tenPlik + " tabela 4 " + ex.Message);
}
try
{
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 5");
tabelkaGW5 = dr.generuj_dane_do_tabeli_wierszy2018(Date1.Date, Date2.Date, (string)Session["id_dzialu"], 5, 8, 2, tenPlik);
Session["tabelka005"] = tabelkaGW5;
tab_06_w01_c01.Text = tabelkaGW5.Rows[0][1].ToString().Trim();
tab_06_w02_c01.Text = tabelkaGW5.Rows[1][1].ToString().Trim();
tab_06_w03_c01.Text = tabelkaGW5.Rows[2][1].ToString().Trim();
tab_06_w04_c01.Text = tabelkaGW5.Rows[3][1].ToString().Trim();
tab_06_w05_c01.Text = tabelkaGW5.Rows[4][1].ToString().Trim();
tab_06_w06_c01.Text = tabelkaGW5.Rows[5][1].ToString().Trim();
tab_06_w07_c01.Text = tabelkaGW5.Rows[6][1].ToString().Trim();
}
catch (Exception ex)
{
cm.log.Error("OGLR2: " + ex.Message);
}
try
{
Session["tabelka006"] = dr.tworzTabele(int.Parse((string)Session["id_dzialu"]), 6, Date1.Date, Date2.Date, 30, Gridview6, tenPlik);
Gridview6.DataBind();
}
catch (Exception ex)
{
cm.log.Error("OGLR2: " + ex.Message);
}
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 7");
Session["tabelka007"] = dr.tworzTabele(int.Parse((string)Session["id_dzialu"]), 7, Date1.Date, Date2.Date, 9, Gridview7, tenPlik);
Gridview7.DataBind();
}
catch (Exception ex)
{
cm.log.Error("OGLR2: " + ex.Message);
}
// dopasowanie opisów
makeLabels();
try
{
Label11.Visible = cl.debug(int.Parse(idDzialu));
infoLabel2.Visible = cl.debug(int.Parse(idDzialu));
infoLabel3.Visible = cl.debug(int.Parse(idDzialu));
infoLabel4.Visible = cl.debug(int.Parse(idDzialu));
infoLabel5.Visible = cl.debug(int.Parse(idDzialu));
infoLabel5.Visible = cl.debug(int.Parse(idDzialu));
infoLabel7.Visible = cl.debug(int.Parse(idDzialu));
infoLabel8.Visible = cl.debug(int.Parse(idDzialu));
}
catch
{
Label11.Visible = false;
infoLabel2.Visible = false;
infoLabel3.Visible = false;
infoLabel4.Visible = false;
infoLabel5.Visible = false;
infoLabel6.Visible = false;
infoLabel7.Visible = false;
infoLabel8.Visible = false;
}
Label11.Text = txt;
Label3.Text = cl.nazwaSadu((string)Session["id_dzialu"]);
}
}// end of Page_Load
protected void odswiez()
{
string idDzialu = (string)Session["id_dzialu"];
string txt = string.Empty;
DataTable tabelkaGW1 = new DataTable();
DataTable tabelkaGW2 = new DataTable();
DataTable tabelkaGW3 = new DataTable();
try
{
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 2");
tabelkaGW2 = dr.generuj_dane_do_tabeli_wierszy2018(Date1.Date, Date2.Date, (string)Session["id_dzialu"], 2, 17, 17, tenPlik);
Session["tabelkaGW002"] = tabelkaGW2;
}
catch (Exception ex)
{
cm.log.Error(tenPlik + " " + ex.Message);
}
try
{
//cm.log.Info(tenPlik + ": wczytywanie danych do tabeli 1");
tabelkaGW1 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse((string)Session["id_dzialu"]), 1, Date1.Date, Date2.Date, 16, tenPlik);
Session["tabelkaGW001"] = tabelkaGW1;
Tabela1.DataSource = null;
Tabela1.DataSourceID = null;
Tabela1.DataSource = tabelkaGW1;
Tabela1.DataBind();
}
catch (Exception ex)
{
cm.log.Error(tenPlik + " " + ex.Message);
}
try
{
cm.log.Info(tenPlik + ": wczytywanie danych do tabeli 3");
tabelkaGW3 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse((string)Session["id_dzialu"]), 3, Date1.Date, Date2.Date, 30, tenPlik);
Session["tabelkaGW003"] = tabelkaGW3;
Gridview3.DataSource = null;
Gridview3.DataSourceID = null;
Gridview3.DataSource = tabelkaGW3;
Gridview3.DataBind();
}
catch (Exception ex)
{
cm.log.Error(tenPlik + " : " + ex.Message);
}
// dopasowanie opisów
makeLabels();
try
{
Label11.Visible = cl.debug(int.Parse(idDzialu));
infoLabel2.Visible = cl.debug(int.Parse(idDzialu));
}
catch
{
Label11.Visible = false;
infoLabel2.Visible = false;
}
Label11.Text = txt;
Label3.Text = cl.nazwaSadu((string)Session["id_dzialu"]);
}
void ReleaseDesignerOutlets()
{
if (AdvancedSearchBox != null)
{
AdvancedSearchBox.Dispose();
AdvancedSearchBox = null;
}
if (AngebotNr != null)
{
AngebotNr.Dispose();
AngebotNr = null;
}
if (ArchiveButton1 != null)
{
ArchiveButton1.Dispose();
ArchiveButton1 = null;
}
if (AufWunsch != null)
{
AufWunsch.Dispose();
AufWunsch = null;
}
if (AusstattungDo != null)
{
AusstattungDo.Dispose();
AusstattungDo = null;
}
if (AusstattungOd != null)
{
AusstattungOd.Dispose();
AusstattungOd = null;
}
if (Bezeichnung != null)
{
Bezeichnung.Dispose();
Bezeichnung = null;
}
if (Binderabstand != null)
{
Binderabstand.Dispose();
Binderabstand = null;
}
if (Binderabstand2 != null)
{
Binderabstand2.Dispose();
Binderabstand2 = null;
}
if (BinderabstandCa != null)
{
BinderabstandCa.Dispose();
BinderabstandCa = null;
}
if (Breite != null)
{
Breite.Dispose();
Breite = null;
}
if (Breite2 != null)
{
Breite2.Dispose();
Breite2 = null;
}
if (BreiteCa != null)
{
BreiteCa.Dispose();
BreiteCa = null;
}
if (BreiteN != null)
{
BreiteN.Dispose();
BreiteN = null;
}
if (Cena1 != null)
{
Cena1.Dispose();
Cena1 = null;
}
if (CenaMontaz != null)
{
CenaMontaz.Dispose();
CenaMontaz = null;
}
if (ComboBox1 != null)
{
ComboBox1.Dispose();
ComboBox1 = null;
}
if (ComboBox2 != null)
{
ComboBox2.Dispose();
ComboBox2 = null;
}
if (ComboBox5 != null)
{
ComboBox5.Dispose();
ComboBox5 = null;
}
if (ComboBoxRaport != null)
{
ComboBoxRaport.Dispose();
ComboBoxRaport = null;
}
if (Dach != null)
{
Dach.Dispose();
Dach = null;
}
if (Data != null)
{
Data.Dispose();
Data = null;
}
if (DataOferty != null)
{
DataOferty.Dispose();
DataOferty = null;
}
if (DataPotwierdzenia != null)
{
DataPotwierdzenia.Dispose();
DataPotwierdzenia = null;
}
if (DeleteButton0 != null)
{
DeleteButton0.Dispose();
DeleteButton0 = null;
}
if (DeleteButton1 != null)
{
DeleteButton1.Dispose();
DeleteButton1 = null;
}
if (DeleteButton2 != null)
{
DeleteButton2.Dispose();
DeleteButton2 = null;
}
if (DeleteButton3 != null)
{
DeleteButton3.Dispose();
DeleteButton3 = null;
}
if (DeleteButton5 != null)
{
DeleteButton5.Dispose();
DeleteButton5 = null;
}
if (Down1 != null)
{
Down1.Dispose();
Down1 = null;
}
if (Down2 != null)
{
Down2.Dispose();
Down2 = null;
}
if (Down3 != null)
{
Down3.Dispose();
Down3 = null;
}
if (Firma != null)
{
Firma.Dispose();
Firma = null;
}
if (Firsthohe != null)
{
Firsthohe.Dispose();
Firsthohe = null;
}
if (Firsthohe2 != null)
{
Firsthohe2.Dispose();
Firsthohe2 = null;
}
if (FirsthoheCa != null)
{
FirsthoheCa.Dispose();
FirsthoheCa = null;
}
if (FirsthoheN != null)
{
FirsthoheN.Dispose();
FirsthoheN = null;
}
if (Gesamtpreis != null)
{
Gesamtpreis.Dispose();
Gesamtpreis = null;
}
if (Gewicht != null)
{
Gewicht.Dispose();
Gewicht = null;
}
if (Gewicht2 != null)
{
Gewicht2.Dispose();
Gewicht2 = null;
}
if (Hauptprofil1 != null)
{
Hauptprofil1.Dispose();
Hauptprofil1 = null;
}
if (Hauptprofil2 != null)
{
Hauptprofil2.Dispose();
Hauptprofil2 = null;
}
if (Hauptprofil3 != null)
{
Hauptprofil3.Dispose();
Hauptprofil3 = null;
}
if (HauptProfilGewicht != null)
{
HauptProfilGewicht.Dispose();
HauptProfilGewicht = null;
}
if (Ilosc1 != null)
{
Ilosc1.Dispose();
Ilosc1 = null;
}
if (InfoLabel1 != null)
{
InfoLabel1.Dispose();
InfoLabel1 = null;
}
if (Kedernut != null)
{
Kedernut.Dispose();
Kedernut = null;
}
if (Komentarz != null)
{
Komentarz.Dispose();
Komentarz = null;
}
if (KWert1 != null)
{
KWert1.Dispose();
KWert1 = null;
}
if (LabelTest1 != null)
{
LabelTest1.Dispose();
LabelTest1 = null;
}
if (LabelTest2 != null)
{
LabelTest2.Dispose();
LabelTest2 = null;
}
if (Lange2 != null)
{
Lange2.Dispose();
Lange2 = null;
}
if (Lange3 != null)
{
Lange3.Dispose();
Lange3 = null;
}
if (LangeCa != null)
{
LangeCa.Dispose();
LangeCa = null;
}
if (LangeN != null)
{
LangeN.Dispose();
LangeN = null;
}
if (Leichbauhalle != null)
{
Leichbauhalle.Dispose();
Leichbauhalle = null;
}
if (Liefertermin != null)
{
Liefertermin.Dispose();
Liefertermin = null;
}
if (Lieferungskosten != null)
{
Lieferungskosten.Dispose();
Lieferungskosten = null;
}
if (Lieferzeit != null)
{
Lieferzeit.Dispose();
Lieferzeit = null;
}
if (ListaOferty != null)
{
ListaOferty.Dispose();
ListaOferty = null;
}
if (Mail != null)
{
Mail.Dispose();
Mail = null;
}
if (Mail_cena != null)
{
Mail_cena.Dispose();
Mail_cena = null;
}
if (Mail_miasto != null)
{
Mail_miasto.Dispose();
Mail_miasto = null;
}
if (Mail_mm != null)
{
Mail_mm.Dispose();
Mail_mm = null;
}
if (MontageAGB != null)
{
MontageAGB.Dispose();
MontageAGB = null;
}
if (MontageBox != null)
{
MontageBox.Dispose();
MontageBox = null;
}
if (MontageSwitch != null)
{
MontageSwitch.Dispose();
MontageSwitch = null;
}
if (Name != null)
{
Name.Dispose();
Name = null;
}
if (NHN != null)
{
NHN.Dispose();
NHN = null;
}
if (NrPotwierdzenia != null)
{
NrPotwierdzenia.Dispose();
NrPotwierdzenia = null;
}
if (OpenButton1 != null)
{
OpenButton1.Dispose();
OpenButton1 = null;
}
if (Plec != null)
{
Plec.Dispose();
Plec = null;
}
if (Postlietzahl != null)
{
Postlietzahl.Dispose();
Postlietzahl = null;
}
if (PriceText1 != null)
{
PriceText1.Dispose();
PriceText1 = null;
}
if (PriceText2 != null)
{
PriceText2.Dispose();
PriceText2 = null;
}
if (RaportType != null)
{
RaportType.Dispose();
RaportType = null;
}
if (ReadyButton1 != null)
{
ReadyButton1.Dispose();
ReadyButton1 = null;
}
if (SaveButton1 != null)
{
SaveButton1.Dispose();
SaveButton1 = null;
}
if (Schneelast != null)
{
Schneelast.Dispose();
Schneelast = null;
}
if (Schneelast2 != null)
{
Schneelast2.Dispose();
Schneelast2 = null;
}
if (SearchCheckBox != null)
{
SearchCheckBox.Dispose();
SearchCheckBox = null;
}
if (SearchDlugosc != null)
{
SearchDlugosc.Dispose();
SearchDlugosc = null;
}
if (SearchSchneelast != null)
{
SearchSchneelast.Dispose();
SearchSchneelast = null;
}
if (SearchSzerokosc != null)
{
SearchSzerokosc.Dispose();
SearchSzerokosc = null;
}
if (SearchText != null)
{
SearchText.Dispose();
SearchText = null;
}
if (SearchTextField != null)
{
SearchTextField.Dispose();
SearchTextField = null;
}
if (SearchTypHali != null)
{
SearchTypHali.Dispose();
SearchTypHali = null;
}
if (SearchWindlast != null)
{
SearchWindlast.Dispose();
SearchWindlast = null;
}
if (SearchWysokosc != null)
{
SearchWysokosc.Dispose();
SearchWysokosc = null;
}
if (Select2 != null)
{
Select2.Dispose();
Select2 = null;
}
if (Stadt != null)
{
Stadt.Dispose();
Stadt = null;
}
if (Stallhalle != null)
{
Stallhalle.Dispose();
Stallhalle = null;
}
if (Starke1 != null)
{
Starke1.Dispose();
Starke1 = null;
}
if (Starke2 != null)
{
Starke2.Dispose();
Starke2 = null;
}
if (StraBe != null)
{
StraBe.Dispose();
StraBe = null;
}
if (Suma1 != null)
{
Suma1.Dispose();
Suma1 = null;
}
if (Switch3 != null)
{
Switch3.Dispose();
Switch3 = null;
}
if (SwitchTab1 != null)
{
SwitchTab1.Dispose();
SwitchTab1 = null;
}
if (Tab0 != null)
{
Tab0.Dispose();
Tab0 = null;
}
if (Tab1 != null)
{
Tab1.Dispose();
Tab1 = null;
}
if (Tab2 != null)
{
Tab2.Dispose();
Tab2 = null;
}
if (Tab3 != null)
{
Tab3.Dispose();
Tab3 = null;
}
if (Tab4 != null)
{
Tab4.Dispose();
Tab4 = null;
}
if (Tab5 != null)
{
Tab5.Dispose();
Tab5 = null;
}
if (Tab6 != null)
{
Tab6.Dispose();
Tab6 = null;
}
if (Tab7 != null)
{
Tab7.Dispose();
Tab7 = null;
}
if (Tabela1 != null)
{
Tabela1.Dispose();
Tabela1 = null;
}
if (Tabela2 != null)
{
Tabela2.Dispose();
Tabela2 = null;
}
if (Tabela3 != null)
{
Tabela3.Dispose();
Tabela3 = null;
}
if (Tabela5 != null)
{
Tabela5.Dispose();
Tabela5 = null;
}
if (TabNavi != null)
{
TabNavi.Dispose();
TabNavi = null;
}
if (TechnischeDaten != null)
{
TechnischeDaten.Dispose();
TechnischeDaten = null;
}
if (Telefonnummer != null)
{
Telefonnummer.Dispose();
Telefonnummer = null;
}
if (ToreUndTuren != null)
{
ToreUndTuren.Dispose();
ToreUndTuren = null;
}
if (Traufhohe != null)
{
Traufhohe.Dispose();
Traufhohe = null;
}
if (Traufhohe2 != null)
{
Traufhohe2.Dispose();
Traufhohe2 = null;
}
if (TraufhoheCa != null)
{
TraufhoheCa.Dispose();
TraufhoheCa = null;
}
if (TraufhoheN != null)
{
TraufhoheN.Dispose();
TraufhoheN = null;
}
if (Unterlagen != null)
{
Unterlagen.Dispose();
Unterlagen = null;
}
if (UnterlagenBox != null)
{
UnterlagenBox.Dispose();
UnterlagenBox = null;
}
if (UnterlagenSwitch != null)
{
UnterlagenSwitch.Dispose();
UnterlagenSwitch = null;
}
if (Up1 != null)
{
Up1.Dispose();
Up1 = null;
}
if (Up2 != null)
{
Up2.Dispose();
Up2 = null;
}
if (Up3 != null)
{
Up3.Dispose();
Up3 = null;
}
if (UWert1 != null)
{
UWert1.Dispose();
UWert1 = null;
}
if (UWert2 != null)
{
UWert2.Dispose();
UWert2 = null;
}
if (Vat2 != null)
{
Vat2.Dispose();
Vat2 = null;
}
if (Vorname != null)
{
Vorname.Dispose();
Vorname = null;
}
if (Windlast != null)
{
Windlast.Dispose();
Windlast = null;
}
if (Windlast2 != null)
{
Windlast2.Dispose();
Windlast2 = null;
}
if (WypChange1 != null)
{
WypChange1.Dispose();
WypChange1 = null;
}
if (WypChange2 != null)
{
WypChange2.Dispose();
WypChange2 = null;
}
if (WypChange3 != null)
{
WypChange3.Dispose();
WypChange3 = null;
}
if (X1 != null)
{
X1.Dispose();
X1 = null;
}
if (Y1 != null)
{
Y1.Dispose();
Y1 = null;
}
if (Zugbandhohe != null)
{
Zugbandhohe.Dispose();
Zugbandhohe = null;
}
if (Zugbandhohe2 != null)
{
Zugbandhohe2.Dispose();
Zugbandhohe2 = null;
}
if (ZugbandhoheCa != null)
{
ZugbandhoheCa.Dispose();
ZugbandhoheCa = null;
}
if (SearchList != null)
{
SearchList.Dispose();
SearchList = null;
}
if (SearchEmail != null)
{
SearchEmail.Dispose();
SearchEmail = null;
}
}
