526互联

MyBatis方法入参打@Param后，xml中的取值方式

发布时间 2023-12-18 17:43:23作者: JaxYoun
/**
* 分页查询对账结果
*
* @param page
* @param requestBO
* @return
*/
Page<ReconcileDetailResultPageBO> pageDetailSettleDataAndResult(IPage<ReconcileDetailResultPageBO> page, @Param("requestBO") ReconcileDetailResultPageRequestBO requestBO);

WHERE
    a.is_deleted = 0
    and a.medicare_settle_time >= #{requestBO.startTime}
    and #{requestBO.endTime} >= a.medicare_settle_time
    <if test="requestBO.handlingAgency != null and requestBO.handlingAgency != ''">
        and a.clear_optins = #{requestBO.handlingAgency}
    </if>
    <if test="requestBO.clearTypeCode != null and requestBO.clearTypeCode != ''">
        and a.clear_type = #{requestBO.clearTypeCode}
    </if>
    <if test="requestBO.insuranceTypeCode != null and requestBO.insuranceTypeCode != ''">
        and a.insured_type = #{requestBO.insuranceTypeCode}
    </if>
    <if test="requestBO.reconcileResult != null and requestBO.reconcileResult != ''">
        and b.result_code = #{requestBO.reconcileResult}
    </if>