修改设备连接和电池组连接

81041

2019-01-18 de8f3559c7e3bfe2153efded3b2885435aa93f0e

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

LineNumberTable
LocalVariableTable
this
+Lcom/fgkj/dao/impl/User_task_batt_testImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
java/util/ArrayList
 
com/fgkj/dto/Task_Batt_Test
 
 com/fgkj/dto/User_task_batt_test
 
num "!
java/sql/ResultSet#$
getInt
(Ljava/lang/String;)I
&('
java/lang/Integer)*
valueOf
(I)Ljava/lang/Integer;
,-.
setNum
(Ljava/lang/Integer;)V0
task_id
23.

setTask_id5
task_usr_ids 789
    getString
&(Ljava/lang/String;)Ljava/lang/String;
;<=
setTask_usr_ids
(Ljava/lang/String;)V?
BattGroupId
AB.
setBattGroupIdD
task_enabled
FG.
setTask_enabledI
 task_exe_date KLM
getTimestamp
((Ljava/lang/String;)Ljava/sql/Timestamp;
OPQ
setTask_exe_date
(Ljava/util/Date;)VS
task_close_date
UVQ
setTask_close_dateX
task_notice_starttime
Z[Q
setTask_notice_starttime]
task_notice_endtime
_`Q
setTask_notice_endtimeb
task_notice_count
de.
setTask_notice_countg
task_notice_latesttime
ijQ
setTask_notice_latesttimel
task_notice_master
no.
setTask_notice_masterq
 test_complete
st.
setTest_completev
test_completetime
xyQ
setTest_completetime{
test_starttime
}~Q
setTest_starttime€
test_record_count_id
‚ƒ.
setTest_record_count_id…
note
‡ˆ=
setNoteŠ
com/fgkj/dto/BattInf
‰ 
battGroupId
‰A
stationName
‰’“=
setStationName•
 battGroupName
‰—˜=
setBattGroupName
š›œ
setBinf
(Lcom/fgkj/dto/BattInf;)V
žŸ 
setUtest
%(Lcom/fgkj/dto/User_task_batt_test;)V¢¤£
java/util/List¥¦
add
(Ljava/lang/Object;)Z ¨©ª
next
()Z
¬®­
java/sql/SQLException¯

printStackTrace
rs
Ljava/sql/ResultSet;
list
Ljava/util/List;
tbt
Lcom/fgkj/dto/Task_Batt_Test;
utest
"Lcom/fgkj/dto/User_task_batt_test;
binf
Lcom/fgkj/dto/BattInf;

e
Ljava/sql/SQLException;
 StackMapTable¾

Ninsert into db_user.tb_user_task_batt_test(task_id,task_usr_ids,BattGroupId,task_enabled,task_exe_date,task_close_date,task_notice_starttime,task_notice_endtime,task_notice_count,task_notice_latesttime,task_notice_master,test_complete,test_completetime,test_starttime,test_record_count_id,note) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
ÀÂÁ
com/fgkj/db/DBUtilÃÄ
getConn
()Ljava/sql/Connection;
ÆÇÈ

getTask_id
()Ljava/lang/Integer;
ÊËÌ
getTask_usr_ids
()Ljava/lang/String;
ÎÏÈ
getBattGroupId
ÑÒÈ
getTask_enabled
ÔÕÖ
getTask_exe_date
()Ljava/util/Date;
ØÙÖ
getTask_close_date
ÛÜÖ
getTask_notice_starttime
ÞßÖ
getTask_notice_endtime
áâÈ
getTask_notice_count
äåÖ
getTask_notice_latesttime
çèÈ
getTask_notice_master
êëÈ
getTest_complete
íîÖ
getTest_completetime
ðñÖ
getTest_starttime
óôÈ
getTest_record_count_id
ö÷Ì
getNote
ùûú
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;
addPro
&(Ljava/lang/Object;)Ljava/lang/String;

java/lang/StringBuilder


.insert into db_user.tb_user_task_batt_test(task_id,task_usr_ids,BattGroupId,task_enabled,task_exe_date,task_close_date,task_notice_starttime,task_notice_endtime,task_notice_count,task_notice_latesttime,task_notice_master,test_complete,test_completetime,test_starttime,test_record_count_id,note) values(


    =





append
-(Ljava/lang/Object;)Ljava/lang/StringBuilder;

,'





-(Ljava/lang/String;)Ljava/lang/StringBuilder;

',
 

,    ù
"
#
$
sdf
Ljava/text/SimpleDateFormat;

&
(
'
java/text/SimpleDateFormat
)
*
format
$(Ljava/util/Date;)Ljava/lang/String;
,
','
.
')


0
1Ì
toString
update
4

Pupdate db_user.tb_user_task_batt_test set task_id=?,task_usr_ids=?,BattGroupId=?,task_enabled=?,task_exe_date=?,task_close_date=?,task_notice_starttime=?,task_notice_endtime=?,task_notice_count=?,task_notice_latesttime=?,task_notice_master=?,test_complete=?,test_completetime=?,test_starttime=?,test_record_count_id=?,note=? where num=?

6
7È
getNum

updateUser
:
Iupdate db_user.tb_user_task_batt_test set task_usr_ids=? where task_id=? 

updateTask
=
Tupdate db_user.tb_user_task_batt_test set task_usr_ids=?,task_exe_date=? where num=?
del
@
6delete from db_user.tb_user_task_batt_test where num=?
    searchAll
()Ljava/util/List;
D
,select * from db_user.tb_user_task_batt_test
 
ù
G
H
I
executeQuery
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;
M
com/fgkj/dto/User_task
O

ýselect distinct(task_id),tb_user_task_batt_test.num,task_usr_ids,tb_user_task_batt_test.BattGroupId,task_enabled,task_exe_date,task_close_date,task_notice_starttime,task_notice_endtime,task_notice_count,task_notice_latesttime,task_notice_master,test_complete,test_completetime,test_starttime,test_record_count_id,note,stationname ,battgroupname from db_user.tb_user_task_batt_test,db_battinf.tb_battinf where tb_user_task_batt_test.battgroupid=db_battinf.tb_battinf.battgroupid and task_id=? order by task_id 

LÆ
utask
Lcom/fgkj/dto/User_task;
serchByInfo

U
V
W
getUinf
()Lcom/fgkj/dto/User_inf;

Y
Z
[
getBinf
()Lcom/fgkj/dto/BattInf;

]
^
_
getUtest
$()Lcom/fgkj/dto/User_task_batt_test;
a

c
Fselect distinct(tb_user_task_batt_test.BattGroupId),task_id,task_usr_ids,task_enabled,task_exe_date,task_close_date,task_notice_starttime,task_notice_endtime,task_notice_count,task_notice_latesttime,task_notice_master,test_complete,test_completetime,test_starttime,test_record_count_id,note from db_user.tb_user_task_batt_test ,db_battinf.tb_battinf  where tb_user_task_batt_test.BattGroupId=db_battinf.tb_battinf.BattGroupId  and (battproductdate)>=(?) and (battproductdate)<=(?) and (battinusedate)>=(?) and (battinusedate)<=(?) and (task_exe_date)>=(?) and  (task_exe_date)<=(?) 
e
 and stationname1!=? 
g
 and stationname1=? 
‰
i
jÌ
getStationName1

l
n
m
java/lang/String
o¦
equals

l
q)
 
s
 and stationname!=? 
u
 and stationname=? 
‰
w
xÌ
getStationName
z
 and battproducer!=? 
|
 and battproducer=? 
‰
~
Ì
getBattProducer

8 and  tb_user_task_batt_test.BattGroupId not in (select  distinct(db_battinf.tb_battinf.BattgroupId) 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_battgroup.baoji_group_id= db_user.tb_user_battgroup_baojigroup_usr.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=?   )  
ƒ
X and  tb_user_task_batt_test.BattGroupId in (select  distinct(db_battinf.tb_battinf.BattgroupId) 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_battgroup.baoji_group_id= db_user.tb_user_battgroup_baojigroup_usr.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  db_user.tb_user_inf.ubaojiusr=1 )  

…
‡
†
com/fgkj/dto/User_inf
ˆÈ
getUId
&
Š
‹
Œ
intValue
()I
Ž
 and task_usr_ids!=? 

 and task_usr_ids=? 
’

0
”
 and test_complete!=? 
–
 and test_complete=? 
˜
, and (test_completetime)<=(task_close_date) 
š
+ and db_battinf.tb_battinf.battgroupid!=?  
œ
* and db_battinf.tb_battinf.battgroupid=?  
‰Î
Ÿ
 and BattGroupName1 like ? 
¡
| and BattGroupName1 not like '%开关电源系统%' and BattGroupName1 not like '%UPS系统%' and BattGroupName1 not like ? 
‰
£
¤Ì
getBattGroupName1
¦
其他
¨
 and monVolStd!=? 
ª
 and monVolStd=?
‰
¬
­
®
getMonVolStd
()Ljava/lang/Float;

°
²
±
java/lang/Float
³
´

floatValue
()F
¶
 and monCapStd!=? 
¸
 and monCapStd=?
‰
º
»
®
getMonCapStd
½
 order by task_exe_date 
‰
¿
ÀÖ
getBattProductDate
‰
Â
ÃÖ
getBattProductDate1
‰
Å
ÆÖ
getBattInUseDate
‰
È
ÉÖ
getBattInUseDate1

Ë
ÌÖ
getTask_exe_date1
Î

%
Ð
+com/fgkj/dao/impl/User_task_batt_testImpl$1

Ï
Ò    
Ó
f(Lcom/fgkj/dao/impl/User_task_batt_testImpl;Lcom/fgkj/dto/User_task_batt_test;Lcom/fgkj/dto/BattInf;)V
uinf
Lcom/fgkj/dto/User_inf;
baseSql
station1SqlT
station1SqlF
stationSqlT
stationSqlF
producerSqlT
producerSqlF
    baojiSqlT
    baojiSqlF
userSqlT
userSqlF
 compeleteSqlT
 compeleteSqlF
rightNowSql
idSqlT
idSqlF
nameSqlT
nameSqlF
volSqlT
volSqlF
capSqlT
capSqlF
endSql
main
([Ljava/lang/String;)V

Exceptions
ñ
java/text/ParseException
ó
,com/fgkj/services/User_task_batt_testService

ò 
ö

yyyy-MM-dd

&

ù

2000-01-01

&
û
ü
ý
parse
$(Ljava/lang/String;)Ljava/util/Date;
ÿ

2016-11-30

Q
setTask_exe_date1

1
‰=
setStationName1
‰    
=
 setSignalName
‰ =
setBattGroupName1
‰=
setBattProducer

°)
(F)Ljava/lang/Float;
‰
setMonCapStd
(Ljava/lang/Float;)V
‰
setMonVolStd

com/fgkj/actions/ActionUtil 
getSimpDate
"(Ljava/util/Date;)Ljava/util/Date;
‰"#Q
setBattProductDate
‰%&Q
setBattProductDate1
‰()Q
setBattInUseDate
‰+,Q
setBattInUseDate1

… 

…/0.
setUId
234
setUinf
(Lcom/fgkj/dto/User_inf;)V

ò6
S
K
args
[Ljava/lang/String;
us
.Lcom/fgkj/services/User_task_batt_testService;
date1
Ljava/util/Date;
date2
date3
date4

SourceFile
User_task_batt_testImpl.java
InnerClasses!

    

/

*·±



k
k»Y·M§
P»Y·N»Y·:+¹¸%¶++/¹¸%¶1+4¹6¶:+>¹¸%¶@+C¹¸%¶E+H¹J¶N+R¹J¶T+W¹J¶Y+\¹J¶^+a¹¸%¶c+f¹J¶h+k¹¸%¶m+p¹¸%¶r+u¹J¶w+z¹J¶|+¹¸%¶+„¹6¶†»‰Y·‹:+Œ¹¸%¶Ž+¹6¶‘+”¹6¶–-¶™-¶,-¹¡W+¹§
šþ­§N-¶«,°

a
d¬‚  !#$,%<&I'Y(i)v*ƒ+,-­.º/Ê0Ú1ç2ô3
4
6
7
*8
79
D;
J<
P=
X 
a?
eA
iCH
k
k°±

c²³
E´µ
<¶·
>¸¹
eº»¼ü¢û
LK¬
¥¦

™+ÀM½N¸¿-½Y,¶ÅSY,¶ÉSY,¶ÍSY,¶ÐSY,¶ÓSY,¶×SY,¶ÚSY,¶ÝSY,¶àSY    ,¶ãSY
,¶æSY,¶éSY,¶ìSY ,¶ïSY,¶òSY,¶õS¸ø¸þ:¶
¬"GHK!LFMfN‹K“O4™™


”¶·‘

    “





 

s
+ÀM»
Y
·
,¶Å¶

¶
,¶É¶

¶
,¶Í¶

¶
,¶Ð¶

¶
²
!,¶Ó¶
%¶

+¶
²
!,¶×¶
%¶

+¶
²
!,¶Ú¶
%¶

+¶
²
!,¶Ý¶
%¶

¶
,¶à¶

¶
²
!,¶ã¶
%¶

¶
,¶æ¶

¶
,¶é¶

¶
²
!,¶ì¶
%¶

+¶
²
!,¶ï¶
%¶

¶
,¶ò¶

¶
,¶õ¶

-¶
¶
/N-°"TUW)X|Y¼Z
    U
 [*






¶·
 

    

2¦

¢+ÀM
3N¸¿-½Y,¶ÅSY,¶ÉSY,¶ÍSY,¶ÐSY,¶ÓSY,¶×SY,¶ÚSY,¶ÝSY,¶àSY    ,¶ãSY
,¶æSY,¶éSY,¶ìSY ,¶ïSY,¶òSY,¶õSY,¶
5S¸ø¸þ:¶
¬&    _`    c"dGegfg”cœh4¢¢


¶·    ™

    œ




8¦
“-+ÀM
9N¸¿-½Y,¶ÉSY,¶ÅS¸ø¸þ:¶
¬mn    opo'q4--


(¶·    $

    '




;¦
š4+ÀM
<N¸¿-½Y,¶ÉSY,¶ÓSY,¶
5S¸ø¸þ:¶
¬uv    wx&w.y444


/¶·    +

    .




>¦
„&+ÀM
?N¸¿-½Y,¶
5S¸ø¸þ:¶
¬}~     €4&&


!¶·    

     




A
B
\
CL+¸¿
»
Y·
E¸
FM,°„…† 

    
²³

J
K
…'+À
LM
NN-¸¿½Y,¶
PS»
Y·
E¸
F:°‹    ”$–4''


"
Q
R    

    $²³

S
K
%Û+ÀM,¶
TN,¶
X:,¶
\:
`:
b:
d:
f:    ¶
h
`¶
k™»
Y¸
p·
¶
¶
/:§»
Y¸
p·
    ¶
¶
/:
r:

t:¶
v
`¶
k™»
Y¸
p·

¶
¶
/:§»
Y¸
p·
¶
¶
/:
y:
{: ¶
}
`¶
k™»
Y¸
p·
¶
¶
/:§»
Y¸
p·
 ¶
¶
/:
€:
‚:-¶
„¶
‰š»
Y¸
p·
¶
¶
/:§»
Y¸
p·
¶
¶
/:
:
:¶É
Ԧ
k™»
Y¸
p·
¶
¶
/:§»
Y¸
p·
¶
¶
/:
“:
•:¶é¶
‰d »
Y¸
p·
¶
¶
/:§@»
Y¸
p·
¶
¶
/:¶é¶
‰ 
—:»
Y¸
p·
¶
¶
/:
™:
›:¶
¶
‰š»
Y¸
p·
¶
¶
/:§»
Y¸
p·
¶
¶
/:
ž:
 :¶
¢
¥¶
k™»
Y¸
p·
¶
¶
/:§»
Y¸
p·
¶
¶
/:
§:
©:¶
Ǧ
¯•š»
Y¸
p·
¶
¶
/:§»
Y¸
p·
¶
¶
/:
µ:
·:¶
¹¶
¯•š»
Y¸
p·
¶
¶
/:§»
Y¸
p·
¶
¶
/:
¼:»
Y¸
p·
¶
¶
/:¸¿½Y¶
¾SY¶
ÁSY¶
ÄSY¶
ÇSY¶ÓSY¶
ÊSY¶
hSY¶
vSY¶
}SY    -¶
„SY
¶ÉSY¶éSY¶
SY »
Y
Í·
¶
¢¶

Ͷ
¶
/SY¶
«SY¶
¹S»
ÏY*·
Ѹ
F:°
r\›
žŸ ¡ ¨%©*ª8«N¬Q­g°l±q²³•´˜µ®¸³¹¸ºÆ»Ü¼ß½õÁúÅÿÊ
    Ë
Ì
"Í
8Ð
=Ñ
BÒ
PÓ
fÔ
iÕ
Ø
„Ù
‰Ú
–Û
†
¯Ý
ÅÞ
Ñà
Öá
ìå
ñæ
öç
èéê0í5î:ïHð^ñaòwõ|ö÷Žø¤ù§ú½ýÂþÇÿÔ
ê

í



#
*
    2

:
B
J
 R
[
d
m
v
~
‡

™
¸
Á
Ç
Ó
Ø
R
8ÛÛ


Ö´µ
Ñ
Ô
Õ˸¹Ŷ·À

     »
Ö
    %¶
×
    *±
Ø
        lo
Ù
    
qj
Ú
    ³(
Û
    ¸#
Ü
     úá
Ý
    ÿÜ
Þ
    
=ž
ß
    
B™
à
    
„W
á
    
‰R
â
    
Ö
ã
    
ñ
ê
ä
    
ö
å
å
    5
¦
æ
    :
¡
ç
    |
_
è
    
Z
é
    Â

ê
    Ç

ë
    Ó
ì
    Ø²³¼‚ÿQ


…‰
l
l
l
lý0
l
lý0
l
lý,
l
lý0
l
lý/
l
l<ý-
l
lý0
l
lý/
l
lý/
l
l    
í
î
ï

ð+
»
òY·
ôL»
&Y
õ·
÷M,
ø¶
úN,
þ¶
ú:,
ø¶
ú:,
þ¶
ú:»Y·:
‘¶:d¸%¶r¶N¶¶†»‰Y·‹:
`¶‘
`¶
`¶–
`¶¸%¶Ž
`¶
`¶¸¶¸¶-¸¶!¸¶$-¸¶'¸¶*»
…Y·-:        ¸%¶.»Y·:
 
¶™
¶
    ¶1+
¶5W±Š"
V
[
\
]$
^-
_6
a?
bG
cQ
dX
e_
fg
hp
ix
j€
kˆ
l
m™
n¡
o©
p²
q»
rÄ
sÎ
t×
uá
wê
xó
zü
{

|


}

~

p
78
9:


#
$þ;<$õ=<-ì><6ã?<?Ú¶·p©¸¹ê/
Ô
Õ    ü´µ
@AB


Ï