}// 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"]);
}
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"]);
}