darren
/
DDWiki
Segui 1
Vota 0
Forka 0
Codice Problemi 0 Pull Requests 0 Rilasci 0 Wiki Attività
鼎鼎知识库
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
127 Commit
1 Ramo (Branch)
Ramo (Branch): master
Rami (Branch) Tag
${ item.name }
Crea branch ${ searchTerm }
da 'master'
${ noResults }
DDWiki/运维/安装/2020.09胶州加模块.md

2020.09胶州加模块.md 65KB
Originale Permalink Blame Cronologia

胶州二期加模块

  • 准备

    -- 确定网卡名称：enp4s0
-- 查找模块：sudo arp-scan -I enp4s0 --localnet
-- 指向地址：192.168.88.1:8080/ebx-bishop/data/carry
-- 服务器：192.168.18.50 dingding teche123
-- 管理员登录：13800000000 TecheFwd2018

  • 需要添加的模块 ``` 楼层：二期负一层超市 区域：S1,S2,S3,S4,S5,S6 电箱：S1电箱，S2电箱，S3电箱，S4电箱，S5电箱，S6电箱

S1 1: 2B8B0 2: 2C04C 3: 2B9DC 4: 2A8B0 5: 2A62C 6：28F44 120

S2 1: 2A8B4 2: 2BF30 3: 2B794 4: 2A8D4 5: 2B550 6: 28BA8 118

S3

1: 2C12C 100 2: 2BA40 102 3: 2A7D4 4: 2BFB8 104 5: 2BE24 6: 28490

S4 1: 28D80 114 2: 2AD70 3: 28F84 4: 285A8 116 5: 28DC0 113 6: 28D84 115

S5 1: 2B278 2: 2B940 3: 2BE78 4: 2A054 5: 2C2C4 6: 2B424

S6 1: 29140 112 2: 291B8 107 3: 2BEF4

- 区域图片
- 创建楼层
- 创建区域
- 创建电箱
- 查找模块，进行重定向，并软重启

--重定向地址：192.168.88.1:8080/ebx-bishop/data/carry -- 当前模块数量：select count(distinct(Mac)) from KaiGuan 42个


# 一期C区加模块

- 需要添加的模块

1-1 257A8 1-2 2286C 1-3 287D8

2-1 29B80 160 2-2 2570C 170 2-3 2A084 164

3-1 22070 168 3-2 29880 162 3-3 2A148 167

4-1 290F0 163 4-2 29628 4-3 2933C 161

- 一共56个模块

select DISTINCT(Mac) from KaiGuan select count(DISTINCT(Mac)) from KaiGuan 现有42个模块 187ed53249 一层A区电箱 187ed5329a 43 10.5已指向 187ed53218 30 10.5已指向 187ed53297 一层A区电箱 187ed53298 45 一层A区电箱 10.5已指向 187ed5328b 152 10.5已指向 187ed5329a 177 10.5已指向 187ed53287 32 10.5已指向 187ed5324f 33 10.5已指向 187ed5329c 61 10.5已指向 187ed53250 65 10.5已指向 187ed532a1 36 10.5已指向 187ed53289 35 10.5已指向 187ed5329e 29 10.5已指向 187ed5329a 27 10.5已指向 187ed53249 60 10.5已指向 187ed53242 191 10.5已指向 187ed53122 31 10.5已指向 187ed5328a 56 四层A区电箱 10.5已指向 187ed53298 四层A区电箱 187ed53208 四层A区电箱 187ed5323f 55 10.5已指向 187ed53292 59 四层B区电箱 10.5已指向 187ed532a2 四层B区电箱 187ed532a2 88 10.5已指向 187ed5329b 三层B区电箱 187ed53287 83 10.5已指向 187ed5323a 90 10.5已指向 187ed53292 三层B区电箱 187ed532a1 92 三层B区电箱 10.5已指向 187ed5328b 93 10.5已指向 187ed53298 94 10.5已指向 187ed53290 69 10.5已指向 187ed53295 二层B区电箱 187ed53287 96 10.5已指向 187ed5323e 97 10.5已指向 187ed5324c 99 10.5已指向 187ed53295 71 10.5已指向 187ed5327d 79 10.5已指向 187ed5328f 77 10.5已指向 187ed53224 80 10.5已指向 187ed53252 76 10.5已指向

- ip找不到模块的

28DB0 114 无法找到 28E24 105 无法找到


# 与现场的沟通

二期负一层超市情况如下

★ S1区 8：15--21：30 二期负一层超市S1区上班 二期负一层超市S1区下班 1: 2B8B0 局域网内找不到；10.5在局域网找到，IP是235，已指向服务器并重启； 线路地址完整 排序6 select Mac, LineAddress from KaiGuan where Mac=‘187ed532b8b0’ update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b8b0’ and LineAddress=‘1’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532b8b0’ and LineAddress=‘2’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b8b0’ and LineAddress=‘3’; update KaiGuan Set Name=‘扶梯南灯’ where Mac=‘187ed532b8b0’ and LineAddress=‘4’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b8b0’ and LineAddress=‘5’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532b8b0’ and LineAddress=‘6’; update KaiGuan Set Name=‘入口电缆’ where Mac=‘187ed532b8b0’ and LineAddress=‘7’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b8b0’ and LineAddress=‘8’; update KaiGuan Set Name=‘超市入口反光2’ where Mac=‘187ed532b8b0’ and LineAddress=‘9’; update KaiGuan Set Name=‘卫生间女感应’ where Mac=‘187ed532b8b0’ and LineAddress=‘10’; update KaiGuan Set Name=‘自助收银反光2’ where Mac=‘187ed532b8b0’ and LineAddress=‘11’; update KaiGuan Set Name=‘卫生间女灯’ where Mac=‘187ed532b8b0’ and LineAddress=‘12’; update KaiGuan Set Name=‘卫生间南反光’ where Mac=‘187ed532b8b0’ and LineAddress=‘13’; update KaiGuan Set Name=‘卫生间男感应’ where Mac=‘187ed532b8b0’ and LineAddress=‘14’; update KaiGuan Set Name=‘卫生间女反光2’ where Mac=‘187ed532b8b0’ and LineAddress=‘15’; update KaiGuan Set Name=‘卫生间男灯’ where Mac=‘187ed532b8b0’ and LineAddress=‘16’; update KaiGuan Set Name=‘卫生间廊灯’ where Mac=‘187ed532b8b0’ and LineAddress=‘17’; update KaiGuan Set Name=‘卫生间廊灯反光2’ where Mac=‘187ed532b8b0’ and LineAddress=‘18’;

2: 2C04C 局域网内找不到; 10.5在局域网找到，IP是251，已指向服务器并重启； 线路地址完整 排序5 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532c04c’ update KaiGuan Set Name=‘扶梯廊灯’ where Mac=‘187ed532c04c’ and LineAddress=‘1’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532c04c’ and LineAddress=‘2’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532c04c’ and LineAddress=‘3’; update KaiGuan Set Name=‘步梯灯’ where Mac=‘187ed532c04c’ and LineAddress=‘4’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532c04c’ and LineAddress=‘5’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532c04c’ and LineAddress=‘6’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532c04c’ and LineAddress=‘7’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532c04c’ and LineAddress=‘8’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532c04c’ and LineAddress=‘9’;

3: 2B9DC 局域网内找不到; 10.5在局域网找到，IP是237，已指向服务器并重启； 线路地址完整 排序4 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532b9dc’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘1’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘2’; update KaiGuan Set Name=‘圆灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘3’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘4’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532b9dc’ and LineAddress=‘5’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘6’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘7’; update KaiGuan Set Name=‘客梯反光’ where Mac=‘187ed532b9dc’ and LineAddress=‘8’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘9’; update KaiGuan Set Name=‘西厅灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘10’; update KaiGuan Set Name=‘东厅灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘11’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532b9dc’ and LineAddress=‘12’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532b9dc’ and LineAddress=‘13’; update KaiGuan Set Name=‘东厅灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘14’; update KaiGuan Set Name=‘东厅灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘15’; update KaiGuan Set Name=‘西厅灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘16’; update KaiGuan Set Name=‘北厅灯’ where Mac=‘187ed532b9dc’ and LineAddress=‘17’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532b9dc’ and LineAddress=‘18’;

4: 2AB90 局域网内找不到; 10.6找到，模块号错了，IP是239，已指向服务器并重启。 线路地址完整 排序3

select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532ab90’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532ab90’ and LineAddress=‘1’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ab90’ and LineAddress=‘2’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ab90’ and LineAddress=‘3’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ab90’ and LineAddress=‘4’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ab90’ and LineAddress=‘5’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ab90’ and LineAddress=‘6’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ab90’ and LineAddress=‘7’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ab90’ and LineAddress=‘8’; update KaiGuan Set Name=‘西厅灯’ where Mac=‘187ed532ab90’ and LineAddress=‘9’; 添加场景

5: 2A62C 局域网内找不到；10.5在局域网找到，IP是252， 已指向服务器并重启； 线路地址完整 排序2 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532a62c’ update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532a62c’ and LineAddress=‘1’; update KaiGuan Set Name=‘扶梯南灯’ where Mac=‘187ed532a62c’ and LineAddress=‘2’; update KaiGuan Set Name=‘收银台灯’ where Mac=‘187ed532a62c’ and LineAddress=‘3’; update KaiGuan Set Name=‘收银台反光4’ where Mac=‘187ed532a62c’ and LineAddress=‘4’; update KaiGuan Set Name=‘收银台反光3’ where Mac=‘187ed532a62c’ and LineAddress=‘5’; update KaiGuan Set Name=‘柱圆灯’ where Mac=‘187ed532a62c’ and LineAddress=‘6’; update KaiGuan Set Name=‘收银台反光2’ where Mac=‘187ed532a62c’ and LineAddress=‘7’; update KaiGuan Set Name=‘收银台反光5’ where Mac=‘187ed532a62c’ and LineAddress=‘8’; update KaiGuan Set Name=‘收银台灯’ where Mac=‘187ed532a62c’ and LineAddress=‘9’; update KaiGuan Set Name=‘收银台灯反光6’ where Mac=‘187ed532a62c’ and LineAddress=‘10’; update KaiGuan Set Name=‘收银台灯’ where Mac=‘187ed532a62c’ and LineAddress=‘11’; update KaiGuan Set Name=‘收银台灯’ where Mac=‘187ed532a62c’ and LineAddress=‘12’; update KaiGuan Set Name=‘单号’ where Mac=‘187ed532a62c’ and LineAddress=‘13’; update KaiGuan Set Name=‘双号’ where Mac=‘187ed532a62c’ and LineAddress=‘14’; update KaiGuan Set Name=‘反光2’ where Mac=‘187ed532a62c’ and LineAddress=‘15’; update KaiGuan Set Name=‘廊东灯’ where Mac=‘187ed532a62c’ and LineAddress=‘16’; update KaiGuan Set Name=‘自助收银灯’ where Mac=‘187ed532a62c’ and LineAddress=‘17’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532a62c’ and LineAddress=‘18’;

6：28F44 局域网内找不到；10.6在局域网找到，IP是17， 已指向服务器并重启； 线路地址完整 排序1 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed5328f44’

update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328f44’ and LineAddress=‘1’; update KaiGuan Set Name=‘备用’ where Mac=‘187ed5328f44’ and LineAddress=‘2’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328f44’ and LineAddress=‘3’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328f44’ and LineAddress=‘4’; update KaiGuan Set Name=‘柱圆反光’ where Mac=‘187ed5328f44’ and LineAddress=‘5’; update KaiGuan Set Name=‘柱圆反光’ where Mac=‘187ed5328f44’ and LineAddress=‘6’; update KaiGuan Set Name=‘柱圆反光’ where Mac=‘187ed5328f44’ and LineAddress=‘7’; update KaiGuan Set Name=‘夜间照明’ where Mac=‘187ed5328f44’ and LineAddress=‘8’; s1上班场景 s1下班场景

★ S2 8：15--21：30 二期负一层超市S2区上班 二期负一层超市S2区下班 1: 2A8B4 局域网内找不到; 10.5在局域网找到，IP是224，已指向服务器并重启； 线路地址完整 排序6 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532a8b4’ update KaiGuan Set Name=‘反光’ where Mac=‘187ed532a8b4’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带1’ where Mac=‘187ed532a8b4’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带1’ where Mac=‘187ed532a8b4’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带2’ where Mac=‘187ed532a8b4’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带2’ where Mac=‘187ed532a8b4’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带3’ where Mac=‘187ed532a8b4’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带3’ where Mac=‘187ed532a8b4’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带4’ where Mac=‘187ed532a8b4’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带4’ where Mac=‘187ed532a8b4’ and LineAddress=‘9’; update KaiGuan Set Name=‘灯带5’ where Mac=‘187ed532a8b4’ and LineAddress=‘10’; update KaiGuan Set Name=‘灯带5’ where Mac=‘187ed532a8b4’ and LineAddress=‘11’; update KaiGuan Set Name=‘灯带6’ where Mac=‘187ed532a8b4’ and LineAddress=‘12’; update KaiGuan Set Name=‘灯带6’ where Mac=‘187ed532a8b4’ and LineAddress=‘13’; update KaiGuan Set Name=‘灯带7’ where Mac=‘187ed532a8b4’ and LineAddress=‘14’; update KaiGuan Set Name=‘灯带7’ where Mac=‘187ed532a8b4’ and LineAddress=‘15’; update KaiGuan Set Name=‘灯带8’ where Mac=‘187ed532a8b4’ and LineAddress=‘16’; update KaiGuan Set Name=‘灯带8’ where Mac=‘187ed532a8b4’ and LineAddress=‘17’; update KaiGuan Set Name=‘灯带9’ where Mac=‘187ed532a8b4’ and LineAddress=‘18’;

2: 2BF30 局域网内找不到; 10.5在局域网找到，IP是229，已指向服务器并重启； 线路地址完整 排序5 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532bf30’

update KaiGuan Set Name=‘反光’ where Mac=‘187ed532bf30’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带9’ where Mac=‘187ed532bf30’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带10’ where Mac=‘187ed532bf30’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带10’ where Mac=‘187ed532bf30’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带11’ where Mac=‘187ed532bf30’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带11’ where Mac=‘187ed532bf30’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带12’ where Mac=‘187ed532bf30’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带12’ where Mac=‘187ed532bf30’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带13’ where Mac=‘187ed532bf30’ and LineAddress=‘9’;

3: 2B794 局域网内找不到; 10.5在局域网找到，IP是227，已指向服务器并重启； 线路地址完整 排序4 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532b794’

update KaiGuan Set Name=‘反光’ where Mac=‘187ed532bf30’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带13’ where Mac=‘187ed532bf30’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带1’ where Mac=‘187ed532bf30’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带1’ where Mac=‘187ed532bf30’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带2’ where Mac=‘187ed532bf30’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带2’ where Mac=‘187ed532bf30’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带3’ where Mac=‘187ed532bf30’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带3’ where Mac=‘187ed532bf30’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带4’ where Mac=‘187ed532bf30’ and LineAddress=‘9’; update KaiGuan Set Name=‘灯带4’ where Mac=‘187ed532bf30’ and LineAddress=‘10’; update KaiGuan Set Name=‘C2灯1’ where Mac=‘187ed532bf30’ and LineAddress=‘11’; update KaiGuan Set Name=‘C2灯1’ where Mac=‘187ed532bf30’ and LineAddress=‘12’; update KaiGuan Set Name=‘C2灯1’ where Mac=‘187ed532bf30’ and LineAddress=‘13’; update KaiGuan Set Name=‘C2灯1’ where Mac=‘187ed532bf30’ and LineAddress=‘14’; update KaiGuan Set Name=‘C2灯2’ where Mac=‘187ed532bf30’ and LineAddress=‘15’; update KaiGuan Set Name=‘C2灯2’ where Mac=‘187ed532bf30’ and LineAddress=‘16’; update KaiGuan Set Name=‘C2灯2’ where Mac=‘187ed532bf30’ and LineAddress=‘17’; update KaiGuan Set Name=‘C2灯2’ where Mac=‘187ed532bf30’ and LineAddress=‘18’;

4: 2A8D4 局域网内找不到; 10.5在局域网找到，IP是226，已指向服务器并重启； 线路地址完整 排序3 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532a8d4’

update KaiGuan Set Name=‘反光’ where Mac=‘187ed532a8d4’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带7’ where Mac=‘187ed532a8d4’ and LineAddress=‘2’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532a8d4’ and LineAddress=‘3’; update KaiGuan Set Name=‘射灯8’ where Mac=‘187ed532a8d4’ and LineAddress=‘4’; update KaiGuan Set Name=‘射灯3’ where Mac=‘187ed532a8d4’ and LineAddress=‘5’; update KaiGuan Set Name=‘射灯4’ where Mac=‘187ed532a8d4’ and LineAddress=‘6’; update KaiGuan Set Name=‘射灯5’ where Mac=‘187ed532a8d4’ and LineAddress=‘7’; update KaiGuan Set Name=‘射灯6’ where Mac=‘187ed532a8d4’ and LineAddress=‘8’; update KaiGuan Set Name=‘射灯7’ where Mac=‘187ed532a8d4’ and LineAddress=‘9’;

5: 2B550 局域网内找不到; 10.5在局域网找到，IP是228，已指向服务器并重启； 线路地址完整 排序2 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532b550’

update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b550’ and LineAddress=‘1’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532b550’ and LineAddress=‘2’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532b550’ and LineAddress=‘3’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532b550’ and LineAddress=‘4’; update KaiGuan Set Name=‘加工间外灯’ where Mac=‘187ed532b550’ and LineAddress=‘5’; update KaiGuan Set Name=‘加工间外灯’ where Mac=‘187ed532b550’ and LineAddress=‘6’; update KaiGuan Set Name=‘射灯2’ where Mac=‘187ed532b550’ and LineAddress=‘7’; update KaiGuan Set Name=‘柱反光’ where Mac=‘187ed532b550’ and LineAddress=‘8’; update KaiGuan Set Name=‘柱反光’ where Mac=‘187ed532b550’ and LineAddress=‘9’; update KaiGuan Set Name=‘柱反光’ where Mac=‘187ed532b550’ and LineAddress=‘10’; update KaiGuan Set Name=‘吊眉灯’ where Mac=‘187ed532b550’ and LineAddress=‘11’; update KaiGuan Set Name=‘柱反光’ where Mac=‘187ed532b550’ and LineAddress=‘12’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b550’ and LineAddress=‘13’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b550’ and LineAddress=‘14’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b550’ and LineAddress=‘15’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b550’ and LineAddress=‘16’; update KaiGuan Set Name=‘射灯1’ where Mac=‘187ed532b550’ and LineAddress=‘17’; update KaiGuan Set Name=‘吊眉灯’ where Mac=‘187ed532b550’ and LineAddress=‘18’;

6: 28BA8 在局域网内找到,已指向服务器并重启，但之后在局域网内找不到; 10.5在局域网找到，IP是189，已设置好服务器指向； 线路地址完整 排序1

select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed5328ba8’

update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328ba8’ and LineAddress=‘1’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328ba8’ and LineAddress=‘2’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328ba8’ and LineAddress=‘3’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328ba8’ and LineAddress=‘4’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328ba8’ and LineAddress=‘5’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328ba8’ and LineAddress=‘6’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328ba8’ and LineAddress=‘7’; update KaiGuan Set Name=‘夜间照明’ where Mac=‘187ed5328ba8’ and LineAddress=‘8’;

★ S3 8：15--21：30 二期负一层超市S3区上班 二期负一层超市S3区下班

1: 2C12C 局域网内找不到; 10.5在局域网找到，IP是215，已指向服务器并重启； 线路地址完整 排序6 select Mac, LineAddress, Name, DianXiangId from KaiGuan where Mac=‘187ed532c12c’

update KaiGuan Set Name=‘反光’ where Mac=‘187ed532c12c’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带1’ where Mac=‘187ed532c12c’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带1’ where Mac=‘187ed532c12c’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带2’ where Mac=‘187ed532c12c’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带2’ where Mac=‘187ed532c12c’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带3’ where Mac=‘187ed532c12c’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带3’ where Mac=‘187ed532c12c’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带4’ where Mac=‘187ed532c12c’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带4’ where Mac=‘187ed532c12c’ and LineAddress=‘9’; update KaiGuan Set Name=‘灯带5’ where Mac=‘187ed532c12c’ and LineAddress=‘10’; update KaiGuan Set Name=‘灯带5’ where Mac=‘187ed532c12c’ and LineAddress=‘11’; update KaiGuan Set Name=‘灯带6’ where Mac=‘187ed532c12c’ and LineAddress=‘12’; update KaiGuan Set Name=‘灯带6’ where Mac=‘187ed532c12c’ and LineAddress=‘13’; update KaiGuan Set Name=‘灯带7’ where Mac=‘187ed532c12c’ and LineAddress=‘14’; update KaiGuan Set Name=‘灯带7’ where Mac=‘187ed532c12c’ and LineAddress=‘15’; update KaiGuan Set Name=‘灯带8’ where Mac=‘187ed532c12c’ and LineAddress=‘16’; update KaiGuan Set Name=‘灯带8’ where Mac=‘187ed532c12c’ and LineAddress=‘17’; update KaiGuan Set Name=‘灯带9’ where Mac=‘187ed532c12c’ and LineAddress=‘18’;

2: 2BA40 局域网内找不到; 10.5在局域网找到，IP是214，已指向服务器并重启； 线路地址完整 排序5 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed532ba40’

update KaiGuan Set Name=‘射灯2’ where Mac=‘187ed532ba40’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带9’ where Mac=‘187ed532ba40’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带10’ where Mac=‘187ed532ba40’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带10’ where Mac=‘187ed532ba40’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带11’ where Mac=‘187ed532ba40’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带11’ where Mac=‘187ed532ba40’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带12’ where Mac=‘187ed532ba40’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带12’ where Mac=‘187ed532ba40’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带14’ where Mac=‘187ed532ba40’ and LineAddress=‘9’;

--10.6 更换成28658

-局域网找新模块28658，确认指向？187ED5328658: 254，10.5, 已指向服务器并重启；服务器已收到； -新模块28658是否最新？确实最新。 -确认旧模块2BA40是否不再更新？最后一次更新时间在2020-10-06 09:34:19，确实不再更新。 -记录旧模块2BA40的开关编号？ select * from KaiGuan where Mac=‘187ed532ba40’ in (‘742’,‘743’,‘744’,‘745’,‘746’,‘747’,‘748’,‘749’,‘750’) -删除旧模块SceneDetails select * from sceneDetails where mac=‘187ed532ba40’ delete from sceneDetails where mac=‘187ed532ba40’

-删除旧模块SceneItem select * from SceneItem where KaiGuanId in (‘742’,‘743’,‘744’,‘745’,‘746’,‘747’,‘748’,‘749’,‘750’) delete from SceneItem where KaiGuanId in (‘742’,‘743’,‘744’,‘745’,‘746’,‘747’,‘748’,‘749’,‘750’)

-删除旧模块warninghistories select * from warningHistories where KaiGuanId in (‘742’,‘743’,‘744’,‘745’,‘746’,‘747’,‘748’,‘749’,‘750’) delete from warningHistories where KaiGuanId in (‘742’,‘743’,‘744’,‘745’,‘746’,‘747’,‘748’,‘749’,‘750’)

-删除旧模块kaiguanwarning select * from kaiguanwarning where KaiGuanId in (‘742’,‘743’,‘744’,‘745’,‘746’,‘747’,‘748’,‘749’,‘750’) delete from KaiGuanWarning where KaiGuanId in (‘742’,‘743’,‘744’,‘745’,‘746’,‘747’,‘748’,‘749’,‘750’)

-删除旧模块开关 select * from KaiGuan where Mac=‘187ed532ba40’ delete from KaiGuan where Mac=‘187ed532ba40’

-添加新模块开关 select Mac, LineAddress, Name from KaiGuan where Mac=‘187ed5328658’

update KaiGuan Set Name=‘射灯2’ where Mac=‘187ed5328658’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带9’ where Mac=‘187ed5328658’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带10’ where Mac=‘187ed5328658’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带10’ where Mac=‘187ed5328658’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带11’ where Mac=‘187ed5328658’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带11’ where Mac=‘187ed5328658’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带12’ where Mac=‘187ed5328658’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带12’ where Mac=‘187ed5328658’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带14’ where Mac=‘187ed5328658’ and LineAddress=‘9’; -设置新模块相关场景 S3上班 S3下班

3: 2A7D4 局域网内找不到；10.5在局域网找到，IP是216，已指向服务器并重启； 线路地址完整 排序4 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532a7d4’

update KaiGuan Set Name=‘射灯3’ where Mac=‘187ed532a7d4’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带14’ where Mac=‘187ed532a7d4’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带8’ where Mac=‘187ed532a7d4’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带8’ where Mac=‘187ed532a7d4’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带7’ where Mac=‘187ed532a7d4’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带7’ where Mac=‘187ed532a7d4’ and LineAddress=‘6’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘7’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘8’; update KaiGuan Set Name=” where Mac=‘187ed532a7d4’ and LineAddress=‘9’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532a7d4’ and LineAddress=‘10’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘11’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘12’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘13’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘14’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘15’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘16’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘17’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532a7d4’ and LineAddress=‘18’;

4: 2BFB8 局域网内找不到; 10.5在局域网找到，IP是218，已指向服务器并重启； 线路地址完整 排序3

select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532bfb8’

update KaiGuan Set Name=‘射灯4’ where Mac=‘187ed532ba40’ and LineAddress=‘1’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532ba40’ and LineAddress=‘2’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ba40’ and LineAddress=‘3’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ba40’ and LineAddress=‘4’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ba40’ and LineAddress=‘5’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ba40’ and LineAddress=‘6’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532ba40’ and LineAddress=‘7’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ba40’ and LineAddress=‘8’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532ba40’ and LineAddress=‘9’;

5: 2BE24 局域网内找不到 --10.6 更换成2F060,准确来说不是更换，而是添加新的模块 2F060, 10.6, IP是171，已指向服务器并重启； 线路地址完整 排序2

select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532f060’

update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532f060’ and LineAddress=‘1’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed532f060’ and LineAddress=‘2’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed532f060’ and LineAddress=‘3’; update KaiGuan Set Name=‘柱子灯箱’ where Mac=‘187ed532f060’ and LineAddress=‘4’; update KaiGuan Set Name=‘卷帘反光’ where Mac=‘187ed532f060’ and LineAddress=‘5’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532f060’ and LineAddress=‘6’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532f060’ and LineAddress=‘7’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532f060’ and LineAddress=‘8’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532f060’ and LineAddress=‘9’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532f060’ and LineAddress=‘10’; update KaiGuan Set Name=‘消防排气电源’ where Mac=‘187ed532f060’ and LineAddress=‘18’; 场景：S3上班，S3下班

6: 28490 局域网内找不到； 10.5在局域网找到， IP是217，已指向服务器并重启；服务器没收到数据； --10.6 更换成2F644,准确来说不是更换，而是添加新的模块 2F644, 10.6，IP是19，已指向服务器并重启； 线路地址完整 排序1

select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532f644’

update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532f644’ and LineAddress=‘1’; update KaiGuan Set Name=‘楼梯间灯’ where Mac=‘187ed532f644’ and LineAddress=‘2’; update KaiGuan Set Name=‘弱电间灯’ where Mac=‘187ed532f644’ and LineAddress=‘6’; update KaiGuan Set Name=‘配电间灯’ where Mac=‘187ed532f644’ and LineAddress=‘7’; update KaiGuan Set Name=‘夜间照明’ where Mac=‘187ed532f644’ and LineAddress=‘8’;

场景：S3上班，S3下班

★ S4 8：15--21：30 二期负一层超市S4区上班 二期负一层超市S4区下班 1: 28DB0 局域网内找不到; 10.5在据业务找到，IP是84， 已指向服务器并重启；服务器没收到数据,是否线路地址没有编？ 线路地址完整 排序6

select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed5328db0’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328db0’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘9’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘10’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘11’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘12’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘13’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘14’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘15’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘16’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘17’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328db0’ and LineAddress=‘18’; 场景

2: 2AD70 局域网内找不到; 10.5在局域网找到，IP是193，已指向服务器并重启； 线路地址完整 排序5 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532ad70’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532ad70’ and LineAddress=‘1’; update KaiGuan Set Name=‘工艺灯’ where Mac=‘187ed532ad70’ and LineAddress=‘2’;

3: 28FB4 局域网内找不到; 10.5在局域网找到，IP是183，已指向服务器并重启； 线路地址完整 排序4 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed5328fb4’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328fb4’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328fb4’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328fb4’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328fb4’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328fb4’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328fb4’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328fb4’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328fb4’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed5328fb4’ and LineAddress=‘9’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed5328fb4’ and LineAddress=‘10’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed5328fb4’ and LineAddress=‘11’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed5328fb4’ and LineAddress=‘12’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed5328fb4’ and LineAddress=‘13’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328fb4’ and LineAddress=‘14’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328fb4’ and LineAddress=‘15’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed5328fb4’ and LineAddress=‘16’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328fb4’ and LineAddress=‘17’;

4: 285A8 局域网内找不到; 10.5在局域网找到，IP是184，已指向服务器并重启； 线路地址完整 排序3 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed53285a8’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed53285a8’ and LineAddress=‘1’; update KaiGuan Set Name=‘备用’ where Mac=‘187ed53285a8’ and LineAddress=‘7’; update KaiGuan Set Name=‘仓库’ where Mac=‘187ed53285a8’ and LineAddress=‘8’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed53285a8’ and LineAddress=‘9’; 5: 28DC0 局域网内找不到; 10.5在局域网找到，IP是21，已指向服务区并重启；服务器没收到数据。 线路地址完整 排序2 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed5328dc0’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘1’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328dc0’ and LineAddress=‘2’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘3’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328dc0’ and LineAddress=‘4’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘5’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘6’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328dc0’ and LineAddress=‘7’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘8’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘9’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘10’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘11’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘12’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328dc0’ and LineAddress=‘13’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328dc0’ and LineAddress=‘14’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed5328dc0’ and LineAddress=‘15’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘16’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘17’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed5328dc0’ and LineAddress=‘18’;

6: 28D84 局域网内找不到; 10.5在局域网找到，IP是63，已指向服务器并重启； 线路地址完整 排序1 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed5328d84’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed5328d84’ and LineAddress=‘1’; update KaiGuan Set Name=‘配电间外灯’ where Mac=‘187ed5328d84’ and LineAddress=‘6’; update KaiGuan Set Name=‘配电间灯’ where Mac=‘187ed5328d84’ and LineAddress=‘7’; update KaiGuan Set Name=‘夜间照明’ where Mac=‘187ed5328d84’ and LineAddress=‘8’;

★ S5 8：15--21：30 二期负一层超市S5区上班 二期负一层超市S5区下班 1: 2B278 局域网内找不到; 10.5在局域网找到，IP是73，已指向服务器并重启； 线路地址完整 排序6 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532b278’

update KaiGuan Set Name=‘加工间外灯’ where Mac=‘187ed532b278’ and LineAddress=‘1’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b278’ and LineAddress=‘2’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b278’ and LineAddress=‘3’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532b278’ and LineAddress=‘4’; update KaiGuan Set Name=‘造型灯’ where Mac=‘187ed532b278’ and LineAddress=‘5’; update KaiGuan Set Name=‘造型反光’ where Mac=‘187ed532b278’ and LineAddress=‘6’; update KaiGuan Set Name=‘造型反光’ where Mac=‘187ed532b278’ and LineAddress=‘7’; update KaiGuan Set Name=‘造型反光’ where Mac=‘187ed532b278’ and LineAddress=‘8’; update KaiGuan Set Name=‘造型反光’ where Mac=‘187ed532b278’ and LineAddress=‘9’; update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b278’ and LineAddress=‘10’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b278’ and LineAddress=‘11’; update KaiGuan Set Name=‘造型反光’ where Mac=‘187ed532b278’ and LineAddress=‘12’; update KaiGuan Set Name=‘加工间廊灯’ where Mac=‘187ed532b278’ and LineAddress=‘13’; update KaiGuan Set Name=‘柱造型反光’ where Mac=‘187ed532b278’ and LineAddress=‘14’; update KaiGuan Set Name=‘柱造型反光’ where Mac=‘187ed532b278’ and LineAddress=‘15’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b278’ and LineAddress=‘16’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b278’ and LineAddress=‘17’; update KaiGuan Set Name=‘柱造型反光’ where Mac=‘187ed532b278’ and LineAddress=‘18’;

2: 2B940 局域网内找不到; 10.5在局域网找到，IP是70，已指向服务器并重启； 线路地址完整 排序5

select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532b940’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b940’ and LineAddress=‘1’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b940’ and LineAddress=‘2’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b940’ and LineAddress=‘3’; update KaiGuan Set Name=‘反光’ where Mac=‘187ed532b940’ and LineAddress=‘4’; update KaiGuan Set Name=‘射灯5’ where Mac=‘187ed532b940’ and LineAddress=‘5’; update KaiGuan Set Name=‘射灯1’ where Mac=‘187ed532b940’ and LineAddress=‘6’; update KaiGuan Set Name=‘加工间造型反光1’ where Mac=‘187ed532b940’ and LineAddress=‘7’; update KaiGuan Set Name=‘加工间造型反光2’ where Mac=‘187ed532b940’ and LineAddress=‘8’;

3: 2BE78 局域网内找不到; 10.5在局域网找到，IP是98，已指向服务器并重启； 线路地址完整 排序4 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532be78’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532be78’ and LineAddress=‘1’; update KaiGuan Set Name=‘灯带7’ where Mac=‘187ed532be78’ and LineAddress=‘2’; update KaiGuan Set Name=‘灯带7’ where Mac=‘187ed532be78’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带8’ where Mac=‘187ed532be78’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带8’ where Mac=‘187ed532be78’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532be78’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532be78’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532be78’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532be78’ and LineAddress=‘9’; update KaiGuan Set Name=‘灯带6’ where Mac=‘187ed532be78’ and LineAddress=‘10’; update KaiGuan Set Name=‘灯带6’ where Mac=‘187ed532be78’ and LineAddress=‘11’; update KaiGuan Set Name=‘灯带2’ where Mac=‘187ed532be78’ and LineAddress=‘12’; update KaiGuan Set Name=‘灯带2’ where Mac=‘187ed532be78’ and LineAddress=‘13’; update KaiGuan Set Name=‘灯带3’ where Mac=‘187ed532be78’ and LineAddress=‘14’; update KaiGuan Set Name=‘灯带3’ where Mac=‘187ed532be78’ and LineAddress=‘15’; update KaiGuan Set Name=‘灯带1’ where Mac=‘187ed532be78’ and LineAddress=‘16’; update KaiGuan Set Name=‘灯带1’ where Mac=‘187ed532be78’ and LineAddress=‘17’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532be78’ and LineAddress=‘18’;

4: 2A054 局域网内找不到; 10.5在局域网找到，IP是200，已指向服务器并重启； 线路地址完整 排序3

select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532a054’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532a054’ and LineAddress=‘1’; update KaiGuan Set Name=‘射灯2’ where Mac=‘187ed532a054’ and LineAddress=‘2’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532a054’ and LineAddress=‘3’; update KaiGuan Set Name=‘射灯3’ where Mac=‘187ed532a054’ and LineAddress=‘4’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532a054’ and LineAddress=‘5’; update KaiGuan Set Name=‘廊造型反光灯’ where Mac=‘187ed532a054’ and LineAddress=‘6’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532a054’ and LineAddress=‘7’; update KaiGuan Set Name=‘柱子造型射灯’ where Mac=‘187ed532a054’ and LineAddress=‘8’;

5: 2C2C4 局域网内找不到; 10.5在局域网找到，IP是198，已指向服务器并重启； 线路地址完整 排序2 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532c2c4’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532c2c4’ and LineAddress=‘1’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed532c2c4’ and LineAddress=‘2’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed532c2c4’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带5’ where Mac=‘187ed532c2c4’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带5’ where Mac=‘187ed532c2c4’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘8’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘9’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘10’; update KaiGuan Set Name=‘灯带9’ where Mac=‘187ed532c2c4’ and LineAddress=‘11’; update KaiGuan Set Name=‘灯带9’ where Mac=‘187ed532c2c4’ and LineAddress=‘12’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘13’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘14’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘15’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘16’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘17’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532c2c4’ and LineAddress=‘18’;

6: 2B424 局域网内找不到; 10.5在局域网找到，IP是72，已指向服务器并重启； 线路完整 排序1 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532b424’

update KaiGuan Set Name=‘廊灯’ where Mac=‘187ed532b424’ and LineAddress=‘1’; update KaiGuan Set Name=‘射灯7’ where Mac=‘187ed532b424’ and LineAddress=‘2’; update KaiGuan Set Name=‘射灯4’ where Mac=‘187ed532b424’ and LineAddress=‘3’; update KaiGuan Set Name=‘射灯6’ where Mac=‘187ed532b424’ and LineAddress=‘4’; update KaiGuan Set Name=‘射灯8’ where Mac=‘187ed532b424’ and LineAddress=‘5’; update KaiGuan Set Name=‘备用’ where Mac=‘187ed532b424’ and LineAddress=‘6’; update KaiGuan Set Name=‘工艺灯’ where Mac=‘187ed532b424’ and LineAddress=‘7’; update KaiGuan Set Name=‘夜间照明’ where Mac=‘187ed532b424’ and LineAddress=‘8’;

★ S6 8：15--21：30 二期负一层超市S6区上班 二期负一层超市S6区下班 1: 29140 在局域网内找到,已指向服务器并重启，但之后在局域网内找不到；10.5，在局域内找到，IP是248，已设置好服务器指向； 线路地址完整 排序3 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed5329140’

update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘1’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘2’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘3’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘4’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘5’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘6’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘7’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘8’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘9’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed5329140’ and LineAddress=‘10’;

2: 291B8 在局域网内找到,已指向服务器并重启，但之后在局域网内依然可以找到;10.5在局域网内找到，IP是16，已设置好服务器指向； 线路地址完整 排序2 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed53291b8’

update KaiGuan Set Name=‘射灯’ where Mac=‘187ed53291b8’ and LineAddress=‘1’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed53291b8’ and LineAddress=‘2’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed53291b8’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed53291b8’ and LineAddress=‘4’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed53291b8’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed53291b8’ and LineAddress=‘6’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed53291b8’ and LineAddress=‘7’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed53291b8’ and LineAddress=‘8’; update KaiGuan Set Name=‘夜间照明’ where Mac=‘187ed53291b8’ and LineAddress=‘13’;

3: 2BEF4 局域网内找不到；10.5，在局域网找到，IP是81，已指向服务器并重启； 线路地址完整 排序1

select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532bef4’

update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532bef4’ and LineAddress=‘1’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532bef4’ and LineAddress=‘2’; update KaiGuan Set Name=‘变光灯’ where Mac=‘187ed532bef4’ and LineAddress=‘3’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532bef4’ and LineAddress=‘4’; update KaiGuan Set Name=‘变光灯’ where Mac=‘187ed532bef4’ and LineAddress=‘5’; update KaiGuan Set Name=‘灯带’ where Mac=‘187ed532bef4’ and LineAddress=‘6’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed532bef4’ and LineAddress=‘7’; update KaiGuan Set Name=‘C2灯’ where Mac=‘187ed532bef4’ and LineAddress=‘8’; update KaiGuan Set Name=‘射灯’ where Mac=‘187ed532bef4’ and LineAddress=‘9’;

一期C区情况如下

★ 一层 1层C区上班 1层C区下班 1-1 257A8 局域网内找不到;10.5,在局域网找到，IP是208，已指向服务器并重启； 20个线路 排序3 已添加

1-2 2286C 局域网内找不到;10.5,在局域网找到，IP是210，已指向服务器并重启；服务器没有收到数据； 更换成187ED5328830 IP143，更改服务器指向并重启 线路地址完整 排序2 已添加

1-3 287D8 局域网内找不到;10.5，在局域网找到，IP是209，已指向服务器并重启； 20个线路 排序1 已添加

★ 二层 2层C区上班 2层C区下班 2-1 29B80 在局域网内找到,已指向服务器并重启，但之后在局域网内找不到;10.5,在局域内找到，IP是247，已设置好服务器指向。 18个线路 排序3 已添加 2-2 2570C 在局域网内找到,已指向服务器并重启，但之后在局域网内找不到;10.5,在局域网内找到，IP是243，已设置好服务器指向。 17个线路 排序2 已添加 2-3 2A084 在局域网内找到,已指向服务器并重启，但之后在局域网内找不到;10.5,在局域内找到，IP是245，已设置好服务器指向。 17个线路 排序1 已添加

★ 三层 3层C区上班 3层C区下班 3-1 22070 在局域网内找到,已指向服务器并重启，但之后在局域网内找不到；10.5在局域网内找到，IP是244，已设置好服务器指向； 8个线路 排序3 已添加 3-2 29880 局域网内找不到；10.5在局域网找到，IP是212，已指向服务器并重启； 7个线路 排序2 已添加 3-3 2A148 在局域网内找到,已指向服务器并重启，但之后在局域网内找不到;10.5在局域网找到，IP是167，已设置好服务器指向； 7个线路 排序1 已添加

★ 四层 4层C区上班
4-1 290F0 在局域网内找到,已指向服务器并重启，但之后在局域网内找不到;10.5,在局域内找到，IP是246，已设置好服务器指向。 10个线路 排序3 已添加 4-2 29628 局域网内找不到；10.5,在局域网找到，IP是62，已指向服务器并重启； 10个线路 排序2 已添加 4-3 2933C 在局域网内找到,已指向服务器并重启，但之后在局域网内找不到; 10.5，在局域网内找到，IP是161，已设置好服务器指向； 10个线路 排序1 已添加

前期安装的模块离线的包括如下：

★ 一层A区电箱： 第一排：187ed532492c, 10.5在局域网找到，IP是42，已设置好服务器指向； 第四排：187ed53297f0,10.5在局域网找到，IP是201，已设置好服务器指向； 第五排：187ed53298b0

★ 四层A区电箱： 第三排：187ed5328af0 第二排：187ed5329890，10.5在局域网找到，IP是57，已设置好服务器指向； 第一排：187ed53208c4, 10.5在局域网找到，IP是53，已设置好服务器指向

★ 四层B区电箱： 第二排：187ed5329218 第三排：187ed532a2fc,10.5在据业务找到，IP是87，已设置好服务器指向

★ 三层B区电箱： 第二排：187ed5329bc8, 10.5在局域网找到，IP是89，已设置好服务器指向； 第五排：187ed5329254，10.5在局域网找到，IP是202，已设置好服务器指向； 第六排：187ed532a1fc

★ 二层B区电箱： 第四排：187ed5329580， 10.5在局域网找到，IP是95，已设置好服务器指向






# 未确认位置的的模块

192.168.88.1:8080/ebx-bishop/data/carry

187ED532AB90: 239, 10.5, 已指向服务器并重启；服务器已收到； 28E24:185,10.5,已指向服务器并重启；服务器已收到；

28e04, 10.6，IP是64，已指向服务器并重启；


# 二期一层A区

1 2AC04 10.6， ip 117, 已指向服务器并重启； 线路地址完整 排序6 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532ac04’

update KaiGuan Set Name=‘楼道声控灯’ where Mac=‘187ed532ac04’ and LineAddress=‘1’; update KaiGuan Set Name=‘1号天井扶梯灯’ where Mac=‘187ed532ac04’ and LineAddress=‘2’; update KaiGuan Set Name=‘1号天井西楼道灯’ where Mac=‘187ed532ac04’ and LineAddress=‘3’; update KaiGuan Set Name=‘2号天井扶梯灯’ where Mac=‘187ed532ac04’ and LineAddress=‘4’; update KaiGuan Set Name=‘空’ where Mac=‘187ed532ac04’ and LineAddress=‘5’; update KaiGuan Set Name=‘1号天井东过道灯’ where Mac=‘187ed532ac04’ and LineAddress=‘6’; update KaiGuan Set Name=‘超市扶梯南过道灯’ where Mac=‘187ed532ac04’ and LineAddress=‘7’; update KaiGuan Set Name=‘超市扶梯灯’ where Mac=‘187ed532ac04’ and LineAddress=‘8’; update KaiGuan Set Name=‘超市扶梯灯’ where Mac=‘187ed532ac04’ and LineAddress=‘9’; update KaiGuan Set Name=‘超市扶梯西灯’ where Mac=‘187ed532ac04’ and LineAddress=‘10’; update KaiGuan Set Name=‘超市扶梯灯’ where Mac=‘187ed532ac04’ and LineAddress=‘11’; update KaiGuan Set Name=‘超市扶梯灯’ where Mac=‘187ed532ac04’ and LineAddress=‘12’; update KaiGuan Set Name=‘客梯墙灯’ where Mac=‘187ed532ac04’ and LineAddress=‘13’; update KaiGuan Set Name=‘2号天井西过道灯’ where Mac=‘187ed532ac04’ and LineAddress=‘14’; update KaiGuan Set Name=‘北2门内灯’ where Mac=‘187ed532ac04’ and LineAddress=‘15’; update KaiGuan Set Name=‘北2门内箱灯’ where Mac=‘187ed532ac04’ and LineAddress=‘16’; update KaiGuan Set Name=‘2号天井东过道灯’ where Mac=‘187ed532ac04’ and LineAddress=‘17’; update KaiGuan Set Name=‘北一门内灯’ where Mac=‘187ed532ac04’ and LineAddress=‘18’;

2 2A894 10.5,已指向服务器并重启；服务器已收到； 线路地址完整 排序5 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532a894’

update KaiGuan Set Name=‘楼道多控灯’ where Mac=‘187ed532a894’ and LineAddress=‘1’; update KaiGuan Set Name=‘北一门走廊灯’ where Mac=‘187ed532a894’ and LineAddress=‘2’; update KaiGuan Set Name=‘北一门西走廊灯’ where Mac=‘187ed532a894’ and LineAddress=‘3’; update KaiGuan Set Name=‘北一门走廊灯’ where Mac=‘187ed532a894’ and LineAddress=‘4’; update KaiGuan Set Name=‘北一门西走廊灯’ where Mac=‘187ed532a894’ and LineAddress=‘5’; update KaiGuan Set Name=‘北二门走廊反光’ where Mac=‘187ed532a894’ and LineAddress=‘6’; update KaiGuan Set Name=‘北二门走廊反光’ where Mac=‘187ed532a894’ and LineAddress=‘7’; update KaiGuan Set Name=‘北二门走廊反光’ where Mac=‘187ed532a894’ and LineAddress=‘8’; update KaiGuan Set Name=‘北二门走廊反光’ where Mac=‘187ed532a894’ and LineAddress=‘9’; update KaiGuan Set Name=‘北一门东走廊灯’ where Mac=‘187ed532a894’ and LineAddress=‘10’; update KaiGuan Set Name=‘空’ where Mac=‘187ed532a894’ and LineAddress=‘11’; update KaiGuan Set Name=‘1号天井扶梯下灯’ where Mac=‘187ed532a894’ and LineAddress=‘12’; update KaiGuan Set Name=‘1号天井上反光’ where Mac=‘187ed532a894’ and LineAddress=‘13’; update KaiGuan Set Name=‘1号天井西过道反光’ where Mac=‘187ed532a894’ and LineAddress=‘14’; update KaiGuan Set Name=‘室外西走廊中间灯’ where Mac=‘187ed532a894’ and LineAddress=‘15’; update KaiGuan Set Name=‘1号天井扶梯侧灯’ where Mac=‘187ed532a894’ and LineAddress=‘16’; update KaiGuan Set Name=‘1号天井下反光’ where Mac=‘187ed532a894’ and LineAddress=‘17’; update KaiGuan Set Name=‘1号天井西过道反光’ where Mac=‘187ed532a894’ and LineAddress=‘18’;

3 2A830 10.6， ip 134, 已指向服务器并重启； 线路地址完整 排序4 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532a830’

update KaiGuan Set Name=‘夜间照明’ where Mac=‘187ed532a830’ and LineAddress=‘1’; update KaiGuan Set Name=‘1号天井下反光’ where Mac=‘187ed532a830’ and LineAddress=‘2’; update KaiGuan Set Name=‘1号天井扶梯下灯’ where Mac=‘187ed532a830’ and LineAddress=‘3’; update KaiGuan Set Name=‘2号天井西过道反光’ where Mac=‘187ed532a830’ and LineAddress=‘4’; update KaiGuan Set Name=‘1号天井西过道反光’ where Mac=‘187ed532a830’ and LineAddress=‘5’; update KaiGuan Set Name=‘1号天井扶梯侧灯’ where Mac=‘187ed532a830’ and LineAddress=‘6’; update KaiGuan Set Name=‘空’ where Mac=‘187ed532a830’ and LineAddress=‘7’; update KaiGuan Set Name=‘2号天井西过道反光’ where Mac=‘187ed532a830’ and LineAddress=‘8’; update KaiGuan Set Name=‘1号天井上反光’ where Mac=‘187ed532a830’ and LineAddress=‘9’; update KaiGuan Set Name=‘1号天井下反光’ where Mac=‘187ed532a830’ and LineAddress=‘10’; update KaiGuan Set Name=‘北一门灯箱’ where Mac=‘187ed532a830’ and LineAddress=‘11’; update KaiGuan Set Name=‘北一门内反光’ where Mac=‘187ed532a830’ and LineAddress=‘12’; update KaiGuan Set Name=‘1号天井上反光’ where Mac=‘187ed532a830’ and LineAddress=‘13’; update KaiGuan Set Name=‘1号天井下反光’ where Mac=‘187ed532a830’ and LineAddress=‘14’; update KaiGuan Set Name=‘2号天井东过道反光’ where Mac=‘187ed532a830’ and LineAddress=‘15’; update KaiGuan Set Name=‘1号天井东过道反光’ where Mac=‘187ed532a830’ and LineAddress=‘16’; update KaiGuan Set Name=‘2号天井东过道反光’ where Mac=‘187ed532a830’ and LineAddress=‘17’; update KaiGuan Set Name=‘超市扶梯南反光’ where Mac=‘187ed532a830’ and LineAddress=‘18’;

4 2BF88 10.5,已指向服务器并重启；服务器已收到； 线路地址完整 排序3

select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed532bf88’

update KaiGuan Set Name=‘楼道声控灯’ where Mac=‘187ed532bf88’ and LineAddress=‘1’; update KaiGuan Set Name=‘1号天井上反光’ where Mac=‘187ed532bf88’ and LineAddress=‘2’; update KaiGuan Set Name=‘1号天井下反光’ where Mac=‘187ed532bf88’ and LineAddress=‘3’; update KaiGuan Set Name=‘1号天井东过道反光’ where Mac=‘187ed532bf88’ and LineAddress=‘4’; update KaiGuan Set Name=‘超市扶梯北反光’ where Mac=‘187ed532bf88’ and LineAddress=‘5’; update KaiGuan Set Name=‘1号天井下反光’ where Mac=‘187ed532bf88’ and LineAddress=‘6’; update KaiGuan Set Name=‘1号天井上反光’ where Mac=‘187ed532bf88’ and LineAddress=‘7’; update KaiGuan Set Name=‘超市扶梯反光’ where Mac=‘187ed532bf88’ and LineAddress=‘8’; update KaiGuan Set Name=‘超市扶梯反光’ where Mac=‘187ed532bf88’ and LineAddress=‘9’; update KaiGuan Set Name=‘超市扶梯反光’ where Mac=‘187ed532bf88’ and LineAddress=‘10’; update KaiGuan Set Name=‘超市扶梯反光’ where Mac=‘187ed532bf88’ and LineAddress=‘11’; update KaiGuan Set Name=‘客梯灯’ where Mac=‘187ed532bf88’ and LineAddress=‘12’; update KaiGuan Set Name=‘超市扶梯反光’ where Mac=‘187ed532bf88’ and LineAddress=‘13’; update KaiGuan Set Name=‘2号天井西过道反光’ where Mac=‘187ed532bf88’ and LineAddress=‘14’; update KaiGuan Set Name=‘2号天井上反光’ where Mac=‘187ed532bf88’ and LineAddress=‘15’; update KaiGuan Set Name=‘超市扶梯南反光’ where Mac=‘187ed532bf88’ and LineAddress=‘16’; update KaiGuan Set Name=‘2号天井下反光’ where Mac=‘187ed532bf88’ and LineAddress=‘17’;

5 28B5C，10.6， ip 172, 已指向服务器并重启； 线路地址完整 排序2 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed5328b5c’

update KaiGuan Set Name=‘楼梯声控灯’ where Mac=‘187ed5328b5c’ and LineAddress=‘1’; update KaiGuan Set Name=‘客梯反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘2’; update KaiGuan Set Name=‘客梯上反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘3’; update KaiGuan Set Name=‘2号天井上反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘4’; update KaiGuan Set Name=‘2号天井西过道反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘5’; update KaiGuan Set Name=‘2号天井下反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘6’; update KaiGuan Set Name=‘北二门内反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘7’; update KaiGuan Set Name=‘北二门灯箱’ where Mac=‘187ed5328b5c’ and LineAddress=‘8’; update KaiGuan Set Name=‘2号天井东过道反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘9’; update KaiGuan Set Name=‘2号天井扶梯灯’ where Mac=‘187ed5328b5c’ and LineAddress=‘10’; update KaiGuan Set Name=‘2号天井下反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘11’; update KaiGuan Set Name=‘2号天井上反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘12’; update KaiGuan Set Name=‘2号天井东过道反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘13’; update KaiGuan Set Name=‘2号天井西过道反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘14’; update KaiGuan Set Name=‘2号天井扶梯下灯’ where Mac=‘187ed5328b5c’ and LineAddress=‘15’; update KaiGuan Set Name=‘2号天井扶梯侧灯’ where Mac=‘187ed5328b5c’ and LineAddress=‘16’; update KaiGuan Set Name=‘2号天井东过道反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘17’; update KaiGuan Set Name=‘2号天井东过道反光’ where Mac=‘187ed5328b5c’ and LineAddress=‘18’;

6 28864，10.6， ip 176, 已指向服务器并重启； 线路地址完整 排序1

select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed5328864’

update KaiGuan Set Name=‘配电室照明’ where Mac=‘187ed5328864’ and LineAddress=‘1’; update KaiGuan Set Name=‘2号天井下反光’ where Mac=‘187ed5328864’ and LineAddress=‘2’; update KaiGuan Set Name=‘2号天井上反光’ where Mac=‘187ed5328864’ and LineAddress=‘3’; update KaiGuan Set Name=‘北一门走廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘4’; update KaiGuan Set Name=‘北一门走廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘5’; update KaiGuan Set Name=‘北一门走廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘6’; update KaiGuan Set Name=‘北一门走廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘7’; update KaiGuan Set Name=‘北一门走廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘8’;

update KaiGuan Set Name=‘北一门连廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘9’; update KaiGuan Set Name=‘北一门连廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘10’; update KaiGuan Set Name=‘北一门连廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘11’; update KaiGuan Set Name=‘北一门连廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘12’; update KaiGuan Set Name=‘北二门连廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘13’; update KaiGuan Set Name=‘北二门连廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘14’; update KaiGuan Set Name=‘北二门连廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘15’; update KaiGuan Set Name=‘北二门连廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘16’; update KaiGuan Set Name=‘北二门连廊反光’ where Mac=‘187ed5328864’ and LineAddress=‘17’;


# 二期二层A区



# 二期三层A区

2 283F0 10.6, IP是140，已指向服务器并重启； 3 2BA70 10.6, IP是75，已指向服务器并重启；


# 二期四层A区

1：29634 29634， 10.6，IP是125，已指向服务器并重启； 线路地址完整 排序6 select Mac, LineAddress, Name,DianXiangId from KaiGuan where Mac=‘187ed5329634’

update KaiGuan Set Name=‘2号西北走廊灯’ where Mac=‘187ed5329634’ and LineAddress=‘1’; update KaiGuan Set Name=‘3号西北走廊灯’ where Mac=‘187ed5329634’ and LineAddress=‘2’; update KaiGuan Set Name=‘备用’ where Mac=‘187ed5329634’ and LineAddress=‘3’; update KaiGuan Set Name=‘备用’ where Mac=‘187ed5329634’ and LineAddress=‘4’; update KaiGuan Set Name=‘西北走廊反光’ where Mac=‘187ed5329634’ and LineAddress=‘5’; update KaiGuan Set Name=‘西北走廊反光’ where Mac=‘187ed5329634’ and LineAddress=‘6’; update KaiGuan Set Name=‘西走廊灯箱’ where Mac=‘187ed5329634’ and LineAddress=‘7’; update KaiGuan Set Name=‘西北走廊反光’ where Mac=‘187ed5329634’ and LineAddress=‘8’; update KaiGuan Set Name=‘西北走廊反光’ where Mac=‘187ed5329634’ and LineAddress=‘9’; update KaiGuan Set Name=‘东走廊灯’ where Mac=‘187ed5329634’ and LineAddress=‘10’; update KaiGuan Set Name=‘东吊眉反光’ where Mac=‘187ed5329634’ and LineAddress=‘11’; update KaiGuan Set Name=‘东小圆反光’ where Mac=‘187ed5329634’ and LineAddress=‘12’; update KaiGuan Set Name=‘东小圆灯’ where Mac=‘187ed5329634’ and LineAddress=‘13’; update KaiGuan Set Name=‘东走廊反光’ where Mac=‘187ed5329634’ and LineAddress=‘14’; update KaiGuan Set Name=‘东小圆灯’ where Mac=‘187ed5329634’ and LineAddress=‘15’; update KaiGuan Set Name=‘东小圆反光’ where Mac=‘187ed5329634’ and LineAddress=‘16’;

2：29FA8 29fa8 10.6，IP是44，已指向服务器并重启；缓存没有，重启； 线路地址完整 排序5 187ed5329f

3：2C19C 2c19c, 10.6,IP是182，已指向服务器并重启； 线路地址完整 排序4 187ed532c1

4：29BE4 29be4, 10.6, IP是181，已指向服务器并重启； 线路地址完整 排序3 187ed5329b

5：28B04 28b04, 10.6,IP是178，已指向服务器并重启； 线路地址完整 排序2 187ed5328b

6: 2C2CC 2c2cc, 10.6, IP是174，已指向服务器并重启； 线路地址完整 排序1 187ed532c2


#  2020年10月5日 总结

今天把二期负一层超市和一期C区的场景都添加了。具体情况如下：

★ 二期负一层超市场景情况：

--S1区：上班8：10，下班21：30：20。其中第4排187ED532A8B0的模块，在局域网内找不到，请检查网络或重启模块。 --S2区：上班8：11，下班21：30：40 --S3区：上班8：12，下班21：31：10。其中第5排187ED532BE24模块和第6排187ED5328490模块，在局域网内找不到，请检查网络或重启模块。 --S4区：上班8：13，下班21：31：30。其中第1排187ED5328D80模块，在局域网内可以找到，但似乎没有编线路地址，请确认。 --S5区：上班8：14，下班21：31：50 --S6区：上班8：15，下班21：32：10。其中第2排187ED53291B8模块，在局域网内找不到，请检查网络或重启模块。

★ 一期C区场景情况：

--1层C区：上班8：55：40，下班21：33：40。其中第2排187ED532286C模块，在局域网内找不到，请检查网络或重启模块。 --2层C区：上班8：56：40，下班21：32：40 --3层C区：上班8：57：40，下班21：31：40 --4层C区：上班8：58：40，下班21：30：40


#  2020年10月6日 上午 汇总

--二期负一层S1区：第4排187ED532A8B0的模块，在局域网内找不到，请检查网络或重启模块。 --二期负一层S3区：其中第5排187ED532BE24模块和第6排187ED5328490模块，在局域网内找不到，请检查网络或重启模块。 --二期负一层S4区：其中第1排187ED5328D80模块，在局域网内可以找到，但似乎没有编线路地址，请确认。 --二期负一层S6区：其中第2排187ED53291B8模块，在局域网内找不到，请检查网络或重启模块。

--一期1层C区：其中第2排187ED532286C模块，在局域网内找不到，请检查网络或重启模块。


#  2020年10��6日 晚上 22：30 汇总

--二期负一层超市S3区域的第2排模块已更换

--二期负一层超市S3区域的第5排和第6排模块已添加

--二期一层A区总共6排，已添加第2排和第4排模块

具体汇总如下(汇总时间：2020年10月6日 下午 14：00)

★ 二期负一层超市：

--二期负一层S1区：开关名称已更新；场景已添加；其中，第4排187ED532A8B0的模块，在局域网内找不到，请检查网络或重启模块。

--二期负一层S2区：开关名称已更新；场景已添加；

--二期负一层S3区：开关名称已更新；场景已添加；

--二期负一层S4区：开关名称已更新；场景已添加；其中，第1排187ED5328D80模块，在局域网内可以找到，但似乎没有编线路地址，请确认。

--二期负一层S5区：开关名称已更新；场景已添加；

--二期负一层S6区：开关名称已更新；场景已添加；其中，第2排187ED53291B8模块，在局域网内找不到，请检查网络或重启模块。

★ 一期C区：

--一期1层C区：场景已添加；其中，第2排187ED532286C模块，在局域网内找不到，请检查网络或重启模块。

--一期2层C区：场景已添加；

--一期3层C区：场景已添加；

--一期4层C区：场景已添加；

★ 二期一层A区

--第1排模块号187ED532AC04：无法在局域网找到，请检查线路或重启模块。

--第2排模块号187ED532A894：已添加，已修改开关名称，未添加场景。场景需要添加吗？

--第3排模块号187ED532A830：无法在局域网找到，请检查线路或重启模块。

--第4排模块号187ED532BF88：已添加，已修改开关名称，未添加场景。场景需要添加吗？

--第5排模块号187ED5328B5C：无法在局域网找到，请检查线路或重启模块。

--第6排模块号187ED5328864：无法在局域网找到，请检查线路或重启模块。


#  2020年10月6日 晚上 22：30 汇总

2020年10月6日 晚上 23：20 汇总

一期1-4层的C区，二期负一层，二期一层A区，现在全部处理完毕。

★ 二期负一层超市：开关名称已更新，场景已添加。

★ 一期1-4层C区：开关名称已更新，场景已添加。

★ 二期一层A区：开关名称已更新，场景已添加。

★ 二期四层A区：已收到开关名称，请告诉我各排模块号。


#  2020年10月7日 早上 7：40 汇总

二期4层A区，开关和场景添加完毕。 ```