我有一个Item
课
public class Item {
//...
public DateTime CreateDate { get; set; }
public DateTime EndDate { get; set; }
}
在一种方法中,我有
List<Item> items
。与遍历列表相比,我如何更简洁地查询平均日期差异?double days = 0;
int total = 0;
foreach (var @t in results)
{
if (@t.EndDate != null)
{
total++;
TimeSpan ts = (TimeSpan)(@t.EndDate - @t.CreateDate);
days = ts.TotalDays;
}
}
double avg = days / total;
最佳答案
var avg = results.Average( x => (x.EndDate - x.CreateDate).TotalDays );
筛选出空
EndDate
值并假定CreateDate不是DateTime?
类型的版本:var avg = results.Where( x=> x.EndDate.HasValue)
.Average( x => (x.EndDate.Value - x.CreateDate).TotalDays );
编辑
要求以
dd:HH:ss
的格式设置持续时间。为此,我们应该平均总毫秒数(或秒),然后执行以下操作:var avg = results.Where(x=> x.EndDate.HasValue && x.CreateDate.HasValue)
.Average( x => (x.EndDate.Value - x.CreateDate.Value).TotalMilliseconds );
var fancyOutput = TimeSpan.FromMilliseconds( avg );
Response.Write( fancyOutput.ToString() );
TimeSpan.ToString()