From d7e7a651810d74e1d0d474090cb9fd78ffd5427b Mon Sep 17 00:00:00 2001
From: kaiyu <404897439@qq.com>
Date: Thu, 27 May 2021 09:09:53 +0800
Subject: [PATCH] screen-manage 更新版本获取因子接口以及分配因子接口
---
screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java | 4 ++--
screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java | 2 +-
screen-manage/src/main/resources/mapper/VersionMapper.xml | 5 ++---
screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java | 2 +-
4 files changed, 6 insertions(+), 7 deletions(-)
diff --git a/screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java b/screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java
index a4432ec..52e0374 100644
--- a/screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java
+++ b/screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java
@@ -36,9 +36,9 @@
private Integer versionId;
/**
- * ������code
+ * ������Id
*/
- private String sensorCode;
+ private Integer sensorId;
/**
* ������������key
diff --git a/screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java b/screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java
index 81d74c7..6e93009 100644
--- a/screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java
+++ b/screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java
@@ -87,7 +87,7 @@
private static SensorVO convertToSensorVO(Sensor sensor) {
SensorVO vo = new SensorVO();
vo.setName(sensor.getName());
- vo.setCode(sensor.getCode());
+ vo.setId(sensor.getId());
vo.setUnit(sensor.getUnit());
vo.setMaxValue(sensor.getMaxValue());
vo.setMinValue(sensor.getMinValue());
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java
index 1632882..ddf3404 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java
@@ -142,7 +142,7 @@
wrapper_Version.eq("sensor_code",oldSensor.getCode());
wrapper_Version.eq("is_delete","0");
VersionSensorUnit versionSensorUnit = new VersionSensorUnit();
- versionSensorUnit.setSensorCode(updateSensorMap.get(key).toString());
+ // versionSensorUnit.setSensorCode(updateSensorMap.get(key).toString());
versionSensorUnitMapper.update(versionSensorUnit,wrapper_Version);
content = content+"������:"+oldSensor.getCode()+"->"+updateSensorMap.get(key)+";";
}
diff --git a/screen-manage/src/main/resources/mapper/VersionMapper.xml b/screen-manage/src/main/resources/mapper/VersionMapper.xml
index b8f5a8b..61a7fc0 100644
--- a/screen-manage/src/main/resources/mapper/VersionMapper.xml
+++ b/screen-manage/src/main/resources/mapper/VersionMapper.xml
@@ -22,7 +22,6 @@
<collection property="sensors" column="id" ofType="com.moral.api.entity.Sensor">
<id property="id" column="sid"></id>
<result property="name" column="sname"></result>
- <result property="code" column="scode"></result>
<result property="unitKey" column="dataKey"></result>
<result property="unit" column="dataValue"></result>
<result property="maxValue" column="max_value"></result>
@@ -32,7 +31,7 @@
<select id="queryVersionsAndSensorUnitByIds" resultMap="VersionSensorUnitMap">
SELECT
- v.`id`,v.`name`,v.`desc`,v.`create_time`,v.`update_time`,s.`id` AS sid,s.`code` as scode,s.`name` AS sname ,u.dataKey,u.dataValue,vsu.`max_value` ,vsu.`min_value`
+ v.`id`,v.`name`,v.`desc`,v.`create_time`,v.`update_time`,s.`id` AS sid,s.`name` AS sname ,u.dataKey,u.dataValue,vsu.`max_value` ,vsu.`min_value`
FROM
`version` v
LEFT JOIN
@@ -42,7 +41,7 @@
LEFT JOIN
sensor s
ON
- s.`code` = vsu.`sensor_code` AND s.`is_delete` = 0
+ s.`id` = vsu.`sensor_id` AND s.`is_delete` = 0
LEFT JOIN
(
SELECT
--
Gitblit v1.8.0