taskinfoserver.java

该项目采用Struts框架

package com.cattsoft.task.dao;

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

import com.cattsoft.vo.Plan;
import com.cattsoft.vo.Task;
import com.cattsoft.vo.User;

public interface TaskInfoServer {
	//根据主管id去查询其下的员工
	public List<User> queryEmployeeBy(int user_id) throws ClassNotFoundException, SQLException;
	//新建任务
	public int newTask(Task task) throws ClassNotFoundException, SQLException;
	//根据员工用户名查询其姓名
	public String queryNameBy(String empId) throws ClassNotFoundException, SQLException;
	//查询所有任务
	public List<Task> queryAllTask(String m_id) throws ClassNotFoundException, SQLException;
	//删除任务
	public void deleteTask(int t_id) throws ClassNotFoundException, SQLException;
	//根据任务id查询任务详细信息
	public List<Task> queryTaskBy(int t_id) throws ClassNotFoundException, SQLException;
	//查询未实施状态的所有任务信息
	public List<Task> queryTaskUndoBy(String empId) throws ClassNotFoundException, SQLException;
	//更新task表
	public void updateTask(Task task) throws ClassNotFoundException, SQLException;
	//根据员工id查询其详细信息
	public List<User> queryEmpInfoBy(int user_id) throws ClassNotFoundException, SQLException;
	//根据任务id和任务状态更新该任务信息
	public void updateTask(int t_id,String t_state) throws ClassNotFoundException, SQLException;
	//根据任务id查询其对应的计划信息
	public List<Plan> queryPlanBy(int t_id) throws ClassNotFoundException, SQLException;
	//根据计划id查询其对应的计划详细信息
	public List<Plan> queryPlan(int p_id) throws ClassNotFoundException,SQLException;
	//查询实施中状态的所有任务信息
	public List<Task> queryInForceTask(String empId) throws ClassNotFoundException, SQLException;
	//根据实施中的任务id查询其详细任务信息
	public List<Task> queryTask(int t_id) throws ClassNotFoundException, SQLException;
	//根据实施中的任务id查询其详细计划信息
	public List<Plan> queryPlanAll(int t_id) throws ClassNotFoundException, SQLException;
}