修改

81041

2019-01-15 253879d0d562db0290a67160d30d3f15e8e7bf09

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
Êþº¾4*
(com/fgkj/dao/impl/Batt_devalarm_dataImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
<init>
()V
Code
     

LineNumberTable
LocalVariableTable
this
*Lcom/fgkj/dao/impl/Batt_devalarm_dataImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
java/util/ArrayList
 
com/fgkj/dto/Batt_devalarm_data
 
num
java/sql/ResultSet !
getInt
(Ljava/lang/String;)I
#%$
java/lang/Integer&'
valueOf
(I)Ljava/lang/Integer;
)*+
setNum
(Ljava/lang/Integer;)V-
    record_id
/0+
setRecord_id2
dev_id
45+
    setDev_id7
dev_ip9:;
    getString
&(Ljava/lang/String;)Ljava/lang/String;
=>?
    setDev_ip
(Ljava/lang/String;)VA
alm_type
CD+
setAlm_typeF
    alm_level
HI+
setAlm_levelK
alm_start_timeMNO
getTimestamp
((Ljava/lang/String;)Ljava/sql/Timestamp;
QRS
setAlm_start_time
(Ljava/util/Date;)VU
alm_end_time
WXS
setAlm_end_timeZ
alm_is_confirmed
\]+
setAlm_is_confirmed_
alm_confirmed_time
abS
setAlm_confirmed_timed
alm_cleared_type
fg+
setAlm_cleared_typei
usr_id
kl+
    setUsr_idnpo
java/util/Listqr
add
(Ljava/lang/Object;)Ztuv
next
()Z
xzy
java/sql/SQLException{

printStackTrace
rs
Ljava/sql/ResultSet;
list
Ljava/util/List;
ddata
!Lcom/fgkj/dto/Batt_devalarm_data;

e
Ljava/sql/SQLException;
 StackMapTable
obj
Ljava/lang/Object;
update‰
G UPDATE db_alarm.tb_devalarm_data SET  alm_is_confirmed=? WHERE num=?  
‹Œ
com/fgkj/db/DBUtilŽ
getConn
()Ljava/sql/Connection;
‘’“
getAlm_is_confirmed
()Ljava/lang/Integer;
•–“
getNum
˜š™
com/fgkj/dao/DAOHelper›œ
 executeUpdate
=(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
sql
Ljava/lang/String;
bl

Z
del£
= DELETE FROM db_alarm.db_alarm.tb_devalarm_data WHERE num=?  
    updatePro
&(Ljava/lang/Object;)Ljava/lang/String;§
java/lang/StringBuilder©
8 UPDATE db_alarm.tb_devalarm_data SET  alm_is_confirmed=
¦«    ?
¦­®¯
append
-(Ljava/lang/Object;)Ljava/lang/StringBuilder;±
,alm_confirmed_time='
¦³®´
-(Ljava/lang/String;)Ljava/lang/StringBuilder;    ˜¶·¸
sdf
Ljava/text/SimpleDateFormat;
º»¼
getAlm_confirmed_time
()Ljava/util/Date;
¾À¿
java/text/SimpleDateFormatÁÂ
format
$(Ljava/util/Date;)Ljava/lang/String;Ä
' WHERE num=
¦ÆÇÈ
toString
()Ljava/lang/String;
    cancelProË
1 UPDATE db_alarm.tb_devalarm_data SET  record_id=
ÍΓ
getRecord_idÐ
,alm_end_time='
ÒÓ¼
getAlm_end_timeÕ
',alm_cleared_type=
×ؓ
getAlm_cleared_typeÚ
 WHERE num=
delProÝ
1 DELETE FROM db_alarm.tb_devalarm_data WHERE num=
    searchAll
()Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;ã
com/fgkj/dto/Batt_Maint_Dealarm
âåæç
getUinf
()Lcom/fgkj/dto/User_inf;
âéêë
getBinf
()Lcom/fgkj/dto/BattInf;
âíîï
getPage
()Lcom/fgkj/dto/Page;ñ
 SELECT FOUND_ROWS() numberó
õ
t SELECT SQL_CALC_FOUND_ROWS tb_devalarm_data.num,record_id,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time, alm_is_confirmed,alm_confirmed_time,alm_cleared_type,  DISTINCTbinf.stationName,DISTINCTbinf.FbsDeviceName  FROM db_alarm.tb_devalarm_data,(SELECT DISTINCT db_battinf.tb_battinf.FbsDeviceId,db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.FbsDeviceName from db_battinf.tb_battinf  where db_battinf.tb_battinf.StationName LIKE ?  AND db_battinf.tb_battinf.StationName1 LIKE ? )  as DISTINCTbinf     WHERE  tb_devalarm_data.dev_id=DISTINCTbinf.FbsDeviceId   AND alm_start_time>=? and alm_start_time<=? ÷
 AND alm_cleared_type!=0
ùûú
java/lang/String&¥ý
2 and db_alarm.tb_devalarm_data.dev_id in(select distinct db_battinf.tb_battinf.FbsDeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=? )ÿ
 ORDER BY alm_start_time DESC 


 LIMIT ?,? 


%




com/fgkj/dto/BattInf
È
getStationName
 

È
getStationName1


 
¼
getBattProductDate



¼
getBattProductDate1




com/fgkj/dto/User_inf
“
getUId




com/fgkj/dto/Page
“
getPageCurr
#



intValue
()I


!
"“
getPageSize
$
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$1

#
&    
'
-(Lcom/fgkj/dao/impl/Batt_devalarm_dataImpl;)V
˜
)
*
+
executeQueryLimit
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;

-
/
.
com/fgkj/dao/LimitNumberFactory
0
1
GetLimtitNumber
*(Ljava/sql/Connection;Ljava/lang/String;)In
3
4

sizen
6
7
8
get
(I)Ljava/lang/Object;
bmd
!Lcom/fgkj/dto/Batt_Maint_Dealarm;
uinf
Lcom/fgkj/dto/User_inf;
binf
Lcom/fgkj/dto/BattInf;
page
Lcom/fgkj/dto/Page;
conn
Ljava/sql/Connection;
    numberSql
baseSql
alarmTypeSql

stationSql
endSql
limitSql
number

I
LocalVariableTypeTable
3Ljava/util/List<Lcom/fgkj/dto/Batt_devalarm_data;>;
N
java/sql/Connection
serchByInfo
å
í
S
 SELECT FOUND_ROWS() number 
U
j SELECT SQL_CALC_FOUND_ROWS distinct tb_devalarm_data.num,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time, alm_is_confirmed,alm_confirmed_time,alm_cleared_type, db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.stationName5,db_battinf.tb_battinf.FbsDeviceName   FROM db_alarm.tb_devalarm_data,db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    WHERE   tb_devalarm_data.dev_id=db_battinf.tb_battinf.FbsDeviceId  and tb_battinf.station_install=1 and db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=? 
W
 AND alm_cleared_type=0 
Y
 and stationname1!=? 
[
 and stationname1=? 
 
 
ù
^
_r
equals
a
 and stationname!=? 
c
 and stationname=? 


f
 and stationname2!=? 
h
 and stationname2=? 

j
kÈ
getStationName2
m
 and stationname5!=? 
o
 and stationname5=? 

q
rÈ
getStationName5
t
 and alm_type!=? 
v
 and alm_type=? 

x
y“
getAlm_type
{
D ORDER BY alm_start_time DESC,db_alarm.tb_devalarm_data.dev_id asc  
}
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$2

|
&
station1SqlT
station1SqlF
stationSqlT
stationSqlF
stationSql2T
stationSql2F
stationSql5T
stationSql5F
almTypeT
almTypeF

searchNums
(Ljava/lang/Object;)I
Œ
°select distinct num,dev_id,alm_start_time  from db_alarm.tb_devalarm_data where alm_cleared_type=0  and tb_devalarm_data.dev_id in (select distinct db_battinf.tb_battinf.FbsDeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=?  and tb_battinf.station_install=1 ) 
Ž
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$3


&
˜
‘
’
+
executeQuery
nums
serchTopAlmInDev
–

oselect db_alarm.tb_devalarm_data.dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fbsdevicename,dev_ip,alm_type,alm_start_time   from db_alarm.tb_devalarm_data,db_battinf.tb_battinf  where alm_cleared_type=0   and db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid   order by alm_start_time desc   limit 1
˜
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$4

—
&
serchTopDevTen
œ
Ïselect distinct db_alarm.tb_devalarm_data.dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fbsdevicename,dev_ip,alm_type,alm_start_time   from db_alarm.tb_devalarm_data,db_battinf.tb_battinf  where alm_cleared_type=0   and db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid and tb_battinf.station_install=1   and  db_alarm.tb_devalarm_data.dev_id  in (select distinct db_battinf.tb_battinf.FbsDeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=?) order by alm_start_time desc   limit 0,5
ž
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$5


&
    serchIn30
¢

Ðselect distinct db_alarm.tb_devalarm_data.dev_id,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fbsdevicename,dev_ip,alm_type,alm_start_time   from db_alarm.tb_devalarm_data,db_battinf.tb_battinf  where alm_cleared_type=0   and db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid and tb_battinf.station_install=1   and (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(alm_start_time))<30
¤

v and tb_battinf.StationId in( select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id  and db_user.tb_user_battgroup_baojigroup_usr.uId=? ) 
¦
  order by alm_start_time desc 
¨
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$6

§
&
userSql
orderSql
serchDev_alarm
®

¸select distinct db_alarm.tb_devalarm_data.dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fbsdevicename,dev_ip,alm_type,alm_start_time,alm_cleared_type   from db_alarm.tb_devalarm_data,db_battinf.tb_battinf   where db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid and tb_battinf.station_install=1   and  db_alarm.tb_devalarm_data.dev_id=? and alm_type=? and alm_start_time=? 

°
±“
    getDev_id

³
´¼
getAlm_start_time
¶
*com/fgkj/dao/impl/Batt_devalarm_dataImpl$7

µ
&
main
([Ljava/lang/String;)V

Exceptions
¼
java/text/ParseException

 
¿

yyyy-MM-dd
¾«
Â

2000-01-01
¾
Ä
Å
Æ
parse
$(Ljava/lang/String;)Ljava/util/Date;
È

2020-01-01

Ê
Ì
Ë
com/fgkj/actions/ActionUtil
Í
Î
getSimpDate
"(Ljava/util/Date;)Ljava/util/Date;

Ð
ÑS
setAlm_start_time1

Ó
Ô?
setStationName1

Ö
×?
setStationName

Ù
Ú?
setStationName2

Ü
Ý?
setStationName5
 


à
á+
setPageCurr


ã
ä+
setPageSize
 


ç
è+
setUId

ê
ë
ì
setPage
(Lcom/fgkj/dto/Page;)V

î
ï
ð
setUinf
(Lcom/fgkj/dto/User_inf;)V
â 
 


Ö


Ó


Ù


Ü


ø
ùS
setBattProductDate


û
üS
setBattProductDate1
â
þ
ÿ
setBinf
(Lcom/fgkj/dto/BattInf;)V
â
ê
â
î


Oán
iterator
()Ljava/util/Iterator;

java/util/Iteratoru 
()Ljava/lang/Object;    
java/lang/System
out
Ljava/io/PrintStream;

java/io/PrintStream
println
(Ljava/lang/Object;)V
v
hasNext
args
[Ljava/lang/String;
dimpl
date1
Ljava/util/Date;
date2

b&
java/util/Date

SourceFile
Batt_devalarm_dataImpl.java
InnerClasses!

    

/

*·±




’Ö»Y·M§»»Y·N-+¹¸"¶(-+,¹¸"¶.-+1¹¸"¶3-+6¹8¶<-+@¹¸"¶B-+E¹¸"¶G-+J¹L¶P-+T¹L¶V-+Y¹¸"¶[-+^¹L¶`-+c¹¸"¶e-+h¹¸"¶j,-¹mW+¹s
šÿB§N-¶w,°
ÌÏxR !""#1$@%L&['j(v)‚*‘+,¬-».àÌ0Ð2Ô44ÖÖ|}
Î~°€Ð‚ƒ„ünû·Kx
qr
6
¬
9…†

‡r
„&+ÀMˆN¸Š-½Y,¶SY,¶”S¸—6¬>?@#A4&&…†
!€ž#Ÿ 
¡r
}+ÀM¢N¸Š-½Y,¶”S¸—6¬EFGH4…†
€žŸ 
¤¥
‰9+ÀM»¦Y¨·ª,¶¶¬°¶²²µ,¶¹¶½¶²ö²,¶”¶¬¶ÅN-°MN7O*99…†
4€7ž
É¥
•E+ÀM»¦YÊ·ª,¶Ì¶¬϶²²µ,¶Ñ¶½¶²Ô¶²,¶Ö¶¬Ù¶²,¶”¶¬¶ÅN-°STCU*EE…†
@€Cž
Û¥
k+ÀM»¦YÜ·ª,¶”¶¬¶ÅN-°Z[\*…†
€ž
Þß
,


°
a

àá
§
@+ÀâM,¶äN,¶è:,¶ì:¸Š:ð:ò:ô:    ö:
»¦Y    ¸ø·ª
¶²¶Å:    ü:»¦Y    ¸ø·ª¶²¶Å:    þ:
: »¦Y    ¸ø·ª¶² ¶²¶Å:½Y»¦Y
Ủ
¶²
¶²¶ÅSY»¦Y
Ủ
    ¶²
¶²¶ÅSY¶
SY¶
SY-¶
SY¶
¶
d¶
 ¶
h¸"SY¶
 S»
#Y*·
%¸
(:¸
,6Æ(¹
2
ž¹
2
d¹
5À¸"¶j°^§¨
©ª«¬­#®'¶+·A¹E¿[Â_ÄdÆÈÖÉ÷Ê
È

ê
ì
"í
=ï¢
@
@…†

;
9
:

6
;
<
0
=
>
*
?
@
%
A
B
!
Cž#
ž'

Dž    +

Ež
Eû
Fž_á
GždÜ
Hž 

6~
-
I
J
K


6~
L„7
ÿ
=
â



Mùùùùùùùn


Oá
ÖS+ÀM,¶
PN,¶
Q:¸Š:
R:ò:
T:
V:    »¦Y¸ø·ª    ¶²¶Å:
X:

Z:,¶
\ò¶
]™»¦Y¸ø·ª
¶²¶Å:§»¦Y¸ø·ª¶²¶Å:
`:
b: ,¶
dò¶
]™»¦Y¸ø·ª¶²¶Å:§»¦Y¸ø·ª ¶²¶Å:
e:
g:,¶
iò¶
]™»¦Y¸ø·ª¶²¶Å:§»¦Y¸ø·ª¶²¶Å:
l:
n:,¶
pò¶
]™»¦Y¸ø·ª¶²¶Å:§»¦Y¸ø·ª¶²¶Å:
s:
u:,¶
w¶
š»¦Y¸ø·ª¶²¶Å:§»¦Y¸ø·ª¶²¶Å:
z:
:»¦Y¸ø·ª¶²¶²¶Å:½Y-¶
SY,¶
\SY,¶
dSY,¶
iSY,¶
pSY,¶
wSY¶
¶
d¶
 ¶
h¸"SY¶
 S»
|Y*·
~¸
(:¸
,6Æ(¹
2
ž¹
2
d¹
5À¸"¶j°¾/
-
.

/
0
1
2
3#
=(
>>
@C
AH
BT
Cj
Dm
Eƒ
Hˆ
I
J™
K¯
L²
MÈ
PÍ
QÒ
RÞ
Sô
T÷
U
 
X

Y

Z
#
[
9
\
<
]
R
`
W
a
\
b
f
c
|
d

e
•
p
š
r
Ÿ
s
º
u
”&
–5
—P
™òSS…†
N€
I
;
<C
?
@>
A
B9
Cž5ž#0
Dž(+
Ež    C
ž
H
€žˆ
Ë
ž
Æ
‚ž Í
†
ƒžÒ

„ž

A
…ž

<
†ž
Wü
‡ž
\÷
ˆž
š¹
Gž
Ÿ´
Hž6~&-
I
J
K
6~
L„£ÿm



Mùùùùùùý.ùùý.ùùý.ùùý,ùùÿº



Mùùùùùùùùùùùùùùùùn


‰
Š
ÜI+À
M
‹N-¸Š½Y,¶
S»
Y*·
¸
:6ƹ
2
ž¹
2
¸"¶
6¬
º
»    
Å%
Ø(
Ù7
ÚF
Ü>II…†
D
;
<    @ž%$~(!
“
J„
ÿF

ùn


ӧ
]
•L+¸Š
»
—Y*·
™¸
M,°
á
ç
þ ž
~

šá
†(+À
M
›N-¸Š½Y,¶
S»
Y*·
Ÿ¸
:°)*    6%S4((…†
#
;
<    ž%~

 á
ÜZ+À
M
¡N
£:»¦Y-¸ø·ª¶²¶ÅN
¥:»¦Y-¸ø·ª¶²¶ÅN-¸Š½Y,¶
S»
§Y*·
©¸
:°"WX    ^a"b'c;dWHZZ…†
U
;
<    QžL
ªž'3
«žW~

‡
”6+ÀM
­N-¸Š½Y,¶
¯SY,¶
wSY,¶
²S»
µY*·
·¸
:°…†    Š3¢466…†
1€    -ž3~    
¸
¹
º

»” 
-»
Y·
½L»¾Y
¾·
ÀM,
Á¶
ÃN,
Ƕ
Ã:»Y·:-¸
ɶP¸
ɶ
Ïò¶
Òò¶
Õò¶
Øò¶
Û¸"¶B»
Y·
Þ:¸"¶
ßN ¸"¶
â»
Y·
å:ê¸"¶
æ¶
é¶
í»âY·
ñ:»
Y·
ò:        ò¶
ó    ò¶
ô    ò¶
õ    ò¶
ö    -¸
ɶ
÷    ¸
ɶ
ú    ¶
ý¶
¶+¶:
 
¹
:§¹    
À:²¶¹
šÿ屎#¥¦§¨$©-ª6«@¬G­N®U¯\°e±n²w³‚´‹µ–¶·¤¸­¹¶º½»Ä¼Ë½Ò¾Û¿åÁìÂóÃúÅ
Æ
Ç
"Æ
,Íz
-
%

·¸
 !$
    "!-
€n¿
?
@‹¢
;
<­€
9
:¶w
=
>    
+~

#
K

+~
L
„/ÿ
 $
¾%%

â
n
'():
#
|

—

§
µ