查询对象列表
本文关键字:列表 对象 查询 | 更新日期: 2023-09-27 18:04:41
我目前有一个"Day"对象列表。Day的类定义包含两个字符串:- name小时
我需要做的是在列表中找到所有具有相同小时数的日子,并将它们格式化为一个项目。
交货。
Sunday 8am - 9pm
Monday 8am - 10pm
Tuesday 8am - 10pm
Wednesday 8am -10pm
Thursday 9am - 10pm
Friday 9am - 11pm
Saturday 8am - 11pm
所以,星期一、星期二和星期三都有相同的时间。我需要在原来的基础上创建一个新的列表,看起来像这样:
Sunday 8am - 9pm
Mon-Wed 8am -10 pm
...
...
有一个简单的方法做到这一点与LINQ?
使用GroupConsecutive
扩展方法,您将在答案末尾找到该方法,您可以执行以下操作:
List<Day> days = new List<Day>
{
new Day { Name = "Sunday", Hours= "8am - 9pm" },
new Day { Name = "Monday", Hours= "8am - 10pm" },
new Day { Name = "Tuesday", Hours= "8am - 10pm" },
new Day { Name = "Wednesday", Hours= "8am - 10pm" },
new Day { Name = "Thursday", Hours= "9am - 10pm" },
new Day { Name = "Friday", Hours= "8am - 11pm" },
new Day { Name = "Saturday", Hours= "8am - 11pm" },
};
var query = from g in days.GroupConsequtive(d => d.Hours)
select new {
Name = g.Count() == 1 ? g.First().Name :
String.Format("{0}-{1}", g.First().Name.Substring(0, 3), g.Last().Name.Substring(0, 3)),
Hours = g.Key
};
列举结果:
foreach (var item in query)
Console.WriteLine("{0} {1}", item.Name, item.Hours);
输出:Sunday 8am - 9pm
Mon-Wed 8am - 10pm
Thursday 9am - 10pm
Fri-Sat 8am - 11pm
连续分组的扩展方法:
public static class LazyExtensions
{
public static IEnumerable<IGrouping<TKey, TElement>> GroupConsecutive<TKey, TElement>(
this IEnumerable<TElement> source, Func<TElement, TKey> keySelector)
{
if (!source.Any())
yield break;
var comparer = Comparer<TKey>.Default;
Grouping<TKey, TElement> group = null;
foreach (var item in source)
{
var key = keySelector(item);
if (group == null)
group = new Grouping<TKey, TElement>(key);
if (comparer.Compare(group.Key, key) != 0)
{
yield return group;
group = new Grouping<TKey, TElement>(key);
}
group.Elements.Add(item);
}
yield return group;
}
private class Grouping<TKey, TElement> : IGrouping<TKey, TElement>
{
public Grouping(TKey key)
{
Key = key;
Elements = new List<TElement>();
}
public List<TElement> Elements { get; private set; }
public TKey Key { get; private set; }
public IEnumerator<TElement> GetEnumerator()
{
return Elements.GetEnumerator();
}
IEnumerator IEnumerable.GetEnumerator()
{
return GetEnumerator();
}
}
}
它是如何工作的?它创建分组(自定义类,实现IGrouping接口)并将具有相同键值的连续元素添加到该组中。如果到达新的键值,则返回分组。因此,所有序列按连续的键值分组。
这很接近你想要的:
IList<Day> days = new List<Day>();
days.Add(new Day { Name = "Sunday", Hours = "8am - 9pm" });
days.Add(new Day { Name = "Monday", Hours = "8am - 10pm" });
days.Add(new Day { Name = "Tuesday", Hours = "8am - 10pm" });
days.Add(new Day { Name = "Wednesday", Hours = "8am - 10pm" });
days.Add(new Day { Name = "Thursday", Hours = "9am - 10pm" });
days.Add(new Day { Name = "Friday", Hours = "9am - 11pm" });
days.Add(new Day { Name = "Saturday", Hours = "8am - 11pm" });
var grouped = days.GroupBy(d => d.Hours).ToList();
StringBuilder sb = new StringBuilder();
foreach (var group in grouped)
{
sb.AppendFormat("{0}: {1}'n", group.Key, group.Select(g => g.Name).Aggregate((list, nextday) => list + ", " + nextday));
}
var table = sb.ToString();
输出为:
上午8点至晚上9点:周日
上午8点至晚上10点:星期一、二、三
上午9点至晚上10点:星期四
周五上午9点至晚上11点
List<Tuple<string,string>> days = new List<Tuple<string,string>>
(
new Tuple<string,string>[]
{
new Tuple<string,string>( "Sunday", "8am - 9pm" ),
new Tuple<string,string>( "Monday", "8am - 10pm" ),
new Tuple<string,string>( "Tuesday", "8am - 10pm" ),
new Tuple<string,string>( "Wednesday", "8am - 10pm" ),
new Tuple<string,string>( "Thursday ", "9am - 10pm" ),
new Tuple<string,string>( "Friday", "9am - 11pm" ),
new Tuple<string,string>( "Saturday ", "8am - 11pm" )
}
);
ILookup<string,string> table = days.ToLookup( k => k.Item2, v => v.Item1 );
table[ "8am - 9pm" ]; // Sunday
table[ "8am - 10pm" ]; // Monday, Tuesday, Wednesday