private void LoadReportSource(string _MaKho)
{
crtPhieuXuat cry = new crtPhieuXuat();
var model = from m in db.ChiTietPhieuXuats
join vt in db.VatTus on m.MaVT equals vt.MaVT
join pn in db.PhieuXuats on m.MaPX equals pn.MaPX
join ncc in db.NhaCungCaps on vt.MaNCC equals ncc.MaNCC
join kho in db.KhoVatTus on pn.MaKhoXuat equals kho.MaKhoVT
where m.MaPX.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.TrangThaiVT,
DVT = vt.DVT,
SoLuong = m.SoLuong,
DonGia = vt.DonGia != null ? vt.DonGia.Value : 0
};
cry.SetDataSource(model.ToList());
cryView1.ReportSource = cry;
cryView1.RefreshReport();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crtPhieuXuat rpt = new crtPhieuXuat();
rpt.Site = this.Site;
return(rpt);
}