修改

81041

2019-01-10 4e3f740554673dee39e94d67540e1d9469912b43

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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
Êþº¾4c
&com/fgkj/dao/impl/User_task_changeImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
<init>
()V
Code
     

LineNumberTable
LocalVariableTable
this
(Lcom/fgkj/dao/impl/User_task_changeImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
java/util/ArrayList
 
com/fgkj/dto/User_task_change
 
num
java/sql/ResultSet !
getInt
(Ljava/lang/String;)I
#%$
java/lang/Integer&'
valueOf
(I)Ljava/lang/Integer;
)*+
setNum
(Ljava/lang/Integer;)V-
usr_id
/0+
    setUsr_id2
    master_id
45+
setMaster_id7
appoint_uid
9:+
setAppoint_uid<
    copy_uids>?@
    getString
&(Ljava/lang/String;)Ljava/lang/String;
BCD
setCopy_uids
(Ljava/lang/String;)VF
change_type_id
HI+
setChange_type_idK
task_type_id
MN+
setTask_type_idP
task_rc_num
RS+
setTask_rc_numU
battgroupId
WX+
setBattgroupIdZ
 change_reason
\]D
setChange_reason_
old_executor_ids
abD
setOld_executor_idsd
old_task_exe_timefgh
getTimestamp
((Ljava/lang/String;)Ljava/sql/Timestamp;
jkl
setOld_task_exe_time
(Ljava/util/Date;)Vn
new_executor_ids
pqD
setNew_executor_idss
new_task_exe_time
uvl
setNew_task_exe_timex
change_ask_time
z{l
setChange_ask_time}
change_ask_time_limit
€l
setChange_ask_time_limit‚
task_change_approve_time
„…l
setTask_change_approve_time‡
task_change_approve_res
‰Š+
setTask_change_approve_resŒ
remark
ŽD
    setRemark‘“’
java/util/List”•
add
(Ljava/lang/Object;)Z—˜™
next
()Z
›œ
java/sql/SQLExceptionž

printStackTrace
rs
Ljava/sql/ResultSet;
list
Ljava/util/List;
uchange
Lcom/fgkj/dto/User_task_change;

e
Ljava/sql/SQLException;
 StackMapTable©

ainsert into db_user.tb_user_task_change(usr_id,master_id,appoint_uid,copy_uids,change_type_id,task_type_id,task_rc_num,battgroupid,change_reason,old_executor_ids,old_task_exe_time,new_executor_ids,new_task_exe_time,change_ask_time,change_ask_time_limit,task_change_approve_time,task_change_approve_res,remark) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
«­¬
com/fgkj/db/DBUtil®¯
getConn
()Ljava/sql/Connection;
±²³
    getUsr_id
()Ljava/lang/Integer;
µ¶³
getMaster_id
¸¹³
getAppoint_uid
»¼½
getCopy_uids
()Ljava/lang/String;
¿À³
getChange_type_id
Âó
getTask_type_id
ÅƳ
getTask_rc_num
Èɳ
getBattgroupId
Ë̽
getChange_reason
ÎϽ
getOld_executor_ids
ÑÒÓ
getOld_task_exe_time
()Ljava/util/Date;
ÕÖ½
getNew_executor_ids
ØÙÓ
getNew_task_exe_time
ÛÜÓ
getChange_ask_time
ÞßÓ
getChange_ask_time_limit
áâÓ
getTask_change_approve_time
äå³
getTask_change_approve_res
çè½
    getRemark
êìë
com/fgkj/dao/DAOHelperíî
 executeUpdate
=(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
ðòñ
java/lang/Boolean&ó
(Z)Ljava/lang/Boolean;
ðõö™
booleanValue
obj
Ljava/lang/Object;
sql
Ljava/lang/String;
bl
Ljava/lang/Boolean;
updateÿ
qupdate db_user.tb_user_task_change set task_change_approve_res=?,remark=?,task_change_approve_time=? where num=? 



³
getNum
del

3delete from db_user.tb_user_task_change where num=?

Z
    searchAll
()Ljava/util/List;
serchByCondition1
$(Ljava/lang/Object;)Ljava/util/List;

com/fgkj/dto/Task_Batt_Test





getBinf
()Lcom/fgkj/dto/BattInf;
 
getUchange
!()Lcom/fgkj/dto/User_task_change;



select distinct(tb_user_task_change.battgroupid),battgroupname,stationname,tb_user_task_change.num,usr_id,master_id,appoint_uid,copy_uids,change_type_id,task_type_id,task_rc_num,change_reason,old_executor_ids,old_task_exe_time,new_executor_ids,new_task_exe_time,change_ask_time,change_ask_time_limit,task_change_approve_time,task_change_approve_res,remark from db_user.tb_user_task_change,db_battinf.tb_battinf where  tb_user_task_change.BattGroupId=db_battinf.tb_battinf.BattGroupId and (change_ask_time)>=(?) and  (change_ask_time)<=(?)  

 and stationname1!=? 

 and stationname1=? 


 

com/fgkj/dto/BattInf
!½
getStationName1

#
%
$
java/lang/String
&•
equals
(
java/lang/StringBuilder

#
*&
+
&(Ljava/lang/Object;)Ljava/lang/String;

'
-    D

'
/
0
1
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;

'
3
4½
toString
6
 and stationname!=? 
8
 and stationname=? 


:
;½
getStationName
=
 and battproducer!=? 
?
 and battproducer=? 


A
B½
getBattProducer
D
+ and db_battinf.tb_battinf.battgroupid!=?  
F
* and db_battinf.tb_battinf.battgroupid=?  


H
I³
getBattGroupId
#
K
L
M
intValue
()I
O
 and BattGroupName1 like ? 
Q
| and BattGroupName1 not like '%开关电源系统%' and BattGroupName1 not like '%UPS系统%' and BattGroupName1 not like ? 


S
T½
getBattGroupName1
V
其他
X
 and monVolStd!=? 
Z
 and monVolStd=?


\
]
^
getMonVolStd
()Ljava/lang/Float;

`
b
a
java/lang/Float
c
d

floatValue
()F
f
 and monCapStd!=? 
h
 and monCapStd=?


j
k
^
getMonCapStd
m
 and task_type_id!=? 
o
 and task_type_id=? 
q
 and usr_id!=? 
s
 and usr_id=? 
u
 and change_type_id!=? 
w
 and change_type_id=? 
y
  and task_change_approve_res!=? 
{
 and task_change_approve_res=? 
}
& and task_change_approve_res in (0,?) 

" order by tb_user_task_change.num 


‚Ó
getChange_ask_time1
„

%
†
(com/fgkj/dao/impl/User_task_changeImpl$1

…
ˆ    
‰
+(Lcom/fgkj/dao/impl/User_task_changeImpl;)V
ê
‹
Œ

executeQuery
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;




‘
getPage
()Lcom/fgkj/dto/Page;

“
•
”
com/fgkj/dto/Page
–³
getPageCurr

“
˜
™³
getPageSize‘
›
œ

get
(I)Ljava/lang/Object;‘
Ÿ
 
M
size

“
¢
£+

setPageAll
tbt
Lcom/fgkj/dto/Task_Batt_Test;
binf
Lcom/fgkj/dto/BattInf;
baseSql
station1SqlT
station1SqlF
stationSqlT
stationSqlF
producerSqlT
producerSqlF
idSqlT
idSqlF
nameSqlT
nameSqlF
volSqlT
volSqlF
capSqlT
capSqlF
 task_typeSqlT
 task_typeSqlF
approveSqlT
approveSqlF
change_typeSqlT
change_typeSqlF
change_approveSqlT
change_approveSqlF
change_approveSqlD
endSql
listd
index

I

i
LocalVariableTypeTable
/Ljava/util/List<Lcom/fgkj/dto/Task_Batt_Test;>;
serchByCondition
É
 SELECT FOUND_ROWS() number
Ë
0select SQL_CALC_FOUND_ROWS distinct(tb_user_task_change.battgroupid),battgroupname,stationname,tb_user_task_change.num,usr_id,master_id,appoint_uid,copy_uids,change_type_id,task_type_id,task_rc_num,change_reason,old_executor_ids,old_task_exe_time,new_executor_ids,new_task_exe_time,change_ask_time,change_ask_time_limit,task_change_approve_time,task_change_approve_res,remark from db_user.tb_user_task_change,db_battinf.tb_battinf where  tb_user_task_change.BattGroupId=db_battinf.tb_battinf.BattGroupId and (change_ask_time)>=(?) and  (change_ask_time)<=(?)  
Í
* order by tb_user_task_change.battgroupid 
Ï
 limit ?,? 
Ñ
(com/fgkj/dao/impl/User_task_changeImpl$2

Ð
ˆ
ê
Ô
Õ

executeQueryLimit

×
Ù
Ø
com/fgkj/dao/LimitNumberFactory
Ú
Û
GetLimtitNumber
*(Ljava/sql/Connection;Ljava/lang/String;)I    
Ý
ß
Þ
java/lang/System
à
á
out
Ljava/io/PrintStream;
ã
number: 

'
å
0
æ
(I)Ljava/lang/StringBuilder;

è
ê
é
java/io/PrintStream
ëD
println
    numberSql
conn
Ljava/sql/Connection;
limitSql
number
ò
java/sql/Connection
serchByInfo
main
([Ljava/lang/String;)V

Exceptions
ø
java/text/ParseException
ú
java/text/SimpleDateFormat
ü

yyyy-MM-dd

ù
-
ÿ

2000-01-01

ù

parse
$(Ljava/lang/String;)Ljava/util/Date;

2020-01-01
 

    D
setStationName

D
setStationName1

+
setBattGroupId

D
setBattGroupName1

D
setBattProducer

`&
(F)Ljava/lang/Float;


setMonCapStd
(Ljava/lang/Float;)V


setMonVolStd
!#"
com/fgkj/actions/ActionUtil$%
getSimpDate
"(Ljava/util/Date;)Ljava/util/Date;
'(l
setChange_ask_time1

“ 

“+,+
setPageCurr

“./+
setPageSize
 

234
setBinf
(Lcom/fgkj/dto/BattInf;)V

678

setUchange
"(Lcom/fgkj/dto/User_task_change;)V

:;<
setPage
(Lcom/fgkj/dto/Page;)V
 

?
Ç

‘ABC
iterator
()Ljava/util/Iterator;EGF
java/util/Iterator˜H
()Ljava/lang/Object;

èJ
ëK
(Ljava/lang/Object;)VEMN™
hasNext

èP
ëQ
(I)V
args
[Ljava/lang/String;
sdf
Ljava/text/SimpleDateFormat;
date1
Ljava/util/Date;
date2
page
Lcom/fgkj/dto/Page;
uimpl

tS_
java/util/Date

SourceFile
User_task_changeImpl.java
InnerClasses!


    

/

*·±




-»Y·M§
»Y·N-+¹¸"¶(-+,¹¸"¶.-+1¹¸"¶3-+6¹¸"¶8-+;¹=¶A-+E¹¸"¶G-+J¹¸"¶L-+O¹¸"¶Q-+T¹¸"¶V-+Y¹=¶[-+^¹=¶`-+c¹e¶i-+m¹=¶o-+r¹e¶t-+w¹e¶y-+|¹e¶~-+¹e¶ƒ-+†¹¸"¶ˆ-+‹¹=¶,-¹W+¹–
šþë§N-¶š,°

#
&›n !""1#@$O%[&j'y(ˆ)—*£+¯,»-Ç.Ó/ß0ë1÷2
3
5

#7
'9
+;4
-
-Ÿ 

%¡¢
£¤
'¥¦§ü‘û
K›
”•

©+ÀM¨N¸ª-½Y,¶°SY,¶´SY,¶·SY,¶ºSY,¶¾SY,¶ÁSY,¶ÄSY,¶ÇSY,¶ÊSY    ,¶ÍSY
,¶ÐSY,¶ÔSY,¶×SY ,¶ÚSY,¶ÝSY,¶àSY,¶ãSY,¶æS¸é¸ï:¶ô¬"?@C(DVE~F›C£G4©©÷ø
¤£¤¡ùú£ûü
ý•
˜:+ÀMþN¸ª-½Y,¶ãSY,¶æSY,¶àSY,¶
S¸é¸ï:¶ô¬KLM4N4::÷ø
5£¤2ùú4ûü

•
~ +ÀM
N¸ª-½Y,¶
S¸é6¬RS    TU4  ÷ø
£¤    ùúû




,


°
Z


    


™#v+À
M,¶
 N,¶
:
:
:
:
:-¶

¶
"™»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
5:    
7:
-¶
9
¶
"™»
'Y¸
)·
,    ¶
.¶
2:§»
'Y¸
)·
,
¶
.¶
2:
<:
>:-¶
@
¶
"™»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
C: 
E:-¶
G¶
Jš»
'Y¸
)·
, ¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
N:
P:-¶
R
U¶
"™»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
W:
Y:-¶
[¶
_•š»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
e:
g:-¶
i¶
_•š»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
l:
n:¶Á¶
Jd »
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
p:
r:¶°¶
Jš»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
t:
v:¶¾¶
Jd »
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
x:
z:
|:¶ã¶
Jd »
'Y¸
)·
,¶
.¶
2:§>¶ã¶
J »
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
~:»
'Y¸
)·
,¶
.¶
2:¸ª ½Y¶ÚSY¶
€SY-¶
SY-¶
9SY-¶
@SY-¶
GSY»
'Y
ƒ·
,-¶
R¶
.
Ħ
.¶
2SY-¶
[SY-¶
iSY    ¶ÁSY
¶°SY¶¾SY¶ãS»
…Y*·
‡¸
Š:»Y·: 6!,¶
Ž¶
’¶
Jd,¶
Ž¶
—¶
Jh6"§9 "¹
šÀ
¹W !„!
¹
šÀ
¶
Ž¹
ž
¸"¶
¡„"
",¶
Ž¶
—¶
J,¶
Ž¶
’¶
Jh¢"¹
ž
¡ÿ§ °
–e^_
`abjk$l1mGnJo`resjtwuvw¦z«{°|½}Ó~Öì‚ñƒö„
…
†
‡
/Š
4‹
9Œ
F
\Ž
_
u’
z“
”
‹•
¡–
¤—
ºš
¿›
Ĝ
Н
æž
éŸ
ÿ¢£    ¤¥,§/¨E«J¬O­Z®p°s±‰´Žµ“¶ ·¶¹¹ºϽÔ¾Ù¿ÞÀëÁ
ÃÄÅ&Æ)È?ÌDÍZÏ_ÐfÑnÒvÓ}ԄՋדرٹÚÁÛÊÜÓÝÜÞâßêÏï
 ø
û

+
J
s

`#vv÷ø
q
¤
¥
l
¦
§f£¤aùú\
¨úW
©ú$R
ªúe
«ú    j
¬ú
«Ë
­ú°Æ
®úñ…
¯ú ö€
°ú
4B
±ú
9=
²ú
zü
³ú
÷
´ú
¿·
µú
IJ
¶úr
·ú    m
¸úJ,
¹úO'
ºúŽ
è
»ú“
ã
¼úÔ
¢
½úÙ

¾úÞ
˜
¿úD
2
Àú¢ø~
Á¢ û{
Â
Ã!_
Ä
Ã"
Å
ø~
Á
Æ §ýÿJ    



#
#
#
#ý/
#
#ý/
#
#ý,
#
#ý/
#
#ý.
#
#ý.
#
#ý/
#
#ý-
#
#ý/
#
#þ4
#
#
#$ÿ×#



#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#‘‘

5ú%

Ç


¼$|+À
M,¶
 N,¶
:
:
È:¸ª:
Ê:
:    
:
-¶

¶
"™»
'Y¸
)·
,    ¶
.¶
2:§»
'Y¸
)·
,
¶
.¶
2:
5:
7:-¶
9
¶
"™»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
<: 
>:-¶
@
¶
"™»
'Y¸
)·
, ¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
C:
E:-¶
G¶
Jš»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
N:
P:-¶
R
U¶
"™»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
W:
Y:-¶
[¶
_•š»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
e:
g:-¶
i¶
_•š»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
l:
n:¶Á¶
Jd »
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
p:
r:¶°¶
Jš»
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
t:
v:¶¾¶
Jd »
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
x:
z:
|:¶ã¶
Jd »
'Y¸
)·
,¶
.¶
2:§>¶ã¶
J »
'Y¸
)·
,¶
.¶
2:§»
'Y¸
)·
,¶
.¶
2:
Ì: 
Î:!»
'Y¸
)·
, ¶
.!¶
.¶
2:½Y¶ÚSY¶
€SY-¶
SY-¶
9SY-¶
@SY-¶
GSY»
'Y
ƒ·
,-¶
R¶
.
Ħ
.¶
2SY-¶
[SY-¶
iSY    ¶ÁSY
¶°SY¶¾SY¶ãSY ,¶
Ž¶
’¶
Jd,¶
Ž¶
—¶
Jh¸"SY,¶
Ž¶
—S»
ÐY*·
Ò¸
Ó:"¸
Ö6#²
Ü»
'Y
â·
,#¶
ä¶
2¶
ç"Æ+"¹
ž
ž!""¹
ž
d¹
šÀ
¶
Ž#¸"¶
¡"°
¢h







$
')
(.
);
*Q
+T
,j
/o
0t
1
2—
3š
4°
7µ
8º
9Ç
:Ý
;à
<ö
?û
@

A


B
 
C
#
D
9
G
>
H
C
I
P
J
f
K
i
L

O
„
P
‰
Q
•
R
«
S
®
T
Ä
W
É
X
Î
Y
Ú
Z
ð
[
ó
\    
_
`
a 
b6
d9
eO
hT
iY
jd
kz
m}
n“
q˜
r
sª
tÀ
vÃ
wÙ
zÞ
{ã
|è
}õ
~
€

‚0
ƒ3
…I
‰N
ŠS
‹n
r
Žy

‰
‘
’—
“ž
•¦
–Ä
—Ì
˜Ô
™Ý
šæ
ݕ
Ͽ

ž
Ÿ&
+
Õ4
ÖL
×[
Øy
Ú
j$||÷ø
w
¤
¥
r
¦
§l£¤gùúb
ìú]
í
î$X
¨ú)S
©ú    .N
ªú
o 
«út
¬úµÇ
­ú ºÂ
®úû
¯ú
|
°ú
>>
±ú
C9
²ú
„ø
³ú
‰ó
´ú
ɳ
µú
ή
¶ún
·úi
¸úT(
¹úY#
ºú˜
ä
»ú
ß
¼úÞ
ž
½úã
™
¾úè
”
¿úN
.
Àú S
)
ïú!+Q¡¢"4H
ð
Ã#
Å
+Q¡
Æ"§
ÿT



#
#
ñ
#
#
#ý/
#
#ý/
#
#ý,
#
#ý/
#
#ý.
#
#ý.
#
#ý/
#
#ý-
#
#ý/
#
#þ4
#
#
#$ÿ
/$



#
#
ñ
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#‘


ó


6

°

Þ÷ø
    
ô
õ
ö

÷u
'»
ùY
û·
ýL+
þ¶M+¶N»
Y·:
¶
¶
¸"¶ 
¶
¶¸¶¸¶»Y·:d¸"¶Ld¸"¶G¸"¶.¸"¶ˆ,¸ ¶y-¸ ¶&»
“Y·):¸"¶*
¸"¶-»
Y·0:¶1¶5¶9»
Y·=:¶>:        ¹@
:§¹D
À
:
²
Ü
¶
¶I¹L
šÿâ²
Ü    ¹
ž
¶O±‚ 
á
â
ã
å$
æ,
ç4
è=
éE
êM
ëV
ì_
îh
ïr
ð|
ñ…
òŽ
ó—
ô 
ö©
÷²
ø¼
úÅ
ûÌ
üÓ
ýÚ
ÿãì





&p
'RS
TU

VW
XW$

¦
§h¿£¤©~YZÅb
¤
¥ãD[ì;¡¢    
\
¥

Å
ì;¡
Æ    §,ÿø]
ù^^

“

‘E`ab
…
Ð