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
33
34
35
<?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="FindMonthSalaryForEditQuery">
        <![CDATA[
 
SELECT
    fims_id,
    fims_year_month,
    fims_total,
    fims_factory_id,
    fims_remark,
    fimd_id,
    fimd_fims_id,
    fimd_piece_work_money,
    fimd_remark,
    fimd_bbem_id,
    fimd_subtotal,
    fimd_other,
    fimd_leader_money,
    fimd_pick_flag
FROM
    fi_month_salary
LEFT JOIN fi_month_salary_detail ON fimd_fims_id = fims_id
where 1=1
and fims_factory_id=:fimsFactoryId
and fims_year_month=:fimsYearMonth
<<and fims_id=:fimsId>>
 
        ]]>
    </sql-query>
</hibernate-mapping>