From 35e4b9b72819b2d9cc66dacd0b9cef6a49e937ec Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.33>
Date: 星期六, 03 十一月 2018 08:59:37 +0800
Subject: [PATCH] bts设备放电
---
gx_tieta/src/com/fgkj/services/ram/Fbs9100_stateService.java | 12 ++++++
gx_tieta/src/com/fgkj/dao/FBS9100_ComBase.java | 7 +++
gx_tieta/src/com/fgkj/actions/ram/Fbs9100_stateAction.java | 9 ++++
gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java | 75 +++++++++++++++++++++++++++++++++++++
4 files changed, 101 insertions(+), 2 deletions(-)
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 e7e632c..0a55545 100644
--- a/gx_tieta/src/com/fgkj/actions/ram/Fbs9100_stateAction.java
+++ b/gx_tieta/src/com/fgkj/actions/ram/Fbs9100_stateAction.java
@@ -93,13 +93,20 @@
result = tojson(model);
return SUCCESS;
}
- //瀵艰埅涓婂疄鏃舵煡璇�61850璁惧鐨勫浜庢牳瀹规祴璇曠殑鏁版嵁
+ //瀵艰埅涓婂疄鏃舵煡璇�61850璁惧鐨勫浜庢牳瀹规祴璇曠殑鏁版嵁
public String seach6185Nuclear_cap(){
User_inf uinf=(User_inf) getUser();
ServiceModel model = service.seach6185Nuclear_cap(uinf);
result = tojson(model);
return SUCCESS;
}
+ //瀵艰埅涓婂疄鏃舵煡璇ts澶勪簬鏀剧數娴嬭瘯鐨勬暟鎹殑璁惧
+ public String seachNuclear_cap(){
+ User_inf uinf=(User_inf) getUser();
+ ServiceModel model = service.seachNuclear_cap(uinf);
+ result = tojson(model);
+ return SUCCESS;
+ }
public String getResult() {
return result;
}
diff --git a/gx_tieta/src/com/fgkj/dao/FBS9100_ComBase.java b/gx_tieta/src/com/fgkj/dao/FBS9100_ComBase.java
index 10cd810..af23bca 100644
--- a/gx_tieta/src/com/fgkj/dao/FBS9100_ComBase.java
+++ b/gx_tieta/src/com/fgkj/dao/FBS9100_ComBase.java
@@ -45,6 +45,13 @@
final public static int DEV_RES_TEST=4; //鍐呴樆娴嬭瘯
final public static int DEV_KD_TEST=5; //kd娴嬭瘯
+ //bts璁惧宸ヤ綔鐘舵�佸搴斿叧绯粀orkstate
+ final public static int ONLINE_TEST=0; //鍦ㄧ嚎妫�娴�
+ final public static int DISCHARGE=1; //鏀剧數娴嬭瘯
+ final public static int CHARGE=2; //鍏呯數娴嬭瘯
+ final public static int RES_TEST=3; //鍐呴樆娴嬭瘯
+ final public static int NONE=4; //鏈煡
+
//bts鏀剧數娴嬭瘯椤甸潰涓殑娴嬭瘯绫诲瀷鐨勫搴斿叧绯�
final public static int CMD_TESTCMD_HR = 37; //鏍稿娴嬭瘯
final public static int CMD_TESTCMD_RES = 50; //鍐呴樆娴嬭瘯
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 7f7d86f..b18a17e 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
@@ -743,6 +743,78 @@
return list;
}
+ //瀵艰埅涓婂疄鏃舵煡璇ts澶勪簬鏀剧數娴嬭瘯鐨勬暟鎹殑璁惧
+ public List seachNuclear_cap(Object obj){
+ User_inf uinf=(User_inf) obj;
+ 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.FbsDeviceName " +
+ " ,db_ram_db.tb_batt_rtstate.batt_test_tlong " +
+ " from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf,db_ram_db.tb_batt_rtstate " +
+ " where dev_workstate="+FBS9100_ComBase.DISCHARGE+" "+
+ " 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 " +
+ " and db_battinf.tb_battinf.fbsdeviceId in(select distinct db_battinf.tb_battinf.fbsdeviceId 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=? ) " +
+ " " ;
+ List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, 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("dev_captest_timelong"));
+
+ 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.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());*/
+ fstate.setNum(rs.getInt("batt_test_tlong"));
+ list.add(fstate);
+ }
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return list;
+ }
+ });
+
+ return list;
+ }
public static void main(String[] args) {
Fbs9100_stateImpl fi=new Fbs9100_stateImpl();
/*List<Fbs9100_state> list=fi.searchAll();
@@ -771,8 +843,9 @@
User_inf uinf=new User_inf();
uinf.setUId(1002);
//List<Fbs9100_state> list=fi.searchByUid(uinf);
- List<Fbs9100_state> list=fi.searchDevWorkstate(fs);
+ // List<Fbs9100_state> list=fi.searchDevWorkstate(fs);
// List<Fbs9100_state> list=fi.seach6185Nuclear_cap(uinf);
+ List<Fbs9100_state> list=fi.seachNuclear_cap(uinf);
System.out.println(list.size());
for(Fbs9100_state f:list){
System.out.println(f);
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 0e66249..6908eb2 100644
--- a/gx_tieta/src/com/fgkj/services/ram/Fbs9100_stateService.java
+++ b/gx_tieta/src/com/fgkj/services/ram/Fbs9100_stateService.java
@@ -175,6 +175,18 @@
}
return model;
}
+ //瀵艰埅涓婂疄鏃舵煡璇ts澶勪簬鏀剧數娴嬭瘯鐨勬暟鎹殑璁惧
+ public ServiceModel seachNuclear_cap(Object obj){
+ List list=((Fbs9100_stateImpl)dao).seachNuclear_cap(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();
--
Gitblit v1.9.1