history init

liuxiaolong

2019-05-09 0d1d88cdb668e75ea8609417ac18ae19947e9525

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<?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,cged_size
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>