package cn.estsh.i3plus.pojo.wms.repository;

import cn.estsh.i3plus.pojo.base.jpa.dao.BaseRepository;
import cn.estsh.i3plus.pojo.wms.bean.WmsIbCheckPlan;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.Date;
import java.util.List;

/**
 * @Description : 抽点比例表
 * @Reference :1
 * @Author : jimmy.zeng
 * @CreateDate : 2018-11-07 11:17
 * @Modify:
 **/
public interface WmsIbCheckPlanRepository extends BaseRepository<WmsIbCheckPlan, Long> {

   /* @Query("select icp from WmsIbCheckPlan icp where icp.partNo =:partNo and icp.organizeCode=:organizeCode and  icp.startDate<=:date and icp.endDate>=:date")
    List<WmsIbCheckPlan> findWmsIbCheckPlanByPartNoAndTime(@Param("partNo") String partNo, @Param("organizeCode") String organizeCode, @Param("date") String date);
*/
}
