From 1ced120d93b025164e8a22374dfa09acdb2afb32 Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@63.com> Date: 星期六, 12 三月 2022 10:50:50 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/service/BasSteService.java | 4 +++- src/main/java/com/zy/asrs/mapper/BasSteMapper.java | 3 +++ src/main/java/com/zy/asrs/service/impl/BasSteServiceImpl.java | 5 +++++ src/main/resources/mapper/BasSteMapper.xml | 6 ++++++ 4 files changed, 17 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/BasSteMapper.java b/src/main/java/com/zy/asrs/mapper/BasSteMapper.java index 02615a9..f26536e 100644 --- a/src/main/java/com/zy/asrs/mapper/BasSteMapper.java +++ b/src/main/java/com/zy/asrs/mapper/BasSteMapper.java @@ -3,10 +3,13 @@ import com.zy.asrs.entity.BasSte; import com.baomidou.mybatisplus.mapper.BaseMapper; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; @Mapper @Repository public interface BasSteMapper extends BaseMapper<BasSte> { + int updatePos(@Param("row")Integer row, @Param("bay")Integer bay, @Param("lev")Integer lev); + } diff --git a/src/main/java/com/zy/asrs/service/BasSteService.java b/src/main/java/com/zy/asrs/service/BasSteService.java index 922d967..bd599d0 100644 --- a/src/main/java/com/zy/asrs/service/BasSteService.java +++ b/src/main/java/com/zy/asrs/service/BasSteService.java @@ -1,10 +1,12 @@ package com.zy.asrs.service; -import com.zy.asrs.entity.BasSte; import com.baomidou.mybatisplus.service.IService; +import com.zy.asrs.entity.BasSte; public interface BasSteService extends IService<BasSte> { BasSte findByCrnNo(Integer crnNo); + int updatePos(Integer row, Integer bay, Integer lev); + } diff --git a/src/main/java/com/zy/asrs/service/impl/BasSteServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/BasSteServiceImpl.java index 5faf24b..240ba59 100644 --- a/src/main/java/com/zy/asrs/service/impl/BasSteServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/BasSteServiceImpl.java @@ -27,4 +27,9 @@ return basStes.get(0); } + @Override + public int updatePos(Integer row, Integer bay, Integer lev) { + return this.baseMapper.updatePos(row, bay, lev); + } + } diff --git a/src/main/resources/mapper/BasSteMapper.xml b/src/main/resources/mapper/BasSteMapper.xml index d445c94..f89586a 100644 --- a/src/main/resources/mapper/BasSteMapper.xml +++ b/src/main/resources/mapper/BasSteMapper.xml @@ -28,4 +28,10 @@ </resultMap> + <update id="updatePos"> + update asr_bas_ste + set his_row = row, his_bay = bay,his_lev = lev, + row = #{row}, bay = #{bay}, lev = #{lev} + </update> + </mapper> -- Gitblit v1.9.1