From 3221d91c0bac4f71ea2410382e633e76a3357baf Mon Sep 17 00:00:00 2001
From: 星伟 <星伟@192.168.10.25>
Date: 星期三, 26 九月 2018 10:45:55 +0800
Subject: [PATCH] 电池续航

---
 gx_tieta/src/com/fgkj/dao/BaseDAO.java                    |    2 +
 gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java    |   12 +++++
 gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java   |   33 ++++++++++++++++
 gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java             |    2 +
 gx_tieta/src/com/fgkj/services/Batt_enduranceService.java |   32 ++++++++++++++++
 5 files changed, 80 insertions(+), 1 deletions(-)

diff --git a/gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java b/gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java
new file mode 100644
index 0000000..2ac9952
--- /dev/null
+++ b/gx_tieta/src/com/fgkj/actions/Batt_enduranceAction.java
@@ -0,0 +1,33 @@
+package com.fgkj.actions;
+
+import com.fgkj.dto.Batt_endurance;
+import com.fgkj.dto.ServiceModel;
+import com.fgkj.services.Batt_enduranceService;
+
+public class Batt_enduranceAction extends ActionUtil{
+	private Batt_enduranceService service=new Batt_enduranceService();
+	private String json;
+	private String result;
+	
+	//缁埅鏃堕棿鐨勬煡璇�
+	public String serchByCondition() {
+		Batt_endurance bendurance=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, Batt_endurance.class);
+		ServiceModel model=service.serchByCondition(bendurance);
+		result=tojson(model);
+		return SUCCESS;
+	}
+
+	
+	
+	
+	public String getResult() {
+		return result;
+	}
+	public void setJson(String json) {
+		this.json = json;
+	}
+	
+	
+	
+
+}
diff --git a/gx_tieta/src/com/fgkj/dao/BaseDAO.java b/gx_tieta/src/com/fgkj/dao/BaseDAO.java
index 317f591..a9691ce 100644
--- a/gx_tieta/src/com/fgkj/dao/BaseDAO.java
+++ b/gx_tieta/src/com/fgkj/dao/BaseDAO.java
@@ -176,6 +176,8 @@
 	
 	public static final int BATT_DEVALARM_DATA_HISTORY = 86;
 	
+	public static final int BATT_ENDURANCE=87;
+	
 	public boolean add(Object obj); // 娣诲姞
 
 	public boolean update(Object obj); // 鏇存柊
diff --git a/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java b/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java
index 12b5793..60ba796 100644
--- a/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java
+++ b/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java
@@ -18,6 +18,7 @@
 import com.fgkj.dao.impl.Batt_devalarm_data_historyImpl;
 import com.fgkj.dao.impl.Batt_devdischarge_paramImpl;
 import com.fgkj.dao.impl.Batt_electricityImpl;
+import com.fgkj.dao.impl.Batt_enduranceImpl;
 import com.fgkj.dao.impl.Batt_historyImpl;
 import com.fgkj.dao.impl.Batt_maint_infAgainImpl;
 import com.fgkj.dao.impl.Batt_maint_infImpl;
@@ -182,6 +183,7 @@
 			case 84:return new Positiomap_usrImpl();
 			case 85:return new Battalarm_data_historyImpl();
 			case 86:return new Batt_devalarm_data_historyImpl();
+			case 87:return new Batt_enduranceImpl();
 			default :return null;
 		}
 	}
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 146d94b..490600b 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
@@ -41,7 +41,7 @@
     //缁埅鏃堕棿鐨勬煡璇�
 	public List serchByCondition(Object obj) {
 		Batt_endurance bendurance=(Batt_endurance) obj;
-		String sql="select distinct num,deviceid,tb_batt_endurance.stationid,endurance_state,real_cap,tb_batt_endurance.moncapstd,real_curr,endurance_timelong " +
+		String sql="select distinct tb_batt_endurance.num,tb_batt_endurance.deviceid,tb_batt_endurance.stationid,endurance_state,real_cap,tb_batt_endurance.moncapstd,real_curr,endurance_timelong " +
 				",db_battinf.tb_battinf.StationName " +
 				" from web_site.tb_batt_endurance,db_battinf.tb_battinf " +
 				" where tb_batt_endurance.stationid=db_battinf.tb_battinf.stationid " ;
@@ -66,6 +66,7 @@
 		}
 		//鎺掑簭鏃堕棿
 		String orderSql=" order by endurance_timelong asc";
+		//System.out.println(sql);
 		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+bendurance.getStationid()+"%",bendurance.getEndurance_state(),bendurance.getEndurance_timelong()}, new CallBack() {
 			
 			public List getResults(ResultSet rs) {
@@ -98,5 +99,14 @@
 		// TODO Auto-generated method stub
 		return null;
 	}
+	public static void main(String[] args) {
+		Batt_enduranceImpl bimpl=new Batt_enduranceImpl();
+		Batt_endurance ben=new Batt_endurance();
+		ben.setStationid("");
+		ben.setEndurance_state(0);
+		ben.setEndurance_timelong(0);
+		List list=bimpl.serchByCondition(ben);
+		System.out.println(list.size());
+	}
 
 }
diff --git a/gx_tieta/src/com/fgkj/services/Batt_enduranceService.java b/gx_tieta/src/com/fgkj/services/Batt_enduranceService.java
new file mode 100644
index 0000000..20c5446
--- /dev/null
+++ b/gx_tieta/src/com/fgkj/services/Batt_enduranceService.java
@@ -0,0 +1,32 @@
+package com.fgkj.services;
+
+import java.util.List;
+
+import com.fgkj.dao.BaseDAO;
+import com.fgkj.dao.BaseDAOFactory;
+import com.fgkj.dto.ServiceModel;
+
+public class Batt_enduranceService {
+	private BaseDAO dao;
+	private ServiceModel model;
+	
+	public Batt_enduranceService() {
+		super();
+		dao =BaseDAOFactory.getBaseDAO(BaseDAO.BATT_ENDURANCE);
+		model = new ServiceModel();
+	}
+	//缁埅鏃堕棿鐨勬煡璇�
+	public ServiceModel serchByCondition(Object obj) {
+		List list=dao.serchByCondition(obj);
+		if(list.size()>0&&list!=null){
+			model.setCode(1);
+			model.setData(list);
+			model.setMsg("鏌ヨ鎴愬姛!");
+		}else{
+			model.setCode(0);
+			model.setMsg("鏌ヨ澶辫触!");
+		}
+		return model;
+	}
+
+}

--
Gitblit v1.9.1