public void getDefault()
{
this.Invoke((MethodInvoker) delegate
{
this.Cursor = Cursors.WaitCursor;
dataGridView1.DataSource = helper.getDataTable("SELECT " + COLS + " FROM CARI_KARTLAR_V2");
this.Cursor = Cursors.Default;
});
}
public void dataGridColWidth(DataGridView dtGrid, string TARGET_GRID)
{
DataTable dtCols = helper.getDataTable("SELECT*FROM SETTING_COL_WIDTH WHERE TARGET_GRID='" + TARGET_GRID + "'");
foreach (DataRow drCol in dtCols.Rows)
{
foreach (DataGridViewColumn col in dtGrid.Columns)
{
if (drCol["COL"].ToString() == col.Name)
{
col.Width = int.Parse(drCol["WIDTH"].ToString());
}
}
}
}
public void getDefault()
{
DateTime dtTime1 = Convert.ToDateTime(date1.Text);
DateTime dtTime2 = Convert.ToDateTime(date2.Text);
string dateFormat1 = dtTime1.Year + "-" + dtTime1.Month + "-" + dtTime1.Day;
string dateFormat2 = dtTime2.Year + "-" + dtTime2.Month + "-" + dtTime2.Day;
this.Invoke((MethodInvoker) delegate
{
this.Cursor = Cursors.WaitCursor;
dataGridView1.DataSource = helper.getDataTable("SELECT " + COLS + " FROM SERVIS_FISLERI INNER JOIN CARI_KARTLAR_V2 ON SERVIS_FISLERI.MUSTERI_ID=CARI_KARTLAR_V2.ID WHERE FIS_TARIHI BETWEEN CONVERT(datetime, '" + dateFormat1 + "') AND CONVERT(datetime, '" + dateFormat2 + "') ORDER BY SERVIS_ID DESC");
this.Cursor = Cursors.Default;
});
}
private void MUSTERI_DUZENLE_Load(object sender, EventArgs e)
{
DataTable dt = helper.getDataTable("SELECT*FROM CARI_KARTLAR_V2 WHERE ID=" + ITEM_ID + "");
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
txtAdres.Text = row["ADRES"].ToString();
txtCariKodu.Text = row["CARI_KODU"].ToString();
txtCariTuru.Text = row["CARI_TURU"].ToString();
txtCariUnvani.Text = row["UNVANI"].ToString();
txtCepTelefon.Text = row["CEP_TELEFON"].ToString();
txtGrupKodu.Text = row["GRUP_KODU"].ToString();
txtIl.Text = row["IL"].ToString();
txtIlce.Text = row["ILCE"].ToString();
txtTelefon.Text = row["TELEFON"].ToString();
txtVergiDairesi.Text = row["VERGI_DAIRESI"].ToString();
txtVergiNumarasi.Text = row["VERGI_NUMARASI"].ToString();
txtYetkiliKisi.Text = row["YETKILI_KISI"].ToString();
txtOzelKod1.Text = row["OZEL_KODLAR_1"].ToString();
txtOzelKod2.Text = row["OZEL_KODLAR_2"].ToString();
txtOzelKod3.Text = row["OZEL_KODLAR_3"].ToString();
txtOzelKod4.Text = row["OZEL_KODLAR_4"].ToString();
txtOzelKod5.Text = row["OZEL_KODLAR_5"].ToString();
txtFaturaAdresi.Text = row["FATURA_ADRESI"].ToString();
}
}
}
public void processCommand()
{
DateTime dtTime1 = Convert.ToDateTime(date1.Text);
DateTime dtTime2 = Convert.ToDateTime(date2.Text);
string dateFormat1 = dtTime1.Year + "-" + dtTime1.Month + "-" + dtTime1.Day;
string dateFormat2 = dtTime2.Year + "-" + dtTime2.Month + "-" + dtTime2.Day;
dataGridView1.DataSource = helper.getDataTable("SELECT " + COLS + " FROM SERVIS_FISLERI INNER JOIN CARI_KARTLAR_V2 ON SERVIS_FISLERI.MUSTERI_ID=CARI_KARTLAR_V2.ID WHERE FIS_TARIHI BETWEEN CONVERT(datetime, '" + dateFormat1 + "') AND CONVERT(datetime, '" + dateFormat2 + "') ORDER BY SERVIS_ID DESC");
}
private void txtCariID_TextChanged(object sender, EventArgs e)
{
DataTable dt = helper.getDataTable("SELECT TOP 1 * FROM CARI_KARTLAR_V2 WHERE ID=" + txtCariID.Text + "");
if (dt.Rows.Count == 1)
{
txtAdSoyad.Text = dt.Rows[0]["UNVANI"].ToString();
txtCepTelefon.Text = dt.Rows[0]["CEP_TELEFON"].ToString();
txtTelefon.Text = dt.Rows[0]["TELEFON"].ToString();
txtAdres.Text = dt.Rows[0]["ADRES"].ToString();
}
}
public void getDefault()
{
string COLS = "ID,AD,SOYAD,EPOSTA_ADRESI,AKTIF";
dataGridView1.DataSource = helper.getDataTable("SELECT " + COLS + " FROM KULLANICILAR");
}