zy-asrs.git - Gitblit

			@@ -8,6 +8,7 @@
			import org.apache.ibatis.annotations.Update;
			import org.springframework.stereotype.Repository;

			import java.util.Date;
			import java.util.List;

			@Mapper
			@@ -39,4 +40,10 @@
			@Select("SELECT plt_type FROM asr_wrk_mast WHERE io_type = 101 AND plt_type IS NOT NULL AND plt_type > 0 AND user_no = #{userNo} AND ((#{batchSeq} IS NULL AND batch_seq IS NULL) OR batch_seq = #{batchSeq})")
			List<Integer> listOutboundPltTypesByUserNo(@Param("userNo") String userNo, @Param("batchSeq") String batchSeq);

			@Select("SELECT MIN(ISNULL(appe_time, io_time)) FROM asr_wrk_mast WHERE train_no = #{trainNo} AND io_type < 100")
			Date selectFirstInboundCreateTimeByTrainNo(@Param("trainNo") String trainNo);

			@Select("SELECT wrk_no FROM asr_wrk_mast WHERE train_no = #{trainNo} AND io_type < 100 AND wrk_sts = 5")
			List<Integer> listFinishedInboundWrkNosByTrainNo(@Param("trainNo") String trainNo);

			}