czt
2024-04-21 86f687fe84d34d9291ed9e5c6ea45e04e11e3be2
src/main/java/com/fzzy/api/view/repository/Api1202Rep.java
@@ -44,4 +44,12 @@
    @Query("from Api1202 where rkjsdh=:rkjsdh ")
    List<Api1202> getDataByRkjsdh(@Param("rkjsdh") String rkjsdh);
    /**
     * 根据货位代码和业务日期,倒序查询
     * @param hwdm
     * @return
     */
    @Query("from Api1202 where hwdm=:hwdm and ywrq <=:keyTime order by ywrq desc")
    List<Api1202> getDataByHwdmAndTime(@Param("hwdm") String hwdm, @Param("keyTime") Date keyTime);
}