package com.chinaitop.depot.intelligent.ventilation.mapper;

import com.chinaitop.depot.intelligent.ventilation.model.TJobApplication;
import com.chinaitop.depot.intelligent.ventilation.model.TJobApplicationAudit;
import com.chinaitop.depot.intelligent.ventilation.model.TJobApplicationExample;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

public interface TJobApplicationMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    int countByExample(TJobApplicationExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    int deleteByExample(TJobApplicationExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    int deleteByPrimaryKey(String id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    int insert(TJobApplication record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    int insertSelective(TJobApplication record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    List<TJobApplication> selectByExample(TJobApplicationExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    TJobApplication selectByPrimaryKey(String id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    int updateByExampleSelective(@Param("record") TJobApplication record, @Param("example") TJobApplicationExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    int updateByExample(@Param("record") TJobApplication record, @Param("example") TJobApplicationExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    int updateByPrimaryKeySelective(TJobApplication record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table t_job_application
     *
     * @mbggenerated Tue Jun 09 10:55:51 CST 2020
     */
    int updateByPrimaryKey(TJobApplication record);
    
    
    List<TJobApplicationAudit> getApprovalList(Map<String, Object> paramMap);

	List<TJobApplication> getJobCtrlList(Map<String, String> map);

	TJobApplication getHouseByNumber(String aerationPlanNumber);
}