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_param;
import com.fgkj.dto.User_task_user_list;

public class User_task_user_listImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		List list=new ArrayList();
		try {
			while(rs.next()){
				User_task_user_list uulist=new User_task_user_list();
				uulist.setNum(rs.getInt("num"));
				uulist.setTask_id(rs.getInt("task_id"));
				uulist.setUId(rs.getInt("uId"));
				uulist.setUsr_type(rs.getInt("usr_type"));
				
				list.add(uulist);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	public boolean add(Object obj) {
		User_task_user_list ulist=(User_task_user_list) obj;
		String sql="insert into db_user.tb_user_task_user_list(task_id,uId,usr_type) values(?,?,?)";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ulist.getTask_id(),
			ulist.getUId(),ulist.getUsr_type()});
		return bl;
	}

	//4.1作业管理
	public String addPro(Object obj) {
		User_task_user_list ulist=(User_task_user_list) obj;
		String sql="insert into db_user.tb_user_task_user_list(task_id,uId,usr_type) values("+ulist.getTask_id()+","+
				ulist.getUId()+","+ulist.getUsr_type()+")";
		return sql;
	}

	public boolean update(Object obj) {
		User_task_user_list ulist=(User_task_user_list) obj;
		String sql="update db_user.tb_user_task_user_list set task_id=?,uId=?,usr_type=? where num=?";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ulist.getTask_id(),
			ulist.getUId(),ulist.getUsr_type(),ulist.getNum()});
		return bl;
	}

	public boolean del(Object obj) {
		User_task_user_list ulist=(User_task_user_list) obj;
		String sql="delete from db_user.tb_user_task_user_list where num=?";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ulist.getNum()});
		return bl;
	}

	public List searchAll() {
		String sql="select * from db_user.tb_user_task_user_list";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new User_task_user_listImpl());
		return list;
	}
    //4.1作业管理----根据task_id查主管姓名和指派人姓名
	public List serchByCondition(Object obj) {
		User_task_user_list ulist=(User_task_user_list) obj;
		String sql="select num,task_id,uid,usr_type from db_user.tb_user_task_user_list where task_id=?";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{ulist.getTask_id()}, new User_task_user_listImpl());
		return list;
	}

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

}