本文整理汇总了C#中Service.List.Sum方法的典型用法代码示例。如果您正苦于以下问题:C# List.Sum方法的具体用法?C# List.Sum怎么用?C# List.Sum使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Service.List
的用法示例。
在下文中一共展示了List.Sum方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetTime
/// <summary>
/// Gets the total time spended on TS3 for specified client.
/// </summary>
/// <param name="clientDatabaseId">The client database id.</param>
/// <param name="fromTime">From time.</param>
/// <param name="toTime">To time.</param>
/// <returns></returns>
public double GetTime(uint clientDatabaseId, DateTime? fromTime, DateTime? toTime)
{
lock (Container.lockTimeClientList)
{
lock (Repository.Container.lockDatabase)
{
var times = new List<TimeClientEntity>();
using (var command = new SQLiteCommand(this.Container.DatabaseConnection))
{
command.CommandText = string.Format("SELECT ClientDatabaseId, Joined, Disconnected, TotalMinutes FROM Time WHERE ClientDatabaseId = {0}", clientDatabaseId);
if (fromTime.HasValue) command.CommandText += string.Format(" AND Disconnected > {0}", fromTime.Value.ToTimeStamp());
if (toTime.HasValue) command.CommandText += string.Format(" AND Joined < {0}", toTime.Value.ToTimeStamp());
using (var reader = command.ExecuteReader())
{
while (reader.HasRows && reader.Read())
{
times.Add(new TimeClientEntity
{
User = (uint)reader.GetInt32(0),
Joined = reader.GetInt32(1).ToDateTime(),
Disconnected = reader.GetInt32(2).ToDateTime(),
TotalMinutes = reader.GetInt32(3)
});
}
}
}
return times.Sum(m => m.GetTime(fromTime, toTime));
}
}
}