private void icoBtnXuatphieusuachua_Click(object sender, EventArgs e) { FormReport.ReportPhieuSuaChua Frm = new FormReport.ReportPhieuSuaChua(); var psc = context.PHIEU_SUA_CHUA.Join ( context.CHI_TIET_PHIEU_SUA_CHUA, PSC => PSC.MaPhieuSua, CT => CT.MaPhieuSua, (PSC, CT) => new { PSC, CT } ) .Join ( context.THIET_BI, PSCCT => PSCCT.CT.MaThietBi, TB => TB.MaThietBi, (PSCCT, TB) => new { PSCCT, TB } ).Join ( context.NHAN_VIEN, PSCCTTB => PSCCTTB.PSCCT.PSC.MaNhanVien, NV => NV.MaNhanVien, (PSCCTTB, NV) => new { PSCCTTB, NV } ).Select ( p => new { MaPhong = p.PSCCTTB.PSCCT.PSC.MaPhong, NgayBatDau = p.PSCCTTB.PSCCT.PSC.NgayBatDau, NgayKetThuc = p.PSCCTTB.PSCCT.PSC.NgayKetThuc, HoTen = p.NV.HoTen, MaThietBi = p.PSCCTTB.TB.MaThietBi, TenThietBi = p.PSCCTTB.TB.TenThietBi, PhiSuaChua = p.PSCCTTB.PSCCT.CT.PhiSuaChua, NguyenNhan = p.PSCCTTB.PSCCT.PSC.NguyenNhan, GhiChu = p.PSCCTTB.PSCCT.PSC.GhiChu } ).ToList(); Frm.DataSource = psc; frmReportViewer Rpv = new frmReportViewer(Frm); Rpv.ShowDialog(); }
public frmReportViewer(FormReport.ReportPhieuSuaChua frm) { InitializeComponent(); FormPSC = frm; load(); }