我正在從 excel 表中讀取資料，并且（經過一些處理）我將其放入一個類中：
public class Record
{
public string partNo { get; set; }
public float quantity { get; set; }
public string designator { get; set; }
}
這是資料的樣子：
record[0]=new Record { partNo = "123456789", quantity = 2, designator = "C1 C2 " };
record[1]=new Record { partNo = "333333333", quantity = 2, designator = "D1 D2 " };
record[2]=new Record { partNo = "123456789", quantity = 3, designator = "C10 C12 C15 " };
record[3]=new Record { partNo = "222222222", quantity = 5, designator = "Q5 Q6 Q10 Q22 Q50 " };
有沒有辦法對具有相同資料的 partNo 進行分組并添加數量并連接指示符？喜歡...
record[0]=new Record { partNo = "123456789", quantity = 5, designator = "C1 C2 C10 C12 C15 " };
record[1]=new Record { partNo = "333333333", quantity = 2, designator = "D1 D2 " };
record[3]=new Record { partNo = "222222222", quantity = 5, designator = "Q5 Q6 Q10 Q22 Q50 " };
我發現了一個類似的帖子，但不完全是：Group by in LINQ
我的 c# 技能是初學者，我的 Linq 經驗是不存在的...大聲笑。
任何幫助表示贊賞。謝謝
uj5u.com熱心網友回復：
您可以使用Enumerable.GroupBy將元素分組并將其投影到新表單中：
IEnumerable<Record> groupedRecords = records.GroupBy(
record => record.partNo,
(groupKey, records) =>
new Record
{
partNo = groupKey,
quantity = records.Sum(record => record.quantity),
designator = string.Concat(
records.Select(record => record.designator))
});
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/318189.html
上一篇：如何在障礙物處正確同步執行緒
下一篇：將表連接到與父表相關的表