最近 6 笔付款

我需要从仅包含以下内容的模式中获取最后六笔付款

贡献 ID 到期日 数量

付款持续了 7 年，我只需要获取最新的最后六笔付款，我认为这会做到这一点，因为它遵循我的 sql

SELECT TOP 6 [ID]
  ,[customerInfo]
  ,[IVACODE]
  ,[Contribution]
  ,[DUE_DATE]
  ,[isActive]
  ,[isDeleted]
FROM [portal].[dbo].[tblPortalContributionSchedule]
where customerInfo='01F6B68B-6FC2-4F9D-B586-6934B8D6C979'
and DUE_DATE <='2016/09/26' 
ORDER BY DUE_DATE DESC

Linq版本

List<tblPortalContributionSchedule> _contributions 
    = portalEntities.tblPortalContributionSchedules
            .Where(a => a.customerInfo == _customerId 
                        && a.isDeleted == false 
                        && a.DUE_DATE <=Convert.ToDateTime("2016/09/26"))
            .Take(6)
            .OrderByDescending(o => o.DUE_DATE)
            .ToList();

foreach (var contribution in _contributions)
{

            AllPayments.Add(new Payments(contribution.ID, Convert.ToDecimal(contribution.Contribution), Convert.ToDateTime(contribution.DUE_DATE), false));

}

But its not producing the same results as per below

抱歉，我需要 linq 中的答案，我不需要的是正确的方法，我得到的比预期要少

Edit 1这是我到目前为止的查询，但我仍然没有得到与我的 sql 脚本相同的结果

 List<tblPortalContributionSchedule> _contributions = 
portalEntities.tblPortalContributionSchedules.Where(a => a.customerInfo == 
_customerId && a.isDeleted == false && a.DUE_DATE 
<=Convert.ToDateTime("2016/09/26")).OrderByDescending(o => 
o.DUE_DATE).Take(6).ToList();

Edit 2
显示我在视频中显示的代码

    public List<Payments> getAllPayments(Guid _customerId)

    {
        List<Payments> AllPayments = new List<Payments>();

        List<tblPortalPayment> _payments = portalEntities.tblPortalPayments.Where(a => a.CustomerId == _customerId && a.isDeleted == false).ToList();

        foreach (var payment in _payments)
        {
            AllPayments.Add(new Payments(payment.id, Convert.ToDecimal(payment.paymentDue), Convert.ToDateTime(payment.paymentDate), Convert.ToBoolean(payment.isinArrears)));

        }

  List<tblPortalContributionSchedule> _contributions = portalEntities.tblPortalContributionSchedules.Where(a => a.customerInfo == _customerId && a.isDeleted == false && a.DUE_DATE<= Convert.ToDateTime("2016/09/26")).OrderByDescending(o => o.DUE_DATE).Take(6).ToList();
        foreach (var contribution in _contributions)
        {

            AllPayments.Add(new Payments(contribution.ID, Convert.ToDecimal(contribution.Contribution), Convert.ToDateTime(contribution.DUE_DATE), false));

        }


        var result = AllPayments.OrderByDescending(o => o.paymentDate).ToList(); 

        return AllPayments.OrderByDescending(o => o.paymentDate).ToList();

    }      

您可以按照如下所示进行尝试，并让我们知道结果。

var dueDateFilter = new DateTime(2016, 09, 26);

List<tblPortalContributionSchedule> _contributions = 
    portalEntities.tblPortalContributionSchedules
        .Where(a => a.customerInfo == _customerId 
            && a.isDeleted == false 
            && a.DUE_DATE <= dueDateFilter)
        .OrderByDescending(o => o.DUE_DATE)
        .Take(6)
        .ToList();