public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RpBaoGia rpt = new RpBaoGia();
rpt.Site = this.Site;
return(rpt);
}
private void HoaDon_Load(object sender, EventArgs e)
{
int id = IDHD;
DataTable dt = new DataTable();
RpBaoGia HD = new RpBaoGia();
dt = hd_BUS.Display("SELECT HOADON.SOHD,CTHD.MASP,KHACHHANG.HOTEN,NGSUA,BIENSO,SANPHAM.TENSP,SL,DONVI,LOAI,GIACTHD,TongGia,NHANVIEN.HOTEN,MANVTV,MANVKT " +
"FROM CTHD, SANPHAM, KHACHHANG, HANGXE, NHANVIEN, HOADON " +
" WHERE CTHD.SOHD = HOADON.SOHD AND KHACHHANG.MAKH = HOADON.MAKH AND NHANVIEN.MANV = HOADON.MANV " +
" AND HANGXE.MAHANGXE = KHACHHANG.MAHANGXE AND SANPHAM.MASP = CTHD.MASP AND HOADON.SOHD = " + id);
HD.SetDataSource(dt);
crystalReportViewer1.ReportSource = HD;
crystalReportViewer1.Refresh();
}