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 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 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 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();
// }
}
}
