当某天没有数据时Total=0,Data为30内所有时间,这个不能添加上
请路过的大佬指教!!
var dt = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd 00:00");
var getMonthData = (from a in _cmsAccessService.GetPagedList(a => a.Deleted == false, 1, 10000).Result
where a.CreatedOn >= DateTime.Parse(dt) && a.CreatedOn < DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59"))
group a by a.CreatedOn.Date into g
select new
{
Date = g.Key,
Total = g.Count()
}).ToList();