捡料

Junjie

2023-07-25 e06fb82148aefd34c137529213d6fef3ab498c58

捡料

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

@@ -64,4 +64,6 @@
    List<WrkMast> selectInOutWrkMast();//查询出入库工作档

    List<WrkMast> selectLocToLocWrkMast();//查询库位移转工作档

    WrkMast selectPickStepByBarcode(String barcode);
}

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

@@ -200,9 +200,9 @@
                    }

                    // 过滤盘点/拣料/并板任务
//                    if (null != wrkMastMapper.selectPickStepByBarcode(barcode)) {
//                        continue;
//                    }
                    if (null != wrkMastMapper.selectPickStepByBarcode(barcode)) {
                        continue;
                    }

                    // 判断重复工作档
//                    WrkMast wrkMast = wrkMastMapper.selectPakInStep1(inSta.getStaNo(), barcode);

 src/main/resources/mapper/WrkMastMapper.xml

@@ -178,4 +178,11 @@
        order by io_pri desc,wrk_sts desc
    </select>

    <select id="selectPickStepByBarcode" resultMap="BaseResultMap">
        select top 1 * from asr_wrk_mast
        where io_type in (53)
        and wrk_sts in (2)
        and barcode = #{barcode}
        order by io_pri desc,wrk_sts desc
    </select>
</mapper>