| | |
|---|
| | | "'${ipAddress}', ${port}, '${password}', ${PTZType}, ${status})") |
|---|
| | | int add(DeviceChannel channel); |
|---|
| | | |
|---|
| | | // @Update("UPDATE device_channel " + |
|---|
| | | // "SET name=#{name}, manufacture=#{manufacture}, model=#{model}, owner=#{owner}, civilCode=#{civilCode}, " + |
|---|
| | | // "block=#{block}, address=#{address}, parental=#{parental}, parentId=#{parentId}, safetyWay=#{safetyWay}, " + |
|---|
| | | // "registerWay=#{registerWay}, certNum=#{certNum}, certifiable=#{certifiable}, errCode=#{errCode}, secrecy=#{secrecy}, " + |
|---|
| | | // "ipAddress=#{ipAddress}, port=#{port}, password=#{password}, PTZType=#{PTZType}, status=#{status}, streamId=#{streamId}, " + |
|---|
| | | // "hasAudio=#{hasAudio}" + |
|---|
| | | // "WHERE deviceId=#{deviceId} AND channelId=#{channelId}") |
|---|
| | | |
|---|
| | | |
|---|
| | | @Update(value = {" <script>" + |
|---|
| | | "UPDATE device_channel " + |
|---|
| | | "SET deviceId='${deviceId}'" + |
|---|
| | |
|---|
| | | " WHERE 1=1 " + |
|---|
| | | " <if test=\"hasSubChannel == true\" > AND subCount >0</if>" + |
|---|
| | | " <if test=\"hasSubChannel == false\" > AND subCount=0</if>" + |
|---|
| | | " ORDER BY channelId ASC" + |
|---|
| | | " </script>"}) |
|---|
| | | List<DeviceChannel> queryChannelsByDeviceId(String deviceId, String parentChannelId, String query, Boolean hasSubChannel, Boolean online); |
|---|
| | | |
|---|
