public void DuLieu()
{
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
_index = GVGD.GetFocusedDataSourceRowIndex() - 10;
_Query = "";
if (chk1.Checked)
{
_Query += "WHERE " + DuLieuTaoSan.MocThoiGian()[_IDThoiGian].Substring(4);
}
else if (chk2.Checked)
{
if (bdtpTu.EditValue != null && bdtpDen.EditValue != null)
{
_Query = string.Format("WHERE (convert(date, NgayGD) BETWEEN '{0}' AND '{1}')", ((DateTime)bdtpTu.EditValue).ToString("yyyyMMdd"), ((DateTime)bdtpDen.EditValue).ToString("yyyyMMdd"));
}
}
else if (chk4.Checked && _SV_MC.Length > 0)
{
_Query += string.Format("WHERE REPLACE(COALESCE(Booking,''),' ','') in ('{0}')", String.Join("' ,'", _SV_MC));
}
if (_Query != "")
{
khachHangOBindingSource.DataSource = DaiLyD.All();
__ListKhachSanO = new D_KHACHSAN().DuLieu(_Query);
khachSanOBindingSource.DataSource = __ListKhachSanO;
}
Size textSize = TextRenderer.MeasureText(__ListKhachSanO.Count.ToString(), new Font("Tahoma", 9, FontStyle.Regular));
GVGD.IndicatorWidth = textSize.Width + 5;
GVGD.FocusedRowHandle = _index;
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
private void repositoryItemButtonEdit1_Click(object sender, EventArgs e)
{
O_BAOCAOCTNH c = (gridView2.GetRow(gridView2.GetSelectedRows()[0]) as O_BAOCAOCTNH);
switch (c.LoaiGiaoDich)
{
case 1:
case 2:
List <O_KHACHSAN> ks = new D_KHACHSAN().DuLieu_ID(c.IDGDLienKet);
new frmKhachSanThem(ks).ShowDialog(this);
break;
case 3:
case 0:
List <O_GIAODICH> gd = new D_GIAODICH().DuLieu_ID(c.IDGDLienKet);
new frmVeThem(gd).ShowDialog(this);
break;
}
}
