Merge remote-tracking branch 'origin/master'

kaiyu

2020-11-16 cd264145f9b4107f1430da46269dd306d26f3116

 src/main/java/com/moral/service/impl/DeviceAdjustValueTimingServiceImpl.java

New file
@@ -0,0 +1,45 @@
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);
    }
}