潘钊 / bsth_control · Files

package com.bsth.repository;

import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.bsth.entity.Cars;

@Repository
public interface CarsRepository extends BaseRepository<Cars, Integer>{

	@Query(value="select s from Cars s where s.id in(select e.cl.id from CarConfigInfo e where e.xl.id = ?1) ")
	List<Cars> findCarsByLineId(Integer lineId);
	
	@Query(value="select s from Cars s")
	List<Cars> findCars();
	
	@Query(value="select s from Cars s where s.insideCode=?1")
	List<Cars> findCarsByCode(String insideCode);

	@Modifying
	@Query(value = "UPDATE Cars s set s.businessCode=?1 , s.company=?2, s.brancheCompany=?3,  s.brancheCompanyCode=?4, "
			+ "s.carCode=?5, s.carPlate=?6, s.supplierName=?7, s.equipmentCode=?8, s.carClass=?9, s.carSeatnNumber=?10,"
			+ "s.carStandard=?11, s.scrapCode=?12, s.scrapDate=?13, s.makeCodeOne=?14, s.makeCodeTwo=?15, s.engineCodeOne=?16,"
			+ "s.engineCodeTwo=?17, s.carType=?18, s.sfdc=?19, s.descriptions=?20, s.scrapState=?21 "
			+ "where s.insideCode=?22")
	int update(String businessCode, String company, String brancheCompany, String brancheCompanyCode,
			   String carCode, String carPlate, String supplierName, String equipmentCode, String carClass, Integer carSeatnNumber,
			   String carStandard, String scrapCode, Date scrapDate, String makeCodeOne, String makeCodeTwo, String engineCodeOne,
			   String engineCodeTwo, String carType, Boolean sfdc, String descriptions, Boolean scrapState, String insideCode);
}