data.sql
17.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
-- 堆垛机1 PLC--> WCS PROPS
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'TaskValidate','任务校验','BYTE', '1—任务校验正确；2--任务校验出错',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'WorkModel','工作模式','BYTE', '工作模式：1-脱机；2-联机',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OperationModel','操作模式','BYTE', '操作模式：1-维修；2-手动；3-机载操作；4-单机自 动；5-联机',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'WorkStatus','工作状态','BYTE', '工作状态：0-待机，1-入库，2-出库，3-拣选，4-转 库，5-双重入库，6-回库台位（入库准备），7-召回， 8-急停',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalDistance','水平测距','DWORD', '水平测距数据 单位 1m',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'VerticalDistance','起升测距','DWORD', '起升测距数据 单位 1m',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'CurrentColumn','当前列','BYTE', '当前列',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'CurrentLayer','当前层','BYTE', '当前层',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HasPallet','叉原位时是否有货','BYTE', '1-叉原位时叉上无货，2-叉原位时叉上有货，',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'LeftForkOutWhenInOrigin','叉原位时是否左超差','BOOL', '0-无超差；1-货物左超差（叉原位时）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RightForkOutWhenInOrigin','叉原位时是否右超差','BOOL', '0-无超差；1-货物右超差（叉原位时）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'LeftShape','是否左侧外形超限','BOOL', '0-无超限；1-左侧外形超限',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RightShape','是否右侧外形超限','BOOL', '0-无超限；1-右侧外形超限',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Overload','过载','BOOL', '0-无过载；1-过载',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Rope','松绳','BOOL', '0-无松绳；1-松绳',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RunningUuivertorAlarm','运行变频器报警','BOOL', '0-无报警；1-运行变频器报警',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RaisingUuivertorAlarm','起升变频器报警','BOOL', '0-无报警；1-起升变频器报警',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RunningTimeout','运行超时','BOOL', '0-无超时；1-运行超时',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RaisingTimeout','起升超时','BOOL', '0-无超时；1-起升超时',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'PalletForkTimeout','货叉超时','BOOL', '0-无超时；1-货叉超时',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OverHeight1','超高1','BOOL', '0-无超高；1-超高 1（货物高度与送货地址不匹配）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OverHeight2','超高2','BOOL', '0-无超高；1-超高 2（货物高度与送货地址不匹配）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OverHeight3','超高3','BOOL', '0-无超高；1-超高 3（货物高度与送货地址不匹配）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OverHeight','货物超高','BOOL', '0-无超高；1-货物超高',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalLaserDataError','水平激光数据错误','BOOL', '0-无错误；1-水平激光数据错误',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RaisingBarcodeDataError','起升条码数据错误','BOOL', '0-无错误；1-起升条码数据错误',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'DoubleIn','双重入库','BOOL', '0-无故障；1-双重入库 满入',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'EmptyOut','空货位出库','BOOL', '0-无故障；1-空货位出库 空出',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'AdressError','0-无故障；1-地址错','BOOL', '0-无故障；1-地址错',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'MainCocontactorInterrupt','主接触器断开','BOOL', '0-无故障；1-主接触器断开 （急停、冲 顶、超速保 护，行走超 限动作）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalBreakerOrBrakeInterrupt','水平断路器/制动器跳闸','BOOL', '0-无故障；1-水平断路器/制动器跳闸',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RaisingBreakerOrBrakeInterrupt','起升断路器/制动器跳闸','BOOL', '0-无故障；1-起升断路器/制动器跳闸',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'PalletForkBreakerOrBrakeInterrupt','货叉断路器/制动器跳闸','BOOL', '0-无故障；1-货叉断路器/制动器跳闸',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalLeadingendOut','水平前端超限（前进终点）','BOOL', '0-无超限，1-水平前端超限（前进终点）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalTrailingendOut','水平后端超限（后退终点）','BOOL', '0-无超限；1-水平后端超限（后退终点）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'VerticalHorizontalLeadingendOut','垂直上端超限（上升终点）','BOOL', '0-无超限；1-垂直上端超限（上升终点）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'VerticalHorizontalTrailingendOut','垂直下端超限（下降终点）','BOOL', '0-无超限；1-垂直下端超限（下降终点）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free1','Free1','BOOL', 'free',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free2','Free2','BOOL', 'free',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free3','Free3','BOOL', 'free',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free4','Free4','BOOL', 'free',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'TaskExcuteStatus','任务执行','BYTE', '1-待机；2-任务执行中;3-任务完成；4-任务中断（出 错） 1*',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'TaskNo1','任务号1','DWORD', '托盘条码数据 1（任务号）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'TaskNo2','任务号2','WORD', '托盘条码数据 2（任务号）(双托盘时使用)',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free5','Free5','WORD', 'free',1) ;
-- 堆垛机1 WCS --> PLC PROPS
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSTaskFlag', '任务标志', 'BYTE', '任务标志：0-无任务，1-人库，2-出库，3-拣选，4- 转库，5-双重入库，6-回库台位（入库准备，召回）， 7-送货高度不匹配；9-清任务（须带托盘号） 任务完成时清除', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSStop', '急停', 'BYTE', '0-无任务，1-急停 ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFromRow', '取货地址排', 'BYTE', '取货地址: 排 （1—N） 源地址(回库 台位时发)', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFromLayer', '取货地址层', 'BYTE', '取货地址: 列（0-最远列） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFromColumn', '取货地址列', 'BYTE', '取货地址: 层（1-最高层） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSToRow', '放货地址排', 'BYTE', '放货地址: 排（1—N） 目的地址(双 重入库及高 度不符时为放货地址)', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSToLayer', '放货地址层', 'BYTE', '放货地址: 列（0-最远列）） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSToColumn', '放货地址列', 'BYTE', '放货地址: 层（1-最高层） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSTaskNo', '任务号', 'DWORD', '托盘条码数据（即任务号） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSValidateCode', '校验码', 'BYTE', 'DB100.DBB0-- DB100.DBB11 字节异或值 校验码', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFree1', 'WCSFree1', 'BYTE', 'free ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFree2', 'WCSFree2', 'BYTE', 'free ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFree3', 'WCSFree3', 'BYTE', 'free ', 1);
-- 堆垛机1 PLC-->WCS Address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'TaskValidate', -1, 'DB101B0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'WorkModel', -1, 'DB101B1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OperationModel', -1, 'DB101B2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'WorkStatus', -1, 'DB101B3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalDistance', -1, 'DB101D4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'VerticalDistance', -1, 'DB101D8' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'CurrentColumn', -1, 'DB101B12' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'CurrentLayer', -1, 'DB101B13' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HasPallet', -1, 'DB101B14' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'LeftForkOutWhenInOrigin', -1, 'DB101X15.0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RightForkOutWhenInOrigin', -1, 'DB101X15.1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'LeftShape', -1, 'DB101X15.2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RightShape', -1, 'DB101X15.3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Overload', -1, 'DB101X15.4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Rope', -1, 'DB101X15.5' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RunningUuivertorAlarm', -1, 'DB101X15.6' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RaisingUuivertorAlarm', -1, 'DB101X15.7' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RunningTimeout', -1, 'DB101X16.0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RaisingTimeout', -1, 'DB101X16.1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'PalletForkTimeout', -1, 'DB101X16.2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OverHeight1', -1, 'DB101X16.3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OverHeight2', -1, 'DB101X16.4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OverHeight3', -1, 'DB101X16.5' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OverHeight', -1, 'DB101X16.6' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalLaserDataError', -1, 'DB101X16.7' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RaisingBarcodeDataError', -1, 'DB101X17.0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'DoubleIn', -1, 'DB101X17.1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'EmptyOut', -1, 'DB101X17.2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'AdressError', -1, 'DB101X17.3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'MainCocontactorInterrupt', -1, 'DB101X17.4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalBreakerOrBrakeInterrupt', -1, 'DB101X17.5' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RaisingBreakerOrBrakeInterrupt', -1, 'DB101X17.6' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'PalletForkBreakerOrBrakeInterrupt', -1, 'DB101X17.7' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalLeadingendOut', -1, 'DB101X18.0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalTrailingendOut', -1, 'DB101X18.1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'VerticalHorizontalLeadingendOut', -1, 'DB101X18.2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'VerticalHorizontalTrailingendOut', -1, 'DB101X18.3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free1', -1, 'DB101X18.4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free2', -1, 'DB101X18.5' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free3', -1, 'DB101X18.6' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free4', -1, 'DB101X18.7' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'TaskExcuteStatus', -1, 'DB101B19' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'TaskNo1', -1, 'DB101D20' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'TaskNo2', -1, 'DB101D24' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free5', -1, 'DB101W28' ,'-1',1);
-- 堆垛机1 WCS-->PLC Address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSTaskFlag', -1, 'DB100B0', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSStop', -1, 'DB100B1', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFromRow', -1, 'DB100B2', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFromLayer', -1, 'DB100B3', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFromColumn', -1, 'DB100B4', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSToRow', -1, 'DB100B5', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSToLayer', -1, 'DB100B6', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSToColumn', -1, 'DB100B7', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSTaskNo', -1, 'DB100D8', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSValidateCode', -1, 'DB100B12','-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFree1', -1, 'DB100B13','-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFree2', -1, 'DB100B14','-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFree3', -1, 'DB100B15','-1', 1);