From 94e4a7598d2ed0bee320174bcd44a3844d59cc0d Mon Sep 17 00:00:00 2001 From: LSH Date: 星期三, 27 十二月 2023 19:25:00 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/LocCheckMapper.java | 22 ++++++++++++++++++++++ 1 files changed, 22 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/LocCheckMapper.java b/src/main/java/com/zy/asrs/mapper/LocCheckMapper.java index 226f138..9917cca 100644 --- a/src/main/java/com/zy/asrs/mapper/LocCheckMapper.java +++ b/src/main/java/com/zy/asrs/mapper/LocCheckMapper.java @@ -2,11 +2,33 @@ import com.zy.asrs.entity.LocCheck; import com.baomidou.mybatisplus.mapper.BaseMapper; +import com.zy.asrs.entity.LocOwner; +import com.zy.asrs.entity.ManLocDetl; +import org.apache.ibatis.annotations.Delete; 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 LocCheckMapper extends BaseMapper<LocCheck> { + List<ManLocDetl> getAutoLocDetl(); + + List<ManLocDetl> getCountLocDetl(@Param("count") int count); + + List<ManLocDetl> getMatnrCountLocDetl(@Param("count") int count,@Param("matnr") String matnr); + + List<ManLocDetl> getLocCountLocDetl(@Param("count") int count,@Param("loc_no") String locno); + + @Delete("DELETE FROM man_loc_check") + boolean deleteAll(); + + List<String> getLocCount(); + + List<LocOwner> getOwnerCount(); + + List<ManLocDetl> getOwnerCountLocDetl(int count, String owner); } -- Gitblit v1.9.1