private void LoadDonDatPhong() { panel_HoaDon.Controls.Clear(); List <DTO_KhachHang> lsobj_kh = new List <DTO_KhachHang>(); List <DTO_CTHD> lsobj_cthd = new List <DTO_CTHD>(); List <DTO_LoaiPhong> lsobj_lp = new List <DTO_LoaiPhong>(); List <DTO_Phong> lsobj_p = new List <DTO_Phong>(); List <DTO_HoaDon> lsobj_hd = new List <DTO_HoaDon>(); List <DTO_NhanVien> lsobj_nv = new List <DTO_NhanVien>(); string result = bus_kh.SelectAll(lsobj_kh); string result1 = bus_cthd.selectAll(lsobj_cthd); string result2 = bus_lp.SelectAll(lsobj_lp); string result3 = bus_p.SelectAll(lsobj_p); string result4 = bus_hd.SelectAll(lsobj_hd); string result5 = bus_nv.SelectAll(lsobj_nv); var query = (from kh in lsobj_kh join cthd in lsobj_cthd on kh.Makh equals cthd.Makh join p in lsobj_p on cthd.Sophong equals p.Sophong join hd in lsobj_hd on cthd.Macthd equals hd.MaCTHD where cthd.Manv == Message select new { MaKH = kh.Makh, TenKH = kh.Tenkh, SoPhong = p.Sophong, NgayTT = hd.Ngaythanhtoan, TraTruoc = hd.Tratruoc } ); foreach (var item in query) { GUI_DanhSach.x1HoaDon x1_HD = new GUI_DanhSach.x1HoaDon(); x1_HD.lb_MaKH.Text = item.MaKH; x1_HD.lb_TenKH.Text = item.TenKH; x1_HD.lb_SoPhong.Text = item.SoPhong; x1_HD.lb_NgayThanhToan.Text = item.NgayTT; x1_HD.lb_TraTruoc.Text = item.TraTruoc; this.panel_HoaDon.Controls.Add(x1_HD); x1_HD.Dock = DockStyle.Top; } }