游瑞烽 / personnel_update · Files

package com.bsth.repository;

import com.bsth.entity.PersonnelCopy;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface PersonnelCopyRepository extends PagingAndSortingRepository<PersonnelCopy, Long> {
	
//	@Query(value="select s from Personnel s where s.id in(select e.jsy.id from EmployeeConfigInfo e where e.xl.id = ?1) ")
//    List<Personnel> findJsysByLineId(Integer lineId);
//
//	@Query(value="select s from Personnel s where s.id in(select e.spy.id from EmployeeConfigInfo e where e.xl.id = ?1) ")
//    List<Personnel> findSpysByLineId(Integer lineId);

//    @Query(value="select s from Personnel s ")
//    List<Personnel> findAll();

}