From 98ad8b1986704d39693ad61ba3f167013cd2fdf0 Mon Sep 17 00:00:00 2001 From: lsh <1> Date: 星期五, 26 一月 2024 18:40:24 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/WrkMastMapper.java | 13 +++++++++++++ 1 files changed, 13 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java index 8d9e59c..af2c105 100644 --- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java @@ -2,11 +2,24 @@ import com.baomidou.mybatisplus.mapper.BaseMapper; import com.zy.asrs.entity.WrkMast; +import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository; + +import java.util.List; @Mapper @Repository public interface WrkMastMapper extends BaseMapper<WrkMast> { +// @Select("select * from asr_wrk_mast where ((wrk_sts = 4 Or wrk_sts = 14 ) and io_type <> 103 and io_type <> 104 and io_type <> 107 ) or (wrk_sts = 2 and io_type=6) order by upd_mk,io_time,wrk_no") + List<WrkMast> selectToBeCompleteData(); + List<WrkMast> selectToBeCompleteData202(); + + List<WrkMast> selectToBeHistoryData(); + + // work log ------------------------------------------------------- + @Insert("insert into asr_wrk_mast_log select * from asr_wrk_mast where wrk_no=#{workNo}") + int saveWrkMastLog(Integer workNo); + } -- Gitblit v1.9.1