package com.fgkj.dao.impl;
|
|
import java.sql.Connection;
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
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.CallBack;
|
import com.fgkj.dao.DAOHelper;
|
import com.fgkj.dao.LimitNumberFactory;
|
import com.fgkj.db.DBUtil;
|
import com.fgkj.db.IDatabaseName;
|
import com.fgkj.dto.BattInf;
|
import com.fgkj.dto.Batt_Maint_Dealarm;
|
import com.fgkj.dto.Batt_maint_inf;
|
import com.fgkj.dto.Batt_maintenance_inf;
|
import com.fgkj.dto.Batttestdata_inf;
|
import com.fgkj.dto.Page;
|
import com.fgkj.dto.User_inf;
|
|
public class BattInfAgainImpl implements BaseDAO,CallBack{
|
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList<BattInf>();
|
try {
|
while (rs.next()) {
|
Batt_Maint_Dealarm bmd = new Batt_Maint_Dealarm();
|
BattInf binf = new BattInf();
|
Batt_maint_inf mainf = new Batt_maint_inf();
|
Batttestdata_inf tdata = new Batttestdata_inf();
|
Page p=new Page();
|
binf.setBattGroupId(rs.getInt("battGroupId"));
|
|
|
binf.setStationName(rs.getString("stationName"));
|
binf.setStationName1(rs.getString("stationName1"));
|
binf.setStationIp(rs.getString("stationIp"));
|
binf.setBattGroupName(rs.getString("battGroupName"));
|
binf.setBattGroupName1(rs.getString("battGroupName1"));
|
binf.setBattGroupNum(rs.getInt("battGroupNum"));
|
binf.setMonCount(rs.getInt("monCount"));
|
binf.setMonCapStd(rs.getFloat("monCapStd"));
|
binf.setMonVolStd(rs.getFloat("monVolStd"));
|
binf.setBattProducer(rs.getString("battProducer"));
|
binf.setBattProductDate(rs.getDate("battProductDate"));
|
binf.setBattInUseDate(rs.getDate("battInUseDate"));
|
|
//minf.setFault_type(rs.getString("fault_type"));
|
if (rs.getString("maint_done_time") != null)
|
mainf.setMaint_done_time(DAOHelper.sdf.parse(rs
|
.getString("maint_done_time")));
|
|
tdata.setBattGroupId(rs.getInt("battGroupId"));
|
|
//System.out.println(rs.getInt("battGroupId"));
|
|
tdata.setTest_record_count(rs.getInt("test_record_count"));
|
|
if (rs.getString("test_starttime") != null)
|
tdata.setTest_starttime(DAOHelper.sdf.parse(rs
|
.getString("test_starttime")));
|
|
tdata.setTest_starttype(rs.getInt("test_starttype"));
|
tdata.setTest_type(rs.getInt("test_type"));
|
tdata.setTest_curr(rs.getFloat("test_curr"));
|
tdata.setTest_timelong(rs.getInt("test_timelong"));
|
tdata.setMax_monvol(rs.getFloat("max_monvol"));
|
tdata.setMin_monvol(rs.getFloat("min_monvol"));
|
tdata.setMin_monnum(rs.getInt("min_monnum"));
|
tdata.setTest_cap(rs.getFloat("test_cap"));
|
tdata.setData_new(rs.getInt("data_new"));
|
|
|
bmd.setBinf(binf);
|
bmd.setMainf(mainf);
|
bmd.setTdata(tdata);
|
bmd.setPage(p);
|
|
|
list.add(bmd);
|
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} catch (ParseException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
|
return list;
|
}
|
|
|
public boolean add(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
|
public boolean update(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
|
public boolean del(Object obj) {
|
// TODO Auto-generated method stub
|
return false;
|
}
|
|
public List searchAll() {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
public List serchByCondition(Object obj) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
public List serchByInfo(Object obj) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
|
//1.2电池组统计分析查询
|
public List serchByTestType1(Object obj){
|
Batt_Maint_Dealarm bmd = (Batt_Maint_Dealarm) obj;
|
List list = null;
|
BattInf binf = bmd.getBinf();
|
Batt_maint_inf mainf = bmd.getMainf();
|
Batttestdata_inf tdata = bmd.getTdata();
|
User_inf uinf=bmd.getUinf();
|
String sql="";
|
String baseSql="select distinct(db_battinf.tb_battinf.BattgroupId),StationName1,StationName,stationip,BattGroupName,BattGroupName1,battgroupnum,moncount,moncapstd,monvolstd,battproducer,battproductdate,battinusedate " +
|
",maint_done_time " +
|
",test_record_count,test_type,test_starttime,test_starttype,test_curr,test_timelong,max_monvol,min_monvol,test_cap,data_new ,db_user.tb_user_battgroup_baojigroup_battgroup.battgroupid " +
|
"from db_batt_testdata.tb_batttestdata_inf " +
|
"left outer join db_battinf.tb_batt_maint_inf on db_batt_testdata.tb_batttestdata_inf.BattgroupId=db_battinf.tb_batt_maint_inf.BattGroupId " +
|
"left outer join db_battinf.tb_battinf on db_battinf.tb_battinf.BattgroupId=db_batt_testdata.tb_batttestdata_inf.BattGroupId " +
|
"left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.battgroupid=db_batt_testdata.tb_batttestdata_inf.BattgroupId " +
|
"left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id= db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id " +
|
"left outer join db_user.tb_user_inf on db_user.tb_user_inf.uId=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
"where test_type=? and to_days(db_batt_testdata.tb_batttestdata_inf.record_time)>=to_days(?) and to_days(db_batt_testdata.tb_batttestdata_inf.record_time)<=to_days(?) " +
|
"and to_days(battproductdate)>=to_days(?) and to_days(battproductdate)<=to_days(?) and to_days(battinusedate)>=to_days(?) and to_days(battinusedate)<=to_days(?)";
|
//用于维护区
|
String station1SqlT=" and stationname1!=? ";//全部
|
String station1SqlF=" and stationname1=? ";
|
if(binf.getStationName1().equals("")){
|
baseSql+=station1SqlT;
|
}else{
|
baseSql+=station1SqlF;
|
}
|
//用于机房站点
|
String stationSqlT=" and stationname!=? ";//全部
|
String stationSqlF=" and stationname=? ";
|
if(binf.getStationName().equals("")){
|
baseSql+=stationSqlT;
|
}else{
|
baseSql+=stationSqlF;
|
}
|
//用于电池类型
|
String producerSqlT=" and battproducer!=? ";//全部
|
String producerSqlF=" and battproducer=? ";
|
if(binf.getBattProducer().equals("")){
|
baseSql+=producerSqlT;
|
}else{
|
baseSql+=producerSqlF;
|
}
|
//选取蓄电池组条件
|
String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? ";
|
String idSqlF=" and db_battinf.tb_battinf.battgroupid=? ";
|
if(binf.getBattGroupId()==0){
|
baseSql+=idSqlT;
|
}else{
|
baseSql+=idSqlF;
|
}
|
//选取系统类型
|
String nameSqlT=" and BattGroupName1 like ? ";
|
String nameSqlF=" and BattGroupName1 not like '%开关电源系统%' and BattGroupName1 not like '%UPS系统%' and BattGroupName1 not like ? ";
|
if(binf.getBattGroupName1().equals("其他")){
|
baseSql+=nameSqlF;
|
}else{
|
baseSql+=nameSqlT;
|
}
|
//用于单体电压
|
String volSqlT=" and monVolStd!=? ";//全部
|
String volSqlF=" and monVolStd=?" ;
|
if(binf.getMonVolStd()==0){
|
baseSql+=volSqlT;
|
}else{
|
baseSql+=volSqlF;
|
}
|
//用于电池容量
|
String capSqlT=" and monCapStd!=? ";//全部
|
String capSqlF=" and monCapStd=?" ;
|
if(binf.getMonCapStd()==0){
|
baseSql+=capSqlT;
|
}else{
|
baseSql+=capSqlF;
|
}
|
//包机人
|
String userSqlF=" and db_user.tb_user_inf.uname=? and db_user.tb_user_inf.ubaojiusr=1 ";
|
if(uinf.getUName().equals("0")){
|
baseSql=baseSql;
|
}else{
|
baseSql+=userSqlF;
|
}
|
//用于测试类型
|
//全部
|
String start_typeA=" ";
|
//拉闸放电
|
String start_typeF=" and test_starttype<5 and test_type not in(2,9) and test_starttype!=2 ";
|
//核对性放电
|
String start_typeT=" and test_starttype>=5 or (test_type not in(2,9) and test_starttype=2) ";
|
if(tdata.getTest_starttype()==0){
|
baseSql+=start_typeA;
|
}else if(tdata.getTest_starttype()==1){
|
baseSql+=start_typeF;
|
}else if(tdata.getTest_starttype()==2){
|
baseSql+=start_typeT;
|
}
|
|
//用于电池维护记录条件
|
//有维护记录
|
String maintSqlT=" and db_battinf.tb_battinf.BattGroupId in(select db_battinf.tb_batt_maint_inf.battgroupid from db_battinf.tb_batt_maint_inf where to_days(maint_done_time)>=to_days(?) and to_days(maint_done_time)<=to_days(?)) " ;
|
//无维护记录
|
String maintSqlF=" and db_battinf.tb_battinf.BattGroupId not in(select db_battinf.tb_batt_maint_inf.battgroupid from db_battinf.tb_batt_maint_inf where to_days(maint_done_time)>=to_days(?) and to_days(maint_done_time)<=to_days(?)) " ;
|
//全部
|
String maintSqlA=" and db_battinf.tb_battinf.BattGroupId!=(select count(distinct(db_battinf.tb_batt_maint_inf.battgroupid )) from db_battinf.tb_batt_maint_inf where to_days(maint_done_time)>=to_days(?) and to_days(maint_done_time)<=to_days(?)) " ;
|
|
if(mainf.getRemark().equals("0")){
|
baseSql+=maintSqlF;
|
}else if(mainf.getRemark().equals("1")){
|
baseSql+=maintSqlT;
|
}else if(mainf.getRemark().equals("100")){
|
baseSql+=maintSqlA;
|
}
|
String endSql=" order by StationName1,db_battinf.tb_battinf.BattgroupId";
|
|
sql=baseSql+endSql;
|
//System.out.println(sql);
|
if(uinf.getUName().equals("0")){
|
list = DAOHelper.executeQuery(
|
sql,
|
DBUtil.getConn(),
|
new Object[] {
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
binf.getBattProductDate(),
|
binf.getBattProductDate1(),
|
binf.getBattInUseDate(),
|
binf.getBattInUseDate1(),
|
binf.getStationName1(),
|
binf.getStationName(),
|
binf.getBattProducer(),
|
|
binf.getBattGroupId(),
|
"%"+binf.getBattGroupName1()+"%",
|
binf.getMonVolStd(),
|
binf.getMonCapStd(),
|
mainf.getMaint_done_time(),
|
mainf.getMaint_done_time1()
|
},
|
new BattInfAgainImpl());
|
}else{
|
list = DAOHelper.executeQuery(
|
sql,
|
DBUtil.getConn(),
|
new Object[] {
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
binf.getBattProductDate(),
|
binf.getBattProductDate1(),
|
binf.getBattInUseDate(),
|
binf.getBattInUseDate1(),
|
binf.getStationName1(),
|
binf.getStationName(),
|
binf.getBattProducer(),
|
|
binf.getBattGroupId(),
|
"%"+binf.getBattGroupName1()+"%",
|
binf.getMonVolStd(),
|
binf.getMonCapStd(),
|
uinf.getUName(),
|
mainf.getMaint_done_time(),
|
mainf.getMaint_done_time1()
|
},
|
new BattInfAgainImpl());
|
}
|
|
List<Batt_Maint_Dealarm> listd=new ArrayList();
|
/*for(int i=0;i<list.size();i++){
|
System.out.println(((Batt_Maint_Dealarm)list.get(i)).getBinf().getBattGroupId());
|
}*/
|
int index=0;
|
//System.out.println(list.size());
|
for(int i=(bmd.getPage().getPageCurr()-1)*bmd.getPage().getPageSize();i<bmd.getPage().getPageSize()*bmd.getPage().getPageCurr()&&i<list.size();i++){
|
listd.add((Batt_Maint_Dealarm) list.get(i));
|
//system.out.println(list.get(i));
|
((Batt_Maint_Dealarm)listd.get(index++)).getPage().setPageAll(list.size());
|
}
|
return listd;
|
}
|
//1.2电池组统计分析查询
|
@SuppressWarnings("unchecked")
|
public List serchByTestType(Object obj){
|
Batt_Maint_Dealarm bmd = (Batt_Maint_Dealarm) obj;
|
List<Batt_Maint_Dealarm> list = new ArrayList<Batt_Maint_Dealarm>();;
|
BattInf binf = bmd.getBinf();
|
Batt_maint_inf mainf = bmd.getMainf();
|
Batttestdata_inf tdata = bmd.getTdata();
|
User_inf uinf=bmd.getUinf();
|
String sql="";
|
String numberSql=" SELECT FOUND_ROWS() number";
|
Connection conn=DBUtil.getConn();
|
String baseSql="select SQL_CALC_FOUND_ROWS distinct(db_battinf.tb_battinf.BattgroupId),StationName1,StationName,stationip,BattGroupName,BattGroupName1,battgroupnum,moncount,moncapstd,monvolstd,battproducer,battproductdate,battinusedate " +
|
",maint_done_time " +
|
",test_record_count,test_type,test_starttime,test_starttype,test_curr,test_timelong,max_monvol,min_monvol,min_monnum,test_cap,data_new ,db_user.tb_user_battgroup_baojigroup_battgroup.battgroupid " +
|
"from db_batt_testdata.tb_batttestdata_inf " +
|
"left outer join db_battinf.tb_batt_maint_inf on db_batt_testdata.tb_batttestdata_inf.BattgroupId=db_battinf.tb_batt_maint_inf.BattGroupId " +
|
"left outer join db_battinf.tb_battinf on db_battinf.tb_battinf.BattgroupId=db_batt_testdata.tb_batttestdata_inf.BattGroupId " +
|
"left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.battgroupid=db_batt_testdata.tb_batttestdata_inf.BattgroupId " +
|
"left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id= db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id " +
|
"left outer join db_user.tb_user_inf on db_user.tb_user_inf.uId=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
"where test_type=? and db_batt_testdata.tb_batttestdata_inf.record_time>=? and db_batt_testdata.tb_batttestdata_inf.record_time<=? " +
|
"and battproductdate>=? and battproductdate<=? and battinusedate>=? and battinusedate<=?";
|
//用于维护区
|
String station1SqlT=" and stationname1!=? ";//全部
|
String station1SqlF=" and stationname1=? ";
|
if(binf.getStationName1().equals("")){
|
baseSql+=station1SqlT;
|
}else{
|
baseSql+=station1SqlF;
|
}
|
//用于机房站点
|
String stationSqlT=" and stationname!=? ";//全部
|
String stationSqlF=" and stationname=? ";
|
if(binf.getStationName().equals("")){
|
baseSql+=stationSqlT;
|
}else{
|
baseSql+=stationSqlF;
|
}
|
//用于电池类型
|
String producerSqlT=" and battproducer!=? ";//全部
|
String producerSqlF=" and battproducer=? ";
|
if(binf.getBattProducer().equals("")){
|
baseSql+=producerSqlT;
|
}else{
|
baseSql+=producerSqlF;
|
}
|
//选取蓄电池组条件
|
String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? ";
|
String idSqlF=" and db_battinf.tb_battinf.battgroupid=? ";
|
if(binf.getBattGroupId()==0){
|
baseSql+=idSqlT;
|
}else{
|
baseSql+=idSqlF;
|
}
|
//选取系统类型
|
String nameSqlT=" and BattGroupName1 like ? ";
|
String nameSqlF=" and BattGroupName1 not like '%开关电源系统%' and BattGroupName1 not like '%UPS系统%' and BattGroupName1 not like ? ";
|
if(binf.getBattGroupName1().equals("其他")){
|
baseSql+=nameSqlF;
|
}else{
|
baseSql+=nameSqlT;
|
}
|
//用于单体电压
|
String volSqlT=" and monVolStd!=? ";//全部
|
String volSqlF=" and monVolStd=?" ;
|
if(binf.getMonVolStd()==0){
|
baseSql+=volSqlT;
|
}else{
|
baseSql+=volSqlF;
|
}
|
//用于电池容量
|
String capSqlT=" and monCapStd!=? ";//全部
|
String capSqlF=" and monCapStd=?" ;
|
if(binf.getMonCapStd()==0){
|
baseSql+=capSqlT;
|
}else{
|
baseSql+=capSqlF;
|
}
|
//包机人
|
String userSqlF=" and db_user.tb_user_inf.uname=? and db_user.tb_user_inf.ubaojiusr=1 ";
|
if(uinf.getUName().equals("0")){
|
baseSql=baseSql;
|
}else{
|
baseSql+=userSqlF;
|
}
|
//用于测试类型
|
//全部
|
String start_typeA=" ";
|
//拉闸放电
|
String start_typeF=" and test_starttype<5 and test_type not in(2,9) and test_starttype!=2 ";
|
//核对性放电
|
String start_typeT=" and test_starttype>=5 or (test_type not in(2,9) and test_starttype=2) ";
|
if(tdata.getTest_starttype()==0){
|
baseSql+=start_typeA;
|
}else if(tdata.getTest_starttype()==1){
|
baseSql+=start_typeF;
|
}else if(tdata.getTest_starttype()==2){
|
baseSql+=start_typeT;
|
}
|
|
//用于电池维护记录条件
|
//有维护记录
|
String maintSqlT=" and db_battinf.tb_battinf.BattGroupId in(select db_battinf.tb_batt_maint_inf.battgroupid from db_battinf.tb_batt_maint_inf where to_days(maint_done_time)>=to_days(?) and to_days(maint_done_time)<=to_days(?)) " ;
|
//无维护记录
|
String maintSqlF=" and db_battinf.tb_battinf.BattGroupId not in(select db_battinf.tb_batt_maint_inf.battgroupid from db_battinf.tb_batt_maint_inf where to_days(maint_done_time)>=to_days(?) and to_days(maint_done_time)<=to_days(?)) " ;
|
//全部
|
String maintSqlA=" and db_battinf.tb_battinf.BattGroupId!=(select count(distinct(db_battinf.tb_batt_maint_inf.battgroupid )) from db_battinf.tb_batt_maint_inf where to_days(maint_done_time)>=to_days(?) and to_days(maint_done_time)<=to_days(?)) " ;
|
|
if(mainf.getRemark().equals("0")){
|
baseSql+=maintSqlF;
|
}else if(mainf.getRemark().equals("1")){
|
baseSql+=maintSqlT;
|
}else if(mainf.getRemark().equals("100")){
|
baseSql+=maintSqlA;
|
}
|
String endSql=" order by StationName1,db_battinf.tb_battinf.BattgroupId";
|
String limitSql=" limit ?,? ";
|
sql=baseSql+endSql+limitSql;
|
System.out.println(sql);
|
if(uinf.getUName().equals("0")){
|
list = DAOHelper.executeQueryLimit(
|
sql,
|
conn,
|
new Object[] {
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
binf.getBattProductDate(),
|
binf.getBattProductDate1(),
|
binf.getBattInUseDate(),
|
binf.getBattInUseDate1(),
|
binf.getStationName1(),
|
binf.getStationName(),
|
binf.getBattProducer(),
|
|
binf.getBattGroupId(),
|
"%"+binf.getBattGroupName1()+"%",
|
binf.getMonVolStd(),
|
binf.getMonCapStd(),
|
mainf.getMaint_done_time(),
|
mainf.getMaint_done_time1(),(bmd.getPage().getPageCurr() - 1)* bmd.getPage().getPageSize(),
|
bmd.getPage().getPageSize()
|
},
|
new BattInfAgainImpl());
|
}else{
|
list = DAOHelper.executeQueryLimit(
|
sql,
|
conn,
|
new Object[] {
|
tdata.getTest_type(),
|
tdata.getRecord_time(),
|
tdata.getRecord_time1(),
|
binf.getBattProductDate(),
|
binf.getBattProductDate1(),
|
binf.getBattInUseDate(),
|
binf.getBattInUseDate1(),
|
binf.getStationName1(),
|
binf.getStationName(),
|
binf.getBattProducer(),
|
|
binf.getBattGroupId(),
|
"%"+binf.getBattGroupName1()+"%",
|
binf.getMonVolStd(),
|
binf.getMonCapStd(),
|
uinf.getUName(),
|
mainf.getMaint_done_time(),
|
mainf.getMaint_done_time1(),(bmd.getPage().getPageCurr() - 1)* bmd.getPage().getPageSize(),
|
bmd.getPage().getPageSize()
|
},
|
new BattInfAgainImpl());
|
}
|
|
/*List<Batt_Maint_Dealarm> listd=new ArrayList();
|
for(int i=0;i<list.size();i++){
|
System.out.println(((Batt_Maint_Dealarm)list.get(i)).getBinf().getBattGroupId());
|
}
|
int index=0;
|
System.out.println(list.size());
|
for(int i=(bmd.getPage().getPageCurr()-1)*bmd.getPage().getPageSize();i<bmd.getPage().getPageSize()*bmd.getPage().getPageCurr()&&i<list.size();i++){
|
listd.add((Batt_Maint_Dealarm) list.get(i));
|
//system.out.println(list.get(i));
|
((Batt_Maint_Dealarm)listd.get(index++)).getPage().setPageAll(list.size());
|
}*/
|
//去掉limit条件后的总数
|
int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql);
|
System.out.println("number: "+number);
|
if(list!=null&&list.size()>0){
|
list.get(list.size()-1).getPage().setPageAll(number);
|
}
|
return list;
|
}
|
public static void main(String[] args) throws ParseException {
|
BattInfAgainImpl biml = new BattInfAgainImpl();
|
BattInf binf = new BattInf();
|
/*
|
* binf.setStationName("中国山西太原杏花岭区移动枢纽一枢纽-2F-网管监控-203");
|
* binf.setStationName1("一枢纽");
|
* binf.setBattGroupName("1#开关电源系统-1#电池组-光宇-24节");
|
* binf.setBattGroupName1("开关电源系统"); binf.setBattProducer("光宇");
|
* binf.setMonCapStd(100f); binf.setMonVolStd(12f);
|
*/
|
binf.setStationName("太原小店二枢纽4号楼5层动力机房");
|
binf.setStationName1("二枢纽");
|
//binf.setBattGroupName("");
|
binf.setBattGroupId(0);
|
binf.setBattGroupName1("");
|
binf.setBattProducer("光宇");
|
binf.setMonCapStd(0f);
|
binf.setMonVolStd(0f);
|
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date1 = sdf.parse("2000-01-01");
|
Date date2 = sdf.parse("2020-01-01");
|
binf.setBattProductDate(ActionUtil.getSimpDate(date1));
|
binf.setBattProductDate1(ActionUtil.getSimpDate(date2));
|
binf.setBattInUseDate(ActionUtil.getSimpDate(date1));
|
binf.setBattInUseDate1(ActionUtil.getSimpDate(date2));
|
|
/*
|
* binf.getStationName1(), binf.getStationName(),
|
* binf.getBattGroupName(), binf.getBattProducer(),
|
* binf.getBattGroupName1(), binf.getBattProductDate(),
|
* binf.getBattProductDate1(), binf.getBattInUseDate(),
|
* binf.getBattInUseDate1(),
|
*/
|
|
Batt_maint_inf mainf = new Batt_maint_inf();
|
mainf.setRemark("100");
|
mainf.setMaint_done_time(ActionUtil.getSimpDate(date1));
|
mainf.setMaint_done_time1(ActionUtil.getSimpDate(date2));
|
|
Batttestdata_inf tdata = new Batttestdata_inf();
|
tdata.setTest_type(3);
|
tdata.setTest_starttype(0);
|
tdata.setRecord_time(ActionUtil.getSimpDate(date1));
|
tdata.setRecord_time1(ActionUtil.getSimpDate(date2));
|
|
Page p=new Page();
|
p.setPageCurr(1);
|
p.setPageSize(10);
|
|
User_inf uinf=new User_inf();
|
uinf.setUName("0");
|
Batt_Maint_Dealarm bmd = new Batt_Maint_Dealarm();
|
bmd.setBinf(binf);
|
bmd.setMainf(mainf);
|
bmd.setTdata(tdata);
|
bmd.setPage(p);
|
bmd.setUinf(uinf);
|
|
List<Batt_Maint_Dealarm> list = biml.serchByTestType(bmd);
|
for (Batt_Maint_Dealarm b : list) {
|
System.out.println(b);
|
}
|
System.out.println(list.size());
|
}
|
|
}
|
