From 72bf018e4a2b8dc2bd99a0bb9a43bc9621edfdfe Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.23>
Date: 星期二, 27 十一月 2018 14:20:31 +0800
Subject: [PATCH] 续航不足3小时的机房个数
---
gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java | 43 ++++++++++++++++++++++++++++++++++++++++---
gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java | 8 +++++++-
gx_tieta/src/com/fgkj/services/Batt_enduranceService.java | 7 +++++++
3 files changed, 54 insertions(+), 4 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java b/gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java
index b831f5c..8afc13e 100644
--- a/gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java
+++ b/gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java
@@ -27,7 +27,13 @@
return SUCCESS;
}
-
+ //瀵艰埅涓婄画鑸笉瓒�3灏忔椂鐨勪釜鏁�
+ public String serchxuhangNotInThree() {
+ User_inf uinf=(User_inf) getUser();
+ ServiceModel model=service.serchxuhangNotInThree(uinf);
+ result=tojson(model);
+ return SUCCESS;
+ }
public String getResult() {
return result;
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
index a251909..73fa1ae 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
@@ -173,7 +173,41 @@
});
return list;
}
- public List serchByInfo(Object obj) {
+ //瀵艰埅涓婄画鑸笉瓒�3灏忔椂鐨勪釜鏁�
+ public int serchxuhangNotInThree(Object obj) {
+ User_inf uinf=(User_inf) obj;
+ String sql="select count(distinct tb_batt_endurance.deviceid) as nums from web_site.tb_batt_endurance " +
+ " where endurance_actual_timelong<180 " +
+ " and tb_batt_endurance.stationid in (" +
+ " select distinct db_battinf.tb_battinf.stationid " +
+ " from db_battinf.tb_battinf " +
+ " left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid " +
+ " left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
+ " left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
+ " where db_user.tb_user_inf.uid=? and db_battinf.tb_battinf.station_install=1) " ;
+ 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()){
+ int nums=rs.getInt("nums");
+ list.add(nums);
+ }
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return list;
+ }
+ });
+ int nums=0;//缁埅涓嶈冻3灏忔椂鏁�
+ if(list!=null&&list.size()>0){
+ nums=(Integer) list.get(list.size()-1);
+ }
+ return nums;
+ }
+ public List serchByInfo(Object obj) {
// TODO Auto-generated method stub
return null;
}
@@ -198,12 +232,15 @@
User_inf uinf=new User_inf();
uinf.setUId(1002);
- List<Integer> list=bimpl.serchByState_xuhang(uinf);
+ /*List<Integer> list=bimpl.serchByState_xuhang(uinf);
for (int num : list) {
System.out.println(num);
- }
+ }*/
//System.out.println(list.size());
+ int nums=bimpl.serchxuhangNotInThree(uinf);
+ System.out.println(nums);
}
+
}
diff --git a/gx_tieta/src/com/fgkj/services/Batt_enduranceService.java b/gx_tieta/src/com/fgkj/services/Batt_enduranceService.java
index 307c099..7517bac 100644
--- a/gx_tieta/src/com/fgkj/services/Batt_enduranceService.java
+++ b/gx_tieta/src/com/fgkj/services/Batt_enduranceService.java
@@ -42,5 +42,12 @@
}
return model;
}
+ //瀵艰埅涓婄画鑸笉瓒�3灏忔椂鐨勪釜鏁�
+ public ServiceModel serchxuhangNotInThree(Object obj) {
+ int nums=((Batt_enduranceImpl)dao).serchxuhangNotInThree(obj);
+ model.setMsg("鏌ヨ鎴愬姛!");
+ model.setSum(nums);
+ return model;
+ }
}
--
Gitblit v1.9.1