From 2899544d5e9001cdaa824405d234d8e4138f7063 Mon Sep 17 00:00:00 2001 From: zhangherong <571457620@qq.com> Date: 星期六, 12 七月 2025 16:35:49 +0800 Subject: [PATCH] art: 技术状态鉴定工单变更-字典添加 --- db/ZHR/dict_zhr.sql | 37 +++++++++++++++++++++++++++++++++++++ 1 files changed, 37 insertions(+), 0 deletions(-) diff --git a/db/ZHR/dict_zhr.sql b/db/ZHR/dict_zhr.sql index 86d71cd..790f3de 100644 --- a/db/ZHR/dict_zhr.sql +++ b/db/ZHR/dict_zhr.sql @@ -70,3 +70,40 @@ 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'); -- Gitblit v1.9.3