请问两个list数组的比较以及排序

[caicoko]

List<dynamic> list1 = new List<dynamic>();
list1.Add(new { id = "1", num = 11, time = "2015-10-10 10:10:10" });
list1.Add(new { id = "2", num = 22, time = "2015-10-10 11:11:11" });
list1.Add(new { id = "3", num = 33, time = "2015-10-10 12:12:12" });
List<dynamic> list2 = new List<dynamic>();
list2.Add(new { id = "11", num = 18, time = "2015-10-10 10:10:10" });
list2.Add(new { id = "21", num = 10, time = "2015-10-10 11:11:11" });
list2.Add(new { id = "3", num = 55, time = "2015-10-10 12:12:12" });

有上面2个数组，以两个数组的时间相等，判断出2个num值偏差比较大的那条数据，如上列2列要返回 list1.Add(new { id = "3", num = 33, time = "2015-10-10 12:12:12" });


linq的方法如何实现，或者有其他更好的方法也可以。

[娃都会打酱油了]

List<dynamic> list1 = new List<dynamic>();
list1.Add(new { id = "1", num = 11, time = "2015-10-10 10:10:10" });
list1.Add(new { id = "2", num = 22, time = "2015-10-10 11:11:11" });
list1.Add(new { id = "3", num = 33, time = "2015-10-10 12:12:12" });
List<dynamic> list2 = new List<dynamic>();
list2.Add(new { id = "11", num = 18, time = "2015-10-10 10:10:10" });
list2.Add(new { id = "21", num = 10, time = "2015-10-10 11:11:11" });
list2.Add(new { id = "3", num = 55, time = "2015-10-10 12:12:12" });

var query = (from l1 in list1
                join l2 in list2 on l1.time equals l2.time
                orderby Math.Abs(l1.num - l2.num) descending
                select l1).First();
Console.WriteLine(query.id + " " + query.num);

[q107770540]

  list1.Add(new { id = "1", num = 11, time = "2015-10-10 10:10:10" });
            list1.Add(new { id = "2", num = 22, time = "2015-10-10 11:11:11" });
            list1.Add(new { id = "3", num = 33, time = "2015-10-10 12:12:12" });

            List<dynamic> list2 = new List<dynamic>();
            list2.Add(new { id = "11", num = 18, time = "2015-10-10 10:10:10" });
            list2.Add(new { id = "21", num = 10, time = "2015-10-10 11:11:11" });
            list2.Add(new { id = "3", num = 55, time = "2015-10-10 12:12:12" });

            var query = from x in list1
                        join y in list2 on x.time equals y.time
                        orderby y.num - x.num descending
                        select y;

            if(query.Any())
                Console.WriteLine(query.First().id);

            Console.ReadKey();

[ajianchina]

随楼主挑一个吧

var query = list1.Join(list2, a => a.time, b => b.time, (a, b) => new
{
	x = Math.Abs(a.num - b.num),
	a
}).OrderBy(p => p.x);

if (query.Any()) Console.WriteLine(query.LastOrDefault().a);

[ajianchina]

上面代码中的LastOrDefault换成Last 或者这样子吧，也一样

var query = list1.Join(list2, a => a.time, b => b.time, (a, b) => new
{
	x = Math.Abs(a.num - b.num),
	a
}).OrderBy(p => p.x).LastOrDefault();

if (query != null) Console.WriteLine(query.a);

[q107770540]

这是不是个BUG？ 40分的帖子结出了45分。。。。