package com.dy.pipIrrGlobal.daoRm;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseValveLast;
|
import com.dy.pipIrrGlobal.voRm.VoOpenCloseValve;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Author: liurunyu
|
* @Date: 2024/7/1 15:29
|
* @Description
|
*/
|
@Mapper
|
public interface RmOpenCloseValveLastMapper extends BaseMapper<RmOpenCloseValveLast> {
|
/**
|
* 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(RmOpenCloseValveLast record);
|
|
/**
|
* insert record to table selective
|
*
|
* @param record the record
|
* @return insert count
|
*/
|
int insertSelective(RmOpenCloseValveLast record);
|
|
/**
|
* select by primary key
|
*
|
* @param id primary key
|
* @return object by primary key
|
*/
|
RmOpenCloseValveLast selectByPrimaryKey(Long id);
|
|
/**
|
* update record selective
|
*
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKeySelective(RmOpenCloseValveLast record);
|
|
/**
|
* update record
|
*
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKey(RmOpenCloseValveLast record);
|
|
/**
|
* select by rtuAddr
|
*
|
* @param intakeId intakeId
|
* @return object by rtuAddr
|
*/
|
List<RmOpenCloseValveLast> selectByIntakeId(Long intakeId);
|
|
/**
|
* 根据指定条件获取开关阀报最新记录数量
|
* @param params
|
* @return
|
*/
|
Long getOpenCloseValveReportsCount_last(Map<?, ?> params);
|
|
/**
|
* 根据指定条件获取开关阀报最新记录
|
* @param params
|
* @return
|
*/
|
List<VoOpenCloseValve> getOpenCloseValveReports_last(Map<?, ?> params);
|
|
/**
|
* 根据开阀类型获取操作次数
|
* @param params
|
* @return
|
*/
|
Integer getCountByOpenType(Map<?, ?> params);
|
|
/**
|
* 根据关阀类型获取操作次数
|
* @param params
|
* @return
|
*/
|
Integer getCountByCloseType(Map<?, ?> params);
|
|
/**
|
* 为指定（阀控器地址、水卡编号、无关阀记录）开关阀最新记录添加关阀时间，使之不在未关阀记录中显示
|
* @param rtuAddr
|
* @param icCardNo
|
* @return
|
*/
|
Integer addCloseTime(@Param("rtuAddr") String rtuAddr, @Param("icCardNo")String icCardNo);
|
}
|
