package cn.com.lzt.projarrangedetail.dao;

import java.util.List;

import org.jeecgframework.minidao.annotation.Arguments;
import org.jeecgframework.minidao.annotation.MiniDao;
import org.jeecgframework.minidao.annotation.Param;
import org.jeecgframework.minidao.annotation.ResultType;
import org.jeecgframework.minidao.annotation.Sql;

import cn.com.lzt.arrangedutyoperate.entity.ArrangeDutyOperateEntity;
import cn.com.lzt.projarrangedetail.dto.ProjArrangeDetailAndUserDto;

/**
 * 查询项目排班详细表
 * 
 * 
 */
@MiniDao
public interface ProjArrangeDetailAndUserMiniDao {
	
	/**
	 * 根据项目pid,月度yearMonth查询岗位postId和用户userId
	 * @author zbw
	 * 2017-11-6
	 * @param projArrangeDetailAndUserMiniDaoDto
	 * @param authSql
	 * @return
	 */
	@Arguments({"projArrangeDetailAndUserDto", "authSql"})
	@ResultType(ProjArrangeDetailAndUserDto.class)
	public List<ProjArrangeDetailAndUserDto> getProjArrangeDetailAndUserByPIdYearMonth( ProjArrangeDetailAndUserDto projArrangeDetailAndUserDto, 
	String authSql);
	
	
	/**
	 * 根据员工idList和月度查询员工信息和项目排班详细表数据
	 * @author zbw
	 * 2017-11-6
	 * @param projArrangeDetailAndUserMiniDaoDto
	 * @param authSql
	 * @return
	 */
	@Arguments({"projArrangeDetailAndUserDto", "authSql"})
	@ResultType(ProjArrangeDetailAndUserDto.class)
	public List<ProjArrangeDetailAndUserDto> getProjArrangeDetailAndUserByUserIdListYearMonth( ProjArrangeDetailAndUserDto projArrangeDetailAndUserDto, 
	String authSql);
	
	
	@ResultType(ArrangeDutyOperateEntity.class)
	public List<ArrangeDutyOperateEntity> getArrangeDutyOperate4CopyLastMonth(@Param("yearmonth")String yearmonth,@Param("pid")String pid);
	
}