From d131336c24611d905940c19b8a3f69873ffe9c79 Mon Sep 17 00:00:00 2001
From: zhou zhou <3272660260@qq.com>
Date: 星期四, 18 十二月 2025 17:21:41 +0800
Subject: [PATCH] #库存预留
---
src/main/java/com/zy/asrs/mapper/BasStationMapper.java | 20 +++++++++++++++++++-
1 files changed, 19 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/BasStationMapper.java b/src/main/java/com/zy/asrs/mapper/BasStationMapper.java
index 9bb6da0..665c10b 100644
--- a/src/main/java/com/zy/asrs/mapper/BasStationMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/BasStationMapper.java
@@ -1,12 +1,30 @@
package com.zy.asrs.mapper;
-import com.zy.asrs.entity.BasStation;
import com.baomidou.mybatisplus.mapper.BaseMapper;
+import com.zy.asrs.entity.BasStation;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;
+
+import java.util.List;
@Mapper
@Repository
public interface BasStationMapper extends BaseMapper<BasStation> {
+ /**
+ * 鏇存柊搴撲綅鐘舵��
+ */
+ @Update({
+ "<script>",
+ "UPDATE agv_bas_station",
+ "SET loc_sts = #{sts}",
+ "WHERE dev_no IN",
+ "<foreach collection='siteList' item='item' open='(' separator=',' close=')'>",
+ "#{item}",
+ "</foreach>",
+ "</script>"
+ })
+ void updateLocStsBatch(@Param("siteList") List<String> siteList, @Param("sts") String sts);
}
--
Gitblit v1.9.1