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 List <clsLoaiSanPham_DTO> Retrieve_LoaiSanPham()
{
List <clsLoaiSanPham_DTO> dsLSP = new List <clsLoaiSanPham_DTO>();
string sql = @"select * from LoaiSanPham";
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
while (dr.Read())
{
clsLoaiSanPham_DTO lsp = new clsLoaiSanPham_DTO();
if (!dr.IsDBNull(0))
{
lsp.MaLoaiSP = (string)dr["MaLoaiSP"];
}
if (!dr.IsDBNull(1))
{
lsp.TenLoaiSP = (string)dr["TenLoaiSP"];
}
if (!dr.IsDBNull(2))
{
lsp.TrangThai = (Boolean)dr["TrangThai"];
}
dsLSP.Add(lsp);
}
DataProvider.CloseConnect();
return(dsLSP);
}
public static clsLoaiSanPham_DTO Retrieve_LoaiSanPham(string maLoai)
{
clsLoaiSanPham_DTO lsp = new clsLoaiSanPham_DTO();
string sql = string.Format("select * from LoaiSanPham where MaLoaiSP = '{0}'", maLoai);
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
lsp.MaLoaiSP = (string)dr["MaLoaiSP"];
}
if (!dr.IsDBNull(1))
{
lsp.TenLoaiSP = (string)dr["TenLoaiSP"];
}
if (!dr.IsDBNull(2))
{
lsp.TrangThai = (Boolean)dr["TrangThai"];
}
}
DataProvider.CloseConnect();
return(lsp);
}
