#

luxiaotao1123

2022-04-09 6b416a0c1132a6a6ae802b768b1333de3cba136b

#

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

@@ -3,8 +3,10 @@
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.WrkDetl;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

@Mapper
@@ -13,4 +15,6 @@

    List<WrkDetl> findByWorkNo(Integer workNo);

    int updateIoTime(@Param("workNo") Integer workNo, @Param("ioTime") Date ioTime);

}

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

@@ -4,6 +4,7 @@
import com.zy.asrs.entity.WaitPakin;
import com.zy.asrs.entity.WrkDetl;

import java.util.Date;
import java.util.List;

public interface WrkDetlService extends IService<WrkDetl> {
@@ -12,4 +13,6 @@

    List<WrkDetl> findByWorkNo(Integer workNo);

    boolean updateIoTime(Integer workNo, Date ioTime);

}

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

@@ -407,19 +407,23 @@
                            throw new CoolException("保存工作主档历史档失败");
                        }

                        Date now = new Date();
                        // 堆垛机站点(目标站)
                        Integer staNo = staDesc.getCrnStn();
                        // 更新工作档数据状态
                        wrkMast.setIoTime(now);
                        wrkMast.setIoType(wrkMast.getIoType() - 50); // 入出库类型: 103->53,104->54,107->57
                        wrkMast.setWrkSts(2L); // 工作状态: 2.设备上走
                        wrkMast.setSourceStaNo(wrkMast.getStaNo()); // 源站
                        wrkMast.setStaNo(staNo); // 目标站
                        wrkMast.setLocNo(wrkMast.getSourceLocNo()); // 目标库位 = 出库时的源库位
                        wrkMast.setSourceLocNo(""); // 源库位清空
                        wrkMast.setModiTime(new Date());
                        wrkMast.setModiTime(now);
                        if (wrkMastMapper.updateById(wrkMast) == 0) {
                            throw new CoolException("更新工作档数据状态失败");
                        }
                        // 更新明细档io_time (历史档关联使用）
                        wrkDetlService.updateIoTime(wrkMast.getWrkNo(), now);
                        // 修改库位状态 Q.拣料/盘点/并板再入库
                        LocMast locMast = locMastService.selectById(wrkMast.getLocNo());
                        locMast.setLocSts("Q");

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

@@ -53,4 +53,9 @@
        return this.baseMapper.findByWorkNo(workNo);
    }

    @Override
    public boolean updateIoTime(Integer workNo, Date ioTime) {
        return this.baseMapper.updateIoTime(workNo, ioTime) > 0;
    }

}

 src/main/resources/mapper/WrkDetlMapper.xml

@@ -30,4 +30,11 @@
        select wrk_no, mat_no, mat_name, qty from asr_wrk_detl where 1=1 and wrk_no = #{workNo}
    </select>

    <update id="updateIoTime">
        update asr_wrk_detl
        set io_time = #{ioTime}
        where 1=1
        and wrk_no = #{workNo}
    </update>

</mapper>