private void AracSatis_Load(object sender, EventArgs e) { Giris g = new Giris(); lblad.Text = Giris.kullaniciAdi; textBox4.MaxLength = 9; ToolTip acik = new ToolTip(); acik.SetToolTip(button1, "Marka Seçiniz"); acik.SetToolTip(button3, "Tc Ekle"); acik.ToolTipTitle = "Bilgi"; acik.ToolTipIcon = ToolTipIcon.Info; acik.IsBalloon = true; acik.SetToolTip(pictureBox3, "Müşteri Tc ve Marka adı yanında bulunan butonlardan ekleme yapınız."); listele(); Random rnd = new Random(); int sayi = rnd.Next(12345, 99999); label3.Text = sayi.ToString(); comboBox5.SelectedIndex = 0; dataGridView1.Columns[0].HeaderText = "Satış Id"; dataGridView1.Columns[1].HeaderText = "Araç Şase"; dataGridView1.Columns[2].HeaderText = "Müşteri Tc"; dataGridView1.Columns[3].HeaderText = "Model"; dataGridView1.Columns[4].HeaderText = "Marka"; dataGridView1.Columns[5].HeaderText = "Vites Türü"; dataGridView1.Columns[6].HeaderText = "Yakıt Türü"; dataGridView1.Columns[7].HeaderText = "Araç Yılı"; dataGridView1.Columns[8].HeaderText = "Garanti Tarihi"; dataGridView1.Columns[9].HeaderText = "Miktar"; dataGridView1.Columns[10].HeaderText = "Birim Fiyat"; dataGridView1.Columns[11].HeaderText = "Kullanıcı"; dataGridView1.Columns[12].HeaderText = "Satış Tarih"; baglanti.Open(); SqlCommand komut = new SqlCommand("select distinct TC from musteriKayit", baglanti); SqlDataReader oku = komut.ExecuteReader(); while (oku.Read()) { comboBox5.Items.Add(oku["TC"].ToString()); } oku.Close(); baglanti.Close(); comboBox5.AutoCompleteSource = AutoCompleteSource.ListItems; }
private void AracKayit_Load(object sender, EventArgs e) { Giris g = new Giris(); lblad.Text = Giris.kullaniciAdi; this.FormBorderStyle = FormBorderStyle.FixedSingle; listele(); comboBox1.SelectedIndex = 0; comboBox2.SelectedIndex = 0; Random rnd = new Random(); int sayi = rnd.Next(12345, 99999); label9.Text = sayi.ToString(); dataGridView1.Columns[0].HeaderText = "Araç Şase"; dataGridView1.Columns[1].HeaderText = "Marka Adı"; dataGridView1.Columns[2].HeaderText = "Fabrika Adı"; dataGridView1.Columns[3].HeaderText = "Geliş Tarihi"; dataGridView1.Columns[4].HeaderText = "Miktar"; dataGridView1.Columns[5].HeaderText = "Fiyat"; dataGridView1.Columns[6].HeaderText = "Kullanıcı"; dataGridView1.Columns[7].HeaderText = "Tarih Saat"; dataGridView1.Columns[8].HeaderText = "Araç Durum"; baglanti.Open(); SqlCommand komut = new SqlCommand("select distinct fabrikadi from fabrikaKayit", baglanti); SqlDataReader oku = komut.ExecuteReader(); while (oku.Read()) { comboBox2.Items.Add(oku["fabrikadi"].ToString()); } oku.Close(); baglanti.Close(); baglanti.Open(); SqlCommand komut1 = new SqlCommand("select distinct aracmarka from markaStok", baglanti); SqlDataReader oku1 = komut1.ExecuteReader(); while (oku1.Read()) { comboBox1.Items.Add(oku1["aracmarka"].ToString()); } oku1.Close(); baglanti.Close(); }
private void servisKayit_Load(object sender, EventArgs e) { Giris g = new Giris(); lblad.Text = Giris.kullaniciAdi; this.FormBorderStyle = FormBorderStyle.FixedSingle; cmbtc.SelectedIndex = 0; cmbparcad.SelectedIndex = 0; cmbkasko.SelectedIndex = 0; Random rnd = new Random(); int sayi = rnd.Next(12345, 99999); textBox1.Text = Convert.ToString(sayi); kayıtgetır(); oku(); dataGridView1.Columns[0].HeaderText = "AraçŞase"; dataGridView1.Columns[1].HeaderText = "TC"; dataGridView1.Columns[2].HeaderText = "Parça Adı"; dataGridView1.Columns[3].HeaderText = "Araç Marka"; dataGridView1.Columns[4].HeaderText = "Araç Model"; dataGridView1.Columns[5].HeaderText = "Araç Durum"; dataGridView1.Columns[6].HeaderText = "Kasko"; dataGridView1.Columns[7].HeaderText = "Araç Plaka"; dataGridView1.Columns[8].HeaderText = "Giriş Tarih"; dataGridView1.Columns[9].HeaderText = "Çıkış Tarih"; dataGridView1.Columns[10].HeaderText = "Sigorta No"; dataGridView1.Columns[11].HeaderText = "Fiyat"; ToolTip acik = new ToolTip(); acik.SetToolTip(button2, "TC Ekle"); acik.SetToolTip(button3, "Yedek Parça Ekle"); acik.SetToolTip(button1, "Marka Seç"); cmbtc.AutoCompleteSource = AutoCompleteSource.ListItems; cmbtc.MaxLength = 11; textBox7.MaxLength = 9; textBox6.MaxLength = 9; }