package com.northglass.repository;
|
|
import java.util.Date;
|
import java.util.List;
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.entity.GalssTaskDetails;
|
import com.northglass.entity.ShelfTask;
|
import com.northglass.entity.Slicecage;
|
|
public interface SlicecageDao extends JpaRepository<Slicecage, Long>{
|
|
@Query("select t from Slicecage t where t.gourp=?1 ")
|
public List<Slicecage> findfall(Long groups);
|
|
@Query("select count(t) from Slicecage t where t.gourp=?1 and t.state='使用中' ")
|
public int findfall2(Long groups);
|
|
@Query("select t from Slicecage t where t.id=?1 ")
|
public Slicecage findById(long id);
|
|
@Query(nativeQuery=true,value="select count(*) from gmms_slicecage s left join gmms_galss_task gt on gt.processcard_id=s.processcard_id where engineering_id=?1 and s.state='使用中';")
|
public int findfall3(String engineeringid);
|
}
|
