C#LINQ查詢按條件求和行并添加到現有串列-有解無憂

我有以下資料串列。

 var data = new List<SummaryTabData>()
        {
            new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_CFD_Long", avgSlippagePts = 54.23} ,
            new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_FX_Long", avgSlippagePts = 61.41} ,
            new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_FX_Short", avgSlippagePts = 11.48} ,
            new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_CFD_Short", avgSlippagePts = 63.51} ,

            new SummaryTabData(){ LP = "LP_2", assetClass = "Asset_FX_Long",  avgSlippagePts = 6.51} ,            
            new SummaryTabData(){ LP = "LP_2", assetClass = "Asset_FX_Short", avgSlippagePts = 13.51}
        };

我的目標是為每種型別的 LP為每對Asset_CFD_long/Asset_CFD_short和Asset_FX_Long/Asset_FX_Short添加一個額外的行。有時可能有 2 或 4 個資產類別，就像您在示例片段中看到的那樣

最終結果應該是這樣的。

var data = new List<SummaryTabData>()
            {
                new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_CFD_Long", avgSlippagePts = 54.23} ,
                new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_CFD_Short", avgSlippagePts = 63.51} ,

                // that is the new row added to the collection for LP_1 CFD
                new SummaryTabData(){ LP = "LP_1", assetClass = "CFD_Total", avgSlippagePts = 117.74} ,

                new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_FX_Long", avgSlippagePts = 61.41} ,
                new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_FX_Short", avgSlippagePts = 11.48} ,

                // that is the new row added to the collection for LP_1 FX
                new SummaryTabData(){ LP = "LP_1", assetClass = "FX_Total", avgSlippagePts = 72.89} ,

                new SummaryTabData(){ LP = "LP_2", assetClass = "Asset_FX_Long",  avgSlippagePts = 6.51} ,
                new SummaryTabData(){ LP = "LP_2", assetClass = "Asset_FX_Short", avgSlippagePts = 13.51},

                // that is the new row added to the collection for LP_2 FX
                new SummaryTabData(){ LP = "LP_2", assetClass = "FX_Total", avgSlippagePts = 20.02},
            };

資料沒有排序。您是否知道可以執行此操作的某種 LINQ 查詢，或者我應該使用傳統的 for 回圈方法？

uj5u.com熱心網友回復：

要求有點奇怪，但是假設 LP 組可以以任何方式排序

更新

var groups = data
   .Select(x => new { Asset = x.assetClass.Split("_")[1], Summary = x })
   .GroupBy(x => new { x.Asset, x.Summary.LP });

var list = new List<SummaryTabData>();

foreach (var group in groups)
{
   list.AddRange(group.Select(x => x.Summary).ToList());

   list.Add(new SummaryTabData()
   {
      assetClass = $"{group.Key.Asset}_Total",
      LP = group.Key.LP,
      avgSlippagePts = group.Sum(x => x.Summary.avgSlippagePts)
   });

}

foreach (var item in list)
   Console.WriteLine($"{item.LP}, {item.assetClass}, {item.avgSlippagePts}");

輸出

LP_1, Asset_FX_Short, 11.48
LP_1, Asset_FX_Long, 61.41
LP_1, FX_Total, 72.89
LP_1, Asset_CFD_Short, 63.51
LP_1, Asset_CFD_Long, 54.23
LP_1, CFD_Total, 117.74
LP_2, Asset_FX_Short, 13.51
LP_2, Asset_FX_Long, 6.51
LP_2, FX_Total, 20.02

在所有可能的引擎蓋中，還有其他方法可以做到這一點

完整演示在這里

uj5u.com熱心網友回復：

using System;
using System.Collections.Generic;using System.Linq;

namespace TestConsoleApp
{
    class Program
    {
        public class SummaryTabData
        {
            public string LP { get; set; }
            public string assetClass { get; set; }
            public double avgSlippagePts { get; set; }
        }

        public enum AssetClassType
        {
            Cfd,
            Fx
        }

        static void Main(string[] args)
        {

            var data = new List<SummaryTabData>()
            {
                new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_CFD_Long", avgSlippagePts = 54.23} ,
                new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_FX_Long", avgSlippagePts = 61.41} ,

                new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_FX_Short", avgSlippagePts = 11.48} ,
                new SummaryTabData(){ LP = "LP_1", assetClass = "Asset_CFD_Short", avgSlippagePts = 63.51} ,

                new SummaryTabData(){ LP = "LP_2", assetClass = "Asset_FX_Long",  avgSlippagePts = 6.51} ,
                new SummaryTabData(){ LP = "LP_2", assetClass = "Asset_FX_Short", avgSlippagePts = 13.51}
            };
            var expectedResult = GetSummaries(data);

        }

        private static List<SummaryTabData> GetSummaries(List<SummaryTabData> data)
        {
            var datas = data.Select(x => new
            {
                x.LP,
                x.assetClass,
                x.avgSlippagePts,
                AssetClassType = x.assetClass.Contains("CFD") ? AssetClassType.Cfd : AssetClassType.Fx
            }).GroupBy(x => new { x.AssetClassType, x.LP })
                .Select(x => new
                {
                    assetClass = x.Key.AssetClassType == AssetClassType.Cfd ? "CFD_Total" : "FX_Total",
                    sum = x.Sum(z => z.avgSlippagePts),
                    Lp = x.Key.LP,
                    SummaryTabData = x.Select(z => new SummaryTabData()
                    {
                        assetClass = z.assetClass,
                        LP = z.LP,
                        avgSlippagePts = z.avgSlippagePts
                    })
                }).ToList();

            List<SummaryTabData> result = new List<SummaryTabData>();

            foreach (var groupData in datas)
            {
                result.AddRange(groupData.SummaryTabData);

                result.Add(new SummaryTabData
                {
                    assetClass = groupData.assetClass,
                    LP = groupData.Lp,
                    avgSlippagePts = groupData.sum
                });
            }

            return result;
        }
    }
}

我認為這段代碼可以幫助您解決問題，我在代碼的第一部分使用了 LINQ，在代碼的最后一部分我無法避免使用 foreach。

轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/314652.html

標籤：C＃林克链接到 sql

上一篇：如何在linq查詢c#中的WHERE陳述句后嵌入動態OR條件

下一篇：C#比較兩個陣列并對匹配執行操作