1 <?xml version="1.0" encoding="UTF-8"?>
2 "http://ibatis.apache.org/dtd/sql-map-2.dtd">
4
5
6
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50 parameterClass="com.yondervision.mi.form.MI950Form">
51
55 select t.REGID, t.PERSONALID, t.CENTERID, t.FILEDATE, t.FILENAME, t.FILEPATH, t.CHANNEL, t.VALIDFLAG,56 t.DATEMODIFIED, t.DATECREATED,t.FREEUSE1, t.FREEUSE2, t.FREEUSE3, t.FREEUSE4,d.USERNAME as USERNAME, d.CERTINUM as CERTINUM57 from MI950 t,MI029 d WHERE 1=1 and t.personalid = d.personalid AND t.VALIDFLAG = '1'58
59 t.CENTERID = #centerid:VARCHAR#60
61
62 t.PERSONALID = #personalid:VARCHAR#63
64
65
66 to_date(t.FILEDATE,'yyyy-mm-dd') >= to_date('$startdate$','yyyy-mm-dd')67 ]]>
68
69
70
71 to_date(t.FILEDATE,'yyyy-mm-dd') <= to_date('$enddate$','yyyy-mm-dd')72 ]]>
73
74 ORDER BY t.FILEDATE DESC75
76
77
81 insert into MI950 (REGID, PERSONALID, CENTERID, FILEDATE, FILENAME, FILEPATH, CHANNEL,82 VALIDFLAG, DATEMODIFIED, DATECREATED,83 FREEUSE1, FREEUSE2, FREEUSE3, FREEUSE4)84 values (#regid:VARCHAR#, #personalid:VARCHAR#, #centerid:VARCHAR#, #filedate:VARCHAR#,85 #filename:VARCHAR#,86 #filepath:VARCHAR#, #channel:VARCHAR#, #validflag:VARCHAR#, #datemodified:VARCHAR#,87 #datecreated:VARCHAR#,88 #freeuse1:VARCHAR#, #freeuse2:VARCHAR#, #freeuse3:VARCHAR#, #freeuse4:INTEGER#)89
90
91 SELECT * FROM MI95092
93
94
95 SELECT count(*) FROM MI95096 WHERE 1=197
98 CENTERID = #centerid:VARCHAR#99
100
101 PERSONALID = #personalid:VARCHAR#102
103
104
105 to_date(FILEDATE,'yyyy-mm-dd') >= to_date('$startdate$','yyyy-mm-dd')106 ]]>
107
108
109
110 to_date(FILEDATE,'yyyy-mm-dd') <= to_date('$enddate$','yyyy-mm-dd')111 ]]>
112
113
114
115 SELECT * FROM MI950116
117
118 FILEDATE = #filedate:VARCHAR#119
120
121 PERSONALID = #personalid:VARCHAR#122
123
124 CENTERID = #centerid:VARCHAR#125
126
127
128
129 UPDATE MI950130
131
132
133
134
135
136
137
138
139 REGID = #regid#140
141
142