package com.moral.service.impl; import com.moral.entity.DeviceAdjustValueTiming; import com.moral.mapper.DeviceAdjustValueTimingMapper; import com.moral.service.DeviceAdjustValueTimingService; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; import java.util.List; import java.util.Map; @Service public class DeviceAdjustValueTimingServiceImpl implements DeviceAdjustValueTimingService { @Resource private DeviceAdjustValueTimingMapper deviceAdjustValueTimingMapper; @Override public List getDataByDeviceid(Integer device_id) { List result = deviceAdjustValueTimingMapper.selectAllByDeviceid(device_id); return result; } @Override public void insertData(int device_id, int seconds, String value) { //获取当前时间作为更新时间 DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); LocalDateTime time = LocalDateTime.now(); String nowTime = df.format(time); //先根据device_id查询数据库,看表中是否有相同设备、相同时间的数据 Map deviceAdjustValueTimingMap = deviceAdjustValueTimingMapper.selectAllByDeviceidAndSeconds(device_id,seconds); //判断是否为空,如果为空才可以插入,如果不为空则进行更新 if (deviceAdjustValueTimingMap == null){ deviceAdjustValueTimingMapper.insertData(device_id,seconds,value,nowTime); }else { deviceAdjustValueTimingMapper.upDataByDeviceid(value,nowTime,device_id); } } @Override public int delete(String id) { return deviceAdjustValueTimingMapper.delete(id); } }