package com.fzzy.async.fzzy35.repository; import com.fzzy.async.fzzy35.entity.Fz35DrugLog; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; import java.util.Date; import java.util.List; /** * 查询通风作业数据 * * @author chen * @date 2022-09-08 10:42 */ public interface Fzzy35Sync1306Rep extends JpaRepository { /** * 根据时间段查询通风数据 * @param start * @param end * @return */ @Query("from Fz35DrugLog where deptId =:deptId and start >=:start and start <:end order by start ") List findByReceiveDate(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); }