private void GetFilter()
{
if (filter == null)
{
filter = new TimKiemChungTuFilterInfor();
}
filter.SoPhieu = txtSoGiaoDich.Text.Trim();
filter.LoaiDonHang = Common.IntValue(lueLoaiDH.EditValue);
//filter.GiaoNhan = cboGiaoNhan.SelectedIndex < 0 ? -1 : arLoaiDongHang[cboGiaoNhan.SelectedIndex];
//filter.TrangThai = Common.IntValue(lueTrangThaiDH.EditValue);
filter.IdTrungTam = CommonFuns.Instance.GetIdTrungTam(bteTrungTam, nguoiDung);
filter.LoaiMaHang = cboLoaiMaHang.SelectedIndex;
filter.MaHang = txtSanPham.Text.Trim();
filter.NhanVien = txtNhanVien.Text.Trim();
filter.TuNgay = Convert.ToDateTime(dteStart.EditValue);
filter.DenNgay = Convert.ToDateTime(dteEnd.EditValue);
filter.IdDoiTuong = bteKhachHang.Tag != null ? ((DMDoiTuongInfo)bteKhachHang.Tag).IdDoiTuong : -1;
filter.KhachHang = txtHoTenKhachHang.Text.Trim();
//filter.DiaChi = txtDiaChi.Text.Trim();
//filter.CMND = txtCMND.Text.Trim();
//filter.DienThoai = txtDienThoai.Text.Trim();
//filter.GhiChu = txtGhiChu.Text.Trim();
filter.UserName = CommonFuns.Instance.GetUserName();//"chkCuaToi.Checked ? nguoiDung.TenDangNhap : "";
//filter.Draft = Common.IntValue(lueDraft.EditValue);
filter.DoanhThuTu = Common.DoubleValue(txtDoanhThuTu.Text);
filter.DoanhThuDen = Common.DoubleValue(txtDoanhThuDen.Text);
filter.TinhTrangThanhToan = cboConNo.SelectedIndex;
filter.IdNhanVien = nguoiDung.IdNhanVien;
LoaiDuLieuDoiTru = chkLoaiTru.Checked;
}
private void GetFilter()
{
if (dteStart.EditValue == null)
{
dteStart.EditValue = CommonProvider.Instance.GetSysDate();
}
if (dteEnd.EditValue == null)
{
dteEnd.EditValue = dteStart.DateTime;
}
if (filter == null)
{
filter = new TimKiemChungTuFilterInfor();
}
filter.LoaiDonHang = Common.IntValue(lueLoaiDH.EditValue);
filter.IdTrungTam = CommonFuns.Instance.GetIdTrungTam(bteTrungTam, nguoiDung);
filter.MaHang = bteNganh.Text;
filter.TuNgay = Convert.ToDateTime(dteStart.EditValue);
filter.DenNgay = Convert.ToDateTime(dteEnd.EditValue);
filter.KhungGio = Common.IntValue(lueKhungGio.EditValue);
filter.Thu = Common.IntValue(lueThu.EditValue);
filter.UserName = CommonFuns.Instance.GetUserName();//"chkCuaToi.Checked ? nguoiDung.TenDangNhap : "";
filter.IdNhanVien = nguoiDung.IdNhanVien;
filter.IdNhomNguoiDung = nguoiDung.SupperUser == 1 ? -1 : nguoiDung.IdNhomNguoiDung;
}
public void TimKiemDoanhSoCTietPg(TimKiemChungTuFilterInfor filter, DataTable dataTable)
{
FillToDataTable(dataTable, Declare.StoreProcedureNamespace.spChungTuBanHangTKiemDoanhSoPg,
filter.SoPhieu, filter.LoaiDonHang, filter.TrangThai, filter.IdTrungTam,
filter.IdKho, filter.SanPham, filter.MaHang, filter.LoaiMaHang, filter.NhanVien,
filter.KhachHang, clsUtils.DateValue(filter.TuNgay), clsUtils.DateValue(filter.DenNgay),
filter.UserName, filter.IdNhanVien, filter.SoBatDau, filter.SoKetThuc, filter.IdNhomNguoiDung);
}
public frmBC_GiaoNhanChiTiet()
{
InitializeComponent();
Common.LoadStyle(this);
DataProvider = BaoCaoChiTietGiaoNhanDataProvider.Instance;
filter = new TimKiemChungTuFilterInfor();
gListChungTu.DataSource = DataSource;
}
public void TimKiemDoanhSoCTietPg(TimKiemChungTuFilterInfor filter, DataTable dataTable)
{
PhieuThuLenDoanhSoDao.Instance.TimKiemDoanhSoCTietPg(filter, dataTable);
if (dataTable.PrimaryKey.Length == 0)
{
dataTable.PrimaryKey = new[] { dataTable.Columns["idchitiet"] };
}
}
public frmBH_TimKhachMuaHang()
{
InitializeComponent();
Common.LoadStyle(this);
dteStart.DateTime = Declare.SYSDATE;
dteEnd.DateTime = Declare.SYSDATE;
DataProvider = TimKiemKhachMuaHangDataProvider.Instance;
filter = new TimKiemChungTuFilterInfor();
gListChungTu.DataSource = DataSource;
}
internal List<ChungTuBanHangGNhanCTietInfor> Search(TimKiemChungTuFilterInfor filter)
{
return
GetListCommand<ChungTuBanHangGNhanCTietInfor>(
Declare.StoreProcedureNamespace.spChungTuBanHangTimKiemCTGNCTiet,
filter.SoPhieu, filter.LoaiDonHang, filter.TrangThai, filter.IdTrungTam,
filter.IdKho, filter.SanPham, filter.MaHang, filter.LoaiMaHang, filter.NhanVien, filter.IdNhanVien,
clsUtils.DateValue(filter.TuNgay), clsUtils.DateValue(filter.DenNgay),
filter.KhachHang, filter.DiaChi, filter.CMND, filter.DienThoai, filter.GhiChu, filter.UserName);
}
public frmBH_TimKhachMuaHang(List <ChungTuBanHangInfor> liChungTuBanHang, string dienThoai, string cmnd, string maSoThue)
{
InitializeComponent();
Common.LoadStyle(this);
this.DataSource = liChungTuBanHang;
txtDienThoai.Text = dienThoai;
txtCMND.Text = cmnd;
txtMaSoThue.Text = maSoThue;
dteStart.DateTime = Declare.SYSDATE;
dteEnd.DateTime = Declare.SYSDATE;
DataProvider = TimKiemKhachMuaHangDataProvider.Instance;
filter = new TimKiemChungTuFilterInfor();
gListChungTu.DataSource = DataSource;
}
private void GetFilter()
{
if (filter == null)
{
filter = new TimKiemChungTuFilterInfor();
}
filter.TrangThai = Common.IntValue(lueTrangthai.EditValue);
filter.SoPhieu = txtSoGiaoDich.Text.Trim();
filter.IdTrungTam = txtTrungTam.Tag != null ? ((DMTrungTamInfor)txtTrungTam.Tag).IdTrungTam : -1;
filter.IdKho = txtKhoNhap.Tag != null ? ((DMKhoInfo)txtKhoNhap.Tag).IdKho : -1;
filter.TuNgay = Convert.ToDateTime(dteStart.EditValue);
filter.DenNgay = Convert.ToDateTime(dteEnd.EditValue);
filter.IdDoiTuong = txtKhachHang.Tag != null ? ((DMDoiTuongInfo)txtKhachHang.Tag).IdDoiTuong : -1;
filter.UserName = "";//"chkCuaToi.Checked ? nguoiDung.TenDangNhap : "";
}
private void GetFilter()
{
if (filter == null)
{
filter = new TimKiemChungTuFilterInfor();
}
filter.TrangThai = Common.IntValue(lueTrangthai.EditValue);
filter.SoPhieu = txtSoGiaoDich.Text.Trim();
filter.IdTrungTam = CommonFuns.Instance.GetIdTrungTam(txtTrungTam, nguoiDung);
filter.IdKho = txtKhoNhap.Tag != null ? ((DMKhoInfo)txtKhoNhap.Tag).IdKho : -1;
filter.TuNgay = Convert.ToDateTime(dteStart.EditValue);
filter.DenNgay = Convert.ToDateTime(dteEnd.EditValue);
filter.IdDoiTuong = txtKhachHang.Tag != null ? ((DMDoiTuongInfo)txtKhachHang.Tag).IdDoiTuong : -1;
filter.UserName = "";//"chkCuaToi.Checked ? nguoiDung.TenDangNhap : "";
filter.LoaiDonHang = NhapLaiKhac
? (int)TransactionType.DON_HANG_NHAP_LAI
: (int)TransactionType.NHAPTRAHANGMUA;
}
protected override IFilter GetFilter()
{
if (filter == null)
{
filter = new TimKiemChungTuFilterInfor();
}
filter.SoPhieu = txtSoGiaoDich.Text.Trim();
filter.IdTrungTam = CommonFuns.Instance.GetIdTrungTam(bteTrungTam, nguoiDung);
filter.IdKho = bteKhoXuat.Tag != null ? ((DMKhoInfo)bteKhoXuat.Tag).IdKho : -1;
filter.NhanVien = txtNhanVien.Text.Trim();
filter.TuNgay = Convert.ToDateTime(dteStart.EditValue);
filter.DenNgay = Convert.ToDateTime(dteEnd.EditValue);
filter.KhachHang = txtHoTenKhachHang.Text.Trim();
filter.CMND = txtCMND.Text.Trim();
filter.DienThoai = txtDienThoai.Text.Trim();
filter.MaSoThue = txtMaSoThue.Text.Trim();
return(filter);
}
protected override IFilter GetFilter()
{
if (filter == null)
{
filter = new TimKiemChungTuFilterInfor();
}
filter.SoPhieu = txtSoGiaoDich.Text.Trim();
filter.LoaiDonHang = Common.IntValue(lueLoaiDH.EditValue);
//filter.GiaoNhan = cboGiaoNhan.SelectedIndex < 0 ? -1 : arLoaiDongHang[cboGiaoNhan.SelectedIndex];
filter.TrangThai = Common.IntValue(lueTrangThaiDH.EditValue);
filter.IdTrungTam = CommonFuns.Instance.GetIdTrungTam(bteTrungTam, nguoiDung);
filter.IdKho = bteKhoXuat.Tag != null ? ((DMKhoInfo)bteKhoXuat.Tag).IdKho : -1;
filter.LoaiMaHang = cboLoaiMaHang.SelectedIndex;
filter.MaHang = bteNganh.Text;
filter.NhanVien = txtNhanVien.Text.Trim();
if (dteStart.EditValue == null)
{
dteStart.Focus();
throw new ManagedException("Bạn chưa chọn ngày bắt đầu", true);
}
filter.TuNgay = dteStart.DateTime;
if (dteEnd.EditValue == null)
{
dteEnd.Focus();
throw new ManagedException("Bạn chưa chọn ngày kết thúc", true);
}
filter.DenNgay = dteEnd.DateTime;
//filter.IdDoiTuong = bteKhachHang.Tag != null ? ((DMDoiTuongInfo)bteKhachHang.Tag).IdDoiTuong : -1;
filter.KhachHang = txtHoTenKhachHang.Text.Trim();
filter.DiaChi = txtDiaChi.Text.Trim();
filter.CMND = txtCMND.Text.Trim();
filter.DienThoai = txtDienThoai.Text.Trim();
filter.GhiChu = txtGhiChu.Text.Trim();
filter.UserName = CommonFuns.Instance.GetUserName();//"chkCuaToi.Checked ? nguoiDung.TenDangNhap : "";
filter.UserName = String.IsNullOrEmpty(filter.UserName) && filter.IdTrungTam > 0 &&
filter.IdTrungTam == nguoiDung.IdTrungTamHachToan
? nguoiDung.TenDangNhap
: String.Empty;
filter.IdNhanVien = nguoiDung.IdNhanVien;
//filter.Draft = Common.IntValue(lueDraft.EditValue);
return(filter);
}
private void GetFilter()
{
if (filter == null)
{
filter = new TimKiemChungTuFilterInfor();
}
filter.SoPhieu = txtSoGiaoDich.Text.Trim();
filter.IdTrungTam = CommonFuns.Instance.GetIdTrungTam(bteTrungTam, nguoiDung);
filter.IdKho = bteKhoXuat.Tag != null ? ((DMKhoInfo)bteKhoXuat.Tag).IdKho : -1;
filter.LoaiMaHang = cboLoaiMaHang.SelectedIndex;
filter.MaHang = bteNganh.Text;
filter.TuNgay = Convert.ToDateTime(dteStart.EditValue);
filter.DenNgay = Convert.ToDateTime(dteEnd.EditValue);
filter.IdDoiTuong = bteKhachHang.Tag != null ? ((DMDoiTuongInfo)bteKhachHang.Tag).IdDoiTuong : -1;
filter.KhachHang = txtHoTenKhachHang.Text.Trim();
filter.CMND = txtCMND.Text.Trim();
filter.DienThoai = txtDienThoai.Text.Trim();
filter.UserName = CommonFuns.Instance.GetUserName();//"chkCuaToi.Checked ? nguoiDung.TenDangNhap : "";
filter.Draft = Common.IntValue(lueDraft.EditValue);
filter.IdNhanVien = nguoiDung.IdNhanVien;
}
private void GetFilter()
{
if (filter == null)
{
filter = new TimKiemChungTuFilterInfor();
}
filter.SoPhieu = txtSoGiaoDich.Text.Trim();
filter.LoaiDonHang = Common.IntValue(lueLoaiDH.EditValue);
filter.TrangThai = Common.IntValue(lueTrangThaiDH.EditValue);
filter.IdTrungTam = CommonFuns.Instance.GetIdTrungTam(bteTrungTam, nguoiDung);
filter.IdKho = bteKhoXuat.Tag != null ? ((DMKhoInfo)bteKhoXuat.Tag).IdKho : -1;
filter.LoaiMaHang = cboLoaiMaHang.SelectedIndex;
filter.MaHang = bteNganh.Text;
filter.NhanVien = txtNhanVien.Text.Trim();
filter.TuNgay = Convert.ToDateTime(dteStart.EditValue);
filter.DenNgay = Convert.ToDateTime(dteEnd.EditValue);
filter.KhachHang = txtHoTenKhachHang.Text.Trim();
filter.UserName = CommonFuns.Instance.GetUserName();//"chkCuaToi.Checked ? nguoiDung.TenDangNhap : "";
filter.IdNhanVien = nguoiDung.IdNhanVien;
filter.IdNhomNguoiDung = nguoiDung.SupperUser == 1 ? -1 : nguoiDung.IdNhomNguoiDung;
}
private void GetFilter()
{
if (filter == null)
{
filter = new TimKiemChungTuFilterInfor();
}
filter.SoPhieu = txtSoGiaoDich.Text.Trim();
filter.LoaiDonHang = Common.IntValue(lueLoaiDH.EditValue);
filter.IdTrungTam = bteTrungTam.Tag != null ? ((DMTrungTamInfor)bteTrungTam.Tag).IdTrungTam : -1;
filter.IdKho = bteKhoXuat.Tag != null ? ((DMKhoInfo)bteKhoXuat.Tag).IdKho : -1;
filter.LoaiMaHang = cboLoaiMaHang.SelectedIndex;
filter.MaHang = txtSanPham.Text.Trim();
filter.NhanVien = txtNhanVien.Text.Trim();
filter.TuNgay = Convert.ToDateTime(dteStart.EditValue);
filter.DenNgay = Convert.ToDateTime(dteEnd.EditValue);
filter.IdDoiTuong = bteKhachHang.Tag != null ? ((DMDoiTuongInfo)bteKhachHang.Tag).IdDoiTuong : -1;
filter.KhachHang = txtHoTenKhachHang.Text.Trim();
filter.DiaChi = txtDiaChi.Text.Trim();
filter.CMND = txtCMND.Text.Trim();
filter.DienThoai = txtDienThoai.Text.Trim();
filter.GhiChu = txtGhiChu.Text.Trim();
filter.UserName = nguoiDung.TenDangNhap;
}
public List <NhapHangTraMuaInfor> GetListAllChungTuNhapTraKTPg(TimKiemChungTuFilterInfor filter)
{
return(NhapHangTraMuaDAO.Instance.GetListAllChungTuNhapTraKTPg(filter));
}
internal List <NhapHangTraMuaInfor> GetListAllChungTuNhapTraKTPg(TimKiemChungTuFilterInfor filter)
{
return
(GetListCommand <NhapHangTraMuaInfor>(Declare.StoreProcedureNamespace.spChungTuNhapTraHangMuaGetAllKTPg, filter.IdTrungTam, filter.IdKho, filter.IdDoiTuong,
clsUtils.DateValue(filter.TuNgay), clsUtils.DateValue(filter.DenNgay), filter.LoaiDonHang, filter.TrangThai, filter.SoPhieu, filter.UserName, filter.SoBatDau, filter.SoKetThuc));
}
