public static List <SanPhamDTO> LaySanPhamTheoDanhMuc(string tendanhmuc) { SqlDataReader reader = DataProvider.TruyVanSPTheoDanhMuc("LaySPTheoDanhMuc", tendanhmuc); List <SanPhamDTO> lsp = new List <SanPhamDTO>(); try { while (reader.Read()) { SanPhamDTO sp = new SanPhamDTO(); sp.MaSP = reader.GetString(0); sp.TenSP = reader.GetString(1); sp.TenLoaiSP = reader.GetString(3); sp.TenDanhMuc = reader.GetString(2); sp.XuatXu = reader.GetString(4); sp.DonViTinh = reader.GetString(5); sp.GiaBan = (int)reader.GetDecimal(6); sp.SoLuong = reader.GetInt32(7); lsp.Add(sp); } reader.Close(); } catch { } return(lsp); }