package com.whyc.service;
|
|
import com.whyc.mapper.BattStationTempHisMapper;
|
import com.whyc.mapper.CommonMapper;
|
import com.whyc.pojo.db_power_history.BattStationTempHistory;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
|
@Service
|
public class BattStationTempHisService {
|
|
@Resource
|
private BattStationTempHisMapper mapper;
|
|
@Resource
|
private CommonMapper commonMapper;
|
|
@Autowired
|
private JdbcSqlExecuteService jdbcSqlExecuteService;
|
|
public void createTableByMonth(Integer battGroupId,String yearMonth) {
|
jdbcSqlExecuteService.execute("CREATE TABLE IF NOT EXISTS `db_power_history`.`db_batt_station_temp_history_"+yearMonth+"` LIKE `db_power_history`.`db_batt_station_temp_history`");
|
}
|
|
public boolean existTempHisTableByMonth(Integer battGroupId, String yearMonth) {
|
return commonMapper.existTable("db_power_history","db_batt_station_temp_history_"+battGroupId+"_"+yearMonth);
|
}
|
|
public void add(Integer battGroupId, String yearMonth, BattStationTempHistory tempHistory) {
|
jdbcSqlExecuteService.execute("INSERT INTO `db_power_history`.`db_batt_station_temp_history_"+battGroupId+"_"+yearMonth+"` (`batt_group_id`, `station_id`, `pixel_x`, `pixel_y`, `max_temp`, `min_temp`, `min_temp_point`, `max_temp_point`, `camera_id`, `record_time`)" +
|
"\n values("+tempHistory.getBattGroupId()+","+tempHistory.getStationId()+","+tempHistory.getPixelX()+","+tempHistory.getPixelY()+","+tempHistory.getMaxTemp()+","+tempHistory.getMinTemp()+",'"+tempHistory.getMinTempPoint()+"','"+tempHistory.getMaxTempPoint()+"','"+tempHistory.getCameraId()+"','"+tempHistory.getRecordTime());
|
}
|
}
|
