package com.fgkj.dao.impl.ram;

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.ram.Fbs9100_battparam;
import com.mysql.fabric.xmlrpc.base.Array;

public class Fbs9100_battparamImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		// TODO Auto-generated method stub
		return null;
	}

	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;
	}
    //根据设备id查询电池参数信息
	public List serchByCondition(Object obj) {
		Fbs9100_battparam bparam=(Fbs9100_battparam) obj;
		String sql=" select distinct num,dev_ip,dev_id,op_cmd,STD_CAP,STD_RES,BattGroupCount,EachGroupBattCount,MonomerVol,GroupVol,BattTemp,FloatChargeVol,FloatChargeCurr,OnlineVolLow,GroupConnType " +
				" ,db_battinf.tb_battinf.DeviceName,StationName,StationName1,StationName2,StationName3,StationName5,StationId " +
				" from db_ram_db.tb_fbs9100_battparam,db_battinf.tb_battinf  " +
				" where dev_id=? and db_ram_db.tb_fbs9100_battparam.dev_id=db_battinf.tb_battinf.fbsdeviceid" +
				" limit 1 ";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{bparam.getDev_id()}, new CallBack() {
			
			public List getResults(ResultSet rs) {
				List list=new ArrayList();
				try {
					while(rs.next()){
						Fbs9100_battparam b=new Fbs9100_battparam();
						b.setNum(rs.getInt("num"));
						b.setDev_ip(rs.getString("dev_ip"));
						b.setDev_id(rs.getInt("dev_id"));
						b.setOp_cmd(rs.getInt("op_cmd"));
						b.setSTD_CAP(rs.getInt("sTD_CAP"));
						b.setSTD_RES(rs.getInt("sTD_RES"));
						b.setBattGroupCount(rs.getInt("battGroupCount"));
						b.setEachGroupBattCount(rs.getInt("eachGroupBattCount"));
						b.setMonomerVol(rs.getFloat("monomerVol"));
						b.setGroupVol(rs.getFloat("groupVol"));
						list.add(b);
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				return null;
			}
		});
		return null;
	}

	public List serchByInfo(Object obj) {
		// TODO Auto-generated method stub
		return null;
	}

}