#

luxiaotao1123

2021-02-05 b3663287d214d1b8f2ce66c70f10636b00c27805

#

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

@@ -512,6 +512,11 @@
                continue;
            }

            // 已经存在吊车执行任务时，则过滤
            if (wrkMastMapper.selectWorking(slave.getId()) != null) {
                return;
            }

            // 命令下发区 --------------------------------------------------------------------------
            CrnCommand crnCommand = new CrnCommand();
            crnCommand.setCrnNo(slave.getId()); // 堆垛机编号

 src/main/resources/mapper/WrkMastMapper.xml

@@ -116,7 +116,7 @@
    </select>

    <select id="selectWorking" resultMap="BaseResultMap">
        select top 1 * from dbo.asr_wrk_mast where wrk_sts=12 and crn_no=#{crnNo} order by io_time,wrk_no
        select top 1 * from dbo.asr_wrk_mast where 1=1 and (wrk_sts=3 or wrk_sts=12) and crn_no=#{crnNo} order by io_time,wrk_no
    </select>

</mapper>