public void kul_GuncVeriCek(int no, iTalk_TextBox_Small ad, iTalk_TextBox_Small sad, DateTimePicker dt
, iTalk_TextBox_Small tc, iTalk_ComboBox kan_g, iTalk_TextBox_Small tel, iTalk_TextBox_Small kul_ad,
iTalk_TextBox_Small kul_sifre, DataGridView dg, Ambiance_Button_1 btduzenle)
{
try
{
SqlConnection b = new SqlConnection();
b.ConnectionString = bag_cumlem;
b.Open();
string sql = "Select * from kullanicilar where kul_no='" + no + "'";
SqlCommand k = new SqlCommand(sql, b);
SqlDataReader dr = k.ExecuteReader();
while (dr.Read())
{
ad.Text = dr["adi"].ToString();
sad.Text = dr["soyadi"].ToString();
dt.Text = dr["dog_tar"].ToString();
tc.Text = dr["tc_no"].ToString();
kan_g.Text = dr["kan_grub"].ToString();
tel.Text = dr["tel_no"].ToString();
kul_ad.Text = dr["kul_adi"].ToString();
kul_sifre.Text = dr["kul_sifre"].ToString();
btduzenle.Visible = true;
}
}
catch
{
MessageBox.Show("Kullanıcı Getirilirken bir hata oluştu tekrar deneyiniz");
}
}
//FATURA İRSALİYE LİSTELEME
public void irsaliye_faturalistele(iTalk_ComboBox cb, DataGridView dg)
{
string sql;
if (cb.SelectedIndex == 1)
{
sql = "Select DISTINCT(fatura_no) fatura_no,isim_unvan,vergi_d,vergi_no,irsaliye_tarihi,kdv,genel_toplam from fatura ";
SqlConnection b = new SqlConnection();
b.ConnectionString = bag_cumlem;
b.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, b);
DataTable t = new DataTable();
da.Fill(t);
dg.DataSource = t;
dg.Columns[0].HeaderText = "FATURA NO";
dg.Columns[0].Width = 150;
dg.Columns[1].HeaderText = "MÜŞTERİ";
dg.Columns[1].Width = 150;
dg.Columns[2].HeaderText = "VERGİ DAİRESİ";
dg.Columns[2].Width = 150;
dg.Columns[3].HeaderText = "VERGİ NO";
dg.Columns[3].Width = 150;
dg.Columns[3].HeaderText = "İRSALİYE TARİHİ";
dg.Columns[3].Width = 150;
dg.Columns[3].HeaderText = "KDV";
dg.Columns[3].Width = 150;
dg.Columns[3].HeaderText = "GENEL TOPLAM";
dg.Columns[3].Width = 150;
}
else if (cb.SelectedIndex == 2)
{
sql = "Select DISTINCT(irsaliye_no) irsaliye_no,isim_unvan,vergi_d,vergi_no,duz_tar,kdv,genel_toplam from irsaliye";
SqlConnection b = new SqlConnection();
b.ConnectionString = bag_cumlem;
b.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, b);
DataTable t = new DataTable();
da.Fill(t);
dg.DataSource = t;
dg.Columns[0].HeaderText = "İRSALİYE NO";
dg.Columns[0].Width = 150;
dg.Columns[1].HeaderText = "MÜŞTERİ";
dg.Columns[1].Width = 150;
dg.Columns[2].HeaderText = "VERGİ DAİRESİ";
dg.Columns[2].Width = 150;
dg.Columns[3].HeaderText = "VERGİ NO";
dg.Columns[3].Width = 150;
dg.Columns[4].HeaderText = "TARİH";
dg.Columns[4].Width = 150;
dg.Columns[5].HeaderText = "KDV";
dg.Columns[5].Width = 150;
dg.Columns[6].HeaderText = "GENEL TOPLAM";
dg.Columns[6].Width = 150;
}
else if (cb.SelectedIndex == 0)
{
}
else
{
MessageBox.Show("Seçim Yapılmamış", "__--ERROR--__");
}
try
{
}
catch {
MessageBox.Show("BİR HATA OLUŞTU");
}
}
