linq带条件分组查询.

最新推荐文章于 2023-01-17 21:25:16 发布

s136735431

最新推荐文章于 2023-01-17 21:25:16 发布

阅读量1.9k

点赞数

分类专栏： LINQ 文章标签： linq string

本文链接：https://blog.csdn.net/s136735431/article/details/6833755

版权

LINQ 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

折腾了1个小时,终于把这个问题解决了,分享下.哈哈.......

先是获取上周的日期:

  string str = DateTime.Today.DayOfWeek.ToString().ToLower();

            DateTime endWeek = new DateTime();
            DateTime startWeek = new DateTime();

            switch (str)
            {
                case "monday":
                    endWeek = DateTime.Now.Date.AddDays(-1);
                    break;
                case "tuesday":
                    endWeek = DateTime.Now.Date.AddDays(-2);
                    break;
                case "wendesday":
                    endWeek = DateTime.Now.Date.AddDays(-3);
                    break;
                case "thursday":
                    endWeek = DateTime.Now.Date.AddDays(-4);
                    break;
                case "friday":
                    endWeek = DateTime.Now.Date.AddDays(-5);
                    break;
                case "saturday":
                    endWeek = DateTime.Now.Date.AddDays(-6);
                    break;
                case "sunday":
                    endWeek = DateTime.Now.Date.AddDays(-7);
                    break;
                default:
                    break;
            }
            startWeek = endWeek.Date.AddDays(-7);
            endWeek = Convert.ToDateTime(endWeek.ToShortDateString() + " 23:59:59");

然后LINQ语句分组查询,

       int value = (from a in context.Documents
                         where a.FillTime >= startTime & a.FillTime <= endTime
                         group a by a.UserID into b
                         orderby b.Count() descending
                         select b.Key).FirstOrDefault();

OK,完成了.呵呵