我查看了一些orderby示例,但是我仍然对最好的linq表达式感到困惑,这些表达式可以对代码中的程序集进行排序以生成此列表:
Level Parent Child
1 L010057501U 231-100-002
1 L010057501U 307-355-022
2 307-355-022 307-355-058
3 307-355-058 355-100-008
3 307-355-058 357-200-002
2 307-355-022 307-355-059
3 307-355-059 355-200-005
3 307-355-059 357-100-002
结果需要按级别排序,但是子级需要紧接在父级之后,再列出下一个父级。组件的组件可能有多个层次。我希望我已经充分解释了。
class Program
{
static void Main(string[] args)
{
SortAssembly();
Console.ReadLine();
}
class Assembly
{
public int Level { get; set; }
public string Parent { get; set; }
public string Component { get; set; }
}
private static void SortAssembly()
{
Assembly[] assemblies = {
new Assembly { Level=1, Parent="L010057501U", Component="231-100-002" },
new Assembly { Level=1, Parent="L010057501U", Component="307-355-022" },
new Assembly { Level=2, Parent="307-355-022", Component="307-355-058" },
new Assembly { Level=2, Parent="307-355-022", Component="307-355-059" },
new Assembly { Level=3, Parent="307-355-058", Component="355-100-008" },
new Assembly { Level=3, Parent="307-355-059", Component="355-200-005" },
new Assembly { Level=3, Parent="307-355-059", Component="357-100-002" },
new Assembly { Level=3, Parent="307-355-058", Component="357-200-002" }
};
var query = ???
foreach (var part in query)
{
Console.WriteLine("{0} - {1} - {2}", part.Level, part.Parent, part.Component);
}
}
}
1-L010057501U-231-100-002
1-L010057501U-307-355-022
____2-307-355-022-307-355-058
________3-307-355-058-355-100-008
________3-307-355-058-357-200-002
____2-307-355-022-307-355-059
________3-307-355-059-355-200-005
________3-307-355-059-357-100-002
我尝试实现IComparable,但我没有掌握。仍然需要帮助。
最佳答案
您可以尝试以下
using System;
using System.Linq;
public class Assembly
{
public int Level { get; set; }
public string Parent { get; set; }
public string Component { get; set; }
public bool Visited{get;set;} // to track visited levels
}
public class Program
{
public static void Main()
{
Assembly[] assemblies = {
new Assembly { Level=1, Parent="L010057501U", Component="231-100-002" },
new Assembly { Level=1, Parent="L010057501U", Component="307-355-022" },
new Assembly { Level=2, Parent="307-355-022", Component="307-355-058" },
new Assembly { Level=2, Parent="307-355-022", Component="307-355-059" },
new Assembly { Level=3, Parent="307-355-058", Component="355-100-008" },
new Assembly { Level=3, Parent="307-355-059", Component="355-200-005" },
new Assembly { Level=3, Parent="307-355-059", Component="357-100-002" },
new Assembly { Level=3, Parent="307-355-058", Component="357-200-002" }
};
DisplayAssemblies(assemblies);
}
private static void DisplayAssemblies(Assembly[] data)
{
// order the data to be sorted by levels
var levels=data.OrderBy(t=>t.Level);
foreach(var level in levels)
if(!level.Visited)
DisplayLevel(level,data);
}
private static void DisplayLevel(Assembly level, Assembly[] data)
{
var childs=data.Where(t=>t.Parent==level.Component).ToArray();
Console.WriteLine("{0} - {1} - {2}", level.Level, level.Parent, level.Component);
level.Visited=true;
foreach(var child in childs)
{
DisplayLevel(child,data);
}
}
}
输出:
1 - L010057501U - 231-100-002
1 - L010057501U - 307-355-022
2 - 307-355-022 - 307-355-058
3 - 307-355-058 - 355-100-008
3 - 307-355-058 - 357-200-002
2 - 307-355-022 - 307-355-059
3 - 307-355-059 - 355-200-005
3 - 307-355-059 - 357-100-002
这是Live DEMO
希望能帮到你
关于c# - Linq查询到orderby级别然后是父项和子项,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/26952205/