|
|
alter table M_CODE add SUBCOMNO INT
|
|
|
|
|
|
delete from M_CODE where FLAG=5
|
|
|
|
|
|
delete from M_CODEDICTIONARY where TYPENAME in('KEY_BREAKLANE',
|
|
|
'KEY_CANCLEXQ',
|
|
|
'KEY_CARTYPEERROR',
|
|
|
'KEY_CD',
|
|
|
'KEY_JJ',
|
|
|
'KEY_NOMATCHCARNO',
|
|
|
'KEY_PAPER',
|
|
|
'KEY_TIMEOUTCAR',
|
|
|
'KEY_TQCAR_BADCPC',
|
|
|
'KEY_TQCAR_BADETC',
|
|
|
'KEY_TQCAR_BIG',
|
|
|
'KEY_TQCAR_GOBY',
|
|
|
'KEY_TQCAR_GW',
|
|
|
'KEY_TQCAR_HDLWEIGHT',
|
|
|
'KEY_TQCAR_J',
|
|
|
'KEY_TQCAR_OHTER',
|
|
|
'KEY_TQCAR_OVER',
|
|
|
'KEY_UTTURN')
|
|
|
|
|
|
|
|
|
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_BREAKLANE', '类别-闯关', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_CANCLEXQ', '类别-取消线圈控制', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_CARTYPEERROR', '类别-车型错误', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_CD', '类别-车队', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_JJ', '类别-军警', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_NOMATCHCARNO', '类别-车牌不符', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_PAPER', '类别-纸卷', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TIMEOUTCAR', '类别-超时车', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TQCAR_BADCPC', '无卡/坏卡', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TQCAR_BADETC', 'OBU/ETC卡坏', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TQCAR_BIG', '大件车', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TQCAR_GOBY', '逆行', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TQCAR_GW', '公务', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TQCAR_HDLWEIGHT', '手输轴数吨位', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TQCAR_J', 'J型', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TQCAR_OHTER', '其他', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_TQCAR_OVER', '超限车', 1, 5,4);
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('KEY_UTTURN', '类别-U转车', 1, 5,4);
|
|
|
|
|
|
|
|
|
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_BREAKLANE', 1, '实际闯关，需追缴', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_BREAKLANE', 2, '疫情防控，车辆通行缓慢', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_BREAKLANE', 3, '已交易推杆显示闯关', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_BREAKLANE', 4, '无数据推杆显示闯关', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_BREAKLANE', 5, '其他', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CANCLEXQ', 1, 'IC卡发出后车辆倒出不走，产生废卡：', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CANCLEXQ', 2, '机电系统故障线圈失控或操作不灵 检修测试', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CANCLEXQ', 3, 'IC卡未刷成功需重新操作的', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CANCLEXQ', 4, '清障拖车', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CARTYPEERROR', 1, '出口车型输入错误', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CARTYPEERROR', 2, '入口车型输入错误', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CD', 1, '车队--真实军警车队通行', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CD', 2, '车队--公司通知车队', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CD', 3, '车队--节假日放行车辆', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_CD', 4, '车队--其他', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_JJ', 1, '无牌军警车，单位：', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_NOMATCHCARNO', 1, '人工车道入口输入错误', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_NOMATCHCARNO', 2, '人工车道出口输入错误', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_NOMATCHCARNO', 3, '其他', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_NOMATCHCARNO', 4, '出入口相差较大，核实入口所', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_PAPER', 1, '节假日纸卷', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_PAPER', 2, '无入口信息，无卡/坏卡入口所不符', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_PAPER', 3, 'U转一站地', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_PAPER', 4, '严重超时', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_PAPER', 5, '车卡绑定不一致', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_PAPER', 6, 'ETC用户要票，转纸卷', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_PAPER', 7, '其他', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_PAPER', 8, 'XX所站无通行卡，发纸卷', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TIMEOUTCAR', 1, '超时车--服务区工作车辆', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TIMEOUTCAR', 2, '超时车--车辆故障', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TIMEOUTCAR', 3, '大件车等待办证', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TIMEOUTCAR', 4, '其他', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_BADCPC', 1, '实际丢卡', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_BADCPC', 2, '无入口信息', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_BADCPC', 3, 'OBU设备电量低', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_BADCPC', 4, 'CPC卡电量低', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_BADCPC', 5, 'CPC卡无法读取', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_BADCPC', 6, '其他', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_BIG', 1, '有效期单次，已查通行记录', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_GW', 1, '抢险救灾', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_GW', 2, '疫情防控', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_GW', 3, '计量局检泵车', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_HDLWEIGHT', 1, '多轴车', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_TQCAR_HDLWEIGHT', 2, 'CPC卡过错轴', NULL, NULL, NULL);
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_UTTURN', 1, '超吨U转', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_UTTURN', 2, '交通管制', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_UTTURN', 3, '30分钟内', '', '', '');
|
|
|
INSERT INTO M_CODEDICTIONARY([TYPENAME], [ID], [TEXT], [EXPLAIN], [Expand1], [Expand2]) VALUES ('KEY_UTTURN', 4, '其他', '', '', '');
|