protected void cbpViewReport_Callback(object sender, CallbackEventArgsBase e)
{
hdfViewReport["View"] = 1;
if (ccbKhachHang.Value != null)
{
int IDKhachHang = Convert.ToInt32(ccbKhachHang.Value.ToString());
oInGiaoDich = new oReportGiaoDich();
oInGiaoDich.TieuDe = "CHI TIẾT PHÁT SINH";
var kh = DBDataProvider.DB.khKhachHangs.Where(x => x.IDKhachHang == IDKhachHang).FirstOrDefault();
oInGiaoDich.MaKhachHang = kh == null ? "" : kh.MaKhachHang;
oInGiaoDich.TenKhachHang = kh == null ? "" : kh.HoTen;
oInGiaoDich.DienThoai = kh == null ? "" : kh.DienThoai;
oInGiaoDich.DiaChi = kh == null ? "" : kh.DiaChi;
oInGiaoDich.listProduct = new List <oChiTietGiaoDich>();
oInGiaoDich.NgayThangNam = DBDataProvider.TinhThanhCty() + ", " + Formats.ConvertToFullStringDate(DateTime.Now);
string NgayBD = fromDay.Date.ToString("yyyy-MM-dd");
string NgayKT = toDay.Date.AddDays(1).ToString("yyyy-MM-dd");
List <khNhatKyCongNo> nhatky = DBDataProvider.DB.khNhatKyCongNos.Where(x => x.NgayNhap <= DateTime.Parse(NgayKT) && x.NgayNhap >= DateTime.Parse(NgayBD) && x.IDKhachHang == IDKhachHang).ToList();
int stt = 1;
double TongHangTra = 0, TongPhatSinh = 0, TongThanhToan = 0, TongGiamGia = 0;
foreach (var a in nhatky)
{
TongHangTra += Convert.ToDouble(a.TraHang);
TongPhatSinh += Convert.ToDouble(a.NhapHang);
TongThanhToan += Convert.ToDouble(a.ThanhToan);
TongGiamGia += Convert.ToDouble(a.GiamGia);
oChiTietGiaoDich chitiet = new oChiTietGiaoDich();
chitiet.STT = stt++;
chitiet.Ngay = Formats.ConvertToVNDateString(a.NgayNhap.ToString());
chitiet.NoiDung = a.DienGiai;
chitiet.SoPhieu = a.MaPhieu.ToString();
chitiet.NoDau = Convert.ToDouble(a.NoDau);
chitiet.NhapHang = Convert.ToDouble(a.NhapHang);
chitiet.HangTra = Convert.ToDouble(a.TraHang);
chitiet.ThanhToan = Convert.ToDouble(a.ThanhToan);
chitiet.NoCuoi = Convert.ToDouble(a.NoCuoi);
chitiet.GiamGia = Convert.ToDouble(a.GiamGia);
oInGiaoDich.listProduct.Add(chitiet);
}
oInGiaoDich.TongHangTra = TongHangTra;
oInGiaoDich.TongPhatSinh = TongPhatSinh;
oInGiaoDich.TongThanhToan = TongThanhToan;
oInGiaoDich.TongGiamGia = TongGiamGia;
}
}
private void CreateReportReview()
{
hdfViewReport["view"] = 1;
oPhieuTTExport = new oThanhToan();
oPhieuTTExport.NgayThu = DBDataProvider.TinhThanhCty() + ", " + Formats.ConvertToFullStringDate(DateTime.Parse(dateNgayTT.Text.ToString()));
var KH = DBDataProvider.DB.khKhachHangs.Where(x => x.IDKhachHang == Convert.ToInt32(ccbKhachHang.Value.ToString())).FirstOrDefault();
oPhieuTTExport.STTPhieuThu = 0000;
oPhieuTTExport.TieuDe = "PHIẾU THANH TOÁN ";
oPhieuTTExport.XemTruoc = "(Xem trước)";
oPhieuTTExport.SoHoaDon = txtHoaDon.Text;
oPhieuTTExport.TenKhachHang = KH.HoTen;
oPhieuTTExport.MaKhachHang = KH.MaKhachHang;
oPhieuTTExport.DienThoai = KH.DienThoai;
oPhieuTTExport.NoiDung = memoNoiDungTT.Text;
oPhieuTTExport.SoTienThu = Convert.ToDouble(speSoTienTT.Number);
oPhieuTTExport.CongNoTruocThanhToan = Convert.ToDouble(KH.CongNo);
oPhieuTTExport.CongNoSauThanhToan = Convert.ToDouble(KH.CongNo) - Convert.ToDouble(speSoTienTT.Number);
cbpThanhToan.JSProperties["cp_rpView"] = true;
}
protected void cbpViewReport_Callback(object sender, CallbackEventArgsBase e)
{
int IDPhieuThu = int.Parse(e.Parameter);
var PhieuTT = DBDataProvider.DB.kPhieuThanhToanNCCs.Where(x => x.IDPhieuThu == IDPhieuThu).SingleOrDefault();
hdfViewReport["view"] = 1;
oPhieuTTExport = new oThanhToan();
oPhieuTTExport.NgayThu = DBDataProvider.TinhThanhCty() + ", " + Formats.ConvertToFullStringDate(DateTime.Parse(PhieuTT.NgayThu.ToString()));
oPhieuTTExport.IDKhachHang = Convert.ToInt32(PhieuTT.KhachHangID);
oPhieuTTExport.STTPhieuThu = Convert.ToInt32(PhieuTT.STTPhieuThu);
oPhieuTTExport.TieuDe = "PHIẾU THANH TOÁN " + PhieuTT.STTPhieuThu;
oPhieuTTExport.SoHoaDon = PhieuTT.SoHoaDon;
oPhieuTTExport.TenKhachHang = PhieuTT.khKhachHang.HoTen;
oPhieuTTExport.MaKhachHang = PhieuTT.khKhachHang.MaKhachHang;
oPhieuTTExport.DienThoai = PhieuTT.khKhachHang.DienThoai;
oPhieuTTExport.NoiDung = PhieuTT.NoiDung;
oPhieuTTExport.SoTienThu = Convert.ToDouble(PhieuTT.SoTienThu);
oPhieuTTExport.CongNoTruocThanhToan = Convert.ToDouble(PhieuTT.CongNoCu);
oPhieuTTExport.CongNoSauThanhToan = Convert.ToDouble(PhieuTT.CongNoCu - PhieuTT.SoTienThu);
}
