设备掉线报警邮件发送

jinpengyong

2020-11-27 72026a58219a4ee7cc41a7b37204da372d16d2aa

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
package com.moral.mapper;
 
import java.util.List;
import java.util.Map;
 
import org.apache.ibatis.annotations.Param;
 
import com.moral.entity.Device;
 
public interface DeviceMapper {
    int deleteByPrimaryKey(Integer id);
 
    int insert(Device record);
 
    int insertSelective(Device record);
 
    Device selectByPrimaryKey(Integer id);
 
    Device selectWithOrgIdsByMac(String mac);
 
    List<Device> selectWithMacByNotState(String state);
 
    int updateChangedStateById(@Param("id") int id, @Param("state") String state);
 
    int updateByPrimaryKeySelective(Device record);
 
    int updateByPrimaryKey(Device record);
 
    List<Map<String, Object>> getChangshuMacs();
 
    List<Map<String, Object>> getMacAndSensorkeyByOrganizationid(@Param("organizationIdList") List<Object> organizationIdList);
 
    List<String> getMacs();
 
    List<String> getMacByOrganizationid(@Param("organizationIdList") List<Object> organizationIdList);
 
    List<Map<String, Object>> macAndOrganizationIdMap(@Param("macs") List<String> macs);
 
    List<String> getMacsByMonitorPointIds(List<Integer> list);
 
    List<Map<String, Object>> getAllByMacList(List<String> list);
 
    List<Map<String, Object>> getOfflineDevice();
 
}