void siparis()
{
baglanti.Open();
try
{
komut = new OleDbCommand("Select * from ecz_sipar where istek=true", baglanti);
OleDbDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
String a = dr["eczane_adi"].ToString();
// comboBox1.Text = dr["eczane_adi"].ToString();
ilal.Hide();
ilsatdurumu.Hide();
kasadurum.Hide();
ilsat.Show();
Bilgi.Hide();
eczsilgb.Hide();
ecz_ekle.Hide();
eczduzenle.Hide();
ilacbil.Show();
this.ecz_siparTableAdapter.Fill(this.girisDataSet.ecz_sipar);
this.eczaneTableAdapter.Fill(this.girisDataSet.eczane);
this.ilacTableAdapter.Fill(this.girisDataSet.ilac);
}
}
catch (Exception) {
}
baglanti.Close();
}
private void EczaDeposu1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'girisDataSet.kasa1' table. You can move, or remove it, as needed.
this.kasa1TableAdapter.Fill(this.girisDataSet.kasa1);
// TODO: This line of code loads data into the 'girisDataSet.durum' table. You can move, or remove it, as needed.
this.durumTableAdapter.Fill(this.girisDataSet.durum);
// TODO: This line of code loads data into the 'girisDataSet.ecz_sipar' table. You can move, or remove it, as needed.
this.ecz_siparTableAdapter.Fill(this.girisDataSet.ecz_sipar);
this.eczaneTableAdapter.Fill(this.girisDataSet.eczane);
this.ilacTableAdapter.Fill(this.girisDataSet.ilac);
// TODO: This line of code loads data into the 'girisDataSet.eczane' table. You can move, or remove it, as needed.
// TODO: This line of code loads data into the 'girisDataSet.eczane_sip' table. You can move, or remove it, as needed.
// TODO: This line of code loads data into the 'girisDataSet.ilac' table. You can move, or remove it, as needed.
// TODO: This line of code loads data into the 'girisDataSet.eczane' table. You can move, or remove it, as needed.
timer1.Interval = 10000;
timer1.Start();
ilal.Hide();
ilsat.Hide();
Bilgi.Hide();
eczsilgb.Hide();
ecz_ekle.Hide();
eczduzenle.Hide();
eczkulgenel.Hide();
ilacbil.Hide();
ilsatdurumu.Hide();
kasadurum.Hide();
}
private void karZararToolStripMenuItem_Click(object sender, EventArgs e)
{
kasadurum.Show();
ilal.Hide();
ilsat.Hide();
Bilgi.Hide();
eczsilgb.Hide();
ecz_ekle.Hide();
eczduzenle.Hide();
eczkulgenel.Hide();
ilacbil.Hide();
ilsatdurumu.Hide();
}
private void goster_Click(object sender, EventArgs e)
{
ilacbil.Show();
ilal.Hide();
ilsat.Show();
Bilgi.Hide();
eczsilgb.Hide();
ecz_ekle.Hide();
eczduzenle.Hide();
eczkulgenel.Hide();
ilsatdurumu.Hide();
kasadurum.Hide();
/* siparis();*/
}
private void eczaneEkleToolStripMenuItem_Click(object sender, EventArgs e)
{
kasadurum.Hide();
ilsatdurumu.Hide();
ilacbil.Hide();
ilal.Hide();
ilsat.Hide();
Bilgi.Hide();
eczsilgb.Hide();
ecz_ekle.Show();
eczduzenle.Hide();
eczkulgenel.Show();
this.ecz_siparTableAdapter.Fill(this.girisDataSet.ecz_sipar);
this.eczaneTableAdapter.Fill(this.girisDataSet.eczane);
this.ilacTableAdapter.Fill(this.girisDataSet.ilac);
}