public void DuLieu()
{
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
_index = GVGD.GetFocusedDataSourceRowIndex() - 10;
_Query = "LoaiGiaoDich in (4,8,9,13,14) AND TinhCongNo = 1";
if (chk1.Checked)
{
_Query += DuLieuTaoSan.MocThoiGian()[_IDThoiGian];
}
else if (chk2.Checked)
{
if (bdtpTu.EditValue != null && bdtpDen.EditValue != null)
{
_Query += string.Format("AND (convert(date, NgayGD) BETWEEN '{0}' AND '{1}')", ((DateTime)bdtpTu.EditValue).ToString("yyyyMMdd"), ((DateTime)bdtpDen.EditValue).ToString("yyyyMMdd"));
}
}
else if (chk3.Checked && _SV_MC.Length > 0)
{
_Query += string.Format("AND REPLACE(COALESCE(SoVeVN,''),' ','') in ('{0}')", String.Join("' ,'", _SV_MC));
}
else if (chk4.Checked && _SV_MC.Length > 0)
{
_Query += string.Format("AND REPLACE(COALESCE(MaCho,''),' ','') in ('{0}')", String.Join("' ,'", _SV_MC));
}
if (_Query != "LoaiGiaoDich in (4,8,9,13,14) AND TinhCongNo = 1")
{
khachHangOBindingSource.DataSource = DaiLyD.All();
_ListGiaoDichO = new D_GIAODICH().DuLieu(_Query, DuLieuTaoSan.Q.VeAdmin);
giaoDichOBindingSource.DataSource = _ListGiaoDichO;
}
Size textSize = TextRenderer.MeasureText(_ListGiaoDichO.Count.ToString(), new Font("Tahoma", 9, FontStyle.Regular));
GVGD.IndicatorWidth = textSize.Width + 5;
GVGD.FocusedRowHandle = _index;
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
void ChinhSua()
{
if (GVGD.GetSelectedRows().Count() < 1)
{
return;
}
_GiaoDichO = GVGD.GetRow(GVGD.GetSelectedRows()[0]) as O_GIAODICH;
if (_GiaoDichO == null)
{
return;
}
_index = GVGD.GetFocusedDataSourceRowIndex();
List <O_GIAODICH> lst = _ListGiaoDichO.Where(w => w.MaCho.Equals(_GiaoDichO.MaCho) && w.LoaiGiaoDich.Equals(_GiaoDichO.LoaiGiaoDich) && w.IDKhachHang.Equals(_GiaoDichO.IDKhachHang) && w.NgayGD.ToString("ddMMyyy").Equals(_GiaoDichO.NgayGD.ToString("ddMMyyy")) && w.NhaCungCap.Equals(_GiaoDichO.NhaCungCap) && w.TuyenBayDi.Equals(_GiaoDichO.TuyenBayDi)).ToList();
if (lst.Count > 1)
{
DialogResult dc = XtraMessageBox.Show("Bạn muốn sửa tất cả giao dịch cùng Mã Chỗ ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
switch (dc)
{
case DialogResult.No:
lst = _ListGiaoDichO.Where(w => w.ID.Equals(_GiaoDichO.ID)).ToList();
break;
case DialogResult.Cancel:
return;
}
}
if (new List <int>()
{
4, 13, 14
}.Contains(_GiaoDichO.LoaiGiaoDich))
{
frmVeThem frm = new frmVeThem(lst);
frm.ShowDialog(ParentForm);
}
else
{
frmVeHoanThem frm2 = new frmVeHoanThem(lst);
frm2.ShowDialog(ParentForm);
}
}
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();
}
}
void ChinhSua()
{
_KhachSanO = GVGD.GetRow(GVGD.GetSelectedRows()[0]) as O_KHACHSAN;
_index = GVGD.GetFocusedDataSourceRowIndex();
List <O_KHACHSAN> lst = __ListKhachSanO.Where(w => w.MaCho.Equals(_KhachSanO.MaCho) && w.IDKhachHang.Equals(_KhachSanO.IDKhachHang) && w.NgayGD.ToString("ddMMyyy").Equals(_KhachSanO.NgayGD.ToString("ddMMyyy"))).ToList();
if (lst.Count > 1)
{
DialogResult dc = XtraMessageBox.Show("Bạn muốn sửa tất cả giao dịch cùng Mã Chỗ ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
switch (dc)
{
case DialogResult.No:
lst = __ListKhachSanO.Where(w => w.ID.Equals(_KhachSanO.ID)).ToList();
break;
case DialogResult.Cancel:
return;
}
}
new frmKhachSanThem(lst).ShowDialog(this);
}
