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; } }