private int tongkhno() { List <eKhachHang> lskh = khbul.getKhachHangs(); int i = 0; foreach (var item in lskh) { List <ePhieuThueTra> lsp = phieu.getPhieuThueTraByKHBaoCao(item.id_KhachHang); foreach (var item1 in lsp) { if (item1.ngayTraPhiTreHen == null) { i++; break; } } } return(i); }
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.getKhachHangs() 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 BaoCaoKhachHang_Load(object sender, EventArgs e) { khbul = new KhachHangBUL(); phieu = new PhieuThueTraBUL(); td = new TieuDeBUL(); tl = new TheLoaiBUL(); dvd = new DVDBUL(); List <eKhachHang> ls = khbul.getKhachHangs(); dgv_dskh.DataSource = ls; FormatLaiDataGridviewkh(dgv_dskh); txt_totalkhnop.Text = tongkhno().ToString(); txt_totaldiatra.Text = tongkhthue().ToString(); cb_listkh.Items.Add("Tất Cả"); cb_listkh.Items.Add("Khách hàng quá hạn trả đĩa"); cb_listkh.Items.Add("Khách hàng nợ phí trễ hạn"); cb_listkh.SelectedIndex = 0; }
void loadDataGridView(DataGridView d) { dgv_dskh.DataSource = khbul.getKhachHangs(); FormatGridView(d); }