private void cbbDanhMuc_SelectedIndexChanged(object sender, EventArgs e) { if (cbbDanhMuc.SelectedValue.ToString() == "System.Data.DataRowView") { } else { var id = cbbDanhMuc.SelectedValue.ToString(); idDanhmuc = Convert.ToInt32(id); FMain_Load(sender, e); } DAO_Main main = new DAO_Main(); cbbSanPham.DataSource = main.ListSP_DanhMuc(idDanhmuc); if (main.ListSP_DanhMuc(idDanhmuc).Count() == 0) { cbbSanPham.Text = ""; lbSoLuong.Text = "0"; lv.Items.Clear(); } else { cbbSanPham.DisplayMember = "TenSanPham"; cbbSanPham.ValueMember = "ID"; var id = cbbSanPham.SelectedValue.ToString(); idSanPham = Convert.ToInt32(id); int soluong = main.SoLuong(idSanPham); lbSoLuong.Text = soluong.ToString(); db = new QuanLyKhoHangDataContext(); string href = "H:\\project\\c#\\Wfrom\\QuanLyKhoHnag_ChuoiCuaHangTienIch\\QuanLyKhoHnag_ChuoiCuaHangTienIch\\Image\\"; var sanpham = db.SanPhams.SingleOrDefault(x => x.ID == idSanPham); pictureBox1.Image = Image.FromFile(href + sanpham.HinhAnh); } }
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); } } }