|  |  |  | 
|---|
|  |  |  | "mobilePositionSubmissionInterval," + | 
|---|
|  |  |  | "subscribeCycleForAlarm," + | 
|---|
|  |  |  | "ssrcCheck," + | 
|---|
|  |  |  | "asMessageChannel," + | 
|---|
|  |  |  | "geoCoordSys," + | 
|---|
|  |  |  | "treeType," + | 
|---|
|  |  |  | "online" + | 
|---|
|  |  |  | 
|---|
|  |  |  | "mobilePositionSubmissionInterval," + | 
|---|
|  |  |  | "subscribeCycleForAlarm," + | 
|---|
|  |  |  | "ssrcCheck," + | 
|---|
|  |  |  | "asMessageChannel," + | 
|---|
|  |  |  | "geoCoordSys," + | 
|---|
|  |  |  | "treeType," + | 
|---|
|  |  |  | "online" + | 
|---|
|  |  |  | 
|---|
|  |  |  | "#{mobilePositionSubmissionInterval}," + | 
|---|
|  |  |  | "#{subscribeCycleForAlarm}," + | 
|---|
|  |  |  | "#{ssrcCheck}," + | 
|---|
|  |  |  | "#{asMessageChannel}," + | 
|---|
|  |  |  | "#{geoCoordSys}," + | 
|---|
|  |  |  | "#{treeType}," + | 
|---|
|  |  |  | "#{online}" + | 
|---|
|  |  |  | 
|---|
|  |  |  | "mobilePositionSubmissionInterval," + | 
|---|
|  |  |  | "subscribeCycleForAlarm," + | 
|---|
|  |  |  | "ssrcCheck," + | 
|---|
|  |  |  | "asMessageChannel," + | 
|---|
|  |  |  | "geoCoordSys," + | 
|---|
|  |  |  | "treeType," + | 
|---|
|  |  |  | "online," + | 
|---|
|  |  |  | 
|---|
|  |  |  | "mobilePositionSubmissionInterval," + | 
|---|
|  |  |  | "subscribeCycleForAlarm," + | 
|---|
|  |  |  | "ssrcCheck," + | 
|---|
|  |  |  | "asMessageChannel," + | 
|---|
|  |  |  | "geoCoordSys," + | 
|---|
|  |  |  | "treeType," + | 
|---|
|  |  |  | "online " + | 
|---|
|  |  |  | 
|---|
|  |  |  | "mobilePositionSubmissionInterval," + | 
|---|
|  |  |  | "subscribeCycleForAlarm," + | 
|---|
|  |  |  | "ssrcCheck," + | 
|---|
|  |  |  | "asMessageChannel," + | 
|---|
|  |  |  | "geoCoordSys," + | 
|---|
|  |  |  | "treeType," + | 
|---|
|  |  |  | "online" + | 
|---|
|  |  |  | 
|---|
|  |  |  | "<if test=\"mobilePositionSubmissionInterval != null\">, mobilePositionSubmissionInterval=#{mobilePositionSubmissionInterval}</if>" + | 
|---|
|  |  |  | "<if test=\"subscribeCycleForAlarm != null\">, subscribeCycleForAlarm=#{subscribeCycleForAlarm}</if>" + | 
|---|
|  |  |  | "<if test=\"ssrcCheck != null\">, ssrcCheck=#{ssrcCheck}</if>" + | 
|---|
|  |  |  | "<if test=\"asMessageChannel != null\">, asMessageChannel=#{asMessageChannel}</if>" + | 
|---|
|  |  |  | "<if test=\"geoCoordSys != null\">, geoCoordSys=#{geoCoordSys}</if>" + | 
|---|
|  |  |  | "<if test=\"treeType != null\">, treeType=#{treeType}</if>" + | 
|---|
|  |  |  | "<if test=\"mediaServerId != null\">, mediaServerId=#{mediaServerId}</if>" + | 
|---|
|  |  |  | 
|---|
|  |  |  | "updateTime," + | 
|---|
|  |  |  | "charset," + | 
|---|
|  |  |  | "ssrcCheck," + | 
|---|
|  |  |  | "asMessageChannel," + | 
|---|
|  |  |  | "geoCoordSys," + | 
|---|
|  |  |  | "treeType," + | 
|---|
|  |  |  | "online" + | 
|---|
|  |  |  | 
|---|
|  |  |  | "#{updateTime}," + | 
|---|
|  |  |  | "#{charset}," + | 
|---|
|  |  |  | "#{ssrcCheck}," + | 
|---|
|  |  |  | "#{asMessageChannel}," + | 
|---|
|  |  |  | "#{geoCoordSys}," + | 
|---|
|  |  |  | "#{treeType}," + | 
|---|
|  |  |  | "#{online}" + | 
|---|
|  |  |  | 
|---|
|  |  |  | @Select("select count(1) as total, sum(online) as online from device") | 
|---|
|  |  |  | ResourceBaceInfo getOverview(); | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Select("select * from device") | 
|---|
|  |  |  | List<Device> getAll(); | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Select("select * from device where  asMessageChannel = 1") | 
|---|
|  |  |  | List<Device> queryDeviceWithAsMessageChannel(); | 
|---|
|  |  |  | } | 
|---|