如何根据LoanPayment参数计算生成各期LoanPaymentDetail的还款到期日

架构老林

2026-9-23

实现方案

C# 内置的 DateTime.AddMonths 方法已经天然满足你需要的月末适配规则：当目标月份不存在对应日期时，会自动返回当月最后一天，完全匹配你的业务需求。

你只需要先根据还款频率确定每期需要累加的月份步长，再在循环中对应计算即可，同时建议优化循环内重复保存的逻辑，提升性能并保证事务一致性。

修改后完整代码：

public async Task<LoanPayment> AddLoanPayment(LoanPaymentCreateDto loanPaymentCreateDto)
{
    var mapper = new EntityMapper();
    var loanPayment = mapper.FromLoanPaymentDtoToPayment(loanPaymentCreateDto);
    await _unitOfWork.LoanPaymentRepository.Insert(loanPayment);
    // 保存LoanPayment主记录
    await _unitOfWork.SaveChangesAsync();

    // 确定还款频率对应的月份累加步长
    int addMonthStep = loanPayment.PaymentFrequency switch
    {
        1 => 1,  // 月度：每期加1个月
        2 => 3,  // 季度：每期加3个月
        3 => 12, // 年度：每期加12个月
        _ => throw new ArgumentOutOfRangeException(nameof(loanPayment.PaymentFrequency), "不支持的还款频率")
    };

    // 循环生成LoanPaymentDetail明细记录
    for (int i = 1; i <= loanPayment.PaymentCount; i++)
    {
        var loanPaymentDetail = new LoanPaymentDetail();
        loanPaymentDetail.LoanPaymentId = loanPayment.Id;
        // 计算当期到期日，i=1时为首期到期日
        loanPaymentDetail.DueDate = loanPayment.DueDate.AddMonths((i - 1) * addMonthStep);
        loanPaymentDetail.AmountPayable = loanPayment.Amount / loanPayment.PaymentCount;
        await _unitOfWork.LoanPaymentDetailRepository.Insert(loanPaymentDetail);
    }

    // 所有明细生成完成后统一保存，保证事务一致性
    await _unitOfWork.SaveChangesAsync();
    return loanPayment;
}