<?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="PrOrderQuery">
|
<![CDATA[
|
|
select a.pror_id,a.pror_sn,b.bbbp_name pror_bbbp_name,a.pror_saler,a.pror_order_date,a.pror_send_date,
|
c.bbta_name pror_bbta_name,a.creator,d.sydi_name pror_sale_method,a.pror_remark,a.pror_bbbp_id
|
from pr_order a left join
|
bb_business_partner b on a.pror_bbbp_id=b.bbbp_id left join
|
bb_station c on a.pror_bbta_id=c.bbta_id left join
|
sys_dictionary d on a.pror_sydi_id=d.sydi_id
|
where 1=1
|
<<and a.pror_id=:prorId>>
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
