日期:2014-05-20 浏览次数:21232 次
rptProdct2.DataSource = (from p in plist
join s in shopcart on p.ProductID equals s.ID
where p.ProductID != s.ID
orderby p.NowPrice descending
select p).OrderBy(p => p.NowPrice).Take(10);
rptProdct2.DataBind();
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ConsoleApplication1
{
public class ShopCart
{
public int ID { get; set; }
public int Count { get; set; }
}
public class Product
{
public int ProductId { get; set; }
public decimal Price { get; set; }
public string ProductName { get; set; }
public override string ToString()
{
return ProductName;
}
}
class Program
{
static void Main(string[] args)
{
List<Product> productList = new List<Product>()
{
new Product(){ ProductId=1, Price=10, ProductName="商品1"},
new Product(){ ProductId=2, Price=10, ProductName="商品2"},
new Product(){ ProductId=3, Price=10, ProductName="商品3"},
new Product(){ ProductId=4, Price=10, ProductName="商品4"}
};
List<ShopCart> shopCart = new List<ShopCart>()
{
new ShopCart(){ ID=1, Count=10},
new ShopCart(){ ID=2, Count=10}
};
var query = productList.Except(from x in shopCart select productList.Where(y => y.ProductId == x.ID).Single());
query.ToList().ForEach(x => Console.WriteLine(x));
}
}
}