package com.fgkj.services;
|
|
import java.sql.Connection;
|
import java.sql.PreparedStatement;
|
import java.sql.SQLException;
|
import java.text.ParseException;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import com.fgkj.actions.ActionUtil;
|
import com.fgkj.dao.BaseDAO;
|
import com.fgkj.dao.BaseDAOFactory;
|
import com.fgkj.dao.BattCapFactory;
|
import com.fgkj.dao.BattTestData;
|
import com.fgkj.dao.BattinfGroupFactory;
|
import com.fgkj.dao.DAOHelper;
|
import com.fgkj.dao.FBS9100_ComBase;
|
import com.fgkj.dao.ProcessServerDao;
|
import com.fgkj.dao.impl.App_SysImpl;
|
import com.fgkj.dao.impl.BattInfImpl;
|
import com.fgkj.dao.impl.Batt_param_lowImpl;
|
import com.fgkj.dao.impl.Batttestdata_infDAOImpl;
|
import com.fgkj.dao.impl.BatttestdatastopDAOImpl;
|
import com.fgkj.dao.impl.Process_surveyImpl;
|
import com.fgkj.dao.impl.ram.Bts_station_stateImpl;
|
import com.fgkj.dao.impl.ram.Fbs9100_setparamImpl;
|
import com.fgkj.db.DBUtil;
|
import com.fgkj.dto.App_Sys;
|
import com.fgkj.dto.BattInf;
|
import com.fgkj.dto.BattInf_Rebuild;
|
import com.fgkj.dto.Batt_Maint_Dealarm;
|
import com.fgkj.dto.Batt_param_low;
|
import com.fgkj.dto.Batttestdata_inf;
|
import com.fgkj.dto.Batttestdatastop;
|
import com.fgkj.dto.Page;
|
import com.fgkj.dto.Process_survey;
|
import com.fgkj.dto.ServiceModel;
|
import com.fgkj.dto.User_inf;
|
import com.sun.scenario.effect.Bloom;
|
|
public class BattInfServices {
|
private ServiceModel model;
|
private BaseDAO dao;
|
|
public BattInfServices() {
|
this.model = new ServiceModel();
|
this.dao = BaseDAOFactory.getBaseDAO(BaseDAO.BATTINF);
|
}
|
//添加新的电池组
|
public ServiceModel add(Object obj) {
|
Boolean bl=dao.add(obj);
|
if(bl){
|
/*//将主程序的服务设为重启
|
Process_survey process=new Process_survey();
|
process.setProcessName(ProcessServerDao.BMS_FBSDEV);
|
Boolean b=(new Process_surveyImpl()).update(process);*/
|
/*App_Sys as=new App_Sys();
|
as.setAppServer_Reinit_BattGroupData_EN(BattTestData.AppServer_Reinit_BattGroupData_EN);
|
Boolean b=(new App_SysImpl()).update(as);*/
|
BattTestData.run_cmd();
|
//将告警的服务设为重启
|
Process_survey process=new Process_survey();
|
process.setProcessName(ProcessServerDao.BMS_FBSDEV_ALARM_BATT);
|
Boolean b=(new Process_surveyImpl()).update(process);
|
model.setCode(1);
|
model.setMsg("添加成功!");
|
}
|
else{
|
model.setCode(0);
|
model.setMsg("添加失败!");
|
}
|
return model;
|
|
}
|
//修改电池组信息
|
public ServiceModel update(Object obj) {
|
Boolean bl=dao.update(obj);
|
if(bl){
|
/*//将主程序的服务设为重启
|
Process_survey process=new Process_survey();
|
process.setProcessName(ProcessServerDao.BMS_FBSDEV);
|
Boolean b=(new Process_surveyImpl()).update(process);*/
|
/*App_Sys as=new App_Sys();
|
as.setAppServer_Reinit_BattGroupData_EN(BattTestData.AppServer_Reinit_BattGroupData_EN);
|
Boolean b=(new App_SysImpl()).update(as);*/
|
BattTestData.run_cmd();
|
//将告警的服务设为重启
|
Process_survey process=new Process_survey();
|
process.setProcessName(ProcessServerDao.BMS_FBSDEV_ALARM_BATT);
|
Boolean b=(new Process_surveyImpl()).update(process);
|
model.setCode(1);
|
model.setMsg("修改成功!");
|
}
|
else{
|
model.setCode(0);
|
model.setMsg("修改失败!");
|
}
|
return model;
|
}
|
//修改电池信息配置(ip地址,掩码和网关)
|
public ServiceModel updateIp(Object obj) {
|
BattInf binf=(BattInf) obj;
|
Connection conn=DBUtil.getConn();
|
PreparedStatement ps=null;
|
boolean b=((BattInfImpl)dao).updateIp(obj);
|
if(b){
|
boolean bl=(new Fbs9100_setparamImpl()).sendCmdToFBS9100Dev(binf.getNum(),FBS9100_ComBase.CMD_TESTCMD_NULL, binf.getFBSDeviceId());
|
if(bl){
|
//将6185的服务设为重启
|
Process_survey process=new Process_survey();
|
process.setProcessName(ProcessServerDao.BMS_FBS61850_BATT);
|
Boolean bt=(new Process_surveyImpl()).update(process);
|
model.setCode(1);
|
model.setMsg("修改成功!");
|
}else{
|
//System.out.println(bl);
|
binf.setFbsDeviceIp(binf.getFbsDeviceIp_old());
|
binf.setFbsDeviceIp_WG(binf.getFbsDeviceIp_WG_old());
|
binf.setFbsDeviceIp_YM(binf.getFbsDeviceIp_YM_old());
|
((BattInfImpl)dao).updateIp(binf);
|
model.setCode(0);
|
model.setMsg("修改61850设备IP信息失败,请检查网络!");
|
}
|
}else{
|
model.setCode(0);
|
model.setMsg("修改失败!");
|
}
|
//System.out.println(model);
|
return model;
|
}
|
|
//设置电池组充电电流阈值
|
public ServiceModel update_charge(Object obj){
|
boolean bl=((BattInfImpl)dao).update_charge(obj);
|
if(bl){
|
model.setCode(1);
|
model.setMsg("修改成功!");
|
}else{
|
model.setCode(0);
|
model.setMsg("修改失败!");
|
}
|
return model;
|
}
|
//删除电池组
|
public ServiceModel delete(Object obj) {
|
Boolean bl=dao.del(obj);
|
if(bl){
|
/*//将主程序的服务设为重启
|
Process_survey process=new Process_survey();
|
process.setProcessName(ProcessServerDao.BMS_FBSDEV);
|
Boolean b=(new Process_surveyImpl()).update(process);*/
|
/*App_Sys as=new App_Sys();
|
as.setAppServer_Reinit_BattGroupData_EN(BattTestData.AppServer_Reinit_BattGroupData_EN);
|
Boolean b=(new App_SysImpl()).update(as);*/
|
BattTestData.run_cmd();
|
//将告警的服务设为重启
|
Process_survey process=new Process_survey();
|
process.setProcessName(ProcessServerDao.BMS_FBSDEV_ALARM_BATT);
|
Boolean b=(new Process_surveyImpl()).update(process);
|
model.setCode(1);
|
model.setMsg("删除成功!");
|
}
|
else{
|
model.setCode(0);
|
model.setMsg("删除失败!");
|
}
|
return model;
|
}
|
//根据维护区和机房名称查询电池组信息
|
public ServiceModel searchInform(Object obj) {
|
List<BattInf> list=((BattInfImpl)dao).searchInform(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}
|
else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//根据维护区和机房名称查询电池组信息(电池组信息配置)<-------跨域----------->
|
public ServiceModel searchInform_ky() {
|
List<BattInf> list=((BattInfImpl)dao).searchInform_ky();
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}
|
else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//根据维护区和机房名称查询电池组信息
|
public ServiceModel searchInform1(Object obj) {
|
List<BattInf> list=((BattInfImpl)dao).searchInform1(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}
|
else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
|
public ServiceModel searchAll() {
|
List list = dao.searchAll();
|
/*for (int i = 0; i < 100; i++) {
|
System.out.println(list.get(i));
|
}
|
System.out.println("查询结束。。。");*/
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
}
|
return model;
|
}
|
public ServiceModel serchByCondition(Object obj) {
|
BattInf bif=(BattInf) obj;
|
List<BattInf> list=dao.serchByCondition(bif);
|
model=new ServiceModel();
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}
|
return model;
|
}
|
|
//查询电池组左侧导航菜单（实时监测，历史数据查询）
|
public ServiceModel findMenu() {
|
BattInfImpl dtdao=(BattInfImpl)dao;
|
List<List> list = dtdao.findMenu();
|
model.setCode(1);
|
model.setData(list);
|
return model;
|
}
|
public ServiceModel findByBattGroupId(Object obj) {
|
List list=((BattInfImpl)dao).serchByBattgroupId(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
}
|
return model;
|
}
|
//----------根据StationName1（维护区） 查不重复BattGroupName（蓄电池组）
|
public ServiceModel serchByStationName1(Object obj) {
|
List list=((BattInfImpl)dao).serchByStationName1(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}
|
//System.out.println(model);
|
return model;
|
}
|
|
// ----------根据StationName1（维护区） 查不重复的StationName（站点）
|
public ServiceModel serchByStationName(Object obj) {
|
List list=((BattInfImpl)dao).serchByStationName(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}
|
return model;
|
}
|
|
// ----------根据StationName1（维护区） 查不重复的StationName（站点）不包含91000000一期设备
|
public ServiceModel serchByStationNameNot91(Object obj) {
|
List list=((BattInfImpl)dao).serchByStationNameNot91(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}
|
return model;
|
}
|
//查电池品牌
|
public ServiceModel serchByBattProducer() {
|
List list=((BattInfImpl)dao).serchByBattProducer();
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}
|
//System.out.println(model);
|
return model;
|
}
|
//查单体电压
|
public ServiceModel serchByMonVolStd() {
|
List list=((BattInfImpl)dao).serchByMonVolStd();
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}
|
//System.out.println(model);
|
return model;
|
}
|
//查电池容量
|
public ServiceModel serchByMonCapStd() {
|
List list=((BattInfImpl)dao).serchByMonCapStd();
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}
|
//System.out.println(model);
|
return model;
|
}
|
//5.3添加选取电池组或者机房或者维护区(未被应用)
|
public ServiceModel serchBatt(Object obj) {
|
Boolean bl=false;
|
List<BattInf> list=(new BattInfImpl()).serchBatt(obj);
|
if(list!=null && list.size()>0){
|
model.setCode(1);
|
model.setData(list);
|
}else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
|
// ----------查不重复的StationName1（维护区）
|
public ServiceModel serchByStation() {
|
List list=((BattInfImpl)dao).serchByStation();
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}
|
return model;
|
}
|
// ----------查不重复的StationName1（维护区）不包含91000000一期设备
|
public ServiceModel serchByStationNot91() {
|
List list=((BattInfImpl)dao).serchByStationNot91();
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}
|
return model;
|
}
|
//查单体编号
|
public ServiceModel serchByMonNum(Object obj) {
|
List list=((BattInfImpl)dao).serchByMonNum(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
}else{
|
model.setCode(0);
|
model.setSum(0);
|
}
|
return model;
|
}
|
//根据电池id查询电池的基本信息
|
public ServiceModel searchBattBybattgroupid(Object obj){
|
model=new ServiceModel();
|
List list=((BattInfImpl)dao).searchBattBybattgroupid(obj);
|
//System.out.println(list);
|
if(list!=null && list.size()>0){
|
model.setCode(1);
|
model.setData(list);
|
}
|
return model;
|
}
|
public ServiceModel serchByBattGroupName(Object obj) {
|
List list=((BattInfImpl)dao).serchByBattGroupName(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setSum(list.size());
|
model.setMsg("查询成功！");
|
}else{
|
model.setCode(0);
|
model.setMsg("查询失败！");
|
}
|
return model;
|
}
|
//6.4.7按地域和标称电压分组统计蓄电池组服役超期的数量
|
/*
|
* 区域层次放在stationid中
|
* battgroupnum 中存放统计方式：年度统计为0 季度统计为1
|
* moncount中存放统计季度：一季度为1 以此类推
|
* monnum 中存放年份*/
|
public ServiceModel serchBeyondTime(Object obj){
|
System.out.println(1111111111);
|
BattInf binf=(BattInf) obj;
|
int year=binf.getMonNum();//获取年份
|
int firstMonth=0;//获取起始月份
|
int lastMonth=0;//获取结束月份
|
String dateFirst=""; //起始时间
|
String dateLast=""; //结束时间
|
//做时间判断
|
if(binf.getBattGroupNum()==0){
|
firstMonth=0;//获取起始月份
|
lastMonth=11;//获取结束月份
|
}else if(binf.getBattGroupNum()==1){
|
if(binf.getMonCount()==1){
|
firstMonth=0;//获取起始月份
|
lastMonth=2;//获取结束月份
|
}else if(binf.getMonCount()==2){
|
firstMonth=3;//获取起始月份
|
lastMonth=5;//获取结束月份
|
}else if(binf.getMonCount()==3){
|
firstMonth=6;//获取起始月份
|
lastMonth=8;//获取结束月份
|
}else if(binf.getMonCount()==4){
|
firstMonth=9;//获取起始月份
|
lastMonth=11;//获取结束月份
|
}
|
}
|
try {
|
dateFirst=ActionUtil.getFirstDayOfMonth(year,firstMonth);//起始时间
|
binf.setBattInUseDate(DAOHelper.sdf.parse(dateFirst));
|
//System.out.println(dateFirst.substring(0,10));
|
dateLast=ActionUtil.getLastDayOfMonth(year,lastMonth);//结束时间
|
binf.setBattInUseDate1(DAOHelper.sdf.parse(dateLast));
|
} catch (Exception e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
|
//求总数
|
List<BattInf> list=(new BattInfImpl()).serchByMonVolStdGroup(binf);
|
List<BattInf> listB=BattinfGroupFactory.finishMonvol(list);
|
List<BattInf> listL=BattinfGroupFactory.delMonvol(listB);
|
//求超期服役的数量
|
try {
|
year=(new Date()).getYear()+1900-3;//当前时间减去年限
|
//System.out.println(year);
|
dateFirst=ActionUtil.getFirstDayOfMonth(year,firstMonth);//起始时间
|
binf.setBattInUseDate(DAOHelper.sdf.parse(dateFirst));
|
//System.out.println(binf.getBattInUseDate());
|
} catch (ParseException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
List<BattInf> listY=(new BattInfImpl()).serchBeyondTime(binf);//超期服役的电池组数
|
List<BattInf> listBY=BattinfGroupFactory.finishMonvol(listY);
|
List<BattInf> listLY=BattinfGroupFactory.delMonvol(listBY);
|
/*for (BattInf b : listBY) {
|
System.out.println("0 "+b.getBattGroupNum()+" "+
|
"2v: "+b.getBattGroupId()+" "+
|
"6v: "+b.getMonCount()+" "+
|
"12v: "+b.getMonNum());
|
}*/
|
int level = Integer.parseInt(binf.getStationId());
|
List<BattInf> listFalse=(new BattInfImpl()).serchBylevel(level);
|
/* for (BattInf b : listL) {
|
System.out.println("1 "+b.getBattGroupNum()+" "+
|
"2v: "+b.getBattGroupId()+" "+
|
"6v: "+b.getMonCount()+" "+
|
"12v: "+b.getMonNum());
|
}*/
|
List<BattInf> listEnd=BattinfGroupFactory.countAll(listL, listLY);
|
for (BattInf b : listEnd) {
|
System.out.println("2 "+b.getBattGroupNum()+" "+
|
"2v: "+b.getBattGroupId()+" 超过2v: "+b.getMonCapStd()+" "+
|
"6v: "+b.getMonCount()+" 超过6v: "+b.getMonResStd()+" "+
|
"12v: "+b.getMonNum()+" 超过12v: "+b.getMonSerStd());
|
}
|
if(listL!=null&&listL.size()>0){
|
model.setCode(1);
|
model.setData(listEnd);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(listFalse);
|
System.out.println(listFalse.size());
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//6.4.8按地域和标称电压分组统计蓄电池组的数量(蓄电池组数量统计)
|
/*
|
* 区域层次放在stationid中
|
* battgroupnum 中存放统计方式：年度统计为0 季度统计为1
|
* moncount中存放统计季度：一季度为1 以此类推
|
* monnum 中存放年份*/
|
public ServiceModel serchByMonVolStdGroup(Object obj){
|
BattInf binf=(BattInf) obj;
|
int year=binf.getMonNum();//获取年份
|
int firstMonth=0;//获取起始月份
|
int lastMonth=0;//获取结束月份
|
String dateFirst=""; //起始时间
|
String dateLast=""; //结束时间
|
//做时间判断
|
if(binf.getBattGroupNum()==0){
|
firstMonth=0;//获取起始月份
|
lastMonth=11;//获取结束月份
|
}else if(binf.getBattGroupNum()==1){
|
if(binf.getMonCount()==1){
|
firstMonth=0;//获取起始月份
|
lastMonth=2;//获取结束月份
|
}else if(binf.getMonCount()==2){
|
firstMonth=3;//获取起始月份
|
lastMonth=5;//获取结束月份
|
}else if(binf.getMonCount()==3){
|
firstMonth=6;//获取起始月份
|
lastMonth=8;//获取结束月份
|
}else if(binf.getMonCount()==4){
|
firstMonth=9;//获取起始月份
|
lastMonth=11;//获取结束月份
|
}
|
}
|
try {
|
dateFirst=ActionUtil.getFirstDayOfMonth(year,firstMonth);//起始时间
|
binf.setBattInUseDate(DAOHelper.sdf.parse(dateFirst));
|
//System.out.println(dateFirst.substring(0,10));
|
dateLast=ActionUtil.getLastDayOfMonth(year,lastMonth);//结束时间
|
binf.setBattInUseDate1(DAOHelper.sdf.parse(dateLast));
|
} catch (Exception e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
|
|
List<BattInf> list=(new BattInfImpl()).serchByMonVolStdGroup(binf);
|
List<BattInf> listB=BattinfGroupFactory.finishMonvol(list);
|
List<BattInf> listL=BattinfGroupFactory.delMonvol(listB);
|
//没有数据时传分组情况
|
int level = Integer.parseInt(binf.getStationId());
|
List<BattInf> listFalse=(new BattInfImpl()).serchBylevel(level);
|
// for (BattInf b : listL) {
|
// System.out.println(b.getBattGroupNum()+" "+
|
// "2v: "+b.getBattGroupId()+" "+
|
// "6v: "+b.getMonCount()+" "+
|
// "12v: "+b.getMonNum());
|
// }
|
if(listL!=null&&listL.size()>0){
|
model.setCode(1);
|
model.setData(listL);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(listFalse);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//6.4.9按地域和标称电压分组统计蓄电池组品牌的数量(蓄电池供应商信息统计)
|
/*
|
* 区域层次放在stationid中
|
* battgroupnum 中存放统计方式：年度统计为0 季度统计为1
|
* moncount中存放统计季度：一季度为1 以此类推
|
* monnum 中存放年份*/
|
public ServiceModel serchByBattProducerGroup(Object obj){
|
BattInf binf=(BattInf) obj;
|
int year=binf.getMonNum();//获取年份
|
int firstMonth=0;//获取起始月份
|
int lastMonth=0;//获取结束月份
|
String dateFirst=""; //起始时间
|
String dateLast=""; //结束时间
|
//做时间判断
|
if(binf.getBattGroupNum()==0){
|
firstMonth=0;//获取起始月份
|
lastMonth=11;//获取结束月份
|
}else if(binf.getBattGroupNum()==1){
|
if(binf.getMonCount()==1){
|
firstMonth=0;//获取起始月份
|
lastMonth=2;//获取结束月份
|
}else if(binf.getMonCount()==2){
|
firstMonth=3;//获取起始月份
|
lastMonth=5;//获取结束月份
|
}else if(binf.getMonCount()==3){
|
firstMonth=6;//获取起始月份
|
lastMonth=8;//获取结束月份
|
}else if(binf.getMonCount()==4){
|
firstMonth=9;//获取起始月份
|
lastMonth=11;//获取结束月份
|
}
|
}
|
try {
|
dateFirst=ActionUtil.getFirstDayOfMonth(year,firstMonth);//起始时间
|
binf.setBattInUseDate(DAOHelper.sdf.parse(dateFirst));
|
//System.out.println(dateFirst.substring(0,10));
|
dateLast=ActionUtil.getLastDayOfMonth(year,lastMonth);//结束时间
|
binf.setBattInUseDate1(DAOHelper.sdf.parse(dateLast));
|
} catch (Exception e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
|
|
List<BattInf> list=(new BattInfImpl()).serchByBattProducerGroup(binf);
|
//没有数据时传分组情况
|
int level = Integer.parseInt(binf.getStationId());
|
List<BattInf> listFalse=(new BattInfImpl()).serchBylevel(level);
|
|
// for (BattInf b : list) {
|
// System.out.println(b.getNum()+" "+
|
// b.getStationName1()+" "+
|
// b.getStationName2()+" "+
|
// b.getStationName3()+" "+
|
// b.getStationName4()+" "+
|
// b.getBattProducer()+" "+
|
// b.getBattGroupNum());
|
// }
|
if(list!=null&&list.size()>0){
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
System.out.println(listFalse);
|
model.setData(listFalse);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//6.4.10按地域和标称电压分组统计蓄电池组使用时间(蓄电池投产年限统计)
|
/*
|
* 区域层次放在stationid中
|
* battgroupnum 中存放统计方式：年度统计为0 季度统计为1
|
* moncount中存放统计季度：一季度为1 以此类推
|
* monnum 中存放年份*/
|
public ServiceModel serchByBattInUseDateGroup(Object obj){
|
BattInf binf=(BattInf) obj;
|
int year=binf.getMonNum();//获取年份
|
int firstMonth=0;//获取起始月份
|
int lastMonth=0;//获取结束月份
|
String dateFirst=""; //起始时间
|
String dateLast=""; //结束时间
|
//做时间判断
|
if(binf.getBattGroupNum()==0){
|
firstMonth=0;//获取起始月份
|
lastMonth=11;//获取结束月份
|
}else if(binf.getBattGroupNum()==1){
|
if(binf.getMonCount()==1){
|
firstMonth=0;//获取起始月份
|
lastMonth=2;//获取结束月份
|
}else if(binf.getMonCount()==2){
|
firstMonth=3;//获取起始月份
|
lastMonth=5;//获取结束月份
|
}else if(binf.getMonCount()==3){
|
firstMonth=6;//获取起始月份
|
lastMonth=8;//获取结束月份
|
}else if(binf.getMonCount()==4){
|
firstMonth=9;//获取起始月份
|
lastMonth=11;//获取结束月份
|
}
|
}
|
try {
|
dateFirst=ActionUtil.getFirstDayOfMonth(year,firstMonth);//起始时间
|
binf.setBattInUseDate(DAOHelper.sdf.parse(dateFirst));
|
//System.out.println(dateFirst.substring(0,10));
|
dateLast=ActionUtil.getLastDayOfMonth(year,lastMonth);//结束时间
|
binf.setBattInUseDate1(DAOHelper.sdf.parse(dateLast));
|
} catch (Exception e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
|
|
List<BattInf> list=(new BattInfImpl()).serchByBattInUseDateGroup(binf);
|
//System.out.println(list.size());
|
//没有数据时传分组情况
|
int level = Integer.parseInt(binf.getStationId());
|
List<BattInf> listFalse=(new BattInfImpl()).serchBylevel(level);
|
|
// for (BattInf b : list) {
|
// System.out.println(b.getNum()+" "+
|
// b.getStationName1()+" "+
|
// b.getStationName2()+" "+
|
// b.getStationName3()+" "+
|
// b.getStationName4()+" "+
|
// b.getBattInUseDate()+" "+
|
// b.getBattGroupNum());
|
// }
|
if(list!=null&&list.size()>0){
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(listFalse);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
|
//1 根据机房id查询电池组id排序最小值
|
public ServiceModel serchByIdLow(Object obj){
|
List list=((BattInfImpl)dao).serchByIdLow(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
|
/**
|
* 根据机房id查询机房中的电池组信息
|
* @param obj
|
* @return
|
*/
|
public ServiceModel searchBattByStationId(Object obj){
|
ServiceModel model = new ServiceModel();
|
List list = ((BattInfImpl)dao).searchBattByStationId(obj);
|
if(list != null && list.size()>0){
|
model.setCode(1);
|
model.setData(list);
|
|
}else{
|
model.setCode(0);
|
}
|
return model;
|
}
|
|
//搜索机房或电池组
|
public ServiceModel serchStationOrBattgroup(Object obj){
|
List list=((BattInfImpl)dao).serchStationOrBattgroup(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
//System.out.println(list.size());
|
return model;
|
}
|
//查询所有的省份(左侧导航第一层，查所有的省份)
|
public ServiceModel serchAllStation(Object obj){
|
List list=((BattInfImpl)dao).serchAllStation(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//查询所有的省份(左侧导航第一层，查所有的省份)
|
public ServiceModel serchAllStation_all(Object obj){
|
List list=((BattInfImpl)dao).serchAllStation_all(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//查询管理的市(左侧导航第二层，查所有的市,num中存放uid)
|
public ServiceModel serchStationName2(Object obj){
|
List list=((BattInfImpl)dao).serchStationName2(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//查询管理的市(左侧导航第二层，查所有的市)
|
public ServiceModel serchStationName2_all(Object obj){
|
List list=((BattInfImpl)dao).serchStationName2_all(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//查询管理的县/区(左侧导航第三层，查所有的县/区)
|
public ServiceModel serchStationName5(Object obj){
|
List list=((BattInfImpl)dao).serchStationName5(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//查询管理的县/区(左侧导航第三层，查所有的县/区)
|
public ServiceModel serchStationName5_all(Object obj){
|
List list=((BattInfImpl)dao).serchStationName5_all(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//查询管理的机房(左侧导航第四层，查所有的机房,num中存放uid)
|
public ServiceModel serchStationName3(Object obj){
|
List list=((BattInfImpl)dao).serchStationName3(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//查询管理的机房(左侧导航第四层，查所有的机房)
|
public ServiceModel serchStationName3_all(Object obj){
|
List list=((BattInfImpl)dao).serchStationName3_all(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//根据机房id查询机房下的电池组信息(左侧导航第五层,根据机房查询下面的电池组,num中存放uid)
|
public ServiceModel serchBattByStation(Object obj){
|
List list=((BattInfImpl)dao).serchBattByStation(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//根据机房id查询机房下的电池组信息(左侧导航第五层,根据机房查询下面的电池组)
|
public ServiceModel serchBattByStation_all(Object obj){
|
List list=((BattInfImpl)dao).serchBattByStation_all(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setData(list);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//查询所有的电池组数
|
public ServiceModel serchAllBatt(Object obj){
|
int nums=((BattInfImpl)dao).serchAllBatt(obj);
|
model.setCode(1);
|
model.setSum(nums);
|
model.setMsg("查询成功!");
|
//System.out.println(model);
|
return model;
|
}
|
//电池配组管理(重要)
|
public ServiceModel serchMakeGroup(Object obj){
|
List<BattInf> list=((BattInfImpl)dao).serchMakeGroup(obj);
|
Batt_param_low capLow=new Batt_param_low();
|
capLow.setLow_type(BattCapFactory.CapType_type);//2容量
|
capLow.setLow_nametype(BattCapFactory.CapType_name);//1次低
|
capLow.setLow_method(BattCapFactory.CapType_method);//0
|
List<Batt_param_low> listp=(new Batt_param_lowImpl()).serchByLow(capLow);
|
float param=0f;//阈值
|
if(listp!=null&&listp.size()>0){
|
param=listp.get(listp.size()-1).getLow_value();//0.1
|
}
|
if(list!=null&&list.size()>0){
|
for (int i = 0; i < list.size(); i++) {
|
BattInf binf=list.get(i);
|
List<Batttestdatastop> list_sdata=new ArrayList();
|
//筛选出电池组有效的节能放电记录
|
List<Batttestdata_inf> list_tinf=(new Batttestdata_infDAOImpl()).Batt_selecteffectiveBatt(binf, param);
|
if(list_tinf!=null&&list_tinf.size()>0){
|
Batttestdata_inf tinf=list_tinf.get(list_tinf.size()-1);
|
//求出单体的实际容量
|
list_sdata=(new BatttestdatastopDAOImpl().serchMakeGroup(binf, tinf));
|
}else{
|
List listr=(List) binf.getObj();
|
for (int j = 0; j <binf.getMonCount(); j++) {
|
Batttestdatastop sdata=new Batttestdatastop();
|
sdata.setBattGroupId(binf.getBattGroupId());
|
sdata.setNote(binf.getBattProducer());
|
sdata.setMon_num(j+1);
|
for (int z = 0; z < listr.size(); z++) {
|
BattInf_Rebuild brinf=(BattInf_Rebuild) listr.get(z);
|
if((j+1)==brinf.getOld_monum()&&sdata.getBattGroupId()==brinf.getOld_battgroupid()){
|
sdata.setMon_num(-1);
|
break;
|
}
|
if((j+1)==brinf.getNew_monum()&&sdata.getBattGroupId()==brinf.getNew_battgroupid()){
|
sdata.setNote(brinf.getOld_battproducer());
|
break;
|
}
|
}
|
sdata.setTest_cap(binf.getMonCapStd());//没有放电默认为标称
|
sdata.setPercent(1f);
|
list_sdata.add(sdata);
|
}
|
}
|
binf.setObj(list_sdata);
|
}
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//电池配组管理(重要)
|
public ServiceModel serchGroupByInfor(Object obj){
|
List<BattInf> list=((BattInfImpl)dao).serchGroupByInfor(obj);
|
List list_b=new ArrayList();
|
if(list!=null&&list.size()>0){
|
for(int i=0;i<list.size();i++){
|
BattInf binf=list.get(i);
|
List<BattInf_Rebuild> listr=(List<BattInf_Rebuild>) binf.getObj();
|
for (int j = 0; j <binf.getMonCount(); j++) {
|
BattInf b=new BattInf();
|
b.setBattGroupId(binf.getBattGroupId());
|
b.setBattProducer(binf.getBattProducer());
|
b.setStationName(binf.getStationName());
|
b.setBattGroupName(binf.getBattGroupName());
|
b.setMonVolStd(binf.getMonVolStd());
|
b.setMonCapStd(binf.getMonCapStd());
|
b.setStationId(binf.getStationId());
|
b.setMonNum(j+1);
|
for (int z = 0; z < listr.size(); z++) {
|
BattInf_Rebuild brinf=(BattInf_Rebuild) listr.get(z);
|
if((j+1)==brinf.getNew_monum()&&b.getBattGroupId()==brinf.getNew_battgroupid()){
|
b.setBattProducer(brinf.getOld_battproducer());
|
b.setNum(1);
|
}
|
if((j+1)==brinf.getOld_monum()&&b.getBattGroupId()==brinf.getOld_battgroupid()){
|
b.setNum(0);
|
}
|
}
|
list_b.add(b);
|
}
|
}
|
model.setCode(1);
|
model.setData(list_b);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
|
//首页上根据stationid查询电池组的机历卡
|
public ServiceModel serchBattAllInfoByStationId(Object obj){
|
List list=((BattInfImpl)dao).serchBattAllInfoByStationId(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//首页上显示已安装数和全部基站数
|
public ServiceModel serchDevice(Object obj){
|
//int devNum=(new BattInfImpl()).serchByDeviceId(obj); //总设备数(已安装)
|
List list=(new BattInfImpl()).serchByDeviceId_all(obj); //总设备数(全部)
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
//System.out.println(model.getData());
|
return model;
|
}
|
//头部查出已安装的所有机房
|
public ServiceModel serchByDeviceId(Object obj){
|
int devNum=(new BattInfImpl()).serchByDeviceId(obj); //总设备数(已安装)
|
model.setCode(1);
|
model.setSum(devNum);
|
model.setMsg("查询成功!");
|
return model;
|
}
|
//头部查出已安装的电池单体
|
public ServiceModel serchByInstall_count(Object obj){
|
int devNum=(new BattInfImpl()).serchByInstall_count(obj); //总设备数(已安装)
|
model.setCode(1);
|
model.setSum(devNum);
|
model.setMsg("查询成功!");
|
return model;
|
}
|
|
//添加操作时查询出设备id
|
public ServiceModel searchmaxdev_id(){
|
int dev_id=BattinfGroupFactory.searchmaxdev_id();
|
model.setData(dev_id);
|
return model;
|
}
|
//添加操作时查询出电池组id
|
public ServiceModel searchMaxBattgroupId(){
|
int battgroupid=BattinfGroupFactory.searchMaxBattgroupId();
|
model.setData(battgroupid);
|
return model;
|
}
|
|
//批量设置放电参数时，根据省市区，电池单体型号（伏数），组数筛选出电池组
|
public ServiceModel serchByDischarge(Object obj){
|
List list=((BattInfImpl)dao).serchByDischarge(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
//判断新增的机房是否存在
|
public ServiceModel judgeBatt(Object obj) {
|
List list=((BattInfImpl)dao).judgeBatt(obj);
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
model.setMsg("查询成功!");
|
}else{
|
model.setCode(0);
|
model.setMsg("查询失败!");
|
}
|
return model;
|
}
|
|
public static void main(String[] args) {
|
//new BattInfServices().findMenu();
|
BattInf b=new BattInf();
|
//b.setBattGroupId(1000005);
|
b.setNum(58);
|
b.setFBSDeviceId(91000001);
|
b.setFbsDeviceIp("192.168.0.56");
|
b.setFbsDeviceIp_YM("255.255.255.0");
|
b.setFbsDeviceIp_WG("127.0.0.1");
|
b.setFbsDeviceIp_old("192.168.0.56");
|
b.setFbsDeviceIp_YM_old("255.255.255.0");
|
b.setFbsDeviceIp_WG_old("192.168.0.1");
|
b.setStationName("");
|
b.setStationName1("");
|
b.setStationName2("武汉市");
|
b.setStationName9("");
|
b.setBattGroupName("");
|
b.setStationId("42070463");
|
//b.setBattGroupName1("开关电源系统");
|
b.setBattProducer("1");
|
b.setMonCapStd(100f);
|
b.setMonVolStd(12f);
|
BattInfServices bs=new BattInfServices();
|
//bs.serchByStation();
|
//bs.serchByStationName(b);
|
//bs.serchByStationName1(b);
|
//bs.serchByCondition(b);
|
|
//bs.searchBattBybattgroupid(b);
|
//bs.serchByBattGroupName(b);
|
//bs.findMenu();
|
//bs.serchAllStation();
|
//bs.serchStationOrBattgroup(b);
|
//bs.serchBattByStation(b);
|
|
Page page=new Page();
|
page.setPageCurr(1);
|
page.setPageSize(10);
|
Batt_Maint_Dealarm bmd=new Batt_Maint_Dealarm();
|
bmd.setBinf(b);
|
bmd.setPage(page);
|
//bs.searchInform(bmd);
|
//bs.serchByBattGroupName(b);
|
//bs.updateIp(b);
|
/*ServiceModel model=bs.serchMakeGroup(b);
|
List<BattInf> list=(List) model.getData();
|
for (BattInf binf : list) {
|
List<Batttestdatastop> list_sdata=(List) binf.getObj();
|
for (Batttestdatastop s : list_sdata) {
|
System.out.println(s);
|
}
|
}*/
|
//BattTestData.run_cmd(BattTestData.STRCMD);
|
User_inf uinf=new User_inf();
|
uinf.setUId(1002);
|
ServiceModel model=bs.serchDevice(uinf);
|
System.out.println(model);
|
}
|
}
|
