#优化

lsh

2024-08-21 6d2fa862707301c65b14a383ff8623938afbd76b

#优化

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

@@ -44,6 +44,8 @@
    //找单品类型，最内侧空库位
    List<LocMast> findInEmptyLocMast(Short locType1, @Param("rows") List<Integer> rows, Integer crnNo);

    List<LocMast> findInEmptyLocMastNew(Short locType1, @Param("locNos") List<String> locNos, Integer crnNo);

    //在库位组中搜索可入的空库位
    List<LocMast> findEmptyLocMastByLocNos(Short locType1, @Param("locNos") List<String> locNos, Integer crnNo);


 src/main/java/com/zy/asrs/service/LocMastService.java

@@ -68,6 +68,8 @@
    //找单品类型，最内侧空库位
    List<LocMast> findInEmptyLocMast(Short locType1, List<Integer> rows, Integer crnNo);

    List<LocMast> findInEmptyLocMastNew(Short locType1, List<String> locNos, Integer crnNo);

    //在库位组中搜索可入的空库位
    List<LocMast> findEmptyLocMastByLocNos(Short locType1, List<String> locNos, Integer crnNo);


 src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java

@@ -234,6 +234,11 @@
    }

    @Override
    public List<LocMast> findInEmptyLocMastNew(Short locType1, List<String> locNos, Integer crnNo) {
        return this.baseMapper.findInEmptyLocMastNew(locType1, locNos, crnNo);
    }

    @Override
    public List<LocMast> findEmptyLocMastByLocNos(Short locType1, List<String> locNos, Integer crnNo) {
        return this.baseMapper.findEmptyLocMastByLocNos(locType1, locNos, crnNo);
    }

 src/main/resources/mapper/LocMastMapper.xml

@@ -308,6 +308,19 @@
        order by bay1,lev1,row1
    </select>

    <select id="findInEmptyLocMastNew" resultMap="BaseResultMap">
        select * from asr_loc_mast
        where loc_type2 = 1
        and loc_type1 = #{locType1}
        and loc_no in
        <foreach item="item" collection="locNos" index="index"  separator="," open="(" close=")">
            #{item}
        </foreach>
        and loc_sts = 'O'
        and crn_no = #{crnNo}
        order by bay1,lev1,row1
    </select>

    <select id="findEmptyLocMastByLocNos" resultMap="BaseResultMap">
        select * from asr_loc_mast
        where loc_type2 = 1