package cn.com.countrygarden.bi.main.dao.writtenExamination;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import cn.com.countrygarden.bi.main.core.Mapper;
import cn.com.countrygarden.bi.main.dto.PersonnelWrittenexaminationVO;
import cn.com.countrygarden.bi.main.dto.personnel.QueryCriteriaDTO;
import cn.com.countrygarden.bi.main.dto.PersonInfoVO;
import cn.com.countrygarden.bi.main.dto.PersonnelTgDTO;
import cn.com.countrygarden.bi.main.model.writtenExamination.PersonnelSelectionscore;
/**
 * 个人单独项目跟投表-数据层
 *
 * @author 汤婷
 * @email www.justintoforest@gamail.com
 * @url 
 * @date 2018-10-17
 */
public interface PersonnelSelectionscoreMapper extends Mapper<PersonnelSelectionscore>{

	List<PersonnelWrittenexaminationVO> findPersonnelWrittenexaminationVOAll(@Param("code")String code,@Param("name")String name,@Param("selectType")String selectType);

	List<PersonnelWrittenexaminationVO> findPersonnelWrittenexaminationVO(@Param("code")String code,@Param("name") String name,@Param("selectType")String selectType);

	List<PersonnelSelectionscore> findSelectionscoreAll(@Param("personnelId")Integer personnelId,@Param("selectType")String selectType);

	List<PersonnelTgDTO> findExistWrittenexamination(@Param("userId")String code, @Param("name")String name,@Param("userIds")List<String> userIds);

	List<PersonnelWrittenexaminationVO> findPersonnelWrittenexaminationVOexportExcelAll(
			@Param("queryCriteriaDTO")QueryCriteriaDTO queryCriteriaDTO,@Param("rolesMap") Map<String, Object> rolesMap);
	List<PersonnelWrittenexaminationVO> findPersonnelWrittenexaminationVOexportExcelAll1(
			@Param("queryCriteriaDTO")QueryCriteriaDTO queryCriteriaDTO,@Param("rolesMap")
			Map<String, Object> rolesMap);
	List<PersonnelSelectionscore> selectpersonnelWrittenexaminationNewest(@Param("rolesMap") Map<String, Object> rolesMap);

//	List<PersonnelTgDTO> findExistWrittenexaminationAll(@Param("personInfoVO")PersonInfoVO personInfoVO,@Param("userIds")
//			List<String> userIds);
	List<PersonnelTgDTO> findExistWrittenexaminationAll(@Param("personInfoVO")PersonInfoVO personInfoVO,@Param("rolesMap")
	Map<String, Object> rolesMap);

//	Integer deletePersonnelSelectionscore(List<PersonnelSelectionscore> list);

     int delpiliang(@Param("perslId") List<String> perslId,@Param("perstagId") List<String> perstagId,@Param("perselecTypeId") List<String> perselecTypeId);

}

