package com.fgkj.dao.impl;
|
|
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.db.DBUtil;
|
import com.fgkj.db.IDatabaseName;
|
import com.fgkj.dto.BattInf;
|
import com.fgkj.dto.Batt_User_Permit;
|
import com.fgkj.dto.Batt_maint_inf;
|
import com.fgkj.dto.Page;
|
import com.fgkj.dto.User_inf;
|
|
public class Batt_maint_infAgainImpl implements BaseDAO, CallBack {
|
|
public List getResults(ResultSet rs) {
|
return null;
|
}
|
|
public boolean add(Object obj) {
|
return false;
|
}
|
|
public boolean update(Object obj) {
|
return false;
|
}
|
|
public boolean del(Object obj) {
|
return false;
|
}
|
|
public List searchAll() {
|
return null;
|
}
|
|
//2.2电池故障处理统计查询
|
/*
|
* 维护区：stationname1
|
* 包机人：stationname
|
* 电池品牌：battproducer
|
* 统计方式：devicename
|
* 统计开始时间：battproductdate
|
* 统计结束时间：battproductdata1
|
* */
|
public List serchByCondition(Object obj) {
|
final BattInf binf=(BattInf) obj;
|
|
// System.out.println(binf);
|
String sql = "select distinct(db_battinf.tb_batt_maint_inf.usr_id),fault_time,maint_done_time,maint_time_limit,maint_done "
|
+ "from db_battinf.tb_batt_maint_inf,db_battinf.tb_battinf ,db_user.tb_user_inf "
|
+ "where db_battinf.tb_batt_maint_inf.battgroupid=db_battinf.tb_battinf .battgroupid "
|
+ "and fault_time>=? and fault_time<=? "
|
+ "and db_battinf.tb_batt_maint_inf.usr_id=db_user.tb_user_inf.uid ";
|
//责任人(包机人)
|
String unameSqlF=" and db_user.tb_user_inf.uname!=? ";
|
String unameSqlT=" and db_user.tb_user_inf.uname=? ";
|
if(binf.getStationName().equals("")){
|
sql+=unameSqlF;
|
}else{
|
sql+=unameSqlT;
|
}
|
//用于维护区
|
String station1SqlT=" and stationname1!=? ";//全部
|
String station1SqlF=" and stationname1=? ";
|
if(binf.getStationName1().equals("")){
|
sql+=station1SqlT;
|
}else{
|
sql+=station1SqlF;
|
}
|
//用于电池类型
|
String producerSqlT=" and battproducer!=? ";//全部
|
String producerSqlF=" and battproducer=? ";
|
if(binf.getBattProducer().equals("")){
|
sql+=producerSqlT;
|
}else{
|
sql+=producerSqlF;
|
}
|
List list = DAOHelper.executeQuery(
|
sql,
|
DBUtil.getConn(),
|
new Object[] {
|
binf.getBattProductDate(),
|
binf.getBattProductDate1(),
|
binf.getStationName(),
|
binf.getStationName1(),
|
binf.getBattProducer(),}, new CallBack() {
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
try {
|
// System.out.println(rs.next());
|
while (rs.next()) {
|
Batt_maint_inf mainf = new Batt_maint_inf();
|
mainf.setUsr_id(rs.getInt("usr_id"));
|
mainf.setFault_time(rs.getTimestamp("fault_time"));
|
mainf.setMaint_done_time(rs.getTimestamp("maint_done_time"));
|
mainf.setMaint_time_limit(rs.getTimestamp("maint_time_limit"));
|
mainf.setMaint_done(rs.getInt("maint_done"));
|
|
// maint_result存放统计方式
|
|
mainf.setMaint_result(binf.getDeviceName());
|
|
// fault_caption存放维护区
|
if (binf.getStationName1().equals("")) {
|
mainf.setFault_caption("全部");
|
} else {
|
mainf.setFault_caption(binf.getStationName1());
|
}
|
// master_check存放包机人
|
if (binf.getStationName().equals("")) {
|
mainf.setMaster_check("全部");
|
} else {
|
mainf.setMaster_check(binf.getStationName());
|
}
|
// remark存放品牌
|
if (binf.getBattProducer().equals("")) {
|
mainf.setRemark("全部");
|
} else {
|
mainf.setRemark(binf.getBattProducer());
|
}
|
//System.out.println(mainf);
|
list.add(mainf);
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
|
// List<Batt_maint_inf> listd=new ArrayList();
|
// int index=0;
|
// for(int i=(bup.getPage().getPageCurr()-1)*bup.getPage().getPageSize();i<bup.getPage().getPageSize()*bup.getPage().getPageCurr()&&i<list.size();i++){
|
// ((Batt_maint_inf)list.get(i)).setMaster_id(list.size());
|
// listd.add((Batt_maint_inf) list.get(i));
|
// //System.out.println(list.get(i));
|
// }
|
//System.out.println(listd.size());
|
return list;
|
}
|
|
public List serchByInfo(Object obj) {
|
return null;
|
}
|
|
public static void main(String[] args) throws ParseException {
|
BattInf binf = new BattInf();
|
binf.setStationName1("");
|
binf.setStationName("");
|
binf.setBattProducer("");
|
binf.setDeviceName("1");
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date1 = sdf.parse("2000-01-01");
|
Date date2 = sdf.parse("2016-12-30");
|
binf.setBattProductDate(ActionUtil.getSimpDate(date1));
|
binf.setBattProductDate1(ActionUtil.getSimpDate(date2));
|
|
User_inf uinf = new User_inf();
|
uinf.setUName("0");
|
|
Page p = new Page();
|
p.setPageCurr(1);
|
p.setPageSize(10);
|
|
Batt_User_Permit bup = new Batt_User_Permit();
|
bup.setBinf(binf);
|
bup.setPage(p);
|
bup.setUinf(uinf);
|
Batt_maint_infAgainImpl bimpl = new Batt_maint_infAgainImpl();
|
List<Batt_maint_inf> list = bimpl.serchByCondition(bup);
|
|
for (Batt_maint_inf batt_maint_inf : list) {
|
System.out.println(batt_maint_inf);
|
}
|
System.out.println(list.size());
|
}
|
|
}
|
