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
51
| <?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="UserAdminQuery">
| <![CDATA[
|
|
| select u.syus_id,
| u.syus_real_name,
| u.syus_login_name,
| u.syus_password,
| u.syus_position,
| u.syus_sex,
| u.syus_mobile,
| u.syus_telphone,
| u.syus_email,
| u.syus_zhi_wu,
| u.syus_gong_hao,
| u.syus_locationid,
| u.syus_syde_id,
| u.syus_state,
| u.syus_login_count,
| u.syus_login_lasttime,
| u.syus_level,
| h.scmh_name,
| h.scmh_id
| from sys_user u
| LEFT JOIN scm_hospital h on u.syus_locationid = h.scmh_id
|
| WHERE 0=0
|
| <<and u.syus_level <= :syusLevel>>
| and syus_level <> 0
| <<and h.scmh_ids like concat('%',:scmhId,'%')>>
|
| << and u.syus_id = :syusId>>
| << and u.syus_sex = :syusSex>>
| << and u.syus_login_name like concat('%',:syusLoginName,'%')>>
| << and u.syus_real_name like concat('%',:syusRealName,'%')>>
| << and u.syus_mobile like concat('%',:syusMobile,'%')>>
| <<and u.syus_state =:syusState>>
| <<and (u.syus_login_name like concat('%',:adminInfo,'%')>>
| << or u.syus_real_name like concat('%',:adminInfo,'%') or u.syus_mobile like concat('%',:adminInfo,'%') or u.syus_state like concat('%',:adminInfo,'%'))>>
| and ##CONDITIONS##
|
| ]]>
| </sql-query>
| </hibernate-mapping>
|
|
