public List <ClassHangHoa> TimTheoSL(int SL) { using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext()) { List <ClassHangHoa> lstHH = new List <ClassHangHoa>(); db.DeferredLoadingEnabled = false; var ttHH = from n in db.HangHoas join u in db.HangSanXuats on n.MaHangSanXuat equals u.MaHangSanXuat join l in db.LoaiSanPhams on n.MaLoaiHangHoa equals l.MaLoaiSanPham select new { n.MaHangHoa, n.TenHangHoa, n.GiaNhap, n.GiaBan, n.SoLuongCon, n.TrangThai, n.ChuThich, n.Image, u.TenHangSanXuat, l.TenLoaiSanPham }; foreach (var i in ttHH) { if (i.SoLuongCon <= SL) { ClassHangHoa HHNew = new ClassHangHoa(); HHNew.MaHangHoa = i.MaHangHoa; HHNew.TenHangHoa = i.TenHangHoa; HHNew.LoaiHangHoa = i.TenLoaiSanPham; HHNew.HangSanXuat = i.TenHangSanXuat; HHNew.GiaNhap = i.GiaNhap; HHNew.GiaBan = i.GiaBan; HHNew.SoLuongCon = i.SoLuongCon; HHNew.TrangThai = i.TrangThai; HHNew.ChuThich = i.ChuThich; if (i.Image != null) { // HHNew.Image = ByteArrayToImage(i.Image.ToArray()); } lstHH.Add(HHNew); } } return(lstHH); } }
public List <ClassHangHoa> GetHangHoa() { using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext()) { List <ClassHangHoa> lstHH = new List <ClassHangHoa>(); db.DeferredLoadingEnabled = false; var ttHH = from n in db.HangHoas join u in db.HangSanXuats on n.MaHangSanXuat equals u.MaHangSanXuat join l in db.LoaiSanPhams on n.MaLoaiHangHoa equals l.MaLoaiSanPham where n.TrangThai == true select new { n.MaHangHoa, n.TenHangHoa, n.GiaNhap, n.GiaBan, n.SoLuongCon, n.TrangThai, n.ChuThich, n.Image, u.TenHangSanXuat, l.TenLoaiSanPham }; foreach (var i in ttHH) { ClassHangHoa HHNew = new ClassHangHoa(); HHNew.MaHangHoa = i.MaHangHoa; HHNew.TenHangHoa = i.TenHangHoa; HHNew.LoaiHangHoa = i.TenLoaiSanPham; HHNew.HangSanXuat = i.TenHangSanXuat; HHNew.GiaNhap = i.GiaNhap; HHNew.GiaBan = i.GiaBan; HHNew.SoLuongCon = i.SoLuongCon; HHNew.TrangThai = i.TrangThai; HHNew.ChuThich = i.ChuThich; lstHH.Add(HHNew); } return(lstHH); } }