<?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
|
cgpd_id,cged_id,bbpr_id,bbpr_name,bbpr_sn,bbpr_style,cgpd_size,cgpd_entry_size,cged_remark
|
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
|
where 1=1
|
and cgpd_finish_state<>'完成'
|
<<and cgpd_bbbp_id=:bbbpId>>
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
