private void icoBtnInphieuthue_Click(object sender, EventArgs e) { try { HOA_DON hd = context.HOA_DON.FirstOrDefault(p => p.MaThuePhong == maThuePhong); if (hd == null) { throw new Exception("Phiếu thuê này chưa thanh toán"); } if (maThuePhong.Equals(string.Empty)) { throw new Exception("Vui lòng chọn phiếu thuê cần xuất"); } ClassReport.ReportInfo info = new ClassReport.ReportInfo(); info.ID = maThuePhong; info.pIDRoom = context.CHI_TIET_PHIEU_THUE_PHONG.Where(p => p.MaThuePhong.Equals(maThuePhong)).Select(p => p.MaPhong).FirstOrDefault(); info.pName = context.CHI_TIET_PHIEU_THUE_PHONG.Where(p => p.MaThuePhong.Equals(maThuePhong)).Select(p => p.HoTenKhachHang).FirstOrDefault(); info.pDateFrom = context.CHI_TIET_PHIEU_THUE_PHONG.Where(p => p.MaThuePhong.Equals(maThuePhong)).Select(p => p.NgayNhan).FirstOrDefault(); info.pDateTo = context.CHI_TIET_PHIEU_THUE_PHONG.Where(p => p.MaThuePhong.Equals(maThuePhong)).Select(p => p.NgayTra).FirstOrDefault(); info.pTienPhong = double.Parse(context.HOA_DON.Where(p => p.MaThuePhong.Equals(maThuePhong)).Select(p => p.TongTien).FirstOrDefault().ToString()); FormReport.ReportPhieuThue Frm = new FormReport.ReportPhieuThue(info); Frm.DataSource = context.DANH_SACH_SU_DUNG_DICH_VU.Join ( context.DICH_VU, DS => DS.MaDichVu, DV => DV.MaDichVu, (DS, DV) => new { DS, DV } ) .Where(p => p.DS.MaThuePhong.Equals(maThuePhong)) .Select ( p => new { TenDichVu = p.DV.TenDichVu, SoLuong = p.DS.SoLuong, DonGia = p.DV.DonGia, ThanhTien = p.DV.DonGia * p.DS.SoLuong, } ).ToList(); frmReportViewer Rpv = new frmReportViewer(Frm); Rpv.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public frmReportViewer(FormReport.ReportPhieuThue frm) { InitializeComponent(); FormPT = frm; load(); }