package com.fgkj.dao.impl;

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.db.IDatabaseName;
import com.fgkj.dto.BattDischarge_param;
import com.sun.org.apache.bcel.internal.generic.GETFIELD;
import com.sun.org.apache.xerces.internal.impl.dv.dtd.IDDatatypeValidator;

public class BattDischarge_paramImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		List list=new ArrayList();
		try {
			while(rs.next()){
				BattDischarge_param bparam=new BattDischarge_param();
				bparam.setNum(rs.getInt("num"));
				bparam.setPreset_time(rs.getInt("preset_time"));
				bparam.setPreset_cap(rs.getFloat("preset_cap"));
				bparam.setPreset_monvol(rs.getFloat("preset_monvol"));
				bparam.setPreset_groupvol(rs.getFloat("preset_groupvol"));
				bparam.setParam_name(rs.getString("param_name"));
				bparam.setPreset_curr(rs.getFloat("preset_curr"));
				bparam.setPreset_mon(rs.getInt("preset_mon"));
				bparam.setDcvolhighlimit(rs.getFloat("dcvolhighlimit"));
				bparam.setChargecurrset(rs.getFloat("chargecurrset"));
				bparam.setNote(rs.getString("note"));
				list.add(bparam);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
    //8.1添加新的参数
	public boolean add(Object obj) {
		BattDischarge_param bparam=(BattDischarge_param) obj;
		String sql="insert into web_site.tb_battdischarge_param(param_name,preset_time,preset_cap,preset_monvol,preset_groupvol,preset_curr,preset_mon,dcvolhighlimit,chargecurrset,note) values(?,?,?,?,?,?,?,?,?,?)";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{bparam.getParam_name(),bparam.getPreset_time(),bparam.getPreset_cap(),
			bparam.getPreset_monvol(),bparam.getPreset_groupvol(),bparam.getPreset_curr(),bparam.getPreset_mon(),
			bparam.getDcvolhighlimit(),bparam.getChargecurrset(),bparam.getNote()});
		return bl;
	}
	
    //8.1修改参数信息
	public boolean update(Object obj) {
		BattDischarge_param bparam=(BattDischarge_param) obj;
		String sql="update web_site.tb_battdischarge_param set param_name=?,preset_time=? ,preset_cap=?,preset_monvol=?,preset_groupvol=?,preset_curr=?,preset_mon=?,dcvolhighlimit=?,chargecurrset=?,note=? where num=? ";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{bparam.getParam_name(),bparam.getPreset_time(),bparam.getPreset_cap(),
			bparam.getPreset_monvol(),bparam.getPreset_groupvol(),bparam.getPreset_curr(),bparam.getPreset_mon(),
			bparam.getDcvolhighlimit(),bparam.getChargecurrset(),bparam.getNote(),bparam.getNum()});
		
		return bl;
	}

	public boolean del(Object obj) {
		BattDischarge_param bparam=(BattDischarge_param) obj;
		String sql="delete from web_site.tb_battdischarge_param where num=?";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{bparam.getNum()});
		
		return bl;
	}
    //8.1查询所有的参数
	public List searchAll() {
		String sql="select num,param_name,preset_time,preset_cap,preset_monvol,preset_groupvol,preset_curr,preset_mon,dcvolhighlimit,chargecurrset,note from web_site.tb_battdischarge_param";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new BattDischarge_paramImpl());
		return list;
	}
    
	public List serchByCondition(Object obj) {
		BattDischarge_param bparam=(BattDischarge_param) obj;
		String sql="select num,param_name,preset_time,preset_cap,preset_monvol,preset_groupvol,preset_curr,preset_mon,dcvolhighlimit,chargecurrset,note from web_site.tb_battdischarge_param where num=?";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{bparam.getNum()}, new BattDischarge_paramImpl());
		return list;
	}

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

}