fg_v2.0.git - Gitblit

			@@ -1,14 +1,18 @@
			package com.whyc.service;

			import com.whyc.dto.InterfaceParam;
			import com.whyc.dto.ReportBattDTO;
			import com.whyc.dto.StandardFeatureCurve;
			import com.whyc.dto.UpsAlarmDTO;
			import com.whyc.dto.paramter.AlarmPar;
			import com.whyc.dto.paramter.DevAlarmPar;
			import com.whyc.dto.result.AlarmRes;
			import com.whyc.dto.result.RealDateDTO;
			import com.whyc.dto.result.ReportBattResultDTO;
			import com.whyc.mapper.CallBack;
			import com.whyc.pojo.*;
			import com.whyc.util.ActionUtil;
			import com.whyc.util.ThreadLocalUtil;
			import org.apache.ibatis.annotations.Param;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.stereotype.Service;
			@@ -17,10 +21,7 @@
			import javax.swing.*;
			import java.sql.ResultSet;
			import java.sql.SQLException;
			import java.util.ArrayList;
			import java.util.Date;
			import java.util.LinkedList;
			import java.util.List;
			import java.util.*;

			@Service
			public class SubTablePageInfoService {
			@@ -28,7 +29,7 @@
			private MybatisSqlExecuteService sqlExecuteService;
			//2,7,33,55，72，78，109-SubTablePageInfoUtils.java;201行,435行
			public List<PwrdevAlarmHistory> getList2(PwrdevAlarmHistory data){
			String sql="select alarm.*,inf.StationName,inf.StationName1,inf.StationName2,inf.StationName3,inf.StationName5 " +
			String sql="select alarm.*,inf.StationName,inf.StationName1,inf.StationName2,inf.StationName3,inf.StationName5,inf.PowerDeviceName " +
			" from db_pwrdev_alarm."+data.getRecordYear()+" alarm,db_pwrdev_inf.tb_pwrdev_inf inf " +
			" where alarm.PowerDeviceId = inf.PowerDeviceId ";
			if(data.getStationName1()!=null){
			@@ -44,10 +45,10 @@
			sql+=" and stationName3 like '%"+data.getStationName3()+"%'";
			}
			if(data.getAlmStartTime()!=null){
			sql+=" and alarm.alm_start_time >='"+ActionUtil.sdf.format(data.getAlmStartTime())+"' ";
			sql+=" and alarm.alm_start_time >='"+ ThreadLocalUtil.format(data.getAlmStartTime(),1)+"' ";
			}
			if(data.getAlmStartTime1()!=null){
			sql+=" and alarm.alm_start_time <='"+ActionUtil.sdf.format(data.getAlmStartTime1())+"' ";
			sql+=" and alarm.alm_start_time <='"+ThreadLocalUtil.format(data.getAlmStartTime1(),1)+"' ";
			}
			if(data.getAlmSource()==0){
			sql+=" and alm_source!=100 ";
			@@ -84,6 +85,7 @@
			ph.setNum(rs.getLong("num"));
			ph.setRecordId(rs.getLong("record_id"));
			ph.setPowerDeviceId(rs.getLong("PowerDeviceId"));
			ph.setPowerDeviceName(rs.getString("PowerDeviceName"));
			ph.setAlmType(rs.getInt("alm_type"));
			ph.setAlmLevel(rs.getInt("alm_level"));
			ph.setAlmSource(rs.getInt("alm_source"));
			@@ -110,9 +112,9 @@
			return list;
			}

			//3,53,54,77,102-SubTablePageInfoUtils.java;72行 211行,445行
			//3,53,54,77,102,127,136-SubTablePageInfoUtils.java;72行 211行,445行
			public List<PwrdevAlarmHistory> getListForTX(PwrdevAlarmHistory data){
			String sql="select alarm.*,inf.StationName,inf.StationName1,inf.StationName2,inf.StationName3,inf.StationName5 " +
			String sql="select alarm.*,inf.StationName,inf.StationName1,inf.StationName2,inf.StationName3,inf.StationName5,inf.PowerDeviceName " +
			" from db_pwrdev_alarm."+data.getRecordYear()+" alarm,db_pwrdev_inf.tb_pwrdev_inf inf " +
			" where alarm.PowerDeviceId = inf.PowerDeviceId ";
			if(data.getStationName1()!=null){
			@@ -128,10 +130,10 @@
			sql+=" and stationName3 like '%"+data.getStationName3()+"%'";
			}
			if(data.getAlmStartTime()!=null){
			sql+=" and alarm.alm_start_time >='"+ActionUtil.sdf.format(data.getAlmStartTime())+"' ";
			sql+=" and alarm.alm_start_time >='"+ThreadLocalUtil.format(data.getAlmStartTime(),1)+"' ";
			}
			if(data.getAlmStartTime1()!=null){
			sql+=" and alarm.alm_start_time <='"+ActionUtil.sdf.format(data.getAlmStartTime1())+"' ";
			sql+=" and alarm.alm_start_time <='"+ThreadLocalUtil.format(data.getAlmStartTime1(),1)+"' ";
			}
			if(data.getAlmSource()==0){
			sql+=" and alm_source!=100 ";
			@@ -178,6 +180,7 @@
			ph.setNum(rs.getLong("num"));
			ph.setRecordId(rs.getLong("record_id"));
			ph.setPowerDeviceId(rs.getLong("PowerDeviceId"));
			ph.setPowerDeviceName(rs.getString("PowerDeviceName"));
			ph.setAlmType(rs.getInt("alm_type"));
			ph.setAlmLevel(rs.getInt("alm_level"));
			ph.setAlmSource(rs.getInt("alm_source"));
			@@ -208,7 +211,7 @@
			public int getCount(UserLog userLog){
			String sql=" select count(*) num from db_user."+userLog.getRecordYear()+" l,db_user.tb_user_inf u" +
			" where l.uId = u.uId" +
			" and uOprateDay between '"+ActionUtil.sdf.format(userLog.getOperationTime())+"' and '"+ActionUtil.sdf.format(userLog.getOperationTime2())+"' ";
			" and uOprateDay between '"+ThreadLocalUtil.format(userLog.getOperationTime(),1)+"' and '"+ThreadLocalUtil.format(userLog.getOperationTime2(),1)+"' ";
			if(userLog.getUId()!=null){
			sql+=" and l.uId ="+userLog.getUId()+" ";
			}
			@@ -369,7 +372,7 @@
			//6-PwrDevDataHistoryGWService.java;45行
			public List<PwrDevDataHistoryGW> getListByParam(Long powerDeviceId, String tableMonth, Date subStartTime, Date subEndTime){
			String sql=" select * from db_pwrdev_data_history_gw.tb_pwrdev_historydata_gw_"+powerDeviceId+"_"+tableMonth+" d " +
			" where d.record_time >='"+ActionUtil.sdf.format(subStartTime)+"' and d.record_time <='"+ActionUtil.sdf.format(subEndTime)+"' ";
			" where d.record_time >='"+ThreadLocalUtil.format(subStartTime,1)+"' and d.record_time <='"+ThreadLocalUtil.format(subEndTime,1)+"' ";
			List<PwrDevDataHistoryGW> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			@@ -453,7 +456,7 @@
			return list;
			}

			//8-StandardFeatureCurveService.java;86行
			//8,133-StandardFeatureCurveService.java;86行
			public List<StandardFeatureCurve> getList(String va, String c){
			String sql=" select * from `web_site`.`tb_standard_feature_curve_"+va+"_"+c+"`";
			List<StandardFeatureCurve> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@@ -473,7 +476,7 @@
			return list;
			}

			//9,12,20,24,49，110-SubTablePageInfoUtils.java;225行,459行 225行
			//9,12,20,24,49，110,118-SubTablePageInfoUtils.java;225行,459行 225行
			public List<AlarmRes> getListForInterface(InterfaceParam param){
			String sql="select history.BattGroupId,history.num,alm_id,alm_signal_id,history.monnum,alm_value,alm_level,alm_is_confirmed,alm_confirmed_time,alm_start_time,alm_end_time,alm_severity" +
			",stationId,stationname,stationname1,stationname2,stationname3,stationname5,battgroupname " +
			@@ -490,10 +493,10 @@
			sql+=")";
			}
			if(param.getStartTime()!=null){
			sql+=" and alm_start_time>='"+ ActionUtil.sdf.format(param.getStartTime())+"' ";
			sql+=" and alm_start_time>='"+ ThreadLocalUtil.format(param.getStartTime(),1)+"' ";
			}
			if(param.getEndTime()!=null){
			sql+=" and alm_start_time<='"+ ActionUtil.sdf.format(param.getEndTime())+"' ";
			sql+=" and alm_start_time<='"+ ThreadLocalUtil.format(param.getEndTime(),1)+"' ";
			}

			sql+=" order by history.battgroupid asc,history.alm_start_time desc,history.monnum asc limit "+param.getLimitStart()+","+param.getLimitEnd()+" ";
			@@ -571,10 +574,10 @@
			sql+=" and stationName3 like '%"+param.getStationName3()+"%'";
			}
			if(param.getAlmStartTime()!=null){
			sql+=" and alarm.alm_start_time >='"+ActionUtil.sdf.format(param.getAlmStartTime())+"' ";
			sql+=" and alarm.alm_start_time >='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' ";
			}
			if(param.getAlmStartTime1()!=null){
			sql+=" and alarm.alm_start_time <='"+ActionUtil.sdf.format(param.getAlmStartTime1())+"' ";
			sql+=" and alarm.alm_start_time <='"+ThreadLocalUtil.format(param.getAlmStartTime1(),1)+"' ";
			}
			if(param.getAlmSource()==0){
			sql+=" and alm_source!=100 ";
			@@ -640,7 +643,60 @@
			sql+=" and stationName='"+param.getStationName()+"' ";
			}
			}
			sql+=" and alm_start_time >='"+ActionUtil.sdf.format(param.getAlmStartTime())+"' and alm_start_time <='"+ActionUtil.sdf.format(param.getAlmStartTime1())+"' ";
			sql+=" and alm_start_time >='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' and alm_start_time <='"+ThreadLocalUtil.format(param.getAlmStartTime1(),1)+"' ";
			sql+=" and history.dev_id 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="+param.getUId()+")";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("number"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			int num =0;
			if(list!=null){
			num= (int) list.get(0);
			}
			return num;
			}
			//13,14,17,36，94-SubTablePageInfoUtils.java;88行
			public int getCount_stationId(DevAlarmPar param){
			String sql="SELECT count(distinct history.num) as number FROM db_alarm."+param.getRecordYear()+" history,db_battinf.tb_battinf " +
			" where history.dev_id=db_battinf.tb_battinf.FbsDeviceId ";
			/*if(param.getStationName1()!=null){
			if(param.getStationName1().equals("")){
			sql+=" and stationName1!='"+param.getStationName1()+"' ";
			}else{
			sql+=" and stationName1='"+param.getStationName1()+"' ";
			}
			}
			if(param.getStationName()!=null){
			if(param.getStationName().equals("")){
			sql+=" and stationName!='"+param.getStationName()+"' ";
			}else{
			sql+=" and stationName='"+param.getStationName()+"' ";
			}
			}*/
			if(param.getStationId()!=null){
			if(param.getStationId().equals("")){
			sql+=" and stationId!='"+param.getStationId()+"' ";
			}else{
			sql+=" and stationId='"+param.getStationId()+"' ";
			}
			}
			sql+=" and alm_start_time >='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' and alm_start_time <='"+ThreadLocalUtil.format(param.getAlmStartTime1(),1)+"' ";
			sql+=" and history.dev_id 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 " +
			@@ -705,11 +761,75 @@
			});
			return list;
			}

			//16,19,30，61,105，111-SubTablePageInfoUtils.java;188行 422行
			public List getList2_stationId(DevAlarmPar param){
			String sql=" SELECT history.num,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time,alm_is_confirmed,alm_confirmed_time,alm_cleared_type,alm_severity, " +
			" db_battinf.tb_battinf.stationName,stationName1,stationName2,stationName3,stationName5,db_battinf.tb_battinf.stationName4 as dev_name " +
			" FROM db_alarm."+param.getRecordYear()+" history,db_battinf.tb_battinf " +
			" where history.dev_id=db_battinf.tb_battinf.FbsDeviceId ";
			/*if(param.getStationName1()!=null){
			if(param.getStationName1().equals("")){
			sql+=" and stationName1!='"+param.getStationName1()+"' ";
			}else{
			sql+=" and stationName1='"+param.getStationName1()+"' ";
			}
			}
			if(param.getStationName()!=null){
			if(param.getStationName().equals("")){
			sql+=" and stationName!='"+param.getStationName()+"' ";
			}else{
			sql+=" and stationName='"+param.getStationName()+"' ";
			}
			}*/
			if(param.getStationId()!=null){
			if(param.getStationId().equals("")){
			sql+=" and stationId!='"+param.getStationId()+"' ";
			}else{
			sql+=" and stationId='"+param.getStationId()+"' ";
			}
			}
			sql+=" and alm_start_time >='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' and alm_start_time <='"+ThreadLocalUtil.format(param.getAlmStartTime1(),1)+"' ";
			sql+=" and history.dev_id 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="+param.getUId()+") " +
			" ORDER BY alm_start_time desc ,dev_name asc limit "+param.getLimitStart()+","+param.getLimitEnd()+" ";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<DevalarmDataHistory> list=new ArrayList<>();
			while (rs.next()){
			DevalarmDataHistory ph=new DevalarmDataHistory();
			ph.setNum(rs.getLong("num"));
			ph.setDevId(rs.getInt("dev_id"));
			ph.setDevIp(rs.getString("dev_ip"));
			ph.setAlmType(rs.getInt("alm_type"));
			ph.setAlmLevel(rs.getInt("alm_level"));
			ph.setAlmStartTime(rs.getTimestamp("alm_start_time"));
			ph.setAlmEndTime(rs.getTimestamp("alm_end_time"));
			ph.setAlmIsConfirmed(rs.getInt("alm_is_confirmed"));
			ph.setAlmConfirmedTime(rs.getTimestamp("alm_confirmed_time"));
			ph.setAlmClearedType(rs.getInt("alm_cleared_type"));
			ph.setDevName(rs.getString("dev_name"));
			ph.setStationName(rs.getString("stationName"));
			ph.setStationName1(rs.getString("stationName1"));
			ph.setStationName2(rs.getString("stationName2"));
			ph.setStationName3(rs.getString("stationName3"));
			ph.setStationName5(rs.getString("stationName5"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}
			//16,19,30，61,105，111,123-SubTablePageInfoUtils.java;188行 422行
			public List getList2(DevAlarmPar param){
			String sql=" SELECT history.num,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time,alm_is_confirmed,alm_confirmed_time,alm_cleared_type,alm_severity, " +
			" db_battinf.tb_battinf.stationName,stationName1,stationName2,stationName3,stationName5,db_battinf.tb_battinf.FbsDeviceName as dev_name " +
			" db_battinf.tb_battinf.stationName,stationName1,stationName2,stationName3,stationName5,db_battinf.tb_battinf.stationName4 as dev_name " +
			" FROM db_alarm."+param.getRecordYear()+" history,db_battinf.tb_battinf " +
			" where history.dev_id=db_battinf.tb_battinf.FbsDeviceId ";
			if(param.getStationName1()!=null){
			@@ -726,7 +846,7 @@
			sql+=" and stationName='"+param.getStationName()+"' ";
			}
			}
			sql+=" and alm_start_time >='"+ActionUtil.sdf.format(param.getAlmStartTime())+"' and alm_start_time <='"+ActionUtil.sdf.format(param.getAlmStartTime1())+"' ";
			sql+=" and alm_start_time >='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' and alm_start_time <='"+ThreadLocalUtil.format(param.getAlmStartTime1(),1)+"' ";
			sql+=" and history.dev_id 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 " +
			@@ -766,11 +886,11 @@
			return list;
			}

			//21,74，84，86，93-SubTablePageInfoUtils.java;164行，398行
			//21,74，84，86，93,116,135-SubTablePageInfoUtils.java;164行，398行
			public List<UserLog> getList2(UserLog userLog){
			String sql=" select l.*,u.uName from db_user."+userLog.getRecordYear()+" l,db_user.tb_user_inf u " +
			" where l.uId = u.uId " +
			" and uOprateDay between '"+ActionUtil.sdf.format(userLog.getOperationTime())+"' and '"+ActionUtil.sdf.format(userLog.getOperationTime2())+"' ";
			" and uOprateDay between '"+ThreadLocalUtil.format(userLog.getOperationTime(),1)+"' and '"+ThreadLocalUtil.format(userLog.getOperationTime2(),1)+"' ";
			if(userLog.getUId()!=null){
			sql+=" and l.uId ="+userLog.getUId()+" ";
			}
			@@ -853,7 +973,7 @@
			return list;
			}

			//23,60,75，87，88,100-SubTablePageInfoUtils.java;469行，235行
			//23,60,75，87，88,100,235-SubTablePageInfoUtils.java;469行，235行
			public List<DevalarmDataHistory> getListForInterface_dev(InterfaceParam param){
			String sql=" SELECT history.num,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time,alm_is_confirmed,alm_confirmed_time,alm_cleared_type, " +
			" db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.stationName1,db_battinf.tb_battinf.stationName2,db_battinf.tb_battinf.stationName3," +
			@@ -871,10 +991,10 @@
			sql+=")";
			}
			if(param.getStartTime()!=null){
			sql+=" and alm_start_time >='"+ActionUtil.sdf.format(param.getStartTime())+"' ";
			sql+=" and alm_start_time >='"+ThreadLocalUtil.format(param.getStartTime(),1)+"' ";
			}
			if(param.getEndTime()!=null){
			sql+=" and alm_start_time <='"+ActionUtil.sdf.format(param.getEndTime())+"' ";
			sql+=" and alm_start_time <='"+ThreadLocalUtil.format(param.getEndTime(),1)+"' ";
			}
			sql+=" ORDER BY alm_start_time desc ,dev_name asc limit "+param.getLimitStart()+","+param.getLimitEnd()+" ";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@@ -916,8 +1036,8 @@
			for (int i=0;i<temp.size();i++) {
			BattalarmDataHistory bh=temp.get(i);
			sql+="("+bh.getBattGroupId()+","+bh.getMonNum()+","+bh.getRecordId()+","+bh.getAlmId()+","+bh.getAlmSignalId()+","+bh.getAlmLevel()+
			",'"+ActionUtil.sdf.format(bh.getAlmStartTime())+"','"+ActionUtil.sdf.format(bh.getAlmEndTime())+"',"+bh.getAlmValue()+","+bh.getAlmIsConfirmed()+"," +
			"'"+ActionUtil.sdf.format(bh.getAlmConfirmedTime())+"',"+bh.getAlmClearedType()+","+bh.getUsrId()+","+bh.getAlmSeverity()+")";
			",'"+ThreadLocalUtil.format(bh.getAlmStartTime(),1)+"','"+ThreadLocalUtil.format(bh.getAlmEndTime(),1)+"',"+bh.getAlmValue()+","+bh.getAlmIsConfirmed()+"," +
			"'"+ThreadLocalUtil.format(bh.getAlmConfirmedTime(),1)+"',"+bh.getAlmClearedType()+","+bh.getUsrId()+","+bh.getAlmSeverity()+")";
			if(i!=(temp.size()-1)){
			sql+=",";
			}
			@@ -943,7 +1063,7 @@
			sqlExecuteService.execute(sql);
			}

			//29,65，83，112-SubTablePageInfoUtils.java;104行
			//29,65，83，112,128-SubTablePageInfoUtils.java;104行
			public int getCountForTX(PwrdevAlarmHistory param){
			String sql="select count(distinct alarm.num) as number from db_pwrdev_alarm."+param.getRecordYear()+" alarm,db_pwrdev_inf.tb_pwrdev_inf inf " +
			" where alarm.PowerDeviceId = inf.PowerDeviceId ";
			@@ -960,10 +1080,10 @@
			sql+=" and stationName3 like '%"+param.getStationName3()+"%'";
			}
			if(param.getAlmStartTime()!=null){
			sql+=" and alarm.alm_start_time >='"+ActionUtil.sdf.format(param.getAlmStartTime())+"' ";
			sql+=" and alarm.alm_start_time >='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' ";
			}
			if(param.getAlmStartTime1()!=null){
			sql+=" and alarm.alm_start_time <='"+ActionUtil.sdf.format(param.getAlmStartTime1())+"' ";
			sql+=" and alarm.alm_start_time <='"+ThreadLocalUtil.format(param.getAlmStartTime1(),1)+"' ";
			}
			if(param.getAlmSource()==0){
			sql+=" and alm_source!=100 ";
			@@ -1021,7 +1141,7 @@
			return num;
			}

			//32,47,50-PwrdevAlarmService.java;189行 158行,85行
			//32,47,50,124-PwrdevAlarmService.java;189行 158行,85行
			public List<PwrdevAlarmParam> searchAll(String tableName){
			String sql="select * from db_pwrdev_alarm."+tableName;
			List<PwrdevAlarmParam> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@@ -1061,10 +1181,10 @@
			sql+=")";
			}
			if(param.getStartTime()!=null){
			sql+=" and alm_start_time >='"+ActionUtil.sdf.format(param.getStartTime())+"' ";
			sql+=" and alm_start_time >='"+ThreadLocalUtil.format(param.getStartTime(),1)+"' ";
			}
			if(param.getEndTime()!=null){
			sql+=" and alm_start_time <='"+ActionUtil.sdf.format(param.getEndTime())+"' ";
			sql+=" and alm_start_time <='"+ThreadLocalUtil.format(param.getEndTime(),1)+"' ";
			}
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			@@ -1086,7 +1206,7 @@
			return num;
			}

			//35,38,57,67,101-，71SubTablePageInfoUtils.java;176行 410行
			//35,38,57,67,101，71,117 -SubTablePageInfoUtils.java;176行 410行
			public List<AlarmRes> getList2(AlarmPar param){
			String sql="select history.BattGroupId,history.num,alm_signal_id,history.monnum,alm_value,alm_level,alm_is_confirmed,alm_confirmed_time,alm_start_time,alm_end_time " +
			" ,alm_severity,stationname,StationName1,StationName2,StationName3,StationName5,battgroupname " +
			@@ -1095,7 +1215,7 @@
			" and alm_id in("+param.getAlmIdOne()+","+param.getAlmIdTwo()+", "+param.getAlmIdThree()+ ", "+param.getAlmIdFour()+ ", "+param.getAlmIdFive()+ ", "+param.getAlmIdSix()+ ", "+param.getAlmIdSeven()+ ", "+param.getAlmIdEight()+ ") " +
			" and alm_signal_id%2 in("+param.getAlmSignalIdOne()+","+param.getAlmSignalIdTwo()+") " +
			" and alm_level in( "+param.getAlmLevelOne()+ ", "+param.getAlmLevelTwo()+ ", "+param.getAlmLevelThree()+ ", "+param.getAlmLevelFour()+ ") " +
			" and alm_start_time>='"+ActionUtil.sdf.format(param.getAlmStartTime())+"' and alm_start_time <='"+ActionUtil.sdf.format(param.getAlmStartTime1())+"' " +
			" and alm_start_time>='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' and alm_start_time <='"+ThreadLocalUtil.format(param.getAlmStartTime1(),1)+"' " +
			" and db_battinf.tb_battinf.stationname1 like '%"+param.getStationname1()+"%' " +
			" and db_battinf.tb_battinf.stationname like '%"+param.getStationname()+"%' ";
			if(param.getBattGroupId()==0){
			@@ -1196,7 +1316,7 @@
			return list;
			}

			//42-HistoryDataArchivingService.java;72行
			//42,129-HistoryDataArchivingService.java;72行 76行
			public void insertBatch4PowerAlarmHistoryByYear(String year, List<PwrdevAlarmHistory> temp){
			String sql="insert into db_pwrdev_alarm.`tb_pwrdev_alarm_history_"+year+"` " +
			" (record_id,PowerDeviceId,alm_type,alm_level,alm_source,alm_index,alm_start_time,alm_end_time,alm_value,alm_is_confirmed,alm_confirmed_time,alm_cleared_type,usr_Id,alm_severity,alm_trigger) " +
			@@ -1205,8 +1325,8 @@
			for (int i=0;i<temp.size();i++) {
			PwrdevAlarmHistory bh=temp.get(i);
			sql+="("+bh.getRecordId()+","+bh.getPowerDeviceId()+","+bh.getAlmType()+","+bh.getAlmLevel()+","+bh.getAlmSource()+","+bh.getAlmIndex()+
			",'"+ActionUtil.sdf.format(bh.getAlmStartTime())+"','"+ActionUtil.sdf.format(bh.getAlmEndTime())+"',"+bh.getAlmValue()+","+bh.getAlmIsConfirmed()+"," +
			"'"+ActionUtil.sdf.format(bh.getAlmConfirmedTime())+"',"+bh.getAlmClearedType()+","+bh.getUsrId()+","+bh.getAlmSeverity()+","+bh.getAlmTrigger()+")";
			",'"+ThreadLocalUtil.format(bh.getAlmStartTime(),1)+"','"+ThreadLocalUtil.format(bh.getAlmEndTime(),1)+"',"+bh.getAlmValue()+","+bh.getAlmIsConfirmed()+"," +
			"'"+ThreadLocalUtil.format(bh.getAlmConfirmedTime(),1)+"',"+bh.getAlmClearedType()+","+bh.getUsrId()+","+bh.getAlmSeverity()+","+bh.getAlmTrigger()+")";
			if(i!=(temp.size()-1)){
			sql+=",";
			}
			@@ -1217,7 +1337,7 @@

			//43-PwrdevDataHistoryService.java;69行
			public List<PwrdevDataHistory> getGtStartTime(String tableName, Date startTime){
			String sql="select * from db_pwrdev_data_history."+tableName+" where record_time>='"+ ActionUtil.sdf.format(startTime)+"' ";
			String sql="select * from db_pwrdev_data_history."+tableName+" where record_time>='"+ ThreadLocalUtil.format(startTime,1)+"' ";
			List<PwrdevDataHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			@@ -1301,7 +1421,7 @@
			return list;
			}

			//44,70,104，108-SubTablePageInfoUtils.java;121行,115行
			//44,70,104，108,122,134-SubTablePageInfoUtils.java;121行,115行
			public int getCountForInterface_batt(InterfaceParam param){
			String sql="SELECT count(*) as number FROM db_alarm."+param.getRecordYear()+" history,db_battinf.tb_battinf " +
			" where history.battgroupid=db_battinf.tb_battinf.battgroupid ";
			@@ -1316,10 +1436,10 @@
			sql+=")";
			}
			if(param.getStartTime()!=null){
			sql+=" and alm_start_time >='"+ActionUtil.sdf.format(param.getStartTime())+"' ";
			sql+=" and alm_start_time >='"+ThreadLocalUtil.format(param.getStartTime(),1)+"' ";
			}
			if(param.getEndTime()!=null){
			sql+=" and alm_start_time <='"+ActionUtil.sdf.format(param.getEndTime())+"' ";
			sql+=" and alm_start_time <='"+ThreadLocalUtil.format(param.getEndTime(),1)+"' ";
			}
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			@@ -1344,8 +1464,8 @@
			//48-BattRealdataService.java;59行
			public List<RealDateDTO> serchByCondition(BattRealdata realdata){
			String sql="select * from db_batt_history.tb_batt_realdata_"+realdata.getTableName()+" " +
			" where recrod_time >= '"+ActionUtil.sdf.format(realdata.getRecrodTime())+"' " +
			" and recrod_time <= '"+ActionUtil.sdf.format(realdata.getRecrodTime1())+"' " +
			" where recrod_time >= '"+ThreadLocalUtil.format(realdata.getRecrodTime(),1)+"' " +
			" and recrod_time <= '"+ThreadLocalUtil.format(realdata.getRecrodTime1(),1)+"' " +
			" and mon_num ="+realdata.getMonNum()+" " +
			" order by recrod_time asc";
			List<RealDateDTO> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@@ -1377,7 +1497,7 @@
			if(userLogs!=null&&userLogs.size()>0){
			for (int i=0;i<userLogs.size();i++) {
			UserLog bh=userLogs.get(i);
			sql+="("+bh.getUId()+","+bh.getOperationType()+",'"+ActionUtil.sdf.format(bh.getOperationTime())+"','"+bh.getTerminalIp()+"','"+bh.getOperationMsg()+"','"+bh.getOperationDetail()+
			sql+="("+bh.getUId()+","+bh.getOperationType()+",'"+ThreadLocalUtil.format(bh.getOperationTime(),1)+"','"+bh.getTerminalIp()+"','"+bh.getOperationMsg()+"','"+bh.getOperationDetail()+
			"',"+bh.getReadFlag()+")";
			if(i!=(userLogs.size()-1)){
			sql+=",";
			@@ -1462,7 +1582,7 @@
			return list;
			}

			//66，68，80,99-SubTablePageInfoUtils.java;80行
			//66，68，80,99,132-SubTablePageInfoUtils.java;80行
			public int getCount(AlarmPar param){
			String sql="select count(distinct history.num) as number " +
			" from db_alarm."+param.getRecordYear()+" history,db_battinf.tb_battinf " +
			@@ -1470,7 +1590,7 @@
			" and alm_id in("+param.getAlmIdOne()+","+param.getAlmIdTwo()+", "+param.getAlmIdThree()+ ", "+param.getAlmIdFour()+ ", "+param.getAlmIdFive()+ ", "+param.getAlmIdSix()+ ", "+param.getAlmIdSeven()+ ", "+param.getAlmIdEight()+ ") " +
			" and alm_signal_id%2 in("+param.getAlmSignalIdOne()+","+param.getAlmSignalIdTwo()+") " +
			" and alm_level in( "+param.getAlmLevelOne()+ ", "+param.getAlmLevelTwo()+ ", "+param.getAlmLevelThree()+ ", "+param.getAlmLevelFour()+ ") " +
			" and alm_start_time>='"+ActionUtil.sdf.format(param.getAlmStartTime())+"' and alm_start_time <='"+ActionUtil.sdf.format(param.getAlmStartTime1())+"' " +
			" and alm_start_time>='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' and alm_start_time <='"+ThreadLocalUtil.format(param.getAlmStartTime1(),1)+"' " +
			" and db_battinf.tb_battinf.stationname1 like '%"+param.getStationname1()+"%' " +
			" and db_battinf.tb_battinf.stationname like '%"+param.getStationname()+"%' ";
			if(param.getBattGroupId()==0){
			@@ -1563,8 +1683,9 @@
			//0-BattRealdataController.java;50行
			public List<BattRealdata> serchDate100( String table){
			String sql="select distinct num, recrod_time, group_vol, online_vol, group_curr" +
			" from db_batt_history.tb_batt_realdata_"+table+" " +
			" order by recrod_time desc limit 0, 100";
			" from db_batt_history.tb_batt_realdata_"+table+" " +
			" where mon_num=1 " +
			"order by recrod_time desc limit 0, 100";
			List<BattRealdata> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			@@ -1586,7 +1707,7 @@

			//92-PwrdevDataHistoryService.java;74行
			public List<PwrdevDataHistory> getLtEndTime( String tableName, Date endTime){
			String sql=" select * from db_pwrdev_data_history."+tableName+" where record_time<='"+ ActionUtil.sdf.format(endTime)+"' ";
			String sql=" select * from db_pwrdev_data_history."+tableName+" where record_time<='"+ ThreadLocalUtil.format(endTime,1)+"' ";
			List<PwrdevDataHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			@@ -1712,8 +1833,8 @@
			for (int i=0;i<temp.size();i++) {
			DevalarmDataHistory bh=temp.get(i);
			sql+="("+bh.getRecordId()+","+bh.getDevId()+",'"+bh.getDevIp()+"',"+bh.getAlmType()+","+bh.getAlmLevel()+
			",'"+ActionUtil.sdf.format(bh.getAlmStartTime())+"','"+ActionUtil.sdf.format(bh.getAlmEndTime())+"',"+bh.getAlmValue()+","+bh.getAlmIsConfirmed()+"," +
			"'"+ActionUtil.sdf.format(bh.getAlmConfirmedTime())+"',"+bh.getAlmClearedType()+","+bh.getUsrId()+","+bh.getAlmSeverity()+")";
			",'"+ThreadLocalUtil.format(bh.getAlmStartTime(),1)+"','"+ThreadLocalUtil.format(bh.getAlmEndTime(),1)+"',"+bh.getAlmValue()+","+bh.getAlmIsConfirmed()+"," +
			"'"+ThreadLocalUtil.format(bh.getAlmConfirmedTime(),1)+"',"+bh.getAlmClearedType()+","+bh.getUsrId()+","+bh.getAlmSeverity()+")";
			if(i!=(temp.size()-1)){
			sql+=",";
			}
			@@ -1724,7 +1845,7 @@

			//115-PwrdevDataHistoryService.java;89行
			public List<PwrdevDataHistory> getWeekOrDayData( String tableName,Date startTime,Date endTime){
			String sql=" select * from db_pwrdev_data_history."+tableName+" where record_time>='"+ActionUtil.sdf.format(startTime)+"' and record_time<='"+ActionUtil.sdf.format(endTime)+"' ";
			String sql=" select * from db_pwrdev_data_history."+tableName+" where record_time>='"+ThreadLocalUtil.format(startTime,1)+"' and record_time<='"+ThreadLocalUtil.format(endTime,1)+"' ";
			List<PwrdevDataHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			@@ -1807,4 +1928,1553 @@
			});
			return list;
			}

			//119-HistoryDataArchivingService.java;127行
			public void createTable4DevAlarmDataHistoryByYear( String year){
			String sql=" CREATE TABLE db_alarm.`tb_devalarm_data_history_"+year+"` ( " +
			" `num` bigint(20) NOT NULL AUTO_INCREMENT, " +
			" `record_id` bigint(20) NOT NULL DEFAULT '0', " +
			" `dev_id` int(11) NOT NULL DEFAULT '0', " +
			" `dev_ip` varchar(24) NOT NULL DEFAULT '127.0.0.1', " +
			" `alm_type` int(11) NOT NULL DEFAULT '0', " +
			" `alm_level` int(11) NOT NULL DEFAULT '0', " +
			" `alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00', " +
			" `alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00', " +
			" `alm_value` float NOT NULL DEFAULT '0', " +
			" `alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0', " +
			" `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00', " +
			" `alm_cleared_type` int(11) NOT NULL DEFAULT '0', " +
			" `usr_Id` int(11) NOT NULL DEFAULT '0', " +
			" `alm_severity` int(11) NOT NULL DEFAULT '0', " +
			" PRIMARY KEY (`num`), " +
			" KEY `index_record_id` (`record_id`), " +
			" KEY `index_dev_id` (`dev_id`), " +
			" KEY `index_alm_type` (`alm_type`), " +
			" KEY `index_alm_start_time` (`alm_start_time`), " +
			" KEY `index_alm_cleared_type` (`alm_cleared_type`) " +
			" ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8";
			sqlExecuteService.execute(sql);
			}

			//121-SubTablePageInfoUtils.java;503行
			public List<BattalarmDataHistory> getLevelSubList_dev(int uId, String tableName){
			String sql=" SELECT distinct history.num,history.alm_level " +
			" FROM db_alarm."+tableName+" history, " +
			" db_battinf.tb_battinf " +
			" where history.dev_id = db_battinf.tb_battinf.FbsDeviceId " +
			" and alm_level in(1,2,3,4) " +
			" and history.dev_id 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 = "+uId+")";
			List<BattalarmDataHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattalarmDataHistory> list=new ArrayList<>();
			while (rs.next()){
			BattalarmDataHistory ph=new BattalarmDataHistory();
			ph.setNum(rs.getLong("num"));
			ph.setAlmLevel(rs.getInt("alm_level"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//125-BattmonTestcapService.java;42行
			public void del(BattmonTestcap btcp){
			String sql="delete from db_battinf."+btcp.getTableName()+" " +
			" where monvolstd="+btcp.getMonvolstd()+" and moncapstd="+btcp.getMoncapstd()+" and battproducer='"+btcp.getBattproducer()+"' and " +
			" battmodel='"+btcp.getBattmodel()+"' and note='"+btcp.getNote()+"' ";
			sqlExecuteService.execute(sql);
			}

			//130-SubTablePageInfoUtils.java;506行
			public List<BattalarmDataHistory> getLevelSubList_pwr(int uId, String tableName, List<Integer> almTypes){
			String sql="SELECT distinct alarm.num,alarm.alm_level " +
			" from db_pwrdev_alarm."+tableName+" alarm,db_pwrdev_inf.tb_pwrdev_inf " +
			" inf where alarm.PowerDeviceId = inf.PowerDeviceId " +
			" and alm_level in(1,2,3,4) " ;
			if(almTypes!=null&&almTypes.size()>0){
			sql+=" and alm_type in ( ";
			for (int i=0;i<almTypes.size();i++) {
			sql+=almTypes.get(i);
			if(i!=(almTypes.size()-1)){
			sql+=",";
			}
			}
			sql+=")";
			}
			sql+=" and StationId in ( select distinct inf.StationId from " +
			" (select StationId from db_battinf.tb_battinf union select StationId from db_pwrdev_inf.tb_pwrdev_inf ) inf, " +
			" 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.StationId=inf.StationId " +
			" 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="+uId+" )";
			List<BattalarmDataHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattalarmDataHistory> list=new ArrayList<>();
			while (rs.next()){
			BattalarmDataHistory ph=new BattalarmDataHistory();
			ph.setNum(rs.getLong("num"));
			ph.setAlmLevel(rs.getInt("alm_level"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//1-PwrdevHistorydataGwMapper.xml;11行
			public List<Integer> searchMaxNum2(Date startTime, Date stopTime,String table){
			String sql="(SELECT num " +
			" FROM db_pwrdev_data_history_gw.tb_pwrdev_historydata_gw_"+table+" " +
			" WHERE record_time BETWEEN '"+ThreadLocalUtil.format(startTime,1)+"' " +
			" AND '"+ThreadLocalUtil.format(stopTime,1)+"' " +
			" ORDER BY record_time asc limit 1) " +
			" union all " +
			" (SELECT num " +
			" FROM db_pwrdev_data_history_gw.tb_pwrdev_historydata_gw_"+table+" " +
			" WHERE record_time BETWEEN '"+ThreadLocalUtil.format(startTime,1)+"' " +
			" AND '"+ThreadLocalUtil.format(stopTime,1)+"' " +
			" ORDER BY record_time desc limit 1)";
			List<Integer> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<Integer> list=new ArrayList<>();
			while (rs.next()){
			list.add(rs.getInt("num"));
			}
			return list;
			}
			});
			return list;
			}

			//4-StandardFeatureCurveMapper.xml;6行
			public void insertBatch(String titleNameUnion, List<StandardFeatureCurve> curveList2){
			String sql="insert into `web_site`.`tb_standard_feature_curve_"+titleNameUnion+"` (`time`,`value`) values ";
			if(curveList2!=null&&curveList2.size()>0){
			for (int i=0;i<curveList2.size();i++) {
			StandardFeatureCurve bh=curveList2.get(i);
			sql+="('"+bh.getTime()+"',"+bh.getValue()+")";
			if(i!=(curveList2.size()-1)){
			sql+=",";
			}
			}
			}
			sqlExecuteService.execute(sql);
			}
			//100-StandardFeatureCurveMapper.xml;12行
			public void createTable(String titleNameUnion){
			String sql="CREATE TABLE `web_site`.`tb_standard_feature_curve_"+titleNameUnion+"` ( " +
			" `id` INT NOT NULL AUTO_INCREMENT, " +
			" `time` VARCHAR(45) NULL, " +
			" `value` DOUBLE NULL, " +
			" PRIMARY KEY (`id`));";
			sqlExecuteService.execute(sql);
			}

			//6-FBOTestDataMapper.xml;21行
			public void delete(Integer battGroupId, Integer testRecordCount){
			String sql="delete from db_fbo_testdata.tb_fbotestdata_"+battGroupId+" where test_record_count = "+testRecordCount+" ";
			sqlExecuteService.execute(sql);
			}

			//7-ElePriceMapper.xml;22行
			public void deleteByNum(String tableName, int num){
			String sql=" delete from web_site."+tableName+" where num = "+num+" ";
			sqlExecuteService.execute(sql);
			}

			//10-BattalarmDataHistoryMapper.xml;224行
			public List<BattalarmDataHistory> getListByStationId(Date startTime, Date endTime, String stationId,String tableName){
			String sql="select h.*,b.StationName1,b.StationName2,b.StationName3,b.StationName5 from db_alarm."+tableName+" h,db_battinf.tb_battinf b " +
			" where h.BattGroupId = b.BattGroupId " ;
			if(stationId!=null&&!stationId.isEmpty()){
			sql+=" and b.stationId = '"+stationId+"' ";
			}
			sql+=" and h.alm_start_time >='"+ThreadLocalUtil.format(startTime,1)+"' and h.alm_start_time <= '"+ThreadLocalUtil.format(endTime,1)+"' ";
			List<BattalarmDataHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattalarmDataHistory> list=new ArrayList<>();
			while (rs.next()){
			BattalarmDataHistory data=new BattalarmDataHistory();
			data.setNum(rs.getLong("num"));
			data.setMonNum(rs.getInt("MonNum"));
			data.setRecordId(rs.getLong("Record_Id"));
			data.setBattGroupId(rs.getInt("BattGroupId"));
			data.setAlmSignalId(rs.getInt("alm_signal_id"));
			data.setAlmValue(rs.getFloat("alm_value"));
			data.setAlmLevel(rs.getInt("alm_level"));
			data.setAlmIsConfirmed(rs.getInt("alm_is_confirmed"));
			data.setAlmConfirmedTime(rs.getTimestamp("alm_confirmed_time"));
			data.setAlmStartTime(rs.getTimestamp("alm_start_time"));
			data.setAlmEndTime(rs.getTimestamp("alm_end_time"));
			data.setUsrId(rs.getInt("usr_Id"));
			data.setAlmSeverity(rs.getInt("alm_severity"));
			data.setStationName1(rs.getString("StationName1"));
			data.setStationName2(rs.getString("StationName2"));
			data.setStationName3(rs.getString("StationName3"));
			data.setStationName5(rs.getString("StationName5"));
			list.add(data);
			}
			return list;
			}
			});
			return list;
			}

			//12-ElePriceMapper.xml;4行
			public void addElePrice(ElePrice elePrice){
			String sql=" insert into web_site.tb_eleprice_"+elePrice.getTmpId()+" (Tmp_id,Tmp_starttime,Tmp_stoptime,Ele_price) " +
			" values( "+elePrice.getTmpId()+",'"+ThreadLocalUtil.format(elePrice.getTmpStarttime(),4)+"','"+ThreadLocalUtil.format(elePrice.getTmpStoptime(),4)+"',"+elePrice.getElePrice()+")";
			sqlExecuteService.execute(sql);
			}
			//15-BattResDataMapper.xml;15行
			public BattResData getMinInfo(Integer battGroupId, Integer testRecordCount){
			String sql=" select mon_num ,mon_vol from db_batt_testdata.tb_battresdata_"+battGroupId+" " +
			" where mon_vol=(select min(mon_vol) from db_batt_testdata.tb_battresdata_"+battGroupId+" where test_record_count="+testRecordCount+" ) limit 1";
			List<BattResData> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattResData> list=new ArrayList<>();
			while (rs.next()){
			BattResData bh=new BattResData();
			bh.setMonNum(rs.getInt("mon_num"));
			bh.setMonVol(rs.getFloat("mon_vol"));
			list.add(bh);
			}
			return list;
			}
			});
			BattResData bres=null;
			if(list!=null&&list.size()>0){
			bres=list.get(0);
			}
			return bres;

			}
			//16-Ld9testdatastopMapper.xml;16行
			public List<Ld9testdatastop> searchlinftestdata(Ld9testdataInf linf){
			String sql="select * from db_ld9_testdata.tb_ld9testdatastop_"+linf.getBattGroupId()+" " +
			" where test_record_count="+linf.getTestRecordCount()+" order by mon_num asc";
			List<Ld9testdatastop> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<Ld9testdatastop> list=new ArrayList<>();
			while (rs.next()){
			Ld9testdatastop ph=new Ld9testdatastop();
			ph.setNum(rs.getLong("num"));
			ph.setBattGroupId(rs.getInt("BattGroupId"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setTestType(rs.getInt("test_type"));
			ph.setRecordNum(rs.getInt("record_num"));
			ph.setTestStarttime(rs.getTimestamp("test_starttime"));
			ph.setRecordTime(rs.getTimestamp("record_time"));
			ph.setTestTimelong(rs.getInt("test_timelong"));
			ph.setOnlineVol(rs.getFloat("online_vol"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setMonTmp(rs.getFloat("mon_tmp"));
			ph.setTestMonnum(rs.getInt("test_monnum"));
			ph.setMaxMonvol(rs.getFloat("max_monvol"));
			ph.setMinMonvol(rs.getFloat("min_monvol"));
			ph.setTestStopreason(rs.getInt("test_stopreason"));
			ph.setMonCap(rs.getFloat("mon_cap"));
			ph.setMonRestCap(rs.getFloat("mon_rest_cap"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//17-BattTestparamMapper.xml;5行
			public int judgeTable( String battGroupId){
			String sql="select count(*) as tableNum " +
			" from INFORMATION_SCHEMA.TABLES " +
			" where TABLE_SCHEMA = 'db_dev_testparam' " +
			" and TABLE_NAME = 'tb_batt_testparam_"+battGroupId+"'";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("tableNum"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			int tableNum =0;
			if(list!=null){
			tableNum= (int) list.get(0);
			}
			return tableNum;
			}

			//18-PwrdevHistorydataGwMapper.xml;24行
			public List<PwrdevHistorydataGw> serchByCondition(Date startTime, Date stopTime, String table, int roteN){
			String sql=" select * from (select a.*, (@i:= @i+1) as number " +
			" from (select * " +
			" from db_pwrdev_data_history_gw.tb_pwrdev_historydata_gw_"+table+" " +
			" where record_time >= '"+ThreadLocalUtil.format(startTime,1)+"' " +
			" and record_time <= '"+ThreadLocalUtil.format(stopTime,1)+"' " +
			" ) a, " +
			" (select @i:=0) b) c " +
			" where c.number%"+roteN+"=0" ;
			List<PwrdevHistorydataGw> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<PwrdevHistorydataGw> list=new ArrayList<>();
			while (rs.next()){
			PwrdevHistorydataGw ph=new PwrdevHistorydataGw();
			ph.setNum(rs.getLong("num"));
			ph.setRecordTime(rs.getTimestamp("record_time"));
			ph.setPowerdeviceid(rs.getLong("powerdeviceid"));
			ph.setAcin1Vola(rs.getFloat("acin1_vola"));
			ph.setAcin1Volb(rs.getFloat("acin1_volb"));
			ph.setAcin1Volc(rs.getFloat("acin1_volc"));
			ph.setAcin2Vola(rs.getFloat("acin2_vola"));
			ph.setAcin2Volb(rs.getFloat("acin2_volb"));
			ph.setAcin2Volc(rs.getFloat("acin2_volc"));
			ph.setAcin1Curra(rs.getFloat("acin1_curra"));
			ph.setAcin1Currb(rs.getFloat("acin1_currb"));
			ph.setAcin1Currc(rs.getFloat("acin1_currc"));
			ph.setAcin2Curra(rs.getFloat("acin2_curra"));
			ph.setAcin2Currb(rs.getFloat("acin2_currb"));
			ph.setAcin2Currc(rs.getFloat("acin2_currc"));
			ph.setDcoutVol(rs.getFloat("dcout_vol"));
			ph.setDcoutCurr(rs.getFloat("dcout_curr"));
			ph.setBattgroup1Vol(rs.getFloat("battgroup1_vol"));
			ph.setBattgroup1Curr(rs.getFloat("battgroup1_curr"));
			ph.setBattgroup2Vol(rs.getFloat("battgroup2_vol"));
			ph.setBattgroup2Curr(rs.getFloat("battgroup2_curr"));
			ph.setM1OutVol(rs.getFloat("m1_out_vol"));
			ph.setM2OutVol(rs.getFloat("m2_out_vol"));
			ph.setM3OutVol(rs.getFloat("m3_out_vol"));
			ph.setM4OutVol(rs.getFloat("m4_out_vol"));
			ph.setM5OutVol(rs.getFloat("m5_out_vol"));
			ph.setM6OutVol(rs.getFloat("m6_out_vol"));
			ph.setM7OutVol(rs.getFloat("m7_out_vol"));
			ph.setM8OutVol(rs.getFloat("m8_out_vol"));
			ph.setM9OutVol(rs.getFloat("m9_out_vol"));
			ph.setM10OutVol(rs.getFloat("m10_out_vol"));
			ph.setM11OutVol(rs.getFloat("m11_out_vol"));
			ph.setM12OutVol(rs.getFloat("m12_out_vol"));
			ph.setM13OutVol(rs.getFloat("m13_out_vol"));
			ph.setM14OutVol(rs.getFloat("m14_out_vol"));
			ph.setM15OutVol(rs.getFloat("m15_out_vol"));
			ph.setM16OutVol(rs.getFloat("m16_out_vol"));
			ph.setM1Outcurr(rs.getFloat("m1_outcurr"));
			ph.setM2Outcurr(rs.getFloat("m2_outcurr"));
			ph.setM3Outcurr(rs.getFloat("m3_outcurr"));
			ph.setM4Outcurr(rs.getFloat("m4_outcurr"));
			ph.setM5Outcurr(rs.getFloat("m5_outcurr"));
			ph.setM6Outcurr(rs.getFloat("m6_outcurr"));
			ph.setM7Outcurr(rs.getFloat("m7_outcurr"));
			ph.setM8Outcurr(rs.getFloat("m8_outcurr"));
			ph.setM9Outcurr(rs.getFloat("m9_outcurr"));
			ph.setM10Outcurr(rs.getFloat("m10_outcurr"));
			ph.setM11Outcurr(rs.getFloat("m11_outcurr"));
			ph.setM12Outcurr(rs.getFloat("m12_outcurr"));
			ph.setM13Outcurr(rs.getFloat("m13_outcurr"));
			ph.setM14Outcurr(rs.getFloat("m14_outcurr"));
			ph.setM15Outcurr(rs.getFloat("m15_outcurr"));
			ph.setM16Outcurr(rs.getFloat("m16_outcurr"));
			ph.setMTemper1(rs.getFloat("m_temper1"));
			ph.setMTemper2(rs.getFloat("m_temper2"));
			ph.setMHumidity1(rs.getFloat("m_humidity1"));
			ph.setMHumidity2(rs.getFloat("m_humidity2"));
			ph.setUseracin1Vola(rs.getFloat("useracin1_vola"));
			ph.setUseracin1Volb(rs.getFloat("useracin1_volb"));
			ph.setUseracin1Volc(rs.getFloat("useracin1_volc"));
			ph.setUseracin1Curra(rs.getFloat("useracin1_curra"));
			ph.setUseracin1Currb(rs.getFloat("useracin1_currb"));
			ph.setUseracin1Currc(rs.getFloat("useracin1_currc"));
			ph.setUseracin2Vola(rs.getFloat("useracin2_vola"));
			ph.setUseracin2Volb(rs.getFloat("useracin2_volb"));
			ph.setUseracin2Volc(rs.getFloat("useracin2_volc"));
			ph.setUseracin2Curra(rs.getFloat("useracin2_curra"));
			ph.setUseracin2Currb(rs.getFloat("useracin2_currb"));
			ph.setUseracin2Currc(rs.getFloat("useracin2_currc"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//19-Ld9testdatastopMapper.xml;6行
			public List<Ld9testdatastop> serchByInfo(int testRecordCount, int battGroupId, int testMonNum){
			String sql=" select num,BattGroupId,test_record_count,test_type,test_starttime,record_time,test_timelong,group_vol,test_curr,test_cap,mon_cap,mon_rest_cap,mon_num,mon_vol,test_monnum,max_monvol,min_monvol,test_stopreason " +
			" from db_ld9_testdata.tb_ld9testdatastop_"+battGroupId+" " +
			" where test_record_count="+testRecordCount+" and test_monnum="+testMonNum+" ";
			List<Ld9testdatastop> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<Ld9testdatastop> list=new ArrayList<>();
			while (rs.next()){
			Ld9testdatastop ph=new Ld9testdatastop();
			ph.setNum(rs.getLong("num"));
			ph.setBattGroupId(rs.getInt("BattGroupId"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setTestType(rs.getInt("test_type"));
			ph.setTestStarttime(rs.getTimestamp("test_starttime"));
			ph.setRecordTime(rs.getTimestamp("record_time"));
			ph.setTestTimelong(rs.getInt("test_timelong"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setTestMonnum(rs.getInt("test_monnum"));
			ph.setMaxMonvol(rs.getFloat("max_monvol"));
			ph.setMinMonvol(rs.getFloat("min_monvol"));
			ph.setTestStopreason(rs.getInt("test_stopreason"));
			ph.setMonCap(rs.getFloat("mon_cap"));
			ph.setMonRestCap(rs.getFloat("mon_rest_cap"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//97-Ld9testdatastopMapper.xml;11行
			public List<Ld9testdatastop> serchByCondition(int testRecordCount, int battGroupId){
			String sql=" select num,BattGroupId,test_record_count,test_type,test_starttime,record_time,test_timelong,group_vol,test_curr,test_cap,mon_cap,mon_rest_cap,mon_num,mon_vol,test_monnum,max_monvol,min_monvol,test_stopreason " +
			" from db_ld9_testdata.tb_ld9testdatastop_"+battGroupId+" " +
			" where test_record_count="+testRecordCount+" ";
			List<Ld9testdatastop> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<Ld9testdatastop> list=new ArrayList<>();
			while (rs.next()){
			Ld9testdatastop ph=new Ld9testdatastop();
			ph.setNum(rs.getLong("num"));
			ph.setBattGroupId(rs.getInt("BattGroupId"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setTestType(rs.getInt("test_type"));
			ph.setTestStarttime(rs.getTimestamp("test_starttime"));
			ph.setRecordTime(rs.getTimestamp("record_time"));
			ph.setTestTimelong(rs.getInt("test_timelong"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setTestMonnum(rs.getInt("test_monnum"));
			ph.setMaxMonvol(rs.getFloat("max_monvol"));
			ph.setMinMonvol(rs.getFloat("min_monvol"));
			ph.setTestStopreason(rs.getInt("test_stopreason"));
			ph.setMonCap(rs.getFloat("mon_cap"));
			ph.setMonRestCap(rs.getFloat("mon_rest_cap"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//20-BattResDataMapper.xml;12行
			public Float calcAvgVol(Integer battGroupId, Integer testRecordCount){
			String sql="select avg(binary mon_vol) as monVol from db_batt_testdata.tb_battresdata_"+battGroupId+" where test_record_count= "+testRecordCount+" ";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getFloat("monVol"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			Float monVol =0f;
			if(list!=null){
			monVol= (Float) list.get(0);
			}
			return monVol;
			}

			//64-ElePriceMapper.xml;18行
			public void deleteEleprice(String tableName){
			String sql=" delete from web_site."+tableName+" ";
			sqlExecuteService.execute(sql);
			}
			//23-ElePriceMapper.xml;8行
			public void createEleprice(String tableName){
			String sql="CREATE TABLE IF NOT EXISTS web_site."+tableName+" ( " +
			" `num` int(11) NOT NULL AUTO_INCREMENT, " +
			" `tmp_id` int(11) NOT NULL DEFAULT '1001', " +
			" `tmp_starttime` TIME NOT NULL DEFAULT '00:00:00' COMMENT '开始时间', " +
			" `tmp_stoptime` TIME NOT NULL DEFAULT '00:00:00' COMMENT '结束时间', " +
			" `ele_price` float NOT NULL DEFAULT '0' COMMENT '电费价格', " +
			" PRIMARY KEY (`num`) " +
			" )";
			sqlExecuteService.execute(sql);
			}
			//75-ElePriceMapper.xml;25行
			public List<ElePrice> getList(String tableName){
			String sql="select * from web_site."+tableName+" order by tmp_starttime asc";
			List<ElePrice> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<ElePrice> list=new ArrayList<>();
			while (rs.next()){
			ElePrice ph=new ElePrice();
			ph.setNum(rs.getInt("num"));
			ph.setTmpId(rs.getInt("tmp_id"));
			ph.setTmpStarttime(rs.getTimestamp("tmp_starttime"));
			ph.setTmpStoptime(rs.getTimestamp("tmp_stoptime"));
			ph.setElePrice(rs.getFloat("ele_price"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//24-BattRealdataMapper.xml;23行
			public int judgeTable_realdata( String table){
			String sql="select count(*) as tableNum " +
			" from INFORMATION_SCHEMA.TABLES " +
			" where TABLE_SCHEMA = 'db_batt_history' " +
			" and TABLE_NAME = 'tb_batt_realdata_"+table+"'";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("tableNum"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			int tableNum =0;
			if(list!=null){
			tableNum= (int) list.get(0);
			}
			return tableNum;
			}

			//29-BattRealdataMapper.xml;42行
			public List<Integer> searchMaxNum2(BattRealdata realdata){
			String sql="(SELECT " +
			" num " +
			" FROM " +
			" db_batt_history.`tb_batt_realdata_"+realdata.getTableName()+"` " +
			" WHERE " +
			" recrod_time BETWEEN '"+ThreadLocalUtil.format(realdata.getRecrodTime(),1)+"' " +
			" AND '"+ThreadLocalUtil.format(realdata.getRecrodTime1(),1)+"' " +
			" ORDER BY " +
			" recrod_time asc limit 1) " +
			" union all " +
			" (SELECT " +
			" num " +
			" FROM " +
			" db_batt_history.`tb_batt_realdata_"+realdata.getTableName()+"` " +
			" WHERE " +
			" recrod_time BETWEEN '"+ThreadLocalUtil.format(realdata.getRecrodTime(),1)+"' " +
			" AND '"+ThreadLocalUtil.format(realdata.getRecrodTime1(),1)+"' " +
			" ORDER BY " +
			" recrod_time desc limit 1)";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("num"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			return list;
			}

			//92-BattRealdataMapper.xml;29行
			public int searchMaxNum(BattRealdata realdata){
			String sql="select count(*) as maxNum " +
			" from db_batt_history.tb_batt_realdata_"+realdata.getTableName()+" " +
			" where recrod_time >= '"+ThreadLocalUtil.format(realdata.getRecrodTime(),1)+"' " +
			" and recrod_time <= '"+ThreadLocalUtil.format(realdata.getRecrodTime1(),1)+"' " +
			" and mon_num = "+realdata.getMonNum()+" ";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("maxNum"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			int maxNum =0;
			if(list!=null){
			maxNum= (int) list.get(0);
			}
			return maxNum;
			}
			//105-BattRealdataMapper.xml;36行
			public int searchMinNum(BattRealdata realdata){
			String sql="select min(num) as minNum " +
			" from db_batt_history.tb_batt_realdata_"+realdata.getTableName()+" " +
			" where mon_num = "+realdata.getMonNum()+" ";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("minNum"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			int minNum =0;
			if(list!=null){
			minNum= (int) list.get(0);
			}
			return minNum;
			}

			//BattRealdataMapper.xml;63行
			public List<RealDateDTO> serchByCondition2(BattRealdata realdata){
			String sql=" select recrod_time, " +
			" group_vol, " +
			" online_vol, " +
			" group_curr, " +
			" mon_vol, " +
			" mon_tmp, " +
			" mon_res, " +
			" mon_num " +
			" from (select a.*, (@i:= @i+1) as number " +
			" from (select * " +
			" from db_batt_history.tb_batt_realdata_"+realdata.getTableName()+" " +
			" where recrod_time >= '"+ThreadLocalUtil.format(realdata.getRecrodTime(),1)+"' " +
			" and recrod_time <= '"+ThreadLocalUtil.format(realdata.getRecrodTime1(),1)+"' " +
			" and mon_num = "+realdata.getMonNum()+") a, " +
			" (select @i:=0) b) c " +
			" where c.number%"+realdata.getRoteN()+"=0";
			List<RealDateDTO> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<RealDateDTO> list=new ArrayList<>();
			while (rs.next()){
			RealDateDTO ph=new RealDateDTO();
			ph.setRecrodTime(rs.getTimestamp("recrod_time"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setOnlineVol(rs.getFloat("online_vol"));
			ph.setGroupCurr(rs.getFloat("group_curr"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setMonTmp(rs.getFloat("mon_tmp"));
			ph.setMonRes(rs.getFloat("mon_res"));
			ph.setMonNum(rs.getInt("mon_num"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//32-BattTestDataStopMapper.xml;26行
			public List<BattTestDataStop> getList(int battGroupId,int testRecordCount){
			String sql="SELECT DISTINCT battGroupId, test_curr, test_cap, mon_num, mon_vol " +
			" FROM " +
			" db_batt_testdata.tb_batttestdatastop_"+battGroupId+" " +
			" WHERE " +
			" test_record_count = "+testRecordCount+" " +
			" AND data_available = 1";
			List<BattTestDataStop> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattTestDataStop> list=new ArrayList<>();
			while (rs.next()){
			BattTestDataStop ph=new BattTestDataStop();
			ph.setBattGroupId(rs.getInt("battGroupId"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setMonNum(rs.getInt("mon_num"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//33-PwrdevAlarmHistoryMapper.xml;362行
			public List<PwrdevAlarmHistory> getListByStationId_pwr(Date startTime, Date endTime, String stationId,String tableName){
			String sql=" select h.*,b.StationName1,b.StationName2,b.StationName3,b.StationName5 from db_pwrdev_alarm."+tableName+" h,db_pwrdev_inf.tb_pwrdev_inf b " +
			" where h.PowerDeviceId = b.PowerDeviceId " ;
			if(stationId !=null&&!stationId.isEmpty()){
			sql+=" and b.stationId = '"+stationId+"' ";
			}
			sql+=" and h.alm_start_time >= '"+ThreadLocalUtil.format(startTime,1)+"' and h.alm_start_time <='"+ThreadLocalUtil.format(endTime,1)+"' ";
			List<PwrdevAlarmHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<PwrdevAlarmHistory> list=new ArrayList<>();
			while (rs.next()){
			PwrdevAlarmHistory ph=new PwrdevAlarmHistory();
			ph.setNum(rs.getLong("num"));
			ph.setRecordId(rs.getLong("record_id"));
			ph.setPowerDeviceId(rs.getLong("PowerDeviceId"));
			ph.setAlmType(rs.getInt("alm_type"));
			ph.setAlmLevel(rs.getInt("alm_level"));
			ph.setAlmSource(rs.getInt("alm_source"));
			ph.setAlmIndex(rs.getInt("alm_index"));
			ph.setAlmStartTime(rs.getTimestamp("alm_start_time"));
			ph.setAlmEndTime(rs.getTimestamp("alm_end_time"));
			ph.setAlmValue(rs.getFloat("alm_value"));
			ph.setAlmIsConfirmed(rs.getInt("alm_is_confirmed"));
			ph.setAlmConfirmedTime(rs.getTimestamp("alm_confirmed_time"));
			ph.setAlmClearedType(rs.getInt("alm_cleared_type"));
			ph.setUsrId(rs.getInt("usr_Id"));
			ph.setAlmTrigger(rs.getInt("alm_trigger"));
			ph.setAlmSeverity(rs.getInt("alm_severity"));
			ph.setStationName1(rs.getString("StationName1"));
			ph.setStationName2(rs.getString("StationName2"));
			ph.setStationName3(rs.getString("StationName3"));
			ph.setStationName5(rs.getString("StationName5"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//35-Ld9testdataMapper.xml;12行
			public List<Ld9testdata> serchByCondition(int roteN, int testRecordCount, int battGroupId, int testMonNum){
			String sql="select num,BattGroupId,test_record_count,test_type,record_num,test_starttime,record_time,test_timelong,online_vol,group_vol" +
			",test_curr,test_cap,mon_cap,mon_rest_cap,mon_num,mon_vol,mon_tmp,test_monnum " +
			" from db_ld9_testdata.tb_ld9testdata_"+battGroupId+" " +
			" where test_record_count="+testRecordCount+" and (record_num%"+roteN+"=0 ) and test_monnum="+testMonNum+" ";
			List<Ld9testdata> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<Ld9testdata> list=new ArrayList<>();
			while (rs.next()){
			Ld9testdata ph=new Ld9testdata();
			ph.setNum(rs.getLong("num"));
			ph.setBattGroupId(rs.getInt("BattGroupId"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setTestType(rs.getInt("test_type"));
			ph.setRecordNum(rs.getInt("record_num"));
			ph.setTestStarttime(rs.getTimestamp("test_starttime"));
			ph.setRecordTime(rs.getTimestamp("record_time"));
			ph.setTestTimelong(rs.getInt("test_timelong"));
			ph.setOnlineVol(rs.getFloat("online_vol"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setTestMonnum(rs.getInt("test_monnum"));
			ph.setMonCap(rs.getFloat("mon_cap"));
			ph.setMonRestCap(rs.getFloat("mon_rest_cap"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//59-Ld9testdataMapper.xml;6行
			public List<Ld9testdata> serchByInfo(Ld9testdata ld9testdata){
			String sql=" select test_monnum,max(record_num) as record_nums,BattGroupId,test_record_count " +
			" from db_ld9_testdata.tb_ld9testdata_"+ld9testdata.getBattGroupId()+" " +
			" where test_record_count="+ld9testdata.getTestRecordCount()+" " +
			" GROUP BY test_monnum order by test_monnum asc";
			List<Ld9testdata> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<Ld9testdata> list=new ArrayList<>();
			while (rs.next()){
			Ld9testdata ph=new Ld9testdata();
			ph.setTestMonnum(rs.getInt("test_monnum"));
			ph.setRecordNums(rs.getInt("record_nums"));
			ph.setBattGroupId(rs.getInt("BattGroupId"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}
			//73-Ld9testdataMapper.xml;17行
			public List<Ld9testdata> getLD9AllGroupByTestRecordCount(Ld9testdataInf ld9inf){
			String sql="select * from db_ld9_testdata.tb_ld9testdata_"+ld9inf.getBattGroupId()+" " +
			" where test_record_count="+ld9inf.getTestRecordCount()+" order by mon_num asc";
			List<Ld9testdata> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<Ld9testdata> list=new ArrayList<>();
			while (rs.next()){
			Ld9testdata ph=new Ld9testdata();
			ph.setNum(rs.getLong("num"));
			ph.setBattGroupId(rs.getInt("BattGroupId"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setTestType(rs.getInt("test_type"));
			ph.setRecordNum(rs.getInt("record_num"));
			ph.setTestStarttime(rs.getTimestamp("test_starttime"));
			ph.setRecordTime(rs.getTimestamp("record_time"));
			ph.setTestTimelong(rs.getInt("test_timelong"));
			ph.setOnlineVol(rs.getFloat("online_vol"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setTestMonnum(rs.getInt("test_monnum"));
			ph.setMonCap(rs.getFloat("mon_cap"));
			ph.setMonRestCap(rs.getFloat("mon_rest_cap"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//62-Ld9testdataMapper.xml;22行
			public Map getLD9AllGroupTimeLong(Ld9testdataInf ld9inf){
			String sql="select mon_num,max(test_timelong) as max_testTimelong " +
			" from db_ld9_testdata.tb_ld9testdata_"+ld9inf.getBattGroupId()+" " +
			" where test_record_count="+ld9inf.getTestRecordCount()+" group by mon_num";
			List<Ld9testdata> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<Ld9testdata> list=new ArrayList<>();
			while (rs.next()){
			Ld9testdata ph=new Ld9testdata();
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setTestTimelong(rs.getInt("max_testTimelong"));
			list.add(ph);
			}
			return list;
			}
			});
			Map map=new HashMap();
			if(list!=null&&list.size()>0){
			for (Ld9testdata ld9:list) {
			map.put(ld9.getMonNum(),ld9.getTestTimelong());
			}
			}
			return map;
			}

			//37-BattTestDataStopMapper.xml;35行
			public Float calcAvgVol_stop(Integer battGroupId, Integer testRecordCount){
			String sql=" SELECT " +
			" AVG(BINARY mon_vol) AS mon_avg " +
			" FROM " +
			" db_batt_testdata.tb_batttestdatastop_"+battGroupId+" " +
			" WHERE " +
			" test_record_count = "+testRecordCount+" " +
			" AND data_available = 1 " +
			" ORDER BY BattgroupId";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getFloat("mon_avg"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			Float mon_avg =0f;
			if(list!=null){
			mon_avg= (Float) list.get(0);
			}
			return mon_avg;

			}

			//65-BattTestDataStopMapper.xml;6行
			public BattTestDataStop findByMonNum(Integer battGroupId,Integer monNum){
			String sql="select stop.battgroupid,stop.test_curr,stop.test_cap,stop.mon_vol,stop.test_record_count,stop.mon_num,stop.group_vol,inf.max_monvol " +
			" from db_batt_testdata.tb_batttestdatastop_"+battGroupId+" stop,db_batt_testdata.tb_batttestdata_inf inf " +
			" where stop.battGroupId = inf.battGroupId and stop.test_starttime = inf.test_starttime and stop.mon_num ="+monNum+" " +
			" and stop.data_available=1 and inf.test_type=3 " +
			" order by stop.test_starttime desc limit 1";
			List<BattTestDataStop> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattTestDataStop> list=new ArrayList<>();
			while (rs.next()){
			BattTestDataStop ph=new BattTestDataStop();
			ph.setBattGroupId(rs.getInt("battGroupId"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setMaxMonVol(rs.getFloat("max_monvol"));
			list.add(ph);
			}
			return list;
			}
			});
			BattTestDataStop btsp=null;
			if(list!=null&&list.size()>0){
			btsp=list.get(0);
			}
			return btsp;
			}

			//77-BattTestDataStopMapper.xml;13行
			public Float getRealCap(BattTestDataStop stop){
			String sql=" select test_cap from db_batt_testdata.tb_batttestdata_"+stop.getBattGroupId()+" " +
			" where test_record_count="+stop.getTestRecordCount()+" and mon_vol>"+stop.getMonVol()+" and mon_num="+stop.getMonNum()+" and data_available=1 " +
			" order by record_time desc limit 1";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List list=new ArrayList<>();
			while (rs.next()){
			list.add(rs.getFloat("test_cap"));
			}
			return list;
			}
			});
			float test_cap=0f;
			if(list!=null&&list.size()>0){
			test_cap= (float) list.get(0);
			}
			return test_cap;
			}

			//89-BattTestDataStopMapper.xml;20行
			public List<BattTestDataStop> getTestDataStop(Integer battGroupId, Date testStarttime){
			String sql=" select num,BattGroupId,test_record_count,test_type,data_new,data_available,record_num,test_starttime,record_time,test_timelong,online_vol" +
			",group_vol,test_curr,test_cap,mon_num,mon_vol,mon_tmp " +
			" from db_batt_testdata.tb_batttestdatastop_"+battGroupId+" " +
			" where test_starttime='"+ThreadLocalUtil.format(testStarttime,1)+"' " +
			" and data_available=1";
			List<BattTestDataStop> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattTestDataStop> list=new ArrayList<>();
			while (rs.next()){
			BattTestDataStop ph=new BattTestDataStop();
			ph.setBattGroupId(rs.getInt("battGroupId"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setTestType(rs.getInt("test_type"));
			ph.setDataNew(rs.getInt("data_new"));
			ph.setDataAvailable(rs.getInt("data_available"));
			ph.setRecordNum(rs.getInt("record_num"));
			ph.setTestStarttime(rs.getTimestamp("test_starttime"));
			ph.setRecordTime(rs.getTimestamp("record_time"));
			ph.setTestTimelong(rs.getInt("test_timelong"));
			ph.setOnlineVol(rs.getFloat("online_vol"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setMonTmp(rs.getFloat("mon_tmp"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//38,67--BattMaintDealarmMapper.xml;226行 210
			public List<ReportBattResultDTO> searchByBattGroupId5(ReportBattDTO dto){
			String sql=" select distinct(db_battinf.tb_battinf.BattgroupId),moncount,moncapstd,monvolstd,monresstd,monserstd,FloatVolLevel,OfflineVolLevel " +
			" ,db_batt_testdata.tb_battresdata_inf.battgroupid,db_batt_testdata.tb_battresdata_inf.test_record_count " +
			" ,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".group_vol,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".test_curr" +
			" ,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".test_starttime,mon_num,mon_vol,mon_tmp,mon_res,mon_ser,conn_res " +
			" from " +
			" db_battinf.tb_battinf,db_batt_testdata.tb_battresdata_inf,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+" " +
			" where " +
			" db_battinf.tb_battinf.BattgroupId=db_batt_testdata.tb_battresdata_inf.BattGroupId " +
			" and " +
			" db_batt_testdata.tb_battresdata_inf.BattGroupId=db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".battgroupid " +
			" and " +
			" db_batt_testdata.tb_battresdata_inf.test_record_count=db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".test_record_count " +
			" and db_battinf.tb_battinf.battgroupid="+dto.getBattGroupId()+" and " +
			" db_batt_testdata.tb_battresdata_inf.data_available=1 and " +
			" db_batt_testdata.tb_battresdata_inf.test_type="+dto.getTestType()+" " ;
			if(dto.getMonNum()!=0){
			sql+=" and db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".mon_num="+dto.getMonNum()+" ";
			}
			if(dto.getStationName1()!=null&&!dto.getStationName1().isEmpty()){
			sql+=" and stationname1='"+dto.getStationName1()+"' ";
			}
			if(dto.getStationName()!=null&&!dto.getStationName().isEmpty()){
			sql+=" and stationname='"+dto.getStationName()+"' ";
			}
			sql+=" order by db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".test_record_count asc,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".mon_num asc ";
			List<ReportBattResultDTO> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<ReportBattResultDTO> list=new ArrayList<>();
			while (rs.next()){
			ReportBattResultDTO ph=new ReportBattResultDTO();
			ph.setBattGroupId(rs.getInt("battGroupId"));
			ph.setMonCount(rs.getInt("moncount"));
			ph.setMonCapStd(rs.getFloat("moncapstd"));
			ph.setMonVolStd(rs.getFloat("monvolstd"));
			ph.setMonResStd(rs.getFloat("monresstd"));
			ph.setMonSerStd(rs.getFloat("monserstd"));
			ph.setFloatVolLevel(rs.getFloat("FloatVolLevel"));
			ph.setOfflineVolLevel(rs.getFloat("OfflineVolLevel"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setTestStartTime(rs.getTimestamp("test_starttime"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			ph.setMonTmp(rs.getFloat("mon_tmp"));
			ph.setMonSer(rs.getFloat("mon_ser"));
			ph.setMonRes(rs.getFloat("mon_res"));
			ph.setConnRes(rs.getFloat("conn_res"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//45-FBOTestDataMapper.xml;24行
			public List<FBOTestData> getList_fbo(int battGroupId, int testRecordCount){
			String sql=" select * from db_fbo_testdata.tb_fbotestdata_"+battGroupId+" where test_record_count = "+testRecordCount+" ";
			List<FBOTestData> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<FBOTestData> list=new ArrayList<>();
			while (rs.next()){
			FBOTestData ph=new FBOTestData();
			ph.setNum(rs.getInt("num"));
			ph.setBattGroupId(rs.getInt("BattGroupId"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setTestStartTime(rs.getTimestamp("test_starttime"));
			ph.setTestTimeLong(rs.getInt("test_timelong"));
			ph.setRecordTime(rs.getTimestamp("record_time"));
			ph.setRecordNum(rs.getInt("record_num"));
			ph.setOnlineVol(rs.getFloat("online_vol"));
			ph.setSumVol(rs.getFloat("sum_vol"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//76-FBOTestDataMapper.xml;27行
			public int getMonCuntBytestRecordCount(int battGroupId, int testRecordCount){
			String sql="select if(max(mon_num) is null,0,max(mon_num)) as monCount " +
			"from db_fbo_testdata.tb_fbotestdata_"+battGroupId+" where test_record_count = "+testRecordCount+" limit 1";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("monCount"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			int monCount =0;
			if(list!=null){
			monCount= (int) list.get(0);
			}
			return monCount;
			}

			//46-BattMaintDealarmMapper.xml;199行
			public List<ReportBattResultDTO> searchByBattGroupId(ReportBattDTO dto){
			String sql="select distinct(db_battinf.tb_battinf.BattgroupId),moncount,moncapstd,monvolstd,monresstd,monserstd,FloatVolLevel,OfflineVolLevel" +
			" ,db_batt_testdata.tb_batttestdata_inf.battgroupid,max_monvol,min_monvol,db_batt_testdata.tb_batttestdata_inf.test_record_count" +
			" ,db_batt_testdata.tb_batttestdata_inf.test_type,db_batt_testdata.tb_batttestdata_inf.test_record_count" +
			" ,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".test_starttime,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".record_time" +
			" ,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".test_timelong,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".group_vol" +
			" ,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".test_curr,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".test_cap" +
			" ,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".mon_num,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".mon_vol" +
			" from" +
			" db_battinf.tb_battinf,db_batt_testdata.tb_batttestdata_inf,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+" " +
			" where" +
			" db_battinf.tb_battinf.BattgroupId=db_batt_testdata.tb_batttestdata_inf.BattGroupId " +
			" and" +
			" db_batt_testdata.tb_batttestdata_inf.BattGroupId=db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".battgroupid " +
			" and" +
			" db_batt_testdata.tb_batttestdata_inf.test_record_count=db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".test_record_count " +
			" and" +
			" db_batt_testdata.tb_batttestdata_inf.record_num=db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".record_num " +
			" and db_battinf.tb_battinf.battgroupid="+dto.getBattGroupId()+" and " +
			" db_batt_testdata.tb_batttestdata_inf.data_available=1" +
			" and db_batt_testdata.tb_batttestdata_inf.test_type="+dto.getTestType()+" and " +
			" db_batt_testdata.tb_batttestdata_inf.test_starttype=3 " ;
			if(dto.getMonNum()!=0){
			sql+=" and db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".mon_num="+dto.getMonNum()+" ";
			}
			if(dto.getStationName1()!=null&&!dto.getStationName1().isEmpty()){
			sql+=" and stationname1='"+dto.getStationName1()+"' ";
			}
			if(dto.getStationName()!=null&&!dto.getStationName().isEmpty()){
			sql+=" and stationname='"+dto.getStationName()+"' ";
			}
			sql+=" order by db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".test_record_count asc,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".mon_num asc ";
			List<ReportBattResultDTO> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<ReportBattResultDTO> list=new ArrayList<>();
			while (rs.next()){
			ReportBattResultDTO ph=new ReportBattResultDTO();
			ph.setBattGroupId(rs.getInt("battGroupId"));
			ph.setMonCount(rs.getInt("moncount"));
			ph.setMonCapStd(rs.getFloat("moncapstd"));
			ph.setMonVolStd(rs.getFloat("monvolstd"));
			ph.setMonResStd(rs.getFloat("monresstd"));
			ph.setMonSerStd(rs.getFloat("monserstd"));
			ph.setFloatVolLevel(rs.getFloat("FloatVolLevel"));
			ph.setOfflineVolLevel(rs.getFloat("OfflineVolLevel"));
			ph.setMaxMonVol(rs.getFloat("max_monvol"));
			ph.setMinMonVol(rs.getFloat("min_monvol"));
			ph.setTestRecordCount(rs.getInt("test_record_count"));
			ph.setTestStartTime(rs.getTimestamp("test_starttime"));
			ph.setRecordTime(rs.getTimestamp("record_time"));
			ph.setTestTimeLong(rs.getInt("test_timelong"));
			ph.setGroupVol(rs.getFloat("group_vol"));
			ph.setTestCurr(rs.getFloat("test_curr"));
			ph.setTestCap(rs.getFloat("test_cap"));
			ph.setMonNum(rs.getInt("mon_num"));
			ph.setMonVol(rs.getFloat("mon_vol"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//49-PowerAppSysMapper.xml;12行
			public int updateFlag(String columnName){
			String sql=" update db_pwrdev_inf.tb_pwrapp_sys set "+columnName+"=1 limit 1 ";
			int flag=sqlExecuteService.executeUpdate(sql,null);
			return flag;
			}

			//52-BatttestdataInfMapper.xml;34行
			public int judge( int battGroupId){
			String sql="select count(table_name) as judgeNum from INFORMATION_SCHEMA.TABLES where table_name ='tb_batttestdatastop_"+battGroupId+"' and TABLE_SCHEMA='db_batt_testdata'";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("judgeNum"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			int judgeNum =0;
			if(list!=null){
			judgeNum= (int) list.get(0);
			}
			return judgeNum;
			}

			//55-DevalarmDataHistoryMapper.xml;215行
			public List<DevalarmDataHistory> getListByStationId_dev(Date startTime, Date endTime, String stationId,String tableName){
			String sql="select h.*,b.StationName,b.StationName1,b.StationName2,b.StationName3,b.StationName5 from db_alarm."+tableName+" h,db_battinf.tb_battinf b " +
			" where h.dev_id = b.FBSDeviceId " ;
			if(stationId!=null&&!stationId.isEmpty()){
			sql+=" and b.stationId ="+stationId+" ";
			}
			sql+=" and h.alm_start_time >= '"+ThreadLocalUtil.format(startTime,1)+"' and h.alm_start_time <= '"+ThreadLocalUtil.format(endTime,1)+"' ";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<DevalarmDataHistory> list=new ArrayList<>();
			while (rs.next()){
			DevalarmDataHistory ph=new DevalarmDataHistory();
			ph.setNum(rs.getLong("num"));
			ph.setDevId(rs.getInt("dev_id"));
			ph.setDevIp(rs.getString("dev_ip"));
			ph.setAlmType(rs.getInt("alm_type"));
			ph.setAlmLevel(rs.getInt("alm_level"));
			ph.setAlmStartTime(rs.getTimestamp("alm_start_time"));
			ph.setAlmEndTime(rs.getTimestamp("alm_end_time"));
			ph.setAlmIsConfirmed(rs.getInt("alm_is_confirmed"));
			ph.setAlmConfirmedTime(rs.getTimestamp("alm_confirmed_time"));
			ph.setAlmClearedType(rs.getInt("alm_cleared_type"));
			ph.setStationName(rs.getString("stationName"));
			ph.setStationName1(rs.getString("stationName1"));
			ph.setStationName2(rs.getString("stationName2"));
			ph.setStationName3(rs.getString("stationName3"));
			ph.setStationName5(rs.getString("stationName5"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}

			//60-PwrdevAlarmParamMapper.xml;27行
			public int updateParam(PwrdevAlarmParam param){
			String sql=" update db_pwrdev_alarm.tb_pwrdev_alarm_param_"+param.getPowerDeviceId()+" set alarm_limitH ="+param.getAlarmLimith()+"," +
			" alarm_limitL ="+param.getAlarmLimitl()+",alarm_level="+param.getAlarmLevel()+
			",UserAlarm_EN="+param.getUseralarmEn()+" where alarm_id ="+param.getAlarmId()+" ";
			int flag=sqlExecuteService.executeUpdate(sql,null);
			return flag;
			}

			//61-BattResDataMapper.xml;21行
			public List serchisStandard(int battGroupId){
			String sql=" select * from db_batt_testdata.tb_battresdata_"+battGroupId+" where isStandard=1 ";
			List<BattResData> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattResData> list=new ArrayList<>();
			while (rs.next()){
			BattResData bh=new BattResData();
			bh.setNum(rs.getLong("num"));
			bh.setBattGroupId(rs.getInt("BattGroupId"));
			bh.setTestRecordCount(rs.getInt("test_record_count"));
			bh.setTestType(rs.getInt("test_type"));
			bh.setDataNew(rs.getInt("data_new"));
			bh.setDataAvailable(rs.getInt("data_available"));
			bh.setTestStartTime(rs.getTimestamp("test_starttime"));
			bh.setGroupVol(rs.getFloat("group_vol"));
			bh.setTestCurr(rs.getFloat("test_curr"));
			bh.setMonNum(rs.getInt("mon_num"));
			bh.setMonVol(rs.getFloat("mon_vol"));
			bh.setMonTemp(rs.getFloat("mon_tmp"));
			bh.setMonSer(rs.getFloat("mon_ser"));
			bh.setMonRes(rs.getFloat("mon_res"));
			bh.setConnRes(rs.getFloat("conn_res"));
			list.add(bh);
			}
			return list;
			}
			});
			return list;
			}

			//78-BattResDataMapper.xml;24行
			public List serchCurrent( int battGroupId){
			String sql=" select * from db_batt_testdata.tb_battresdata_"+battGroupId+" " +
			" where test_starttime=( " +
			" SELECT DISTINCT test_starttime from db_batt_testdata.tb_battresdata_inf where BattGroupId="+battGroupId+" order by test_starttime desc limit 1 " +
			" )";
			List<BattResData> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattResData> list=new ArrayList<>();
			while (rs.next()){
			BattResData bh=new BattResData();
			bh.setNum(rs.getLong("num"));
			bh.setBattGroupId(rs.getInt("BattGroupId"));
			bh.setTestRecordCount(rs.getInt("test_record_count"));
			bh.setTestType(rs.getInt("test_type"));
			bh.setDataNew(rs.getInt("data_new"));
			bh.setDataAvailable(rs.getInt("data_available"));
			bh.setTestStartTime(rs.getTimestamp("test_starttime"));
			bh.setGroupVol(rs.getFloat("group_vol"));
			bh.setTestCurr(rs.getFloat("test_curr"));
			bh.setMonNum(rs.getInt("mon_num"));
			bh.setMonVol(rs.getFloat("mon_vol"));
			bh.setMonTemp(rs.getFloat("mon_tmp"));
			bh.setMonSer(rs.getFloat("mon_ser"));
			bh.setMonRes(rs.getFloat("mon_res"));
			bh.setConnRes(rs.getFloat("conn_res"));
			list.add(bh);
			}
			return list;
			}
			});
			return list;
			}
			//96-BattResDataMapper.xml;18行
			public List<BattResData> getResInfoByBattGroupId( int battGroupId){
			String sql="select * from db_batt_testdata.tb_battresdata_"+battGroupId+" order by test_starttime desc";
			List<BattResData> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<BattResData> list=new ArrayList<>();
			while (rs.next()){
			BattResData bh=new BattResData();
			bh.setNum(rs.getLong("num"));
			bh.setBattGroupId(rs.getInt("BattGroupId"));
			bh.setTestRecordCount(rs.getInt("test_record_count"));
			bh.setTestType(rs.getInt("test_type"));
			bh.setDataNew(rs.getInt("data_new"));
			bh.setDataAvailable(rs.getInt("data_available"));
			bh.setTestStartTime(rs.getTimestamp("test_starttime"));
			bh.setGroupVol(rs.getFloat("group_vol"));
			bh.setTestCurr(rs.getFloat("test_curr"));
			bh.setMonNum(rs.getInt("mon_num"));
			bh.setMonVol(rs.getFloat("mon_vol"));
			bh.setMonTemp(rs.getFloat("mon_tmp"));
			bh.setMonSer(rs.getFloat("mon_ser"));
			bh.setMonRes(rs.getFloat("mon_res"));
			bh.setConnRes(rs.getFloat("conn_res"));
			list.add(bh);
			}
			return list;
			}
			});
			return list;
			}

			//108-BattResDataMapper.xml;4行
			public void deleteByTestRecordCount(Integer battGroupId, Integer testRecordCount){
			String sql="delete from db_batt_testdata.tb_battresdata_"+battGroupId+" where test_record_count = "+testRecordCount+"";
			sqlExecuteService.execute(sql);
			}

			//93-CommonMapper.xml;160行
			public void truncate(String dbName, String tableName){
			String sql="TRUNCATE "+dbName+".`"+tableName+"`";
			sqlExecuteService.execute(sql);
			}

			//107-PwrdevHistorydataGwMapper.xml;5行
			public int judgeTable_pwr(String table){
			String sql=" select count(*) as tableNum " +
			" from INFORMATION_SCHEMA.TABLES " +
			" where TABLE_SCHEMA = 'db_pwrdev_data_history_gw' " +
			" and TABLE_NAME = 'tb_pwrdev_historydata_gw_"+table+"';";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("tableNum"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			int tableNum =0;
			if(list!=null){
			tableNum= (int) list.get(0);
			}
			return tableNum;
			}
			//查询ups历史告警数量
			public int getCountForUps(UpsAlarmDTO param) {
			String sql="select count(distinct alarm.num) as number from db_upspwrdev_alarm."+param.getRecordYear()+" alarm,db_pwrdev_inf.tb_pwrdev_inf inf " +
			" where alarm.power_device_id = inf.PowerDeviceId ";
			if(param.getStationName1()!=null){
			sql+=" and stationName1 like '%"+param.getStationName1()+"%'";
			}
			if(param.getStationName2()!=null){
			sql+=" and stationName2 like '%"+param.getStationName2()+"%'";
			}
			if(param.getStationName5()!=null){
			sql+=" and stationName5 like '%"+param.getStationName5()+"%'";
			}
			if(param.getStationName3()!=null){
			sql+=" and stationName3 like '%"+param.getStationName3()+"%'";
			}
			/*if(param.getPwrdevId()!=0){
			sql+=" and alarm.power_device_id="+param.getPwrdevId();
			}*/
			if(param.getAlmStartTime()!=null){
			sql+=" and alarm.alm_start_time >='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' ";
			}
			if(param.getAlmEndTime()!=null){
			sql+=" and alarm.alm_start_time <='"+ThreadLocalUtil.format(param.getAlmEndTime(),1)+"' ";
			}
			if(param.getAlmTypes()!=null&&param.getAlmTypes().size()>0){
			sql+=" and alm_type in ( ";
			for (int i=0;i<param.getAlmTypes().size();i++) {
			sql+=param.getAlmTypes().get(i);
			if(i!=(param.getAlmTypes().size()-1)){
			sql+=",";
			}
			}
			sql+=")";
			}
			sql+=" and alarm.power_device_id in ( select distinct inf.PowerDeviceId from" +
			" (select PowerDeviceId,StationId from db_pwrdev_inf.tb_pwrdev_inf ) inf," +
			" 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.StationId=inf.StationId" +
			" 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="+param.getUsrId()+" )";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			LinkedList<Object> temp = new LinkedList<>();
			try {
			while (rs.next())
			temp.add(rs.getInt("number"));
			} catch (SQLException e) {
			e.printStackTrace();
			}
			return temp;
			}
			});
			int num =0;
			if(list!=null){
			num= (int) list.get(0);
			}
			return num;
			}
			//查询ups历史告警
			public List getList2(UpsAlarmDTO param){
			String sql=" SELECT history.num,record_id,power_device_id,alm_type,alm_level,alm_start_time,alm_end_time,alm_value,alm_is_confirmed,alm_confirmed_time,alm_cleared_type, " +
			" inf.stationName,stationName1,stationName2,stationName3,stationName5,inf.PowerDeviceName as dev_name " +
			" FROM db_upspwrdev_alarm."+param.getRecordYear()+" history,db_pwrdev_inf.tb_pwrdev_inf inf " +
			" where history.power_device_id = inf.PowerDeviceId ";
			if(param.getStationName1()!=null){
			sql+=" and stationName1 like '%"+param.getStationName1()+"%'";
			}
			if(param.getStationName2()!=null){
			sql+=" and stationName2 like '%"+param.getStationName2()+"%'";
			}
			if(param.getStationName5()!=null){
			sql+=" and stationName5 like '%"+param.getStationName5()+"%'";
			}
			if(param.getStationName3()!=null){
			sql+=" and stationName3 like '%"+param.getStationName3()+"%'";
			}
			if(param.getAlmTypes()!=null&&param.getAlmTypes().size()>0){
			sql+=" and alm_type in ( ";
			for (int i=0;i<param.getAlmTypes().size();i++) {
			sql+=param.getAlmTypes().get(i);
			if(i!=(param.getAlmTypes().size()-1)){
			sql+=",";
			}
			}
			sql+=")";
			}
			sql+=" and alm_start_time >='"+ThreadLocalUtil.format(param.getAlmStartTime(),1)+"' and alm_start_time <='"+ThreadLocalUtil.format(param.getAlmEndTime(),1)+"' ";
			sql+=" and history.power_device_id in ( select distinct inf.PowerDeviceId from" +
			" (select PowerDeviceId,StationId from db_pwrdev_inf.tb_pwrdev_inf ) inf," +
			" 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.StationId=inf.StationId" +
			" 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="+param.getUsrId()+" ) " +
			" ORDER BY alm_start_time desc ,dev_name asc limit "+param.getLimitStart()+","+param.getLimitEnd()+" ";
			List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
			@Override
			public List getResults(ResultSet rs) throws SQLException {
			List<UpspwrdevAlarmHistory> list=new ArrayList<>();
			while (rs.next()){
			UpspwrdevAlarmHistory ph=new UpspwrdevAlarmHistory();
			ph.setNum(rs.getLong("num"));
			ph.setRecordId(rs.getLong("record_id"));
			ph.setPowerDeviceId(rs.getLong("power_device_id"));
			ph.setAlmType(rs.getInt("alm_type"));
			ph.setAlmLevel(rs.getInt("alm_level"));
			ph.setAlmStartTime(rs.getTimestamp("alm_start_time"));
			ph.setAlmEndTime(rs.getTimestamp("alm_end_time"));
			ph.setAlmValue(rs.getFloat("alm_value"));
			ph.setAlmIsConfirmed(rs.getInt("alm_is_confirmed"));
			ph.setAlmConfirmedTime(rs.getTimestamp("alm_confirmed_time"));
			ph.setAlmClearedType(rs.getInt("alm_cleared_type"));
			ph.setDevName(rs.getString("dev_name"));
			ph.setStationName(rs.getString("stationName"));
			ph.setStationName1(rs.getString("stationName1"));
			ph.setStationName2(rs.getString("stationName2"));
			ph.setStationName3(rs.getString("stationName3"));
			ph.setStationName5(rs.getString("stationName5"));
			list.add(ph);
			}
			return list;
			}
			});
			return list;
			}
			//ups历史告警确认
			public int setHisAlmIsConfirmed(int num, String year) {
			String sql=" update db_upspwrdev_alarm.tb_upspwrdev_alarm_history_"+year+" set alm_is_confirmed =1," +
			" where num = "+num+" ";
			int flag=sqlExecuteService.executeUpdate(sql,null);
			return flag;
			}
			//ups历史告警取消
			public int cancleHisAlmIsConfirmed(int num, String year) {
			String sql=" update db_upspwrdev_alarm.tb_upspwrdev_alarm_history_"+year+" set alm_is_confirmed =0," +
			" where num = "+num+" ";
			int flag=sqlExecuteService.executeUpdate(sql,null);
			return flag;
			}
			//ups历史告警删除
			public void delHisAlm(int num, String year) {
			String sql="delete from db_upspwrdev_alarm.tb_upspwrdev_alarm_history_"+year+" where num = "+num+"";
			sqlExecuteService.execute(sql);
			}
			}