<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.dxhy.core.job.dao.TDxVehicleSaleInvoiceDao">

    <insert id="insertInvoice" parameterType="com.dxhy.core.job.entity.TDxVehicleSaleInvoice" databaseId="mysql">
        insert into t_dx_vehicle_sale_invoice (uuid,
                                               buyer_id_num,
                                               vehicle_type,
                                               factory_model,
                                               product_place,
                                               certificate,
                                               certificate_import,
                                               inspection_num,
                                               engine_no,
                                               vehicle_no,
                                               phone,
                                               buyer_bank,
                                               tax_rate,
                                               tax_bureau_name,
                                               tax_bureau_code,
                                               tax_records,
                                               limit_people,
                                               tonnage,
                                               create_date)
        values (#{tDxVehicleSaleInvoice.uuid},
                #{tDxVehicleSaleInvoice.buyerIdNum},
                #{tDxVehicleSaleInvoice.vehicleType},
                #{tDxVehicleSaleInvoice.factoryModel},
                #{tDxVehicleSaleInvoice.productPlace},
                #{tDxVehicleSaleInvoice.certificate},
                #{tDxVehicleSaleInvoice.certificateImport},
                #{tDxVehicleSaleInvoice.inspectionNum},
                #{tDxVehicleSaleInvoice.engineNo},
                #{tDxVehicleSaleInvoice.vehicleNo},
                #{tDxVehicleSaleInvoice.phone},
                #{tDxVehicleSaleInvoice.buyerBank},
                #{tDxVehicleSaleInvoice.taxRate},
                #{tDxVehicleSaleInvoice.taxBureauName},
                #{tDxVehicleSaleInvoice.taxBureauCode},
                #{tDxVehicleSaleInvoice.taxRecords},
                #{tDxVehicleSaleInvoice.limitPeople},
                #{tDxVehicleSaleInvoice.tonnage},
                now())

    </insert>

    <insert id="insertInvoice" parameterType="com.dxhy.core.job.entity.TDxVehicleSaleInvoice" databaseId="oracle">
        insert into t_dx_vehicle_sale_invoice (uuid,
                                               buyer_id_num,
                                               vehicle_type,
                                               factory_model,
                                               product_place,
                                               certificate,
                                               certificate_import,
                                               inspection_num,
                                               engine_no,
                                               vehicle_no,
                                               phone,
                                               buyer_bank,
                                               tax_rate,
                                               tax_bureau_name,
                                               tax_bureau_code,
                                               tax_records,
                                               limit_people,
                                               tonnage,
                                               create_date)
        values (#{tDxVehicleSaleInvoice.uuid},
                #{tDxVehicleSaleInvoice.buyerIdNum},
                #{tDxVehicleSaleInvoice.vehicleType},
                #{tDxVehicleSaleInvoice.factoryModel},
                #{tDxVehicleSaleInvoice.productPlace},
                #{tDxVehicleSaleInvoice.certificate},
                #{tDxVehicleSaleInvoice.certificateImport},
                #{tDxVehicleSaleInvoice.inspectionNum},
                #{tDxVehicleSaleInvoice.engineNo},
                #{tDxVehicleSaleInvoice.vehicleNo},
                #{tDxVehicleSaleInvoice.phone},
                #{tDxVehicleSaleInvoice.buyerBank},
                #{tDxVehicleSaleInvoice.taxRate},
                #{tDxVehicleSaleInvoice.taxBureauName},
                #{tDxVehicleSaleInvoice.taxBureauCode},
                #{tDxVehicleSaleInvoice.taxRecords},
                #{tDxVehicleSaleInvoice.limitPeople},
                #{tDxVehicleSaleInvoice.tonnage},
                sysdate)

    </insert>
</mapper>
