<?xml version="1.0"?>
|
<!DOCTYPE hibernate-mapping PUBLIC
|
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
|
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
|
|
<hibernate-mapping>
|
<sql-query name="RefOrderProductEntrySetDeliverIdUpdate">
|
<![CDATA[
|
|
update
|
ref_order_product_entry
|
set
|
reop_iodd_id=:deliverId
|
where 1=1
|
<<and reop_id in(:reopIds) >>
|
<<and reop_iodd_id=:clearDeliverId >>
|
<<and reop_prod_id=:prodId and reop_iodd_id is null >>
|
and ##CONDITIONS##
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
