Question

I have a List where UserObj has a DateTime data member and a string Name member. I want to find the UserObj in the list with given Name InputName and with DateTime closest to an input DateTime InputDT

名称和日期可能同时发生,但将有一个独特的解决办法。

我认为:

UserObj user = userObjList.Where(u => ((u.Name ==inputName) && (userObjList.Min())).ToList()[0];

但不能确定如何规定最低条件?

Answer 1

两个日期之间的绝对差别使得这两个日期分开,然后是第一个。

UserObj user = userObjList
    .Where(u => u.Name == inputName)
    .OrderBy(u => Math.Abs((u.Date - inputDT).TotalSeconds))
    .First();

http://code.google.com/p/morelinq/source/browse/trunk/MoreLinq/MinBy.cs?r=83”rel=“nofollow” 延长:

UserObj user = userObjList
    .Where(u => u.Name == inputName)
    .MinBy(u => Math.Abs((u.Date - inputDT).TotalSeconds));

Answer 2

我认为,以下工作虽然没有经过测试......

var validUserObjs = userObjList.Where(u => u.Name ==inputName);
double mintime = validUserObjs.Min(u=>Math.Abs((u.Date-inputDate).TotalSeconds));
var result = validUserObjs.First(u=>Math.Abs((u.Date-inputDate).TotalSeconds)==mintime);

想法是首先让用户获得有效的用户。然后,委员会发现,最接近的日期是投入日期。然后,委员会利用这一时间差异确定具体项目。

Its a lot messier than that given one with order by but it should be O(N) to do it (one pass through the list to find the minimum and then a second pass to get that item). It may need some minor tweaking for errors in my code but the idea is sound. :)

友情链接