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.Batt_maintenance_inf;
import com.fgkj.dto.Batttestdata_inf;
import com.mysql.fabric.xmlrpc.base.Array;

public class Batt_maintenance_infDAOImpl implements BaseDAO {
	private SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

	// private SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
	public boolean add(Object obj) {
		return false;
	}

	public boolean update(Object obj) {
		return false;
	}

	public boolean del(Object obj) {
		return false;
	}

	public List searchAll() {
		String sql = "select num,BattGroupId,mon_num,fault_type,fault_time,maintenance_type,maintenance_man,maintenance_time,remark from db_battinf.tb_batt_maintenance_inf";
		return DAOHelper.executeQuery(sql,
				DBUtil.getConn(), null, new CallBack() {

					public List getResults(ResultSet rs) {
						List list = new ArrayList();
						try {
							while (rs.next()) {
								Batt_maintenance_inf bmi = new Batt_maintenance_inf();
								bmi.setNum(rs.getInt("num"));
								bmi.setBattGroupId(rs.getInt("BattGroupId"));
								bmi.setMon_num(rs.getString("mon_num"));
								bmi.setFault_type(rs.getString("fault_type"));
								bmi.setFault_time(sdf.parse(rs
										.getString("fault_time")));
								bmi.setMaintenance_type(rs
										.getString("maintenance_type"));
								bmi.setMaintenance_man(rs
										.getString("maintenance_man"));
								bmi.setMaintenance_time(sdf.parse(rs
										.getString("maintenance_time")));
								bmi.setRemark(rs.getString("remark"));
								list.add(bmi);
							}
							// System.out.println(list);
						} catch (SQLException e) {
							e.printStackTrace();
						} catch (ParseException e) {
							e.printStackTrace();
						}
						return list;
					}
				});
	}

	//根据battgroupid查故障信息
	public List serchByCondition(Object obj) {
		Batt_maintenance_inf binf=(Batt_maintenance_inf) obj;
		String sql=null;
		List list=null;
			//System.out.println(binf);
			sql="select battgroupid,fault_type,maintenance_time from db_battinf.tb_batt_maintenance_inf where battgroupid=? and to_days(maintenance_time)>=to_days(?) and to_days(maintenance_time)<=to_days(?)";
		    list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattGroupId(),binf.getMaintenance_time(),binf.getMaintenance_time1()}, new CallBack() {
				
				public List getResults(ResultSet rs) {
					List list=new ArrayList();
					try {
						while(rs.next()){
							Batt_maintenance_inf bminf=new Batt_maintenance_inf();
							
							bminf.setBattGroupId(rs.getInt("BattGroupId"));
							bminf.setFault_type(rs.getString("fault_type"));
							bminf.setMaintenance_time(rs.getTimestamp("maintenance_time"));
							
							list.add(bminf)	;
						}
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
					return list;
				}
			});
			
		return list;
	}


	public List serchByInfo(Object obj) {
		return null;
	}

	public static void main(String[] args) throws ParseException {
		Batttestdata_inf bdata=new Batttestdata_inf();
		bdata.setBattGroupId(1000001);
		
		//bdata.setTest_type(2000);
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
		Date date1= sdf.parse("2017-07-14");
		Date date2= sdf.parse("2017-07-14");
		bdata.setRecord_time(ActionUtil.getSimpDate(date1));
		bdata.setRecord_time1(ActionUtil.getSimpDate(date2));
		Batttestdata_infDAOImpl b=new Batttestdata_infDAOImpl();
		/*List<Batttestdata_inf> list=b.serchByCondition(binf);
		for(Batttestdata_inf bd:list){
			System.out.println(bd);
		}*/
		//List<Batttestdata_inf> list=b.serchByDataNew(bdata);
		List<Batttestdata_inf> list=b.serchByTestType3(bdata);
		for(Batttestdata_inf bd:list){
			System.out.println(bd);
		}
		System.out.println(list.size());
	}

}