From cac35d6a8bbf37e49507741b9df82aaa9c318422 Mon Sep 17 00:00:00 2001
From: 星伟 <星伟@192.168.10.25>
Date: 星期四, 27 九月 2018 14:30:31 +0800
Subject: [PATCH] 设备用电量统计分析查询
---
gx_tieta/src/com/fgkj/dao/impl/Batt_electricityImpl.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Batt_electricityImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Batt_electricityImpl.java
index 12ab954..156ca12 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Batt_electricityImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_electricityImpl.java
@@ -144,14 +144,14 @@
String sql="";
String basesql="select num,dev_id,dev_name,dev_recordtime,dev_electricity_CM,dev_electricity_CT,dev_electricity_CU,note ";
String conditionSql=" from web_site.tb_batt_electricity " +
- ",(select DISTINCT(FBSdeviceid) from db_battinf.tb_battinf where stationid=? ) as DISTINCTbattinf " +
+ ",(select DISTINCT(FBSdeviceid) from db_battinf.tb_battinf where stationid=? and stationname1 like ? and stationname2 like ? ) as DISTINCTbattinf " +
"where DISTINCTbattinf.FBSdeviceid=tb_batt_electricity.dev_id " +
"and to_days(tb_batt_electricity.dev_recordtime)>=to_days(?) and to_days(tb_batt_electricity.dev_recordtime)<=to_days(?) ";
basesql+=conditionSql;//鍚堣繛琛ㄦ潯浠�
String endSql=" ORDER BY dev_id ,dev_recordtime ";
sql=basesql+endSql;//鍚堟垚鏈�鍚庣殑sql
//System.out.println(sql);
- List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getStationId(),binf.getBattProductDate(),binf.getBattProductDate1()}, new CallBack() {
+ List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getStationId(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%",binf.getBattProductDate(),binf.getBattProductDate1()}, new CallBack() {
public List getResults(ResultSet rs) {
List list=new ArrayList();
--
Gitblit v1.9.1