Êþº¾ 4¦ )com/fgkj/dao/impl/BatttestdatastopDAOImpl java/lang/Object com/fgkj/dao/BaseDAO com/fgkj/dao/CallBack <init> ()V Code
|
|
LineNumberTable LocalVariableTable this +Lcom/fgkj/dao/impl/BatttestdatastopDAOImpl; add (Ljava/lang/Object;)Z java/util/List java/util/ArrayList
|
size ()I get (I)Ljava/lang/Object; " com/fgkj/dto/Batttestdata $ java/lang/StringBuilder & 1insert into db_batt_testdata.tb_batttestdatastop_
|
# ( ) (Ljava/lang/String;)V
|
! + , - getBattGroupId ()Ljava/lang/Integer;
|
# / 0 1 append -(Ljava/lang/Object;)Ljava/lang/StringBuilder; 3 ¶(BattGroupId,test_record_count,test_type,data_new,data_available,record_num,test_starttime,record_time,test_timelong,online_vol,group_vol,test_curr,test_cap,mon_num,mon_vol,mon_tmp)
|
# 5 0 6 -(Ljava/lang/String;)Ljava/lang/StringBuilder; 8
|
values( : ,
|
! < = - getTest_record_count
|
! ? @ - getTest_type
|
! B C - getData_new
|
! E F - getData_available
|
! H I - getRecord_num K ,' M O N com/fgkj/dao/DAOHelper P Q sdf Ljava/text/SimpleDateFormat;
|
! S T U getTest_starttime ()Ljava/util/Date;
|
W Y X java/text/SimpleDateFormat Z [ format $(Ljava/util/Date;)Ljava/lang/String; ] ','
|
! _ ` U getRecord_time b ',
|
! d e - getTest_timelong
|
! g h i getOnline_vol ()Ljava/lang/Float;
|
! k l i getGroup_vol
|
! n o i getTest_curr
|
! q r i getTest_cap
|
! t u -
|
getMon_num
|
! w x i
|
getMon_vol
|
! z { i
|
getMon_tmp } )
|
# toString ()Ljava/lang/String;
|
|
com/fgkj/db/DBUtil getConn ()Ljava/sql/Connection;
|
M makeManualCommit -(Ljava/sql/Connection;Ljava/util/ArrayList;)Z obj Ljava/lang/Object; list Ljava/util/List; sql_str Ljava/util/ArrayList; i I b Lcom/fgkj/dto/Batttestdata; sql Ljava/lang/String; bl Z LocalVariableTypeTable -Ljava/util/List<Lcom/fgkj/dto/Batttestdata;>; )Ljava/util/ArrayList<Ljava/lang/String;>; StackMapTable updatenew ¢ ,update db_batt_testdata.tb_batttestdatastop_ ¤ / set mon_tmp=? where mon_num=? and record_num=?
|
M ¦ § ¨ executeUpdate =(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z update « com/fgkj/test/Mon_vols
|
ª ® getBattggroupid
|
# ° 0 ± (I)Ljava/lang/StringBuilder; ³ 1 set online_vol=? ,group_vol=? where record_num=?
|
ª µ ¶ · getMon_vols ()F
|
¹ » º java/lang/Float ¼ ½ valueOf (F)Ljava/lang/Float;
|
ª ¿ I
|
Á Ã Â java/lang/Integer ¼ Ä (I)Ljava/lang/Integer; ms Lcom/fgkj/test/Mon_vols; del É com/fgkj/dto/Batttestdatastop Ë 1delete from db_batt_testdata.tb_batttestdatastop_
|
È + Î . where battgroupid=? and test_record_count=?
|
È <
|
Ñ Ó Ò java/lang/Boolean ¼ Ô (Z)Ljava/lang/Boolean;
|
Ñ Ö × Ø booleanValue ()Z tstop Lcom/fgkj/dto/Batttestdatastop; Ljava/lang/Boolean; searchAll ()Ljava/util/List; serchByCondition $(Ljava/lang/Object;)Ljava/util/List; á Öselect num,BattGroupId,test_record_count,test_type,data_new,data_available,record_num,test_starttime,record_time,test_timelong,group_vol,test_curr,test_cap,mon_num,mon_vol from db_batt_testdata.tb_batttestdatastop_ ã where test_record_count=?
|
|
M æ ç è executeQuery c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List; btd serchByInfo
|
getResults &(Ljava/sql/ResultSet;)Ljava/util/List;
|
È ï num ñ ó ò java/sql/ResultSet ô õ getInt (Ljava/lang/String;)I
|
È ÷ ø ù setNum (Ljava/lang/Integer;)V û BattGroupId
|
È ý þ ù setBattGroupId test_record_count
|
È ù setTest_record_count test_type
|
È ù setTest_type
|
data_new
|
È ù setData_new data_available
|
È ù setData_available
|
record_num
|
È ù setRecord_num test_starttime ñ getTimestamp ((Ljava/lang/String;)Ljava/sql/Timestamp;
|
È ! setTest_starttime (Ljava/util/Date;)V# record_time
|
È% &! setRecord_time( test_timelong
|
È* + ù setTest_timelong- group_vol ñ/ 01 getFloat (Ljava/lang/String;)F
|
È3 45 setGroup_vol (Ljava/lang/Float;)V7 test_curr
|
È9 :5 setTest_curr< test_cap
|
È> ?5 setTest_capA mon_num
|
ÈC D ù
|
setMon_numF mon_vol
|
ÈH I5
|
setMon_vol ñL M Ø next
|
OQP java/sql/SQLException R
|
printStackTrace rs Ljava/sql/ResultSet; bs e Ljava/sql/SQLException; serchByMonNum
|
È t
|
Á[ \ intValue^ > where battgroupid=? and mon_num!=? and test_record_count=? ` * and db_batt_testdata.tb_batttestdatastop_b .data_available=1 d ×select num,BattGroupId,test_record_count,test_type,data_new,data_available,record_num,test_starttime,record_time,test_timelong,group_vol, test_curr,test_cap,mon_num,mon_vol from db_batt_testdata.tb_batttestdatastop_f < where battgroupid=? and mon_num=? and test_record_count=? h java/lang/String serchByLowNewk Mselect battgroupid,mon_num,mon_vol from db_batt_testdata.tb_batttestdatastop_m R where mon_vol<=? *(select avg(mon_vol) from db_batt_testdata.tb_batttestdatastop_o % where battgroupid=?) and data_new=1 q 6.data_available=1 and test_cap<? order by battgroupid
|
Ès t i getLowV
|
Èv w i getLowCy +com/fgkj/dao/impl/BatttestdatastopDAOImpl$1
|
x{ | .(Lcom/fgkj/dao/impl/BatttestdatastopDAOImpl;)V serchByType where test_cap>? &.data_available=1 order by battgroupid +com/fgkj/dao/impl/BatttestdatastopDAOImpl$2
|
{
|
serchByLow iselect distinct battGroupId,test_curr,test_cap,mon_num,mon_vol from db_batt_testdata.tb_batttestdatastop_ where test_record_count=? +com/fgkj/dao/impl/BatttestdatastopDAOImpl$3
|
{
|
È n
|
¹ ·
|
floatValue
|
È q
|
È i
|
getMon_max
|
È w
|
com/fgkj/dao/BattCapFactory GetHourRate (DD)I CapType_Real
|
¡¢ GetMonomerCap
|
(DIDDDDI)D
|
¤ ¥¦
|
JudgeAlarm (DFFD)I realCap D STDAH hourRate current SumAH MaxMonomerVol
|
MonomerVol MonomerVolType flag sumVol F listB 1Ljava/util/List<Lcom/fgkj/dto/Batttestdatastop;>; serch· Qselect avg(binary mon_vol) as mon_avg from db_batt_testdata.tb_batttestdatastop_¹ order by battgroupid» +com/fgkj/dao/impl/BatttestdatastopDAOImpl$4
|
º{
|
serchByCap¿
select battgroupid,max(test_cap) as max,min(test_cap) as min,avg(test_cap) as avg,test_cap from db_batt_testdata.tb_batttestdatastop_Á Ã , where db_batt_testdata.tb_batttestdatastop_Å .data_available=1Ç order by test_starttime descÉ +com/fgkj/dao/impl/BatttestdatastopDAOImpl$5
|
È{ serchBadBattÍ com/fgkj/dto/Batt_Maint_Dealarm
|
ÌÏ ÐÑ getBinf ()Lcom/fgkj/dto/BattInf;
|
ÌÓ ÔÕ getTdata !()Lcom/fgkj/dto/Batttestdata_inf;× Øselect num,BattGroupId,test_record_count,test_type,data_new,data_available,record_num,test_starttime,record_time,test_timelong,group_vol, test_curr,test_cap,mon_num,mon_vol from db_batt_testdata.tb_batttestdatastop_
|
Ù +Ú com/fgkj/dto/Batttestdata_infÜ where Þ (test_record_count=? and record_time=?
|
Ù <
|
Ù _â +com/fgkj/dao/impl/BatttestdatastopDAOImpl$6
|
á{å com/fgkj/dto/Alarm_param
|
ä Ðâ
|
äé ê ù setAlm_idì !com/fgkj/dao/impl/Alarm_paramImpl
|
ë
|
ëï Þ ß
|
äñ ò i getAlm_low_coe
|
äô õ - getAlm_low_level Ðã
|
øúù com/fgkj/dto/BattInf û i getMonCapStd
|
øý þ i getMonVolStd
|
Ì getSdata !()Lcom/fgkj/dto/Batttestdatastop;
|
Ù i getMax_monvol?fff %com/fgkj/dao/impl/BatttestdataDAOImpl
|
|
serchRealCap (Ljava/lang/Object;)F
|
Ì setBinf (Lcom/fgkj/dto/BattInf;)V
|
g ¼ (D)Ljava/lang/String;
|
¹ 1
|
parseFloat bmd !Lcom/fgkj/dto/Batt_Maint_Dealarm; binf Lcom/fgkj/dto/BattInf; tdata Lcom/fgkj/dto/Batttestdata_inf; sdata param Caplevel Changelevel aparam Lcom/fgkj/dto/Alarm_param; listA Cparam listC 3Ljava/util/List<Lcom/fgkj/dto/Batt_Maint_Dealarm;>; ,Ljava/util/List<Lcom/fgkj/dto/Alarm_param;>; serchMakeGroup 6(Ljava/lang/Object;Ljava/lang/Object;)Ljava/util/List;
|
ø, -. getObj ()Ljava/lang/Object;0 +com/fgkj/dao/impl/BatttestdatastopDAOImpl$7
|
/{
|
ø3 4 getBattProducer
|
È6 7 ) setNote9 com/fgkj/dto/BattInf_Rebuild
|
8; < getOld_monum
|
8> ? getOld_battgroupid
|
8A B getNew_monum
|
8D E getNew_battgroupid
|
8G H getOld_battproducer
|
ÈJ KL
|
setPercent (F)V obj1 obj2 listr tinf j brinf Lcom/fgkj/dto/BattInf_Rebuild; serchRealCapByMon_num (Ljava/lang/Object;)DW -select db_batt_testdata.tb_batttestdatastop_
|
ø +Z .battgroupid\ &,db_batt_testdata.tb_batttestdatastop_^
|
.test_curr` .test_capb .mon_vold .test_record_count f .mon_numh 1,db_batt_testdata.tb_batttestdata_inf.max_monvol j + from db_batt_testdata.tb_batttestdatastop_l ',db_batt_testdata.tb_batttestdata_inf n =.BattGroupId=db_batt_testdata.tb_batttestdata_inf.BattGroupIdp C.test_starttime=db_batt_testdata.tb_batttestdata_inf.test_starttimer .mon_num=? t 7 and db_batt_testdata.tb_batttestdata_inf.test_type=3 v / order by db_batt_testdata.tb_batttestdatastop_x .test_starttime desc z limit 1
|
ø| } - getMonNum +com/fgkj/dao/impl/BatttestdatastopDAOImpl$8
|
~{
|
È k main ([Ljava/lang/String;)V BA
|
½ ß iterator ()Ljava/util/Iterator; java/util/Iterator M. java/lang/System out Ljava/io/PrintStream;
|
java/io/PrintStream println (Ljava/lang/Object;)V Ø hasNext args [Ljava/lang/String; btds bi
|
SourceFile BatttestdatastopDAOImpl.java InnerClasses !
|
/ *· ± J+À M» Y· N,Æ0,¹ '6§,¹ À !:» #Y%· '¶ *¶ .2¶ 47¶ 4¶ *¶ .9¶ 4¶ ;¶ .9¶ 4¶ >¶ .9¶ 4¶ A¶ .9¶ 4¶ D¶ .9¶ 4¶ G¶ .J¶ 4² L¶ R¶ V¶ 4\¶ 4² L¶ ^¶ V¶ 4a¶ 4¶ c¶ .9¶ 4¶ f¶ .9¶ 4¶ j¶ .9¶ 4¶ m¶ .9¶ 4¶ p¶ .9¶ 4¶ s¶ .9¶ 4¶ v¶ .9¶ 4¶ y¶ .|¶ 4¶ ~:-¶ W,¹ ¡þå¸ -¸ 6¬ 2 ! " - # C $$ #) %0 !> (G ) R J J E = ! - ) G E = þ ûú
|
¡ C+À !M» #Y¡· ',¶ *¶ .£¶ 4¶ ~N¸ -½ Y,¶ ySY,¶ sSY,¶ GS¸ ¥6¬ , - . @ / 4 C C > % @ © ª L+À ªM» #Y¡· ',¶ ¬¶ ¯²¶ 4¶ ~N¸ -½ Y,¶ ´¸ ¸SY,¶ ´¸ ¸SY,¶ ¾¸ ÀS¸ ¥6¬ 3 4 5 I 6 4 L L G Å Æ . I Ç ° B+À ÈM» #YÊ· ',¶ ̶ .Ͷ 4¶ ~N¸ -½ Y,¶ ÌSY,¶ ÏS¸ ¥¸ Ð:¶ Õ¬ " ; < = < ? " @ 4 > < A 4 B B = Ù Ú $ < Û Ü Ý , ° F Þ ß 8+À ÈM» #Yà· ',¶ ̶ .ⶠ4¶ ~N-¸ ½ Y,¶ ÏS» Y· ä¸ å° J L M L O * 8 8 3 é Ú ê ß 6 ° S ë ì Ý » Y· M§ ú» ÈY· íN-+î¹ ð ¸ À¶ ö-+ú¹ ð ¸ À¶ ü-+ÿ¹ ð ¸ À¶-+¹ ð ¸ À¶-+ ¹ ð ¸ À¶ -+¹ ð ¸ À¶-+¹ ð ¸ À¶-+¹ ¶ -+"¹ ¶$-+'¹ ð ¸ À¶)-+,¹. ¸ ¸¶2-+6¹. ¸ ¸¶8-+;¹. ¸ ¸¶=-+@¹ ð ¸ À¶B-+E¹. ¸ ¸¶G,-¹J W+¹K ÿ§ N-¶N,° O ^ W Y Z [ " \ 1 ] @ ^ P _ ` ` p a b c d ª e º f Ê g Ú h ê i ú j Y m n p 4 ST ïU Ú VW ü û öKO X ß K ¤+À ÈMN» Y· :,¶Y¶Z 3» #Yà· ',¶ ̶ .]¶ 4_¶ 4,¶ ̶ .a¶ 4¶ ~N§ 1» #Yc· ',¶ ̶ .e¶ 4_¶ 4,¶ ̶ .a¶ 4¶ ~N-¸ ½ Y,¶ ÌSY,¶YSY,¶ ÏS» Y· ä¸ å:° F u v w x y # z * { 0 | C y G ~ J T [ a t x ¡
4 ¤ ¤ é Ú þ J Èg - i ß Á i+À ÈM» #Yj· ',¶ ̶ .l¶ 4,¶ ̶ .n¶ 4_¶ 4,¶ ̶ .p¶ 4¶ ~N-¸ ½ Y,¶rSY,¶ ÌSY,¶uS»xY*·z¸ å° ) < @ * i i d é Ú @ ) } ß ¦ N+À ÈM» #Yj· ',¶ ̶ .~¶ 4_¶ 4,¶ ̶ .¶ 4¶ ~N-¸ ½ Y,¶uS»Y*·¸ å° ¥ § ¨ / § 3 ª * N N I é Ú 3
ß ü e+À ÈM» #Y· ',¶ ̶ .¶ 4_¶ 4,¶ ̶ .a¶ 4¶ ~N-¸ ½ Y,¶ ÏS»Y*·¸ å:996 9
|
9 9996 8» Y· :Æ ê¹ à6§ Î,¶¶9,¶¶9¹ À ȶ¶9
|
¹ À ȶ¶9 ,¶¶9¹ À ȶ¶9c8
|
¸6 ²¸9,¶u¶,¶r¶¸£6 +¹ À ȸ ¸¶2¹ ¹J W6¹ ¡ÿ,° # ¿ À Á  / À 3 à O × R Ø U Ù X Ú [ Û ^ Ü a Ý d Þ g ß j à m á v â
ã ä å æ ´ ç É è Ó é è ê ñ ë ú ì í% î+ ï? ðP ôS ãb ÷ ¬ e e ` é Ú 32 O R§¨ U©¨ X ª [
|
Ǭ
|
^¬¨ a¨ d®¨ g þ¯¨ j û° m ø±² v ï³ Ú O ´ - ÿ Èg û Çú µ ß ° T+À ÈM» #Y¶· ',¶ ̶ .¶ 4_¶ 4,¶ ̶ .a¶ 4¸¶ 4¶ ~N-¸ ½ Y,¶ ÏS»ºY*·¼¸ å° û ý þ / ÿ 5 ý 9 * T T O é Ú 9 ½ ß ¸ N+À ÈM» #Y¾· ',¶ ̶ .À¶ 4¶ 4,¶ ̶ .Ķ 4ƶ 4¶ ~N-¸ »ÈY*·Ê¸ å:° / 5 9 K. 4 N N I é Ú 9 K Ë ß D ! v+ÀÌM,¶ÎN,¶Ò:» ÈY· í:» #YÖ· '¶Ø¶ .À¶ 4Û¶ 4ݶ 4_¶ 4¶Ø¶ .a¶ 4¶ ~:¸ ½ Y¶ßSY¶àS»áY*·ã¸ å:9 8
|
6 6 »äY·æ: ç¸ À¶è»ëY·í ¶î:Æ C¹ 9¹ d¹ Àä¶ð¶8
|
¹ d¹ Àä¶ó¶Z6 8 ö¸ À¶è»ëY·í ¶î:Æ C¹ 9¹ d¹ Àä¶ð¶8¹ d¹ Àä¶ó¶Z6 9699999 6 » Y· : Æ ¹ ö6 §ä-¶÷¶9-¶ü¶9 ¹ À̶ÿ¶¶9 ¹ À̶ÿ¶¶9¶¶9 ¹ À̶ÿ¶¶9¸6 ¹ À̶ÿ¶¶-¶ü¶j ²¸9§ ? ¹ À̶ÿ-¶ü¶j¸ ¸¶G»Y· ¹ À̶ÿ¶
|
9
|
¸£6 ç ¹ À̶ÿ ¸ À¶ ö ¹ ÀÌ-¶ ç Q ¹ À̶ÿ ¸ À¶ ¹ À̶ÿ¸ À¶ ¹ À̶ÿ¸¸¸ ¸¶=§ V ö N ¹ À̶ÿ ¸ À¶ ¹ À̶ÿ¸ À¶ ¹ À̶ÿ¸¸¸ ¸¶= ¹ ¹J W6 ¹ ¡þ °
|
B 3 4
|
5 7 8 #: 1; 7< == Q8 V@ |f g h
i j k l ªm ¹n Ôo ïq òr ýs tu5vPySzV{Y|\}_~behq
²ÊÕíö.1Qmz§¯ÆÝú 3Pa£ds¦ v v q
|
l f ] Ú V |ú ÷§¨ ô ²
|
ñ î! å"# ªÌ$ ò%² k& S#©¨ V ª Y «¨ \¬¨ _¨ b®¨ e¯¨ h° q³ ð |ú ' ªÌ$( k&( z
|
ÿ ï ÌøÙ Èg ä ý ` ÿ 5 ÌøÙ Èg ä û ª;û û Rú )*
|
û+ÀøN-¶+À :,ÀÙ:» #YÖ· '¶Ø¶ .À¶ 4Û¶ 4ݶ 4_¶ 4¶Ø¶ .a¶ 4¶ ~:¸ ½ Y¶ßSY¶àS»/Y*·1¸ å:99
|
6 9 99996Æd¹ Z6§H¹ À È:-¶2¶56§ m¹ À8:¶Y¶Z¶: ¶ ̶Z¶= ¸ À¶B§ ?¶Y¶Z¶@ ¶ ̶Z¶C ¶F¶5§ ¹ ¡ÿ-¶÷¶9
|
-¶ü¶9¶¶9 ¶¶9¶¶9¶¶9
|
¸6 ¶¶-¶ü¶j
|
²¸9§ %-¶ü¶j¸ ¸¶G»Y· ¶
|
9¸ ¸¶=
|
o¶I¹ ¡þ²°  0 ª « ¬ ¯ ,° 2± 8² L Q´ wÔ zÕ }Ö × Ø Ù Ú Û Ü Ý ¡Þ §ß µà ¾á Äâ Òã òä ûå þç è(é+á:ìDíNïYðdñoòzóôõ®ö±÷ÄøÓúÞûéÞøþ Ô û ûM ûN ö íO çP Qª w z§¨ }~©¨
|
{ª x«¨ u¬¨ r¨ o®¨ l¯¨ i° ¤T µ4 Ú Á yQ Ò YRS w ´ I
|
ÿ § ø Ùg ý Èü 98ú ,ú û v!ú ú TU á =+ÀøM» #YV· ',¶X¶ .Y¶ 4[¶ 4,¶X¶ .]¶ 4[¶ 4,¶X¶ ._¶ 4[¶ 4,¶X¶ .a¶ 4[¶ 4,¶X¶ .c¶ 4[¶ 4,¶X¶ .e¶ 4g¶ 4i¶ 4,¶X¶ .k¶ 4¶ 4,¶X¶ .m¶ 4_¶ 4,¶X¶ .o¶ 4_¶ 4,¶X¶ .q¶ 4_¶ 4,¶X¶ .a¶ 4s¶ 4u¶ 4,¶X¶ .w¶ 4y¶ 4¶ ~N-¸ ½ Y,¶{S»~Y*·¸ å:996 9
|
9 9996Æ þ¹ ô6§ â,¶÷¶9,¶ü¶9¹ À ȶ¶9
|
¹ À ȶ¶9 ¹ À ȶ¶9¹ À ȶ¶9
|
¸6 ¹ À ȶ¶,¶ü¶j ²¸9§ 6¹ À È,¶ü¶j¸ ¸¶G»Y· ¹ ¶
|
9¹ ¡ÿ¯ ² , / B U h {
|
§ º Í à æ ù ÿ ,"-%.(/+0.1124374:5I6O7Y8c:x;<¢=·>À?á@õAøBC+6:G = = 8 : "§¨ %©¨ (ª +«¨
|
.¬¨ 1 ¨ 4 ®¨ 7¯¨ :° L î ´ * ÿO øg û ¨2ú ö R» ÈY· íL+¸ À¶ ü+¸ À¶» Y· äM,+¶
N-¹ :§ ¹ À È:²¶¹ ÿå± & K L M N "P (Q ?R GQ QU 4 R J Ú " 0¡ ( * ? Ú ( * ´ ÿ 3 ¢ È £ ¤¥ B x º È á / ~
|
