public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CRPhieumuon rpt = new CRPhieumuon();
rpt.Site = this.Site;
return(rpt);
}
public void Load_cr()
{
DataTable dt = new DataTable();
dt = conn.Table("SELECT phieumuon.madocgia, phieumuon.ngaymuon, phieumuon.masach, phieumuon.manhanvien, phieumuon.ngaytra, docgia.hoten, docgia.diachi, nhanvien.hoten AS Expr1, sach.nhande, sach.tacgia FROM phieumuon INNER JOIN docgia ON phieumuon.madocgia = docgia.madocgia INNER JOIN nhanvien ON phieumuon.manhanvien = nhanvien.manhanvien INNER JOIN sach ON phieumuon.masach = sach.masach WHERE phieumuon.madocgia = '" + madg + "' AND phieumuon.masach = '" + masach + "'");
CRPhieumuon cr = new CRPhieumuon();
cr.SetDataSource(dt);
crystalReportViewer1.ReportSource = cr;
}
