统计订单中某物品的销售总计

测试数据库设计如图：

 

实现代码如下：

 

 1                 IQueryable<Order> orders = edm.Order;
 2                 var tmpGroup = orders.GroupBy(p => p.OrderName);
 3 
 4                 var abc = (from n in tmpGroup
 5                           from m in n
 6                           select new
 7                           {
 8                               Name=n.Key,
 9                               Count=n.Count(),
10                               Sum = n.Sum(p => p.OrderDetail.Sum(c => c.Price))
11                           }).Distinct();
12                 foreach (var item in abc)
13                 {
14                     Console.WriteLine(item.Name.Trim() +"  "+item.Count+"  : " + item.Sum);
15                 }

 效果如图：

转载于:https://www.cnblogs.com/liende/archive/2012/12/28/2837968.html