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.User_task_batt_template;

public class User_task_batt_templateImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		List list=new ArrayList();
		try {
			while(rs.next()){
				User_task_batt_template ute=new User_task_batt_template();
				ute.setTemplate_id(rs.getInt("template_id"));
				ute.setTemplate_name(rs.getString("template_name"));
				ute.setTask_batt_check_en(rs.getInt("task_batt_check_en"));
				ute.setTask_batt_lazha_test_en(rs.getInt("task_batt_lazha_test_en"));
				ute.setTask_batt_cap40_test_en(rs.getInt("task_batt_cap40_test_en"));
				ute.setTask_batt_cap80_test_en(rs.getInt("task_batt_cap80_test_en"));
				ute.setTask_param_id(rs.getInt("task_param_id"));
				ute.setTask_battgroup_quyu_index(rs.getInt("task_battgroup_quyu_index"));
				ute.setTask_exe_usr_selmode(rs.getInt("task_exe_usr_selmode"));
				ute.setTask_exe_usrlunliu_count(rs.getInt("task_exe_usrlunliu_count"));
				ute.setTask_create_mode(rs.getInt("task_create_mode"));
				list.add(ute);		
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	//4.4 作业模板管理(新建模板)
	public boolean add(Object obj) {
		User_task_batt_template utem=(User_task_batt_template) obj;
		String sql="insert into db_user.tb_user_task_batt_template(template_name,task_batt_check_en,task_batt_lazha_test_en," +
				"task_batt_cap40_test_en,task_batt_cap80_test_en,task_param_id,task_battgroup_quyu_index,task_exe_usr_selmode," +
				"task_exe_usrlunliu_count,task_create_mode) values(?,?,?,?,?,?,?,?,?,?)";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{utem.getTemplate_name(),utem.getTask_batt_check_en(),
			utem.getTask_batt_lazha_test_en(),utem.getTask_batt_cap40_test_en(),utem.getTask_batt_cap80_test_en(),utem.getTask_param_id(),
			utem.getTask_battgroup_quyu_index(),utem.getTask_exe_usr_selmode(),utem.getTask_exe_usrlunliu_count(),utem.getTask_create_mode()});
		return bl;
	}
	//4.4 作业模板管理(修改模板/重命名)
	public boolean update(Object obj) {
		User_task_batt_template utem=(User_task_batt_template) obj;
		String sql="update db_user.tb_user_task_batt_template set template_name=?,task_batt_check_en=?,task_batt_lazha_test_en=?," +
				"task_batt_cap40_test_en=?,task_batt_cap80_test_en=?,task_param_id=?,task_battgroup_quyu_index=?,task_exe_usr_selmode=?," +
				"task_exe_usrlunliu_count=?,task_create_mode=? where template_id=?";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{utem.getTemplate_name(),utem.getTask_batt_check_en(),
			utem.getTask_batt_lazha_test_en(),utem.getTask_batt_cap40_test_en(),utem.getTask_batt_cap80_test_en(),utem.getTask_param_id(),
			utem.getTask_battgroup_quyu_index(),utem.getTask_exe_usr_selmode(),utem.getTask_exe_usrlunliu_count(),utem.getTask_create_mode(),
			utem.getTemplate_id()});
		return bl;
	}
	
	//4.4 作业模板管理(修改模板/重命名)<多条修改>
	public String updatePro(Object obj){
		User_task_batt_template utem=(User_task_batt_template) obj;
		String sql="update db_user.tb_user_task_batt_template set " +
				"template_name='"+utem.getTemplate_name()+"'"+
				",task_batt_check_en="+utem.getTask_batt_check_en()+
				",task_batt_lazha_test_en="+utem.getTask_batt_lazha_test_en()+
				 ",task_batt_cap40_test_en="+utem.getTask_batt_cap40_test_en()+
				 ",task_batt_cap80_test_en="+utem.getTask_batt_cap80_test_en()+
				 ",task_param_id="+utem.getTask_param_id()+
				 ",task_battgroup_quyu_index="+utem.getTask_battgroup_quyu_index()+
				 ",task_exe_usr_selmode="+utem.getTask_exe_usr_selmode()+
				 ",task_exe_usrlunliu_count="+utem.getTask_exe_usrlunliu_count()+
				 ",task_create_mode="+utem.getTask_create_mode()+
				 " where template_id="+utem.getTemplate_id();
		//System.out.println(sql);
		return sql;
	}

	//4.4 作业模板管理(删除)
	public boolean del(Object obj) {
		User_task_batt_template utem=(User_task_batt_template) obj;
		String sql="delete from db_user.tb_user_task_batt_template where template_id=?";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{utem.getTemplate_id()});
		return bl;
	}

	//4.4查询所有的模板
	public List searchAll() {
		String sql="select template_id,template_name,task_batt_check_en,task_batt_lazha_test_en," +
				"task_batt_cap40_test_en,task_batt_cap80_test_en,task_param_id,task_battgroup_quyu_index,task_exe_usr_selmode," +
				"task_exe_usrlunliu_count,task_create_mode from db_user.tb_user_task_batt_template";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new User_task_batt_templateImpl());
		return list;
	}
    //4.4根据模板id查询模板的信息
	public List serchByCondition(Object obj) {
		User_task_batt_template utem=(User_task_batt_template) obj;
		String sql="select template_id,template_name,task_batt_check_en,task_batt_lazha_test_en," +
				"task_batt_cap40_test_en,task_batt_cap80_test_en,task_param_id,task_battgroup_quyu_index,task_exe_usr_selmode," +
				"task_exe_usrlunliu_count,task_create_mode from db_user.tb_user_task_batt_template where template_id=?";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{utem.getTemplate_id()}, new User_task_batt_templateImpl());
		return list;
	}

	public List serchByInfo(Object obj) {
		// TODO Auto-generated method stub
		return null;
	}
	
	public static void main(String[] args) {
		User_task_batt_templateImpl ut=new User_task_batt_templateImpl();
		User_task_batt_template u=new User_task_batt_template();
		u.setTemplate_id(100001);
		List<User_task_batt_template> list=ut.serchByCondition(u);
		for(User_task_batt_template uu:list){
			System.out.println(uu);
		}
		/*List<User_task_batt_template> list=ut.searchAll();
		for(User_task_batt_template uu:list){
			System.out.println(uu);
		}*/
	}

}