潘钊 / bsth_control · Files

package com.bsth.repository;

import java.util.List;

import com.bsth.entity.Personnel;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

/**
 * Created by xu on 16/6/15.
 */
@Repository
public interface PersonnelRepository extends BaseRepository<Personnel, Integer> {
	
	@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 where s.jobCodeori=?1")
	List<Personnel> findPersonnelByCode(String jobCodeori);

	@Modifying
	@Query(value = "UPDATE Personnel s set s.company=?1 , s.companyCode=?2, s.brancheCompany=?3,  s.brancheCompanyCode=?4, "
			+ "s.personnelName=?5, s.papersCode=?6, s.icCardCode=?7, s.posts=?8, s.card=?9, s.jobCode=?10 "
			+ "where s.jobCodeori=?11")
	int update(String company, String companyCode, String brancheCompany, String brancheCompanyCode,
			   String personnelName, String papersCode, String icCardCode, String posts, String card,String jobCode,
			   String jobCodeori);
}