update dispatch.bill_monthly
set
`status` = #{bill.billPaymentStatus, typeHandler=org.apache.ibatis.type.EnumOrdinalTypeHandler},
`created_time` = #{bill.createdTime},
`amount` = #{bill.amount},
`count` = #{bill.count},
`bill_config` = #{bill.billConfig},
`is_ready` = #{bill.isReady}
where bill_id = #{bill.billId} and is_ready = '0'
INSERT INTO dispatch.bill_monthly (`bill_id`,`type`,`organization_id`,`month`)
(#{bill.billId},#{bill.billType, typeHandler=org.apache.ibatis.type.EnumOrdinalTypeHandler},#{bill.orgId},#{bill.month})
update dispatch.bill_monthly
set
`status` = #{bill.billPaymentStatus, typeHandler=org.apache.ibatis.type.EnumOrdinalTypeHandler},
`paid_time` = #{bill.paidTime},
`paid_amount` = #{bill.paidAmount}
where bill_id = #{bill.billId}