<!-- 新增采购单-->
<insert id="savePurchaseOrder" parameterType="pd">
<selectKey resultType="int" order="AFTER" keyProperty="pur_id">
select LAST_INSERT_ID()
</selectKey>
insert into
busi_purchase_order_info
(
pur_order_no,
garage_id,
sup_id,
pur_handler,
pur_total_price,
pur_bz,
create_name,
create_datetime,
modify_name,
modify_datetime
) values (
#{pur_order_no},
#{garage_id},
#{sup_id},
#{pur_handler},
#{pur_total_price},
#{pur_bz},
#{create_name},
#{create_datetime},
#{modify_name},
#{modify_datetime}
)
</insert>
<insert id="savePurchaseOrder" parameterType="pd">
<selectKey resultType="int" order="AFTER" keyProperty="pur_id">
select LAST_INSERT_ID()
</selectKey>
insert into
busi_purchase_order_info
(
pur_order_no,
garage_id,
sup_id,
pur_handler,
pur_total_price,
pur_bz,
create_name,
create_datetime,
modify_name,
modify_datetime
) values (
#{pur_order_no},
#{garage_id},
#{sup_id},
#{pur_handler},
#{pur_total_price},
#{pur_bz},
#{create_name},
#{create_datetime},
#{modify_name},
#{modify_datetime}
)
</insert>