private void button2_Click(object sender, EventArgs e) { frmGirisFisiEkle grsfisi = new frmGirisFisiEkle(); grsfisi.Show(); this.Hide(); }
private void dataGridView1_MouseDoubleClick(object sender, MouseEventArgs e) { try { if (cikisfisi == true) { int MusteriRef = Convert.ToInt32(dataGridView1["MusteriRef", dataGridView1.CurrentCell.RowIndex].Value); string kod = dataGridView1["MusteriKodu", dataGridView1.CurrentCell.RowIndex].Value.ToString(); string adi = dataGridView1["MusteriAdi", dataGridView1.CurrentCell.RowIndex].Value.ToString(); frmCikisFisiEkle frm = (frmCikisFisiEkle)Application.OpenForms["frmCikisFisiEkle"]; frm.MusteriUnvaniTxt.Text = adi; frm.MusteriKoduTxt.Text = kod; frm.MusteriIdLbl.Text = MusteriRef.ToString(); indis++; cikisfisi = false; this.Hide(); } else { int MusteriRef = Convert.ToInt32(dataGridView1["MusteriRef", dataGridView1.CurrentCell.RowIndex].Value); string kod = dataGridView1["MusteriKodu", dataGridView1.CurrentCell.RowIndex].Value.ToString(); string adi = dataGridView1["MusteriAdi", dataGridView1.CurrentCell.RowIndex].Value.ToString(); frmGirisFisiEkle frm = (frmGirisFisiEkle)Application.OpenForms["frmGirisFisiEkle"]; frm.MusteriUnvaniTxt.Text = adi; frm.MusteriKoduTxt.Text = kod; frm.MusteriIdLbl.Text = MusteriRef.ToString(); indis++; this.Hide(); } } catch (Exception) { MessageBox.Show("Geçersiz"); return; } }
private void dataGridView1_MouseClick(object sender, MouseEventArgs e) { int row_index = dataGridView1.HitTest(e.X, e.Y).RowIndex; int[] selectedIndexes = new int[dataGridView1.SelectedRows.Count]; if (girisfistable.Rows.Count < 1) { return; } if (e.Button == MouseButtons.Right) { ContextMenu menu = new ContextMenu(); MenuItem item = new MenuItem("Güncelle"); if (row_index == null || row_index < 0 || row_index >= girisfistable.Rows.Count) { return; } item.Click += new EventHandler(delegate(object s, EventArgs args) { string fisid = dataGridView1.Rows[row_index].Cells["FisId"].Value.ToString(); frmGirisFisiEkle girsekle = new frmGirisFisiEkle(); girsekle.fisid = fisid; girsekle.Show(); this.Hide(); }); menu.MenuItems.Add(item); item = new MenuItem("Sil"); item.Click += new EventHandler(delegate(object s, EventArgs args) { if (row_index == null || row_index < 0 || row_index >= girisfistable.Rows.Count) { return; } string fisidsil = dataGridView1.Rows[row_index].Cells["FisId"].Value.ToString(); string fisharaketid = dataGridView1.Rows[row_index].Cells["FisHaraketId"].Value.ToString(); if (MessageBox.Show("Silmek İstediğinize Eminmisiniz?", "Uyarı", MessageBoxButtons.YesNo) == DialogResult.Yes) { string adet = "select * from FisHaraket where FisTipi=1 and FisId=" + fisidsil; DataTable kontroltable = DataBase.select(adet); if (kontroltable.Rows.Count > 1) { string fisharaketsil = "Delete from FisHaraket where FisHaraketId=" + fisharaketid; DataBase.ExecSql(fisharaketsil); string stoksil = "Delete from Stok where FisHaraketId=" + fisharaketid; DataBase.ExecSql(stoksil); MessageBox.Show("Silindi"); string sorgu = @"select fb.FisId,fb.FisNo,fb.Tarih,urn.UrunAdi,fh.Miktar,fh.Birim,fh.FisHaraketId from FisBaslik fb, FisHaraket fh ,Urunler urn where fb.FisId = fh.FisId and fh.UrunRef = urn.UrunRef and fh.FisTipi = 1"; girisfistable = DataBase.select(sorgu); dataGridView1.DataSource = girisfistable; dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[6].Visible = false; } else { string fisbasliksil = "Delete from FisBaslik where FisId=" + fisidsil; string fisharaketsil = "Delete from FisHaraket where FisHaraketId=" + fisharaketid; string stoksil = "Delete from Stok where FisHaraketId=" + fisharaketid; DataBase.ExecSql(fisbasliksil); DataBase.ExecSql(fisharaketsil); DataBase.ExecSql(stoksil); MessageBox.Show("Silindi"); string sorgu = @"select fb.FisId,fb.FisNo,fb.Tarih,urn.UrunAdi,fh.Miktar,fh.Birim,fh.FisHaraketId from FisBaslik fb, FisHaraket fh ,Urunler urn where fb.FisId = fh.FisId and fh.UrunRef = urn.UrunRef and fh.FisTipi = 1"; girisfistable = DataBase.select(sorgu); dataGridView1.DataSource = girisfistable; dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[6].Visible = false; } } }); menu.MenuItems.Add(item); menu.Show(dataGridView1, new Point(e.X, e.Y)); } }