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>
|
|