| | |
| | | <insert id="insertInvoiceDetailBatch" parameterType="java.util.List" useGeneratedKeys="true" keyProperty="id"> |
| | | insert into invoice_detail |
| | | <trim prefix="(" suffix=") values" suffixOverrides=","> |
| | | id,invoice_manage_id,receivable_bill_no,receivable_bill_amount,receivable_bill_currency,billed_amount,unbilled_amount,current_billed_amount,create_time,update_time,deleted, |
| | | invoice_manage_id,receivable_bill_no,receivable_bill_amount,receivable_bill_currency,billed_amount,unbilled_amount,current_billed_amount,create_time,update_time,deleted, |
| | | </trim> |
| | | <foreach item="item" index="index" collection="list" separator=","> |
| | | <trim prefix="(" suffix=") " suffixOverrides=","> |
| | | #{item.id},#{item.invoiceManageId},#{item.receivableBillNo},#{item.receivableBillAmount},#{item.receivableBillCurrency},#{item.billedAmount},#{item.unbilledAmount},#{item.currentBilledAmount},#{item.createTime},#{item.updateTime},#{item.deleted}, |
| | | #{item.invoiceManageId},#{item.receivableBillNo},#{item.receivableBillAmount},#{item.receivableBillCurrency},#{item.billedAmount},#{item.unbilledAmount},#{item.currentBilledAmount},#{item.createTime},#{item.updateTime},#{item.deleted}, |
| | | </trim> |
| | | </foreach> |
| | | </insert> |