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<DeviceAdjustValueTiming> getDataByDeviceid(Integer device_id) {
|
List<DeviceAdjustValueTiming> 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<String,Object> 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);
|
}
|
}
|
