From 6cbb420754e6e29fa134a6afca4514b8dfd62918 Mon Sep 17 00:00:00 2001
From: vincentlu <t1341870251@gmail.com>
Date: 星期二, 13 一月 2026 16:14:49 +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