<?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="EntryDetailAddQuery">
|
<![CDATA[
|
|
SELECT
|
bbbp_sn,cgpd_id,cged_id,bbpr_id,bbpr_name,bbpr_sn,bbpr_style,cgpd_scan_size cgpd_size,
|
cgpd_entry_size, cged_remark, cged_size, cgpd_scan_size, cgpr_bbbp_id cgen_bbbp_id, bbbp_name
|
FROM
|
cg_procure
|
LEFT JOIN cg_procure_detail ON cgpd_cgpr_id = cgpr_id
|
LEFT JOIN cg_entry_detail ON cged_cgpd_id = cgpd_id
|
left join bb_product on cgpd_bbpr_id=bbpr_id
|
left join bb_business_partner on bbbp_id=cgpr_bbbp_id
|
where 1=1
|
and cgpd_finish_state<>'完成'
|
and cgpd_scan_size > 0
|
<<and cgpr_bbbp_id=:bbbpId>>
|
<<and cgpd_locationid=:locationid>>
|
<<and cgpr_locationid=:locationid>>
|
<<and (cged_locationid=:locationid or cged_locationid is null)>>
|
<<and bbpr_locationid=:locationid>>
|
and ##CONDITIONS##
|
order by bbbp_name, bbbp_id, bbpr_name
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
