public static List <clsMau_DTO> Retrieve_Mau(string condition)
{
List <clsMau_DTO> dsMau = new List <clsMau_DTO>();
string sql = @"select * from Mau where trangthai = 1";
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
while (dr.Read())
{
clsMau_DTO mau = new clsMau_DTO();
if (!dr.IsDBNull(0))
{
mau.MaMau = (string)dr["MaMau"];
}
if (!dr.IsDBNull(1))
{
mau.TenMau = (string)dr["TenMau"];
}
if (!dr.IsDBNull(2))
{
mau.TrangThai = (Boolean)dr["TrangThai"];
}
dsMau.Add(mau);
}
DataProvider.CloseConnect();
return(dsMau);
}
private void frmChiTietSanPham_Load(object sender, EventArgs e)
{
try
{
lblMaSP.Text = "CHI TIẾT CỦA SẢN PHẨM MÃ: " + info[0];
clsSanPham_DTO sp = clsSanPham_BUS.Retrieve_SanPham(info[0]);
lblSLTK.Text = Program.convertToCurrency(Convert.ToInt32(info[1])) + " cái";
lblTenSP.Text = sp.TenSP;
List <clsNhaSanXuat_DTO> nsx = clsNhaSanXuat_BUS.LayDSNSX(sp.MaNhaSX);
lblNSX.Text = nsx[0].TenNhaSX;
clsMau_DTO mau = clsMau_BUS.LayMau(info[2]);
lblMau.Text = mau.TenMau;
clsSize_DTO size = clsSize_BUS.LaySize(info[3]);
lblSize.Text = size.TenSize;
clsChatLieu_DTO CL = clsChatLieu_BUS.LayDSChatLieu(info[4]);
lblChatLieu.Text = CL.TenChatLieu;
clsLoaiSanPham_DTO loai = clsLoaiSanPham_BUS.Retrieve_LoaiSanPham(sp.MaLoaiSP);
lblLoaiSP.Text = loai.TenLoaiSP;
lblGiaBan.Text = Program.convertToCurrency(Convert.ToInt32(info[5])) + " VNĐ / cái";
lblNgayNhap.Text = sp.NgayNhapKho.ToString("dd/MM/yyyy");
picHinhAnh.Image = Image.FromFile(info[6]);
}
catch (Exception ex)
{
}
}
public static clsMau_DTO LayMau(string maMau)
{
clsMau_DTO mau = new clsMau_DTO();
string sql = string.Format("select * from Mau where MaMau = '{0}'", maMau);
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
mau.MaMau = (string)dr["MaMau"];
}
if (!dr.IsDBNull(1))
{
mau.TenMau = (string)dr["TenMau"];
}
if (!dr.IsDBNull(2))
{
mau.TrangThai = (Boolean)dr["TrangThai"];
}
}
DataProvider.CloseConnect();
return(mau);
}
