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
<?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="ProcureListQuery">
        <![CDATA[
 
SELECT
    cgpr_id,cgpr_sn,'' syde_name,bbbp_name,bbpr_sn,bbpr_name,cgpd_size,cgpd_entry_size,cgpd_price*cgpd_entry_size cgpd_subtotal,cgpr_order_date,cgpd_finish_state
FROM
    cg_procure
LEFT JOIN cg_procure_detail ON cgpr_id = cgpd_cgpr_id
left join bb_business_partner on cgpd_bbbp_id=bbbp_id
left join bb_product on cgpd_bbpr_id=bbpr_id
WHERE
    1 = 1
   and ##CONDITIONS##
 
        ]]>
    </sql-query>
</hibernate-mapping>