| | |
| | | import org.springframework.data.jpa.repository.Query; |
| | | import org.springframework.data.repository.query.Param; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | */ |
| | | public interface Fzzy40Sync1108Rep extends JpaRepository<Fz40Drug, String> { |
| | | |
| | | @Query("from Fz40Drug where deptId=:deptId order by id") |
| | | List<Fz40Drug> listDrug(@Param("deptId") String deptId); |
| | | @Query("from Fz40Drug where deptId=:deptId and updateTime >=:start and updateTime <:end order by updateTime ") |
| | | List<Fz40Drug> listDrug(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); |
| | | } |