修改版本号

hdw

2018-12-18 a331497081c4756a822dce1fa8708a0bd0a72ce7

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

LineNumberTable
LocalVariableTable
this
%Lcom/fgkj/dao/impl/Ld9/LD9_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,dev_id,sys_state,sys_online_vol,sys_group_vol, sys_now_battnum,sys_now_battstate,sys_now_battvol,sys_now_battcurr, sys_now_battcap,sys_now_testtime,dev_commcount,dev_errcommcount  from db_ram_db.tb_ld9_state  order by sys_now_battnum
!#"
com/fgkj/db/DBUtil$%
getConn
()Ljava/sql/Connection;'
%com/fgkj/dao/impl/Ld9/LD9_stateImpl$1
&)    *
((Lcom/fgkj/dao/impl/Ld9/LD9_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/LD9_state
7:;<
getPage
()Lcom/fgkj/dto/Page;>
 SELECT FOUND_ROWS() number@
B
Jselect SQL_CALC_FOUND_ROWS distinct db_ram_db.tb_ld9_state.num,db_ram_db.tb_ld9_state.dev_ip,db_ram_db.tb_ld9_state.dev_id,db_ram_db.tb_ld9_state.dev_version,db_ram_db.tb_ld9_state.sys_state,db_ram_db.tb_ld9_state.sys_stop_reason,db_ram_db.tb_ld9_state.dev_commcount,db_ram_db.tb_ld9_state.dev_errcommcount,db_ram_db.tb_ld9_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_ld9_state left outer join db_battinf.tb_battinf ON db_ram_db.tb_ld9_state.dev_id=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
2 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
( GROUP BY db_ram_db.tb_ld9_state.dev_id 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{
%com/fgkj/dao/impl/Ld9/LD9_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
ld9
Lcom/fgkj/dto/LD9_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
LD9_stateImpl.java
InnerClasses!

    

/

*·±



6

°



6
¬



6
¬
 


6
¬
%


\L+¸ 
»&Y*·(¸+M,°).K 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¹À“-¶•°jTU
VWXYcd#e'f.gDhOiejhk~n‚t˜vœx z»}øž

Ÿ
 
¡
0£¢
3
3

.™š

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

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

®6
6

°
¨
¯°±&z