Merge remote-tracking branch 'origin/master'
| | |
| | | "avatar": "", |
| | | "version": "4.9.2", |
| | | "createdTime": "2025-3-10 16:38:19", |
| | | "updatedTime": "2025-7-8 15:34:54", |
| | | "updatedTime": "2025-7-9 19:20:22", |
| | | "dbConns": [], |
| | | "profile": { |
| | | "default": { |
| | |
| | | "id": "F19406B3-1B81-484F-B916-81143EB092A4" |
| | | }, |
| | | { |
| | | "defKey": "process_technicianâ_signature", |
| | | "defKey": "process_technician_signature", |
| | | "defName": "å·¥èºåç¾å", |
| | | "comment": "", |
| | | "type": "", |
| | |
| | | "id": "44FAEC7F-5BA9-4AD0-8692-DA36C64E4B7C" |
| | | }, |
| | | { |
| | | "defKey": "process_technicianâ_signature_time", |
| | | "defKey": "process_technician_signature_time", |
| | | "defName": "å·¥èºåç¾åæ¶é´", |
| | | "comment": "", |
| | | "type": "", |
¶Ô±ÈÐÂÎļþ |
| | |
| | | -- HFç¼ç ç»´æ¤ |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_base_hf_code]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_base_hf_code]; |
| | | CREATE TABLE [dbo].[eam_base_hf_code] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | del_flag INT, |
| | | hf_code NVARCHAR(100), |
| | | hf_name NVARCHAR(255), |
| | | hf_category NVARCHAR(64), |
| | | hf_status NVARCHAR(64), |
| | | hf_version NVARCHAR(50), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ¥è¡¨HFCodeç»´æ¤', 'SCHEMA', dbo, 'table', eam_base_hf_code, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', |
| | | create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', |
| | | update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å 餿 è®°', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', del_flag; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'HFç¼ç ', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', hf_code; |
| | | EXEC sp_addextendedproperty 'MS_Description', '模æ¿åç§°', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', hf_name; |
| | | EXEC sp_addextendedproperty 'MS_Description', '模æ¿åç±»', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', |
| | | hf_category; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç¶æ;å¯ç¨ãç¦ç¨', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', |
| | | hf_status; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'çæ¬;V1ï¼V2+', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', |
| | | hf_version; |
| | | |
| | | --ææ¯é´å®è§è |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_standard]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_evaluation_standard]; |
| | | CREATE TABLE [dbo].[eam_technical_status_evaluation_standard] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | del_flag INT, |
| | | standard_name NVARCHAR(255), |
| | | standard_code NVARCHAR(50), |
| | | evaluation_period INT, |
| | | equipment_id NVARCHAR(32), |
| | | standard_status NVARCHAR(64), |
| | | has_safety_equipment_check NVARCHAR(64), |
| | | has_precision_check NVARCHAR(64), |
| | | has_other_check NVARCHAR(64), |
| | | standard_version NVARCHAR(50), |
| | | remark NVARCHAR(255), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ææ¯ç¶æé´å®è§è', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_standard, |
| | | 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å 餿 è®°', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', del_flag; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'è§èåç§°', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', standard_name; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'è§èç¼ç ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', standard_code; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'é´å®å¨æ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', evaluation_period; |
| | | EXEC sp_addextendedproperty 'MS_Description', '设å¤ID', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', equipment_id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'è§èç¶æ;å¾
æäº¤ãå¯ç¨ãä½åº', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', standard_status; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ¯å¦æå®å
¨è£
ç½®æ£æ¥;æ¯å¦', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', has_safety_equipment_check; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ¯å¦æè®¾å¤ç²¾åº¦æ£æ¥;æ¯å¦', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', has_precision_check; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ¯å¦æå
¶ä»æ£æ¥;æ¯å¦', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', has_other_check; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'çæ¬;V1,V2+', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard, 'column', standard_version; |
| | | EXEC sp_addextendedproperty 'MS_Description', '夿³¨', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_standard, |
| | | 'column', remark; |
| | | |
| | | --ææ¯ç¶æé´å®è§èæç» |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_standard_detail]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_evaluation_standard_detail]; |
| | | CREATE TABLE [dbo].[eam_technical_status_evaluation_standard_detail] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | standard_id NVARCHAR(32), |
| | | check_category NVARCHAR(64), |
| | | item_code INT, |
| | | item_name NVARCHAR(255), |
| | | tolerance_value NVARCHAR(100), |
| | | sub_item_name NVARCHAR(255), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ææ¯ç¶æé´å®è§èæç»', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'è§èID', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', standard_id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ£æ¥åç±»;ç²¾åº¦æ£æ¥ãå®å
¨è£
ç½®æ£æ¥ãå
¶ä»æ£æ¥', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', check_category; |
| | | EXEC sp_addextendedproperty 'MS_Description', '项ç®åºå·', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', item_code; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ£æ¥é¡¹ç®', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', item_name; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å
å·®å¼;ç²¾åº¦æ£æ¥å±ç¤º', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', tolerance_value; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ£æ¥å项ç®;ç²¾åº¦æ£æ¥å±ç¤ºï¼å¯ä»¥ä¸ºç©º', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_standard_detail, 'column', sub_item_name; |
| | | |
| | | --ææ¯ç¶æé´å®å·¥å |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_evaluation_order]; |
| | | CREATE TABLE [dbo].[eam_technical_status_evaluation_order] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | del_flag INT, |
| | | order_num NVARCHAR(50), |
| | | equipment_id NVARCHAR(32), |
| | | standard_id NVARCHAR(32), |
| | | evaluation_date DATETIME2, |
| | | freeze_order_date DATETIME2, |
| | | order_expiration_date DATETIME2, |
| | | actual_start_time DATETIME2, |
| | | actual_end_time DATETIME2, |
| | | evaluator NVARCHAR(50), |
| | | evaluation_status NVARCHAR(64), |
| | | creation_method NVARCHAR(64), |
| | | safety_equipment_check_result NVARCHAR(64), |
| | | precision_check_result NVARCHAR(64), |
| | | functional_check_result NVARCHAR(64), |
| | | other_check_result NVARCHAR(64), |
| | | repair_manager_signature NVARCHAR(50), |
| | | repair_manager_signature_time_1 DATETIME2, |
| | | sample_check_result NVARCHAR(64), |
| | | process_technician_signature NVARCHAR(50), |
| | | process_technician_signature_time DATETIME2, |
| | | evaluation_result NVARCHAR(64), |
| | | evaluation_reason NVARCHAR(64), |
| | | inspector_signature NVARCHAR(50), |
| | | inspector_signature_time DATETIME2, |
| | | hf_code_a NVARCHAR(100), |
| | | hf_code_b NVARCHAR(100), |
| | | hf_code_c NVARCHAR(100), |
| | | hf_code_d NVARCHAR(100), |
| | | remark NVARCHAR(255), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ææ¯ç¶æé´å®å·¥å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å 餿 è®°', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', del_flag; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å·¥åå·', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', order_num; |
| | | EXEC sp_addextendedproperty 'MS_Description', '设å¤ID', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', equipment_id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'è§èID', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', standard_id; |
| | | EXEC sp_addextendedproperty 'MS_Description', '计åé´å®æ¥æ;æå70天çæå·¥å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', evaluation_date; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'éå®å·¥åæ¥æ;æå55天éå®å·¥å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', freeze_order_date; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å·¥åè¿ææ¥æ;å°ææªåç´æ¥è¿æï¼å¹¶ä¿®æ¹è®¾å¤ææ¯ç¶æä¸ºç¦ç¨', 'SCHEMA', dbo, |
| | | 'table', eam_technical_status_evaluation_order, 'column', order_expiration_date; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å®é
å¼å§æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', actual_start_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å®é
ç»ææ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', actual_end_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'é´å®äºº', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', evaluator; |
| | | EXEC sp_addextendedproperty 'MS_Description', |
| | | 'é´å®ç¶æ;å¾
é´å®ãé´å®ä¸ã维修室主任ç¾åãå·¥èºäººåç¾åãææ¯ä¸»ç®¡ç¾åãè®¾å¤æ£éªåç¾åã已宿ãå·²éå®ãåæ´ä¸ãå·²è¿æ', |
| | | 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, 'column', evaluation_status; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¹å¼', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', creation_method; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å®å
¨è£
ç½®æ£æ¥ç»æ;æ¯ãå¦', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', safety_equipment_check_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç²¾åº¦åæ°æ£æ¥ç»æ;æ¯ãå¦ãæ ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', precision_check_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åè½ç¶ææ£æ¥ç»æ;æ¯ãå¦', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', functional_check_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å
¶ä»æ£æ¥ç»æ;æ¯ãå¦ãæ ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', other_check_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', '维修室主任ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', repair_manager_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', '维修室主任ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', repair_manager_signature_time_1; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'è¯ä»¶æ£æ¥ç»æ;åæ ¼ãä¸åæ ¼', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', sample_check_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å·¥èºåç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', process_technician_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å·¥èºåç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', process_technician_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'é´å®ç»æ;åæ ¼ãéç¨ãç¦ç¨', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', evaluation_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'é\ç¦ç¨åå (å¤é);å®å
¨è£
ç½®ã设å¤åè½ã精度ãè¯ä»¶ãå
¶ä»', 'SCHEMA', dbo, |
| | | 'table', eam_technical_status_evaluation_order, 'column', evaluation_reason; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'è®¾å¤æ£æ¥äººç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', inspector_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'è®¾å¤æ£æ¥äººç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', inspector_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'éå½A HFç¼ç ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', hf_code_a; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'éå½B HFç¼ç ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', hf_code_b; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'éå½C HFç¼ç ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', hf_code_c; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'éå½D HFç¼ç ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order, 'column', hf_code_d; |
| | | EXEC sp_addextendedproperty 'MS_Description', '夿³¨', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, |
| | | 'column', remark; |
| | | |
| | | --ææ¯ç¶æé´å®å·¥åæç» |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order_detail]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_evaluation_order_detail]; |
| | | CREATE TABLE [dbo].[eam_technical_status_evaluation_order_detail] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | item_code INT, |
| | | check_category NVARCHAR(64), |
| | | item_name NVARCHAR(255), |
| | | tolerance_value NVARCHAR(100), |
| | | sub_item_name NVARCHAR(255), |
| | | safety_equipment_check_result NVARCHAR(64), |
| | | other_check_result NVARCHAR(255), |
| | | precision_check_result NUMERIC(24, 4), |
| | | repairman_signature NVARCHAR(50), |
| | | repairman_signature_time DATETIME2, |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ææ¯ç¶æé´å®å·¥åæç»', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åºå·', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', item_code; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ£æ¥åç±»;ç²¾åº¦æ£æ¥ãå®å
¨è£
ç½®æ£æ¥ãå
¶ä»æ£æ¥', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', check_category; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ£æ¥é¡¹ç®', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', item_name; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å
å·®å¼;ç²¾åº¦æ£æ¥å±ç¤º', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', tolerance_value; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ£æ¥å项ç®;ç²¾åº¦æ£æ¥å±ç¤ºï¼å¯ä»¥ä¸ºç©º', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', sub_item_name; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å®å
¨è£
ç½®æ£æ¥ç»æ;æ¯ãå¦ãæ ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', safety_equipment_check_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å
¶ä»æ£æ¥ç»æ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', other_check_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', '精度æ£éªç»æ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', precision_check_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', '维修人/ç²¾åº¦æ£æ¥è
ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', repairman_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', '维修人/ç²¾åº¦æ£æ¥è
ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_detail, 'column', repairman_signature_time; |
| | | |
| | | |
| | | --ææ¯ç¶æé´å®å·¥ååæ´ |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order_change]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_evaluation_order_change]; |
| | | CREATE TABLE [dbo].[eam_technical_status_evaluation_order_change] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | del_flag INT, |
| | | order_id NVARCHAR(32), |
| | | change_order_num NVARCHAR(100), |
| | | applicant NVARCHAR(50), |
| | | factory_org_code NVARCHAR(100), |
| | | apply_date DATETIME2, |
| | | change_status NVARCHAR(64), |
| | | apply_reason NVARCHAR(64), |
| | | deferred_maintenance_date DATETIME2, |
| | | equipment_manager_signature NVARCHAR(50), |
| | | equipment_manager_signature_time DATETIME2, |
| | | depart_manager_signature NVARCHAR(50), |
| | | depart_manager_signature_time DATETIME2, |
| | | depart_manager_comment NVARCHAR(255), |
| | | production_support_signature NVARCHAR(50), |
| | | production_support_signature_time DATETIME2, |
| | | production_support_comment NVARCHAR(255), |
| | | hf_code NVARCHAR(100), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ææ¯ç¶æé´å®å·¥ååæ´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å 餿 è®°', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', del_flag; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å·¥åID', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', order_id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åæ´åå·', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', change_order_num; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·äºº', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', applicant; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·é¨é¨', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', factory_org_code; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·æ¥æ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', apply_date; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åæ´ç¶æ;å¾
æäº¤ãå¾
ä¸»ç®¡å®¡æ ¸ãå¾
é¨é¨ç¡®è®¤ãå¾
ä¿éé¨ç¡®è®¤ãå·²ä½åºã已宿', |
| | | 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order_change, 'column', change_status; |
| | | EXEC sp_addextendedproperty 'MS_Description', |
| | | 'åæ´åå ;çäº§ä»»å¡æ¥æ æ³åæºãè®¾å¤æ
鿣å¤äºç»´ä¿®ç¶æã设å¤å·²æ¥åºã设å¤å¤§ä¿®ãæ¬è¿ãæ¹é ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', apply_reason; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åæ´é´å®æ¥æ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', deferred_maintenance_date; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主管é¢å¯¼ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主管é¢å¯¼ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'é¨é¨é¢å¯¼ç¾å;æ ¹æ®åæ´åå ç±»ååºåä¸åç人审æ¹', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', depart_manager_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'é¨é¨é¢å¯¼ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', depart_manager_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'é¨é¨é¢å¯¼æè§', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', depart_manager_comment; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç产ä¿éé¨é¢å¯¼ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', production_support_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç产ä¿éé¨é¢å¯¼ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', production_support_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç产ä¿éé¨é¢å¯¼æè§', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', production_support_comment; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'HFç¼ç ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_order_change, 'column', hf_code; |
| | | |
| | | |
| | | --ææ¯ç¶æåæ´ç³è¯· |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_change]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_change]; |
| | | CREATE TABLE [dbo].[eam_technical_status_change] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | del_flag INT, |
| | | change_order_num NVARCHAR(100), |
| | | change_status NVARCHAR(64), |
| | | designer NVARCHAR(50), |
| | | designer_time DATETIME2, |
| | | depart_header_signature NVARCHAR(50), |
| | | depart_header_signature_time DATETIME2, |
| | | depart_header_signature_comment NVARCHAR(255), |
| | | depart_leader_signature NVARCHAR(50), |
| | | depart_leader_signature_time DATETIME2, |
| | | depart_leader_signature_comment NVARCHAR(255), |
| | | hf_code NVARCHAR(100), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ææ¯ç¶æåæ´ç³è¯·', 'SCHEMA', dbo, 'table', eam_technical_status_change, |
| | | null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', |
| | | create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', |
| | | create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', |
| | | update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', |
| | | update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å 餿 è®°', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', |
| | | del_flag; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åæ´åå·', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', |
| | | change_order_num; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åæ´åç¶æ', 'SCHEMA', dbo, 'table', eam_technical_status_change, |
| | | 'column', change_status; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç¼å¶äºº', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', |
| | | designer; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç¼å¶æ¶é´', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', |
| | | designer_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½å®¤ä¸»ç®¡ç¾å', 'SCHEMA', dbo, 'table', eam_technical_status_change, |
| | | 'column', depart_header_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½å®¤ä¸»ç®¡ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_change, 'column', depart_header_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½å®¤ä¸»ç®¡æè§', 'SCHEMA', dbo, 'table', eam_technical_status_change, |
| | | 'column', depart_header_signature_comment; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½é¨ä¸»ç®¡ç¾å', 'SCHEMA', dbo, 'table', eam_technical_status_change, |
| | | 'column', depart_leader_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½é¨ä¸»ç®¡ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_change, 'column', depart_leader_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½é¨ä¸»ç®¡ç¾å', 'SCHEMA', dbo, 'table', eam_technical_status_change, |
| | | 'column', depart_leader_signature_comment; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'HFç¼ç ', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', |
| | | hf_code; |
| | | |
| | | |
| | | --ææ¯ç¶æåæ´ç³è¯·æç» |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_change_detail]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_change_detail]; |
| | | CREATE TABLE [dbo].[eam_technical_status_change_detail] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | equipment_id NVARCHAR(32), |
| | | change_category NVARCHAR(64), |
| | | change_date DATETIME2, |
| | | change_technical_status NVARCHAR(64), |
| | | acceptance_checker NVARCHAR(50), |
| | | acceptance_check_time DATETIME2, |
| | | acceptance_check_result NVARCHAR(64), |
| | | order_id NVARCHAR(32), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ææ¯ç¶æåæ´ç³è¯·æç»', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_change_detail, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, |
| | | 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, |
| | | 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, |
| | | 'column', create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, |
| | | 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, |
| | | 'column', update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', '设å¤ID', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, |
| | | 'column', equipment_id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åæ´åå ;æ¬è¿ãå¤§ä¿®ãæ¹é ãå
¶ä»', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_change_detail, 'column', change_category; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åæ´æ¥æ', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, |
| | | 'column', change_date; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åæ´åææ¯ç¶æ;åæ´éè¿åé»è®¤è®¾å¤ææ¯ç¶ææ¹ä¸ºç¦ç¨', 'SCHEMA', dbo, |
| | | 'table', eam_technical_status_change_detail, 'column', change_technical_status; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'éªæ¶æ£æ¥äºº', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, |
| | | 'column', acceptance_checker; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'éªæ¶æ£æ¥æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_change_detail, 'column', acceptance_check_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', |
| | | 'éªæ¶æ£æ¥ç»æ;å¤§ä¿®ãæ¹é éè¦å¡«åéªæ¶ç»æï¼æ¬è¿æç
§ææ¯ç¶æé´å®å·¥åç»´æ¤ï¼å
¶ä»ææªä½¿ç¨å°ï¼åªé¢çæ¤ç±»å', 'SCHEMA', dbo, |
| | | 'table', eam_technical_status_change_detail, 'column', acceptance_check_result; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ææ¯ç¶æé´å®å·¥åID;æ¬è¿ä½¿ç¨', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_change_detail, 'column', order_id; |
| | | |
| | | |
| | | --å å·¥è®¾å¤ææ¯é´å®ç³è¯· |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_application]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_evaluation_application]; |
| | | CREATE TABLE [dbo].[eam_technical_status_evaluation_application] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | del_flag INT, |
| | | application_order_num NVARCHAR(100), |
| | | applicant NVARCHAR(50), |
| | | factory_org_code NVARCHAR(100), |
| | | apply_date DATETIME2, |
| | | application_status NVARCHAR(64), |
| | | depart_header_signature NVARCHAR(50), |
| | | depart_header_signature_time DATETIME2, |
| | | depart_header_comment NVARCHAR(255), |
| | | production_header_signature NVARCHAR(50), |
| | | production_header_signature_time DATETIME2, |
| | | production_header_comment NVARCHAR(255), |
| | | production_support_signature NVARCHAR(50), |
| | | production_support_signature_time DATETIME2, |
| | | production_support_comment NVARCHAR(255), |
| | | hf_code NVARCHAR(100), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å å·¥è®¾å¤ææ¯é´å®ç³è¯·;ç¦ç¨ç¶æçè®¾å¤æä¸´æ¶è¿è¡ææ¯é´å®æ¶ä½¿ç¨', 'SCHEMA', |
| | | dbo, 'table', eam_technical_status_evaluation_application, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å 餿 è®°', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', del_flag; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·åå·', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', application_order_num; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·äºº', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', applicant; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·é¨é¨', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', factory_org_code; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·æ¥æ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', apply_date; |
| | | EXEC sp_addextendedproperty 'MS_Description', |
| | | 'ç³è¯·åç¶æ;å¾
æäº¤ãå¾
åä½å®¤çº§é¢å¯¼å®¡æ ¸ãç产设å¤ç®¡çä¸»ç®¡å®¡æ ¸ãå¾
ä¿éé¨é¢å¯¼å®¡æ ¸ãå·²ä½åºã已宿', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', application_status; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·åä½å®¤çº§é¢å¯¼ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', depart_header_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·åä½å®¤çº§é¢å¯¼ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', depart_header_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·åä½å®¤çº§é¢å¯¼æè§', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', depart_header_comment; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç产设å¤ç®¡ç主管ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', production_header_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç产设å¤ç®¡ç主管ç¾ååä»¶', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', production_header_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç产设å¤ç®¡ç主管æè§', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', production_header_comment; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç产ä¿éé¨é¢å¯¼ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', production_support_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç产ä¿éé¨é¢å¯¼ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', production_support_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç产ä¿éé¨é¢å¯¼æè§', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', production_support_comment; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'HFç¼ç ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_evaluation_application, 'column', hf_code; |
| | | |
| | | --åç¨å 工设å¤ç³è¯·å |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_deactivate]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_deactivate]; |
| | | CREATE TABLE [dbo].[eam_technical_status_deactivate] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | del_flag INT, |
| | | deactivate_order_num NVARCHAR(100), |
| | | applicant NVARCHAR(50), |
| | | factory_org_code NVARCHAR(100), |
| | | apply_date DATETIME2, |
| | | application_status NVARCHAR(64), |
| | | depart_header_signature NVARCHAR(50), |
| | | depart_header_signature_time DATETIME2, |
| | | depart_header_signature_comment NVARCHAR(255), |
| | | depart_leader_signature NVARCHAR(50), |
| | | depart_leader_signature_time DATETIME2, |
| | | depart_leader_signature_comment NVARCHAR(255), |
| | | hf_code NVARCHAR(100), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åç¨å 工设å¤ç³è¯·å;ç³è¯·åä½ç³è¯·åç¨è®¾å¤ï¼å®¡æ¹éè¿åä¿®æ¹è®¾å¤ç¶æä¸ºç¦ç¨', |
| | | 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, 'column', |
| | | id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å 餿 è®°', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', del_flag; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åç¨åå·', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', deactivate_order_num; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·äºº', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', applicant; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·é¨é¨', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', factory_org_code; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'ç³è¯·æ¥æ', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', apply_date; |
| | | EXEC sp_addextendedproperty 'MS_Description', |
| | | 'ç³è¯·åç¶æ;å¾
æäº¤ãå¾
åä½å®¤çº§é¢å¯¼å®¡æ ¸ãç产设å¤ç®¡çä¸»ç®¡å®¡æ ¸ãå¾
ä¿éé¨é¢å¯¼å®¡æ ¸ãå·²ä½åºã已宿', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate, 'column', application_status; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½å®¤ä¸»ç®¡ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate, 'column', depart_header_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½å®¤ä¸»ç®¡ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate, 'column', depart_header_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½å®¤ä¸»ç®¡æè§', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate, 'column', depart_header_signature_comment; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½é¨ä¸»ç®¡ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate, 'column', depart_leader_signature; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½é¨ä¸»ç®¡ç¾åæ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate, 'column', depart_leader_signature_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', '使ç¨åä½é¨ä¸»ç®¡ç¾å', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate, 'column', depart_leader_signature_comment; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'HFç¼ç ', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, |
| | | 'column', hf_code; |
| | | |
| | | |
| | | --åç¨å å·¥è®¾å¤æç» |
| | | IF EXISTS (SELECT * |
| | | FROM sys.objects |
| | | WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_deactivate_detail]') |
| | | AND type in (N'U')) |
| | | DROP TABLE [dbo].[eam_technical_status_deactivate_detail]; |
| | | CREATE TABLE [dbo].[eam_technical_status_deactivate_detail] |
| | | ( |
| | | id NVARCHAR(32) NOT NULL, |
| | | create_by NVARCHAR(50), |
| | | create_time DATETIME2, |
| | | update_by NVARCHAR(50), |
| | | update_time DATETIME2, |
| | | equipment_id NVARCHAR(32), |
| | | deactivate_reason NVARCHAR(255), |
| | | deactivate_duration NUMERIC(24, 4), |
| | | deactivate_duration_unit NVARCHAR(64), |
| | | PRIMARY KEY (id) |
| | | ); |
| | | |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åç¨å å·¥è®¾å¤æç»', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate_detail, null, null; |
| | | EXEC sp_addextendedproperty 'MS_Description', '主é®', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate_detail, |
| | | 'column', id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建人', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate_detail, |
| | | 'column', create_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'å建æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate_detail, 'column', create_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°äºº', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate_detail, |
| | | 'column', update_by; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'æ´æ°æ¶é´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate_detail, 'column', update_time; |
| | | EXEC sp_addextendedproperty 'MS_Description', '设å¤ID', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate_detail, |
| | | 'column', equipment_id; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åç¨åå ', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate_detail, 'column', deactivate_reason; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åç¨æ¶é¿', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate_detail, 'column', deactivate_duration; |
| | | EXEC sp_addextendedproperty 'MS_Description', 'åç¨æ¶é¿åä½;天ãæãå¹´', 'SCHEMA', dbo, 'table', |
| | | eam_technical_status_deactivate_detail, 'column', deactivate_duration_unit; |
| | |
| | | /** |
| | | * æå±åç±» |
| | | */ |
| | | @Excel(name = "æå±åç±»", width = 15, orderNum = "5") |
| | | @Excel(name = "æå±åç±»", width = 15, orderNum = "5",dicCode = "equipment_category") |
| | | @ApiModelProperty(value = "æå±åç±»") |
| | | @Dict(dicCode = "equipment_category") |
| | | private String equipmentCategory; |
| | |
| | | /** |
| | | * è´¨ä¿å¼å§æ¥æ |
| | | */ |
| | | @Excel(name = "è´¨ä¿å¼å§æ¥æ", width = 15, orderNum = "36") |
| | | @Excel(name = "è´¨ä¿å¼å§æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "36") |
| | | @ApiModelProperty(value = "è´¨ä¿å¼å§æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | /** |
| | | * è´¨ä¿ç»ææ¥æ |
| | | */ |
| | | @Excel(name = "è´¨ä¿ç»ææ¥æ", width = 15, orderNum = "37") |
| | | @Excel(name = "è´¨ä¿ç»ææ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "37") |
| | | @ApiModelProperty(value = "è´¨ä¿ç»ææ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**ææ°äºä¿æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "ææ°äºä¿æ¥æ", width = 15, orderNum = "39") |
| | | @Excel(name = "ææ°äºä¿æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "39") |
| | | @ApiModelProperty(value = "ææ°äºä¿æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**䏿¬¡äºä¿æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "䏿¬¡äºä¿æ¥æ", width = 15, orderNum = "40") |
| | | @Excel(name = "䏿¬¡äºä¿æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "40") |
| | | @ApiModelProperty(value = "䏿¬¡äºä¿æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**æ¬æ¬¡ä¸ä¿æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "æ¬æ¬¡ä¸ä¿æ¥æ", width = 15, orderNum = "41") |
| | | @Excel(name = "æ¬æ¬¡ä¸ä¿æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "41") |
| | | @ApiModelProperty(value = "æ¬æ¬¡ä¸ä¿æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**䏿¬¡ä¸ä¿æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "䏿¬¡ä¸ä¿æ¥æ", width = 15, orderNum = "42") |
| | | @Excel(name = "䏿¬¡ä¸ä¿æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "42") |
| | | @ApiModelProperty(value = "䏿¬¡ä¸ä¿æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**ææ°ææ¯ç¶æé´å®æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "ææ°ææ¯ç¶æé´å®æ¥æ", width = 15, orderNum = "44") |
| | | @Excel(name = "ææ°ææ¯ç¶æé´å®æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "44") |
| | | @ApiModelProperty(value = "ææ°ææ¯ç¶æé´å®æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | private java.util.Date latestTechnologyCheck; |
| | | /**ææ¯ç¶æä¸æ¬¡é´å®æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "ææ¯ç¶æä¸æ¬¡é´å®æ¥æ", width = 15, orderNum = "45") |
| | | @Excel(name = "ææ¯ç¶æä¸æ¬¡é´å®æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "45") |
| | | @ApiModelProperty(value = "ææ¯ç¶æä¸æ¬¡é´å®æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | /** |
| | | * æå±åç±» |
| | | */ |
| | | @Excel(name = "æå±åç±»", width = 15, orderNum = "5") |
| | | @Excel(name = "æå±åç±»", width = 15, orderNum = "5",dicCode = "equipment_category") |
| | | @ApiModelProperty(value = "æå±åç±»") |
| | | @Dict(dicCode = "equipment_category") |
| | | private String equipmentCategory; |
| | |
| | | /** |
| | | * ç»´ä¿®çç» |
| | | */ |
| | | @Excel(name = "ç»´ä¿®çç»", width = 15, orderNum = "10",dictTable = "eam_base_repair_depart",dicText = "depart_name",dicCode = "org_code") |
| | | @Excel(name = "ç»´ä¿®çç»", width = 15, orderNum = "10") |
| | | @ApiModelProperty(value = "ç»´ä¿®çç»") |
| | | @Dict(dictTable = "eam_base_repair_depart",dicText = "depart_name",dicCode = "org_code") |
| | | private String repairDepartOrgCode; |
| | |
| | | /** |
| | | * çç«å¨ |
| | | */ |
| | | @Excel(name = "çç«å¨", width = 15, orderNum = "16") |
| | | @Excel(name = "çç«å¨", width = 15, orderNum = "16",dicCode = "yn") |
| | | @ApiModelProperty(value = "çç«å¨") |
| | | @Dict(dicCode = "yn") |
| | | private String fireExtinguisher; |
| | | |
| | | /** |
| | |
| | | /** |
| | | * è´¨ä¿å¼å§æ¥æ |
| | | */ |
| | | @Excel(name = "è´¨ä¿å¼å§æ¥æ", width = 15, orderNum = "36") |
| | | @Excel(name = "è´¨ä¿å¼å§æ¥æ", width = 25, format = "yyyy/MM/dd", orderNum = "36") |
| | | @ApiModelProperty(value = "è´¨ä¿å¼å§æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | /** |
| | | * è´¨ä¿ç»ææ¥æ |
| | | */ |
| | | @Excel(name = "è´¨ä¿ç»ææ¥æ", width = 15, orderNum = "37") |
| | | @Excel(name = "è´¨ä¿ç»ææ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "37") |
| | | @ApiModelProperty(value = "è´¨ä¿ç»ææ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**ææ°äºä¿æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "ææ°äºä¿æ¥æ", width = 15, orderNum = "39") |
| | | @Excel(name = "ææ°äºä¿æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "39") |
| | | @ApiModelProperty(value = "ææ°äºä¿æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**䏿¬¡äºä¿æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "䏿¬¡äºä¿æ¥æ", width = 15, orderNum = "40") |
| | | @Excel(name = "䏿¬¡äºä¿æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "40") |
| | | @ApiModelProperty(value = "䏿¬¡äºä¿æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**æ¬æ¬¡ä¸ä¿æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "æ¬æ¬¡ä¸ä¿æ¥æ", width = 15, orderNum = "41") |
| | | @Excel(name = "æ¬æ¬¡ä¸ä¿æ¥æ", width = 15, format = "yyyy/MM/dd",orderNum = "41") |
| | | @ApiModelProperty(value = "æ¬æ¬¡ä¸ä¿æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**䏿¬¡ä¸ä¿æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "䏿¬¡ä¸ä¿æ¥æ", width = 15, orderNum = "42") |
| | | @Excel(name = "䏿¬¡ä¸ä¿æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "42") |
| | | @ApiModelProperty(value = "䏿¬¡ä¸ä¿æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | |
| | | /**ææ°ææ¯ç¶æé´å®æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "ææ°ææ¯ç¶æé´å®æ¥æ", width = 15, orderNum = "44") |
| | | @Excel(name = "ææ°ææ¯ç¶æé´å®æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "44") |
| | | @ApiModelProperty(value = "ææ°ææ¯ç¶æé´å®æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | private java.util.Date latestTechnologyCheck; |
| | | /**ææ¯ç¶æä¸æ¬¡é´å®æ¥æ*/ |
| | | @TableField(exist = false) |
| | | @Excel(name = "ææ¯ç¶æä¸æ¬¡é´å®æ¥æ", width = 15, orderNum = "45") |
| | | @Excel(name = "ææ¯ç¶æä¸æ¬¡é´å®æ¥æ", width = 15, format = "yyyy/MM/dd", orderNum = "45") |
| | | @ApiModelProperty(value = "ææ¯ç¶æä¸æ¬¡é´å®æ¥æ") |
| | | @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | |
| | | package org.jeecg.modules.eam.request; |
| | | |
| | | import lombok.Data; |
| | | import org.jeecg.common.aspect.annotation.Dict; |
| | | import org.jeecgframework.poi.excel.annotation.Excel; |
| | | |
| | | @Data |
| | | public class EamEquipmentQuery { |
| | |
| | | private String operationSystem; |
| | | private String orgId; |
| | | private String equipmentCategory; |
| | | |
| | | private String factoryOrgCode; |
| | | private String repairDepartOrgCode; |
| | | private String column; |
| | | private String order; |
| | | } |
| | |
| | | if (StringUtils.isNotBlank(eamEquipment.getEquipmentCategory())) { |
| | | queryWrapper.like("e.equipment_category", eamEquipment.getEquipmentCategory()); |
| | | } |
| | | if (StringUtils.isNotBlank(eamEquipment.getFactoryOrgCode())) { |
| | | queryWrapper.like("e.factory_org_code", eamEquipment.getFactoryOrgCode()); |
| | | } |
| | | if (StringUtils.isNotBlank(eamEquipment.getRepairDepartOrgCode())) { |
| | | queryWrapper.like("e.repair_depart_org_code", eamEquipment.getRepairDepartOrgCode()); |
| | | } |
| | | if (StringUtils.isNotBlank(eamEquipment.getId())) { |
| | | queryWrapper.eq("e.id", eamEquipment.getId()); |
| | | } |
| | |
| | | //import org.jeecg.modules.mdc.entity.MdcEquipment; |
| | | //import org.jeecg.modules.mdc.service.IMdcEquipmentService; |
| | | import org.jeecg.modules.system.entity.BaseFactory; |
| | | import org.jeecg.modules.system.entity.EamBaseRepairDepart; |
| | | import org.jeecg.modules.system.service.IBaseFactoryService; |
| | | import org.jeecg.modules.system.service.IEamBaseRepairDepartService; |
| | | import org.jeecgframework.poi.excel.ExcelImportUtil; |
| | | import org.jeecgframework.poi.excel.def.NormalExcelConstants; |
| | | import org.jeecgframework.poi.excel.entity.ExportParams; |
| | |
| | | private TranslateDictTextUtils translateDictTextUtils; |
| | | @Autowired |
| | | private IBaseFactoryService baseFactoryService; |
| | | |
| | | @Autowired |
| | | private IEamBaseRepairDepartService eamBaseRepairDepartService; |
| | | /** |
| | | * å页å表æ¥è¯¢ |
| | | * |
| | |
| | | }else { |
| | | eamEquipment.setFactoryOrgCode(baseFactory.getOrgCode()); |
| | | } |
| | | EamBaseRepairDepart eamBaseRepairDepart=eamBaseRepairDepartService.searchCenterByKeyWord(eamEquipment.getRepairDepartOrgCode()); |
| | | if(eamBaseRepairDepart==null){ |
| | | sb.append(String.format("ç»´ä¿®çç»ä¿¡æ¯[%s]ä¸åå¨ï¼æ æ³å¯¼å
¥\n\r", eamEquipment.getRepairDepartOrgCode())); |
| | | continue; |
| | | }else { |
| | | eamEquipment.setRepairDepartOrgCode(eamBaseRepairDepart.getOrgCode()); |
| | | } |
| | | EamEquipment equipment = eamEquipmentService.saveEquipment(eamEquipment); |
| | | if (equipment == null) { |
| | | //ä¿å失败ï¼è·³è¿æ¬æ¬¡å¾ªç¯ |
| | | sb.append(String.format("设å¤ç¼ç [%s]ä¿åå¤±è´¥ï¼æ æ³å¯¼å
¥\n\r", eamEquipment.getEquipmentCode())); |
| | | continue; |
| | | } |
| | | EamEquipmentExtend eamEquipmentExtend=new EamEquipmentExtend(); |
| | | BeanUtils.copyProperties(eamEquipmentExtend,equipment); |
| | | eamEquipmentExtendService.save(eamEquipmentExtend); |
| | | } |
| | | log.info("æ¶èæ¶é´" + (System.currentTimeMillis() - start) + "毫ç§"); |
| | | //update-end-author:taoyan date:20190528 for:æ¹éæå
¥æ°æ® |
| | |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import java.util.*; |
| | | import java.util.concurrent.atomic.AtomicInteger; |
| | | |
| | | /** |
| | | * @Description: ä¿å
»æ å |
| | |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<?> deleteBatch(@RequestParam(name = "ids", required = true) String ids) { |
| | | List<String> list = Arrays.asList(ids.split(",")); |
| | | AtomicInteger i = new AtomicInteger(); |
| | | list.forEach(id -> { |
| | | EamMaintenanceStandard entity = eamMaintenanceStandardService.getById(id); |
| | | if (entity != null&&entity.getStandardStatus().equals(MaintenanceStandardStatusEnum.WAIT_SUBMIT.name())) { |
| | | //åªå é¤ç¶æä¸ºå¾
æäº¤ç |
| | | i.getAndIncrement(); |
| | | entity.setDelFlag(CommonConstant.DEL_FLAG_1); |
| | | eamMaintenanceStandardService.updateById(entity); |
| | | } |
| | | }); |
| | | return Result.OK("æ¹éå 餿åï¼"); |
| | | return Result.OK("æ¹éå 餿å,å·²å é¤ç¶æä¸ºå¾
æäº¤çä¿å
»æ åï¼å 餿°é为"+i); |
| | | } |
| | | |
| | | /** |
| | |
| | | |
| | | for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) { |
| | | MultipartFile file = entity.getValue(); |
| | | file.getOriginalFilename(); |
| | | return eamMaintenanceStandardService.importPointInspectionExcel(file); |
| | | String fileName = file.getOriginalFilename(); |
| | | Result<?> importResult=eamMaintenanceStandardService.importPointInspectionExcel(file); |
| | | if (importResult.isSuccess()) { |
| | | successCount++; |
| | | } else { |
| | | results.put(fileName, importResult.getMessage()); |
| | | failureCount++; |
| | | } |
| | | } |
| | | |
| | | // æå»ºååº |
| | | Map<String, Object> response = new HashMap<>(); |
| | | response.put("results", results); |
| | | response.put("totalFiles", fileMap.size()); |
| | | response.put("successCount", successCount); |
| | | response.put("failureCount", failureCount); |
| | | |
| | | return Result.ok("导å
¥å®æ" + response); |
| | | // æå»ºæç»ååº |
| | | return getResult(results, fileMap.size(), successCount, failureCount); |
| | | |
| | | } catch (Exception e) { |
| | | log.error("ç¹æ£å¯¼å
¥å¤çå¼å¸¸", e); |
| | |
| | | |
| | | for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) { |
| | | MultipartFile file = entity.getValue(); |
| | | file.getOriginalFilename(); |
| | | return eamMaintenanceStandardService.importMaintenanceStandard(file, "SECOND"); |
| | | String fileName = file.getOriginalFilename(); |
| | | Result<?> importResult=eamMaintenanceStandardService.importMaintenanceStandard(file, "SECOND"); |
| | | if (importResult.isSuccess()) { |
| | | successCount++; |
| | | } else { |
| | | results.put(fileName, importResult.getMessage()); |
| | | failureCount++; |
| | | } |
| | | } |
| | | |
| | | // æå»ºæç»ååº |
| | | Map<String, Object> response = new HashMap<>(); |
| | | response.put("results", results); |
| | | response.put("totalFiles", fileMap.size()); |
| | | response.put("successCount", successCount); |
| | | response.put("failureCount", failureCount); |
| | | |
| | | return Result.ok("导å
¥å®æ"+response); |
| | | return getResult(results, fileMap.size(), successCount, failureCount); |
| | | |
| | | } catch (Exception e) { |
| | | log.error("导å
¥å¤çå¼å¸¸", e); |
| | |
| | | |
| | | for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) { |
| | | MultipartFile file = entity.getValue(); |
| | | file.getOriginalFilename(); |
| | | return eamMaintenanceStandardService.importMaintenanceStandard(file, "THIRD"); |
| | | String fileName = file.getOriginalFilename(); |
| | | Result<?> importResult= eamMaintenanceStandardService.importMaintenanceStandard(file, "THIRD"); |
| | | if (importResult.isSuccess()) { |
| | | successCount++; |
| | | } else { |
| | | results.put(fileName, importResult.getMessage()); |
| | | failureCount++; |
| | | } |
| | | } |
| | | |
| | | // æå»ºæç»ååº |
| | | Map<String, Object> response = new HashMap<>(); |
| | | response.put("results", results); |
| | | response.put("totalFiles", fileMap.size()); |
| | | response.put("successCount", successCount); |
| | | response.put("failureCount", failureCount); |
| | | |
| | | return Result.ok("导å
¥å®æ"+response); |
| | | return getResult(results, fileMap.size(), successCount, failureCount); |
| | | |
| | | } catch (Exception e) { |
| | | log.error("导å
¥å¤çå¼å¸¸", e); |
| | |
| | | } |
| | | } |
| | | |
| | | private Result<?> getResult(Map<String, String> results, int fileCount, int successCount, int failureCount) { |
| | | List<String> response = new ArrayList<>(); |
| | | response.add("æ»æä»¶æ°ï¼" + fileCount); |
| | | response.add("æåæ°ï¼" + successCount); |
| | | response.add("失败æ°ï¼" + failureCount); |
| | | if (failureCount > 0) { |
| | | response.add("é误信æ¯ï¼" + results.values()); |
| | | return Result.error("é¨åæä»¶å¯¼å
¥å¤±è´¥ï¼" + response); |
| | | } |
| | | return Result.ok("æææä»¶å¯¼å
¥æåï¼" + response); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.common.api.vo.Result; |
| | | import org.jeecg.common.aspect.annotation.AutoLog; |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.common.system.query.QueryGenerator; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusChange; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusChangeService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Slf4j |
| | | @Api(tags="ææ¯ç¶æåæ´ç³è¯·") |
| | | @RestController |
| | | @RequestMapping("/eam/eamTechnicalStatusChange") |
| | | public class EamTechnicalStatusChangeController extends JeecgController<EamTechnicalStatusChange, IEamTechnicalStatusChangeService> { |
| | | @Autowired |
| | | private IEamTechnicalStatusChangeService eamTechnicalStatusChangeService; |
| | | |
| | | /** |
| | | * å页å表æ¥è¯¢ |
| | | * |
| | | * @param eamTechnicalStatusChange |
| | | * @param pageNo |
| | | * @param pageSize |
| | | * @param req |
| | | * @return |
| | | */ |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-å页å表æ¥è¯¢", notes="ææ¯ç¶æåæ´ç³è¯·-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<?> queryPageList(EamTechnicalStatusChange eamTechnicalStatusChange, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | | @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, |
| | | HttpServletRequest req) { |
| | | QueryWrapper<EamTechnicalStatusChange> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusChange, req.getParameterMap()); |
| | | Page<EamTechnicalStatusChange> page = new Page<EamTechnicalStatusChange>(pageNo, pageSize); |
| | | IPage<EamTechnicalStatusChange> pageList = eamTechnicalStatusChangeService.page(page, queryWrapper); |
| | | return Result.OK(pageList); |
| | | } |
| | | |
| | | /** |
| | | * æ·»å |
| | | * |
| | | * @param eamTechnicalStatusChange |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-æ·»å ") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-æ·»å ", notes="ææ¯ç¶æåæ´ç³è¯·-æ·»å ") |
| | | @PostMapping(value = "/add") |
| | | public Result<?> add(@RequestBody EamTechnicalStatusChange eamTechnicalStatusChange) { |
| | | eamTechnicalStatusChangeService.save(eamTechnicalStatusChange); |
| | | return Result.OK("æ·»å æåï¼"); |
| | | } |
| | | |
| | | /** |
| | | * ç¼è¾ |
| | | * |
| | | * @param eamTechnicalStatusChange |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-ç¼è¾") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-ç¼è¾", notes="ææ¯ç¶æåæ´ç³è¯·-ç¼è¾") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<?> edit(@RequestBody EamTechnicalStatusChange eamTechnicalStatusChange) { |
| | | eamTechnicalStatusChangeService.updateById(eamTechnicalStatusChange); |
| | | return Result.OK("ç¼è¾æå!"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idå é¤ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-éè¿idå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-éè¿idå é¤", notes="ææ¯ç¶æåæ´ç³è¯·-éè¿idå é¤") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<?> delete(@RequestParam(name="id",required=true) String id) { |
| | | eamTechnicalStatusChangeService.removeById(id); |
| | | return Result.OK("å 餿å!"); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤ |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-æ¹éå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-æ¹éå é¤", notes="ææ¯ç¶æåæ´ç³è¯·-æ¹éå é¤") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | | this.eamTechnicalStatusChangeService.removeByIds(Arrays.asList(ids.split(","))); |
| | | return Result.OK("æ¹éå 餿åï¼"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idæ¥è¯¢ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-éè¿idæ¥è¯¢", notes="ææ¯ç¶æåæ´ç³è¯·-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<?> queryById(@RequestParam(name="id",required=true) String id) { |
| | | EamTechnicalStatusChange eamTechnicalStatusChange = eamTechnicalStatusChangeService.getById(id); |
| | | return Result.OK(eamTechnicalStatusChange); |
| | | } |
| | | |
| | | /** |
| | | * 导åºexcel |
| | | * |
| | | * @param request |
| | | * @param eamTechnicalStatusChange |
| | | */ |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusChange eamTechnicalStatusChange) { |
| | | return super.exportXls(request, eamTechnicalStatusChange, EamTechnicalStatusChange.class, "ææ¯ç¶æåæ´ç³è¯·"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿excel导å
¥æ°æ® |
| | | * |
| | | * @param request |
| | | * @param response |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | return super.importExcel(request, response, EamTechnicalStatusChange.class); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.common.api.vo.Result; |
| | | import org.jeecg.common.aspect.annotation.AutoLog; |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.common.system.query.QueryGenerator; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusChangeDetail; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusChangeDetailService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯·æç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Slf4j |
| | | @Api(tags="ææ¯ç¶æåæ´ç³è¯·æç»") |
| | | @RestController |
| | | @RequestMapping("/eam/eamTechnicalStatusChangeDetail") |
| | | public class EamTechnicalStatusChangeDetailController extends JeecgController<EamTechnicalStatusChangeDetail, IEamTechnicalStatusChangeDetailService> { |
| | | @Autowired |
| | | private IEamTechnicalStatusChangeDetailService eamTechnicalStatusChangeDetailService; |
| | | |
| | | /** |
| | | * å页å表æ¥è¯¢ |
| | | * |
| | | * @param eamTechnicalStatusChangeDetail |
| | | * @param pageNo |
| | | * @param pageSize |
| | | * @param req |
| | | * @return |
| | | */ |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-å页å表æ¥è¯¢", notes="ææ¯ç¶æåæ´ç³è¯·æç»-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<?> queryPageList(EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | | @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, |
| | | HttpServletRequest req) { |
| | | QueryWrapper<EamTechnicalStatusChangeDetail> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusChangeDetail, req.getParameterMap()); |
| | | Page<EamTechnicalStatusChangeDetail> page = new Page<EamTechnicalStatusChangeDetail>(pageNo, pageSize); |
| | | IPage<EamTechnicalStatusChangeDetail> pageList = eamTechnicalStatusChangeDetailService.page(page, queryWrapper); |
| | | return Result.OK(pageList); |
| | | } |
| | | |
| | | /** |
| | | * æ·»å |
| | | * |
| | | * @param eamTechnicalStatusChangeDetail |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-æ·»å ") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-æ·»å ", notes="ææ¯ç¶æåæ´ç³è¯·æç»-æ·»å ") |
| | | @PostMapping(value = "/add") |
| | | public Result<?> add(@RequestBody EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail) { |
| | | eamTechnicalStatusChangeDetailService.save(eamTechnicalStatusChangeDetail); |
| | | return Result.OK("æ·»å æåï¼"); |
| | | } |
| | | |
| | | /** |
| | | * ç¼è¾ |
| | | * |
| | | * @param eamTechnicalStatusChangeDetail |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-ç¼è¾") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-ç¼è¾", notes="ææ¯ç¶æåæ´ç³è¯·æç»-ç¼è¾") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<?> edit(@RequestBody EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail) { |
| | | eamTechnicalStatusChangeDetailService.updateById(eamTechnicalStatusChangeDetail); |
| | | return Result.OK("ç¼è¾æå!"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idå é¤ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idå é¤", notes="ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idå é¤") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<?> delete(@RequestParam(name="id",required=true) String id) { |
| | | eamTechnicalStatusChangeDetailService.removeById(id); |
| | | return Result.OK("å 餿å!"); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤ |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-æ¹éå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-æ¹éå é¤", notes="ææ¯ç¶æåæ´ç³è¯·æç»-æ¹éå é¤") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | | this.eamTechnicalStatusChangeDetailService.removeByIds(Arrays.asList(ids.split(","))); |
| | | return Result.OK("æ¹éå 餿åï¼"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idæ¥è¯¢ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idæ¥è¯¢", notes="ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<?> queryById(@RequestParam(name="id",required=true) String id) { |
| | | EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail = eamTechnicalStatusChangeDetailService.getById(id); |
| | | return Result.OK(eamTechnicalStatusChangeDetail); |
| | | } |
| | | |
| | | /** |
| | | * 导åºexcel |
| | | * |
| | | * @param request |
| | | * @param eamTechnicalStatusChangeDetail |
| | | */ |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail) { |
| | | return super.exportXls(request, eamTechnicalStatusChangeDetail, EamTechnicalStatusChangeDetail.class, "ææ¯ç¶æåæ´ç³è¯·æç»"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿excel导å
¥æ°æ® |
| | | * |
| | | * @param request |
| | | * @param response |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | return super.importExcel(request, response, EamTechnicalStatusChangeDetail.class); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.common.api.vo.Result; |
| | | import org.jeecg.common.aspect.annotation.AutoLog; |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.common.system.query.QueryGenerator; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusDeactivate; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusDeactivateService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Slf4j |
| | | @Api(tags="åç¨å 工设å¤ç³è¯·å") |
| | | @RestController |
| | | @RequestMapping("/eam/eamTechnicalStatusDeactivate") |
| | | public class EamTechnicalStatusDeactivateController extends JeecgController<EamTechnicalStatusDeactivate, IEamTechnicalStatusDeactivateService> { |
| | | @Autowired |
| | | private IEamTechnicalStatusDeactivateService eamTechnicalStatusDeactivateService; |
| | | |
| | | /** |
| | | * å页å表æ¥è¯¢ |
| | | * |
| | | * @param eamTechnicalStatusDeactivate |
| | | * @param pageNo |
| | | * @param pageSize |
| | | * @param req |
| | | * @return |
| | | */ |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·å-å页å表æ¥è¯¢", notes="åç¨å 工设å¤ç³è¯·å-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<?> queryPageList(EamTechnicalStatusDeactivate eamTechnicalStatusDeactivate, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | | @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, |
| | | HttpServletRequest req) { |
| | | QueryWrapper<EamTechnicalStatusDeactivate> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusDeactivate, req.getParameterMap()); |
| | | Page<EamTechnicalStatusDeactivate> page = new Page<EamTechnicalStatusDeactivate>(pageNo, pageSize); |
| | | IPage<EamTechnicalStatusDeactivate> pageList = eamTechnicalStatusDeactivateService.page(page, queryWrapper); |
| | | return Result.OK(pageList); |
| | | } |
| | | |
| | | /** |
| | | * æ·»å |
| | | * |
| | | * @param eamTechnicalStatusDeactivate |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·å-æ·»å ") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·å-æ·»å ", notes="åç¨å 工设å¤ç³è¯·å-æ·»å ") |
| | | @PostMapping(value = "/add") |
| | | public Result<?> add(@RequestBody EamTechnicalStatusDeactivate eamTechnicalStatusDeactivate) { |
| | | eamTechnicalStatusDeactivateService.save(eamTechnicalStatusDeactivate); |
| | | return Result.OK("æ·»å æåï¼"); |
| | | } |
| | | |
| | | /** |
| | | * ç¼è¾ |
| | | * |
| | | * @param eamTechnicalStatusDeactivate |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·å-ç¼è¾") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·å-ç¼è¾", notes="åç¨å 工设å¤ç³è¯·å-ç¼è¾") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<?> edit(@RequestBody EamTechnicalStatusDeactivate eamTechnicalStatusDeactivate) { |
| | | eamTechnicalStatusDeactivateService.updateById(eamTechnicalStatusDeactivate); |
| | | return Result.OK("ç¼è¾æå!"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idå é¤ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·å-éè¿idå é¤") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·å-éè¿idå é¤", notes="åç¨å 工设å¤ç³è¯·å-éè¿idå é¤") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<?> delete(@RequestParam(name="id",required=true) String id) { |
| | | eamTechnicalStatusDeactivateService.removeById(id); |
| | | return Result.OK("å 餿å!"); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤ |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·å-æ¹éå é¤") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·å-æ¹éå é¤", notes="åç¨å 工设å¤ç³è¯·å-æ¹éå é¤") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | | this.eamTechnicalStatusDeactivateService.removeByIds(Arrays.asList(ids.split(","))); |
| | | return Result.OK("æ¹éå 餿åï¼"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idæ¥è¯¢ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·å-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·å-éè¿idæ¥è¯¢", notes="åç¨å 工设å¤ç³è¯·å-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<?> queryById(@RequestParam(name="id",required=true) String id) { |
| | | EamTechnicalStatusDeactivate eamTechnicalStatusDeactivate = eamTechnicalStatusDeactivateService.getById(id); |
| | | return Result.OK(eamTechnicalStatusDeactivate); |
| | | } |
| | | |
| | | /** |
| | | * 导åºexcel |
| | | * |
| | | * @param request |
| | | * @param eamTechnicalStatusDeactivate |
| | | */ |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusDeactivate eamTechnicalStatusDeactivate) { |
| | | return super.exportXls(request, eamTechnicalStatusDeactivate, EamTechnicalStatusDeactivate.class, "åç¨å 工设å¤ç³è¯·å"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿excel导å
¥æ°æ® |
| | | * |
| | | * @param request |
| | | * @param response |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | return super.importExcel(request, response, EamTechnicalStatusDeactivate.class); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.common.api.vo.Result; |
| | | import org.jeecg.common.aspect.annotation.AutoLog; |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.common.system.query.QueryGenerator; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusDeactivateDetail; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusDeactivateDetailService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Slf4j |
| | | @Api(tags="åç¨å 工设å¤ç³è¯·åæç»") |
| | | @RestController |
| | | @RequestMapping("/eam/eamTechnicalStatusDeactivateDetail") |
| | | public class EamTechnicalStatusDeactivateDetailController extends JeecgController<EamTechnicalStatusDeactivateDetail, IEamTechnicalStatusDeactivateDetailService> { |
| | | @Autowired |
| | | private IEamTechnicalStatusDeactivateDetailService eamTechnicalStatusDeactivateDetailService; |
| | | |
| | | /** |
| | | * å页å表æ¥è¯¢ |
| | | * |
| | | * @param eamTechnicalStatusDeactivateDetail |
| | | * @param pageNo |
| | | * @param pageSize |
| | | * @param req |
| | | * @return |
| | | */ |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·åæç»-å页å表æ¥è¯¢", notes="åç¨å 工设å¤ç³è¯·åæç»-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<?> queryPageList(EamTechnicalStatusDeactivateDetail eamTechnicalStatusDeactivateDetail, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | | @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, |
| | | HttpServletRequest req) { |
| | | QueryWrapper<EamTechnicalStatusDeactivateDetail> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusDeactivateDetail, req.getParameterMap()); |
| | | Page<EamTechnicalStatusDeactivateDetail> page = new Page<EamTechnicalStatusDeactivateDetail>(pageNo, pageSize); |
| | | IPage<EamTechnicalStatusDeactivateDetail> pageList = eamTechnicalStatusDeactivateDetailService.page(page, queryWrapper); |
| | | return Result.OK(pageList); |
| | | } |
| | | |
| | | /** |
| | | * æ·»å |
| | | * |
| | | * @param eamTechnicalStatusDeactivateDetail |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·åæç»-æ·»å ") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·åæç»-æ·»å ", notes="åç¨å 工设å¤ç³è¯·åæç»-æ·»å ") |
| | | @PostMapping(value = "/add") |
| | | public Result<?> add(@RequestBody EamTechnicalStatusDeactivateDetail eamTechnicalStatusDeactivateDetail) { |
| | | eamTechnicalStatusDeactivateDetailService.save(eamTechnicalStatusDeactivateDetail); |
| | | return Result.OK("æ·»å æåï¼"); |
| | | } |
| | | |
| | | /** |
| | | * ç¼è¾ |
| | | * |
| | | * @param eamTechnicalStatusDeactivateDetail |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·åæç»-ç¼è¾") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·åæç»-ç¼è¾", notes="åç¨å 工设å¤ç³è¯·åæç»-ç¼è¾") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<?> edit(@RequestBody EamTechnicalStatusDeactivateDetail eamTechnicalStatusDeactivateDetail) { |
| | | eamTechnicalStatusDeactivateDetailService.updateById(eamTechnicalStatusDeactivateDetail); |
| | | return Result.OK("ç¼è¾æå!"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idå é¤ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·åæç»-éè¿idå é¤") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·åæç»-éè¿idå é¤", notes="åç¨å 工设å¤ç³è¯·åæç»-éè¿idå é¤") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<?> delete(@RequestParam(name="id",required=true) String id) { |
| | | eamTechnicalStatusDeactivateDetailService.removeById(id); |
| | | return Result.OK("å 餿å!"); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤ |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·åæç»-æ¹éå é¤") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·åæç»-æ¹éå é¤", notes="åç¨å 工设å¤ç³è¯·åæç»-æ¹éå é¤") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | | this.eamTechnicalStatusDeactivateDetailService.removeByIds(Arrays.asList(ids.split(","))); |
| | | return Result.OK("æ¹éå 餿åï¼"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idæ¥è¯¢ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "åç¨å 工设å¤ç³è¯·åæç»-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="åç¨å 工设å¤ç³è¯·åæç»-éè¿idæ¥è¯¢", notes="åç¨å 工设å¤ç³è¯·åæç»-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<?> queryById(@RequestParam(name="id",required=true) String id) { |
| | | EamTechnicalStatusDeactivateDetail eamTechnicalStatusDeactivateDetail = eamTechnicalStatusDeactivateDetailService.getById(id); |
| | | return Result.OK(eamTechnicalStatusDeactivateDetail); |
| | | } |
| | | |
| | | /** |
| | | * 导åºexcel |
| | | * |
| | | * @param request |
| | | * @param eamTechnicalStatusDeactivateDetail |
| | | */ |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusDeactivateDetail eamTechnicalStatusDeactivateDetail) { |
| | | return super.exportXls(request, eamTechnicalStatusDeactivateDetail, EamTechnicalStatusDeactivateDetail.class, "åç¨å 工设å¤ç³è¯·åæç»"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿excel导å
¥æ°æ® |
| | | * |
| | | * @param request |
| | | * @param response |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | return super.importExcel(request, response, EamTechnicalStatusDeactivateDetail.class); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.common.api.vo.Result; |
| | | import org.jeecg.common.aspect.annotation.AutoLog; |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.common.system.query.QueryGenerator; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationApplication; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusEvaluationApplicationService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | |
| | | /** |
| | | * @Description: å å·¥è®¾å¤ææ¯é´å®ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Slf4j |
| | | @Api(tags="å å·¥è®¾å¤ææ¯é´å®ç³è¯·") |
| | | @RestController |
| | | @RequestMapping("/eam/eamTechnicalStatusEvaluationApplication") |
| | | public class EamTechnicalStatusEvaluationApplicationController extends JeecgController<EamTechnicalStatusEvaluationApplication, IEamTechnicalStatusEvaluationApplicationService> { |
| | | @Autowired |
| | | private IEamTechnicalStatusEvaluationApplicationService eamTechnicalStatusEvaluationApplicationService; |
| | | |
| | | /** |
| | | * å页å表æ¥è¯¢ |
| | | * |
| | | * @param eamTechnicalStatusEvaluationApplication |
| | | * @param pageNo |
| | | * @param pageSize |
| | | * @param req |
| | | * @return |
| | | */ |
| | | @ApiOperation(value="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-å页å表æ¥è¯¢", notes="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<?> queryPageList(EamTechnicalStatusEvaluationApplication eamTechnicalStatusEvaluationApplication, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | | @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, |
| | | HttpServletRequest req) { |
| | | QueryWrapper<EamTechnicalStatusEvaluationApplication> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusEvaluationApplication, req.getParameterMap()); |
| | | Page<EamTechnicalStatusEvaluationApplication> page = new Page<EamTechnicalStatusEvaluationApplication>(pageNo, pageSize); |
| | | IPage<EamTechnicalStatusEvaluationApplication> pageList = eamTechnicalStatusEvaluationApplicationService.page(page, queryWrapper); |
| | | return Result.OK(pageList); |
| | | } |
| | | |
| | | /** |
| | | * æ·»å |
| | | * |
| | | * @param eamTechnicalStatusEvaluationApplication |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "å å·¥è®¾å¤ææ¯é´å®ç³è¯·-æ·»å ") |
| | | @ApiOperation(value="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-æ·»å ", notes="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-æ·»å ") |
| | | @PostMapping(value = "/add") |
| | | public Result<?> add(@RequestBody EamTechnicalStatusEvaluationApplication eamTechnicalStatusEvaluationApplication) { |
| | | eamTechnicalStatusEvaluationApplicationService.save(eamTechnicalStatusEvaluationApplication); |
| | | return Result.OK("æ·»å æåï¼"); |
| | | } |
| | | |
| | | /** |
| | | * ç¼è¾ |
| | | * |
| | | * @param eamTechnicalStatusEvaluationApplication |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "å å·¥è®¾å¤ææ¯é´å®ç³è¯·-ç¼è¾") |
| | | @ApiOperation(value="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-ç¼è¾", notes="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-ç¼è¾") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<?> edit(@RequestBody EamTechnicalStatusEvaluationApplication eamTechnicalStatusEvaluationApplication) { |
| | | eamTechnicalStatusEvaluationApplicationService.updateById(eamTechnicalStatusEvaluationApplication); |
| | | return Result.OK("ç¼è¾æå!"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idå é¤ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "å å·¥è®¾å¤ææ¯é´å®ç³è¯·-éè¿idå é¤") |
| | | @ApiOperation(value="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-éè¿idå é¤", notes="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-éè¿idå é¤") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<?> delete(@RequestParam(name="id",required=true) String id) { |
| | | eamTechnicalStatusEvaluationApplicationService.removeById(id); |
| | | return Result.OK("å 餿å!"); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤ |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "å å·¥è®¾å¤ææ¯é´å®ç³è¯·-æ¹éå é¤") |
| | | @ApiOperation(value="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-æ¹éå é¤", notes="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-æ¹éå é¤") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | | this.eamTechnicalStatusEvaluationApplicationService.removeByIds(Arrays.asList(ids.split(","))); |
| | | return Result.OK("æ¹éå 餿åï¼"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idæ¥è¯¢ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "å å·¥è®¾å¤ææ¯é´å®ç³è¯·-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-éè¿idæ¥è¯¢", notes="å å·¥è®¾å¤ææ¯é´å®ç³è¯·-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<?> queryById(@RequestParam(name="id",required=true) String id) { |
| | | EamTechnicalStatusEvaluationApplication eamTechnicalStatusEvaluationApplication = eamTechnicalStatusEvaluationApplicationService.getById(id); |
| | | return Result.OK(eamTechnicalStatusEvaluationApplication); |
| | | } |
| | | |
| | | /** |
| | | * 导åºexcel |
| | | * |
| | | * @param request |
| | | * @param eamTechnicalStatusEvaluationApplication |
| | | */ |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusEvaluationApplication eamTechnicalStatusEvaluationApplication) { |
| | | return super.exportXls(request, eamTechnicalStatusEvaluationApplication, EamTechnicalStatusEvaluationApplication.class, "å å·¥è®¾å¤ææ¯é´å®ç³è¯·"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿excel导å
¥æ°æ® |
| | | * |
| | | * @param request |
| | | * @param response |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | return super.importExcel(request, response, EamTechnicalStatusEvaluationApplication.class); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.common.api.vo.Result; |
| | | import org.jeecg.common.aspect.annotation.AutoLog; |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.common.system.query.QueryGenerator; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrderChange; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusEvaluationOrderChangeService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥ååæ´ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Slf4j |
| | | @Api(tags="ææ¯ç¶æé´å®å·¥ååæ´") |
| | | @RestController |
| | | @RequestMapping("/eam/eamTechnicalStatusEvaluationOrderChange") |
| | | public class EamTechnicalStatusEvaluationOrderChangeController extends JeecgController<EamTechnicalStatusEvaluationOrderChange, IEamTechnicalStatusEvaluationOrderChangeService> { |
| | | @Autowired |
| | | private IEamTechnicalStatusEvaluationOrderChangeService eamTechnicalStatusEvaluationOrderChangeService; |
| | | |
| | | /** |
| | | * å页å表æ¥è¯¢ |
| | | * |
| | | * @param eamTechnicalStatusEvaluationOrderChange |
| | | * @param pageNo |
| | | * @param pageSize |
| | | * @param req |
| | | * @return |
| | | */ |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥ååæ´-å页å表æ¥è¯¢", notes="ææ¯ç¶æé´å®å·¥ååæ´-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<?> queryPageList(EamTechnicalStatusEvaluationOrderChange eamTechnicalStatusEvaluationOrderChange, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | | @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, |
| | | HttpServletRequest req) { |
| | | QueryWrapper<EamTechnicalStatusEvaluationOrderChange> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusEvaluationOrderChange, req.getParameterMap()); |
| | | Page<EamTechnicalStatusEvaluationOrderChange> page = new Page<EamTechnicalStatusEvaluationOrderChange>(pageNo, pageSize); |
| | | IPage<EamTechnicalStatusEvaluationOrderChange> pageList = eamTechnicalStatusEvaluationOrderChangeService.page(page, queryWrapper); |
| | | return Result.OK(pageList); |
| | | } |
| | | |
| | | /** |
| | | * æ·»å |
| | | * |
| | | * @param eamTechnicalStatusEvaluationOrderChange |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥ååæ´-æ·»å ") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥ååæ´-æ·»å ", notes="ææ¯ç¶æé´å®å·¥ååæ´-æ·»å ") |
| | | @PostMapping(value = "/add") |
| | | public Result<?> add(@RequestBody EamTechnicalStatusEvaluationOrderChange eamTechnicalStatusEvaluationOrderChange) { |
| | | eamTechnicalStatusEvaluationOrderChangeService.save(eamTechnicalStatusEvaluationOrderChange); |
| | | return Result.OK("æ·»å æåï¼"); |
| | | } |
| | | |
| | | /** |
| | | * ç¼è¾ |
| | | * |
| | | * @param eamTechnicalStatusEvaluationOrderChange |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥ååæ´-ç¼è¾") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥ååæ´-ç¼è¾", notes="ææ¯ç¶æé´å®å·¥ååæ´-ç¼è¾") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<?> edit(@RequestBody EamTechnicalStatusEvaluationOrderChange eamTechnicalStatusEvaluationOrderChange) { |
| | | eamTechnicalStatusEvaluationOrderChangeService.updateById(eamTechnicalStatusEvaluationOrderChange); |
| | | return Result.OK("ç¼è¾æå!"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idå é¤ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥ååæ´-éè¿idå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥ååæ´-éè¿idå é¤", notes="ææ¯ç¶æé´å®å·¥ååæ´-éè¿idå é¤") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<?> delete(@RequestParam(name="id",required=true) String id) { |
| | | eamTechnicalStatusEvaluationOrderChangeService.removeById(id); |
| | | return Result.OK("å 餿å!"); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤ |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥ååæ´-æ¹éå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥ååæ´-æ¹éå é¤", notes="ææ¯ç¶æé´å®å·¥ååæ´-æ¹éå é¤") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | | this.eamTechnicalStatusEvaluationOrderChangeService.removeByIds(Arrays.asList(ids.split(","))); |
| | | return Result.OK("æ¹éå 餿åï¼"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idæ¥è¯¢ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥ååæ´-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥ååæ´-éè¿idæ¥è¯¢", notes="ææ¯ç¶æé´å®å·¥ååæ´-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<?> queryById(@RequestParam(name="id",required=true) String id) { |
| | | EamTechnicalStatusEvaluationOrderChange eamTechnicalStatusEvaluationOrderChange = eamTechnicalStatusEvaluationOrderChangeService.getById(id); |
| | | return Result.OK(eamTechnicalStatusEvaluationOrderChange); |
| | | } |
| | | |
| | | /** |
| | | * 导åºexcel |
| | | * |
| | | * @param request |
| | | * @param eamTechnicalStatusEvaluationOrderChange |
| | | */ |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusEvaluationOrderChange eamTechnicalStatusEvaluationOrderChange) { |
| | | return super.exportXls(request, eamTechnicalStatusEvaluationOrderChange, EamTechnicalStatusEvaluationOrderChange.class, "ææ¯ç¶æé´å®å·¥ååæ´"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿excel导å
¥æ°æ® |
| | | * |
| | | * @param request |
| | | * @param response |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | return super.importExcel(request, response, EamTechnicalStatusEvaluationOrderChange.class); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.common.api.vo.Result; |
| | | import org.jeecg.common.aspect.annotation.AutoLog; |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.common.system.query.QueryGenerator; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrder; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusEvaluationOrderService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Slf4j |
| | | @Api(tags="ææ¯ç¶æé´å®å·¥å") |
| | | @RestController |
| | | @RequestMapping("/eam/eamTechnicalStatusEvaluationOrder") |
| | | public class EamTechnicalStatusEvaluationOrderController extends JeecgController<EamTechnicalStatusEvaluationOrder, IEamTechnicalStatusEvaluationOrderService> { |
| | | @Autowired |
| | | private IEamTechnicalStatusEvaluationOrderService eamTechnicalStatusEvaluationOrderService; |
| | | |
| | | /** |
| | | * å页å表æ¥è¯¢ |
| | | * |
| | | * @param eamTechnicalStatusEvaluationOrder |
| | | * @param pageNo |
| | | * @param pageSize |
| | | * @param req |
| | | * @return |
| | | */ |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥å-å页å表æ¥è¯¢", notes="ææ¯ç¶æé´å®å·¥å-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<?> queryPageList(EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | | @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, |
| | | HttpServletRequest req) { |
| | | QueryWrapper<EamTechnicalStatusEvaluationOrder> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusEvaluationOrder, req.getParameterMap()); |
| | | Page<EamTechnicalStatusEvaluationOrder> page = new Page<EamTechnicalStatusEvaluationOrder>(pageNo, pageSize); |
| | | IPage<EamTechnicalStatusEvaluationOrder> pageList = eamTechnicalStatusEvaluationOrderService.page(page, queryWrapper); |
| | | return Result.OK(pageList); |
| | | } |
| | | |
| | | /** |
| | | * æ·»å |
| | | * |
| | | * @param eamTechnicalStatusEvaluationOrder |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥å-æ·»å ") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥å-æ·»å ", notes="ææ¯ç¶æé´å®å·¥å-æ·»å ") |
| | | @PostMapping(value = "/add") |
| | | public Result<?> add(@RequestBody EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder) { |
| | | eamTechnicalStatusEvaluationOrderService.save(eamTechnicalStatusEvaluationOrder); |
| | | return Result.OK("æ·»å æåï¼"); |
| | | } |
| | | |
| | | /** |
| | | * ç¼è¾ |
| | | * |
| | | * @param eamTechnicalStatusEvaluationOrder |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥å-ç¼è¾") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥å-ç¼è¾", notes="ææ¯ç¶æé´å®å·¥å-ç¼è¾") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<?> edit(@RequestBody EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder) { |
| | | eamTechnicalStatusEvaluationOrderService.updateById(eamTechnicalStatusEvaluationOrder); |
| | | return Result.OK("ç¼è¾æå!"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idå é¤ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥å-éè¿idå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥å-éè¿idå é¤", notes="ææ¯ç¶æé´å®å·¥å-éè¿idå é¤") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<?> delete(@RequestParam(name="id",required=true) String id) { |
| | | eamTechnicalStatusEvaluationOrderService.removeById(id); |
| | | return Result.OK("å 餿å!"); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤ |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥å-æ¹éå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥å-æ¹éå é¤", notes="ææ¯ç¶æé´å®å·¥å-æ¹éå é¤") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | | this.eamTechnicalStatusEvaluationOrderService.removeByIds(Arrays.asList(ids.split(","))); |
| | | return Result.OK("æ¹éå 餿åï¼"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idæ¥è¯¢ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥å-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥å-éè¿idæ¥è¯¢", notes="ææ¯ç¶æé´å®å·¥å-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<?> queryById(@RequestParam(name="id",required=true) String id) { |
| | | EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder = eamTechnicalStatusEvaluationOrderService.getById(id); |
| | | return Result.OK(eamTechnicalStatusEvaluationOrder); |
| | | } |
| | | |
| | | /** |
| | | * 导åºexcel |
| | | * |
| | | * @param request |
| | | * @param eamTechnicalStatusEvaluationOrder |
| | | */ |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder) { |
| | | return super.exportXls(request, eamTechnicalStatusEvaluationOrder, EamTechnicalStatusEvaluationOrder.class, "ææ¯ç¶æé´å®å·¥å"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿excel导å
¥æ°æ® |
| | | * |
| | | * @param request |
| | | * @param response |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | return super.importExcel(request, response, EamTechnicalStatusEvaluationOrder.class); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.common.api.vo.Result; |
| | | import org.jeecg.common.aspect.annotation.AutoLog; |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.common.system.query.QueryGenerator; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrderDetail; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusEvaluationOrderDetailService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.Arrays; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Slf4j |
| | | @Api(tags="ææ¯ç¶æé´å®å·¥åæç»") |
| | | @RestController |
| | | @RequestMapping("/eam/eamTechnicalStatusEvaluationOrderDetail") |
| | | public class EamTechnicalStatusEvaluationOrderDetailController extends JeecgController<EamTechnicalStatusEvaluationOrderDetail, IEamTechnicalStatusEvaluationOrderDetailService> { |
| | | @Autowired |
| | | private IEamTechnicalStatusEvaluationOrderDetailService eamTechnicalStatusEvaluationOrderDetailService; |
| | | |
| | | /** |
| | | * å页å表æ¥è¯¢ |
| | | * |
| | | * @param eamTechnicalStatusEvaluationOrderDetail |
| | | * @param pageNo |
| | | * @param pageSize |
| | | * @param req |
| | | * @return |
| | | */ |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥åæç»-å页å表æ¥è¯¢", notes="ææ¯ç¶æé´å®å·¥åæç»-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<?> queryPageList(EamTechnicalStatusEvaluationOrderDetail eamTechnicalStatusEvaluationOrderDetail, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | | @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, |
| | | HttpServletRequest req) { |
| | | QueryWrapper<EamTechnicalStatusEvaluationOrderDetail> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusEvaluationOrderDetail, req.getParameterMap()); |
| | | Page<EamTechnicalStatusEvaluationOrderDetail> page = new Page<EamTechnicalStatusEvaluationOrderDetail>(pageNo, pageSize); |
| | | IPage<EamTechnicalStatusEvaluationOrderDetail> pageList = eamTechnicalStatusEvaluationOrderDetailService.page(page, queryWrapper); |
| | | return Result.OK(pageList); |
| | | } |
| | | |
| | | /** |
| | | * æ·»å |
| | | * |
| | | * @param eamTechnicalStatusEvaluationOrderDetail |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥åæç»-æ·»å ") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥åæç»-æ·»å ", notes="ææ¯ç¶æé´å®å·¥åæç»-æ·»å ") |
| | | @PostMapping(value = "/add") |
| | | public Result<?> add(@RequestBody EamTechnicalStatusEvaluationOrderDetail eamTechnicalStatusEvaluationOrderDetail) { |
| | | eamTechnicalStatusEvaluationOrderDetailService.save(eamTechnicalStatusEvaluationOrderDetail); |
| | | return Result.OK("æ·»å æåï¼"); |
| | | } |
| | | |
| | | /** |
| | | * ç¼è¾ |
| | | * |
| | | * @param eamTechnicalStatusEvaluationOrderDetail |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥åæç»-ç¼è¾") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥åæç»-ç¼è¾", notes="ææ¯ç¶æé´å®å·¥åæç»-ç¼è¾") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<?> edit(@RequestBody EamTechnicalStatusEvaluationOrderDetail eamTechnicalStatusEvaluationOrderDetail) { |
| | | eamTechnicalStatusEvaluationOrderDetailService.updateById(eamTechnicalStatusEvaluationOrderDetail); |
| | | return Result.OK("ç¼è¾æå!"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idå é¤ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥åæç»-éè¿idå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥åæç»-éè¿idå é¤", notes="ææ¯ç¶æé´å®å·¥åæç»-éè¿idå é¤") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<?> delete(@RequestParam(name="id",required=true) String id) { |
| | | eamTechnicalStatusEvaluationOrderDetailService.removeById(id); |
| | | return Result.OK("å 餿å!"); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤ |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥åæç»-æ¹éå é¤") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥åæç»-æ¹éå é¤", notes="ææ¯ç¶æé´å®å·¥åæç»-æ¹éå é¤") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | | this.eamTechnicalStatusEvaluationOrderDetailService.removeByIds(Arrays.asList(ids.split(","))); |
| | | return Result.OK("æ¹éå 餿åï¼"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿idæ¥è¯¢ |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "ææ¯ç¶æé´å®å·¥åæç»-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="ææ¯ç¶æé´å®å·¥åæç»-éè¿idæ¥è¯¢", notes="ææ¯ç¶æé´å®å·¥åæç»-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<?> queryById(@RequestParam(name="id",required=true) String id) { |
| | | EamTechnicalStatusEvaluationOrderDetail eamTechnicalStatusEvaluationOrderDetail = eamTechnicalStatusEvaluationOrderDetailService.getById(id); |
| | | return Result.OK(eamTechnicalStatusEvaluationOrderDetail); |
| | | } |
| | | |
| | | /** |
| | | * 导åºexcel |
| | | * |
| | | * @param request |
| | | * @param eamTechnicalStatusEvaluationOrderDetail |
| | | */ |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusEvaluationOrderDetail eamTechnicalStatusEvaluationOrderDetail) { |
| | | return super.exportXls(request, eamTechnicalStatusEvaluationOrderDetail, EamTechnicalStatusEvaluationOrderDetail.class, "ææ¯ç¶æé´å®å·¥åæç»"); |
| | | } |
| | | |
| | | /** |
| | | * éè¿excel导å
¥æ°æ® |
| | | * |
| | | * @param request |
| | | * @param response |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | return super.importExcel(request, response, EamTechnicalStatusEvaluationOrderDetail.class); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.experimental.Accessors; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Data |
| | | @TableName("eam_technical_status_change") |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @Accessors(chain = true) |
| | | @ApiModel(value="eam_technical_status_change对象", description="ææ¯ç¶æåæ´ç³è¯·") |
| | | public class EamTechnicalStatusChange { |
| | | |
| | | /**主é®*/ |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "主é®") |
| | | private String id; |
| | | /**å建人*/ |
| | | @ApiModelProperty(value = "å建人") |
| | | private String createBy; |
| | | /**å建æ¶é´*/ |
| | | @ApiModelProperty(value = "å建æ¶é´") |
| | | private Date createTime; |
| | | /**æ´æ°äºº*/ |
| | | @ApiModelProperty(value = "æ´æ°äºº") |
| | | private String updateBy; |
| | | /**æ´æ°æ¶é´*/ |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | private Date updateTime; |
| | | /**å 餿 è®°*/ |
| | | @ApiModelProperty(value = "å 餿 è®°") |
| | | private Integer delFlag; |
| | | /**åæ´åå·*/ |
| | | @ApiModelProperty(value = "åæ´åå·") |
| | | private String changeOrderNum; |
| | | /**åæ´åç¶æ*/ |
| | | @ApiModelProperty(value = "åæ´åç¶æ") |
| | | private String changeStatus; |
| | | /**ç¼å¶äºº*/ |
| | | @ApiModelProperty(value = "ç¼å¶äºº") |
| | | private String designer; |
| | | /**ç¼å¶æ¶é´*/ |
| | | @ApiModelProperty(value = "ç¼å¶æ¶é´") |
| | | private Date designerTime; |
| | | /**使ç¨åä½å®¤ä¸»ç®¡ç¾å*/ |
| | | @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡ç¾å") |
| | | private String departHeaderSignature; |
| | | /**使ç¨åä½å®¤ä¸»ç®¡ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡ç¾åæ¶é´") |
| | | private Date departHeaderSignatureTime; |
| | | /**使ç¨åä½å®¤ä¸»ç®¡æè§*/ |
| | | @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡æè§") |
| | | private String departHeaderSignatureComment; |
| | | /**使ç¨åä½é¨ä¸»ç®¡ç¾å*/ |
| | | @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾å") |
| | | private String departLeaderSignature; |
| | | /**使ç¨åä½é¨ä¸»ç®¡ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾åæ¶é´") |
| | | private Date departLeaderSignatureTime; |
| | | /**使ç¨åä½é¨ä¸»ç®¡ç¾å*/ |
| | | @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾å") |
| | | private String departLeaderSignatureComment; |
| | | /**HFç¼ç */ |
| | | @ApiModelProperty(value = "HFç¼ç ") |
| | | private String hfCode; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.experimental.Accessors; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯·æç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Data |
| | | @TableName("eam_technical_status_change_detail") |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @Accessors(chain = true) |
| | | @ApiModel(value="eam_technical_status_change_detail对象", description="ææ¯ç¶æåæ´ç³è¯·æç»") |
| | | public class EamTechnicalStatusChangeDetail { |
| | | |
| | | /**主é®*/ |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "主é®") |
| | | private String id; |
| | | /**å建人*/ |
| | | @ApiModelProperty(value = "å建人") |
| | | private String createBy; |
| | | /**å建æ¶é´*/ |
| | | @ApiModelProperty(value = "å建æ¶é´") |
| | | private Date createTime; |
| | | /**æ´æ°äºº*/ |
| | | @ApiModelProperty(value = "æ´æ°äºº") |
| | | private String updateBy; |
| | | /**æ´æ°æ¶é´*/ |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | private Date updateTime; |
| | | /**设å¤ID*/ |
| | | @ApiModelProperty(value = "设å¤ID") |
| | | private String equipmentId; |
| | | /**åæ´åå ;æ¬è¿ãå¤§ä¿®ãæ¹é ãå
¶ä»*/ |
| | | @ApiModelProperty(value = "åæ´åå ;æ¬è¿ãå¤§ä¿®ãæ¹é ãå
¶ä»") |
| | | private String changeCategory; |
| | | /**åæ´æ¥æ*/ |
| | | @ApiModelProperty(value = "åæ´æ¥æ") |
| | | private Date changeDate; |
| | | /**åæ´åææ¯ç¶æ;åæ´éè¿åé»è®¤è®¾å¤ææ¯ç¶ææ¹ä¸ºç¦ç¨*/ |
| | | @ApiModelProperty(value = "åæ´åææ¯ç¶æ;åæ´éè¿åé»è®¤è®¾å¤ææ¯ç¶ææ¹ä¸ºç¦ç¨") |
| | | private String changeTechnicalStatus; |
| | | /**éªæ¶æ£æ¥äºº*/ |
| | | @ApiModelProperty(value = "éªæ¶æ£æ¥äºº") |
| | | private String acceptanceChecker; |
| | | /**éªæ¶æ£æ¥æ¶é´*/ |
| | | @ApiModelProperty(value = "éªæ¶æ£æ¥æ¶é´") |
| | | private Date acceptanceCheckTime; |
| | | /**éªæ¶æ£æ¥ç»æ;å¤§ä¿®ãæ¹é éè¦å¡«åéªæ¶ç»æï¼æ¬è¿æç
§ææ¯ç¶æé´å®å·¥åç»´æ¤ï¼å
¶ä»ææªä½¿ç¨å°ï¼åªé¢çæ¤ç±»å*/ |
| | | @ApiModelProperty(value = "éªæ¶æ£æ¥ç»æ;å¤§ä¿®ãæ¹é éè¦å¡«åéªæ¶ç»æï¼æ¬è¿æç
§ææ¯ç¶æé´å®å·¥åç»´æ¤ï¼å
¶ä»ææªä½¿ç¨å°ï¼åªé¢çæ¤ç±»å") |
| | | private String acceptanceCheckResult; |
| | | /**ææ¯ç¶æé´å®å·¥åID;æ¬è¿ä½¿ç¨*/ |
| | | @ApiModelProperty(value = "ææ¯ç¶æé´å®å·¥åID;æ¬è¿ä½¿ç¨") |
| | | private String orderId; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.experimental.Accessors; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Data |
| | | @TableName("eam_technical_status_deactivate") |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @Accessors(chain = true) |
| | | @ApiModel(value="eam_technical_status_deactivate对象", description="åç¨å 工设å¤ç³è¯·å") |
| | | public class EamTechnicalStatusDeactivate { |
| | | |
| | | /**主é®*/ |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "主é®") |
| | | private String id; |
| | | /**å建人*/ |
| | | @ApiModelProperty(value = "å建人") |
| | | private String createBy; |
| | | /**å建æ¶é´*/ |
| | | @ApiModelProperty(value = "å建æ¶é´") |
| | | private Date createTime; |
| | | /**æ´æ°äºº*/ |
| | | @ApiModelProperty(value = "æ´æ°äºº") |
| | | private String updateBy; |
| | | /**æ´æ°æ¶é´*/ |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | private Date updateTime; |
| | | /**å 餿 è®°*/ |
| | | @ApiModelProperty(value = "å 餿 è®°") |
| | | private Integer delFlag; |
| | | /**åç¨åå·*/ |
| | | @ApiModelProperty(value = "åç¨åå·") |
| | | private String deactivateOrderNum; |
| | | /**ç³è¯·äºº*/ |
| | | @ApiModelProperty(value = "ç³è¯·äºº") |
| | | private String applicant; |
| | | /**ç³è¯·é¨é¨*/ |
| | | @ApiModelProperty(value = "ç³è¯·é¨é¨") |
| | | private String factoryOrgCode; |
| | | /**ç³è¯·æ¥æ*/ |
| | | @ApiModelProperty(value = "ç³è¯·æ¥æ") |
| | | private Date applyDate; |
| | | /**ç³è¯·åç¶æ;å¾
æäº¤ãå¾
åä½å®¤çº§é¢å¯¼å®¡æ ¸ãç产设å¤ç®¡çä¸»ç®¡å®¡æ ¸ãå¾
ä¿éé¨é¢å¯¼å®¡æ ¸ãå·²ä½åºã已宿*/ |
| | | @ApiModelProperty(value = "ç³è¯·åç¶æ;å¾
æäº¤ãå¾
åä½å®¤çº§é¢å¯¼å®¡æ ¸ãç产设å¤ç®¡çä¸»ç®¡å®¡æ ¸ãå¾
ä¿éé¨é¢å¯¼å®¡æ ¸ãå·²ä½åºã已宿") |
| | | private String applicationStatus; |
| | | /**使ç¨åä½å®¤ä¸»ç®¡ç¾å*/ |
| | | @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡ç¾å") |
| | | private String departHeaderSignature; |
| | | /**使ç¨åä½å®¤ä¸»ç®¡ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡ç¾åæ¶é´") |
| | | private Date departHeaderSignatureTime; |
| | | /**使ç¨åä½å®¤ä¸»ç®¡æè§*/ |
| | | @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡æè§") |
| | | private String departHeaderSignatureComment; |
| | | /**使ç¨åä½é¨ä¸»ç®¡ç¾å*/ |
| | | @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾å") |
| | | private String departLeaderSignature; |
| | | /**使ç¨åä½é¨ä¸»ç®¡ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾åæ¶é´") |
| | | private Date departLeaderSignatureTime; |
| | | /**使ç¨åä½é¨ä¸»ç®¡ç¾å*/ |
| | | @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾å") |
| | | private String departLeaderSignatureComment; |
| | | /**HFç¼ç */ |
| | | @ApiModelProperty(value = "HFç¼ç ") |
| | | private String hfCode; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.experimental.Accessors; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Data |
| | | @TableName("eam_technical_status_deactivate_detail") |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @Accessors(chain = true) |
| | | @ApiModel(value="eam_technical_status_deactivate_detail对象", description="åç¨å 工设å¤ç³è¯·åæç»") |
| | | public class EamTechnicalStatusDeactivateDetail { |
| | | |
| | | /**主é®*/ |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "主é®") |
| | | private String id; |
| | | /**å建人*/ |
| | | @ApiModelProperty(value = "å建人") |
| | | private String createBy; |
| | | /**å建æ¶é´*/ |
| | | @ApiModelProperty(value = "å建æ¶é´") |
| | | private Date createTime; |
| | | /**æ´æ°äºº*/ |
| | | @ApiModelProperty(value = "æ´æ°äºº") |
| | | private String updateBy; |
| | | /**æ´æ°æ¶é´*/ |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | private Date updateTime; |
| | | /**设å¤ID*/ |
| | | @ApiModelProperty(value = "设å¤ID") |
| | | private String equipmentId; |
| | | /**åç¨åå */ |
| | | @ApiModelProperty(value = "åç¨åå ") |
| | | private String deactivateReason; |
| | | /**åç¨æ¶é¿*/ |
| | | @ApiModelProperty(value = "åç¨æ¶é¿") |
| | | private java.math.BigDecimal deactivateDuration; |
| | | /**åç¨æ¶é¿åä½;天ãæãå¹´*/ |
| | | @ApiModelProperty(value = "åç¨æ¶é¿åä½;天ãæãå¹´") |
| | | private String deactivateDurationUnit; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.experimental.Accessors; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description: å å·¥è®¾å¤ææ¯é´å®ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Data |
| | | @TableName("eam_technical_status_evaluation_application") |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @Accessors(chain = true) |
| | | @ApiModel(value="eam_technical_status_evaluation_application对象", description="å å·¥è®¾å¤ææ¯é´å®ç³è¯·") |
| | | public class EamTechnicalStatusEvaluationApplication { |
| | | |
| | | /**主é®*/ |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "主é®") |
| | | private String id; |
| | | /**å建人*/ |
| | | @ApiModelProperty(value = "å建人") |
| | | private String createBy; |
| | | /**å建æ¶é´*/ |
| | | @ApiModelProperty(value = "å建æ¶é´") |
| | | private Date createTime; |
| | | /**æ´æ°äºº*/ |
| | | @ApiModelProperty(value = "æ´æ°äºº") |
| | | private String updateBy; |
| | | /**æ´æ°æ¶é´*/ |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | private Date updateTime; |
| | | /**å 餿 è®°*/ |
| | | @ApiModelProperty(value = "å 餿 è®°") |
| | | private Integer delFlag; |
| | | /**ç³è¯·åå·*/ |
| | | @ApiModelProperty(value = "ç³è¯·åå·") |
| | | private String applicationOrderNum; |
| | | /**ç³è¯·äºº*/ |
| | | @ApiModelProperty(value = "ç³è¯·äºº") |
| | | private String applicant; |
| | | /**ç³è¯·é¨é¨*/ |
| | | @ApiModelProperty(value = "ç³è¯·é¨é¨") |
| | | private String factoryOrgCode; |
| | | /**ç³è¯·æ¥æ*/ |
| | | @ApiModelProperty(value = "ç³è¯·æ¥æ") |
| | | private Date applyDate; |
| | | /**ç³è¯·åç¶æ;å¾
æäº¤ãå¾
åä½å®¤çº§é¢å¯¼å®¡æ ¸ãç产设å¤ç®¡çä¸»ç®¡å®¡æ ¸ãå¾
ä¿éé¨é¢å¯¼å®¡æ ¸ãå·²ä½åºã已宿*/ |
| | | @ApiModelProperty(value = "ç³è¯·åç¶æ;å¾
æäº¤ãå¾
åä½å®¤çº§é¢å¯¼å®¡æ ¸ãç产设å¤ç®¡çä¸»ç®¡å®¡æ ¸ãå¾
ä¿éé¨é¢å¯¼å®¡æ ¸ãå·²ä½åºã已宿") |
| | | private String applicationStatus; |
| | | /**ç³è¯·åä½å®¤çº§é¢å¯¼ç¾å*/ |
| | | @ApiModelProperty(value = "ç³è¯·åä½å®¤çº§é¢å¯¼ç¾å") |
| | | private String departHeaderSignature; |
| | | /**ç³è¯·åä½å®¤çº§é¢å¯¼ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "ç³è¯·åä½å®¤çº§é¢å¯¼ç¾åæ¶é´") |
| | | private Date departHeaderSignatureTime; |
| | | /**ç³è¯·åä½å®¤çº§é¢å¯¼æè§*/ |
| | | @ApiModelProperty(value = "ç³è¯·åä½å®¤çº§é¢å¯¼æè§") |
| | | private String departHeaderComment; |
| | | /**ç产设å¤ç®¡ç主管ç¾å*/ |
| | | @ApiModelProperty(value = "ç产设å¤ç®¡ç主管ç¾å") |
| | | private String productionHeaderSignature; |
| | | /**ç产设å¤ç®¡ç主管ç¾ååä»¶*/ |
| | | @ApiModelProperty(value = "ç产设å¤ç®¡ç主管ç¾ååä»¶") |
| | | private Date productionHeaderSignatureTime; |
| | | /**ç产设å¤ç®¡ç主管æè§*/ |
| | | @ApiModelProperty(value = "ç产设å¤ç®¡ç主管æè§") |
| | | private String productionHeaderComment; |
| | | /**ç产ä¿éé¨é¢å¯¼ç¾å*/ |
| | | @ApiModelProperty(value = "ç产ä¿éé¨é¢å¯¼ç¾å") |
| | | private String productionSupportSignature; |
| | | /**ç产ä¿éé¨é¢å¯¼ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "ç产ä¿éé¨é¢å¯¼ç¾åæ¶é´") |
| | | private Date productionSupportSignatureTime; |
| | | /**ç产ä¿éé¨é¢å¯¼æè§*/ |
| | | @ApiModelProperty(value = "ç产ä¿éé¨é¢å¯¼æè§") |
| | | private String productionSupportComment; |
| | | /**HFç¼ç */ |
| | | @ApiModelProperty(value = "HFç¼ç ") |
| | | private String hfCode; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.experimental.Accessors; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Data |
| | | @TableName("eam_technical_status_evaluation_order") |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @Accessors(chain = true) |
| | | @ApiModel(value="eam_technical_status_evaluation_order对象", description="ææ¯ç¶æé´å®å·¥å") |
| | | public class EamTechnicalStatusEvaluationOrder { |
| | | |
| | | /**主é®*/ |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "主é®") |
| | | private String id; |
| | | /**å建人*/ |
| | | @ApiModelProperty(value = "å建人") |
| | | private String createBy; |
| | | /**å建æ¶é´*/ |
| | | @ApiModelProperty(value = "å建æ¶é´") |
| | | private Date createTime; |
| | | /**æ´æ°äºº*/ |
| | | @ApiModelProperty(value = "æ´æ°äºº") |
| | | private String updateBy; |
| | | /**æ´æ°æ¶é´*/ |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | private Date updateTime; |
| | | /**å 餿 è®°*/ |
| | | @ApiModelProperty(value = "å 餿 è®°") |
| | | private Integer delFlag; |
| | | /**å·¥åå·*/ |
| | | @ApiModelProperty(value = "å·¥åå·") |
| | | private String orderNum; |
| | | /**设å¤ID*/ |
| | | @ApiModelProperty(value = "设å¤ID") |
| | | private String equipmentId; |
| | | /**è§èID*/ |
| | | @ApiModelProperty(value = "è§èID") |
| | | private String standardId; |
| | | /**计åé´å®æ¥æ;æå70天çæå·¥å*/ |
| | | @ApiModelProperty(value = "计åé´å®æ¥æ;æå70天çæå·¥å") |
| | | private Date evaluationDate; |
| | | /**éå®å·¥åæ¥æ;æå55天éå®å·¥å*/ |
| | | @ApiModelProperty(value = "éå®å·¥åæ¥æ;æå55天éå®å·¥å") |
| | | private Date freezeOrderDate; |
| | | /**å·¥åè¿ææ¥æ;å°ææªåç´æ¥è¿æï¼å¹¶ä¿®æ¹è®¾å¤ææ¯ç¶æä¸ºç¦ç¨*/ |
| | | @ApiModelProperty(value = "å·¥åè¿ææ¥æ;å°ææªåç´æ¥è¿æï¼å¹¶ä¿®æ¹è®¾å¤ææ¯ç¶æä¸ºç¦ç¨") |
| | | private Date orderExpirationDate; |
| | | /**å®é
å¼å§æ¶é´*/ |
| | | @ApiModelProperty(value = "å®é
å¼å§æ¶é´") |
| | | private Date actualStartTime; |
| | | /**å®é
ç»ææ¶é´*/ |
| | | @ApiModelProperty(value = "å®é
ç»ææ¶é´") |
| | | private Date actualEndTime; |
| | | /**é´å®äºº*/ |
| | | @ApiModelProperty(value = "é´å®äºº") |
| | | private String evaluator; |
| | | /**é´å®ç¶æ;å¾
é´å®ãé´å®ä¸ã维修室主任ç¾åãå·¥èºäººåç¾åãææ¯ä¸»ç®¡ç¾åãè®¾å¤æ£éªåç¾åã已宿ãå·²éå®ãåæ´ä¸ãå·²è¿æ*/ |
| | | @ApiModelProperty(value = "é´å®ç¶æ;å¾
é´å®ãé´å®ä¸ã维修室主任ç¾åãå·¥èºäººåç¾åãææ¯ä¸»ç®¡ç¾åãè®¾å¤æ£éªåç¾åã已宿ãå·²éå®ãåæ´ä¸ãå·²è¿æ") |
| | | private String evaluationStatus; |
| | | /**å建æ¹å¼*/ |
| | | @ApiModelProperty(value = "å建æ¹å¼") |
| | | private String creationMethod; |
| | | /**å®å
¨è£
ç½®æ£æ¥ç»æ;æ¯ãå¦*/ |
| | | @ApiModelProperty(value = "å®å
¨è£
ç½®æ£æ¥ç»æ;æ¯ãå¦") |
| | | private String safetyEquipmentCheckResult; |
| | | /**ç²¾åº¦åæ°æ£æ¥ç»æ;æ¯ãå¦ãæ */ |
| | | @ApiModelProperty(value = "ç²¾åº¦åæ°æ£æ¥ç»æ;æ¯ãå¦ãæ ") |
| | | private String precisionCheckResult; |
| | | /**åè½ç¶ææ£æ¥ç»æ;æ¯ãå¦*/ |
| | | @ApiModelProperty(value = "åè½ç¶ææ£æ¥ç»æ;æ¯ãå¦") |
| | | private String functionalCheckResult; |
| | | /**å
¶ä»æ£æ¥ç»æ;æ¯ãå¦ãæ */ |
| | | @ApiModelProperty(value = "å
¶ä»æ£æ¥ç»æ;æ¯ãå¦ãæ ") |
| | | private String otherCheckResult; |
| | | /**维修室主任ç¾å*/ |
| | | @ApiModelProperty(value = "维修室主任ç¾å") |
| | | private String repairManagerSignature; |
| | | /**维修室主任ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "维修室主任ç¾åæ¶é´") |
| | | private Date repairManagerSignatureTime1; |
| | | /**è¯ä»¶æ£æ¥ç»æ;åæ ¼ãä¸åæ ¼*/ |
| | | @ApiModelProperty(value = "è¯ä»¶æ£æ¥ç»æ;åæ ¼ãä¸åæ ¼") |
| | | private String sampleCheckResult; |
| | | /**å·¥èºåç¾å*/ |
| | | @ApiModelProperty(value = "å·¥èºåç¾å") |
| | | private String processTechnicianSignature; |
| | | /**å·¥èºåç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "å·¥èºåç¾åæ¶é´") |
| | | private Date processTechnicianSignatureTime; |
| | | /**é´å®ç»æ;åæ ¼ãéç¨ãç¦ç¨*/ |
| | | @ApiModelProperty(value = "é´å®ç»æ;åæ ¼ãéç¨ãç¦ç¨") |
| | | private String evaluationResult; |
| | | /**é\ç¦ç¨åå (å¤é);å®å
¨è£
ç½®ã设å¤åè½ã精度ãè¯ä»¶ãå
¶ä»*/ |
| | | @ApiModelProperty(value = "é/ç¦ç¨åå (å¤é);å®å
¨è£
ç½®ã设å¤åè½ã精度ãè¯ä»¶ãå
¶ä»") |
| | | private String evaluationReason; |
| | | /**è®¾å¤æ£æ¥äººç¾å*/ |
| | | @ApiModelProperty(value = "è®¾å¤æ£æ¥äººç¾å") |
| | | private String inspectorSignature; |
| | | /**è®¾å¤æ£æ¥äººç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "è®¾å¤æ£æ¥äººç¾åæ¶é´") |
| | | private Date inspectorSignatureTime; |
| | | /**éå½A HFç¼ç */ |
| | | @ApiModelProperty(value = "éå½A HFç¼ç ") |
| | | private String hfCodeA; |
| | | /**éå½B HFç¼ç */ |
| | | @ApiModelProperty(value = "éå½B HFç¼ç ") |
| | | private String hfCodeB; |
| | | /**éå½C HFç¼ç */ |
| | | @ApiModelProperty(value = "éå½C HFç¼ç ") |
| | | private String hfCodeC; |
| | | /**éå½D HFç¼ç */ |
| | | @ApiModelProperty(value = "éå½D HFç¼ç ") |
| | | private String hfCodeD; |
| | | /**夿³¨*/ |
| | | @ApiModelProperty(value = "夿³¨") |
| | | private String remark; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.experimental.Accessors; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥ååæ´ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Data |
| | | @TableName("eam_technical_status_evaluation_order_change") |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @Accessors(chain = true) |
| | | @ApiModel(value="eam_technical_status_evaluation_order_change对象", description="ææ¯ç¶æé´å®å·¥ååæ´") |
| | | public class EamTechnicalStatusEvaluationOrderChange { |
| | | |
| | | /**主é®*/ |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "主é®") |
| | | private String id; |
| | | /**å建人*/ |
| | | @ApiModelProperty(value = "å建人") |
| | | private String createBy; |
| | | /**å建æ¶é´*/ |
| | | @ApiModelProperty(value = "å建æ¶é´") |
| | | private Date createTime; |
| | | /**æ´æ°äºº*/ |
| | | @ApiModelProperty(value = "æ´æ°äºº") |
| | | private String updateBy; |
| | | /**æ´æ°æ¶é´*/ |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | private Date updateTime; |
| | | /**å 餿 è®°*/ |
| | | @ApiModelProperty(value = "å 餿 è®°") |
| | | private Integer delFlag; |
| | | /**å·¥åID*/ |
| | | @ApiModelProperty(value = "å·¥åID") |
| | | private String orderId; |
| | | /**åæ´åå·*/ |
| | | @ApiModelProperty(value = "åæ´åå·") |
| | | private String changeOrderNum; |
| | | /**ç³è¯·äºº*/ |
| | | @ApiModelProperty(value = "ç³è¯·äºº") |
| | | private String applicant; |
| | | /**ç³è¯·é¨é¨*/ |
| | | @ApiModelProperty(value = "ç³è¯·é¨é¨") |
| | | private String factoryOrgCode; |
| | | /**ç³è¯·æ¥æ*/ |
| | | @ApiModelProperty(value = "ç³è¯·æ¥æ") |
| | | private Date applyDate; |
| | | /**åæ´ç¶æ;å¾
æäº¤ãå¾
ä¸»ç®¡å®¡æ ¸ãå¾
é¨é¨ç¡®è®¤ãå¾
ä¿éé¨ç¡®è®¤ãå·²ä½åºã已宿*/ |
| | | @ApiModelProperty(value = "åæ´ç¶æ;å¾
æäº¤ãå¾
ä¸»ç®¡å®¡æ ¸ãå¾
é¨é¨ç¡®è®¤ãå¾
ä¿éé¨ç¡®è®¤ãå·²ä½åºã已宿") |
| | | private String changeStatus; |
| | | /**åæ´åå ;çäº§ä»»å¡æ¥æ æ³åæºãè®¾å¤æ
鿣å¤äºç»´ä¿®ç¶æã设å¤å·²æ¥åºã设å¤å¤§ä¿®ãæ¬è¿ãæ¹é */ |
| | | @ApiModelProperty(value = "åæ´åå ;çäº§ä»»å¡æ¥æ æ³åæºãè®¾å¤æ
鿣å¤äºç»´ä¿®ç¶æã设å¤å·²æ¥åºã设å¤å¤§ä¿®ãæ¬è¿ãæ¹é ") |
| | | private String applyReason; |
| | | /**åæ´é´å®æ¥æ*/ |
| | | @ApiModelProperty(value = "åæ´é´å®æ¥æ") |
| | | private Date deferredMaintenanceDate; |
| | | /**主管é¢å¯¼ç¾å*/ |
| | | @ApiModelProperty(value = "主管é¢å¯¼ç¾å") |
| | | private String equipmentManagerSignature; |
| | | /**主管é¢å¯¼ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "主管é¢å¯¼ç¾åæ¶é´") |
| | | private Date equipmentManagerSignatureTime; |
| | | /**é¨é¨é¢å¯¼ç¾å;æ ¹æ®åæ´åå ç±»ååºåä¸åç人审æ¹*/ |
| | | @ApiModelProperty(value = "é¨é¨é¢å¯¼ç¾å;æ ¹æ®åæ´åå ç±»ååºåä¸åç人审æ¹") |
| | | private String departManagerSignature; |
| | | /**é¨é¨é¢å¯¼ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "é¨é¨é¢å¯¼ç¾åæ¶é´") |
| | | private Date departManagerSignatureTime; |
| | | /**é¨é¨é¢å¯¼æè§*/ |
| | | @ApiModelProperty(value = "é¨é¨é¢å¯¼æè§") |
| | | private String departManagerComment; |
| | | /**ç产ä¿éé¨é¢å¯¼ç¾å*/ |
| | | @ApiModelProperty(value = "ç产ä¿éé¨é¢å¯¼ç¾å") |
| | | private String productionSupportSignature; |
| | | /**ç产ä¿éé¨é¢å¯¼ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "ç产ä¿éé¨é¢å¯¼ç¾åæ¶é´") |
| | | private Date productionSupportSignatureTime; |
| | | /**ç产ä¿éé¨é¢å¯¼æè§*/ |
| | | @ApiModelProperty(value = "ç产ä¿éé¨é¢å¯¼æè§") |
| | | private String productionSupportComment; |
| | | /**HFç¼ç */ |
| | | @ApiModelProperty(value = "HFç¼ç ") |
| | | private String hfCode; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.experimental.Accessors; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Data |
| | | @TableName("eam_technical_status_evaluation_order_detail") |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @Accessors(chain = true) |
| | | @ApiModel(value="eam_technical_status_evaluation_order_detail对象", description="ææ¯ç¶æé´å®å·¥åæç»") |
| | | public class EamTechnicalStatusEvaluationOrderDetail { |
| | | |
| | | /**主é®*/ |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "主é®") |
| | | private String id; |
| | | /**å建人*/ |
| | | @ApiModelProperty(value = "å建人") |
| | | private String createBy; |
| | | /**å建æ¶é´*/ |
| | | @ApiModelProperty(value = "å建æ¶é´") |
| | | private Date createTime; |
| | | /**æ´æ°äºº*/ |
| | | @ApiModelProperty(value = "æ´æ°äºº") |
| | | private String updateBy; |
| | | /**æ´æ°æ¶é´*/ |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | private Date updateTime; |
| | | /**åºå·*/ |
| | | @ApiModelProperty(value = "åºå·") |
| | | private Integer itemCode; |
| | | /**æ£æ¥åç±»;ç²¾åº¦æ£æ¥ãå®å
¨è£
ç½®æ£æ¥ãå
¶ä»æ£æ¥*/ |
| | | @ApiModelProperty(value = "æ£æ¥åç±»;ç²¾åº¦æ£æ¥ãå®å
¨è£
ç½®æ£æ¥ãå
¶ä»æ£æ¥") |
| | | private String checkCategory; |
| | | /**æ£æ¥é¡¹ç®*/ |
| | | @ApiModelProperty(value = "æ£æ¥é¡¹ç®") |
| | | private String itemName; |
| | | /**å
å·®å¼;ç²¾åº¦æ£æ¥å±ç¤º*/ |
| | | @ApiModelProperty(value = "å
å·®å¼;ç²¾åº¦æ£æ¥å±ç¤º") |
| | | private String toleranceValue; |
| | | /**æ£æ¥å项ç®;ç²¾åº¦æ£æ¥å±ç¤ºï¼å¯ä»¥ä¸ºç©º*/ |
| | | @ApiModelProperty(value = "æ£æ¥å项ç®;ç²¾åº¦æ£æ¥å±ç¤ºï¼å¯ä»¥ä¸ºç©º") |
| | | private String subItemName; |
| | | /**å®å
¨è£
ç½®æ£æ¥ç»æ;æ¯ãå¦ãæ */ |
| | | @ApiModelProperty(value = "å®å
¨è£
ç½®æ£æ¥ç»æ;æ¯ãå¦ãæ ") |
| | | private String safetyEquipmentCheckResult; |
| | | /**å
¶ä»æ£æ¥ç»æ*/ |
| | | @ApiModelProperty(value = "å
¶ä»æ£æ¥ç»æ") |
| | | private String otherCheckResult; |
| | | /**精度æ£éªç»æ*/ |
| | | @ApiModelProperty(value = "精度æ£éªç»æ") |
| | | private java.math.BigDecimal precisionCheckResult; |
| | | /**维修人/ç²¾åº¦æ£æ¥è
ç¾å*/ |
| | | @ApiModelProperty(value = "维修人/ç²¾åº¦æ£æ¥è
ç¾å") |
| | | private String repairmanSignature; |
| | | /**维修人/ç²¾åº¦æ£æ¥è
ç¾åæ¶é´*/ |
| | | @ApiModelProperty(value = "维修人/ç²¾åº¦æ£æ¥è
ç¾åæ¶é´") |
| | | private Date repairmanSignatureTime; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusChangeDetail; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯·æç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface EamTechnicalStatusChangeDetailMapper extends BaseMapper<EamTechnicalStatusChangeDetail> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusChange; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface EamTechnicalStatusChangeMapper extends BaseMapper<EamTechnicalStatusChange> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusDeactivateDetail; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface EamTechnicalStatusDeactivateDetailMapper extends BaseMapper<EamTechnicalStatusDeactivateDetail> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusDeactivate; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface EamTechnicalStatusDeactivateMapper extends BaseMapper<EamTechnicalStatusDeactivate> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationApplication; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: å å·¥è®¾å¤ææ¯é´å®ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface EamTechnicalStatusEvaluationApplicationMapper extends BaseMapper<EamTechnicalStatusEvaluationApplication> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrderChange; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥ååæ´ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface EamTechnicalStatusEvaluationOrderChangeMapper extends BaseMapper<EamTechnicalStatusEvaluationOrderChange> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrderDetail; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface EamTechnicalStatusEvaluationOrderDetailMapper extends BaseMapper<EamTechnicalStatusEvaluationOrderDetail> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrder; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface EamTechnicalStatusEvaluationOrderMapper extends BaseMapper<EamTechnicalStatusEvaluationOrder> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamTechnicalStatusChangeDetailMapper"> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamTechnicalStatusChangeMapper"> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamTechnicalStatusDeactivateDetailMapper"> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamTechnicalStatusDeactivateMapper"> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamTechnicalStatusEvaluationApplicationMapper"> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamTechnicalStatusEvaluationOrderChangeMapper"> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamTechnicalStatusEvaluationOrderDetailMapper"> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamTechnicalStatusEvaluationOrderMapper"> |
| | | |
| | | </mapper> |
| | |
| | | /** |
| | | * ç¹æ£è¡¨å¯¼å
¥å
¥å£ |
| | | */ |
| | | public Result<?> importPointInspectionExcel(MultipartFile file); |
| | | Result<?> importPointInspectionExcel(MultipartFile file); |
| | | |
| | | |
| | | Result<?> importMaintenanceStandard(MultipartFile file, String type); |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusChangeDetail; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯·æç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface IEamTechnicalStatusChangeDetailService extends IService<EamTechnicalStatusChangeDetail> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusChange; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface IEamTechnicalStatusChangeService extends IService<EamTechnicalStatusChange> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusDeactivateDetail; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface IEamTechnicalStatusDeactivateDetailService extends IService<EamTechnicalStatusDeactivateDetail> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusDeactivate; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface IEamTechnicalStatusDeactivateService extends IService<EamTechnicalStatusDeactivate> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationApplication; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * @Description: å å·¥è®¾å¤ææ¯é´å®ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface IEamTechnicalStatusEvaluationApplicationService extends IService<EamTechnicalStatusEvaluationApplication> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrderChange; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥ååæ´ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface IEamTechnicalStatusEvaluationOrderChangeService extends IService<EamTechnicalStatusEvaluationOrderChange> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrderDetail; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface IEamTechnicalStatusEvaluationOrderDetailService extends IService<EamTechnicalStatusEvaluationOrderDetail> { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrder; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | public interface IEamTechnicalStatusEvaluationOrderService extends IService<EamTechnicalStatusEvaluationOrder> { |
| | | |
| | | } |
| | |
| | | // å建项ç®è¯¦æ
|
| | | EamMaintenanceStandardDetail detail = new EamMaintenanceStandardDetail(); |
| | | detail.setStandardId(standard.getId()); |
| | | detail.setItemCode(Integer.parseInt(getCellStringValue(row.getCell(0)))); |
| | | detail.setItemName(getCellStringValue(row.getCell(1))); |
| | | detail.setItemCategory(itemCategory); |
| | | |
| | |
| | | if (!items.isEmpty()) { |
| | | items.remove(0); |
| | | } |
| | | |
| | | // 2. 为缺失é¨ä½çæ°æ®å¡«å
å䏿¡çä¿å
»é¨ä½ |
| | | String lastPart = ""; |
| | | int i =1; |
| | | for (EamMaintenanceStandardDetail item : items) { |
| | | item.setItemCode(i); |
| | | if (item.getItemPart() != null && !item.getItemPart().isEmpty()) { |
| | | lastPart = item.getItemPart(); |
| | | } else if (!lastPart.isEmpty()) { |
| | | item.setItemPart(lastPart); |
| | | } |
| | | i++; |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service.impl; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusChangeDetail; |
| | | import org.jeecg.modules.eam.mapper.EamTechnicalStatusChangeDetailMapper; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusChangeDetailService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯·æç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Service |
| | | public class EamTechnicalStatusChangeDetailServiceImpl extends ServiceImpl<EamTechnicalStatusChangeDetailMapper, EamTechnicalStatusChangeDetail> implements IEamTechnicalStatusChangeDetailService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service.impl; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusChange; |
| | | import org.jeecg.modules.eam.mapper.EamTechnicalStatusChangeMapper; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusChangeService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æåæ´ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Service |
| | | public class EamTechnicalStatusChangeServiceImpl extends ServiceImpl<EamTechnicalStatusChangeMapper, EamTechnicalStatusChange> implements IEamTechnicalStatusChangeService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service.impl; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusDeactivateDetail; |
| | | import org.jeecg.modules.eam.mapper.EamTechnicalStatusDeactivateDetailMapper; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusDeactivateDetailService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Service |
| | | public class EamTechnicalStatusDeactivateDetailServiceImpl extends ServiceImpl<EamTechnicalStatusDeactivateDetailMapper, EamTechnicalStatusDeactivateDetail> implements IEamTechnicalStatusDeactivateDetailService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service.impl; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusDeactivate; |
| | | import org.jeecg.modules.eam.mapper.EamTechnicalStatusDeactivateMapper; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusDeactivateService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: åç¨å 工设å¤ç³è¯·å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Service |
| | | public class EamTechnicalStatusDeactivateServiceImpl extends ServiceImpl<EamTechnicalStatusDeactivateMapper, EamTechnicalStatusDeactivate> implements IEamTechnicalStatusDeactivateService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service.impl; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationApplication; |
| | | import org.jeecg.modules.eam.mapper.EamTechnicalStatusEvaluationApplicationMapper; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusEvaluationApplicationService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: å å·¥è®¾å¤ææ¯é´å®ç³è¯· |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Service |
| | | public class EamTechnicalStatusEvaluationApplicationServiceImpl extends ServiceImpl<EamTechnicalStatusEvaluationApplicationMapper, EamTechnicalStatusEvaluationApplication> implements IEamTechnicalStatusEvaluationApplicationService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service.impl; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrderChange; |
| | | import org.jeecg.modules.eam.mapper.EamTechnicalStatusEvaluationOrderChangeMapper; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusEvaluationOrderChangeService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥ååæ´ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Service |
| | | public class EamTechnicalStatusEvaluationOrderChangeServiceImpl extends ServiceImpl<EamTechnicalStatusEvaluationOrderChangeMapper, EamTechnicalStatusEvaluationOrderChange> implements IEamTechnicalStatusEvaluationOrderChangeService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service.impl; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrderDetail; |
| | | import org.jeecg.modules.eam.mapper.EamTechnicalStatusEvaluationOrderDetailMapper; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusEvaluationOrderDetailService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥åæç» |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Service |
| | | public class EamTechnicalStatusEvaluationOrderDetailServiceImpl extends ServiceImpl<EamTechnicalStatusEvaluationOrderDetailMapper, EamTechnicalStatusEvaluationOrderDetail> implements IEamTechnicalStatusEvaluationOrderDetailService { |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.eam.service.impl; |
| | | |
| | | import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrder; |
| | | import org.jeecg.modules.eam.mapper.EamTechnicalStatusEvaluationOrderMapper; |
| | | import org.jeecg.modules.eam.service.IEamTechnicalStatusEvaluationOrderService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: ææ¯ç¶æé´å®å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2025-07-09 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Service |
| | | public class EamTechnicalStatusEvaluationOrderServiceImpl extends ServiceImpl<EamTechnicalStatusEvaluationOrderMapper, EamTechnicalStatusEvaluationOrder> implements IEamTechnicalStatusEvaluationOrderService { |
| | | |
| | | } |
| | |
| | | * æ ¹æ®ç¨æ·idè·åäº§çº¿ä¸ææ é项 |
| | | */ |
| | | List<RepairDepartIdModel> loadMaintainDepartTreeOptions(String userId); |
| | | |
| | | |
| | | /** |
| | | * æ ¹æ®å
³é®åè·åä¸å¿æ°æ® |
| | | */ |
| | | EamBaseRepairDepart searchCenterByKeyWord(String keyWord); |
| | | // |
| | | // /** |
| | | // * é彿¥è¯¢ææåèç¹ |
| | |
| | | // * @return |
| | | // */ |
| | | // EamBaseRepairDepart findMaintainDepartList(String equipmentId); |
| | | |
| | | |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.IdWorker; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.jeecg.common.constant.CommonConstant; |
| | | import org.jeecg.common.constant.FillRuleConstant; |
| | |
| | | if (keyWord.contains("/")) { |
| | | return searchByHierarchy(keyWord); |
| | | } else { |
| | | return searchByCode(keyWord); |
| | | return searchByCodeOrName(keyWord); |
| | | } |
| | | } |
| | | |
| | |
| | | String[] levels = path.split("/"); |
| | | int depth = levels.length; |
| | | |
| | | // æ£æ¥å±çº§æ·±åº¦ |
| | | // æ¯æå¤ç§æ ¼å¼ï¼ä¸å¿/å·¥åºãä¸å¿/工段ãä¸å¿/å·¥åº/工段 |
| | | if (depth < 2 || depth > 3) { |
| | | return null; // æ æçå±çº§æ·±åº¦ |
| | | return null; |
| | | } |
| | | |
| | | // æ¥è¯¢ç¬¬ä¸çº§ä¸å¿ |
| | | BaseFactory center = findFactory(levels[0], 1, null); |
| | | if (center == null) return null; |
| | | // ä»åºå±å¼å§æ¥è¯¢ï¼æåä¸çº§å¯è½æ¯å·¥åºæå·¥æ®µ |
| | | String lastName = levels[depth - 1]; |
| | | BaseFactory lastLevel = searchForLastLevel(lastName); |
| | | if (lastLevel == null) return null; |
| | | |
| | | // æ¥è¯¢ç¬¬äºçº§å·¥åº |
| | | BaseFactory workArea = findFactory(levels[1], null, center.getId()); |
| | | if (workArea == null || depth == 2) return workArea; |
| | | |
| | | // æ¥è¯¢ç¬¬ä¸çº§å·¥æ®µ |
| | | return findFactory(levels[2], null, workArea.getId()); |
| | | return validatePath(levels, lastLevel); |
| | | } |
| | | |
| | | private BaseFactory searchByCode(String code) { |
| | | private BaseFactory validatePath(String[] levels, BaseFactory lastLevel) { |
| | | if (levels.length == 2) { |
| | | // ä¸å¿/å·¥åº æ ä¸å¿/工段 |
| | | BaseFactory center = findParentCenter(lastLevel); |
| | | if (center != null && |
| | | center.getFactoryName().equals(levels[0]) && |
| | | ("1").equals(center.getFactoryCategory())) { |
| | | return lastLevel; |
| | | } |
| | | } else { |
| | | // ä¸å¿/å·¥åº/工段 |
| | | if (!("3").equals(lastLevel.getFactoryCategory())) return null; |
| | | |
| | | BaseFactory workArea = getById(lastLevel.getParentId()); |
| | | if (workArea == null || |
| | | !("2").equals(workArea.getFactoryCategory())) return null; |
| | | |
| | | BaseFactory center = getById(workArea.getParentId()); |
| | | if (center == null || |
| | | !("1").equals(center.getFactoryCategory())) return null; |
| | | |
| | | if (workArea.getFactoryName().equals(levels[1]) && |
| | | center.getFactoryName().equals(levels[0])) { |
| | | return lastLevel; |
| | | } |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | private BaseFactory searchForLastLevel(String name) { |
| | | // å
å°è¯æ¥è¯¢å·¥æ®µï¼ç±»å«3ï¼ |
| | | BaseFactory workshop = findFactory(name, 3, null); |
| | | if (workshop != null) return workshop; |
| | | |
| | | // å¦ææ²¡ææ¾å°å·¥æ®µï¼å°è¯æ¥è¯¢å·¥åºï¼ç±»å«2ï¼ |
| | | return findFactory(name, 2, null); |
| | | } |
| | | |
| | | private BaseFactory findParentCenter(BaseFactory entity) { |
| | | if (("1").equals(entity.getFactoryCategory())) { |
| | | return entity; // æ¬èº«å°±æ¯ä¸å¿ |
| | | } |
| | | |
| | | BaseFactory parent = getById(entity.getParentId()); |
| | | if (parent == null) return null; |
| | | |
| | | if (("1").equals(parent.getFactoryCategory())) { |
| | | return parent; // ç´æ¥ç¶çº§æ¯ä¸å¿ |
| | | } |
| | | |
| | | // 妿ç¶çº§ä¸æ¯ä¸å¿ï¼å°è¯æ¾ç¶çº§çç¶çº§ |
| | | return getById(parent.getParentId()); |
| | | } |
| | | |
| | | private BaseFactory searchByCodeOrName(String keyword) { |
| | | // 使ç¨å页æ¹å¼å
¼å®¹SQL Server |
| | | LambdaQueryWrapper<BaseFactory> query = new LambdaQueryWrapper<>(); |
| | | query.like(BaseFactory::getFactoryCode, code); |
| | | return this.baseMapper.selectOne(query); // 使ç¨selectOneé¿å
å¤ä¸ªç»æ |
| | | query.and(q -> q.eq(BaseFactory::getFactoryName, keyword) |
| | | .or() |
| | | .like(BaseFactory::getFactoryCode, keyword)); |
| | | |
| | | // 使ç¨å页æ¥è¯¢è·åç¬¬ä¸æ¡è®°å½ |
| | | Page<BaseFactory> page = new Page<>(1, 1); |
| | | Page<BaseFactory> resultPage = baseMapper.selectPage(page, query); |
| | | |
| | | return resultPage.getRecords().isEmpty() ? null : resultPage.getRecords().get(0); |
| | | } |
| | | |
| | | private BaseFactory findFactory(String name, Integer category, String parentId) { |
| | |
| | | if (category != null) query.eq(BaseFactory::getFactoryCategory, category); |
| | | if (parentId != null) query.eq(BaseFactory::getParentId, parentId); |
| | | |
| | | return this.baseMapper.selectOne(query); |
| | | // 使ç¨å页æ¹å¼å
¼å®¹SQL Server |
| | | Page<BaseFactory> page = new Page<>(1, 1); |
| | | Page<BaseFactory> resultPage = baseMapper.selectPage(page, query); |
| | | |
| | | return resultPage.getRecords().isEmpty() ? null : resultPage.getRecords().get(0); |
| | | } |
| | | |
| | | private BaseFactory getById(String id) { |
| | | if (StringUtils.isBlank(id)) return null; |
| | | return baseMapper.selectById(id); |
| | | } |
| | | |
| | | /** |
| | |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * æ ¹æ®å
³é®åè·åä¸å¿æ°æ® |
| | | */ |
| | | @Override |
| | | public EamBaseRepairDepart searchCenterByKeyWord(String keyWord) { |
| | | if (StringUtils.isBlank(keyWord)) { |
| | | return null; |
| | | } |
| | | // å
æåç§°æ¥è¯¢ |
| | | LambdaQueryWrapper<EamBaseRepairDepart> query = new LambdaQueryWrapper<>(); |
| | | query.eq(EamBaseRepairDepart::getDelFlag, CommonConstant.DEL_FLAG_0.toString()); |
| | | query.eq(EamBaseRepairDepart::getDepartName, keyWord); |
| | | EamBaseRepairDepart result = this.baseMapper.selectOne(query); |
| | | if (result != null) { |
| | | return result; |
| | | } |
| | | |
| | | // åæç¼ç æ¥è¯¢ |
| | | query = new LambdaQueryWrapper<>(); |
| | | query.eq(EamBaseRepairDepart::getDelFlag, CommonConstant.DEL_FLAG_0.toString()); |
| | | query.eq(EamBaseRepairDepart::getDepartCode, keyWord); |
| | | return this.baseMapper.selectOne(query); |
| | | } |
| | | |
| | | } |