void getDataTaiSan()
{
cbbTaiSan.Items.Clear();
string query = @"SELECT ma_tai_san, ten_tai_san, so_luong, tri_gia, mo_ta, img
FROM TaiSan
WHERE taikhoan = 'admin'";
DB.conn.Open();
SqlCommand cmd = new SqlCommand(query, DB.conn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
CTaiSan ngd = new CTaiSan(rd[0].ToString(), rd[1].ToString(), rd[2].ToString(), rd[3].ToString(), rd[4].ToString(), (byte[])rd[5]);
cbbTaiSan.Items.Add(ngd);
}
DB.conn.Close();
}
public void getData()
{
listTaiSan = new List <CTaiSan>();
string query = @"SELECT ma_tai_san, ten_tai_san, so_luong, tri_gia, mo_ta, img
FROM TaiSan
WHERE taikhoan = '" + IDUser + "' ORDER BY so_luong * tri_gia DESC";
DB.conn.Open();
SqlCommand cmd = new SqlCommand(query, DB.conn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
CTaiSan ppt = new CTaiSan(rd[0].ToString(), rd[1].ToString(), rd[2].ToString(), rd[3].ToString(), rd[4].ToString(), (byte[])rd[5]);
listTaiSan.Add(ppt);
}
DB.conn.Close();
addItem();
}
void getData()
{
string query = @"SELECT ma_tai_san, ten_tai_san, so_luong, tri_gia, mo_ta, img
FROM TaiSan
WHERE ma_tai_san = " + Id + "";
DB.conn.Open();
SqlCommand cmd = new SqlCommand(query, DB.conn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
TaiSan = new CTaiSan(rd[0].ToString(), rd[1].ToString(), rd[2].ToString(), rd[3].ToString(), rd[4].ToString(), (byte[])rd[5]);
}
DB.conn.Close();
lbName.Text = TaiSan.Name;
lbCount.Text = TaiSan.Count;
lbValue.Text = Commom.getMoneyStr(TaiSan.Value);
lbDescription.Text = TaiSan.Description;
pbAnhTaiSan.Image = TaiSan.getImage();
}
