public static clsChatLieu_DTO LayChatLieu(string maCL)
{
clsChatLieu_DTO ChatLieu = new clsChatLieu_DTO();
string query = string.Format("select * from ChatLieu where MaChatLieu = '{0}'", maCL);
SqlDataReader dr = DataProvider.Retrieve_Table(query);
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
ChatLieu.MaChatLieu = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
ChatLieu.TenChatLieu = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
ChatLieu.TrangThai = dr.GetBoolean(2);
}
}
DataProvider.CloseConnect();
return(ChatLieu);
}
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 <clsChatLieu_DTO> LayDSChatLieu()
{
List <clsChatLieu_DTO> dsCL = new List <clsChatLieu_DTO>();
string query = "select * from ChatLieu";
SqlDataReader dr = DataProvider.Retrieve_Table(query);
while (dr.Read())
{
clsChatLieu_DTO ChatLieu = new clsChatLieu_DTO();
if (!dr.IsDBNull(0))
{
ChatLieu.MaChatLieu = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
ChatLieu.TenChatLieu = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
ChatLieu.TrangThai = dr.GetBoolean(2);
}
dsCL.Add(ChatLieu);
}
DataProvider.CloseConnect();
return(dsCL);
}
