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