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