From b0d63d1eecb2e0d88dde8fd1a5bf8574b56b9cbb Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@gmail.com>
Date: 星期一, 05 一月 2026 15:10:04 +0800
Subject: [PATCH] #

---
 zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/StaMapper.java |   25 +++++++++++++++++++++++--
 1 files changed, 23 insertions(+), 2 deletions(-)

diff --git a/zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/StaMapper.java b/zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/StaMapper.java
index 842407c..1f05ae9 100644
--- a/zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/StaMapper.java
+++ b/zy-acs-manager/src/main/java/com/zy/acs/manager/manager/mapper/StaMapper.java
@@ -1,8 +1,6 @@
 package com.zy.acs.manager.manager.mapper;
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.baomidou.mybatisplus.core.metadata.IPage;
-import com.zy.acs.manager.manager.controller.param.StaParam;
 import com.zy.acs.manager.manager.entity.Sta;
 import org.apache.ibatis.annotations.Param;
 
@@ -10,4 +8,27 @@
 
 public interface StaMapper extends BaseMapper<Sta> {
 
+    // inbound -------------------
+
+    int tryReserveIn(@Param("staId") Long staId, @Param("qty") Integer qty);
+
+    int releaseReserveIn(@Param("staId") Long staId, @Param("qty") Integer qty);
+
+    int confirmReserveIn(@Param("staId") Long staId, @Param("qty") Integer qty);
+
+    // outbound ------------------
+
+    int tryReserveOut(@Param("staId") Long staId, @Param("qty") Integer qty);
+
+    int releaseReserveOut(@Param("staId") Long staId, @Param("qty") Integer qty);
+
+    int confirmReserveOut(@Param("staId") Long staId, @Param("qty") Integer qty);
+
+
+    // query ------------------
+
+    List<Sta> selectAvailableOutSta(@Param("minAvailableQty") Integer minAvailableQty);
+
+    List<Sta> selectAvailableInSta(@Param("minAvailableQty") Integer minAvailableQty);
+
 }

--
Gitblit v1.9.1