DDWiki/运维/安装/2020胶州问题汇总.md

# 2020年10月11日

二期负一层超市S4区，第6排，187ed5328d84的6，7，8号位没关
```
二期负一层超市S4区，第6排，187ed5328d84的6，7，8号位没关
--强电给的表中要求这3个线路晚上不关
```

一期一楼C区有些灯没关
```
一期一楼C区有些灯没关
-- 经确认，一期一楼C区的第2排的模块坏了，导致灯没有关。我已经通知 更换模块。
-- 胶州一期一楼C区第2排，今天晚上场景没有自动分断。发现187ed5328830模块坏了，一直显示离线。我重启了一次也没用。更换一下吧。
--场景设计上了
--查看日志 187ed5328830,线路地址
2020-10-11 21:03:42.032 [Warning] 模块号:187ed5328830,线路地址:1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,分断,来源：场景自动分断,当前队列：OCClose|1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20|10|"LogApp"
2020-10-11 21:03:42.033 [Warning] mac：187ed5328830,线路地址：1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20分断成功"LogApp"
--是否报警：离线报警
--IP是143 重启设备，重启后恢复正常，还是离线
```

一期二楼B区有些灯没关
```
一期二楼B区有些灯没关
--一期二楼B区的日志显示六排分断全部成功，可视化界面上现在显示都关了。如果还是有问题，我需要明确知道具体第几排哪些线路没关？或者明天再观察下。
--场景：
187ed5328b98,线路地址
2020-10-11 21:02:00.047 [Warning] mac：187ed5328b98,线路地址：1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16分断成功"LogApp"
187ed53298d0,线路地址
2020-10-11 21:02:01.048 [Warning] mac：187ed53298d0,线路地址：1,2,3,4,5,6,7,8分断成功"LogApp"
187ed532901c,线路地址
2020-10-11 21:02:02.049 [Warning] mac：187ed532901c,线路地址：1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16分断成功"LogApp"
187ed5329580,线路地址
2020-10-11 21:02:03.049 [Warning] mac：187ed5329580,线路地址：1,2,3,4,5,6,7分断成功"LogApp"
187ed5328790,线路地址
2020-10-11 21:02:04.050 [Warning] mac：187ed5328790,线路地址：1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16分断成功"LogApp"
187ed5323e64,线路地址
2020-10-11 21:02:05.051 [Warning] mac：187ed5323e64,线路地址：1,2,3,4,5,6,7分断成功"LogApp"
```

二期负二负三人行道照明没关
```
二期负二负三人行道照明没关
--二期负二负三层不在智能照明系统里。
```

照明上下班抽空重新排下
```
照明上下班抽空重新排下
--我把你们教会吧。这样你们随便怎么改都行。
```

二期一层A区第二排和第六排应该是连廊，不是走廊
```


第二排
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';

第六排
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';

```

# 2020年10月12日

郭：187ed5328830换成187ed531E204
```
--确定1E204的IP：203
--确定服务器指向：192.168.88.1:8080/ebx-bishop/data/carry
--登录模块，修改服务器指向，并重启。
--确认新模块缓存数据线路是否完整。1E204,缓存收到这个模块数据，但没有实时数据。要求现场重启一下。
--记录旧模块的开关编号和开关名称

select Id, Mac, LineAddress, Name, DianXiangId from KaiGuan where Mac='187ed5328830'
in ('1169','1170','1171','1172','1173','1174','1175','1176','1177','1178', '1179','1180','1181','1182','1183','1184', '1185', '1186', '1187', '1188')
没有开关名称
--记录旧模块的所在电箱：一期一层C区电箱


```

郭：二期的开关灯时间，跟一期的改成一样吧，连廊的不变  
监控室
```
已经改成和一期一样了。请尽早安排监控室人员操作培训，甲方开业我们可以支持下，但如果一直这样下去，不合理。
```

监控室:上下班分组
```
上下班已分组。上边是下班场景，下边是上班场景。

以IsSingle区分
测试：1

总共四位数
下班在前下班在后：下班2，上班1
二期在前一期在后：二期2，一期1
楼上在前楼下在后：二楼2，一楼1
区域A在前区域B在后：A是9，B是8
```

监控室：一期二楼三楼B区和C区不到点都开，四楼ABC三个区不到点都开
```
一期二楼B区，早上08:56:20自动合闸，请确认是否是这个时间？

一期二楼C区，早上08:56:40自动合闸，请确认是否是这个时间？

一期三楼B区，早上08:57:20自动合闸，请确认是否是这个时间？

一期三楼C区，早上08:57:40自动合闸，请确认是否是这个时间？

一期四楼A区，早上08:58:00自动合闸，请确认是否是这个时间？

一期四楼B区，早上08:58:20自动合闸，请确认是否是这个时间？

一期四楼C区，早上08:58:40自动合闸，请确认是否是这个时间？
```


监控室：二期超市不到点开。
```
二期超市S1区，早上08:10:00自动合闸，请确认是否是这个时间？

二期超市S2区，早上08:11:00自动合闸，请确认是否是这个时间？

二期超市S3区，早上08:12:00自动合闸，请确认是否是这个时间？

二期超市S4区，早上08:13:00自动合闸，请确认是否是这个时间？

二期超市S5区，早上08:14:00自动合闸，请确认是否是这个时间？

二期超市S6区，早上	08:15:00自动合闸，请确认是否是这个时间？
```

一期东门天井灯没到时间就亮了。
```
没有这个场景。要看具体哪条线路。请告诉是哪个区？第几排？第几个开关？
```

监控室：请注意：一期一楼C区的第2排的模块还没有恢复正常，今天晚上不会自动分断

# 2020年10月13日

郭：187ed5328830换成187ed531E204，又换回187ed5328830
--一期一楼C区的第2排的187ed5328830模块已回复正常
```
IP是156 
服务器指向是否正确：正确
服务器数据是否实时：实时的
是否有离线报警：没有离线报警
可视化界面是否正常：一期一楼C区的第2排的模块，已正常
```

监控室：
```
21:30关
二期负一层S3区
第一排187ed532c12c 5，9，13，17
第二排187ed5328658 4，8
第三排187ed532a7d4 4，8，12，16
第四排187ed532bfb8 3，7
第五排187ed532f060 3，7，11，15，18
第六排187ed532f644 2，6，7，8

二期负一层S2区
第一排187ed532a8b4 5，9，13，17
第二排187ed532bf30 4，8
第三排187ed532b794 4，8，12，16
第四排187ed532a8d4 3，7
第五排187ed532b550 3，7，11，15
第六排187ed5328ba8 2，6，8

二期负一层S1区
第一排187ed532b8b0 4，7
第二排187ed532c04c 5，9
第三排187ed532b9dc 5，9，13，17
第四排187ed532ab90 5，9
第五排187ed532a62c 3，4，11，17
第六排187ed5328f44 8

二期负一层S5区
第一排187ed532b278 5，9，13，17
第二排187ed532b940 4，8
第三排187ed532be78 4，8，12，16
第四排187ed532a054
第五排187ed532c2c4 2，6，10，14，18
第六排187ed532b424 8

二期负一层S6区
第一排187ed5329140 10，11
第二排187ed53291b8 4，7，8，9，13
第三排187ed532bef4 4，6，9

二期负一层S4区
第一排187ed5328db0 5，9，13，17
第二排187ed532ad70 4，8
第三排187ed5328fb4 4，8，12，16
第四排187ed53285a8 3，7
第五排187ed5328dc0 2，6，10，14，18
第六排187ed5328d84 6，7，8

21:00关
二期负一层S3区：
第一排187ed532c12c 1，2，3，4，6，7，8，10，11，12，14，15，16，18
第二排187ed5328658 1，2，3，5，6，7，9
第三排187ed532a7d4 1，2，3，5，6，7，9，10，11，13，14，15，17，18
第四排187ed532bfb8 1，2，4，5，6，8，9
第五排187ed532f060 1，2，4，5，6，8，9，10，12，13，14，16，17
第六排187ed532f644 1，3，4，5

二期负一层S2区
第一排187ed532a8b4
第二排187ed532bf30
第三排187ed532b794
第四排187ed532a8d4
第五排187ed532b550
第六排187ed5328ba8

目前所有的都是21：30左右关
把所有的都设置成21：00关
把21：30的排除出来
更改场景名称
```

二期天井照明没开
```
请告诉我是哪期哪层哪区哪排几号位的空开？
``` 

# 2020年10月14日

梁：一期一楼C区可视化关了，实际好多没关
```
可视化关了吗？--关了
187ed53257a8,线路地址
187ed53257a8,线路地址：1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20分断成功
187ed5328830,线路地址
2020-10-14 21:03:42.066 [Warning] mac：187ed5328830,线路地址：1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20分断成功
187ed53287d8,线路地址
2020-10-14 21:03:41.065 [Warning] mac：187ed53287d8,线路地址：1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20分断成功"LogApp"
```

梁：可视化界面反应慢的问题
```
明天改良一下
```

二期4层A区模块，现在都离线。
```
187ed5329634 2020-10-12 16:09:38
187ed5329fa8 2020-10-12 16:06:54
187ed532c19c 2020-10-12 16:09:38
187ed5329be4 2020-10-12 16:05:16
187ed5328b04 2020-10-12 16:09:07
187ed532c2cc 2020-10-12 16:09:33
```

# 2020年10月15日

二期4层A区模块，是否正常
```
187ed5329634 2020-10-12 16:09:38
187ed5329fa8 2020-10-12 16:06:54
187ed532c19c 2020-10-12 16:09:38
187ed5329be4 2020-10-12 16:05:16
187ed5328b04 2020-10-12 16:09:07
187ed532c2cc 2020-10-12 16:09:33

所有模块正常。目前报警是手动分断报警。
```


1期1-4楼改名称和场景时间。
```
有些开关我标上时间了，没标的就是8点55开9点关。麻烦你设置一下
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532492c' 

update KaiGuan Set Name='', Code='1' where Mac='187ed532492c' and LineAddress='1';
update KaiGuan Set Name='', Code='2' where Mac='187ed532492c' and LineAddress='2';
update KaiGuan Set Name='', Code='3' where Mac='187ed532492c' and LineAddress='3';
update KaiGuan Set Name='', Code='4' where Mac='187ed532492c' and LineAddress='4';
update KaiGuan Set Name='', Code='5' where Mac='187ed532492c' and LineAddress='5';
update KaiGuan Set Name='', Code='6' where Mac='187ed532492c' and LineAddress='6';
update KaiGuan Set Name='', Code='7' where Mac='187ed532492c' and LineAddress='7';
update KaiGuan Set Name='', Code='8' where Mac='187ed532492c' and LineAddress='8';
update KaiGuan Set Name='', Code='9' where Mac='187ed532492c' and LineAddress='9';
update KaiGuan Set Name='', Code='10' where Mac='187ed532492c' and LineAddress='10';
update KaiGuan Set Name='', Code='11' where Mac='187ed532492c' and LineAddress='11';
update KaiGuan Set Name='', Code='12' where Mac='187ed532492c' and LineAddress='12';
update KaiGuan Set Name='', Code='13' where Mac='187ed532492c' and LineAddress='13';
update KaiGuan Set Name='', Code='14' where Mac='187ed532492c' and LineAddress='14';
update KaiGuan Set Name='', Code='15' where Mac='187ed532492c' and LineAddress='15';
update KaiGuan Set Name='', Code='16' where Mac='187ed532492c' and LineAddress='16';
update KaiGuan Set Name='', Code='17' where Mac='187ed532492c' and LineAddress='17';
update KaiGuan Set Name='', Code='18' where Mac='187ed532492c' and LineAddress='18';
update KaiGuan Set Name='', Code='19' where Mac='187ed532492c' and LineAddress='19';
update KaiGuan Set Name='', Code='20' where Mac='187ed532492c' and LineAddress='20';

1层A区
第1排187ed532492c(17) 1不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532492c' 
update KaiGuan Set Name='插座', Code='1' where Mac='187ed532492c' and LineAddress='1';
update KaiGuan Set Name='筒灯',Code='2' where Mac='187ed532492c' and LineAddress='2';
update KaiGuan Set Name='卫生间照明', Code='3' where Mac='187ed532492c' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed532492c' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed532492c' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed532492c' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed532492c' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed532492c' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed532492c' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed532492c' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed532492c' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed532492c' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed532492c' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed532492c' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed532492c' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed532492c' and LineAddress='16';
update KaiGuan Set Name='筒灯', Code='17' where Mac='187ed532492c' and LineAddress='17';
update KaiGuan Set Name='筒灯', Code='18' where Mac='187ed532492c' and LineAddress='18';

第2排187ed5329aec(9) 1,6,7,8,9不管
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329aec' 
update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329aec' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5329aec' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5329aec' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5329aec' and LineAddress='4';
update KaiGuan Set Name='灯带', Code='5' where Mac='187ed5329aec' and LineAddress='5';
update KaiGuan Set Name='中空地插', Code='6' where Mac='187ed5329aec' and LineAddress='6';
update KaiGuan Set Name='插座', Code='7' where Mac='187ed5329aec' and LineAddress='7';
update KaiGuan Set Name='中空地插', Code='8' where Mac='187ed5329aec' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed5329aec' and LineAddress='9';

第3排187ed53218f4(17) 1不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53218f4'
update KaiGuan Set Name='卫生间插座', Code='1' where Mac='187ed53218f4' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed53218f4' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed53218f4' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed53218f4' and LineAddress='4';
update KaiGuan Set Name='灯带', Code='5' where Mac='187ed53218f4' and LineAddress='5';
update KaiGuan Set Name='灯带', Code='6' where Mac='187ed53218f4' and LineAddress='6';
update KaiGuan Set Name='灯带', Code='7' where Mac='187ed53218f4' and LineAddress='7';
update KaiGuan Set Name='灯带', Code='8' where Mac='187ed53218f4' and LineAddress='8';
update KaiGuan Set Name='灯带', Code='9' where Mac='187ed53218f4' and LineAddress='9';
update KaiGuan Set Name='灯带', Code='10' where Mac=187ed53218f4'' and LineAddress='10';
update KaiGuan Set Name='灯带', Code='11' where Mac=187ed53218f4' and LineAddress='11';
update KaiGuan Set Name='造型内小吊灯', Code='12' where Mac=187ed53218f4' and LineAddress='12';
update KaiGuan Set Name='灯带', Code='13' where Mac=187ed53218f4' and LineAddress='13';
update KaiGuan Set Name='灯带', Code='14' where Mac=187ed53218f4' and LineAddress='14';
update KaiGuan Set Name='灯带', Code='15' where Mac=187ed53218f4' and LineAddress='15';
update KaiGuan Set Name='灯带', Code='16' where Mac=187ed53218f4' and LineAddress='16';
update KaiGuan Set Name='造型内小吊灯', Code='17' where Mac=187ed53218f4' and LineAddress='17';


第4排187ed53297f0(9) 1,7,8,9
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53297f0'
update KaiGuan Set Name='卫生间插座2', Code='1' where Mac='187ed53297f0' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed53297f0' and LineAddress='2';
update KaiGuan Set Name='天井竖灯带', Code='3' where Mac='187ed53297f0' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed53297f0' and LineAddress='4';
update KaiGuan Set Name='天井竖灯带', Code='5' where Mac='187ed53297f0' and LineAddress='5';
update KaiGuan Set Name='灯带', Code='6' where Mac='187ed53297f0' and LineAddress='6';
update KaiGuan Set Name='卫生间插座3', Code='7' where Mac='187ed53297f0' and LineAddress='7';
update KaiGuan Set Name='卫生间插座4', Code='8' where Mac='187ed53297f0' and LineAddress='8';
update KaiGuan Set Name='卫生间插座5', Code='9' where Mac='187ed53297f0' and LineAddress='9';


第5排187ed53298b0(17) 1不关
8 17-21
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53298b0'
update KaiGuan Set Name='卫生间插座6', Code='1' where Mac='187ed53298b0' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed53298b0' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed53298b0' and LineAddress='3';
update KaiGuan Set Name='空', Code='4' where Mac='187ed53298b0' and LineAddress='4';
update KaiGuan Set Name='', Code='5' where Mac='187ed53298b0' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed53298b0' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed53298b0' and LineAddress='7';
update KaiGuan Set Name='南雨棚筒灯', Code='8' where Mac='187ed53298b0' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed53298b0' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed53298b0' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed53298b0' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed53298b0' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed53298b0' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed53298b0' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed53298b0' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed53298b0' and LineAddress='16';
update KaiGuan Set Name='卫生间照明2', Code='17' where Mac='187ed53298b0' and LineAddress='17';

第6排187ed5328b40(9) 1,7,8,9不关

select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5328b40'
update KaiGuan Set Name='插座', Code='1' where Mac='187ed5328b40' and LineAddress='1';
update KaiGuan Set Name='天井灯槽灯带', Code='2' where Mac='187ed5328b40' and LineAddress='2';
update KaiGuan Set Name='天井灯槽灯带备', Code='3' where Mac='187ed5328b40' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5328b40' and LineAddress='4';
update KaiGuan Set Name='', Code='5' where Mac='187ed5328b40' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5328b40' and LineAddress='6';
update KaiGuan Set Name='插座', Code='7' where Mac='187ed5328b40' and LineAddress='7';
update KaiGuan Set Name='插座', Code='8' where Mac='187ed5328b40' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed5328b40' and LineAddress='9';

1层B区
第 1 排 (mac: 187ed5324c78) 1不关
16-19 17-21点关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5324c78'
update KaiGuan Set Name='插座', Code='1' where Mac='187ed5324c78' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5324c78' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5324c78' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5324c78' and LineAddress='4';
update KaiGuan Set Name='', Code='5' where Mac='187ed5324c78' and LineAddress='5';
update KaiGuan Set Name='', Code='6' where Mac='187ed5324c78' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5324c78' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5324c78' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed5324c78' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed5324c78' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed5324c78' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed5324c78' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed5324c78' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed5324c78' and LineAddress='14';
update KaiGuan Set Name='灯带', Code='15' where Mac='187ed5324c78' and LineAddress='15';
update KaiGuan Set Name='东雨棚灯带1', Code='16' where Mac='187ed5324c78' and LineAddress='16';
update KaiGuan Set Name='东雨棚灯带2', Code='17' where Mac='187ed5324c78' and LineAddress='17';
update KaiGuan Set Name='东雨棚筒灯1', Code='18' where Mac='187ed5324c78' and LineAddress='18';
update KaiGuan Set Name='东雨棚筒灯2', Code='19' where Mac='187ed5324c78' and LineAddress='19';
update KaiGuan Set Name='轨道灯', Code='20' where Mac='187ed5324c78' and LineAddress='20';


第 2 排 (mac: 187ed53295f8) 1,8不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53295f8'
update KaiGuan Set Name='插座', Code='1' where Mac='187ed53295f8' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed53295f8' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed53295f8' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed53295f8' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed53295f8' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed53295f8' and LineAddress='6';
update KaiGuan Set Name='灯带', Code='7' where Mac='187ed53295f8' and LineAddress='7';
update KaiGuan Set Name='插座', Code='8' where Mac='187ed53295f8' and LineAddress='8';
update KaiGuan Set Name='2', Code='9' where Mac='187ed53295f8' and LineAddress='9';
update KaiGuan Set Name='3', Code='10' where Mac='187ed53295f8' and LineAddress='10';

第 3 排 (mac: 187ed5327ddc) 1不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5327ddc'
update KaiGuan Set Name='插座', Code='1' where Mac='187ed5327ddc' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5327ddc' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5327ddc' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5327ddc' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5327ddc' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5327ddc' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5327ddc' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5327ddc' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed5327ddc' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed5327ddc' and LineAddress='10';
update KaiGuan Set Name='灯带', Code='11' where Mac='187ed5327ddc' and LineAddress='11';
update KaiGuan Set Name='天井竖灯带1主1备', Code='12' where Mac='187ed5327ddc' and LineAddress='12';
update KaiGuan Set Name='天井灯槽灯带1主1备', Code='13' where Mac='187ed5327ddc' and LineAddress='13';
update KaiGuan Set Name='', Code='14' where Mac='187ed5327ddc' and LineAddress='14';
update KaiGuan Set Name='灯带', Code='15' where Mac='187ed5327ddc' and LineAddress='15';
update KaiGuan Set Name='灯带', Code='16' where Mac='187ed5327ddc' and LineAddress='16';
update KaiGuan Set Name='灯带', Code='17' where Mac='187ed5327ddc' and LineAddress='17';
update KaiGuan Set Name='灯带', Code='18' where Mac='187ed5327ddc' and LineAddress='18';
update KaiGuan Set Name='灯带', Code='19' where Mac='187ed5327ddc' and LineAddress='19';
update KaiGuan Set Name='筒灯', Code='20' where Mac='187ed5327ddc' and LineAddress='20';

第 4 排 (mac: 187ed5328f84) 1,8,9不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5328f84'
update KaiGuan Set Name='插座', Code='1' where Mac='187ed5328f84' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed5328f84' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed5328f84' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed5328f84' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5328f84' and LineAddress='5';
update KaiGuan Set Name='灯带', Code='6' where Mac='187ed5328f84' and LineAddress='6';
update KaiGuan Set Name='灯带', Code='7' where Mac='187ed5328f84' and LineAddress='7';
update KaiGuan Set Name='插座', Code='8' where Mac='187ed5328f84' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed5328f84' and LineAddress='9';
update KaiGuan Set Name='插座', Code='10' where Mac='187ed5328f84' and LineAddress='10';

第 5 排 (mac: 187ed5322488) 
12，13，19 17-21点关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5322488'

update KaiGuan Set Name='灯箱', Code='1' where Mac='187ed5322488' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed5322488' and LineAddress='2';
update KaiGuan Set Name='', Code='3' where Mac='187ed5322488' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed5322488' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5322488' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5322488' and LineAddress='6';
update KaiGuan Set Name='灯带', Code='7' where Mac='187ed5322488' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5322488' and LineAddress='8';
update KaiGuan Set Name='', Code='9' where Mac='187ed5322488' and LineAddress='9';
update KaiGuan Set Name='灯带', Code='10' where Mac='187ed5322488' and LineAddress='10';
update KaiGuan Set Name='柱子灯带', Code='11' where Mac='187ed5322488' and LineAddress='11';
update KaiGuan Set Name='西雨棚筒灯1', Code='12' where Mac='187ed5322488' and LineAddress='12';
update KaiGuan Set Name='西雨棚筒灯2', Code='13' where Mac='187ed5322488' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed5322488' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed5322488' and LineAddress='15';
update KaiGuan Set Name='灯带', Code='16' where Mac='187ed5322488' and LineAddress='16';
update KaiGuan Set Name='灯带', Code='17' where Mac='187ed5322488' and LineAddress='17';
update KaiGuan Set Name='筒灯', Code='18' where Mac='187ed5322488' and LineAddress='18';
update KaiGuan Set Name='西雨棚灯带1', Code='19' where Mac='187ed5322488' and LineAddress='19';
update KaiGuan Set Name='筒灯', Code='20' where Mac='187ed5322488' and LineAddress='20';


第 6 排 (mac: 187ed53252e0) 1，9不关
8 17点-21点
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53252e0'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed53252e0' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed53252e0' and LineAddress='2';
update KaiGuan Set Name='', Code='3' where Mac='187ed53252e0' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed53252e0' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed53252e0' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed53252e0' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed53252e0' and LineAddress='7';
update KaiGuan Set Name='雨棚灯带2', Code='8' where Mac='187ed53252e0' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed53252e0' and LineAddress='9';
update KaiGuan Set Name='2', Code='10' where Mac='187ed53252e0' and LineAddress='10';

1层C区
第 1 排 (mac: 187ed53257a8)  18，19，20不关
2，3，4，5，6 17点--21点
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53257a8'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed53257a8' and LineAddress='1';
update KaiGuan Set Name='KTV电梯厅灯带', Code='2' where Mac='187ed53257a8' and LineAddress='2';
update KaiGuan Set Name='KTV电梯厅筒灯', Code='3' where Mac='187ed53257a8' and LineAddress='3';
update KaiGuan Set Name='KTV电梯厅灯箱', Code='4' where Mac='187ed53257a8' and LineAddress='4';
update KaiGuan Set Name='KTV电梯厅筒灯', Code='5' where Mac='187ed53257a8' and LineAddress='5';
update KaiGuan Set Name='KTV电梯厅灯带', Code='6' where Mac='187ed53257a8' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed53257a8' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed53257a8' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed53257a8' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed53257a8' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed53257a8' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed53257a8' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed53257a8' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed53257a8' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed53257a8' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed53257a8' and LineAddress='16';
update KaiGuan Set Name='筒灯', Code='17' where Mac='187ed53257a8' and LineAddress='17';
update KaiGuan Set Name='插座', Code='18' where Mac='187ed53257a8' and LineAddress='18';
update KaiGuan Set Name='插座', Code='19' where Mac='187ed53257a8' and LineAddress='19';
update KaiGuan Set Name='插座', Code='20' where Mac='187ed53257a8' and LineAddress='20';
第 2 排 (mac: 187ed5328830) 1，18，19不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5328830'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5328830' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5328830' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5328830' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5328830' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5328830' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5328830' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5328830' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5328830' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed5328830' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed5328830' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed5328830' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed5328830' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed5328830' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed5328830' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed5328830' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed5328830' and LineAddress='16';
update KaiGuan Set Name='筒灯', Code='17' where Mac='187ed5328830' and LineAddress='17';
update KaiGuan Set Name='插座', Code='18' where Mac='187ed5328830' and LineAddress='18';
update KaiGuan Set Name='插座', Code='19' where Mac='187ed5328830' and LineAddress='19';
update KaiGuan Set Name='筒灯', Code='20' where Mac='187ed5328830' and LineAddress='20';
第 3 排 (mac: 187ed53287d8) 1，19不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53287d8'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed53287d8' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed53287d8' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed53287d8' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed53287d8' and LineAddress='4';
update KaiGuan Set Name='灯带', Code='5' where Mac='187ed53287d8' and LineAddress='5';
update KaiGuan Set Name='灯带', Code='6' where Mac='187ed53287d8' and LineAddress='6';
update KaiGuan Set Name='灯带', Code='7' where Mac='187ed53287d8' and LineAddress='7';
update KaiGuan Set Name='灯带', Code='8' where Mac='187ed53287d8' and LineAddress='8';
update KaiGuan Set Name='天井灯槽灯带', Code='9' where Mac='187ed53287d8' and LineAddress='9';
update KaiGuan Set Name='天井竖灯带', Code='10' where Mac='187ed53287d8' and LineAddress='10';
update KaiGuan Set Name='灯带', Code='11' where Mac='187ed53287d8' and LineAddress='11';
update KaiGuan Set Name='灯带', Code='12' where Mac='187ed53287d8' and LineAddress='12';
update KaiGuan Set Name='灯带', Code='13' where Mac='187ed53287d8' and LineAddress='13';
update KaiGuan Set Name='灯带', Code='14' where Mac='187ed53287d8' and LineAddress='14';
update KaiGuan Set Name='灯带', Code='15' where Mac='187ed53287d8' and LineAddress='15';
update KaiGuan Set Name='灯带', Code='16' where Mac='187ed53287d8' and LineAddress='16';
update KaiGuan Set Name='灯带', Code='17' where Mac='187ed53287d8' and LineAddress='17';
update KaiGuan Set Name='灯带', Code='18' where Mac='187ed53287d8' and LineAddress='18';
update KaiGuan Set Name='插座', Code='19' where Mac='187ed53287d8' and LineAddress='19';
update KaiGuan Set Name='筒灯', Code='20' where Mac='187ed53287d8' and LineAddress='20';

2层A区
第 1 排 (mac: 187ed5329a0c) 1不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329a0c'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329a0c' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed5329a0c' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5329a0c' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5329a0c' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5329a0c' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5329a0c' and LineAddress='6';
update KaiGuan Set Name='布衣原色射灯+筒灯', Code='7' where Mac='187ed5329a0c' and LineAddress='7';
update KaiGuan Set Name='灯带', Code='8' where Mac='187ed5329a0c' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed5329a0c' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed5329a0c' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed5329a0c' and LineAddress='11';
update KaiGuan Set Name='灯带', Code='12' where Mac='187ed5329a0c' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed5329a0c' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed5329a0c' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed5329a0c' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed5329a0c' and LineAddress='16';
update KaiGuan Set Name='灯带', Code='17' where Mac='187ed5329a0c' and LineAddress='17';
第 2 排 (mac: 187ed53287f8) 1，4，5，6，7，8，9不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53287f8'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed53287f8' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed53287f8' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed53287f8' and LineAddress='3';
update KaiGuan Set Name='轨道灯', Code='4' where Mac='187ed53287f8' and LineAddress='4';
update KaiGuan Set Name='轨道灯', Code='5' where Mac='187ed53287f8' and LineAddress='5';
update KaiGuan Set Name='插座', Code='6' where Mac='187ed53287f8' and LineAddress='6';
update KaiGuan Set Name='插座', Code='7' where Mac='187ed53287f8' and LineAddress='7';
update KaiGuan Set Name='插座', Code='8' where Mac='187ed53287f8' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed53287f8' and LineAddress='9';

第 3 排 (mac: 187ed5324fac) 1，17不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5324fac'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5324fac' and LineAddress='1';
update KaiGuan Set Name='', Code='2' where Mac='187ed5324fac' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed5324fac' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed5324fac' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5324fac' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5324fac' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5324fac' and LineAddress='7';
update KaiGuan Set Name='', Code='8' where Mac='187ed5324fac' and LineAddress='8';
update KaiGuan Set Name='造型内小吊灯', Code='9' where Mac='187ed5324fac' and LineAddress='9';
update KaiGuan Set Name='灯带', Code='10' where Mac='187ed5324fac' and LineAddress='10';
update KaiGuan Set Name='灯带', Code='11' where Mac='187ed5324fac' and LineAddress='11';
update KaiGuan Set Name='灯带', Code='12' where Mac='187ed5324fac' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed5324fac' and LineAddress='13';
update KaiGuan Set Name='灯带', Code='14' where Mac='187ed5324fac' and LineAddress='14';
update KaiGuan Set Name='灯带', Code='15' where Mac='187ed5324fac' and LineAddress='15';
update KaiGuan Set Name='灯带', Code='16' where Mac='187ed5324fac' and LineAddress='16';
update KaiGuan Set Name='灯带', Code='17' where Mac='187ed5324fac' and LineAddress='17';


第 4 排 (mac: 187ed5329c44) 1，5，6，7，8，9不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329c44'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329c44' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5329c44' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5329c44' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5329c44' and LineAddress='4';
update KaiGuan Set Name='插座', Code='5' where Mac='187ed5329c44' and LineAddress='5';
update KaiGuan Set Name='插座', Code='6' where Mac='187ed5329c44' and LineAddress='6';
update KaiGuan Set Name='插座', Code='7' where Mac='187ed5329c44' and LineAddress='7';
update KaiGuan Set Name='插座', Code='8' where Mac='187ed5329c44' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed5329c44' and LineAddress='9';

第 5 排 (mac: 187ed5325014) 1，15不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5325014'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5325014' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5325014' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5325014' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5325014' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5325014' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5325014' and LineAddress='6';
update KaiGuan Set Name='灯带', Code='7' where Mac='187ed5325014' and LineAddress='7';
update KaiGuan Set Name='灯带', Code='8' where Mac='187ed5325014' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed5325014' and LineAddress='9';
update KaiGuan Set Name='天井灯槽内灯带1主1备', Code='10' where Mac='187ed5325014' and LineAddress='10';
update KaiGuan Set Name='灯带', Code='11' where Mac='187ed5325014' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed5325014' and LineAddress='12';
update KaiGuan Set Name='天井竖灯带1主1备', Code='13' where Mac='187ed5325014' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed5325014' and LineAddress='14';
update KaiGuan Set Name='轨道灯', Code='15' where Mac='187ed5325014' and LineAddress='15';
update KaiGuan Set Name='灯带', Code='16' where Mac='187ed5325014' and LineAddress='16';
update KaiGuan Set Name='灯带', Code='17' where Mac='187ed5325014' and LineAddress='17';

第 6 排 (mac: 187ed532a190) 1，5不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532a190'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed532a190' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed532a190' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed532a190' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed532a190' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed532a190' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed532a190' and LineAddress='6';
update KaiGuan Set Name='灯带', Code='7' where Mac='187ed532a190' and LineAddress='7';
update KaiGuan Set Name='灯带', Code='8' where Mac='187ed532a190' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed532a190' and LineAddress='9';

2层B区
第 1 排 (mac: 187ed5328b98) 1
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5328b98'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5328b98' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5328b98' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5328b98' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5328b98' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5328b98' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5328b98' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5328b98' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5328b98' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed5328b98' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed5328b98' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed5328b98' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed5328b98' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed5328b98' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed5328b98' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed5328b98' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed5328b98' and LineAddress='16';

第 2 排 (mac: 187ed53298d0) 1，5，6，7，8
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53298d0'


update KaiGuan Set Name='插座', Code='1' where Mac='187ed53298d0' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed53298d0' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed53298d0' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed53298d0' and LineAddress='4';
update KaiGuan Set Name='卫生间插座1', Code='5' where Mac='187ed53298d0' and LineAddress='5';
update KaiGuan Set Name='卫生间插座2', Code='6' where Mac='187ed53298d0' and LineAddress='6';
update KaiGuan Set Name='卫生间插座3', Code='7' where Mac='187ed53298d0' and LineAddress='7';
update KaiGuan Set Name='卫生间插座4', Code='8' where Mac='187ed53298d0' and LineAddress='8';


第 3 排 (mac: 187ed532901c)
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532901c'
update KaiGuan Set Name='灯箱', Code='1' where Mac='187ed532901c' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed532901c' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed532901c' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed532901c' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed532901c' and LineAddress='5';
update KaiGuan Set Name='灯带', Code='6' where Mac='187ed532901c' and LineAddress='6';
update KaiGuan Set Name='灯带', Code='7' where Mac='187ed532901c' and LineAddress='7';
update KaiGuan Set Name='灯带', Code='8' where Mac='187ed532901c' and LineAddress='8';
update KaiGuan Set Name='灯带', Code='9' where Mac='187ed532901c' and LineAddress='9';
update KaiGuan Set Name='天井灯槽灯带', Code='10' where Mac='187ed532901c' and LineAddress='10';
update KaiGuan Set Name='灯带', Code='11' where Mac='187ed532901c' and LineAddress='11';
update KaiGuan Set Name='灯带', Code='12' where Mac='187ed532901c' and LineAddress='12';
update KaiGuan Set Name='天井竖灯带', Code='13' where Mac='187ed532901c' and LineAddress='13';
update KaiGuan Set Name='天井竖灯带备', Code='14' where Mac='187ed532901c' and LineAddress='14';
update KaiGuan Set Name='天井灯槽内灯带(备用)', Code='15' where Mac='187ed532901c' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed532901c' and LineAddress='16';

第 4 排 (mac: 187ed5329580) 1，4，5
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329580'

update KaiGuan Set Name='西卫插座1', Code='1' where Mac='187ed5329580' and LineAddress='1';
update KaiGuan Set Name='西卫照明1', Code='2' where Mac='187ed5329580' and LineAddress='2';
update KaiGuan Set Name='西卫照明2', Code='3' where Mac='187ed5329580' and LineAddress='3';
update KaiGuan Set Name='西卫插座2', Code='4' where Mac='187ed5329580' and LineAddress='4';
update KaiGuan Set Name='插座', Code='5' where Mac='187ed5329580' and LineAddress='5';
update KaiGuan Set Name='2', Code='6' where Mac='187ed5329580' and LineAddress='6';
update KaiGuan Set Name='3', Code='7' where Mac='187ed5329580' and LineAddress='7';

第 5 排 (mac: 187ed5328790) 1
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5328790'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5328790' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed5328790' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed5328790' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed5328790' and LineAddress='4';
update KaiGuan Set Name='灯带', Code='5' where Mac='187ed5328790' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5328790' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5328790' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5328790' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed5328790' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed5328790' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed5328790' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed5328790' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed5328790' and LineAddress='13';
update KaiGuan Set Name='卫生间照明1', Code='14' where Mac='187ed5328790' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed5328790' and LineAddress='15';
update KaiGuan Set Name='', Code='16' where Mac='187ed5328790' and LineAddress='16';


第 6 排 (mac: 187ed5323e64) 1，4
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5323e64'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5323e64' and LineAddress='1';
update KaiGuan Set Name='卫生间照明2', Code='2' where Mac='187ed5323e64' and LineAddress='2';
update KaiGuan Set Name='西卫筒灯', Code='3' where Mac='187ed5323e64' and LineAddress='3';
update KaiGuan Set Name='插座', Code='4' where Mac='187ed5323e64' and LineAddress='4';
update KaiGuan Set Name='2', Code='5' where Mac='187ed5323e64' and LineAddress='5';
update KaiGuan Set Name='3', Code='6' where Mac='187ed5323e64' and LineAddress='6';
update KaiGuan Set Name='4', Code='7' where Mac='187ed5323e64' and LineAddress='7';

2层C区
第 1 排 (mac: 187ed5329b80) 1，15，16，17，18不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329b80'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329b80' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5329b80' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5329b80' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5329b80' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5329b80' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5329b80' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5329b80' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5329b80' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed5329b80' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed5329b80' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed5329b80' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed5329b80' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed5329b80' and LineAddress='13';
update KaiGuan Set Name='灯带', Code='14' where Mac='187ed5329b80' and LineAddress='14';
update KaiGuan Set Name='插座', Code='15' where Mac='187ed5329b80' and LineAddress='15';
update KaiGuan Set Name='插座', Code='16' where Mac='187ed5329b80' and LineAddress='16';
update KaiGuan Set Name='插座', Code='17' where Mac='187ed5329b80' and LineAddress='17';
update KaiGuan Set Name='插座', Code='18' where Mac='187ed5329b80' and LineAddress='18';

第 2 排 (mac: 187ed532570c) 1，16，17，18不关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532570c'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed532570c' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed532570c' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed532570c' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed532570c' and LineAddress='4';
update KaiGuan Set Name='灯带', Code='5' where Mac='187ed532570c' and LineAddress='5';
update KaiGuan Set Name='灯带', Code='6' where Mac='187ed532570c' and LineAddress='6';
update KaiGuan Set Name='天井灯槽灯带1主1备', Code='7' where Mac='187ed532570c' and LineAddress='7';
update KaiGuan Set Name='天井竖灯带主', Code='8' where Mac='187ed532570c' and LineAddress='8';
update KaiGuan Set Name='天井竖灯带备', Code='9' where Mac='187ed532570c' and LineAddress='9';
update KaiGuan Set Name='灯带', Code='10' where Mac='187ed532570c' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed532570c' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed532570c' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed532570c' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed532570c' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed532570c' and LineAddress='15';
update KaiGuan Set Name='插座', Code='16' where Mac='187ed532570c' and LineAddress='16';
update KaiGuan Set Name='插座', Code='17' where Mac='187ed532570c' and LineAddress='17';


第 3 排 (mac: 187ed532a084) 1，16，17，18不关
7，8，9，10 17点-21点关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532a084'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed532a084' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed532a084' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed532a084' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed532a084' and LineAddress='4';
update KaiGuan Set Name='照明备', Code='5' where Mac='187ed532a084' and LineAddress='5';
update KaiGuan Set Name='照明备', Code='6' where Mac='187ed532a084' and LineAddress='6';
update KaiGuan Set Name='北雨棚筒灯1', Code='7' where Mac='187ed532a084' and LineAddress='7';
update KaiGuan Set Name='北雨棚筒灯2', Code='8' where Mac='187ed532a084' and LineAddress='8';
update KaiGuan Set Name='北雨棚灯带1', Code='9' where Mac='187ed532a084' and LineAddress='9';
update KaiGuan Set Name='北雨棚灯带2', Code='10' where Mac='187ed532a084' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed532a084' and LineAddress='11';
update KaiGuan Set Name='灯带', Code='12' where Mac='187ed532a084' and LineAddress='12';
update KaiGuan Set Name='灯箱', Code='13' where Mac='187ed532a084' and LineAddress='13';
update KaiGuan Set Name='灯箱', Code='14' where Mac='187ed532a084' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed532a084' and LineAddress='15';
update KaiGuan Set Name='插座', Code='16' where Mac='187ed532a084' and LineAddress='16';
update KaiGuan Set Name='插座', Code='17' where Mac='187ed532a084' and LineAddress='17';


3层A区
第 1 排 (mac: 187ed53289c4) 1
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53289c4'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed53289c4' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed53289c4' and LineAddress='2';
update KaiGuan Set Name='小吊灯', Code='3' where Mac='187ed53289c4' and LineAddress='3';
update KaiGuan Set Name='柱子灯带', Code='4' where Mac='187ed53289c4' and LineAddress='4';
update KaiGuan Set Name='小吊灯', Code='5' where Mac='187ed53289c4' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed53289c4' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed53289c4' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed53289c4' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed53289c4' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed53289c4' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed53289c4' and LineAddress='11';
update KaiGuan Set Name='', Code='12' where Mac='187ed53289c4' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed53289c4' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed53289c4' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed53289c4' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed53289c4' and LineAddress='16';

第 2 排 (mac: 187ed5329e3c) 1
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329e3c'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329e3c' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5329e3c' and LineAddress='2';
update KaiGuan Set Name='小吊灯', Code='3' where Mac='187ed5329e3c' and LineAddress='3';
update KaiGuan Set Name='柱子灯带', Code='4' where Mac='187ed5329e3c' and LineAddress='4';
update KaiGuan Set Name='小吊灯', Code='5' where Mac='187ed5329e3c' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5329e3c' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5329e3c' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5329e3c' and LineAddress='8';

第 3 排 (mac: 187ed5329af8) 1
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329af8'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329af8' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5329af8' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5329af8' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5329af8' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5329af8' and LineAddress='5';
update KaiGuan Set Name='灯带', Code='6' where Mac='187ed5329af8' and LineAddress='6';
update KaiGuan Set Name='', Code='7' where Mac='187ed5329af8' and LineAddress='7';
update KaiGuan Set Name='灯带', Code='8' where Mac='187ed5329af8' and LineAddress='8';
update KaiGuan Set Name='灯带', Code='9' where Mac='187ed5329af8' and LineAddress='9';
update KaiGuan Set Name='灯带', Code='10' where Mac='187ed5329af8' and LineAddress='10';
update KaiGuan Set Name='灯带', Code='11' where Mac='187ed5329af8' and LineAddress='11';
update KaiGuan Set Name='灯带', Code='12' where Mac='187ed5329af8' and LineAddress='12';
update KaiGuan Set Name='灯带', Code='13' where Mac='187ed5329af8' and LineAddress='13';
update KaiGuan Set Name='灯带', Code='14' where Mac='187ed5329af8' and LineAddress='14';
update KaiGuan Set Name='灯带', Code='15' where Mac='187ed5329af8' and LineAddress='15';
update KaiGuan Set Name='灯带', Code='16' where Mac='187ed5329af8' and LineAddress='16';

第 4 排 (mac: 187ed5324960) 1
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5324960'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5324960' and LineAddress='1';
update KaiGuan Set Name='天井竖灯带主天井灯槽灯带备用', Code='2' where Mac='187ed5324960' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed5324960' and LineAddress='3';

第 5 排 (mac: 187ed5324284) 1
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5324284'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5324284' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed5324284' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed5324284' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5324284' and LineAddress='4';
update KaiGuan Set Name='', Code='5' where Mac='187ed5324284' and LineAddress='5';
update KaiGuan Set Name='', Code='6' where Mac='187ed5324284' and LineAddress='6';
update KaiGuan Set Name='', Code='7' where Mac='187ed5324284' and LineAddress='7';
update KaiGuan Set Name='', Code='8' where Mac='187ed5324284' and LineAddress='8';
update KaiGuan Set Name='灯带', Code='9' where Mac='187ed5324284' and LineAddress='9';
update KaiGuan Set Name='', Code='10' where Mac='187ed5324284' and LineAddress='10';
update KaiGuan Set Name='', Code='11' where Mac='187ed5324284' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed5324284' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed5324284' and LineAddress='13';
update KaiGuan Set Name='', Code='14' where Mac='187ed5324284' and LineAddress='14';
update KaiGuan Set Name='天井竖灯带备用', Code='15' where Mac='187ed5324284' and LineAddress='15';
update KaiGuan Set Name='天井灯槽内灯带主', Code='16' where Mac='187ed5324284' and LineAddress='16';

第 6 排 (mac: 187ed53122f8) 1，4
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53122f8'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed53122f8' and LineAddress='1';
update KaiGuan Set Name='明备1', Code='2' where Mac='187ed53122f8' and LineAddress='2';
update KaiGuan Set Name='2', Code='3' where Mac='187ed53122f8' and LineAddress='3';
update KaiGuan Set Name='插座', Code='4' where Mac='187ed53122f8' and LineAddress='4';
update KaiGuan Set Name='2', Code='5' where Mac='187ed53122f8' and LineAddress='5';
update KaiGuan Set Name='3', Code='6' where Mac='187ed53122f8' and LineAddress='6';
update KaiGuan Set Name='4', Code='7' where Mac='187ed53122f8' and LineAddress='7';

3层B区
第 1 排 (mac: 187ed532a24c) 1
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532a24c'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed532a24c' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed532a24c' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed532a24c' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed532a24c' and LineAddress='4';
update KaiGuan Set Name='', Code='5' where Mac='187ed532a24c' and LineAddress='5';
update KaiGuan Set Name='', Code='6' where Mac='187ed532a24c' and LineAddress='6';
update KaiGuan Set Name='', Code='7' where Mac='187ed532a24c' and LineAddress='7';
update KaiGuan Set Name='', Code='8' where Mac='187ed532a24c' and LineAddress='8';
update KaiGuan Set Name='灯带', Code='9' where Mac='187ed532a24c' and LineAddress='9';
update KaiGuan Set Name='', Code='10' where Mac='187ed532a24c' and LineAddress='10';
update KaiGuan Set Name='', Code='11' where Mac='187ed532a24c' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed532a24c' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed532a24c' and LineAddress='13';
update KaiGuan Set Name='', Code='14' where Mac='187ed532a24c' and LineAddress='14';
update KaiGuan Set Name='天井竖灯带备用', Code='15' where Mac='187ed532a24c' and LineAddress='15';
update KaiGuan Set Name='天井灯槽内灯带主', Code='16' where Mac='187ed532a24c' and LineAddress='16';
update KaiGuan Set Name='天井灯槽内灯带主', Code='17' where Mac='187ed532a24c' and LineAddress='17';
update KaiGuan Set Name='天井灯槽内灯带主', Code='18' where Mac='187ed532a24c' and LineAddress='18';
update KaiGuan Set Name='天井灯槽内灯带主', Code='19' where Mac='187ed532a24c' and LineAddress='19';
update KaiGuan Set Name='天井灯槽内灯带主', Code='20' where Mac='187ed532a24c' and LineAddress='20';

第 2 排 (mac: 187ed5329bc8) 1，5，6，7，8，9，10
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329bc8'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed532a24c' and LineAddress='1';
update KaiGuan Set Name='1层中空灯带1主1备', Code='2' where Mac='187ed532a24c' and LineAddress='2';
update KaiGuan Set Name='', Code='3' where Mac='187ed532a24c' and LineAddress='3';
update KaiGuan Set Name='1层中空射灯', Code='4' where Mac='187ed532a24c' and LineAddress='4';
update KaiGuan Set Name='插座', Code='5' where Mac='187ed532a24c' and LineAddress='5';
update KaiGuan Set Name='东卫插座', Code='6' where Mac='187ed532a24c' and LineAddress='6';
update KaiGuan Set Name='插座', Code='7' where Mac='187ed532a24c' and LineAddress='7';
update KaiGuan Set Name='插座', Code='8' where Mac='187ed532a24c' and LineAddress='8';
update KaiGuan Set Name='东卫插座', Code='9' where Mac='187ed532a24c' and LineAddress='9';
update KaiGuan Set Name='插座', Code='10' where Mac='187ed532a24c' and LineAddress='10';

第 3 排 (mac: 187ed5328754) 1
13，14 17-21点
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5328754'


update KaiGuan Set Name='插座', Code='1' where Mac='187ed5328754' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed5328754' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5328754' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed5328754' and LineAddress='4';
update KaiGuan Set Name='灯带', Code='5' where Mac='187ed5328754' and LineAddress='5';
update KaiGuan Set Name='', Code='6' where Mac='187ed5328754' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5328754' and LineAddress='7';
update KaiGuan Set Name='灯带', Code='8' where Mac='187ed5328754' and LineAddress='8';
update KaiGuan Set Name='灯带', Code='9' where Mac='187ed5328754' and LineAddress='9';
update KaiGuan Set Name='灯带', Code='10' where Mac='187ed5328754' and LineAddress='10';
update KaiGuan Set Name='东卫照明1', Code='11' where Mac='187ed5328754' and LineAddress='11';
update KaiGuan Set Name='东卫照明2', Code='12' where Mac='187ed5328754' and LineAddress='12';
update KaiGuan Set Name='1层东门中空射灯', Code='13' where Mac='187ed5328754' and LineAddress='13';
update KaiGuan Set Name='1层东门中空射灯', Code='14' where Mac='187ed5328754' and LineAddress='14';
update KaiGuan Set Name='灯带', Code='15' where Mac='187ed5328754' and LineAddress='15';
update KaiGuan Set Name='灯带', Code='16' where Mac='187ed5328754' and LineAddress='16';
update KaiGuan Set Name='灯带', Code='17' where Mac='187ed5328754' and LineAddress='17';
update KaiGuan Set Name='灯带', Code='18' where Mac='187ed5328754' and LineAddress='18';
update KaiGuan Set Name='灯箱', Code='19' where Mac='187ed5328754' and LineAddress='19';
update KaiGuan Set Name='灯带', Code='20' where Mac='187ed5328754' and LineAddress='20';

第 4 排 (mac: 187ed5323a58) 1，6，7，8，9
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5323a58'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5323a58' and LineAddress='1';
update KaiGuan Set Name='西卫照明1', Code='2' where Mac='187ed5323a58' and LineAddress='2';
update KaiGuan Set Name='西卫照明2', Code='3' where Mac='187ed5323a58' and LineAddress='3';
update KaiGuan Set Name='天井竖灯带1主1备', Code='4' where Mac='187ed5323a58' and LineAddress='4';
update KaiGuan Set Name='天井灯槽灯带1主1备', Code='5' where Mac='187ed5323a58' and LineAddress='5';
update KaiGuan Set Name='插座', Code='6' where Mac='187ed5323a58' and LineAddress='6';
update KaiGuan Set Name='东卫插座', Code='7' where Mac='187ed5323a58' and LineAddress='7';
update KaiGuan Set Name='东卫插座', Code='8' where Mac='187ed5323a58' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed5323a58' and LineAddress='9';
update KaiGuan Set Name='2', Code='10' where Mac='187ed5323a58' and LineAddress='10';

第 5 排 (mac: 187ed5329254) 1
2，4，5，6，7 17-21点关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329254'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329254' and LineAddress='1';
update KaiGuan Set Name='1层本门中空灯带', Code='2' where Mac='187ed5329254' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5329254' and LineAddress='3';
update KaiGuan Set Name='1层东门中空筒灯', Code='4' where Mac='187ed5329254' and LineAddress='4';
update KaiGuan Set Name='1层东门中空筒灯', Code='5' where Mac='187ed5329254' and LineAddress='5';
update KaiGuan Set Name='1层东门中空灯带1主1备', Code='6' where Mac='187ed5329254' and LineAddress='6';
update KaiGuan Set Name='1层东门中空筒灯', Code='7' where Mac='187ed5329254' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5329254' and LineAddress='8';
update KaiGuan Set Name='', Code='9' where Mac='187ed5329254' and LineAddress='9';
update KaiGuan Set Name='灯带', Code='10' where Mac='187ed5329254' and LineAddress='10';
update KaiGuan Set Name='', Code='11' where Mac='187ed5329254' and LineAddress='11';
update KaiGuan Set Name='', Code='12' where Mac='187ed5329254' and LineAddress='12';
update KaiGuan Set Name='', Code='13' where Mac='187ed5329254' and LineAddress='13';
update KaiGuan Set Name='', Code='14' where Mac='187ed5329254' and LineAddress='14';
update KaiGuan Set Name='灯箱', Code='15' where Mac='187ed5329254' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed5329254' and LineAddress='16';
update KaiGuan Set Name='筒灯', Code='17' where Mac='187ed5329254' and LineAddress='17';
update KaiGuan Set Name='筒灯', Code='18' where Mac='187ed5329254' and LineAddress='18';
update KaiGuan Set Name='筒灯', Code='19' where Mac='187ed5329254' and LineAddress='19';


第 6 排 (mac: 187ed532a1fc) 1，6，7，8
2，5 17-21点
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532a1fc'

update KaiGuan Set Name='西卫插座1', Code='1' where Mac='187ed532a1fc' and LineAddress='1';
update KaiGuan Set Name='1层东门中空灯带1主1备', Code='2' where Mac='187ed532a1fc' and LineAddress='2';
update KaiGuan Set Name='', Code='3' where Mac='187ed532a1fc' and LineAddress='3';
update KaiGuan Set Name='', Code='4' where Mac='187ed532a1fc' and LineAddress='4';
update KaiGuan Set Name='1层东门中空灯带1主1备', Code='5' where Mac='187ed532a1fc' and LineAddress='5';
update KaiGuan Set Name='西卫插座2', Code='6' where Mac='187ed532a1fc' and LineAddress='6';
update KaiGuan Set Name='西卫插座3', Code='7' where Mac='187ed532a1fc' and LineAddress='7';
update KaiGuan Set Name='插座', Code='8' where Mac='187ed532a1fc' and LineAddress='8';
update KaiGuan Set Name='2', Code='9' where Mac='187ed532a1fc' and LineAddress='9';
update KaiGuan Set Name='3', Code='10' where Mac='187ed532a1fc' and LineAddress='10';

3层C区
第 1 排 (mac: 187ed5322070) 1，7，8
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5322070'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5322070' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5322070' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5322070' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5322070' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5322070' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5322070' and LineAddress='6';
update KaiGuan Set Name='插座', Code='7' where Mac='187ed5322070' and LineAddress='7';
update KaiGuan Set Name='插座', Code='8' where Mac='187ed5322070' and LineAddress='8';

第 2 排 (mac: 187ed5329880) 1，6，7
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329880'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329880' and LineAddress='1';
update KaiGuan Set Name='灯带', Code='2' where Mac='187ed5329880' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5329880' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed5329880' and LineAddress='4';
update KaiGuan Set Name='灯带', Code='5' where Mac='187ed5329880' and LineAddress='5';
update KaiGuan Set Name='插座', Code='6' where Mac='187ed5329880' and LineAddress='6';
update KaiGuan Set Name='插座', Code='7' where Mac='187ed5329880' and LineAddress='7';

第 3 排 (mac: 187ed532a148) 1
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532a148'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed532a148' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed532a148' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed532a148' and LineAddress='3';
update KaiGuan Set Name='灯带', Code='4' where Mac='187ed532a148' and LineAddress='4';
update KaiGuan Set Name='灯带+筒灯灯箱绿线', Code='5' where Mac='187ed532a148' and LineAddress='5';
update KaiGuan Set Name='天井灯槽灯带1主1备', Code='6' where Mac='187ed532a148' and LineAddress='6';
update KaiGuan Set Name='天井竖灯带1主1备', Code='7' where Mac='187ed532a148' and LineAddress='7';

4层A区
第 1 排 (mac: 187ed53208c4) 1，5，6，9，10
7 17-21点
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53208c4'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed53208c4' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed53208c4' and LineAddress='2';
update KaiGuan Set Name='天井北竖灯带1主1备', Code='3' where Mac='187ed53208c4' and LineAddress='3';
update KaiGuan Set Name='天井灯槽灯带1主1备', Code='4' where Mac='187ed53208c4' and LineAddress='4';
update KaiGuan Set Name='天井广告牌1', Code='5' where Mac='187ed53208c4' and LineAddress='5';
update KaiGuan Set Name='天井广告牌2', Code='6' where Mac='187ed53208c4' and LineAddress='6';
update KaiGuan Set Name='天井天花灯带1主1备', Code='7' where Mac='187ed53208c4' and LineAddress='7';
update KaiGuan Set Name='天井南竖灯带1主1备', Code='8' where Mac='187ed53208c4' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed53208c4' and LineAddress='9';
update KaiGuan Set Name='插座', Code='10' where Mac='187ed53208c4' and LineAddress='10';

第 2 排 (mac: 187ed5329890) 1，9，10
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329890'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329890' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5329890' and LineAddress='2';
update KaiGuan Set Name='灯带', Code='3' where Mac='187ed5329890' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5329890' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5329890' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5329890' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5329890' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5329890' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed5329890' and LineAddress='9';
update KaiGuan Set Name='插座', Code='10' where Mac='187ed5329890' and LineAddress='10';

第 3 排 (mac: 187ed5328af0) 9，10
2，3，4，5 17-21点
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5328af0'

update KaiGuan Set Name='。', Code='1' where Mac='187ed5328af0' and LineAddress='1';
update KaiGuan Set Name='马达灯', Code='2' where Mac='187ed5328af0' and LineAddress='2';
update KaiGuan Set Name='马达灯', Code='3' where Mac='187ed5328af0' and LineAddress='3';
update KaiGuan Set Name='马达灯', Code='4' where Mac='187ed5328af0' and LineAddress='4';
update KaiGuan Set Name='马达灯', Code='5' where Mac='187ed5328af0' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5328af0' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5328af0' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5328af0' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed5328af0' and LineAddress='9';
update KaiGuan Set Name='插座', Code='10' where Mac='187ed5328af0' and LineAddress='10';


4层B区
第 1 排 (mac: 187ed5323fbc) 1，16-20
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5323fbc'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5323fbc' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5323fbc' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5323fbc' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5323fbc' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5323fbc' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5323fbc' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed5323fbc' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5323fbc' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed5323fbc' and LineAddress='9';
update KaiGuan Set Name='灯带', Code='10' where Mac='187ed5323fbc' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed5323fbc' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed5323fbc' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed5323fbc' and LineAddress='13';
update KaiGuan Set Name='明备', Code='14' where Mac='187ed5323fbc' and LineAddress='14';
update KaiGuan Set Name='明备', Code='15' where Mac='187ed5323fbc' and LineAddress='15';
update KaiGuan Set Name='插座', Code='16' where Mac='187ed5323fbc' and LineAddress='16';
update KaiGuan Set Name='卫生间插座1', Code='17' where Mac='187ed5323fbc' and LineAddress='17';
update KaiGuan Set Name='卫生间插座2', Code='18' where Mac='187ed5323fbc' and LineAddress='18';
update KaiGuan Set Name='卫生间插座3', Code='19' where Mac='187ed5323fbc' and LineAddress='19';
update KaiGuan Set Name='卫生间插座4', Code='20' where Mac='187ed5323fbc' and LineAddress='20';


第 2 排 (mac: 187ed5329218) 1，17，18，19
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329218'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329218' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5329218' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed5329218' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed5329218' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed5329218' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5329218' and LineAddress='6';
update KaiGuan Set Name='灯带', Code='7' where Mac='187ed5329218' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5329218' and LineAddress='8';
update KaiGuan Set Name='', Code='9' where Mac='187ed5329218' and LineAddress='9';
update KaiGuan Set Name='西卫筒灯', Code='10' where Mac='187ed5329218' and LineAddress='10';
update KaiGuan Set Name='西卫生间照明1', Code='11' where Mac='187ed5329218' and LineAddress='11';
update KaiGuan Set Name='西卫生间照明2', Code='12' where Mac='187ed5329218' and LineAddress='12';
update KaiGuan Set Name='卫生间照明1', Code='13' where Mac='187ed5329218' and LineAddress='13';
update KaiGuan Set Name='卫生间照明3', Code='14' where Mac='187ed5329218' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed5329218' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed5329218' and LineAddress='16';
update KaiGuan Set Name='西卫生间插座1', Code='17' where Mac='187ed5329218' and LineAddress='17';
update KaiGuan Set Name='西卫生间插座2', Code='18' where Mac='187ed5329218' and LineAddress='18';
update KaiGuan Set Name='插座', Code='19' where Mac='187ed5329218' and LineAddress='19';
update KaiGuan Set Name='插座', Code='20' where Mac='187ed5329218' and LineAddress='20';

第 3 排 (mac: 187ed532a2fc) 1，14，17
2，11-13 17-21点关
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532a2fc'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed532a2fc' and LineAddress='1';
update KaiGuan Set Name='天井天花灯带', Code='2' where Mac='187ed532a2fc' and LineAddress='2';
update KaiGuan Set Name='天井灯带', Code='3' where Mac='187ed532a2fc' and LineAddress='3';
update KaiGuan Set Name='天井天花灯带', Code='4' where Mac='187ed532a2fc' and LineAddress='4';
update KaiGuan Set Name='天井灯带备', Code='5' where Mac='187ed532a2fc' and LineAddress='5';
update KaiGuan Set Name='天井灯带', Code='6' where Mac='187ed532a2fc' and LineAddress='6';
update KaiGuan Set Name='天井灯带备', Code='7' where Mac='187ed532a2fc' and LineAddress='7';
update KaiGuan Set Name='天井灯带', Code='8' where Mac='187ed532a2fc' and LineAddress='8';
update KaiGuan Set Name='天井灯带备', Code='9' where Mac='187ed532a2fc' and LineAddress='9';
update KaiGuan Set Name='', Code='10' where Mac='187ed532a2fc' and LineAddress='10';
update KaiGuan Set Name='马达灯', Code='11' where Mac='187ed532a2fc' and LineAddress='11';
update KaiGuan Set Name='马达灯', Code='12' where Mac='187ed532a2fc' and LineAddress='12';
update KaiGuan Set Name='马达灯', Code='13' where Mac='187ed532a2fc' and LineAddress='13';
update KaiGuan Set Name='升降机', Code='14' where Mac='187ed532a2fc' and LineAddress='14';
update KaiGuan Set Name='柱子灯带', Code='15' where Mac='187ed532a2fc' and LineAddress='15';
update KaiGuan Set Name='明备', Code='16' where Mac='187ed532a2fc' and LineAddress='16';
update KaiGuan Set Name='插座', Code='17' where Mac='187ed532a2fc' and LineAddress='17';
update KaiGuan Set Name='2', Code='18' where Mac='187ed532a2fc' and LineAddress='18';
update KaiGuan Set Name='3', Code='19' where Mac='187ed532a2fc' and LineAddress='19';
update KaiGuan Set Name='灯箱', Code='20' where Mac='187ed532a2fc' and LineAddress='20';

4层C区
第 1 排 (mac: 187ed53290f0) 1，9，10
4，7 17-21点
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53290f0'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed53290f0' and LineAddress='1';
update KaiGuan Set Name='', Code='2' where Mac='187ed53290f0' and LineAddress='2';
update KaiGuan Set Name='', Code='3' where Mac='187ed53290f0' and LineAddress='3';
update KaiGuan Set Name='马达灯', Code='4' where Mac='187ed53290f0' and LineAddress='4';
update KaiGuan Set Name='', Code='5' where Mac='187ed53290f0' and LineAddress='5';
update KaiGuan Set Name='天井灯槽灯带', Code='6' where Mac='187ed53290f0' and LineAddress='6';
update KaiGuan Set Name='马达灯', Code='7' where Mac='187ed53290f0' and LineAddress='7';
update KaiGuan Set Name='天井灯槽灯带', Code='8' where Mac='187ed53290f0' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed53290f0' and LineAddress='9';
update KaiGuan Set Name='插座', Code='10' where Mac='187ed53290f0' and LineAddress='10';

第 2 排 (mac: 187ed5329628) 1，9，10
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5329628'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed5329628' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed5329628' and LineAddress='2';
update KaiGuan Set Name='', Code='3' where Mac='187ed5329628' and LineAddress='3';
update KaiGuan Set Name='', Code='4' where Mac='187ed5329628' and LineAddress='4';
update KaiGuan Set Name='', Code='5' where Mac='187ed5329628' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed5329628' and LineAddress='6';
update KaiGuan Set Name='', Code='7' where Mac='187ed5329628' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed5329628' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed5329628' and LineAddress='9';
update KaiGuan Set Name='插座', Code='10' where Mac='187ed5329628' and LineAddress='10';

第 3 排 (mac: 187ed532933c) 1，10
8-9 17-21点
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532933c'

update KaiGuan Set Name='插座', Code='1' where Mac='187ed532933c' and LineAddress='1';
update KaiGuan Set Name='', Code='2' where Mac='187ed532933c' and LineAddress='2';
update KaiGuan Set Name='', Code='3' where Mac='187ed532933c' and LineAddress='3';
update KaiGuan Set Name='', Code='4' where Mac='187ed532933c' and LineAddress='4';
update KaiGuan Set Name='', Code='5' where Mac='187ed532933c' and LineAddress='5';
update KaiGuan Set Name='', Code='6' where Mac='187ed532933c' and LineAddress='6';
update KaiGuan Set Name='', Code='7' where Mac='187ed532933c' and LineAddress='7';
update KaiGuan Set Name='马达灯', Code='8' where Mac='187ed532933c' and LineAddress='8';
update KaiGuan Set Name='马达灯', Code='9' where Mac='187ed532933c' and LineAddress='9';
update KaiGuan Set Name='插座', Code='10' where Mac='187ed532933c' and LineAddress='10';

```

# 添加二期二层三层

```
指向地址：192.168.88.1:8080/ebx-bishop/data/carry

3层
3层A区
第1排 104CC 205 已指向已重启
排序6
线路完整

第2排 2BECC 164 已指向已重启
排序5
线路完整

第3排 2A9B0 131 已指向已重启
排序4
线路完整

第4排 2BBF0 28 已指向已重启
排序3
线路完整

第5排 29EC0 249 已指向已重启
排序2
线路完整

第6排 2AE0C 158 已指向已重启
排序1
线路完整

二期3层A区上班
二期3层A区下班

3层B区
第1排 2BD4C 238 已指向已重启
排序3
线路完整

第2排 29FA4 123 已指向已重启
排序2
线路完整

第3排 2C154 68  已指向已重启
排序1
线路完整

二期3层B区上班
二期3层B区下班

3层C区
第1排 29828 26 已指向已重启
排序3
线路完整

第2排 2BC04 116 已指向已重启
排序2
线路完整

第3排 2BA30 14 已指向已重启
排序1
线路完整
二期3层C区上班
二期3层C区下班


3层D区
第1排 2B2DC 51 已指向已重启
排序6
线路完整

第2排 273B8 23 已指向已重启
排序5
线路完整

第3排 29F18 147 已指向已重启
排序4
线路完整

第4排 2A818 113 已指向已重启
排序3
线路完整

第5排 2A628 128 已指向已重启
排序2
线路完整

第6排 2BD34 20 已指向已重启
排序1
线路完整
二期3层D区上班
二期3层D区下班


2层
2层A区
第1排 2865C 213 已指向已重启
排序6
线路完整

第2排 2BAE8 175 已指向已重启
排序5
线路完整

第3排 2BF80 223 已指向已重启
排序4
线路完整

第4排 288DC 225 已指向已重启
排序3
线路完整

第5排 2C36C 240 已指向已重启
排序2
线路完整

第6排 2B978 241 已指向已重启
排序1
线路完整
二期2层A区上班
二期2层A区下班

2层B区
第1排 2B324 127 已指向已重启
排序3
线路完整

第2排 2B24C 154 已指向已重启
排序2
线路完整

第3排 29674 151 已指向已重启
排序1
线路完整
二期2层B区上班
二期2层B区下班

2层C区
第1排 2C0C0 242 已指向已重启
排序3
线路完整

第2排 28488 129 已指向已重启
排序2
线路完整

第3排 2BC70 124 已指向已重启
排序1
线路完整

二期2层C区上班
二期2层C区下班

2层D区
第1排 29430 146 已指向已重启
排序6
线路完整

第2排 288D4 145 已指向已重启
排序5
线路完整

第3排 2B95C 138 已指向已重启
排序4
线路完整

第4排 2BE90 206 已指向已重启
排序3
线路完整

第5排 28474 137 已指向已重启
排序2
线路完整

第6排 2A59C 136 已指向已重启
排序1
线路完整

二期2层D区上班
二期2层D区下班

已完成二期2层A,B,C,D，3层A,B,C,D总共两层8个区域的线路创建和场景设置。
```

季工一期三楼B区第五排第2.4.5.7.9我标着是17点开但是现在触发了，你给解决一下把。
第四排1.2.4.5.6.7.9.10没有触发
```
第4排187ed5323a58 
上班场景是否包含1.2.4.5.6.7.9.10

第5排 187ed5329254 
下班场景不应该包含2.4.5.7.9
现在，我把第5排的2.4.5.7.9从下班场景里删除了
准备从9点上班场景里删除
把放到17点开的场景


第二排第二个也改成17点开21点关。
187ed5329bc8
首先从上班场景里删除
再把第二排第二个放到17点开的场景
已经把第二排第二个放到了17点开的场景中，即"一期天井和雨棚上班"场景

二楼A区的第三排第三个和十七个下班场景控制不了。
187ed5324fac

一楼B区第三排第2.8触发不了
187ed5327ddc
还是那两个开关下班场景触发不了
下班场景里也有这两个开关，难道开关坏了？


一楼A区第三排第15个第五排第17个上班场景触发不了
 187ed53218f4
也在场景里

 纪工一楼B区第五排第12.13.19是雨棚的17点开21点关麻烦你改一下吧
  187ed5322488
  先加到雨棚场景

  一楼A区第五排7.8.9下班触发不了
  7，9下班
  8雨棚上班
  187ed53298b0
  一楼A区第五排7.9已经加到下班场景里了

纪工你看一下二期负一超市夜间照明没开
总共6个，对吧？
都正常
```

# 2020年10月17日

一些问题
```
纪工二期负一S5区第六排第五个上班场景触发不了
187ed532b424
二期负一S5区第六排第五个已经编在场景里了。

二期负一S2第四排第四个上班场景也触发不了你给看一下吧
187ed532a8d4
二期负一S2第四排第四个处于手动分断状态，系统无法控制。请注意：所有现场手动分断的开关，系统都无法控制。

关于二期负一层超市夜间照明和其它灯一起关了的问题。

目前，S1-S6的下班场景中，不会对以下线路关闭。请大家确认以下的夜间照明是否和领导说的夜间照明是一回事？

二期负一层超市,S6 第二排(187ed53291b8)	线路13	 
二期负一层超市,S5	第六排(187ed532b424)	线路8		 
二期负一层超市,S4	第六排(187ed5328d84)	线路8		 
二期负一层超市,S3	第六排(187ed532f644)	线路8		 
二期负一层超市,S2	第六排(187ed5328ba8)	线路8		 
二期负一层超市,S1	第六排(187ed5328f44)	线路8	
```

2期1层或2期4层
```
-- 2期1层C区所有模块还没告诉我
-- 2期1层D区第1排模块还没告诉我
-- 2期4层B区第3排模块找不到，请确认模块号是否是187ED532BB78?

2期1层
A区
第1排
第2排
第3排
第4排
第5排
第6排

B区
第1排 2B208 149 已指向已重启
排序3
线路完整

第2排 29128 109 已指向已重启
排序2
线路完整

第3排 2BB20 135 已指向已重启
排序1
线路完整

二期1层B区下班
二期1层B区上班

C区
第1排 28E04 222 已指向
排序3
线路完整
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed5328e04'
没有

第2排 283F0 219 已指向
排序2 
线路完整
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed53283f0'
没有

第3排 2BA70 75 已指向
排序1
线路完整
select Mac, LineAddress,Name, Code from KaiGuan where Mac='187ed532ba70'
没有


二期1层C区下班
二期1层C区上班

D区
第1排 2AD60 220 已指向已重启
排序6
线路完整

第2排 299F8 18 已指向已重启
排序5
线路完整

第3排 294F0 12 已指向已重启
排序4
线路完整

第4排 2BEF8 86 已指向已重启
排序3
线路完整

第5排 2558C 22 已指向已重启
排序2
线路完整

第6排 2C264 163 已指向已重启
排序1
线路完整

二期1层D区下班
二期1层D区上班

2期4层
A区
第1排
第2排
第3排
第4排
第5排
第6排

B区
第1排 2B414 90 已指向已重启
排序3
线路完整

第2排 2B274 185 已指向已重启
排序2
线路完整
请重启或检查线路
已正常

第3排 2B878 118 已指向已重启
排序1
请重启或检查线路

二期4层B区下班
二期4层B区上班

C区
第1排 2BD7C 195 已指向已重启
排序3
线路完整

第2排 2BFC4 192 已指向已重启
排序2
线路完整

第3排 2ADEC 111 已指向已重启
排序1
线路完整

二期4层C区下班
二期4层C区上班

D区
第1排 2B838 74 已指向已重启
排序6
线路完整



第2排 28454 41 已指向已重启
排序5
线路完整

第3排 2B234 232 已指向已重启
排序4
线路完整

第4排 2C2B8 101 已指向已重启
排序3
线路完整

第5排 28FC0 166 已指向已重启
排序2
线路完整

第6排 2B5D8 197 已指向已重启
排序1
线路完整

二期4层D区下班
二期4层D区上班
```

2期负2层AL1区
```
2期负2层AL1区第一排尾号2BCC8，还没在局域网找到 253

14扶梯灯
15扶梯底灯
16观光前厅灯
```

纪工二期一楼A区下班场景没有触发
```
21:32:30关，还没到时间。
```

二期四楼下班场景也没有触发你顺便看一下吧
```
21:32:50关，还没到时间。
```

纪工超市负一S4第六排第七个第八个都是夜间照明咱只设了第八个。你把第七个也添加上吧。
```
187ed5328d84 7 从s4下班删除
已处理
```
二期4层A区没有关
```
 187ed532c19c 3排
 187ed5329be4 4排
 二期4层A区3排和4排现在关了
```

# 2020年10月18日

```
2期1层B、C、D区和2期4层B、C、D区,已完成线路添加和场景设置。极个别部分设备还未上线，正在处理。

以下需要完善：
-- 2期1层C区所有模块还没告诉我
-- 2期1层D区第1排模块还没告诉我
-- 2期4层B区第2排模块找不到，请重启或检查线路，并确认模块号是否是187ED532B274？
-- 2期4层B区第3排模块找不到，请重启或检查线路，请确认模块号是否是187ED532BB78?
-- 2期负2层AL1区第一排187ED532BCC8，还没在局域网找到

10：23
以下需要完善：
-- 2期1层C区所有模块还没告诉我
-- 2期负2层AL1区第一排187ED532BCC8，还没在局域网找到

16：00
-- 2期负2层AL1区第一排187ED532BCC8，还没在局域网找到
```

一期一楼A区有一些合闸的，需要关掉吗？
```
第 4 排 (mac: 187ed53297f0) 1 7 8 9
第 5 排 (mac: 187ed53298b0) 1
第 6 排 (mac: 187ed5328b40) 1 7 8 9
不是
```

一期一层C区第二排没关
```
第 2 排 (mac: 187ed5328830)
当前状态不是手动分断，是正常系统自动分断。
```

2020年10月19日
```
纪工二期负一S4第五排10个开关没触发你看一下吧。
--在S4下班场景中漏掉了，已添加至"二期负一层超市S4区下班21点关"场景。
187ed5328dc0 10
21点场景，没有这个场景中
21：30场景，没有在这个场景中
放到21点场景中


二期负一S6第三排第九个也没触发。
187ed532bef4
--在S6下班场景中漏掉了，已添加至"二期负一层超市S6区下班21点关"场景。


二期负一S3第五排第七个也没触发
--在S3下班场景中漏掉了，已添加至"二期负一层超市S3区下班21点关"场景。
 187ed532f060


 二期负一第四排第三个第七个也没关 187ed532a8d4
 第八排第七个也没关 第5排 187ed532b550
 --在S5下班场景中漏掉了，已添加至"二期负一层超市S5区下班21点关"场景。
```

# 2020年10月20日

```
一期二层C区第三排北门雨棚灯
187ed532bc70 
一期二层C区第三排没有北门雨棚灯。确定这个线路吗？确定这个线路在一期二层C区第三排吗？
一期二层C区第三排北门雨棚灯的名称，你已经编好了，你再看一下
187ed532a084
7，8，9，10
添加到一期天井和雨棚上班
从一期二层上班中删除


二期1-4第一排是不是没添加进去
--已经在"二期1层D区下班"场景里，并且没有报警，再观察下
187ed532ad60

二期1-4第5排第12个是不是没添加进去，现场没问题
--确实没加到"二期1层D区下班",已加上了。
187ed532558c 


二期一层1-3的第三排，有东门室外雨棚麻烦给看一下时间，下午发现提前亮了
二期一层C区第三排187ed532ba70 5号
二期天井和雨棚上班
从二期一层C区上班中删除
--已创建"二期天井和雨棚上班",下午17：00开。但只找到二期一层C区第三排5号的开关。这一点需要注意，因为利群的领导一直在强调，但一直没有人把实际线路和系统内的线路完全对应起来。


今天晚上二期三楼连廊位置留灯，晚上有人干活。
D区
第一排2、3、7、13、15、17、18 187ed532b2dc
第二排4、5 187ed53273b8
第五排 2、3、4、5、7、9、187ed532a628
第六排2、5、6、7、8、 187ed532bd34
```

# 2020年10月21日

```
二期雨棚关 1262
187ed532ba70 5
利群胶州购物广场,二期一层,1-3下班场景中删除

一期天井和雨棚下班 1259
187ed5324c78 16，17，18，19 利群胶州购物广场,一期一层,B
187ed5322488 12，13，19
187ed53252e0 8
187ed53257a8 2，3，4，5，6 利群胶州购物广场,一期一层,C
187ed5329a0c 1 利群胶州购物广场,一期二层,A
187ed532a084 7，8，9，10 利群胶州购物广场,一期二层,C
187ed5328754 13，14 利群胶州购物广场,一期三层,B
187ed5323a58 2，4，5，6，7利群胶州购物广场,一期三层,B
187ed532a1fc 2，5 利群胶州购物广场,一期三层,B
187ed53208c4 7 利群胶州购物广场,一期四层,A
187ed5328af0 2，3，4，5
187ed532a2fc 2，11，12，13 利群胶州购物广场,一期四层,B
187ed53290f0 4，7 利群胶州购物广场,一期四层,C
187ed532933c 8，9
187ed5329bc8 2 利群胶州购物广场,一期三层,B
187ed5329254 2，4，5，7，9
187ed53298b0 8 利群胶州购物广场,一期一层,A
```