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;
}
}
