| | |
| | | <result column="baphone" property="baphone"/> |
| | | <result column="deviceName" property="deviceName"/> |
| | | <result column="manufacturers" property="manufacturers"/> |
| | | <result column="xllx" property="xllx"/> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | |
| | | e.manufacturers, |
| | | a.place as place, |
| | | e.channelNumber, |
| | | u.name as baname, |
| | | a.xllx, |
| | | u.real_name as baname, |
| | | u.id as baid, |
| | | u.phone as baphone |
| | | from sys_alarm a |
| | |
| | | and r.routeName like '%${routeName}%' |
| | | </if> |
| | | <if test="id!=null and id!=''"> |
| | | AND d.snumber = #{id} |
| | | AND r.id = #{id} |
| | | </if> |
| | | </select> |
| | | |