public static List <clsLoaiMonAn_DTO> LaydsLoaiMonAn() { List <clsLoaiMonAn_DTO> dsLoaiMonAn = new List <clsLoaiMonAn_DTO>(); SqlConnection con = ThaoTacDuLieu_DAO.TaoKetNoi(); string query = string.Format("select * from LoaiMonAn"); SqlCommand cmd = ThaoTacDuLieu_DAO.TruyVan(query, con); SqlDataReader rddtMA = cmd.ExecuteReader(); while (rddtMA.Read()) { clsLoaiMonAn_DTO itemLoaiMonAn = new clsLoaiMonAn_DTO(); if (!rddtMA.IsDBNull(0)) { itemLoaiMonAn.MaLoaiMonAn = (string)rddtMA[0]; } if (!rddtMA.IsDBNull(2)) { itemLoaiMonAn.TenLoaiMonAn = (string)rddtMA[2]; } if (!rddtMA.IsDBNull(1)) { itemLoaiMonAn.MaNhomMonAn = (string)rddtMA[1]; } // dsLoaiMonAn.Add(itemLoaiMonAn); } ThaoTacDuLieu_DAO.DongKetNoi(con); return(dsLoaiMonAn); }
private void dgvDSSP_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { if (dgvDSSP.Columns[e.ColumnIndex].Name == "colAnhMonAn") { try { if (e.Value != null) { e.Value = new Bitmap(e.Value.ToString()); } else { e.Value = new Bitmap(@"HinhAnh\AnhMonAn\no_picture.gif"); } } catch (Exception) { e.Value = new Bitmap(@"HinhAnh\AnhMonAn\no_picture.gif"); } } try { if (dgvDSSP.Columns[e.ColumnIndex].Name == "colDonViTinh") { clsDonViTinh_DTO dtoDonViTinh = lstDonViTinh.First(i => i.MaDonViTinh == e.Value.ToString()); e.Value = dtoDonViTinh.TenDonViTinh; } } catch (Exception) { } if (dgvDSSP.Columns[e.ColumnIndex].Name == "colTenLoaiMonAn") { clsLoaiMonAn_DTO dtoTenLoaiMonAn = lstLoaiMonAn.First(u => u.MaLoaiMonAn == e.Value.ToString()); e.Value = dtoTenLoaiMonAn.TenLoaiMonAn; } //colTenKichThuoc if (dgvDSSP.Columns[e.ColumnIndex].Name == "colTenKichThuoc") { clsKichThuocMonAn_DTO dtoKichThuocMonAn = lstKichThuocMonAn.First(u => u.MaKichThuoc == e.Value.ToString()); e.Value = dtoKichThuocMonAn.TenKichThuoc; } }