1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
| <?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="CgProcureDetailQuery">
| <![CDATA[
|
| select
| bbbp.bbbp_id,
| bbbp.bbbp_name,
| bbs.bbst_name,
| bbs.bbst_style,
| cgpd.cgpd_bbst_id,
| cgpd.cgpd_id,
| cgpd.cgpd_did,
| cgpd.cgpd_amount,
| cgpd.cgpd_entry_amount,
| cgpd.cgpd_flag,
| cgpd.cgpd_remark,
| cgpd.cgpd_cgpr_id,
| cgp.cgpr_id,
| cgp.cgpr_sn,
| cgp.creator,
| cgp.create_time,
| cgp.cgpr_date,
| cgp.cgpr_require_date,
| bbs.bbst_type
| from cg_procure_detail cgpd
| left join cg_procure cgp on cgpd.cgpd_cgpr_id=cgp.cgpr_id
| left join bb_stuff bbs on cgpd.cgpd_bbst_id = bbs.bbst_id
| left join bb_business_partner bbbp on cgp.cgpr_bbbp_id = bbbp.bbbp_id
| where 1=1
| <<and bbbp_name= :bbbpName>>
| <<and bbst_name= :bbstName>>
| <<and cgpd_flag= :cgpdFlag>>
| <<and cgpd_flag != :notCgpdFlag>>
| <<and bbbp_id= :bbbpId>>
| <<and cgpr_id= :cgprId>>
| <<and cgpd.cgpd_id not in ( :cgpdIds)>>
| <<and cgpd.cgpd_cgpr_id in ( :cgpdCgprId)>>
| <<and cgpr_date>=:beginDate>>
| <<and cgpr_date<=:endDate>>
| and ##CONDITIONS##
| order by cgpd_id desc
|
| ]]>
| </sql-query>
| </hibernate-mapping>
|
|
