private void FMain_Load(object sender, EventArgs e)
{
DAO_SanPham sp = new DAO_SanPham();
DAO_Main main = new DAO_Main();
List <DTO_SanPham> list = new List <DTO_SanPham>();
if (cbbDanhMuc.Text == "" && cbbSanPham.Text == "")
{
lv.Items.Clear();
list = main.ListSP();
foreach (var item in list)
{
ListViewItem it = new ListViewItem(item.ID.ToString());
it.SubItems.Add(item.Tensanpham);
it.SubItems.Add(item.Soluong.ToString());
it.SubItems.Add(item.Donvi.ToString());
it.SubItems.Add(item.Ngaythem.ToString());
it.SubItems.Add(item.Ngaysanxuat.ToString());
it.SubItems.Add(item.Hansudung.ToString());
object table = Data.Instance.ExecuteScalar("select TenDanhMuc from DanhMucSanPham where ID = @id ", new object[] { item.DanhmucID });
string danhmuc = table.ToString();
it.SubItems.Add(danhmuc);
lv.Items.Add(it);
}
}
else if (cbbDanhMuc.Text != "" && cbbSanPham.Text == "")
{
lv.Items.Clear();
list = main.ListSP_DanhMuc(idDanhmuc);
foreach (var item in list)
{
ListViewItem it = new ListViewItem(item.ID.ToString());
it.SubItems.Add(item.Tensanpham);
it.SubItems.Add(item.Soluong.ToString());
it.SubItems.Add(item.Donvi.ToString());
it.SubItems.Add(item.Ngaythem.ToString());
it.SubItems.Add(item.Ngaysanxuat.ToString());
it.SubItems.Add(item.Hansudung.ToString());
object table = Data.Instance.ExecuteScalar("select TenDanhMuc from DanhMucSanPham where ID = @id ", new object[] { item.DanhmucID });
string danhmuc = table.ToString();
it.SubItems.Add(danhmuc);
lv.Items.Add(it);
}
}
else if (cbbDanhMuc.Text != "" && cbbSanPham.Text != "")
{
lv.Items.Clear();
list = main.ListSP_DanhMuc_SanPham(idSanPham);
foreach (var item in list)
{
ListViewItem it = new ListViewItem(item.ID.ToString());
it.SubItems.Add(item.Tensanpham);
it.SubItems.Add(item.Soluong.ToString());
it.SubItems.Add(item.Donvi.ToString());
it.SubItems.Add(item.Ngaythem.ToString());
it.SubItems.Add(item.Ngaysanxuat.ToString());
it.SubItems.Add(item.Hansudung.ToString());
object table = Data.Instance.ExecuteScalar("select TenDanhMuc from DanhMucSanPham where ID = @id ", new object[] { item.DanhmucID });
string danhmuc = table.ToString();
it.SubItems.Add(danhmuc);
lv.Items.Add(it);
}
}
}
