| | |
| | | wrapper_VSU.eq("is_delete",0); |
| | | wrapper_VSU.eq("dataKey",sensor.getDefaultUnitKey()); |
| | | wrapper_VSU.eq("dict_type_id",14); |
| | | Map<String,Object> defaultUnitMap = new HashMap<>(); |
| | | defaultUnitMap.put(sensor.getDefaultUnitKey(),sysDictDataMapper.selectOne(wrapper_VSU).getDataValue()); |
| | | sensorMap.put("default_unit_key",defaultUnitMap); |
| | | sensorMap.put("default_unit_key",sysDictDataMapper.selectOne(wrapper_VSU).getDataValue()); |
| | | } |
| | | sensorList.add(sensorMap); |
| | | } |
| | |
| | | wrapper_VSU.eq("is_delete",0); |
| | | wrapper_VSU.eq("dataKey",sensor.getDefaultUnitKey()); |
| | | wrapper_VSU.eq("dict_type_id",14); |
| | | Map<String,Object> defaultUnitMap = new HashMap<>(); |
| | | defaultUnitMap.put(sensor.getDefaultUnitKey(),sysDictDataMapper.selectOne(wrapper_VSU).getDataValue()); |
| | | sensorMap.put("default_unit_key",defaultUnitMap); |
| | | sensorMap.put("default_unit_key",sysDictDataMapper.selectOne(wrapper_VSU).getDataValue()); |
| | | } |
| | | sensorList.add(sensorMap); |
| | | } |
| | |
| | | |
| | | |
| | | <sql id="Base_Column_List"> |
| | | mm.id,mm.name,mm.url,mm.icon,mm.parent_id,mm.order,mm.create_time,mm.update_time,mm.is_delete |
| | | mm.id,mm.name,mm.url,mm.icon,mm.parent_id,mm.order,mm.create_time,mm.update_time,mm.is_delete,mm.desc |
| | | </sql> |
| | | |
| | | |
| | |
| | | <if test="order != null"> |
| | | `order`, |
| | | </if> |
| | | <if test="desc != null"> |
| | | `desc`, |
| | | </if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="name != null"> |
| | |
| | | </if> |
| | | <if test="order != null"> |
| | | #{order}, |
| | | </if> |
| | | <if test="desc != null"> |
| | | #{desc}, |
| | | </if> |
| | | </trim> |
| | | </insert> |
| | |
| | | </if> |
| | | <if test="is_delete != null"> |
| | | is_delete = #{is_delete}, |
| | | </if> |
| | | <if test="desc != null"> |
| | | `desc` = #{desc}, |
| | | </if> |
| | | </set> |
| | | where id = #{id} |
| | |
| | | <if test="order != null"> |
| | | and mm.order = #{order} |
| | | </if> |
| | | <if test="desc != null"> |
| | | and mm.desc = #{order} |
| | | </if> |
| | | limit #{start},#{number} |
| | | </select> |
| | | |