public void LoadData(int s) { List <eKhachHang> listkh = new List <eKhachHang>(); //Chon ra nhung phieu dat truoc theo tieu de da dat // ePhieuDatTruoc bs = tieuDeBUL.FindbyID(s); var lispdt = from td in tieuDeBUL.getTieuDes() join pdt in phieuDatTruocBUL.getPhieuDatTruocs() on td.id_TieuDe equals pdt.id_TieuDe where pdt.id_TieuDe == s select new { pdt.id_KhachHang, pdt.id_TieuDe }; var lit = from p in lispdt join kh in khachHangBUL.getKhachHangs1() on p.id_KhachHang equals kh.id_KhachHang select new { kh.id_KhachHang, kh.tenKhachHang, kh.soCMND, kh.soDT }; foreach (var item in lit) { eKhachHang ek = new eKhachHang(); ek.id_KhachHang = item.id_KhachHang; ek.tenKhachHang = item.tenKhachHang; ek.soCMND = item.soCMND; ek.soDT = item.soDT; listkh.Add(ek); } dgv_dskhdat.DataSource = listkh; }
private void QuanLyKhachHang_Load(object sender, EventArgs e) { dgv_dskh.DataSource = kh.getKhachHangs1(); }