Newer
Older
pichan-haerbin / src / main / java / com / casic / dao / GasDataRecvMapper.java
package com.casic.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.casic.entity.LucencyGasData;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

import java.util.Date;

@Mapper
public interface GasDataRecvMapper extends BaseMapper<LucencyGasData> {


    @Update("UPDATE lucency_gas_data " +
            "SET  devcode=#{devcode} " +
            "WHERE imei=#{imei} ")
    Integer updateData(@Param("imei") String imei, @Param("devcode") String devcode);


    @Insert("insert into lucency_gas_data(devcode,tenant_id,device_id,data_value,uptime,imei,logtime,cell)  " +
            "values(#{devcode},#{tenantId},#{deviceId},#{ch4},#{uptime},#{imei},#{logtime},#{cell})  ")
    Integer addData(@Param("devcode") String devcode, @Param("tenantId") String tenantId,
                    @Param("deviceId") String deviceId, @Param("imei") String imei,
                    @Param("uptime") Date time, @Param("ch4") String ch4,
                    @Param("logtime") Date logtime, @Param("cell") String cell);
}