使用linq group by从具有DateTime属性的对象列表到具有间隔StartDate，EndDate的列表

debugcn 发表于 Dev

米海

我有一个预订实体，该实体按天存储数据，因此，如果第一个列表中的日期是连续的，则我希望能够创建另一个按时间间隔（StartDate，EndDate）存储数据的列表，并且分组应为基于{VenueId，TimePeriodId}对。任何想法表示赞赏。

public class BookedRoom
{       
    public int VenueId { get; set;}        
    public int TimePeriodId { get; set; }        
    public DateTime Day { get; set; }        
}

 public class EventSetup
 {
    public int VenueId { get; set; }        
    public int TimePeriodId { get; set; }        
    public DateTime StartDate { get; set; }
    public DateTime EndDate { get; set; }       
 }

List<BookedRoom> bookedRooms = new List<BookedRoom>(){
            new BookedRoom { VenueId = 1, TimePeriodId = 1, Day = new DateTime(2013, 9, 1)},
            new BookedRoom { VenueId = 1, TimePeriodId = 1, Day = new DateTime(2013, 9, 2)},
            new BookedRoom { VenueId = 2, TimePeriodId = 2, Day = new DateTime(2013, 9, 3)},
            new BookedRoom { VenueId = 1, TimePeriodId = 1, Day = new DateTime(2013, 9, 4)}
        };


        // Some Linq to process bookedRooms and obtain a list which I can use to do the following:

        List<EventSetup> setups = new List<EventSetup>()
        {
            new EventSetup{ VenueId =1, TimePeriodId = 1, StartDate=new DateTime(2013, 9, 1), EndDate = new DateTime(2013, 9, 2)},
            new EventSetup{ VenueId =2, TimePeriodId = 2, StartDate=new DateTime(2013, 9, 3), EndDate = new DateTime(2013, 9, 3)},
            new EventSetup{ VenueId =1, TimePeriodId = 1, StartDate=new DateTime(2013, 9, 4), EndDate = new DateTime(2013, 9, 4)}
        };

丹尼尔·希尔加斯（Daniel Hilgarth）

您可以使用GroupBy结合SelectMany并Aggregate为此：

var setups =
    bookedRooms.GroupBy(x => Tuple.Create(x.TimePeriodId, x.VenueId))
               .SelectMany(x => x.Aggregate(
                                    new List<EventSetup>(), AccumulateRooms))
               .OrderBy(x => x.StartDate)
               .ToList();

List<EventSetup> AccumulateRooms(List<EventSetup> existingSetups,
                                 BookedRoom currentRoom)
{
    var setup = existingSetups.LastOrDefault();
    if(setup == null || setup.EndDate.AddDays(1) != currentRoom.Day.Date)
    {
        setup = new EventSetup
        {
            VenueId = currentRoom.VenueId,
            TimePeriodId = currentRoom.TimePeriodId,
            StartDate = currentRoom.Day.Date,
        };
        existingSetups.Add(setup);
    }
    setup.EndDate = currentRoom.Day.Date;
    return existingSetups;
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。