package com.huimv.sj.dao;

import com.huimv.busi.sj.dto.SjdlslDTO;
import com.huimv.sj.dataobject.SjHksl;
import com.huimv.sj.dataobject.SjHkslExample;

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

public interface SjHkslDAO {
    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    int countByExample(SjHkslExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    int deleteByExample(SjHkslExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    int deleteByPrimaryKey(Integer id);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    void insert(SjHksl record);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    void insertSelective(SjHksl record);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    List<SjHksl> selectByExample(SjHkslExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    SjHksl selectByPrimaryKey(Integer id);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    int updateByExampleSelective(SjHksl record, SjHkslExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    int updateByExample(SjHksl record, SjHkslExample example);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    int updateByPrimaryKeySelective(SjHksl record);

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_hk_sl
     *
     * @ibatorgenerated Wed Sep 27 10:16:50 CST 2017
     */
    int updateByPrimaryKey(SjHksl record);
    
    /**
	 * 插入环控水量
	 */
	public void insertHkslByParam(List<SjHksl> paramMapList);
	
	/**
     * 根据参数查询全程
     * @param searchParam
     * @return
     */
    public List<SjHksl> selectQcslByParam(Map<String, Object> searchParam);
	
    /**
     * 根据参数查询当天
     * @param searchParam
     * @return
     */
	public List<SjHksl> selectDqslByParam(Map<String, Object> searchParam);
	
	/**
	 * 根据参数查询传感器
	 * @param searchParam
	 * @return
	 */
	public List<SjHksl> selectHkslCgqidByParam(Map<String, Object> searchParam);
	/**
	 * 获取每小时耗水量
	 * @param searchParam
	 * @return
	 */
	public List<SjdlslDTO> selectHkslEveryhourByParam(Map<String, Object> searchParam);
	/**
	 * 根据栏期ID 和 查询的时间获取 某天最大最小的水量 即某天内的消耗量
	 * @param lqid cjsj
	 * @return
	 */
	public List<SjdlslDTO> selectSlMaxMinByParam(Map<String, Object> searchParam);
	
	/**
	 * 根据栏期ID 和 查询的时间获取 某天最大最小的电量 即某天内的消耗量
	 * @param lqid cjsj
	 * @return
	 */
	public List<SjdlslDTO> selectJrdlMaxMinByParam(Map<String, Object> searchParam);
}