public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crtPhieuNhap rpt = new crtPhieuNhap();
rpt.Site = this.Site;
return(rpt);
}
private void LoadReportSource(string _MaKho)
{
//crtPhieuNhap cry = new crtPhieuNhap();
var model = from m in db.ChiTietPhieuNhaps.AsEnumerable()
join vt in db.VatTus.AsEnumerable() on m.MaVT equals vt.MaVT
join pn in db.PhieuNhaps.AsEnumerable() on m.MaPhieuNhap equals pn.MaPhieuNhap
join ncc in db.NhaCungCaps.AsEnumerable() on vt.MaNCC equals ncc.MaNCC
join kho in db.KhoVatTus.AsEnumerable() on pn.MaKhoVT equals kho.MaKhoVT
where m.MaPhieuNhap.Equals(_MaKho)
select new
{
NgayDuyet = pn.NgayDuyet != null?pn.NgayDuyet.Value.ToString("dd/MM/yyyy") : DateTime.Now.ToString("dd/MM/yyyy"),
TenKhoVT = kho.TenKhoVT,
LyDo = pn.NoiDung,
SerialNumber = m.SerialNumber,
TenVT = vt.TenVT,
NhaCC = ncc.TenNCC,
TrangThaiVT = m.TrangThai,
DVT = vt.DVT,
SoLuong = m.SoLuong,
DonGia = vt.DonGia != null?vt.DonGia.Value.ToString("#") : ""
};
ReportDocument StockObjectsReport = new crtPhieuNhap();
StockObjectsReport.SetDataSource(model.ToList());
cryView1.ReportSource = StockObjectsReport;
cryView1.RefreshReport();
}