package com.huimv.sj.dao;

import com.huimv.sj.dataobject.SjHkyq;
import com.huimv.sj.dataobject.SjHkyqExample;

import java.util.List;
import java.util.Map;

public interface SjHkyqDAO {
    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    int countByExample(SjHkyqExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    int deleteByExample(SjHkyqExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    int deleteByPrimaryKey(Integer id);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    void insert(SjHkyq record);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    void insertSelective(SjHkyq record);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    List<SjHkyq> selectByExample(SjHkyqExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    SjHkyq selectByPrimaryKey(Integer id);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    int updateByExampleSelective(SjHkyq record, SjHkyqExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    int updateByExample(SjHkyq record, SjHkyqExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    int updateByPrimaryKeySelective(SjHkyq record);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_yq
     *
     * @ibatorgenerated Wed Sep 20 15:18:07 CST 2017
     */
    int updateByPrimaryKey(SjHkyq record);
    
    /**
	 * 插入环控氧气
	 */
	public void insertHkyqByParam(List<SjHkyq> paramMapList);
	
	/**
     * 根据参数查询全程
     * @param searchParam
     * @return
     */
    public List<SjHkyq> selectQcyqByParam(Map<String, Object> searchParam);
	
    /**
     * 根据参数查询当天
     * @param searchParam
     * @return
     */
	public List<SjHkyq> selectDqyqByParam(Map<String, Object> searchParam);
	
	/**
	 * 根据参数查询传感器
	 * @param searchParam
	 * @return
	 */
	public List<SjHkyq> selectHkyqCgqidByParam(Map<String, Object> searchParam);
	
	/**
	 * 根据LQID查询有哪几个表没有数据
	 * list(0) yq 氧气
	 * list(1) eyht 二氧化碳
	 * list(2) lhq 硫化氢
	 * list(3) dl 电量
	 * list(4) sl 水量
	 */
	@SuppressWarnings("rawtypes")
	public String countSnhjButtonByLqid(int lqid);
}