统计30天内,每天的数据量,如果某天没有数据显示时间,数量自动补充0

当某天没有数据时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();

图片说明

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();