package com.dy.pipIrrGlobal.daoRm;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.dy.pipIrrGlobal.pojoRm.RmLossDayLast;
|
import com.dy.pipIrrGlobal.voRm.VoLossDay;
|
import com.dy.pipIrrGlobal.voSt.VoDayLoss;
|
import com.dy.pipIrrGlobal.voSt.VoMonthAmount;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Author liurunyu
|
* @Date 2024/2/28 15:31
|
* @LastEditTime 2024/2/28 15:31
|
* @Description
|
*/
|
@Mapper
|
public interface RmLossDayLastMapper extends BaseMapper<RmLossDayLast> {
|
/**
|
* delete by primary key
|
* @param id primaryKey
|
* @return deleteCount
|
*/
|
int deleteByPrimaryKey(Long id);
|
|
/**
|
* insert record to table
|
* @param record the record
|
* @return insert count
|
*/
|
int insert(RmLossDayLast record);
|
|
/**
|
* insert record to table selective
|
* @param record the record
|
* @return insert count
|
*/
|
int insertSelective(RmLossDayLast record);
|
|
/**
|
* select by primary key
|
* @param id primary key
|
* @return object by primary key
|
*/
|
RmLossDayLast selectByPrimaryKey(Long id);
|
|
/**
|
* select by rtuAddr
|
* @param intakeId 控制器所绑取水口ID
|
* @return object by rtuAddr
|
*/
|
List<RmLossDayLast> selectByIntakeId(Long intakeId) ;
|
/**
|
* select by dt
|
* @param date 日期(yyyy-mm-dd)
|
* @return object by rtuAddr
|
*/
|
List<RmLossDayLast> selectByDate(Date date) ;
|
|
/**
|
* update record selective
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKeySelective(RmLossDayLast record);
|
|
/**
|
* update record
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKey(RmLossDayLast record);
|
|
/**
|
* 根据指定条件获取记录总数
|
* @param params
|
* @return
|
*/
|
Long getRecordCount(Map<?, ?> params);
|
|
/**
|
* 根据指定条件获取记录
|
* @param params
|
* @return
|
*/
|
List<VoLossDay> getLossDayLast(Map<?, ?> params);
|
|
/**
|
* 统计指定月份各天漏损量记录数量
|
* @param params
|
* @return
|
*/
|
Long getDayLossAmountCount(Map<?, ?> params);
|
|
/**
|
* 统计指定月份各天漏损量
|
* @param params
|
* @return
|
*/
|
List<VoDayLoss> getDayLossAmount(Map<?, ?> params);
|
|
/**
|
* 统计指定年份各月漏损量记录数量
|
* @param params
|
* @return
|
*/
|
Long getMonthLossAmountCount(Map<?, ?> params);
|
|
/**
|
* 统计指定年份各月漏损量
|
* @param params
|
* @return
|
*/
|
List<VoMonthAmount> getMonthLossAmount(Map<?, ?> params);
|
|
}
|