package com.gyee.frame.mapper.auto;

import com.gyee.frame.model.auto.RecommenmainMsSql;
import com.gyee.frame.model.auto.RecommenmainMsSqlExample;
import com.gyee.frame.model.custom.SimpleVo;
import com.gyee.frame.model.custom.WoBugEqVo;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

public interface RecommenmainMsSqlMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    long countByExample(RecommenmainMsSqlExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    int deleteByExample(RecommenmainMsSqlExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    int deleteByPrimaryKey(String rid);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    int insert(RecommenmainMsSql record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    int insertSelective(RecommenmainMsSql record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    List<RecommenmainMsSql> selectByExample(RecommenmainMsSqlExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    RecommenmainMsSql selectByPrimaryKey(String rid);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    int updateByExampleSelective(@Param("record") RecommenmainMsSql record, @Param("example") RecommenmainMsSqlExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    int updateByExample(@Param("record") RecommenmainMsSql record, @Param("example") RecommenmainMsSqlExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    int updateByPrimaryKeySelective(RecommenmainMsSql record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table RECOMMENMAIN
     *
     * @mbg.generated
     */
    int updateByPrimaryKey(RecommenmainMsSql record);

    List<WoBugEqVo> unfinishedList(@Param("wpId") String wpId, @Param("wtId") String wtId, @Param("beginDate") Date beginDate, @Param("endDate") Date endDate);
    List<WoBugEqVo> finishedList(@Param("wpId") String wpId, @Param("wtId") String wtId, @Param("beginDate") Date beginDate, @Param("endDate") Date endDate);


    List<SimpleVo> totalList(@Param("wpId") String wpId,@Param("wtId") String wtId, @Param("beginDate") Date beginDate, @Param("endDate") Date endDate);

}