Linq按日期年月日分组

最新推荐文章于 2024-11-15 14:13:40 发布

.NET跨平台

最新推荐文章于 2024-11-15 14:13:40 发布

阅读量482

点赞数

分类专栏： LINQ|表达式树文章标签： linq c#

原文链接：https://blog.youkuaiyun.com/WuLex

版权

LINQ|表达式树专栏收录该内容

96 篇文章

订阅专栏

　　　　　　
var body = _db.tbl_worklist.AsQueryable();

WorkOrderHomePageResponse model = new WorkOrderHomePageResponse();

DateTime startDate = DateTime.Parse(DateTime.Now.AddDays( - 6).ToString("yyyy-MM-dd 00:00:00"));
DateTime endDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59"));

body = body.Where(w =>w.Createtime >= startDate && w.Createtime <= endDate);

var submitList = from o in body
orderby o.Createtime ascending
group o by new {
  time = new {
    o.Createtime.Year,
    o.Createtime.Month, o.Createtime.Day
  }
}
into g
select new SubmitModel {
  Count = g.Count(),
  InDate = g.Key.time.Year + "-" + g.Key.time.Month + "-" + g.Key.time.Day
};

model.submit = submitList.ToList();