首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >具有多个条件并将值设置到列表中的LINQ查询

问具有多个条件并将值设置到列表中的LINQ查询
EN

Stack Overflow用户
提问于 2018-05-04 08:07:50
回答 1查看 43关注 0票数 0

我正在从事一个项目,我正在与xml,c#和行查询工作。

此函数的主要目的是创建日期列表,其中包含每个日期(所有驱动因素)上的总距离,并按日期排序(请注意,日期格式为YYYY/MM/YY,以使排序更容易)

我唯一不确定的部分是最后一部分,我是按日期排序的,因为目前我只能按距离排序。

代码语言:javascript
复制
public List<String> CalculateDistDates()
    {
        List<String> distDatesList = new List<string>();

        var datesDistTot =
            from Driver in this.Drivers
            from Journey in Driver.Journeys
            group Journey by Journey.JourneyDate into distance
            let totaldistance = (from jour in distance
            select (int)jour.Distance).Sum() 
            orderby totaldistance descending


            select new
            {
                journeyDate = .Key,
                totaldistance = totaldistance

            };
EN

回答 1

Stack Overflow用户

发布于 2018-05-04 11:17:55

我试着回答你的问题,并稍微调整了代码以达到相同的结果。

模拟模型

代码语言:javascript
复制
 public class Journey
    {
        public decimal Distance { get; set; }
        public DateTime JourneyDate { get; set; }
    }
    public class Drivers
    {
        public string Name { get; set; }
        public Journey Journey { get; set; }
    }

    public class  DistanceCovered
    {
        public DateTime JourneyDate { get; set; }
        public decimal TotalDistance { get; set; }
    }

这是在控制台应用中创建的函数,只需删除测试代码并填充您的数据即可。

代码语言:javascript
复制
public static void CalculateDistDates()
    {            
        var drivers = new List<Drivers>
        {
            new Drivers{Journey = new Journey {Distance = 1.2M, JourneyDate = DateTime.Now.AddDays(1).Date}},
            new Drivers{Journey =  new Journey{Distance = 1.2M, JourneyDate = DateTime.Now.AddDays(2).Date}},
            new Drivers{Journey =  new Journey{Distance = 1.1M, JourneyDate = DateTime.Now.AddDays(2).Date}},
            new Drivers{Journey =  new Journey{Distance = 1.5M, JourneyDate = DateTime.Now.AddDays(3).Date}},
            new Drivers{Journey = new Journey {Distance = 1.7M, JourneyDate = DateTime.Now.AddDays(-1).Date}},
            new Drivers{Journey =  new Journey{Distance = 1.1M, JourneyDate = DateTime.Now.AddDays(3).Date}},
            new Drivers{Journey =  new Journey{Distance = 0.2M, JourneyDate = DateTime.Now.AddDays(2).Date}}
        };

        var totalDistance = (from d in drivers
            group d by d.Journey.JourneyDate
            into j                 
            select new DistanceCovered
            {
                JourneyDate = j.Key,
                TotalDistance = j.Sum(r=>r.Journey.Distance)
            }).ToList().OrderBy(r=>r.JourneyDate).ThenByDescending(r=>r.TotalDistance);

        foreach (var t in totalDistance)
        {
            Console.WriteLine($"{t.JourneyDate}: {t.TotalDistance}" );
        }

        Console.ReadLine();            
    }
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/50165366

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档