From ea9db400a73b5471184c82eb9fde24aacd6d26d1 Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期六, 05 一月 2019 10:15:00 +0800
Subject: [PATCH] 批量设置修改时常
---
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$4.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$10.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$11.class | 0
gx_tieta/src/com/fgkj/services/ram/Fbs9100_stateService.java | 15 +++++++
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$3.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/services/ram/Fbs9100_stateService.class | 0
gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java | 2
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$5.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$2.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$6.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$1.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$7.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/actions/ram/Fbs9100_stateAction.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$12.class | 0
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$9.class | 0
gx_tieta/src/com/fgkj/actions/ram/Fbs9100_stateAction.java | 7 +++
gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java | 95 +++++++++++++++++++++++++++++++++++++++++++++--
gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$8.class | 0
19 files changed, 112 insertions(+), 7 deletions(-)
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/actions/ram/Fbs9100_stateAction.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/actions/ram/Fbs9100_stateAction.class
index 983fe7c..d5ae663 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/actions/ram/Fbs9100_stateAction.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/actions/ram/Fbs9100_stateAction.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$1.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$1.class
index ccf5932..8997924 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$1.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$1.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$10.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$10.class
index a6db228..55fd576 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$10.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$10.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$11.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$11.class
index fac1abc..dd21e7b 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$11.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$11.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$12.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$12.class
index d44143e..96f6ce6 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$12.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$12.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$2.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$2.class
index 42fddd1..229d860 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$2.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$2.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$3.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$3.class
index d93e0b2..7eda94a 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$3.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$3.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$4.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$4.class
index a9dcf31..188dc1a 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$4.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$4.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$5.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$5.class
index 9657a6f..580ea55 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$5.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$5.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$6.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$6.class
index 5772fe4..7ce8763 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$6.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$6.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$7.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$7.class
index 034f443..0f1a590 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$7.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$7.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$8.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$8.class
index a893bdf..bada21a 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$8.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$8.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$9.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$9.class
index e28a334..ba1c49a 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$9.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl$9.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.class
index 8342a0e..4d80d4c 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.class
Binary files differ
diff --git a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/services/ram/Fbs9100_stateService.class b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/services/ram/Fbs9100_stateService.class
index 8b64fbc..9e256c5 100644
--- a/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/services/ram/Fbs9100_stateService.class
+++ b/gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/services/ram/Fbs9100_stateService.class
Binary files differ
diff --git a/gx_tieta/src/com/fgkj/actions/ram/Fbs9100_stateAction.java b/gx_tieta/src/com/fgkj/actions/ram/Fbs9100_stateAction.java
index 93136fa..a303de8 100644
--- a/gx_tieta/src/com/fgkj/actions/ram/Fbs9100_stateAction.java
+++ b/gx_tieta/src/com/fgkj/actions/ram/Fbs9100_stateAction.java
@@ -118,6 +118,13 @@
result = tojson(model);
return SUCCESS;
}
+ //瀹炴椂鍒锋柊鎵归噺璁剧疆鏀剧數鍙傛暟
+ public String freshenDischarge(){
+ List list=getGson().fromJson(json,new TypeToken<List<BattInf>>(){}.getType());
+ ServiceModel model = service.freshenDischarge(list);
+ result = tojson(model);
+ return SUCCESS;
+ }
//11.1FBS9100璁惧閫氫俊鐘舵�佹煡璇� <-- 璺ㄥ煙 -->
public String serchByCondition_ky(){
//isAllowHeaders(); //鍏佽璺ㄥ煙璁块棶
diff --git a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
index 3c2f22b..e2c4b09 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
@@ -4487,7 +4487,7 @@
}*/
return list;
}
-
+
public static void main(String[] args) throws ParseException {
//new BattInfImpl().searchAll();
diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java
index 06b95ee..ea67d8e 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java
@@ -21,6 +21,7 @@
import com.fgkj.dto.ram.Fbs9600_state;
import com.fgkj.services.User_logService;
import com.sun.corba.se.spi.orbutil.fsm.FSM;
+import com.sun.org.apache.bcel.internal.generic.LSTORE;
public class Fbs9100_stateImpl implements BaseDAO,CallBack{
public List getResults(ResultSet rs) {
@@ -895,7 +896,7 @@
String sql="select distinct dev_id,dev_alarmstate,dev_workstate,dev_temp,dev_version,dev_res_test_state,dev_testtype,dev_testgroupnum "
+ ",dev_captest_onlinevol,dev_captest_groupvol,dev_captest_curr,dev_captest_cap,dev_captest_timelong "
+ ",dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type "
- + ",db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.StationName1,db_battinf.tb_battinf.StationName2,db_battinf.tb_battinf.StationName3,db_battinf.tb_battinf.StationName5 "
+ + ",db_battinf.tb_battinf.battgroupid,db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.StationName1,db_battinf.tb_battinf.StationName2,db_battinf.tb_battinf.StationName3,db_battinf.tb_battinf.StationName5 "
+ ",db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.BattGroupId,db_battinf.tb_battinf.battgroupname,db_battinf.tb_battinf.moncapstd,db_battinf.tb_battinf.moncount "
+ " from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr "
+ " where dev_workstate="+FBS9100_ComBase.DISCHARGE
@@ -948,7 +949,7 @@
fstate.setDev_captest_curr(rs.getFloat("dev_captest_curr"));
fstate.setDev_captest_cap(rs.getFloat("dev_captest_cap"));
fstate.setDev_captest_timelong(rs.getInt("dev_captest_timelong"));
-
+ fstate.setBattgroupid(rs.getInt("battgroupid"));
fstate.setDev_conresist(rs.getFloat("dev_conresist"));
fstate.setDev_concurr(rs.getFloat("dev_concurr"));
fstate.setDev_condcurr(rs.getFloat("dev_condcurr"));
@@ -977,6 +978,86 @@
});
return list;
}
+ //瀹炴椂鍒锋柊鎵归噺璁剧疆鏀剧數鍙傛暟
+ public List freshenDischarge(Object obj) {
+ List<BattInf> list=(List<BattInf>) obj;
+ List listAll=new ArrayList();
+ for (int i = 0; i < list.size(); i++) {
+ BattInf binf=list.get(i);
+ String sql="select distinct dev_id,dev_alarmstate,dev_workstate,dev_temp,dev_res_test_state,dev_testtype,dev_testgroupnum " +
+ " ,dev_captest_onlinevol,dev_captest_groupvol,dev_captest_curr,dev_captest_cap,dev_captest_timelong" +
+ " ,dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type " +
+ " ,db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.StationName1,db_battinf.tb_battinf.StationName2,db_battinf.tb_battinf.StationName3,db_battinf.tb_battinf.StationName5,db_battinf.tb_battinf.FbsDeviceName " +
+ " ,db_ram_db.tb_batt_rtstate.batt_test_tlong " +//,db_ram_db.tb_batt_rtstate.group_curr,db_ram_db.tb_batt_rtstate.group_vol
+ " from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf ,db_ram_db.tb_batt_rtstate"+
+ " where db_battinf.tb_battinf.battgroupid=? "+
+ " and db_battinf.tb_battinf.fbsdeviceId=db_ram_db.tb_fbs9100_state.dev_id " +
+ " and db_battinf.tb_battinf.battgroupid=db_ram_db.tb_batt_rtstate.battgroupid limit 1";
+ List listB=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattGroupId()}, new CallBack() {
+
+ public List getResults(ResultSet rs) {
+ List list=new ArrayList();
+ try {
+ while(rs.next()){
+ Fbs9100_state fstate=new Fbs9100_state();
+ int dev_alarmstate=rs.getInt("dev_alarmstate");
+ String ContactorState="寮�鍏抽棴鍚�";
+ if(dev_alarmstate==1 ||
+ dev_alarmstate==2 ||
+ dev_alarmstate==3 ||
+ dev_alarmstate==4 ||
+ dev_alarmstate==6 ){
+ ContactorState="寮�鍏虫柇寮�";
+ }else{
+ ContactorState="寮�鍏抽棴鍚�";
+ }
+ fstate.setDev_testgroupnum(rs.getInt("dev_testgroupnum")); //琚祴鐢垫睜缁勫彿
+ fstate.setDev_alarmstate(rs.getInt("dev_alarmstate"));
+ fstate.setDev_res_test_state(rs.getInt("dev_res_test_state"));
+ fstate.setDev_testtype(rs.getInt("dev_testtype"));
+ fstate.setNote(ContactorState);
+ fstate.setDev_workstate(rs.getInt("dev_workstate"));
+ fstate.setDev_id(rs.getInt("dev_id"));
+
+ fstate.setDev_captest_onlinevol(rs.getFloat("dev_captest_onlinevol"));
+ fstate.setDev_captest_groupvol(rs.getFloat("dev_captest_groupvol"));
+ fstate.setDev_captest_curr(rs.getFloat("dev_captest_curr"));
+ fstate.setDev_captest_cap(rs.getFloat("dev_captest_cap"));
+ fstate.setDev_captest_timelong(rs.getInt("batt_test_tlong"));//瀹為檯鏀剧數鏃跺父
+
+ fstate.setDev_conresist(rs.getFloat("dev_conresist"));
+ fstate.setDev_concurr(rs.getFloat("dev_concurr"));
+ fstate.setDev_condcurr(rs.getFloat("dev_condcurr"));
+ fstate.setDev_condvoldp(rs.getFloat("dev_condvoldp"));
+ fstate.setDev_61850alarms(rs.getString("dev_61850alarms"));
+ fstate.setDev_last_captest_stop_type(rs.getInt("dev_last_captest_stop_type"));
+ fstate.setDev_temp(rs.getFloat("dev_temp"));
+ fstate.setStationName(rs.getString("stationName"));
+ fstate.setStationName1(rs.getString("stationName1"));
+ fstate.setStationName2(rs.getString("stationName2"));
+ fstate.setStationName3(rs.getString("stationName3"));
+ fstate.setStationName5(rs.getString("stationName5"));
+ fstate.setDeviceName(rs.getString("FbsDeviceName"));
+ /*fstate.setOnline_vols(((Float)rs.getFloat("online_vol")).toString());
+ fstate.setGroup_vols(((Float)rs.getFloat("group_vol")).toString());
+ fstate.setGroup_currs(((Float)rs.getFloat("group_curr")).toString());*/
+
+ list.add(fstate);
+ }
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return list;
+ }
+ });
+ if(listB!=null&&listB.size()>0) {
+ listAll.add(listB);
+ }
+ }
+ return listAll;
+
+ }
public static void main(String[] args) {
Fbs9100_stateImpl fi=new Fbs9100_stateImpl();
/*List<Fbs9100_state> list=fi.searchAll();
@@ -995,7 +1076,7 @@
fs.setPage(p);
BattInf binf=new BattInf();
binf.setNum(1);
- binf.setBattGroupId(1002);
+ binf.setBattGroupId(1001879);
binf.setStationName("骞胯タ鐪�");
binf.setMonVolStd(2f);
/*List<Fbs9100_state> list=fi.serchByCondition(fs);
@@ -1022,11 +1103,15 @@
for(Fbs9100_state f:list){
System.out.println(f);
}*/
- List<Fbs9100_state> list=fi.seachDischarge(binf);
+ /*List<Fbs9100_state> list=fi.seachDischarge(binf);
System.out.println(list.size());
for(Fbs9100_state f:list){
System.out.println(f);
- }
+ }*/
+ List listb=new ArrayList();
+ listb.add(binf);
+ List listAll=fi.freshenDischarge(listb);
+ System.out.println(listAll.size());
}
}
diff --git a/gx_tieta/src/com/fgkj/services/ram/Fbs9100_stateService.java b/gx_tieta/src/com/fgkj/services/ram/Fbs9100_stateService.java
index 1c48cbc..3ef77aa 100644
--- a/gx_tieta/src/com/fgkj/services/ram/Fbs9100_stateService.java
+++ b/gx_tieta/src/com/fgkj/services/ram/Fbs9100_stateService.java
@@ -210,7 +210,20 @@
}
return model;
}
- public static void main(String[] args) {
+
+ //瀹炴椂鍒锋柊鎵归噺璁剧疆鏀剧數鍙傛暟
+ public ServiceModel freshenDischarge(Object obj) {
+ List list=((Fbs9100_stateImpl)dao).freshenDischarge(obj);
+ if(list!=null && list.size()>0){
+ model.setCode(1);
+ model.setData(list);
+ }else{
+ model.setCode(0);
+ model.setMsg("鏌ヨ澶辫触!");
+ }
+ return model;
+ }
+ public static void main(String[] args) {
Fbs9100_stateService fs = new Fbs9100_stateService();
Fbs9100_state f=new Fbs9100_state();
f.setNum(1030);
--
Gitblit v1.9.1