From 23ef469c6bd9a1361743cf2e60066c043ad5fa0c Mon Sep 17 00:00:00 2001
From: yxFwq <1>
Date: 星期一, 15 七月 2024 08:40:02 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/mapper/WrkMastExecuteMapper.java |   31 +++++++++++++++++++++++++++++++
 1 files changed, 31 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastExecuteMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastExecuteMapper.java
index 53d39fc..aaf6b64 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkMastExecuteMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkMastExecuteMapper.java
@@ -3,10 +3,41 @@
 import com.zy.asrs.entity.WrkMastExecute;
 import com.baomidou.mybatisplus.mapper.BaseMapper;
 import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
 import org.springframework.stereotype.Repository;
+
+import java.util.List;
 
 @Mapper
 @Repository
 public interface WrkMastExecuteMapper extends BaseMapper<WrkMastExecute> {
 
+    WrkMastExecute getWrkMastExecuteByCharge(@Param("steNo") Integer steNo);
+
+    WrkMastExecute getWrkMastExecuteByWrkNo(@Param("wrkNo") Long wrkNo);
+
+    List<WrkMastExecute> getWrkMastExecuteByWrkNoList(@Param("wrkNo") Long wrkNo);
+
+    List<WrkMastExecute> getWrkMastExecuteByJarNo(@Param("jarId") Integer jarId);
+
+    List<WrkMastExecute> selectWrkMastExecuteByType(@Param("type") Integer type);
+
+    List<WrkMastExecute> selectWrkMastExecuteByTypeAndIoTyperAndWrkType(@Param("type")Integer type,@Param("ioType")Integer ioType,@Param("wrkSts")Integer wrkSts);
+
+    List<WrkMastExecute> selectWrkMastExecuteByWrk(@Param("type")Integer type,@Param("ioType")Integer ioType,
+                                                   @Param("wrkSts")Integer wrkSts,@Param("steNo")Integer steNo,
+                                                   @Param("jarNo")Integer jarNo,@Param("rgvNo")Integer rgvNo);
+
+
+    Integer getWrkMastExecuteByJarIdCount(@Param("jarId") Integer jarId);
+
+    Integer selectNoStart(@Param("jarRegin") Integer jarRegin);
+    Integer selectNoStartCharge(@Param("jarRegin") Integer jarRegin);
+
+    Integer selectMoveStart(@Param("jarRegin") Integer jarRegin);
+
+    Integer selectMoveStartCharge(@Param("jarRegin") Integer jarRegin);
+
+    WrkMastExecute selectStart(@Param("jarRegin") Integer jarRegin);
+
 }

--
Gitblit v1.9.1