1

81041

2018-12-17 299f3a8a31cf05127b708b4985b8b0f4236a027b

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
Êþº¾2Þ
1com/fgkj/dao/impl/bts61850/BTS_61850_setparamImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
<init>
()V
Code
     

LineNumberTable
LocalVariableTable
this
3Lcom/fgkj/dao/impl/bts61850/BTS_61850_setparamImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
rs
Ljava/sql/ResultSet;
add
(Ljava/lang/Object;)Z
obj
Ljava/lang/Object;
update
com/fgkj/dto/BTS_61850_setparam
£update db_ram_db.tb_bts_61850_setparm set set_discurr=?,set_distime=?,set_discap=?,set_tep_dis=?,set_groupvol_low=?,set_monvollow=?,testcmd=?  where FBSDeviceId=? 
 "!
com/fgkj/db/DBUtil#$
getConn
()Ljava/sql/Connection;
&'(
getSet_discurr
()F
*,+
java/lang/Float-.
valueOf
(F)Ljava/lang/Float;
01(
getSet_distime
34(
 getSet_discap
67(
getSet_tep_dis
9:(
getSet_groupvol_low
<=(
getSet_monvollow
?@A

getTestcmd
()I
CED
java/lang/Integer-F
(I)Ljava/lang/Integer;
HIA
getFBSDeviceId
KML
com/fgkj/dao/DAOHelperNO
 executeUpdate
=(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
bts
!Lcom/fgkj/dto/BTS_61850_setparam;
sql
Ljava/lang/String;
bl

Z
del
    searchAll
()Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;\
com/fgkj/dto/BattInf^
iselect db_battinf.tb_battinf.battgroupid,db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.FBSDeviceIp,db_battinf.tb_battinf.BattGroupName,db_battinf.tb_battinf.MonCount,db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.MonCapStd,db_battinf.tb_battinf.GroupIndexInFBSDevice ,db_ram_db.tb_bts_61850_setparm.FBSDeviceId,db_ram_db.tb_bts_61850_setparm.batt_test,db_ram_db.tb_bts_61850_setparm.set_time,db_ram_db.tb_bts_61850_setparm.set_discurr,db_ram_db.tb_bts_61850_setparm.set_distime,db_ram_db.tb_bts_61850_setparm.set_discap,db_ram_db.tb_bts_61850_setparm.set_tep_dis,db_ram_db.tb_bts_61850_setparm.set_groupvol_low,db_ram_db.tb_bts_61850_setparm.set_monvollow,db_ram_db.tb_bts_61850_setparm.testcmd,db_ram_db.tb_bts_61850_state.stc_workstate,db_ram_db.tb_bts_61850_state.dev_captest_online,db_ram_db.tb_bts_61850_state.dev_captest_groupvol,db_ram_db.tb_bts_61850_state.dev_commcount,db_ram_db.tb_bts_61850_state.timelong  from db_battinf.tb_battinf  LEFT OUTER JOIN db_ram_db.tb_bts_61850_setparm on db_ram_db.tb_bts_61850_setparm.FBSDeviceId=db_battinf.tb_battinf.FBSDeviceId  LEFT OUTER JOIN db_ram_db.tb_bts_61850_state  on db_ram_db.tb_bts_61850_state.FBSDeviceId=db_battinf.tb_battinf.FBSDeviceId  where db_battinf.tb_battinf.StationName1 like ? and db_battinf.tb_battinf.StationName LIKE ?  and db_battinf.tb_battinf.battgroupid=?  `
java/lang/StringBuilderb

%
_d    e
(Ljava/lang/String;)V
[ghi
getStationName1
()Ljava/lang/String;
_klm
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
_opi
toString
[rsi
getStationName
[uvw
getBattGroupId
()Ljava/lang/Integer;y
3com/fgkj/dao/impl/bts61850/BTS_61850_setparamImpl$1
x{    |
6(Lcom/fgkj/dao/impl/bts61850/BTS_61850_setparamImpl;)V
K~€
executeQuery
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;
binf
Lcom/fgkj/dto/BattInf;
list
Ljava/util/List;
sendCmdTo61850Dev
(II)Zˆ
MUPDATE db_ram_db.tb_bts_61850_setparm  SET  batt_test=?  WHERE FBSDeviceId=? 
ŠŒ‹
java/lang/Boolean-
(Z)Ljava/lang/Boolean;
Š‘
booleanValue
()Z“
HSELECT batt_test FROM db_ram_db.tb_bts_61850_setparm  WHERE FBSDeviceId=
_•l–
(I)Ljava/lang/StringBuilder;˜š™
java/sql/Connection›œ
prepareStatement
0(Ljava/lang/String;)Ljava/sql/PreparedStatement;ž Ÿ
java/sql/PreparedStatement¡
()Ljava/sql/ResultSet;£¥¤
java/sql/ResultSet¦‘
next¨
    batt_test£ª«¬
getInt
(Ljava/lang/String;)I
®°¯
java/sql/SQLException±

printStackTraceú
µ·¶
java/lang/Thread¸¹
sleep
(J)V
»°¼
java/lang/InterruptedException
 ¾¿À
close
@(Ljava/sql/ResultSet;Ljava/sql/Statement;Ljava/sql/Connection;)V
cmd

I
dev_id
m_cmd
    m_cmd_ack
res_exe
Ljava/lang/Boolean;
conn
Ljava/sql/Connection;
ps
Ljava/sql/PreparedStatement;

n

e
Ljava/sql/SQLException;
 Ljava/lang/InterruptedException;
 StackMapTableÒ
java/lang/String
 serchbyDev_idÕ
ºselect db_battinf.tb_battinf.battgroupid,db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.FBSDeviceIp,db_battinf.tb_battinf.BattGroupName,db_battinf.tb_battinf.MonCount,db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.MonCapStd,db_battinf.tb_battinf.GroupIndexInFBSDevice ,db_ram_db.tb_bts_61850_setparm.FBSDeviceId,db_ram_db.tb_bts_61850_setparm.batt_test,db_ram_db.tb_bts_61850_setparm.set_time,db_ram_db.tb_bts_61850_setparm.set_discurr,db_ram_db.tb_bts_61850_setparm.set_distime,db_ram_db.tb_bts_61850_setparm.set_discap,db_ram_db.tb_bts_61850_setparm.set_tep_dis,db_ram_db.tb_bts_61850_setparm.set_groupvol_low,db_ram_db.tb_bts_61850_setparm.set_monvollow,db_ram_db.tb_bts_61850_setparm.testcmd from db_battinf.tb_battinf  LEFT OUTER JOIN db_ram_db.tb_bts_61850_setparm on db_ram_db.tb_bts_61850_setparm.FBSDeviceId=db_battinf.tb_battinf.FBSDeviceId  where  db_ram_db.tb_bts_61850_setparm.FBSDeviceId=? ×
3com/fgkj/dao/impl/bts61850/BTS_61850_setparamImpl$2
Ö{
bts_setparam
serchByInfo

SourceFile
BTS_61850_setparamImpl.java
InnerClasses!


    

/

*·±



6

°



6
¬



Õk+ÀMN¸-½Y,¶%¸)SY,¶/¸)SY,¶2¸)SY,¶5¸)SY,¶8¸)SY,¶;¸)SY,¶>¸BSY,¶G¸BS¸J6¬!"%&E'c%h(4kk
fPQcRShTU
V
6
¬
,

WX
,


°
1

YZ
»]+À[M]N-¸½Y»_Ya·c,¶f¶ja¶j¶nSY»_Ya·c,¶q¶ja¶j¶nSY,¶tS»xY*·z¸}:°67AZr4]]
X‚URSZƒ„
…†
` ç>6ª/(!d6§d6§e6§¬6‡:¸½Y¸BSY¸BS¸J¸‰:¶Ž™‚»_Y’·c¶”¶n:¸:
:    
:
6§O¹—:        ¹
:
 
¹¢
™
§¹© 6§$:¶­²¸´§
:¶º„
¡ÿ°
    ¸½¬ˆ·º®ÁÇÊ»‚ wxy z'{.|5}7:€>ƒ]„e†n‡r†wˆ|‰Š‚‹ˆŽ“œ¦’´”·•º˜¼šÁžÇŸÌ¡Ñ‹Û¤ä¦ŽççÁÂ
çÃÂåÄÂâÅÂ:­ÆU>©RS]ŠTÇ|hÈÉeÊË    ‚b
…V̼ÍÎÌÍÏÐ; ý 


ÿP





ÑŠ˜ž£
q®H»úø
ÓZ
ˆ*+ÀMÔN-¸½Y,¶G¸BS»ÖY*·Ø¸}:°ª«²'Û4**
%ÙQ"RS'ƒ„
ÚZ
6

°
à
ÛÜÝxÖ