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
25
26
27
28
29
30
31
32
<?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="MonthProductionDeliverQuery">
        <![CDATA[
 
 
select iodd_id,
iode_id,
bbpr_id,
iode_send_date,
bbpr_style,
bbpr_name,
iodd_cost_price,
iodd_size,
iodd_use_reject,
iodd_original_reject,
iodd_remark
 from io_deliver_detail 
left join io_deliver iode on iode_id=iodd_iode_id
left join bb_product on bbpr_id =iodd_bbpr_id
where iode_type='生产'
<<and iode_send_date >=:beginDate>>
<<and iode_send_date <=:endDate>>
<<and iode.factory_id in (:factoryIds)>>
 
        ]]>
    </sql-query>
</hibernate-mapping>