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