private void dgw_prj_list_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
proje_duzenle obj = new proje_duzenle();
proje_no = dgw_prj_list.Rows[e.RowIndex].Cells[0].Value.ToString();
proje_adi = dgw_prj_list.Rows[e.RowIndex].Cells[1].Value.ToString();
butce = dgw_prj_list.Rows[e.RowIndex].Cells[2].Value.ToString();
birim = dgw_prj_list.Rows[e.RowIndex].Cells[3].Value.ToString();
musteri = dgw_prj_list.Rows[e.RowIndex].Cells[4].Value.ToString();
baslangic = Convert.ToDateTime(dgw_prj_list.Rows[e.RowIndex].Cells[5].Value.ToString());
bitis = Convert.ToDateTime(dgw_prj_list.Rows[e.RowIndex].Cells[6].Value.ToString());
vade = dgw_prj_list.Rows[e.RowIndex].Cells[7].Value.ToString();
aciklama = dgw_prj_list.Rows[e.RowIndex].Cells[8].Value.ToString();
harcamalar = dgw_prj_list.Rows[e.RowIndex].Cells[9].Value.ToString();
harcama_birim = dgw_prj_list.Rows[e.RowIndex].Cells[10].Value.ToString();
flag = dgw_prj_list.Rows[e.RowIndex].Cells[11].Value.ToString();
myConnection.Close();
myConnection.Open();
komut = "SELECT * FROM db_projeler WHERE proje_no='" + proje_no + "' AND proje_ismi='" + proje_adi + "'";
da = new MySqlDataAdapter(komut, connection);
// myConnection = new MySqlConnection(connectionString);
myCommand = new MySqlCommand(komut, myConnection);
// myConnection.Open();
MySqlDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read())
{
id = myReader.GetString(0);
harcama_m_mlz = myReader.GetString(10);
harcama_el_mlz = myReader.GetString(11);
harcama_imalat = myReader.GetString(12);
harcama_test = myReader.GetString(13);
harcama_risk = myReader.GetString(14);
odeme_avans = myReader.GetString(17);
dtp_avans = Convert.ToDateTime(myReader.GetString(18));
odeme_pdr = myReader.GetString(19);
dtp_pdr = Convert.ToDateTime(myReader.GetString(20));
odeme_cdr = myReader.GetString(21);
dtp_cdr = Convert.ToDateTime(myReader.GetString(22));
odeme_prototip = myReader.GetString(23);
dtp_prototip = Convert.ToDateTime(myReader.GetString(24));
odeme_test = myReader.GetString(25);
dtp_test = Convert.ToDateTime(myReader.GetString(26));
odeme_kabul = myReader.GetString(27);
dtp_kabul = Convert.ToDateTime(myReader.GetString(28));
s6 = myReader.GetString(29);
dtp_s6 = Convert.ToDateTime(myReader.GetString(30));
}
myReader.Close();
}
private void btn_kaydet_Click(object sender, EventArgs e)
{
txt_avans.Text = hf.Comma2Dot(txt_avans.Text);
txt_cdr.Text = hf.Comma2Dot(txt_cdr.Text);
txt_el_mlz.Text = hf.Comma2Dot(txt_el_mlz.Text);
txt_imalat.Text = hf.Comma2Dot(txt_imalat.Text);
txt_kabul.Text = hf.Comma2Dot(txt_kabul.Text);
txt_m_mlz.Text = hf.Comma2Dot(txt_m_mlz.Text);
txt_o_test.Text = hf.Comma2Dot(txt_o_test.Text);
txt_pdr.Text = hf.Comma2Dot(txt_pdr.Text);
txt_prototip.Text = hf.Comma2Dot(txt_prototip.Text);
txt_risk.Text = hf.Comma2Dot(txt_risk.Text);
txt_test.Text = hf.Comma2Dot(txt_test.Text);
txt_toplam.Text = hf.Comma2Dot(txt_toplam.Text);
txt_s6.Text = hf.Comma2Dot(txt_s6.Text);
txt_toplam.Text = Convert.ToString(Convert.ToDecimal(txt_test.Text) + Convert.ToDecimal(txt_risk.Text) + Convert.ToDecimal(txt_m_mlz.Text) + Convert.ToDecimal(txt_imalat.Text) + Convert.ToDecimal(txt_el_mlz.Text));
proje_giris f1 = (proje_giris)Application.OpenForms["proje_giris"];
proje_duzenle f2 = (proje_duzenle)Application.OpenForms["proje_duzenle"];
if (f1 != null)
{
Label label_harcamalar = (Label)f1.Controls["lbl_harcamalar"];
Label label_birim = (Label)f1.Controls["lbl_birim"];
label_harcamalar.Text = txt_toplam.Text.ToString();
label_birim.Text = cmb_toplam_brm.Text.ToString();
f1.harcama_m_mlz = Convert.ToString(txt_m_mlz.Text);
f1.harcama_el_mlz = Convert.ToString(txt_el_mlz.Text);
f1.harcama_imalat = Convert.ToString(txt_imalat.Text);
f1.harcama_test = Convert.ToString(txt_test.Text);
f1.harcama_risk = Convert.ToString(txt_risk.Text);
f1.odeme_avans = Convert.ToString(txt_avans.Text);
f1.odeme_pdr = Convert.ToString(txt_pdr.Text);
f1.odeme_cdr = Convert.ToString(txt_cdr.Text);
f1.odeme_prototip = Convert.ToString(txt_prototip.Text);
f1.odeme_test = Convert.ToString(txt_o_test.Text);
f1.odeme_kabul = Convert.ToString(txt_kabul.Text);
f1.s6 = Convert.ToString(txt_s6.Text);
f1.dtp_avans = Convert.ToDateTime(dtp_avans.Text);
f1.dtp_cdr = Convert.ToDateTime(dtp_cdr.Text);
f1.dtp_kabul = Convert.ToDateTime(dtp_kabul.Text);
f1.dtp_prototip = Convert.ToDateTime(dtp_prototip.Text);
f1.dtp_pdr = Convert.ToDateTime(dtp_pdr.Text);
f1.dtp_test = Convert.ToDateTime(dtp_test.Text);
f1.dtp_s6 = Convert.ToDateTime(dtp_s6.Text);
}
else
{
Label label_harcamalar = (Label)f2.Controls["lbl_harcamalar"];
Label label_birim = (Label)f2.Controls["lbl_birim"];
label_harcamalar.Text = txt_toplam.Text.ToString();
label_birim.Text = cmb_toplam_brm.Text.ToString();
f2.harcama_m_mlz = Convert.ToString(txt_m_mlz.Text);
f2.harcama_el_mlz = Convert.ToString(txt_el_mlz.Text);
f2.harcama_imalat = Convert.ToString(txt_imalat.Text);
f2.harcama_test = Convert.ToString(txt_test.Text);
f2.harcama_risk = Convert.ToString(txt_risk.Text);
f2.odeme_avans = Convert.ToString(txt_avans.Text);
f2.odeme_pdr = Convert.ToString(txt_pdr.Text);
f2.odeme_cdr = Convert.ToString(txt_cdr.Text);
f2.odeme_prototip = Convert.ToString(txt_prototip.Text);
f2.odeme_test = Convert.ToString(txt_o_test.Text);
f2.odeme_kabul = Convert.ToString(txt_kabul.Text);
f2.s6 = Convert.ToString(txt_s6.Text);
f2.dtp_avans = Convert.ToDateTime(dtp_avans.Text);
f2.dtp_cdr = Convert.ToDateTime(dtp_cdr.Text);
f2.dtp_kabul = Convert.ToDateTime(dtp_kabul.Text);
f2.dtp_prototip = Convert.ToDateTime(dtp_prototip.Text);
f2.dtp_pdr = Convert.ToDateTime(dtp_pdr.Text);
f2.dtp_test = Convert.ToDateTime(dtp_test.Text);
f2.dtp_s6 = Convert.ToDateTime(dtp_s6.Text);
}
this.Close();
}
private void btn_prj_duzenle_Click(object sender, EventArgs e)
{
proje_duzenle obj = new proje_duzenle();
obj.lbl_id.Text = id;
obj.cmb_birim.Text = birim;
obj.txt_butce.Text = butce;
obj.txt_musteri.Text = musteri;
obj.txt_proje_adi.Text = proje_adi;
obj.txt_proje_no.Text = proje_no;
obj.dtp_baslangıc.Value = baslangic;
obj.dtp_bitis.Value = bitis;
obj.txt_vade.Text = vade;
obj.rcb_aciklama.Text = aciklama;
obj.lbl_harcamalar.Text = harcamalar;
obj.lbl_birim.Text = harcama_birim;
if (flag == "S")
{
obj.ck_seri.Checked = true;
}
else
{
obj.ck_prj.Checked = true;
}
obj.Show();
harcama_ongorusu ho = new harcama_ongorusu();
if (flag == "S")
{
ho.lbl_pdr.Text = "S1";
ho.lbl_cdr.Text = "S2";
ho.lbl_prototip.Text = "S3";
ho.lbl_kabul.Text = "S5";
ho.lbl_test.Text = "S4";
ho.lbl_s6.Enabled = true;
ho.txt_s6.Enabled = true;
ho.dtp_s6.Enabled = true;
}
else
{
ho.lbl_pdr.Text = "PDR";
ho.lbl_cdr.Text = "CDR";
ho.lbl_prototip.Text = "Prototip";
ho.lbl_kabul.Text = "Kabul";
ho.lbl_test.Text = "Test";
ho.lbl_s6.Enabled = false;
ho.txt_s6.Enabled = false;
ho.dtp_s6.Enabled = false;
}
ho.txt_m_mlz.Text = harcama_m_mlz;
ho.txt_el_mlz.Text = harcama_el_mlz;
ho.txt_imalat.Text = harcama_imalat;
ho.txt_test.Text = harcama_test;
ho.txt_risk.Text = harcama_risk;
ho.txt_avans.Text = odeme_avans;
ho.txt_pdr.Text = odeme_pdr;
ho.txt_cdr.Text = odeme_cdr;
ho.txt_prototip.Text = odeme_prototip;
ho.txt_o_test.Text = odeme_test;
ho.txt_kabul.Text = odeme_kabul;
ho.txt_s6.Text = s6;
ho.dtp_avans.Value = dtp_avans;
ho.dtp_pdr.Value = dtp_pdr;
ho.dtp_cdr.Value = dtp_cdr;
ho.dtp_prototip.Value = dtp_prototip;
ho.dtp_test.Value = dtp_test;
ho.dtp_kabul.Value = dtp_kabul;
ho.dtp_s6.Value = dtp_s6;
ho.Show();
}
