private void frmChinhSachThem_Load(object sender, EventArgs e)
{
intStringBindingSource.DataSource = DuLieuTaoSan.LoaiKhachHang_Ve();
XuLyDuLieu.ConvertClassToTable(this, _ChinhSachO);
XuLyGiaoDien.OpenForm(this);
btnLuu.Visible = DuLieuTaoSan.Q.ChinhSachThemSua;
}
private void frmVeThem_Load(object sender, EventArgs e)
{
chkDen.Checked = _GiaoDichO.SoLuongVe == 2;
_ListDaiLyO = new D_DAILY().All();
_ListHangBayO = new D_HANGBAY().DuLieu();
_ListTuyenBayO = new D_TUYENBAY().DuLieu();
NhanVienDB.DataSource = new D_DAILY().NhanVien();
LoaiKhachDB.DataSource = DuLieuTaoSan.LoaiKhachHang_Ve();
LoaiVeDB.DataSource = DuLieuTaoSan.LoaiGiaoDich_Ve(true).Where(w => !w.ID.Equals(8) && !w.ID.Equals(9));
DaiLyDB.DataSource = _ListDaiLyO.Where(w => w.LoaiKhachHang.Equals(LoaiKhachHang));
_ListNCC = new D_NHACUNGCAP().DuLieu();
NCCDB.DataSource = _ListNCC;
tuyenBayOBindingSource.DataSource = _ListTuyenBayO;
rHD.DataSource = DuLieuTaoSan.HinhThucHoaDon();
iAn.Visible = DuLieuTaoSan.Q.VeAdmin;
#region NVGiaoDich
iNVGiaoDich.Properties.ReadOnly = _GiaoDichO.NVGiaoDich != DuLieuTaoSan.NV.ID;
if (_GiaoDichO.NVGiaoDich == DuLieuTaoSan.NV.ID || _GiaoDichO.NVGiaoDich < 1 || DuLieuTaoSan.NV.MienPhat)
{
_GiaoDichO.NVGiaoDich = DuLieuTaoSan.NV.ID;
}
else if (_GiaoDichO.NVHoTro < 1 || DuLieuTaoSan.NV.MienPhat)
{
_GiaoDichO.NVHoTro = DuLieuTaoSan.NV.ID;
}
#endregion
iGhiChu.Text = _GiaoDichO.GhiChu;
DuLieuTaoSan.Adic = XuLyDuLieu.ConvertClassToTable(this, _GiaoDichO);
_LSTDIC = XuLyDuLieu.BanTamGrid(GVGD);
XuLyGiaoDien.OpenForm(this);
btnLuu.Visible = DuLieuTaoSan.Q.VeThemSua;
}
public void TaiLaiDuLieu()
{
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
if (chk2.Checked)
{
if (bdtpTu.EditValue != null && bdtpDen.EditValue != null)
{
CTV = string.Format("AND (convert(date, NgayGD) BETWEEN '{0}' AND '{1}')", ((DateTime)bdtpTu.EditValue).ToString("yyyyMMdd"), ((DateTime)bdtpDen.EditValue).ToString("yyyyMMdd"));
}
}
else if (chk1.Checked)
{
CTV = DuLieuTaoSan.MocThoiGian("NgayGD")[idThoiGian];
}
nhD.ChayLaiSD();
cTNganHangOBindingSource.DataSource = new D_CTNGANHANG().DuLieu(CTV, true);
btnM.Caption = "Số dư: " + nhD.DuLieu(true)[0].SoDuCuoi.ToString("#,### VNĐ");
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
public void NapDatCho()
{
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
string query = "LoaiGiaoDich in (0,1,5,6,7,10,11,12)";
if (query.Length > 0)
{
if (chk2.Checked)
{
if (bdtpTu.EditValue != null && bdtpDen.EditValue != null)
{
query = string.Format("({2}) AND (convert(date, NgayGD) BETWEEN '{0}' AND '{1}')", ((DateTime)bdtpTu.EditValue).ToString("yyyyMMdd"), ((DateTime)bdtpDen.EditValue).ToString("yyyyMMdd"), query);
lstGDDC = new D_GIAODICH().DuLieu(query, DuLieuTaoSan.Q.VeAdmin);
}
}
else if (chk1.Checked)
{
query = string.Format("({0}) {1}", query, DuLieuTaoSan.ThoiGianRutGon("NgayGD")[idThoiGian]);
lstGDDC = new D_GIAODICH().DuLieu(query, DuLieuTaoSan.Q.VeAdmin);
}
giaoDichOBindingSource.DataSource = lstGDDC;
}
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
private void frmNCCGD_Load(object sender, EventArgs e)
{
nCCOBindingSource.DataSource = new D_NHACUNGCAP().DuLieu();
intStringBindingSource.DataSource = DuLieuTaoSan.LoaiPhi(false);
XuLyGiaoDien.OpenForm(this);
XuLyDuLieu.ConvertClassToTable(this, _nCCGDO);
}
private void frmHoaDon_Load(object sender, EventArgs e)
{
tuyenBayOBindingSource.DataSource = new D_TUYENBAY().DuLieu();
DSLoaiKhach.DataSource = DuLieuTaoSan.LoaiKhachHang_GiaoDich();
khachHangOBindingSource.DataSource = new D_DAILY().All();
nCCOBindingSource.DataSource = new D_NHACUNGCAP().DuLieu();
DuLieu();
}
private void frmTheoDoiHoan_Load(object sender, EventArgs e)
{
_GiaoDichO.TheoDoi = true;
btnAdd.Visibility = DuLieuTaoSan.Q.TheoDoiHoanThemSua ? DevExpress.XtraBars.BarItemVisibility.Always : DevExpress.XtraBars.BarItemVisibility.Never;
btnDel.Visibility = DuLieuTaoSan.Q.TheoDoiHoanXoa ? DevExpress.XtraBars.BarItemVisibility.Always : DevExpress.XtraBars.BarItemVisibility.Never;
loaiKhachOBindingSource.DataSource = DuLieuTaoSan.LoaiKhachHang_Ve();
daiLyOBindingSource.DataSource = new D_DAILY().All();
DuLieu();
}
private void iLoaiKhachHang_EditValueChanged(object sender, EventArgs e)
{
LoaiKhachHang = (int)iLoaiKhachHang.EditValue;
DaiLyDB.DataSource = _ListDaiLyO.Where(w => w.LoaiKhachHang.Equals(LoaiKhachHang));
HinhThucDB.DataSource = DuLieuTaoSan.HinhThuc_Ve(LoaiKhachHang);
if (LoaiKhachHang != _GiaoDichO.LoaiKhachHang || iNganHang.EditValue == null)
{
iHTTT.EditValue = LoaiKhachHang == 3 ? 4 : 1;
}
}
private void frmTongHop_Load(object sender, EventArgs e)
{
loaiGiaoDichOBindingSource.DataSource = new D_LOAIGIAODICH().DuLieu_CongNo_TheoLoai(0);
DSLoaiKhach.DataSource = DuLieuTaoSan.LoaiKhachHang_GiaoDich();
lstDaiLy = new D_DAILY().All();
daiLyOBindingSource.DataSource = lstDaiLy;
btn2.Visibility = DuLieuTaoSan.Q.Lv2KhacAdmin ? BarItemVisibility.Always : BarItemVisibility.Never;
btn4.Visibility = DuLieuTaoSan.Q.KhacThemSua ? BarItemVisibility.Always : BarItemVisibility.Never;
NapDatCho();
}
private void frmChinhSach_Load(object sender, EventArgs e)
{
nCCOBindingSource.DataSource = new D_NHACUNGCAP().DuLieu();
loaiPhiBindingSource.DataSource = DuLieuTaoSan.LoaiPhi();
TuyenBayOs = new D_TUYENBAY().DuLieu();
tuyenBayOBindingSource.DataSource = TuyenBayOs;
_ListHangBayO = new D_HANGBAY().DuLieu();
DuLieu();
XuLyGiaoDien.OpenForm(this);
btnLuu.Enabled = DuLieuTaoSan.Q.ChinhSachThemSua;
}
private void frmNhanVienThem_Load(object sender, EventArgs e)
{
dt.Columns.Add("col1");
dt.Columns.Add("col2");
dt.Columns.Add("col3");
XuLyGiaoDien.OpenForm(this);
_HoHang = _KhachHangO.ThongTinLienLac;
DuLieuTaoSan.Adic = XuLyDuLieu.ConvertClassToTable(this, _KhachHangO);
quyenOBindingSource.DataSource = new D_NHOMQUYEN().DuLieu();
gioiTinhBindingSource.DataSource = DuLieuTaoSan.GioiTinh();
e2.EditValue = DateTime.Now;
NguoiThanKhach();
}
private void frmTienMat_Load(object sender, EventArgs e)
{
bdtpDen1.MinValue = DateTime.Now.AddDays(-30);
bdtpDen1.MaxValue = DateTime.Now.AddDays(-1);
bdtpDen12.EditValue = DateTime.Now.AddDays(-1);
ibtnThemMoi.Visibility = DuLieuTaoSan.Q.TienMatThemSua ? BarItemVisibility.Always : BarItemVisibility.Never;
btnDel.Visibility = DuLieuTaoSan.Q.TienMatXoa ? BarItemVisibility.Always : BarItemVisibility.Never;
LayDLNganHang();
TaiLaiDuLieu();
LayDLKhac();
intStringBindingSource2.DataSource = DuLieuTaoSan.LoaiKhachHang_NganHang();
DSNhanVien.DataSource = new D_DAILY().NhanVien();
}
public void DuLieu()
{
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
khachHangOBindingSource.DataSource = new D_DAILY().NhanVien(DuLieuTaoSan.NV.TenDangNhapCty.ToLower());
quyenNhanVienOBindingSource.DataSource = new D_NHOMQUYEN().DuLieu();
gioiTinhBindingSource.DataSource = DuLieuTaoSan.GioiTinh();
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
public void TaiLaiDuLieu()
{
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
if (chk2.Checked)
{
if (bdtpTu.EditValue != null && bdtpDen.EditValue != null)
{
CTV = string.Format("AND (convert(date, NgayGD) BETWEEN '{0}' AND '{1}')", ((DateTime)bdtpTu.EditValue).ToString("yyyyMMdd"), ((DateTime)bdtpDen.EditValue).ToString("yyyyMMdd"));
}
}
else if (chk1.Checked)
{
CTV = DuLieuTaoSan.MocThoiGian("NgayGD")[idThoiGian];
}
else if (chk3.Checked && B != string.Empty)
{
CTV = string.Format("AND MaCode like '%{0}%'", B);
}
if (!chk3.Checked)
{
if (!chkKLT.Checked)
{
CTV += string.Format(" OR LoaiGiaoDich = 8");
}
if (chkNganHang.Checked)
{
CTV += " AND NganHangID = " + kh.ID;
}
}
if (iCTKN.Checked)
{
_listCTNganHangO = new D_CTNGANHANG().DuLieu(CTV);
}
else
{
_listCTNganHangO = new D_CTNGANHANG().DuLieu(CTV, false);
}
cTNganHangOBindingSource.DataSource = _listCTNganHangO;
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
private void frmHoaDonThem_Load(object sender, EventArgs e)
{
daiLyDs = new D_DAILY().All();
daiLyOBindingSource1.DataSource = daiLyDs;
nCCOBindingSource.DataSource = new D_NHACUNGCAP().DuLieu();
tuyenBayOBindingSource.DataSource = new D_TUYENBAY().DuLieu();
bindingSource1.DataSource = daiLyD.NhanVien();
IntStringBindingSource.DataSource = DuLieuTaoSan.LoaiKhachHang_GiaoDich(false);
hoaDonOBindingSource1.DataSource = _HoaDonD.LayThongTinMST();
hangBayOBindingSource.DataSource = new D_HANGBAY().DuLieu();
XuLyGiaoDien.OpenForm(this);
DuLieuTaoSan.Adic = XuLyDuLieu.ConvertClassToTable(this, _HoaDonO);
daiLyOBindingSource.DataSource = daiLyDs.Where(w => w.LoaiKhachHang.Equals((int)iLoaiKhachHang.EditValue));
bandedGridView1.BestFitColumns();
}
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 DuLieu()
{
string _Query = string.Empty;
if (chk1.Checked)
{
_Query += DuLieuTaoSan.ThoiGianRutGon("TuNgay")[_IDThoiGian];
}
else if (chk2.Checked)
{
if (bdtpTu.EditValue != null && bdtpDen.EditValue != null)
{
_Query += string.Format("AND (convert(date, TuNgay) BETWEEN '{0}' AND '{1}')", ((DateTime)bdtpTu.EditValue).ToString("yyyyMMdd"), ((DateTime)bdtpDen.EditValue).ToString("yyyyMMdd"));
}
}
khoaNgayOBindingSource.DataSource = new D_KHOANGAY().DuLieu(_Query);
}
private void frmTongHopThem_Load(object sender, EventArgs e)
{
daiLyOs = new D_DAILY().All();
DuLieuTaoSan.Adic = XuLyDuLieu.ConvertClassToTable(this, Gd);
loaiKhachOBindingSource.DataSource = DuLieuTaoSan.LoaiKhachHang_GiaoDich().Where(w => w.ID.Equals(1) || w.ID.Equals(2));
loaiGiaoDichOBindingSource1.DataSource = DuLieuTaoSan.LoaiGiaoDich_Ve(false);
XuLyGiaoDien.OpenForm(this);
iTenKhach.Text = "Thời gian: " + DateTime.Now.ToString("HH:mm");
if ((new List <int>()
{
7, 11, 12
}).Contains(Gd.LoaiGiaoDich))
{
iGiaThu.Value = Gd.GiaHoan;
iTenKhach.Text = Gd.TenKhach;
}
}
public void DuLieu()
{
string _Query = string.Empty;
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
if (chk1.Checked)
{
_Query = DuLieuTaoSan.ThoiGianRutGon("NgayThucHien")[idThoiGian].Substring(3);
}
else if (chk2.Checked)
{
if (bdtpTu.EditValue != null && bdtpDen.EditValue != null)
{
_Query = string.Format("(convert(date, NgayThucHien) 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("REPLACE(COALESCE(SoVe,''),' ','') in ('{0}')", String.Join("' ,'", _SV_MC));
}
else if (chk4.Checked && _SV_MC.Length > 0)
{
_Query += string.Format("REPLACE(COALESCE(MaCho,''),' ','') in ('{0}')", String.Join("' ,'", _SV_MC));
}
else if (chk5.Checked && _SV_MC.Length > 0)
{
_Query += string.Format("REPLACE(COALESCE(MaHD,''),' ','') in ('{0}')", String.Join("' ,'", _SV_MC));
}
if (_Query.Length > 0)
{
hoaDonOs = hoaDonD.DuLieu(_Query);
hoaDonOBindingSource.DataSource = hoaDonOs;
GVHD.BestFitColumns();
}
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
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();
}
}
public void LayDLCTNganHang()
{
string CTV = "SMS = 1 ";
if (chk1.Checked)
{
CTV += DuLieuTaoSan.ThoiGianRutGon("NgayCuonChieu")[idThoiGian];
}
else if (bdtpTu.EditValue != null && bdtpDen.EditValue != null)
{
CTV += string.Format("AND (convert(date, NgayCuonChieu) BETWEEN '{0}' AND '{1}')", ((DateTime)bdtpTu.EditValue).ToString("yyyyMMdd"), ((DateTime)bdtpDen.EditValue).ToString("yyyyMMdd"));
}
if (chkDD.Checked)
{
CTV += "OR (SMS = 1 and Khoa = 0)";
}
lstGD = new D_GIAODICH().DuLieu(CTV, DuLieuTaoSan.Q.VeAdmin);
giaoDichOBindingSource.DataSource = lstGD;
GVKLN.BestFitColumns();
}
private void frmKhachSanThem_Load(object sender, EventArgs e)
{
#region NVGiaoDich
iNVGiaoDich.Properties.ReadOnly = iNVHoTro.Properties.ReadOnly = _ks.NVGiaoDich != DuLieuTaoSan.NV.ID;
LoaiKhachDB.DataSource = DuLieuTaoSan.LoaiKhachHang_Ve();
if (_ks.NVGiaoDich == DuLieuTaoSan.NV.ID || _ks.NVGiaoDich < 1 || DuLieuTaoSan.NV.MienPhat)
{
_ks.NVGiaoDich = DuLieuTaoSan.NV.ID;
}
else if (_ks.NVHoTro < 1 || DuLieuTaoSan.NV.MienPhat)
{
_ks.NVHoTro = DuLieuTaoSan.NV.ID;
}
#endregion
DuLieuTaoSan.Adic = XuLyDuLieu.ConvertClassToTable(this, _ks);
XuLyGiaoDien.OpenForm(this);
DuLieu();
}
private void frmThemGiaoDichTK_Load(object sender, EventArgs e)
{
loaiGiaoDichOBindingSource.DataSource = new D_LOAIGIAODICH().DuLieu_NganHang_TheoLoai(0, true);
DataLoaiKhach.DataSource = DuLieuTaoSan.LoaiKhachHang_NganHang();
_NganHang = new D_NGANHANG().All();
nganHangNguonBindingSource.DataSource = _NganHang;
nhanVienOBindingSource.DataSource = new D_DAILY().NhanVien();
IntStringBindingSource.DataSource = DuLieuTaoSan.TrangThai_NganHang();
if (CTM.NVGiaoDich < 1)
{
CTM.NVGiaoDich = DuLieuTaoSan.NV.ID;
}
DuLieuTaoSan.Adic = XuLyDuLieu.ConvertClassToTable(this, CTM);
XuLyGiaoDien.OpenForm(this);
if (!CTM.TrangThaiID)
{
iTrangThaiID.EditValue = true;
}
}
private void frmVeHoanThem_Load(object sender, EventArgs e)
{
chkDen.Checked = _GiaoDichO.SoLuongVe == 2;
DuLieuKhachLe();
_ListHangBayO = new D_HANGBAY().DuLieu();
_ListTuyenBayO = new D_TUYENBAY().DuLieu();
LoaiKhachDB.DataSource = DuLieuTaoSan.LoaiKhachHang_Ve();
NCCDB.DataSource = new D_NHACUNGCAP().DuLieu();
NhanVienDB.DataSource = new D_DAILY().NhanVien();
tuyenBayOBindingSource.DataSource = _ListTuyenBayO;
iTinhCongNo.Visible = DuLieuTaoSan.Q.TheoDoiHoanAdmin;
if (Owner.ActiveMdiChild is frmVe)
{
iTinhCongNo.Visible = true;
iTinhCongNo.Checked = true;
}
iAn.Visible = DuLieuTaoSan.Q.VeAdmin;
#region NVGiaoDich
iNVGiaoDich.Properties.ReadOnly = _GiaoDichO.NVGiaoDich != DuLieuTaoSan.NV.ID;
if (_GiaoDichO.NVGiaoDich < 1)
{
_GiaoDichO.NVGiaoDich = DuLieuTaoSan.NV.ID;
}
else if (DuLieuTaoSan.NV.MienPhat)
{
_GiaoDichO.NVGiaoDich = DuLieuTaoSan.NV.ID;
}
#endregion
iGhiChu.Text = _GiaoDichO.GhiChu;
_LSTDIC = XuLyDuLieu.BanTamGrid(GVH);
XuLyDuLieu.ConvertClassToTable(this, _GiaoDichO);
XuLyGiaoDien.OpenForm(this);
if (!_GiaoDichO.TinhCongNo)
{
iNgayGD.DateTime = DateTime.Now;
}
btnLuu.Visible = DuLieuTaoSan.Q.TheoDoiHoanThemSua;
}
private void iLoaiKhachHang_EditValueChanged(object sender, EventArgs e)
{
int LoaiKhachHang = (int)iLoaiKhachHang.EditValue;
loaiGiaoDichOBindingSource.DataSource = new D_LOAIGIAODICH().DuLieu_NganHang_TheoLoai(LoaiKhachHang, false);
DataTen.DataSource = DuLieuTaoSan.NganHangLoaiKhachHang(LoaiKhachHang, (int)(iNganHangID.EditValue ?? 0));
colName2.Visible = LoaiKhachHang == 1;
if (!CTM.TrangThaiID)
{
if ((int)iLoaiKhachHang.EditValue != 6)
{
iTrangThaiID.EditValue = true;
iTrangThaiID.Enabled = false;
}
else
{
iTrangThaiID.EditValue = false;
iTrangThaiID.Enabled = true;
}
}
}
public void DuLieu()
{
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
string _Query = string.Empty;
if (chk1.Checked)
{
_Query = DuLieuTaoSan.ThoiGianRutGon("NgayGD")[_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 != string.Empty)
{
_ListGiaoDichO = new D_GIAODICH().DuLieu(string.Format("TheoDoi = 1 AND ({0}{1})", _Query.Substring(3), chkAll.Checked ? " or TinhCongNo = 0" : string.Empty), DuLieuTaoSan.Q.VeAdmin);
giaoDichOBindingSource.DataSource = _ListGiaoDichO;
}
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
private void frmVe_Load(object sender, EventArgs e)
{
if (!DuLieuTaoSan.Q.VeAdmin)
{
GVGD.Columns.Remove(colEmail);
GVGD.Columns.Remove(colDienThoaiKhachHang);
}
rLoaiKhach.DataSource = DuLieuTaoSan.LoaiKhachHang_Ve();
rTrangThai.DataSource = DuLieuTaoSan.LoaiGiaoDich_Ve(true);
rHinHThuc.DataSource = DuLieuTaoSan.HinhThuc_Ve_TatCa();
rHoaDon.DataSource = DuLieuTaoSan.HinhThucHoaDon();
btnExportExcel.Visibility = DuLieuTaoSan.Q.VeExcel ? BarItemVisibility.Always : BarItemVisibility.Never;
btnThem.Visibility = DuLieuTaoSan.Q.VeThemSua ? BarItemVisibility.Always : BarItemVisibility.Never;
btnXoa.Visibility = DuLieuTaoSan.Q.VeXoa ? BarItemVisibility.Always : BarItemVisibility.Never;
btnHoan.Visibility = DuLieuTaoSan.Q.TheoDoiHoanAdmin ? BarItemVisibility.Always : BarItemVisibility.Never;
tuyenBayOBindingSource.DataSource = new D_TUYENBAY().DuLieu();
nganHangOBindingSource.DataSource = new D_NGANHANG().All();
hangBayOBindingSource.DataSource = new D_HANGBAY().DuLieu();
nCCOBindingSource.DataSource = new D_NHACUNGCAP().DuLieu_GiaoDich();
_ListKhoaNgayO = new D_KHOANGAY().DuLieu();
DuLieu();
}
public void LayDLKhac()
{
IntStringBindingSource.DataSource = DuLieuTaoSan.TrangThai_NganHang();
loaiGiaoDichOBindingSource.DataSource = new D_LOAIGIAODICH().DuLieu();
intStringBindingSource2.DataSource = DuLieuTaoSan.LoaiKhachHang_NganHang();
}
public frmLichSu()
{
InitializeComponent();
ChonThoiGian = DuLieuTaoSan.MocThoiGian("NgayThucHien");
DuLieu();
}
private void frmHangBay_Load(object sender, EventArgs e)
{
DuLieu();
XuLyGiaoDien.OpenForm(this);
intStringBindingSource.DataSource = DuLieuTaoSan.LoaiPhi(false);
}
