public List <clsLoaiTheKhachHang> LayLoaiTheKhachHang() { List <clsLoaiTheKhachHang> lstLoaiTheKH = new List <clsLoaiTheKhachHang>(); SqlConnection con = ThaoTacDuLieu_DAO.TaoKetNoi(); string query = "SELECT * FROM LoaiTheKhachHang"; SqlCommand cmd = ThaoTacDuLieu_DAO.TruyVan(query, con); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { clsLoaiTheKhachHang loaiTheKH = new clsLoaiTheKhachHang(); if (!reader.IsDBNull(0)) { loaiTheKH.MaLoaiThe = (string)reader[0]; } if (!reader.IsDBNull(1)) { loaiTheKH.TenLoaiTheKH = (string)reader[1]; } if (!reader.IsDBNull(2)) { loaiTheKH.GiamGia = (float)(double)reader[2]; } if (!reader.IsDBNull(3)) { loaiTheKH.DonViGiamGia = (string)reader[3]; } if (!reader.IsDBNull(4)) { loaiTheKH.TrangThai = (bool)reader[4]; } lstLoaiTheKH.Add(loaiTheKH); } ThaoTacDuLieu_DAO.DongKetNoi(con); return(lstLoaiTheKH); }
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; } } }