Esempio n. 1
0
        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;
        }
Esempio n. 2
0
        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;
        }