linq日期查询

最新推荐文章于 2024-06-28 08:00:00 发布

weixin_33985679

最新推荐文章于 2024-06-28 08:00:00 发布

阅读量235

点赞数

原文链接：http://www.cnblogs.com/leebokeyuan/p/6092967.html

版权

            //获取当天的数据
            DrawRecordDA _recordDA = new DrawRecordDA();
            var query = _recordDA.GetQuery();

            //筛选 当天
            //query = query.Where(q=>SqlFunctions.DateDiff("day",q.AddTime,DateTime.Now)==0);

            //筛选 当天
            //  query = query.Where(q=>q.AddTime.Day==DateTime.Now.Day);
            //筛选 本周
            query = query.Where(q => SqlFunctions.DateDiff("week", q.AddTime, DateTime.Now) == 0);

            Console.WriteLine(query.Count());