package com.casic.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.casic.entity.AlarmJob;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface AlarmJobMapper extends BaseMapper<AlarmJob> {

    @Select("SELECT MAX(jobcode)  " +
            "FROM   alarm_job " +
            "WHERE  JOBCODE like '${jobcode}%'")
    String getJobCodeMaxSerial(@Param("jobcode") String jobcode);

}