想在列表中找到重复时间跨度的重复项 [英] Want to find duplicates in list which have overlaps timespans
本文介绍了想在列表中找到重复时间跨度的重复项的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
public class MyRows
{
public string StartStop { get; set; }
public string EndStop { get; set; }
public TimeSpan StartTime { get; set; }
public TimeSpan EndTime { get; set; }
public string Day { get; set; }
}
List<MyRows> lmr = new List<MyRows>();
lmr.Add(new MyRows { StartStop = "a", EndStop = "b", StartTime = new TimeSpan(09, 00, 00), EndTime = new TimeSpan(11, 00, 00),Day=DayOfWeek.Sunday.ToString() });
lmr.Add(new MyRows { StartStop = "a", EndStop = "b", StartTime = new TimeSpan(09, 00, 00), EndTime = new TimeSpan(11, 00, 00), Day = DayOfWeek.Sunday.ToString() });
lmr.Add(new MyRows { StartStop = "a", EndStop = "b", StartTime = new TimeSpan(10, 00, 00), EndTime = new TimeSpan(12, 00, 00), Day = DayOfWeek.Tuesday.ToString() });
lmr.Add(new MyRows { StartStop = "a", EndStop = "b", StartTime = new TimeSpan(10, 30, 00), EndTime = new TimeSpan(12, 00, 00), Day = DayOfWeek.Sunday.ToString() });
lmr.Add(new MyRows { StartStop = "a", EndStop = "b", StartTime = new TimeSpan(09, 00, 00), EndTime = new TimeSpan(13, 00, 00), Day = DayOfWeek.Tuesday.ToString() });
lmr.Add(new MyRows { StartStop = "a", EndStop = "b", StartTime = new TimeSpan(09, 00, 00), EndTime = new TimeSpan(11, 00, 00), Day = DayOfWeek.Thursday.ToString() });
lmr.Add(new MyRows { StartStop = "a", EndStop = "b", StartTime = new TimeSpan(11, 00, 00), EndTime = new TimeSpan(12, 00, 00), Day = DayOfWeek.Thursday.ToString() });
我想根据StartStop,EndStop,StartTime,EndTime(相同的TimeSpans)和DayOfWeek查找重复项
I want to find duplicates on the basis of StartStop, EndStop, StartTime, EndTime (same TimeSpans) and DayOfWeek
例如,在上面的列表中
- 第一个对象与第二个和第四个对象重复(第四个bcoz 时间跨度重叠)
- 由于时间跨度重叠,第三对象与第五对象重复.
- 第六个对象与第七个对象没有重复,因为时间跨度不重叠,但日期相同.
- first object is duplicate with second and forth object (forth bcoz timespan overlapping)
- third object is duplicated with fifth object because of timespan overlapping.
- sixth object is not duplicated with seventh beacuse timespan are not overlapping but day is same.
推荐答案
在这里,您不会感到复杂,
Here you go without complication,
var result = lmr.Where(i => lmr.Any(o => YourCondition(i,o) && i != o));
//up to you
private bool YourCondition(MyRow i, MyRow o)
{
return i.StartTime >= o.StartTime && i.EndTime <= o.EndTime && i.Day == o.Day;
}
这篇关于想在列表中找到重复时间跨度的重复项的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文