//6.2
public static Historie_zakazek Select(int idHis, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
SqlCommand command = db.CreateCommand(SQL_SELECT);
command.Parameters.AddWithValue("@idHis", idHis);
SqlDataReader reader = db.Select(command);
Historie_zakazek Historie_zakazky = Read_historie_one(reader);
reader.Close();
if (pDb == null)
{
db.Close();
}
return(Historie_zakazky);
}
private void load(int zakazka)
{
Historie_zakazek h = ShowHistorieZakazek.Select(zakazka);
string[] r = { h.Idhis.ToString(), h.Datumod.ToString(), h.Datumdo.ToString(), h.Typ_zakazky_idtyp.Jmeno_zakazky.ToString(), h.Zakazka_idzak.Objednavatel_idobj.Jmeno_objednavatele.ToString(),
h.Zakazka_idzak.Geodet_idgeo.Jmeno_geodeta.ToString() + " " + h.Zakazka_idzak.Geodet_idgeo.Prijmeni_geodeta.ToString(), h.Zakazka_idzak.Cena.ToString() };
listView1.Items.Add(new ListViewItem(r));
}
//Dvojkliknuti na ID vybrané položky zobrazí detail záznamu (funkce 6.2)
private void listView1_ItemActivate(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
ListViewItem item = listView1.SelectedItems[0];
int b = Int32.Parse(item.SubItems[0].Text);
Historie_zakazek h = ShowHistorieZakazek.Select(b);
Detail_His_Zakazky form = new Detail_His_Zakazky(b);
form.Show();
}
}
public static Historie_zakazek Read_historie_one(SqlDataReader reader)
{
Historie_zakazek historie = new Historie_zakazek();
while (reader.Read())
{
int i = -1;
historie.Idhis = reader.GetInt32(++i);
historie.Datumod = reader.GetDateTime(++i);
historie.Datumdo = reader.GetDateTime(++i);
historie.Zakazka_idzak = ShowZakazka.Detail_zakazky(reader.GetInt32(++i));
historie.Typ_zakazky_idtyp = ShowTypZakazek.Detail_typu_zakazky(reader.GetInt32(++i));
}
return(historie);
}
public static Collection <Historie_zakazek> Read_historie(SqlDataReader reader)
{
Collection <Historie_zakazek> zakazky = new Collection <Historie_zakazek>();
//Collection<Zakazka> zak = ShowZakazka.Select_Aktualni();
while (reader.Read())
{
Historie_zakazek historie = new Historie_zakazek();
int i = -1;
historie.Idhis = reader.GetInt32(++i);
historie.Datumod = reader.GetDateTime(++i);
historie.Datumdo = reader.GetDateTime(++i);
historie.Zakazka_idzak = ShowZakazka.Detail_zakazky(reader.GetInt32(++i));
historie.Typ_zakazky_idtyp = ShowTypZakazek.Detail_typu_zakazky(reader.GetInt32(++i));
zakazky.Add(historie);
}
return(zakazky);
}
