如何使用 Linq 对list数组进行分组？同时有多个字段
0
悬赏园豆：10
[已解决问题]
解决于 2019-12-02 17:35
数据：
G1 | TINA AM | 22 | CT | 3
G2 | TINA AM | 22 | TLC | 3
G3 | TINA AM | 22 | TLC | 3
G4 | TINA AM | 10 | CT | 2
想要实现的效果：
list1：
G1 | TINA AM | 22 | CT | 3
list2：
G2 | TINA AM | 22 | TLC | 3
G3 | TINA AM | 22 | TLC | 3
list3：
G4 | TINA AM | 10 | CT | 2
部分代码如下：
public class CommodityInfo
{
public string GateNo { get; set; }
public string NozzleStyle { get; set; }
public string NozzleSize { get; set; }
public string NozzleType { get; set; }
public int HeatreCount { get; set; }
}
private void button1_Click(object sender, EventArgs e)
{
List<CommodityInfo> personList = new List<CommodityInfo>();
personList.Add(new CommodityInfo() { GateNo = "G1", NozzleStyle = "TINA AM", NozzleSize = "22", NozzleType = "CT", HeatreCount = 3 });
personList.Add(new CommodityInfo() { GateNo = "G2", NozzleStyle = "TINA AM", NozzleSize = "22", NozzleType = "TLC", HeatreCount = 3 });
personList.Add(new CommodityInfo() { GateNo = "G3", NozzleStyle = "TINA AM", NozzleSize = "22", NozzleType = "TLC", HeatreCount = 3 });
personList.Add(new CommodityInfo() { GateNo = "G4", NozzleStyle = "TINA AM", NozzleSize = "10", NozzleType = "CT", HeatreCount = 2 });
}
最佳答案
0
personList.GroupBy(t=>$"{t.NozzleType}{t.HeatreCount }" )
.Dictionary(t=>t.Key,t=>t.ToArray();)
收获园豆：8
问题已解决，谢谢🙏
其他回答(2)
0
看你这例子也不是分组啊，不是筛选吗？
姑且看成分组，比如按照NozzleSize 和NozzleType 分组，
var groupNozzleSize = personList.groupby(new{param1=NozzleSize ,param2=NozzleType});
收获园豆：1
感谢回复，问题已解决🙏
0
var list1=personList.where(e=>e.NozzleType.Equals("CT")&&e.HeatreCount==3 );
var list2=personList.where(e=>e.NozzleType.Equals("TLC")&&e.HeatreCount==3 );
var list3=personList.where(e=>e.NozzleType.Equals("CT")&&e.HeatreCount==2 );
收获园豆：1
感谢回复，问题已解决🙏
