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); } } }