根据楼层入库出库

zyx

2024-04-24 9d2d63ee09e8bcf494fc3fd14a48d82731fac9ef

 src/main/java/com/zy/asrs/mapper/AgvBasDevpMapper.java

@@ -33,8 +33,9 @@
            "WHERE\n" +
            "\tagv_wrk_mast.loc_no IS NULL \n" +
            "\tAND agv_bas_devp.loc_type1 = #{locType} \n" +
            "\tAND agv_bas_devp.floor = #{floor} \n" +
            "\tAND agv_bas_devp.out_enable = 'Y'")
    List<String> selectCacheShelvesStationCodeByLocType(@Param("locType") Short locType);
    List<String> selectCacheShelvesStationCodeByLocType(@Param("locType") Short locType, @Param("floor") int floor);

    @Select("SELECT\n" +
            "\tbas.dev_no,\n" +