<?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="PrOrderDetailByProrIdQuery">
|
<![CDATA[
|
|
select distinct a.prod_id,a.prod_did,a.prod_pror_id,a.prod_bbpr_id,a.prod_bbst_id,
|
a.prod_order_size,a.prod_task_size,a.prod_entry_size,a.prod_exit_size,
|
a.prod_price,a.prod_quantity,a.prod_sale_goods,a.prod_sale_type,
|
a.prod_flagp,a.prod_flags,a.prod_flagp_update,a.prod_flags_update,
|
a.prod_urgent,a.prod_flagt,a.prod_remark,
|
|
b.bbpr_name prod_bbpr_name,b.bbpr_style prod_bbpr_style,c.bbst_name prod_bbst_name,c.bbst_style prod_bbst_style,
|
f.sydi_name prod_sale_method
|
from
|
pr_order_detail a left join
|
bb_product b on a.prod_bbpr_id=b.bbpr_id left join
|
bb_stuff c on a.prod_bbst_id=c.bbst_id left join
|
pr_order e on e.pror_id=a.prod_pror_id left join
|
sys_dictionary f on f.sydi_id=e.pror_sydi_id
|
where 1=1
|
<<and a.prod_pror_id=:prodProrId>>
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
