screen-manage 根据型号id获取因子添加code字段

kaiyu

2021-06-11 61161b5b9f5b07e83dab7d5c03ae9ce9766bb663

screen-manage
                  根据型号id获取因子添加code字段

 screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java

@@ -92,6 +92,7 @@
        vo.setUpper(sensor.getUpper());
        vo.setLower(sensor.getLower());
        vo.setUnitKey(sensor.getUnitKey());
        vo.setCode(sensor.getCode());
        return vo;
    }
}

 screen-manage/src/main/resources/mapper/VersionMapper.xml

@@ -23,6 +23,7 @@
            <id property="id" column="sid"></id>
            <result property="name" column="sname"></result>
            <result property="unitKey" column="dataKey"></result>
            <result property="code" column="code"></result>
            <result property="unit" column="dataValue"></result>
            <result property="upper" column="vupper"></result>
            <result property="lower" column="vlower"></result>
@@ -31,7 +32,7 @@

    <select id="queryVersionsAndSensorUnitByIds" resultMap="VersionSensorUnitMap">
    SELECT
      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.`upper` AS vupper ,vsu.`lower` AS vlower
      v.`id`,v.`name`,v.`desc`,v.`create_time`,v.`update_time`,s.`id` AS sid,s.`name` AS sname ,s.`code`,u.dataKey,u.dataValue,vsu.`upper` AS vupper ,vsu.`lower` AS vlower
    FROM
      `version` v
    LEFT JOIN