czt
2024-04-21 51a999d87421497bb7bb25e47965f78261f801c3
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);
}