Eczane Takip Programı C#

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM1 İçerisine Yazılacak Kodlar…

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace seyda_ozdemir
{
public partial class Form1 : Form
{
public Form2 frm2;
public Form3 frm3;
public Form4 frm4;
public Form5 frm5;
public Form6 frm6;

public Form1()
{
InitializeComponent();

frm2 = new Form2();
frm3 = new Form3();
frm4 = new Form4();
frm5 = new Form5();
frm6 = new Form6();
frm2.frm1 = this;
frm3.frm1 = this;
frm4.frm1 = this;
frm5.frm1 = this;
frm6.frm1 = this;

}

public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=seyda.mdb");
public OleDbCommand kmt = new OleDbCommand();
public OleDbDataAdapter adtr = new OleDbDataAdapter();
public DataSet dtst = new DataSet();

public void güvence()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from güvence";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
frm4.comboBox1.Items.Add(oku[0].ToString());
}

bag.Close();
oku.Dispose();
frm4.comboBox1.Sorted = true;

}

public void kullan()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from kullanim1";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
frm4.comboBox2.Items.Add(oku[0].ToString());
}

bag.Close();
oku.Dispose();
frm4.comboBox2.Sorted = true;

}

public void kullan2()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from kullanim2";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
frm4.comboBox3.Items.Add(oku[0].ToString());
}

bag.Close();
oku.Dispose();
frm4.comboBox3.Sorted = true;

}

public void sgrta()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from sigorta";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
frm3.comboBox1.Items.Add(oku[0].ToString());
}

bag.Close();
oku.Dispose();
frm3.comboBox1.Sorted = true;

}

public void ilacliste()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From ilac", bag);
adtr.Fill(dtst, "ilac");
frm2.dataGridView1.DataMember = "ilac";
frm2.dataGridView1.DataSource = dtst;
adtr.Dispose();
bag.Close();
}

public void hasta()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From hasta", bag);
adtr.Fill(dtst, "hasta");
frm6.dataGridView1.DataMember = "hasta";
frm6.dataGridView1.DataSource = dtst;
adtr.Dispose();
bag.Close();
}

private void button1_Click(object sender, EventArgs e)
{
frm2.ShowDialog();

}

private void button2_Click(object sender, EventArgs e)
{
frm3.ShowDialog();

}

private void button4_Click(object sender, EventArgs e)
{
frm4.ShowDialog();

}

private void button5_Click(object sender, EventArgs e)
{
frm6.ShowDialog();

}

private void button3_Click(object sender, EventArgs e)
{
MessageBox.Show("İYİ GÜNLER");
Close();

}
}
}

FORM2 İçerisine Yazılacak Kodlar…

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace seyda_ozdemir
{
public partial class Form2 : Form
{
public Form1 frm1;
public Form5 frm5;

public Form2()
{
InitializeComponent();
}

private void Form2_Load(object sender, EventArgs e)
{
frm1.ilacliste();
dataGridView1.Columns[0].HeaderText = "Barkod No";
dataGridView1.Columns[1].HeaderText = "İlacın Adı";
dataGridView1.Columns[2].HeaderText = "Üretici Firma";
dataGridView1.Columns[3].HeaderText = "Kutu Sayısı";
dataGridView1.Columns[4].HeaderText = "Fiyatı";
dataGridView1.Columns[5].HeaderText = "kullanım Amacı";
dataGridView1.Columns[6].HeaderText = "Yan Etkileri";
dataGridView1.Columns[7].HeaderText = "İlacı Teslim Alan Personel";

}

private void button1_Click(object sender, EventArgs e)
{

frm1.frm5.ShowDialog();
}

private void button4_Click(object sender, EventArgs e)
{

frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from ilac WHERE barkod_no = '" + textBox1.Text + "'";

frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Clear();
frm1.ilacliste();

}

}

}

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM3 İçerisine Yazılacak Kodlar…

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace seyda_ozdemir
{
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}

private void Form3_Load(object sender, EventArgs e)
{
frm1.sgrta();

}

private void button1_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO pers(yaka_kart,adi_soyadi,tc_kimlik,d_tarihi,adresi,telefonu,email,ise_giris,sigortasi) VALUES ('" + textBox1.Text + "' ,'" + textBox2.Text + "' ,'" + textBox3.Text + "' ,'" + textBox4.Text + "' ,'" + textBox5.Text + "' ,'" + textBox6.Text + "' ,'" + textBox7.Text + "' ,'" + dateTimePicker1.Text + "' ,'" + comboBox1.Text + "' )";
frm1.kmt.ExecuteNonQuery();
frm1.bag.Close();
frm1.kmt.Dispose();
}

private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
comboBox1.Text = "";

}

private void button3_Click(object sender, EventArgs e)
{

this.Hide();
}
}
}

FORM4 İçerisine Yazılacak Kodlar…

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace seyda_ozdemir
{
public partial class Form4 : Form
{
public Form1 frm1;
public Form4()
{
InitializeComponent();
}

private void Form4_Load(object sender, EventArgs e)
{
frm1.güvence ();
frm1.kullan ();
frm1.kullan2();

}

private void button1_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO hasta(tc_kimlik,adi_soyadi,sosyal_güvencesi,adresi,telefonu,ilac_kullanimi,kullanim_sekli) VALUES ('" + textBox1.Text + "' ,'" + textBox2.Text + "' ,'" + comboBox1.Text+ "' ,'" + textBox3.Text + "' ,'" + textBox4.Text + "' ,'" + comboBox2.Text + "' ,'" + comboBox3.Text + "')";
frm1.kmt.ExecuteNonQuery();
frm1.bag.Close();
MessageBox.Show(" kayıt işleminiz tamamlanmıştır GEÇMİŞ OLSUN ! ");
frm1.kmt.Dispose();
}

private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
comboBox1.Text = "";
comboBox2.Text = "";
comboBox3.Text = "";

}

private void button3_Click(object sender, EventArgs e)
{
this.Hide();
}
}
}

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM5 İçerisine Yazılacak Kodlar…

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace seyda_ozdemir
{
public partial class Form5 : Form
{
public Form1 frm1;

public Form5()
{
InitializeComponent();
}

private void Form5_Load(object sender, EventArgs e)
{

}

private void button1_Click(object sender, EventArgs e)
{

}

private void button1_Click_1(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO ilac(barkod_no,ilacin_adı,uretici_firma,kutu_sayisi,fiyati,kullanim_amaci,yan_etkileri,ilac_teslim_alan) VALUES ('" + textBox1.Text + "' ,'" + textBox2.Text + "' ,'" + textBox3.Text + "' ,'" + textBox4.Text + "' ,'" + textBox5.Text + "' ,'" + textBox6.Text + "' ,'" + textBox7.Text + "' ,'" + textBox8.Text + "' )";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
MessageBox.Show("İlaç kayıt işlemi tamamlandı ! ");
frm1.dtst.Clear();
frm1.ilacliste();

}

private void button3_Click(object sender, EventArgs e)
{

this.Hide();

}

private void button2_Click(object sender, EventArgs e)
{
Close();

}

private void button4_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
}
}
}

FORM6 İçerisine Yazılacak Kodlar…

public partial class Form6 : Form
{
public Form1 frm1;

public Form6()
{
InitializeComponent();
}

private void Form6_Load(object sender, EventArgs e)
{
frm1.hasta();
dataGridView1.Columns[0].HeaderText = "Tc Kimlik";
dataGridView1.Columns[1].HeaderText = "Hastanın Adı Soyadı";
dataGridView1.Columns[2].HeaderText = "Sosyal Güvencesi";
dataGridView1.Columns[3].HeaderText = "Adresi";
dataGridView1.Columns[4].HeaderText = "Telefonu";
dataGridView1.Columns[5].HeaderText = "İalç Kullanımı";
dataGridView1.Columns[6].HeaderText = "Kullanım Şekli";

}

private void button4_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from hasta WHERE tc_kimlik = '" + textBox1.Text + "'";

frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Clear();
frm1.hasta();

}

private void button1_Click(object sender, EventArgs e)
{
frm1.frm4.ShowDialog();

}

private void button2_Click(object sender, EventArgs e)
{

this.Hide();
}
}

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

Projeyi İNDİR

Rica: Sitemizin Google'da Ön Sıralarda Çıkması İçin Lütfen Alttaki Google+ Butonuna Tıklayınız , Sayfamızı Facebookta Beğeniniz veya yazıları Twitter,Facebookta paylaşınız.