package com.northglass.repository;
|
|
import java.util.List;
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.constants.StateConstants.ManufactureBatchState;
|
import com.northglass.constants.StateConstants.TaskState;
|
import com.northglass.entity.CardNumber;
|
|
public interface CardNumberDao extends JpaRepository<CardNumber, Long> {
|
|
@Query("select c from CardNumber c where c.state = '" + ManufactureBatchState.WAITING + "'")
|
public List<CardNumber> findByWaiting();
|
|
@Query("select c from CardNumber c where c.state = '" + ManufactureBatchState.IN_WORK + "'")
|
public CardNumber findByWorking();
|
|
// @Query("select c from CardNumber c where c.state = '" + TaskState.WAITING_COMPLETED + "'")
|
// public CardNumber findByWC();
|
//临时
|
@Query("select c from CardNumber c where c.state = '" + TaskState.IN_WORK + "'")
|
public CardNumber findByWC();
|
|
@Query("select c from CardNumber c where c.state = '" + ManufactureBatchState.COMPLETED + "'")
|
public List<CardNumber> findBycompleted();
|
|
@Query("select c from CardNumber c where c.number=?1")
|
public CardNumber findByApart(String number);
|
}
|
