private void buttonCariKodSec_Click(object sender, System.EventArgs e) { if (SiparisIliski) { Sec s = new Sec(); s.sql = "SELECT DISTINCT TOP 10 siparisler.SiparisNo, siparisler.CariKodu, cari_tanim.CariAdi, siparisler.AlisSatis, siparisler.SevkAdresi FROM siparisler INNER JOIN cari_tanim ON siparisler.CariKodu = cari_tanim.CariKodu"; s.sql_orderby = " ORDER BY siparisler.SiparisNo"; s.tablename = "siparisler"; s.ShowDialog(); if (s.dr != null) { textBoxCariKod.Text = s.dr["CariKodu"].ToString(); textBoxIrsaliyeNo.Text = s.dr["SiparisNo"].ToString(); labelCariAdi.Text = s.dr["CariAdi"].ToString(); labelSevk.Text = s.dr["SevkAdresi"].ToString(); } } else { Sec s = new Sec(); s.sql = "SELECT TOP 10 CariKodu,CariAdi FROM cari_tanim (NOLOCK)"; s.sql_orderby = " ORDER BY CariKodu"; s.tablename = "cari_tanim"; s.ShowDialog(); if (s.dr != null) { textBoxCariKod.Text = s.dr["CariKodu"].ToString(); labelCariAdi.Text = s.dr["CariAdi"].ToString(); } } }
private void button9_Click(object sender, System.EventArgs e) { Sec s = new Sec(); s.sql = "SELECT TOP 10 CariKodu,CariAdi FROM cari_tanim"; s.sql_orderby = " ORDER BY CariKodu"; s.tablename = "cari_tanim"; s.ShowDialog(); if (s.dr != null) { } }
private void button6_Click(object sender, System.EventArgs e) { Sec s=new Sec(); s.sql="select MarkaKodu,MarkaAdi from marka_tanim (nolock) "; s.sql_orderby=" ORDER BY MarkaAdi"; s.tablename="marka_tanim"; s.ShowDialog(); if(s.dr!=null) { textBoxMarka.Text=s.dr["MarkaKodu"].ToString(); textBoxMarkaAdi.Text = s.dr["MarkaAdi"].ToString(); } }
private void button7_Click(object sender, System.EventArgs e) { Sec s=new Sec(); s.sql = "SELECT TOP 150 StokKodu,StokAdi FROM stok_tanim_ust (NOLOCK)"; s.sql_orderby=" ORDER BY StokKodu"; s.tablename="StokTanimlari"; s.ShowDialog(); if(s.dr!=null) { textBoxStok.Text=s.dr["StokKodu"].ToString(); textBoxStokAdi.Text = s.dr["StokAdi"].ToString(); } }
private void button2_Click(object sender, System.EventArgs e) { Sec s=new Sec(); s.sql = "SELECT TOP 10 CariKodu,CariAdi FROM cari_tanim (NOLOCK)"; s.sql_orderby=" ORDER BY CariKodu"; s.tablename="cari_tanim"; s.ShowDialog(); if(s.dr!=null) { textBoxCari.Text=s.dr["CariKodu"].ToString(); textBoxCariAdi.Text = s.dr["CariAdi"].ToString(); } }
private void buttonStokKoduSec_Click(object sender, System.EventArgs e) { Sec s = new Sec(); s.sql = "SELECT TOP 20 StokKodu,StokAdi,StokAdi2,Diger1,Diger2 FROM stok_tanim_ust (nolock) "; s.tablename = "StokTanimlari"; s.sql_where = string.Format(" WHERE ( 1 = 1 ) "); if (s.ShowDialog() != DialogResult.OK) { return; } if (s.dr["StokKodu"] != DBNull.Value) { textBoxStokKodu.Text = s.dr["StokKodu"].ToString(); // if(s.dr["StokAdi"]!=DBNull.Value) // { // labelUrunAdi.Text=s.dr["StokAdi"].ToString(); // } } }