0x00 基础的数据格式
public class timekeyitem
{
public DateTime time { get; set; }
public Double Value { get; set; }
}
0x01 生成测试数据
List<timekeyitem> tvitems = new List<timekeyitem>();
Random random = new Random(Environment.TickCount);
DateTime datenow = DateTime.Now;
for (int i = 0; i < 5000; i++)
{
tvitems.Add(new timekeyitem() { time = datenow, Value = random.NextDouble() });
datenow = datenow.AddMinutes(1);
}
0x02 按固定周期聚合(每年、每月、每天、每时、每分、每秒)
每年聚合一次 formatstring = "yyyy-01-01 00:00:00"
每月聚合一次 formatstring = "yyyy-MM-01 00:00:00"
每日聚合一次 formatstring = "yyyy-MM-dd 00:00:00"
每时聚合一次 formatstring = "yyyy-MM-dd HH:00:00"
每分聚合一次 formatstring = "yyyy-MM-dd HH:mm:00"
每秒聚合一次 formatstring = "yyyy-MM-dd HH:mm:ss"
重点在 s.time.ToString(formatstring)
和 DateTime.Parse(g.Key)
String formatstring = "yyyy-MM-dd HH:00:00";
var groupitems = (from s in tvitems
//时间戳聚合
group s by s.time.ToString(formatstring) into g
select new
{
//时间戳转回时间格式
Time = DateTime.Parse(g.Key),
Max = g.Max(v => v.Value),
Min = g.Min(v => v.Value),
Avg = g.Average(v => v.Value),
}).ToList();
0x03 按间隔时间聚合(10分、20分、30分)
groupSpan用于设定聚合周期
如 聚合每10分钟的数据 groupSpan = new TimeSpan(0, 10, 0)
如 聚合每30分钟的数据groupSpan = new TimeSpan(0, 30, 0)
重点在 s.time.Ticks / groupSpan.Ticks
和 new DateTime(g.Key * groupSpan.Ticks)
TimeSpan groupSpan = new TimeSpan(0, 30, 0);
var groupitems = (from s in tvitems
//时间戳聚合
group s by s.time.Ticks / groupSpan.Ticks into g
select new
{
//时间戳转回时间格式
Time = new DateTime(g.Key * groupSpan.Ticks),
Max = g.Max(v => v.Value),
Min = g.Min(v => v.Value),
Avg = g.Average(v => v.Value),
}).ToList();
Console.WriteLine(groupitems);