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.entity.Horizontal;
|
import com.northglass.entity.ShelfTask;
|
|
public interface HorizontalDao extends JpaRepository<Horizontal, Long>{
|
|
|
@Query("select t from Horizontal t where t.gourp=?1 and t.slicecageRank=?2 ")
|
public Horizontal findbygroup(Long groups,String slicecageRank);
|
|
@Query("select t from Horizontal t where t.id=?1 ")
|
public Horizontal findById(long id);
|
|
@Query("select count(t) from Horizontal t where t.gourp=?1 and t.state='使用中' or t.state='出库中' or t.state='进库中'")
|
public int findfall2(Long groups);
|
|
@Query(nativeQuery=true,value="select count(*) from gmms_horizontal 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);
|
}
|
