linq比较日期的方式

来源:互联网 发布:平安科技待遇 知乎 编辑:程序博客网 时间:2024/06/07 16:49
public int GetCountByBirthDay(DateTime dt, int age)
        {


            if (age == 3)
            {
                var babys = from s in db.AdsBabys
                            where (dt.Year - s.BabyBirthday.Value.Year <= age)
                            select s;
                return babys.Count();

            }
            else if (age == 12)
            {
                var babys = from s in db.AdsBabys
                            where (dt.Year - s.BabyBirthday.Value.Year >= age)
                            select s;
                return babys.Count();

            }
            else
            {
                var babys = from s in db.AdsBabys
                            where (dt.Year - s.BabyBirthday.Value.Year == age)
                            select s;
                return babys.Count();
            }
        }
原创粉丝点击