package com.newfiber.api.pc.dao.RiverManage;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.newfiber.api.pc.model.River.PatrolManageLawFile;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * patrolManageLawFile model层
 *
 * @author luzhan
 */
@Repository
public interface PatrolManageLawFileMapper extends BaseMapper<PatrolManageLawFile> {

    @Select("select event_src_name from tc_dic_event_src where event_src_id = #{srcId}")
    String selectEventSrc(@Param("srcId") Integer srcId);

    @Select("select event_level_name from tc_dic_event_level where event_level_id = #{levelId}")
    String selectEventLevel(@Param("levelId") Integer levelId);

    @Select("select type_name from tc_dic_event_any_type where unique_code = #{uniqueCode}")
    String selectEventType(@Param("uniqueCode") Integer uniqueCode);

    /**
     *
     * @param taskNum
     */
    int deleteByTaskNum(@Param("taskNum") String taskNum);
}