--技术状态鉴定工单状态
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_status');
delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_status';

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1943282255763828737', N'技术状态鉴定工单状态', N'technical_status_evaluation_order_status', N'设备管理使用', 0, N'admin', '2025-07-10 20:12:48.8660000', NULL, NULL, NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282353361088513', N'1943282255763828737', N'待鉴定', N'WAIT_EVALUATION', '', 1, 1, N'admin', '2025-07-10 20:13:12.1370000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282402136649730', N'1943282255763828737', N'鉴定中', N'UNDER_EVALUATION', '', 2, 1, N'admin', '2025-07-10 20:13:23.7750000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282529404416002', N'1943282255763828737', N'维修人签字中', N'REPAIRER_SIGNING', '', 3, 1, N'admin', '2025-07-10 20:13:54.1090000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282588527325186', N'1943282255763828737', N'维修室主任签字中', N'REPAIR_MANAGER_SIGNING', '', 4, 1, N'admin', '2025-07-10 20:14:08.2040000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282688888631297', N'1943282255763828737', N'工艺员签字中', N'PROCESS_TECHNICIAN_SIGNING', '', 5, 1, N'admin', '2025-07-10 20:14:32.1330000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282764902002689', N'1943282255763828737', N'使用单位技术主管签字中', N'DEPART_TECHNICAL_LEADER_SIGNING', '', 6, 1, N'admin', '2025-07-10 20:14:50.2570000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282836200976386', N'1943282255763828737', N'设备检验员签字中', N'INSPECTOR_SIGNING', '', 7, 1, N'admin', '2025-07-10 20:15:07.2550000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282897358123009', N'1943282255763828737', N'已完成', N'COMPLETED', '', 8, 1, N'admin', '2025-07-10 20:15:21.8360000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282982930313218', N'1943282255763828737', N'已锁定', N'LOCKED', '', 9, 1, N'admin', '2025-07-10 20:15:42.2430000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943283076018696194', N'1943282255763828737', N'变更中', N'CHANGING', '', 10, 1, N'admin', '2025-07-10 20:16:04.4340000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943283135447789569', N'1943282255763828737', N'已过期', N'EXPIRED', '', 11, 1, N'admin', '2025-07-10 20:16:18.6020000', NULL, NULL);

--技术状态检查项分类
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_check_category');
delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_check_category';

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1942406054790733826', N'技术状态检查项分类', N'technical_status_evaluation_check_category', N'设备管理使用', 0, N'admin', '2025-07-08 10:11:06.2770000', NULL, NULL, NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942406262689800193', N'1942406054790733826', N'安全装置检查', N'SAFETY_EQUIPMENT_CHECK', '', 1, 1, N'admin', '2025-07-08 10:11:55.8440000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942406374128263170', N'1942406054790733826', N'精度检查', N'PRECISION_CHECK', '', 2, 1, N'admin', '2025-07-08 10:12:22.4130000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942406681549774850', N'1942406054790733826', N'其他检查', N'OTHER_CHECK', '', 3, 1, N'admin', '2025-07-08 10:13:35.7220000', NULL, NULL);

--技术状态鉴定规范状态
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_standard_status');
delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_standard_status';

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1942405419550810113', N'技术状态鉴定规范状态', N'technical_status_evaluation_standard_status', N'设备管理使用', 0, N'admin', '2025-07-08 10:08:34.8250000', NULL, NULL, NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942405572965867522', N'1942405419550810113', N'待提交', N'WAIT_SUBMIT', '', 1, 1, N'admin', '2025-07-08 10:09:11.4020000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942405638514450434', N'1942405419550810113', N'启用', N'ENABLE', '', 2, 1, N'admin', '2025-07-08 10:09:27.0300000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942405710740365313', N'1942405419550810113', N'禁用', N'DISABLE', '', 3, 1, N'admin', '2025-07-08 10:09:44.2500000', NULL, NULL);

--HF模板分类
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='hf_template_category');
delete from [dbo].[sys_dict] where dict_code='hf_template_category';

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1941372067586695170', N'HF模板分类', N'hf_template_category', N'设备管理使用', 0, N'admin', '2025-07-05 13:42:24.5310000', NULL, NULL, NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941372224336224258', N'1941372067586695170', N'点检', N'INSPECTION', '', 1, 1, N'admin', '2025-07-05 13:43:01.9000000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941372326169731074', N'1941372067586695170', N'二保', N'SECOND_MAINTENANCE', '', 2, 1, N'admin', '2025-07-05 13:43:26.1820000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941372412710805506', N'1941372067586695170', N'三保移交单', N'THIRD_MAINTENANCE_HANDOVER', '', 3, 1, N'admin', '2025-07-05 13:43:46.0000000', N'admin', '2025-07-10 15:26:39.3940000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943210356597813250', N'1941372067586695170', N'三保验收单', N'THIRD_MAINTENANCE_ACCEPTANCE', '', 4, 1, N'admin', '2025-07-10 15:27:06.7660000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943210616086818818', N'1941372067586695170', N'技术状态鉴定表', N'TECHNICAL_STATUS_EVALUATION', '', 5, 1, N'admin', '2025-07-10 15:28:08.0000000', N'admin', '2025-07-10 15:31:13.3650000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943210729806983169', N'1941372067586695170', N'安全装置检查表', N'TECHNICAL_STATUS_EVALUATION_SAFETY_CHECK', '', 6, 1, N'admin', '2025-07-10 15:28:35.0000000', N'admin', '2025-07-10 15:29:46.5590000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943211129419296770', N'1941372067586695170', N'其他检查表', N'TECHNICAL_STATUS_EVALUATION_OTHER_CHECK', '', 7, 1, N'admin', '2025-07-10 15:30:11.0000000', N'admin', '2025-07-10 15:31:23.8110000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943211241587568641', N'1941372067586695170', N'设备精度检查表', N'TECHNICAL_STATUS_EVALUATION_PRECISION_CHECK', '', 8, 1, N'admin', '2025-07-10 15:30:37.0000000', N'admin', '2025-07-10 15:31:29.2060000');

--启用禁用
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='enable_disable');
delete from [dbo].[sys_dict] where dict_code='enable_disable';

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1941370835371483137', N'启用禁用', N'enable_disable', N'通用数据字典', 0, N'admin', '2025-07-05 13:37:30.7420000', NULL, NULL, NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941370959137005570', N'1941370835371483137', N'启用', N'ENABLE', '', 1, 1, N'admin', '2025-07-05 13:38:00.2500000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941371030628917250', N'1941370835371483137', N'禁用', N'DISABLE', '', 2, 1, N'admin', '2025-07-05 13:38:17.2920000', NULL, NULL);

--技术状态
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='equipment_technology_status');
delete from [dbo].[sys_dict] where dict_code='equipment_technology_status';

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1940319386308980737', N'技术状态', N'equipment_technology_status', N'设备管理使用', 0, N'admin', '2025-07-02 15:59:25.0000000', N'admin', '2025-07-03 10:27:26.5370000', NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1940319446841176066', N'1940319386308980737', N'合格', N'QUALIFIED', '', 1, 1, N'admin', '2025-07-02 15:59:40.0000000', N'admin', '2025-07-11 11:23:11.9870000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1940319476352299010', N'1940319386308980737', N'限用', N'RESTRICTED', '', 2, 1, N'admin', '2025-07-02 15:59:47.0000000', N'admin', '2025-07-11 11:23:52.7830000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943511780124659714', N'1940319386308980737', N'禁用', N'PROHIBITED', '', 3, 1, N'admin', '2025-07-11 11:24:51.7410000', NULL, NULL);

--技术状态鉴定工单变更原因
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_change_reason');
delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_change_reason';

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1943939430844620802', N'技术状态鉴定工单变更原因', N'technical_status_evaluation_order_change_reason', N'设备管理使用', 0, N'admin', '2025-07-12 15:44:11.6180000', NULL, NULL, NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943941741276979202', N'1943939430844620802', N'生产任务急无法停机', N'PRODUCTION_WORK_ORDER_EXPEDITED', '', 1, 1, N'admin', '2025-07-12 15:53:22.4680000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943941811498016770', N'1943939430844620802', N'设备故障正处于维修状态', N'EQUIPMENT_BREAKDOWN_REPAIR', '', 2, 1, N'admin', '2025-07-12 15:53:39.2090000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943941870868389889', N'1943939430844620802', N'设备已报废', N'EQUIPMENT_SCRAPPED', '', 3, 1, N'admin', '2025-07-12 15:53:53.3640000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943941956709015554', N'1943939430844620802', N'设备大修', N'EQUIPMENT_MAJOR', '', 4, 1, N'admin', '2025-07-12 15:54:13.8300000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943942061625335809', N'1943939430844620802', N'设备搬迁', N'EQUIPMENT_RELOCATION', '', 5, 1, N'admin', '2025-07-12 15:54:38.8450000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943942122652459010', N'1943939430844620802', N'设备改造', N'EQUIPMENT_RETROFITTING', '', 6, 1, N'admin', '2025-07-12 15:54:53.3960000', NULL, NULL);

--技术状态鉴定工单变更状态
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_change_status');
delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_change_status';

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1943933734891708418', N'技术状态鉴定工单变更状态', N'technical_status_evaluation_order_change_status', N'设备管理使用', 0, N'admin', '2025-07-12 15:21:33.5970000', NULL, NULL, NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943938381878550530', N'1943933734891708418', N'待提交', N'WAIT_SUBMIT', '', 1, 1, N'admin', '2025-07-12 15:40:01.5240000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943938456247754753', N'1943933734891708418', N'主管领导签字中', N'EQUIPMENT_MANAGER_SIGNING', '', 2, 1, N'admin', '2025-07-12 15:40:19.2550000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943938510379442177', N'1943933734891708418', N'部门领导签字中', N'DEPART_MANAGER_SIGNING', '', 3, 1, N'admin', '2025-07-12 15:40:32.1620000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943938563349307393', N'1943933734891708418', N'保障部领导签字中', N'PRODUCTION_SUPPORT_SIGNING', '', 4, 1, N'admin', '2025-07-12 15:40:44.7920000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943938618584096770', N'1943933734891708418', N'已作废', N'ABOLISH', '', 6, 1, N'admin', '2025-07-12 15:40:57.0000000', N'admin', '2025-07-12 15:41:24.3860000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943938696413601793', N'1943933734891708418', N'已完成', N'COMPLETED', '', 5, 1, N'admin', '2025-07-12 15:41:16.0000000', N'admin', '2025-07-12 15:41:29.4120000');

--技术状态鉴定结果原因
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_result_reason');
delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_result_reason';

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1943508627786436609', N'技术状态鉴定结果原因', N'technical_status_evaluation_result_reason', N'设备管理使用', 0, N'admin', '2025-07-11 11:12:20.1790000', NULL, NULL, NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943951156122116097', N'1943508627786436609', N'安全装置', N'SAFETY_EQUIPMENT_CHECK', '', 1, 1, N'admin', '2025-07-12 16:30:47.1420000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943951206004973570', N'1943508627786436609', N'设备精度', N'EQUIPMENT_PRECISION_CHECK', '', 2, 1, N'admin', '2025-07-12 16:30:59.0340000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943951255988494337', N'1943508627786436609', N'设备功能', N'EQUIPMENT_FUNCTIONAL_CHECK', '', 3, 1, N'admin', '2025-07-12 16:31:10.9520000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943951312682901505', N'1943508627786436609', N'试切', N'SAMPLE_CHECK', '', 4, 1, N'admin', '2025-07-12 16:31:24.4670000', NULL, NULL);
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943951373072490497', N'1943508627786436609', N'其他', N'OTHER_CHECK', '', 5, 1, N'admin', '2025-07-12 16:31:38.0000000', N'admin', '2025-07-12 16:31:46.0150000');
