linq group by 多列值 实现
来源:互联网 发布:2016淘宝客好做吗 编辑:程序博客网 时间:2024/05/18 02:38
场景是:
- //这么一个LIST, 最终想得到的结果如下:
- List<TestData> list = new List<TestData>();
- list.Add(new TestData() { Name="A", Count=3,BatNum="001"});
- list.Add(new TestData() { Name = "A", Count = 3,BatNum="001" });
- list.Add(new TestData() { Name = "A", Count = 3, BatNum = "002" });
- list.Add(new TestData() { Name = "b", Count = 3, BatNum = "001" });
- list.Add(new TestData() { Name = "b", Count = 6, BatNum = "002" });
- list.Add(new TestData() { Name = "b", Count = 3, BatNum = "003" });
- list.Add(new TestData() { Name = "b", Count = 5, BatNum = "001" });
最后结果:
Name="A", Count=6,BatNum="001"
Name="A", Count=3,BatNum="002"
Name="b", Count=8,BatNum="001"
Name="b", Count=6,BatNum="002"
Name="b", Count=3,BatNum="003"
实现:
- public class TestData
- {
- public string Name{get;set;}
- public int Count { get; set; }
- public string BatNum { get; set; }
- }
- protected void Click(object sender, EventArgs e)
- {
- List<TestData> list = new List<TestData>();
- list.Add(new TestData() { Name = "A", Count = 3, BatNum = "001" });
- list.Add(new TestData() { Name = "A", Count = 3, BatNum = "001" });
- list.Add(new TestData() { Name = "A", Count = 3, BatNum = "002" });
- list.Add(new TestData() { Name = "b", Count = 3, BatNum = "001" });
- list.Add(new TestData() { Name = "b", Count = 6, BatNum = "002" });
- list.Add(new TestData() { Name = "b", Count = 3, BatNum = "003" });
- list.Add(new TestData() { Name = "b", Count = 5, BatNum = "001" });
- var query = from l in list
- group l by new { l.Name, l.BatNum } into g
- select new
- {
- Name = g.Key.Name,
- Count = g.Sum(a => a.Count),
- BatNum = g.Key.BatNum
- };
- string result = "";
- foreach (var q in query)
- {
- result += "Name=/"" + q.Name + "/"," + "Count=/"" + q.Count + "/"," + "BatNum=/"" + q.BatNum + " /"<br />";
- }
- Response.Write(result);
- }
- //结果:
- Name="A",Count="6",BatNum="001 "
- Name="A",Count="3",BatNum="002 "
- Name="b",Count="8",BatNum="001 "
- Name="b",Count="6",BatNum="002 "
- linq group by 多列值 实现
- linq group by 多列值 实现
- 通过Linq 实现DataTable Group By
- linq group by
- linq group by
- Linq group by 练习
- linq group by 处理
- linq-group by
- linq to datatable group by 多列 实现
- linq To DataTable 实现Group by 多个栏位
- linq group by 两个值
- Linq使用Group By 2
- Linq使用Group By 3
- Linq使用Group By 1
- Linq使用Group By 2
- Linq使用Group By 3
- linq中group by实例
- Linq使用Group By经验总结
- 通过HttpClient实现访问HTTPS网站
- DWR配置
- OOA,OOD,OOP,OOT
- 计算机的各种编码1
- iOS/iPhone学习系列、代码教程----~~~持续更新中~~~
- linq group by 多列值 实现
- 自定义系统菜单的背景
- layout_weight体验(实现按比例显示)
- 请求通道在等待 00:01:00 以后答复时超时
- Live555学习笔记14-live555多线程论
- Oracle分区表信息的查询
- 获取手机图片和视频的缩略图
- linux 系统帐户 无法远程登录 ftp 服务器
- 打包命令