4,816
社区成员
发帖
与我相关
我的任务
分享
static List<User> list = new List<User>()
{
new User(){id=1 ,name="语文",money=10},
new User(){id=1 ,name="语文",money=10},
new User(){id=2 ,name="数学",money=20},
new User(){id=2 ,name="数学",money=10},
new User(){id=2 ,name="数学",money=30},
new User(){id=3 ,name="英语",money=50},
new User(){id=3 ,name="英语",money=30},
new User(){id=3 ,name="英语",money=20},
new User(){id=3 ,name="英语",money=10},
new User(){id=4 ,name="计算机",money=40},
new User(){id=4 ,name="计算机",money=20},
};
public class User
{
public int id { get; set; }
public virtual string name { get; set; }
public virtual decimal money { get; set; }
public User MyClone()
{
return (User)this.MemberwiseClone();
}
}
static void Main(string[] args)
{
var q = list.GroupBy(x => new {x.id,x.name}).Select(x => new
{
id = x.Key.id,
name=x.Key.name,
count=x.Count(),
total=x.Sum(y=>y.money)
});
StringBuilder sb = new StringBuilder("<table>");
sb.AppendLine("<tr><td>客户代码</td><td>名称</td><td>熟数量</td><td>总金额</td></tr>");
foreach (var item in q)
{
sb.AppendLine(string.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td>", item.id, item.name, item.count, item.total));
sb.AppendLine("<hr>");
}
sb.AppendLine("</table>");
Console.WriteLine(sb);
Console.ReadLine();
}