C# List GroupBy and Sum
2024-10-22 04:49:54
List<PartRequest> partRequests = new List<PartRequest>();
partRequests.Add(new PartRequest()
{
factory = "f1",
stock = "s1",
material = "m1",
quantity = 10
}); partRequests.Add(new PartRequest()
{
factory = "f1",
stock = "s1",
material = "m1",
quantity = 20
}); partRequests.Add(new PartRequest()
{
factory = "f1",
stock = "s2",
material = "m1",
quantity = 40
}); partRequests.Add(new PartRequest()
{
factory = "f2",
stock = "s1",
material = "m1",
quantity = 10
});
partRequests.Add(new PartRequest()
{
factory = "f1",
stock = "s1",
material = "m2",
quantity = 80
}); partRequests.Add(new PartRequest()
{
factory = "f2",
stock = "s2",
material = "m2",
quantity = 120
}); partRequests.Add(new PartRequest()
{
factory = "f2",
stock = "s2",
material = "m2",
quantity = 120
}); var materialGroup = partRequests.GroupBy(x => new { x.material }).Select(x => x.Key.material).ToList(); var groupedResult = partRequests.GroupBy(x=>string.Join(x.factory,":",x.stock,":",x.material)).ToList(); var groupByStckAndFactoryResult = partRequests.GroupBy(x => new { factory = x.factory, stock = x.stock})
.Select(y => new { factory = y.Key.factory, stock = y.Key.stock, material = y.First().material }).ToList(); var groupByStckAndFactoryAndMaterialResult = partRequests.GroupBy(x => new { factory = x.factory, stock = x.stock, material = x.material })
.Select(y => new { factory = y.Key.factory, stock = y.Key.stock, material = y.Key.material, quantity = y.Sum(i => i.quantity) }).ToList(); Console.WriteLine(materialGroup);
最新文章
- IP 地址分类(A、B、C、D、E类)
- Spark难道比oracle性能还差?百万级数据测试性能
- LeetCode 笔记25 Candy (艰难的调试)
- 【团队项目演示】FZU5BOYS之团队项目链接汇总
- 黑马程序员——JAVA基础之System,Runtime,Date,Calendar,Math
- C#全局作用符::
- 【WCF--初入江湖】08 并发与实例模式
- DirectSound播放PCM(可播放实时采集的音频数据)
- C# 产生随机密码
- Best Sequence
- 什么是PROFINET IO系统的实时性
- Spring boot入门(二):Spring boot集成MySql,Mybatis和PageHelper插件
- 【sock_stream和sock_dgram】、 【AF_INET和AF_UNIX】
- HTML的基础样式之CSS
- MySQL中varchar与char区别
- css基本图形绘制(基本的矩形、圆形、椭圆、三角形、多边形,也包括稍微复杂一点的爱心、钻石、阴阳八卦等)
- Spring重复扫描导致事务失败的解决方案及深入分析
- 线程8--GCD常见用法
- ASP.Net WebAPI的返回值
- python第六课——判断结构
热门文章
- wibu软授权(五)
- Vue的watch观察xxx.xx.xx点出属性值的解决办法
- Warning: PHP Startup: Unable to load dynamic library
- docker-compose简易编写和模板命令
- 066_VFPage中Js Button与controller交互方式(一)
- ecplise项目启动出现permgen space异常内存不够
- Android 切换wifi小记
- 接入GoogelAdmob C#服务器端验证 (SSV) 回调
- 路飞项目day01 软件开发流程、PIP永久换源、虚拟环境、路飞项目开始
- enzyme文档