package com.fgkj.dao.impl.rt;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.CallBack;
import com.fgkj.dao.DAOHelper;
import com.fgkj.db.DBUtil;
import com.fgkj.dto.Batt_rtdata;
import com.fgkj.dto.rt.Batt_rtdataRt;

public class Batt_rtdataRtImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		List list=new ArrayList();
		try {
			while(rs.next()){
				Batt_rtdataRt rtdataRt=new Batt_rtdataRt();
				rtdataRt.setNum(rs.getInt("num"));
				rtdataRt.setBattGroupId(rs.getInt("BattGroupId"));
				rtdataRt.setRec_datetime(rs.getDate("rec_datetime"));
				rtdataRt.setMon_num(rs.getInt("mon_num"));
				rtdataRt.setMon_vol(rs.getFloat("mon_vol"));
				rtdataRt.setMon_tmp(rs.getFloat("mon_tmp"));
				rtdataRt.setMon_res(rs.getFloat("mon_res"));
				rtdataRt.setMon_ser(rs.getFloat("mon_ser"));
				rtdataRt.setMon_conn_res(rs.getFloat("mon_conn_res"));
				rtdataRt.setMon_cap(rs.getFloat("mon_cap"));
				rtdataRt.setBatt_count(rs.getInt("batt_count"));
				rtdataRt.setOnline_vol(rs.getFloat("online_vol"));
				rtdataRt.setGroup_vol(rs.getFloat("group_vol"));
				rtdataRt.setGroup_curr(rs.getFloat("group_curr"));
				rtdataRt.setBatt_state(rs.getInt("batt_state"));
				rtdataRt.setBatt_test_type(rs.getInt("batt_test_type"));
				rtdataRt.setBatt_test_starttime(rs.getTimestamp("batt_test_starttime"));
				rtdataRt.setBatt_test_recordtime(rs.getTimestamp("batt_test_recordtime"));
				rtdataRt.setBatt_test_tlong(rs.getInt("batt_test_tlong"));
				rtdataRt.setBatt_test_cap(rs.getFloat("batt_test_cap"));
				rtdataRt.setBatt_real_cap(rs.getFloat("batt_real_cap"));
				rtdataRt.setBatt_rest_cap(rs.getFloat("batt_rest_cap"));
				rtdataRt.setBatt_rest_power1_time(rs.getInt("batt_rest_power1_time"));
				rtdataRt.setBatt_rest_power2_time(rs.getInt("batt_rest_power2_time"));
				list.add(rtdataRt);
			}
		} catch (SQLException 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) {
		Batt_rtdataRt rtdataRt=(Batt_rtdataRt)obj;
		String sql="select num,BattGroupId,rec_datetime,mon_num,mon_vol,mon_tmp,mon_res,mon_ser,mon_conn_res,mon_cap" +
				" ,batt_count,rec_datetime,group_vol,online_vol,group_curr,batt_state," +
				" batt_test_type,batt_test_starttime,batt_test_recordtime,batt_test_tlong," +
				" batt_test_cap,batt_real_cap,batt_rest_cap,batt_rest_power1_time,batt_rest_power2_time  " +
			    " from db_ram_batt_rt.tb_batt_rtdata_"+rtdataRt.getBattGroupId();
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new Batt_rtdataRtImpl());
		return list;
	}

	public List serchByInfo(Object obj) {
		// TODO Auto-generated method stub
		return null;
	}
    public static void main(String[] args) {
		Batt_rtdataRtImpl bimpl=new Batt_rtdataRtImpl();
		Batt_rtdataRt b=new Batt_rtdataRt();
		b.setBattGroupId(1000007);
		List<Batt_rtdataRt> list=bimpl.serchByCondition(b);
		for (Batt_rtdataRt rt : list) {
			 System.out.println(rt);
		}
	}
}