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(); }