package jnpf.tmsMapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import jnpf.tmsEntity.TmsPaperEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
@Mapper
|
public interface TmsPaperMapper extends BaseMapper<TmsPaperEntity> {
|
|
/**
|
* 当年最大试卷编号（含已逻辑删除，避免流水号回退复用）。
|
* 格式：yy + 4 位流水，如 260001。
|
*/
|
@Select("SELECT MAX(paper_no) FROM tms_paper WHERE paper_no LIKE CONCAT(#{prefix}, '%') AND LENGTH(paper_no) = 6")
|
String selectMaxPaperNo(@Param("prefix") String prefix);
|
}
|
