-- 设备运行状态字典增加:7 = 停机(工位退出/收班) INSERT INTO js_sys_dict_data ( dict_code, parent_code, parent_codes, tree_sort, tree_sorts, tree_leaf, tree_level, tree_names, dict_label, dict_value, dict_icon, dict_type, is_sys, description, css_style, css_class, status, create_by, create_date, update_by, update_date, remarks, corp_code, corp_name ) SELECT 'mes_device_state_7', '0', '0,', 210, '0000000210,', '1', 0, '停机', '停机', '7', '', 'mes_device_state', '1', '工位退出/收班', '', '', '0', 'system', NOW(), 'system', NOW(), '', '0', 'JeeSite' FROM DUAL WHERE NOT EXISTS ( SELECT 1 FROM js_sys_dict_data WHERE dict_type = 'mes_device_state' AND dict_value = '7' );