C# entity-framework entity-framework-core

获取不在两个日期范围之间的记录（开始和结束）

发布于 2025-02-09 21:29:02 字数 702 浏览 3 评论 0原文

我有一个收集列表，其中最后付款是一个字段。我想在给定的开始日期和结束日期内使用付费和未付款过滤日期。

我所取得的成就是通过

var filterDate = paymentData
    .Where(value => value.district != null && (Convert.ToDateTime(value.last_payment_date) >=
        Convert.ToDateTime(startdate) && Convert.ToDateTime(value.last_payment_date) < Convert.ToDateTime(enddate))
    ).ToList();

上述代码获得所有付费客户的开始日期和结束日期，将过滤，并给我所有在 start 和 EndDate 中付费的客户。

但是，我的挑战是获得反向，这使所有未在开始和 enddate 中获得的客户。

我可以在linq中使用不表达吗？如何调整代码以使我相反？

原文

I have a collection list with Lastpayment as a field. Using a date picker i want to filter by Paid and not paid within a given start date and end date.

what i have achieved is getting All paid customers with a start date and end date using

var filterDate = paymentData
    .Where(value => value.district != null && (Convert.ToDateTime(value.last_payment_date) >=
        Convert.ToDateTime(startdate) && Convert.ToDateTime(value.last_payment_date) < Convert.ToDateTime(enddate))
    ).ToList();

the above code will filter and give me all customers that have paid within a start and enddate.

However, my challenge is getting the Reverse which is getting all customers that have NOT PAID within a start and enddate.

Can i use a NOT IN expression in LINQ?. How can i adjust my code to give me the reverse ?

分享到QQ

分享到微博