//TheKhachHang_BUS theKH_BUS = new TheKhachHang_BUS(); //LoaiTheKhachHang_BUS loaiTheKH_BUS = new LoaiTheKhachHang_BUS(); //List<clsTheKhachHang> lstTheKH; //List<clsLoaiTheKhachHang> lstLoaiTheKH; private void HienThiDSTheKhachHang(string ma, string ten) { TheKhachHang_BUS theKH_BUS = new TheKhachHang_BUS(); LoaiTheKhachHang_BUS loaiTheKH_BUS = new LoaiTheKhachHang_BUS(); List <clsTheKhachHang> lstTheKH = theKH_BUS.LayDanhSachTheKH(ma, ten); List <clsLoaiTheKhachHang> lstLoaiTheKH = loaiTheKH_BUS.LayLoaiTheKhachHang(); var query = from theKH in lstTheKH join loaiTheKH in lstLoaiTheKH on theKH.MaLoaiThe equals loaiTheKH.MaLoaiThe select new { theKH.MaThe, theKH.MaKhachHang, theKH.MaLoaiThe, theKH.NgayDangKy, theKH.TrangThai, loaiTheKH.TenLoaiTheKH, loaiTheKH.DonViGiamGia, loaiTheKH.GiamGia }; dgvDSTheKH.AutoGenerateColumns = false; //dgvDSTheKH.DataSource = lstTheKH; dgvDSTheKH.DataSource = query.ToList(); }
private void dgvDSTheKH_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colTrangThai") { if (Convert.ToBoolean(e.Value) == true) { e.Value = "Mở"; } else { e.Value = "Khóa"; } } if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colTenKH") { KhachHang_BUS bus = new KhachHang_BUS(); List <clsKhachHang_DTO> lstKH = bus.LayDanhSachKhachHang("", -1); clsKhachHang_DTO KH = lstKH.First(u => u.MaKhachHang == e.Value.ToString()); e.Value = KH.TenKhachHang; } LoaiTheKhachHang_BUS LoaiTheKH_bus = new LoaiTheKhachHang_BUS(); List <clsLoaiTheKhachHang> lstLoaiTheKH = LoaiTheKH_bus.LayLoaiTheKhachHang(); if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colLoaiThe") { clsLoaiTheKhachHang LoaiTheKH = lstLoaiTheKH.First(u => u.MaLoaiThe == e.Value.ToString()); e.Value = LoaiTheKH.TenLoaiTheKH; } //if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colGiamGia") //{ // e.Value = lstLoaiTheKH[0].GiamGia; //} //if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colDonViGiamGia") //{ // e.Value = lstLoaiTheKH[0].DonViGiamGia; //} if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colNgayDangKy") { e.Value = DateTime.Parse(e.Value.ToString()).ToShortDateString(); } foreach (DataGridViewRow r in dgvDSTheKH.Rows) { if (!Convert.ToBoolean(r.Cells["colTrangThai"].Value.ToString())) { r.DefaultCellStyle.ForeColor = Color.Gray; } else { r.DefaultCellStyle.ForeColor = Color.Black; } } }