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();
}
