private void Button12_Click(object sender, EventArgs e) { baglanti(); yeni = false; OleDbCommand cmd = new OleDbCommand("UPDATE STOKKARTI SET Cinsi='" + TextBox2.Text + "',Birimi='" + ComboBox1.Text + "',Sinifi='" + ComboBox2.Text + "',Grubu='" + ComboBox3.Text + "',RafNo='" + TextBox3.Text + "',GozNo='" + TextBox4.Text + "',Aciklama='" + TextBox5.Text + "',Fiyat='" + TextBox6.Text + "',OzelKod1='" + TextBox9.Text + "',OzelKod2='" + TextBox10.Text + "',IskontoOrani='" + TextBox7.Text + "',KDVOrani='" + TextBox8.Text + "',StokResmi='" + a + "' Where StokKodu='" + TextBox1.Text + "'", bag); cmd.ExecuteNonQuery(); MessageBox.Show("Kayıt Güncellendi.", "İŞLEM TAMAM", MessageBoxButtons.OK, MessageBoxIcon.Information); Form13 frm13 = new Form13(); frm13.tumkayitlar(); }
private void Timer2_Tick(object sender, EventArgs e) { toolStripProgressBar1.Value += 1; if (toolStripProgressBar1.Value >= 100) { Timer2.Enabled = false; if (f == 1) { toolStripProgressBar1.Style = ProgressBarStyle.Blocks; toolStripProgressBar1.Value = 0; Form frm16 = new Form16(); frm16.ShowDialog(); return; } if (f == 2) { toolStripProgressBar1.Style = ProgressBarStyle.Blocks; toolStripProgressBar1.Value = 0; Form frm10 = new Form10(); frm10.ShowDialog(); return; } if (f == 3) { toolStripProgressBar1.Style = ProgressBarStyle.Blocks; toolStripProgressBar1.Value = 0; Form frm12 = new Form12(); frm12.ShowDialog(); return; } if (f == 4) { toolStripProgressBar1.Style = ProgressBarStyle.Blocks; toolStripProgressBar1.Value = 0; this.WindowState = FormWindowState.Maximized; Form frm5 = new Form5(); frm5.ShowDialog(); } if (f == 5) { toolStripProgressBar1.Style = ProgressBarStyle.Blocks; toolStripProgressBar1.Value = 0; Form frm7 = new Form7(); frm7.ShowDialog(); return; } if (f == 6) { toolStripProgressBar1.Style = ProgressBarStyle.Blocks; toolStripProgressBar1.Value = 0; Form frm8 = new Form8(); frm8.ShowDialog(); return; } if (f == 7) { toolStripProgressBar1.Style = ProgressBarStyle.Blocks; toolStripProgressBar1.Value = 0; Form frm9 = new Form9(); frm9.ShowDialog(); return; } if (f == 8) { toolStripProgressBar1.Style = ProgressBarStyle.Blocks; toolStripProgressBar1.Value = 0; Form frm13 = new Form13(); frm13.ShowDialog(); return; } if (f == 10) { toolStripProgressBar1.Style = ProgressBarStyle.Blocks; toolStripProgressBar1.Value = 0; Form frm6 = new Form6(); frm6.ShowDialog(); return; } } }
private void Button4_Click(object sender, EventArgs e) { baglanti(); string duzen; if (TextBox1.Text == "" || TextBox2.Text == "") { duzen = Microsoft.VisualBasic.Interaction.InputBox("Güncellenecek kaydın Stok Kodunu giriniz.", "DÜZENLEME"); if (duzen == "") { return; } OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE StokKodu='" + duzen + "'", bag); OleDbDataReader oku = cmd.ExecuteReader(); if (oku.Read()) { foreach (Control c in this.Controls) { if (c is TextBox) { c.Enabled = true; } } ComboBox1.Enabled = true; ComboBox2.Enabled = true; ComboBox3.Enabled = true; Button1.Enabled = true; Button8.Enabled = true; Button9.Enabled = true; Button10.Enabled = true; Button11.Enabled = true; TextBox1.Enabled = false; TextBox1.Text = oku[0].ToString().Trim(); TextBox2.Text = oku[1].ToString().Trim(); ComboBox1.Text = oku[2].ToString().Trim(); ComboBox2.Text = oku[3].ToString().Trim(); ComboBox3.Text = oku[4].ToString().Trim(); TextBox3.Text = oku[5].ToString().Trim(); TextBox4.Text = oku[6].ToString().Trim(); TextBox5.Text = oku[7].ToString().Trim(); TextBox6.Text = oku[8].ToString().Trim(); TextBox9.Text = oku[9].ToString().Trim(); TextBox10.Text = oku[10].ToString().Trim(); TextBox7.Text = oku[11].ToString().Trim(); TextBox8.Text = oku[12].ToString().Trim(); if (oku[13].ToString() != "") { PictureBox1.Image = Image.FromFile(oku[13].ToString()); } Button12.Visible = true; Button4.Visible = false; } else { duzen = ""; MessageBox.Show("Bu stok koduna ait ürün bulunamadı.", "HATA", MessageBoxButtons.OK, MessageBoxIcon.Error); oku.Close(); return; } oku.Close(); } else { foreach (Control c in this.Controls) { if (c is TextBox) { c.Enabled = true; } } Form13 frm13 = (Form13)Application.OpenForms["Form13"]; OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE StokKodu='" + frm13.DataGridView1.CurrentRow.Cells[0].Value.ToString() + "'", bag); OleDbDataReader oku = cmd.ExecuteReader(); if (oku.Read()) { ComboBox1.Enabled = true; ComboBox2.Enabled = true; ComboBox3.Enabled = true; ComboBox1.Text = oku[2].ToString().Trim(); ComboBox2.Text = oku[3].ToString().Trim(); ComboBox3.Text = oku[4].ToString().Trim(); Button1.Enabled = true; Button8.Enabled = true; Button9.Enabled = true; Button10.Enabled = true; Button11.Enabled = true; TextBox1.Enabled = false; Button12.Visible = true; Button4.Visible = false; } } }