void griddoldur()
{
tbl_Kiralar kira = new tbl_Kiralar();
DateTime time = DateTime.Now;
//string kiraDonemi = time.Year + "/" + time.Month;
string kiraDonemi = "";
DataSet ds = kira.spKiraSorgula(kiraDonemi, false, "", true, true, 0, "spKiraSorgula");
grSorgula.DataSource = ds.Tables["tbl_Kira"];
grSorgula.Refresh();
}
private void btnAra_Click(object sender, EventArgs e)
{
/*tbl_Binalar bina = new tbl_Binalar();
* DataSet dataSet = new DataSet() ;
* if (cmbDaireKapiNo.SelectedItem!=null)
* {
* int daireKapiNo = Convert.ToInt32(cmbDaireKapiNo.SelectedItem.ToString());
* dataSet = bina.spBinaSorgula(cmbBinaAdi.SelectedItem.ToString(), chkYetkili.Checked, daireKapiNo, "spBinaSorgula");
* }
* else
* dataSet = bina.spBinaSorgula(cmbBinaAdi.SelectedItem.ToString(), chkYetkili.Checked, 0, "spBinaSorgula");
* gridSorgulama.Columns.Clear();
* grSorgula.DataSource = dataSet.Tables["tbl_BinaMusteri"];
* grSorgula.Refresh();*/
tbl_Kiralar kira = new tbl_Kiralar();
bool kayitli = chkKayitli.Checked;
string kiraDonemi = "";
if (cmbKiraDonemi.SelectedItem != null)
{
kiraDonemi = cmbKiraDonemi.SelectedItem.ToString();
}
int daireKapiNo = 0;
if (cmbDaireKapiNo.SelectedItem != null)
{
daireKapiNo = Convert.ToInt32(cmbDaireKapiNo.SelectedItem.ToString());
}
string binaAdi = "";
if (cmbBinaAdi.SelectedItem != null)
{
binaAdi = cmbBinaAdi.SelectedItem.ToString();
}
DataSet ds = kira.spKiraSorgula(kiraDonemi, chkKiraDurumu.Checked, binaAdi, chkYetkili.Checked, kayitli, daireKapiNo, "spKiraSorgula");
grSorgula.DataSource = ds.Tables["tbl_Kira"];
grSorgula.Refresh();
}