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