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

LineNumberTable
LocalVariableTable
this
0Lcom/fgkj/dao/impl/bts61850/BTS_61850_stateImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
rs
Ljava/sql/ResultSet;
add
(Ljava/lang/Object;)Z
obj
Ljava/lang/Object;
update
del
    searchAll
()Ljava/util/List;

. select num,FBSDeviceId,stc_datatime,stc_groupvol_low,stc_cap_high, stc_timespan_high,stc_discurr,stc_monvol_low,stc_montmp_high, stc_workstate,alam_tmp,alam_comm,alam_relay,dev_captest_online,dev_captest_groupvol, dev_errcommcount,dev_commcount  from db_ram_db.tb_bts_61850_state  order by FBSDeviceId
!#"
com/fgkj/db/DBUtil$%
getConn
()Ljava/sql/Connection;'
0com/fgkj/dao/impl/bts61850/BTS_61850_stateImpl$1
&)    *
3(Lcom/fgkj/dao/impl/bts61850/BTS_61850_stateImpl;)V
,.-
com/fgkj/dao/DAOHelper/0
executeQuery
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;
sql
Ljava/lang/String;
list
Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;8
com/fgkj/dto/BTS_61850_state
7:;<
getPage
()Lcom/fgkj/dto/Page;>
 SELECT FOUND_ROWS() number@
B
Ýselect SQL_CALC_FOUND_ROWS distinct db_ram_db.tb_bts_61850_state.num,db_ram_db.tb_bts_61850_state.dev_ip,db_ram_db.tb_bts_61850_state.fBSDeviceId,db_ram_db.tb_bts_61850_state.alam_tmp,db_ram_db.tb_bts_61850_state.alam_relay,db_ram_db.tb_bts_61850_state.alam_comm,db_ram_db.tb_bts_61850_state.stc_workstate,db_ram_db.tb_bts_61850_state.dev_commcount,db_ram_db.tb_bts_61850_state.dev_errcommcount,db_ram_db.tb_bts_61850_state.dev_ip,db_ram_db.tb_bts_61850_state.timelong, db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName,COUNT(DISTINCT db_battinf.tb_battinf.BattGroupId) as cnt,group_CONCAT(db_ram_db.tb_batt_rtstate.online_vol ORDER BY db_ram_db.tb_batt_rtstate.BattGroupId separator '/') as online_vols,group_CONCAT(db_ram_db.tb_batt_rtstate.group_vol ORDER BY db_ram_db.tb_batt_rtstate.BattGroupId separator '/') as group_vols,group_CONCAT(db_ram_db.tb_batt_rtstate.group_curr ORDER BY db_ram_db.tb_batt_rtstate.BattGroupId separator '/') as group_currs  from db_ram_db.tb_bts_61850_state left outer join db_battinf.tb_battinf ON db_ram_db.tb_bts_61850_state.fBSDeviceId=db_battinf.tb_battinf.FBSDeviceId  LEFT OUTER JOIN db_ram_db.tb_batt_rtstate ON db_battinf.tb_battinf.battgroupid=db_ram_db.tb_batt_rtstate.battgroupid D
 where dev_errcommcount=0  F
 where dev_errcommcount>0  H
 where dev_errcommcount>-1  
7JKL
getDev_errcommcount
()IN
java/lang/StringBuilder
PRQ
java/lang/StringST
valueOf
&(Ljava/lang/Object;)Ljava/lang/String;
MV    W
(Ljava/lang/String;)V
MYZ[
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
M]^_
toString
()Ljava/lang/String;a
0 and db_battinf.tb_battinf.StationId in(select distinct db_battinf.tb_battinf.StationId  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=? ) c
3 GROUP BY db_ram_db.tb_bts_61850_state.fBSDeviceId e
 limit ?,? 
7ghL
getNum
jlk
java/lang/IntegerSm
(I)Ljava/lang/Integer;
oqp
com/fgkj/dto/Pagers
getPageCurr
()Ljava/lang/Integer;
juvL
intValue
oxys
getPageSize{
0com/fgkj/dao/impl/bts61850/BTS_61850_stateImpl$2
z)
,~0
executeQueryLimit
ƒ‚
com/fgkj/dao/LimitNumberFactory„…
GetLimtitNumber
*(Ljava/sql/Connection;Ljava/lang/String;)I‡‰ˆ
java/util/ListŠL
size
oŒŽ

setPageAll
(Ljava/lang/Integer;)V‡‘’
get
(I)Ljava/lang/Object;”
com/fgkj/dto/ram/Fbs9100_state
“–—˜
setPage
(Lcom/fgkj/dto/Page;)V
bts
Lcom/fgkj/dto/BTS_61850_state;
page
Lcom/fgkj/dto/Page;
conn
Ljava/sql/Connection;
    numberSql
baseSql
comSqlT
comSqlF
comSqlA

stationSql
groupSql
limitSql
number

I
LocalVariableTypeTable
2Ljava/util/List<Lcom/fgkj/dto/ram/Fbs9100_state;>;
 StackMapTable­
java/sql/Connection
serchByInfo

SourceFile
BTS_61850_stateImpl.java
InnerClasses!

    

/

*·±



6

°



6
¬



6
¬
#


6
¬
(


\L+¸ 
»&Y*·(¸+M,°-3T 12
34
56
Ð
3+À7M,¶9N¸ :=:?:A:C:E:    G:
,¶Iš»MY¸O·U¶X¶\:§:,¶I »MY¸O·U    ¶X¶\:§»MY¸O·U
¶X¶\:`:»MY¸O·U¶X¶\:b:d: »MY¸O·U¶X ¶X¶\:½Y,¶f¸iSY-¶n¶td-¶w¶th¸iSY-¶wS»zY*·|¸}:¸€6Æ-¹†
ž#-¸i¶‹¹†
d¹À“-¶•°j]^
_`abmn#o'p.qDrOsethu~x‚~˜€œ‚ „»‡øº

»
¼
½
0¿¢
3
3

.™š

)›œ
$ž
 Ÿ2
12
 2
¡2#
¢2    '
£2
‚±¤2œ—¥2 “¦2 ø;34

2§¨©
ø;3ª«aÿG
7o¬PPPPPP ÿ±
7o¬PPPPPPPPP‡

®6
6

°
Ã
¯°±&z