三保工单基础代码

Lius

2025-07-11 7bec214d03538b874e51ba90f09b388df243b713

三保工单基础代码

 db/LS/dict_ls.sql

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,28 @@
--点检工单状态
delete from [dbo].[sys_dict] where dict_code='inspection_status';
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='inspection_status');

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1907309268858290177', N'点检状态', N'inspection_status', N'设备管理-点检状态', 0, N'admin', '2025-04-02 13:49:00.0000000', N'admin', '2025-04-02 13:49:19.6510000', NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1907309380946870273', N'1907309268858290177', N'待点检', N'WAIT_INSPECTION', '', 1, 1, N'admin', '2025-04-02 13:49:27.0000000', N'admin', '2025-05-07 10:11:47.5670000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1907309408746717185', N'1907309268858290177', N'待确认', N'WAIT_CONFIRM', '', 3, 1, N'admin', '2025-04-02 13:49:33.0000000', N'admin', '2025-05-07 10:12:06.4320000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1907309436466872322', N'1907309268858290177', N'已完成', N'COMPLETE', '', 4, 1, N'admin', '2025-04-02 13:49:40.0000000', N'admin', '2025-05-07 10:12:19.2070000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1909417976002236418', N'1907309268858290177', N'点检中', N'UNDER_INSPECTION', '', 2, 1, N'admin', '2025-04-08 09:28:15.0000000', N'admin', '2025-05-07 10:11:56.7550000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1909419871794089986', N'1907309268858290177', N'已作废', N'ABOLISH', '', 5, 1, N'admin', '2025-04-08 09:35:47.0000000', N'admin', '2025-05-07 10:12:33.1970000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1919938438058639361', N'1907309268858290177', N'已过期', N'EXPIRED', '', 6, 1, N'admin', '2025-05-07 10:12:49.0210000', NULL, NULL);

--点检结果状态
delete from [dbo].[sys_dict] where dict_code='inspection_project_result';
delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='inspection_project_result');

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1745288324644782081', N'点检结果', N'inspection_project_result', '', 0, N'admin', '2024-01-11 11:35:37.1360000', NULL, NULL, NULL);

INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1745288369645469697', N'1745288324644782081', N'正常', N'NORMAL', '', 1, 1, N'admin', '2024-01-11 11:35:47.0000000', N'admin', '2025-07-08 15:31:49.8100000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1745288400943366146', N'1745288324644782081', N'异常', N'ANOMALY', '', 1, 1, N'admin', '2024-01-11 11:35:55.0000000', N'admin', '2025-07-08 15:29:58.8960000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1745288434866896897', N'1745288324644782081', N'故障停机', N'FAULT', '', 2, 1, N'admin', '2024-01-11 11:36:03.0000000', N'admin', '2025-07-08 15:30:07.6710000');
INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1745288466827493377', N'1745288324644782081', N'没开机', N'CLOSE', '', 3, 1, N'admin', '2024-01-11 11:36:11.0000000', N'admin', '2025-07-08 15:30:16.7710000');

--维修部门班组编码规则
delete from [dbo].[sys_fill_rule] where rule_code='org_repair_deport_rule';

INSERT INTO [dbo].[sys_fill_rule] ([id], [rule_name], [rule_code], [rule_class], [rule_params], [update_by], [update_time], [create_by], [create_time]) VALUES (N'1676142178556973058', N'维修部门班组编码生成', N'org_repair_deport_rule', N'org.jeecg.modules.system.rule.OrgCodeRepDepRule', N'{"parentId":""}', N'admin', '2025-07-03 11:27:21.0000000', NULL, NULL);

 db/LS/eam_inspection_order.sql

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,215 @@
/*
 Navicat Premium Dump SQL

 Source Server         : localhost-sqlserver
 Source Server Type    : SQL Server
 Source Server Version : 11003000 (11.00.3000)
 Source Host           : localhost:1433
 Source Catalog        : LXZN_TEST_430_NEW
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11003000 (11.00.3000)
 File Encoding         : 65001

 Date: 11/07/2025 10:50:26
*/


-- ----------------------------
-- Table structure for eam_inspection_order
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[eam_inspection_order]') AND type IN ('U'))
    DROP TABLE [dbo].[eam_inspection_order]
GO

CREATE TABLE [dbo].[eam_inspection_order] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [order_num] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [equipment_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [standard_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [inspection_date] datetime2(7)  NULL,
  [operate_time] datetime2(7)  NULL,
  [operator] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [expiration_time] datetime2(7)  NULL,
  [creation_method] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [inspection_status] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [confirm_user] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [confirm_deal_type] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [confirm_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [confirm_time] datetime2(7)  NULL,
  [remark] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [del_flag] int  NULL,
  [create_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [hf_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[eam_inspection_order] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工单号',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'order_num'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备ID',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'equipment_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标准ID',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'standard_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检日期',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'inspection_date'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'operate_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检人',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'operator'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检过期时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'expiration_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建方式',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'creation_method'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检状态',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'inspection_status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'维修工确认人',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'confirm_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'确认类型',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'confirm_deal_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'确认意见',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'confirm_comment'
GO

EXEC sp_addextendedproperty
'MS_Description', N'确认时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'confirm_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标记',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'del_flag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新人',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'HF编码',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'hf_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检工单',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order'
GO


-- ----------------------------
-- Primary Key structure for table eam_inspection_order
-- ----------------------------
ALTER TABLE [dbo].[eam_inspection_order] ADD CONSTRAINT [PK__eam_insp__3213E83F513910DD] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


 db/LS/eam_inspection_order_detail.sql

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,143 @@
/*
 Navicat Premium Dump SQL

 Source Server         : localhost-sqlserver
 Source Server Type    : SQL Server
 Source Server Version : 11003000 (11.00.3000)
 Source Host           : localhost:1433
 Source Catalog        : LXZN_TEST_430_NEW
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11003000 (11.00.3000)
 File Encoding         : 65001

 Date: 11/07/2025 10:50:33
*/


-- ----------------------------
-- Table structure for eam_inspection_order_detail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[eam_inspection_order_detail]') AND type IN ('U'))
    DROP TABLE [dbo].[eam_inspection_order_detail]
GO

CREATE TABLE [dbo].[eam_inspection_order_detail] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [order_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [item_code] int  NULL,
  [item_name] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [item_demand] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [inspection_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [report_flag] nvarchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [exception_description] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(7)  NULL
)
GO

ALTER TABLE [dbo].[eam_inspection_order_detail] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工单ID',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'order_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目序号',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'item_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'保养项目',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'item_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'保养要求',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'item_demand'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检结果;正常、异常、关机、故障',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'inspection_result'
GO

EXEC sp_addextendedproperty
'MS_Description', N'报修标记',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'report_flag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'异常描述',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'exception_description'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新人',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检工单明细',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order_detail'
GO


-- ----------------------------
-- Primary Key structure for table eam_inspection_order_detail
-- ----------------------------
ALTER TABLE [dbo].[eam_inspection_order_detail] ADD CONSTRAINT [PK__eam_insp__3213E83FB31E58DA] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


 db/LS/eam_week_inspection_detail.sql

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,175 @@
/*
 Navicat Premium Dump SQL

 Source Server         : localhost-sqlserver
 Source Server Type    : SQL Server
 Source Server Version : 11003000 (11.00.3000)
 Source Host           : localhost:1433
 Source Catalog        : LXZN_TEST_430_NEW
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11003000 (11.00.3000)
 File Encoding         : 65001

 Date: 11/07/2025 10:50:40
*/


-- ----------------------------
-- Table structure for eam_week_inspection_detail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[eam_week_inspection_detail]') AND type IN ('U'))
    DROP TABLE [dbo].[eam_week_inspection_detail]
GO

CREATE TABLE [dbo].[eam_week_inspection_detail] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [equipment_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [standard_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [plan_inspection_date] datetime2(7)  NULL,
  [item_code] int  NULL,
  [item_name] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [item_demand] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [inspection_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [report_flag] nvarchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [exception_description] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [inspector] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [inspect_time] datetime2(7)  NULL
)
GO

ALTER TABLE [dbo].[eam_week_inspection_detail] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备ID',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'equipment_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标准ID',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'standard_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'计划点检日期',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'plan_inspection_date'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目序号',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'item_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'保养项目',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'item_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'保养要求',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'item_demand'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检结果;正常、异常、关机、故障',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'inspection_result'
GO

EXEC sp_addextendedproperty
'MS_Description', N'报修标记',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'report_flag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'异常描述',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'exception_description'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新人',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检人',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'inspector'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail',
'COLUMN', N'inspect_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'周点检明细',
'SCHEMA', N'dbo',
'TABLE', N'eam_week_inspection_detail'
GO


-- ----------------------------
-- Primary Key structure for table eam_week_inspection_detail
-- ----------------------------
ALTER TABLE [dbo].[eam_week_inspection_detail] ADD CONSTRAINT [PK__eam_week__3213E83FCC4AA6BA] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


 db/LS/sys_business_code_rule.sql

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,843 @@
/*
 Navicat Premium Dump SQL

 Source Server         : localhost-sqlserver
 Source Server Type    : SQL Server
 Source Server Version : 11003000 (11.00.3000)
 Source Host           : localhost:1433
 Source Catalog        : LXZN_TEST_430_NEW
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11003000 (11.00.3000)
 File Encoding         : 65001

 Date: 01/07/2025 10:19:15
*/


-- ----------------------------
-- Table structure for sys_business_code_rule
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_business_code_rule]') AND type IN ('U'))
    DROP TABLE [dbo].[sys_business_code_rule]
GO

CREATE TABLE [dbo].[sys_business_code_rule] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [create_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [del_flag] int  NULL,
  [business_name] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [business_code] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [prefix] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [year_format] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [month_format] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [day_format] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [seq_length] int  NULL
)
GO

ALTER TABLE [dbo].[sys_business_code_rule] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新人',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标记',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'del_flag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'业务名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'business_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'业务编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'business_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编码前缀',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'prefix'
GO

EXEC sp_addextendedproperty
'MS_Description', N'年份编码格式',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'year_format'
GO

EXEC sp_addextendedproperty
'MS_Description', N'月份编码格式',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'month_format'
GO

EXEC sp_addextendedproperty
'MS_Description', N'天 ç¼–码格式',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'day_format'
GO

EXEC sp_addextendedproperty
'MS_Description', N'序号长度',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule',
'COLUMN', N'seq_length'
GO

EXEC sp_addextendedproperty
'MS_Description', N'业务编码规则',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_rule'
GO


-- ----------------------------
-- Records of sys_business_code_rule
-- ----------------------------
INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1902203774154248193', N'admin', N'2025-03-19 11:41:35.6240000', NULL, NULL, N'0', N'工艺参数编码规则', N'ProcessParametersRule', N'PRC', N'yyyy', N'MM', N'dd', N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1902230626944094210', N'admin', N'2025-03-19 13:28:17.8550000', NULL, NULL, N'0', N'精度参数编码规则', N'PrecisionParametersRule', N'PRS', N'yy', N'M', N'd', N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1902243477803536385', N'admin', N'2025-03-19 14:19:21.0000000', N'admin', N'2025-03-19 14:36:36.2420000', N'0', N'备件请购单编码规则', N'SpareRequisitionCodeRule', N'SRCR', N'yyyy', N'MM', N'dd', N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1902247777776095233', N'admin', N'2025-03-19 14:36:26.9310000', NULL, NULL, N'0', N'故障原因编码规则', N'EquipmentFaultReasonRule', N'EFR', N'yyyy', NULL, NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1902628155861540866', N'admin', N'2025-03-20 15:47:56.0000000', N'admin', N'2025-03-20 15:48:03.3090000', N'0', N'备件编码规则', N'SparePartCodeRule', N'SP', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1905536888087691266', N'admin', N'2025-03-28 16:26:11.9360000', NULL, NULL, N'0', N'保养标准规则', N'MaintenanceStandardCodeRule', N'MSCR', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1907312309862907906', N'admin', N'2025-04-02 14:01:05.0000000', N'admin', N'2025-04-02 14:01:40.4970000', N'0', N'点检工单号规则', N'EamInspectionOrder', N'EIO', N'yyyy', N'MM', N'dd', N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1907665666767273985', N'admin', N'2025-04-03 13:25:12.3300000', NULL, NULL, N'0', N'周保工单号规则', N'WeekMaintenanceCodeRule', N'WMCR', N'yyyy', N'MM', N'', N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1909078470665629697', N'admin', N'2025-04-07 10:59:11.0260000', NULL, NULL, N'0', N'岗位编码规则', N'PositionCodeRule', N'PCR', NULL, NULL, NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1909083005541539841', N'admin', N'2025-04-07 11:17:12.0000000', N'admin', N'2025-04-07 11:18:37.9750000', N'0', N'维修工单编码规则', N'RepairOrderCodeRule', N'WX', N'yyyy', N'MM', N'', N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1921760981629857793', N'admin', N'2025-05-12 10:54:57.0000000', N'admin', N'2025-05-12 10:55:07.6780000', N'0', N'工具分类编码规则', N'ToolsClassify', N'GJFL', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1922563469951819778', N'admin', N'2025-05-14 16:03:45.3910000', NULL, NULL, N'0', N'二保编码规则', N'SecondMaintenanceCodeRule', N'SMCR', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1922563625669550081', N'admin', N'2025-05-14 16:04:22.5200000', NULL, NULL, N'0', N'三保编码规则', N'ThirdMaintenanceCodeRule', N'TMCR', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1922942124129423361', N'admin', N'2025-05-15 17:08:23.0000000', N'admin', N'2025-05-26 11:18:57.5170000', N'0', N'设备借出归还规则', N'EquipmentLeanOutCodeRule', N'LEAN', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1924402748380516353', N'admin', N'2025-05-19 17:52:23.5350000', NULL, NULL, N'0', N'工具入库申请单编码规则', N'InBoundOrder', N'IBO', NULL, NULL, NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1924661750514237441', N'admin', N'2025-05-20 11:01:34.4720000', NULL, NULL, N'0', N'工具出库申请单编码规则', N'outBoundOrder', N'OBO', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1925388470684553218', N'admin', N'2025-05-22 11:09:18.0000000', N'admin', N'2025-05-26 11:19:04.7460000', N'0', N'设备封存启封规则', N'EquipmentSealUpCodeRule', N'SEAL', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1925822932846026753', N'XU1129', N'2025-05-23 15:55:41.8760000', NULL, NULL, N'0', N'工具报损申请编码规则', N'LossBound', N'LB', N'YYYY', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1925823234437455874', N'XU1129', N'2025-05-23 15:56:53.0000000', N'XU1129', N'2025-05-23 16:11:59.2590000', N'0', N'工具盘点申请编码规则', N'stocktakingBound', N'TSB', N'YYYY', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1926840992444026882', N'admin', N'2025-05-26 11:21:06.0000000', N'admin', N'2025-05-26 11:32:19.5650000', N'0', N'设备调拨编码规则', N'EquipmentTransferCodeRule', N'DB', N'yyyy', N'MM', N'', N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1927198276936269826', N'admin', N'2025-05-27 11:00:49.0000000', N'admin', N'2025-05-27 11:57:07.4360000', N'0', N'设备报废编码规则', N'EquipmentScrapCodeRule', N'SCRAP', N'YYYY', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1929779613475590145', N'admin', N'2025-06-03 13:58:08.0000000', N'admin', N'2025-06-03 13:59:52.3910000', N'0', N'备件领用码规则', N'SparePartReceive', N'SPR', N'YYYY', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1930807505479364610', N'admin', N'2025-06-06 10:02:36.0000000', N'admin', N'2025-06-06 10:02:54.8780000', N'0', N'备件报废编码规则', N'SparePartScrapCodeRule', N'BJBF', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1933399195028254721', N'admin', N'2025-06-13 13:41:03.0000000', N'admin', N'2025-06-13 13:41:21.5630000', N'0', N'刀具准备单编码规则', N'ToolPreparationOrder', N'TPO', N'yyyy', N'MM', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1934814744203427841', N'admin', N'2025-06-17 11:25:56.0000000', N'admin', N'2025-06-17 11:26:49.6290000', N'0', N'油液编码规则', N'EamFluidCodeRule', N'EFCR', N'yyyy', N'MM', N'dd', N'4')
GO

INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1935244162453413890', N'admin', N'2025-06-18 15:52:18.0000000', N'admin', N'2025-06-30 21:25:31.6860000', N'0', N'设备采购计划编码规则', N'EquipmentPurchasePlanRule', N'EPPR', N'yyyy', N'MM', N'dd', N'4')
GO


-- ----------------------------
-- Table structure for sys_business_code_seq
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_business_code_seq]') AND type IN ('U'))
    DROP TABLE [dbo].[sys_business_code_seq]
GO

CREATE TABLE [dbo].[sys_business_code_seq] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [create_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [rule_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [prefix] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [current_year] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [current_month] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [current_day] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [current_seq] int  NULL
)
GO

ALTER TABLE [dbo].[sys_business_code_seq] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新人',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'规则编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'rule_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'前缀',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'prefix'
GO

EXEC sp_addextendedproperty
'MS_Description', N'当前年份',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'current_year'
GO

EXEC sp_addextendedproperty
'MS_Description', N'当前月份',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'current_month'
GO

EXEC sp_addextendedproperty
'MS_Description', N'当前天',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'current_day'
GO

EXEC sp_addextendedproperty
'MS_Description', N'当前序列值',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq',
'COLUMN', N'current_seq'
GO

EXEC sp_addextendedproperty
'MS_Description', N'业务编码生成序列',
'SCHEMA', N'dbo',
'TABLE', N'sys_business_code_seq'
GO


-- ----------------------------
-- Records of sys_business_code_seq
-- ----------------------------
INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1902205061780410369', N'admin', N'2025-03-19 11:46:42.6460000', NULL, NULL, N'1902203774154248193', N'PRC', N'2025', N'03', N'19', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1902235168561631234', N'admin', N'2025-03-19 13:46:20.6620000', NULL, NULL, N'1902230626944094210', N'PRS', N'25', N'3', N'19', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1902250920492605442', N'admin', N'2025-03-19 14:48:56.2100000', N'admin', N'2025-05-13 16:35:50.3900000', N'1902247777776095233', N'EFR', N'2025', NULL, NULL, N'6')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1902251196090417154', N'admin', N'2025-03-19 14:50:01.9190000', N'admin', N'2025-03-19 17:20:57.2470000', N'1902243477803536385', N'SRCR', N'2025', N'03', N'19', N'2')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1902549646657036289', N'admin', N'2025-03-20 10:35:58.0780000', N'admin', N'2025-03-20 15:48:27.0070000', N'1902243477803536385', N'SRCR', N'2025', N'03', N'20', N'10')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1902628442475110402', N'admin', N'2025-03-20 15:49:04.4650000', N'admin', N'2025-03-21 13:46:25.4790000', N'1902628155861540866', N'SP', N'2025', N'03', NULL, N'57')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1906546213484642306', N'zhangherong', N'2025-03-31 11:16:53.8660000', N'admin', N'2025-03-31 17:47:46.8580000', N'1905536888087691266', N'MSCR', N'2025', N'03', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1906983134023303169', N'admin', N'2025-04-01 16:13:03.8240000', N'liuyuanheng', N'2025-04-09 16:39:37.7410000', N'1905536888087691266', N'MSCR', N'2025', N'04', NULL, N'12')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1907687764440817666', N'admin', N'2025-04-03 14:53:00.8230000', N'admin', N'2025-04-03 17:17:04.7240000', N'1907312309862907906', N'EIO', N'2025', N'04', N'03', N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1907713865418760194', N'admin', N'2025-04-03 16:36:43.7820000', N'admin', N'2025-04-10 09:48:33.1140000', N'1907665666767273985', N'WMCR', N'2025', N'04', NULL, N'9')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1909066020519829506', N'admin', N'2025-04-07 10:09:42.6780000', N'admin', N'2025-04-07 17:43:46.9490000', N'1907312309862907906', N'EIO', N'2025', N'04', N'07', N'18')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1909079838063259650', N'admin', N'2025-04-07 11:04:37.0390000', N'admin', N'2025-05-27 17:11:23.2560000', N'1909078470665629697', N'PCR', NULL, NULL, NULL, N'7')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1909140283565137921', N'admin', N'2025-04-07 15:04:48.3650000', N'admin', N'2025-04-09 15:13:46.8090000', N'1909083005541539841', N'WX', N'2025', N'04', NULL, N'9')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1909413919380381698', N'admin', N'2025-04-08 09:12:08.2290000', N'liuyuanheng', N'2025-04-08 17:59:10.4020000', N'1907312309862907906', N'EIO', N'2025', N'04', N'08', N'21')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1909775081225768961', N'admin', N'2025-04-09 09:07:15.9240000', N'liuyuanheng', N'2025-04-09 16:24:32.7670000', N'1907312309862907906', N'EIO', N'2025', N'04', N'09', N'15')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1910222976441880578', N'admin', N'2025-04-10 14:47:02.4670000', N'admin', N'2025-04-10 15:39:33.1630000', N'1907312309862907906', N'EIO', N'2025', N'04', N'10', N'12')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1911679027821326338', N'admin', N'2025-04-14 15:12:52.1660000', NULL, NULL, N'1907312309862907906', N'EIO', N'2025', N'04', N'14', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1912333935927021570', N'admin', N'2025-04-16 10:35:14.4260000', N'admin', N'2025-04-16 10:48:35.0470000', N'1907312309862907906', N'EIO', N'2025', N'04', N'16', N'4')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1917417488566374402', N'admin', N'2025-04-30 11:15:27.8290000', NULL, NULL, N'1907312309862907906', N'EIO', N'2025', N'04', N'30', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1919939025538023426', N'admin', N'2025-05-07 10:15:09.0870000', NULL, NULL, N'1907312309862907906', N'EIO', N'2025', N'05', N'07', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1921770746502201345', N'admin', N'2025-05-12 11:33:45.3920000', NULL, NULL, N'1921760981629857793', N'GJFL', N'2025', N'05', NULL, N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1922521704305713153', N'admin', N'2025-05-14 13:17:47.6830000', N'admin', N'2025-05-23 09:57:43.3800000', N'1905536888087691266', N'MSCR', N'2025', N'05', NULL, N'10')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1922860589376278529', N'admin', N'2025-05-15 11:44:24.1810000', N'admin', N'2025-05-20 14:02:55.4210000', N'1922563469951819778', N'SMCR', N'2025', N'05', NULL, N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1922902573440782338', N'admin', N'2025-05-15 14:31:13.9610000', N'admin', N'2025-05-23 17:57:18.9220000', N'1922563625669550081', N'TMCR', N'2025', N'05', NULL, N'8')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1922946115039080449', N'admin', N'2025-05-15 17:24:15.0900000', N'admin', N'2025-05-30 15:55:44.3970000', N'1922942124129423361', N'LEAN', N'2025', N'05', NULL, N'19')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1924405751489536001', N'admin', N'2025-05-19 18:04:19.5380000', N'admin', N'2025-06-04 17:38:06.3530000', N'1924402748380516353', N'IBO', NULL, NULL, NULL, N'21')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1924663063441661954', N'admin', N'2025-05-20 11:06:47.4960000', N'admin', N'2025-05-20 11:06:53.4130000', N'1902243477803536385', N'SRCR', N'2025', N'05', N'20', N'2')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1924696535328579585', N'admin', N'2025-05-20 13:19:47.8100000', N'admin', N'2025-05-30 17:45:31.0570000', N'1924661750514237441', N'OBO', N'2025', N'05', NULL, N'22')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1924703916516208641', N'admin', N'2025-05-20 13:49:07.6250000', N'admin', N'2025-05-30 13:34:00.7890000', N'1902628155861540866', N'SP', N'2025', N'05', NULL, N'21')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1924742377038155778', N'admin', N'2025-05-20 16:21:57.3220000', N'admin', N'2025-05-20 16:26:04.6790000', N'1907312309862907906', N'EIO', N'2025', N'05', N'20', N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1925008251143806978', N'admin', N'2025-05-21 09:58:26.6500000', N'admin', N'2025-05-21 10:00:29.5430000', N'1902230626944094210', N'PRS', N'25', N'5', N'21', N'8')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1925388708644196353', N'admin', N'2025-05-22 11:10:14.7730000', N'admin', N'2025-05-26 09:25:32.7630000', N'1925388470684553218', N'SEAL', N'2025', N'05', NULL, N'8')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1925721230137196545', N'admin', N'2025-05-23 09:11:34.0930000', N'admin', N'2025-05-23 09:17:54.6240000', N'1902243477803536385', N'SRCR', N'2025', N'05', N'23', N'2')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1925733263605690370', N'admin', N'2025-05-23 09:59:23.0960000', NULL, NULL, N'1907312309862907906', N'EIO', N'2025', N'05', N'23', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1925826887617560578', N'XU1129', N'2025-05-23 16:11:24.7650000', NULL, NULL, N'1925823234437455874', N'sb', N'2025', N'05', NULL, N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1925827375918432258', N'XU1129', N'2025-05-23 16:13:21.2180000', N'admin', N'2025-05-26 14:06:17.9940000', N'1925823234437455874', N'TSB', N'2025', N'05', NULL, N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1925862287815938049', N'admin', N'2025-05-23 18:32:04.8560000', NULL, NULL, N'1925822932846026753', N'LB', N'2025', N'05', NULL, N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1926834324666683394', N'admin', N'2025-05-26 10:54:36.5080000', N'admin', N'2025-05-26 11:01:24.5150000', N'1902243477803536385', N'SRCR', N'2025', N'05', N'26', N'2')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1926843894491373569', N'admin', N'2025-05-26 11:32:38.1320000', N'admin', N'2025-05-27 10:58:43.0310000', N'1926840992444026882', N'DB', N'2025', N'05', NULL, N'9')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1927212610336874498', N'admin', N'2025-05-27 11:57:46.8400000', N'admin', N'2025-05-27 15:12:57.5920000', N'1927198276936269826', N'SCRAP', N'2025', N'05', NULL, N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1927241564099260417', N'admin', N'2025-05-27 13:52:49.9500000', N'admin', N'2025-05-27 17:20:07.9590000', N'1902243477803536385', N'SRCR', N'2025', N'05', N'27', N'12')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1927619521376444418', N'admin', N'2025-05-28 14:54:41.9960000', N'sqw', N'2025-05-28 18:20:59.0640000', N'1902243477803536385', N'SRCR', N'2025', N'05', N'28', N'5')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1928275207458533378', N'admin', N'2025-05-30 10:20:09.7310000', N'admin', N'2025-05-30 17:27:10.9680000', N'1902243477803536385', N'SRCR', N'2025', N'05', N'30', N'64')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1929716171297447937', N'admin', N'2025-06-03 09:46:02.2850000', N'admin', N'2025-06-03 16:07:23.8970000', N'1902243477803536385', N'SRCR', N'2025', N'06', N'03', N'12')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1929716193044914178', N'admin', N'2025-06-03 09:46:07.4720000', N'admin', N'2025-06-13 09:56:46.6060000', N'1902628155861540866', N'SP', N'2025', N'06', NULL, N'9')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1929779912953090050', N'admin', N'2025-06-03 13:59:19.4810000', N'admin', N'2025-06-06 15:09:40.5620000', N'1929779613475590145', N'SPR', N'2025', N'06', NULL, N'57')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1930141422624288770', N'admin', N'2025-06-04 13:55:50.1010000', NULL, NULL, N'1907312309862907906', N'EIO', N'2025', N'06', N'04', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1930185417001295874', N'admin', N'2025-06-04 16:50:39.1730000', N'admin', N'2025-06-16 14:18:23.2850000', N'1924661750514237441', N'OBO', N'2025', N'06', NULL, N'18')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1930552744431685633', N'admin', N'2025-06-05 17:10:16.8650000', N'admin', N'2025-06-05 17:15:51.5270000', N'1902243477803536385', N'SRCR', N'2025', N'06', N'05', N'5')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1930800566506713089', N'admin', N'2025-06-06 09:35:02.2450000', N'admin', N'2025-06-06 15:09:35.8540000', N'1902243477803536385', N'SRCR', N'2025', N'06', N'06', N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1930822662909685761', N'admin', N'2025-06-06 11:02:50.4570000', N'admin', N'2025-06-06 15:39:50.0790000', N'1930807505479364610', N'BJBF', N'2025', N'06', NULL, N'18')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1931954412185968642', N'admin', N'2025-06-09 14:00:00.4950000', N'admin', N'2025-06-09 14:00:02.2600000', N'1925822932846026753', N'LB', N'2025', N'06', NULL, N'2')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1931972588781166593', N'admin', N'2025-06-09 15:12:14.1130000', NULL, NULL, N'1902203774154248193', N'PRC', N'2025', N'06', N'09', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1932713779793424385', N'admin', N'2025-06-11 16:17:27.8320000', N'admin', N'2025-06-13 16:42:51.9590000', N'1925823234437455874', N'TSB', N'2025', N'06', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1933405091460493314', N'admin', N'2025-06-13 14:04:29.3980000', N'admin', N'2025-06-19 17:39:46.9190000', N'1933399195028254721', N'TPO', N'2025', N'06', NULL, N'5')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1934796748953202689', N'admin', N'2025-06-17 10:14:26.3820000', NULL, NULL, N'1902243477803536385', N'SRCR', N'2025', N'06', N'17', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1934817312719646722', N'admin', N'2025-06-17 11:36:09.1500000', N'admin', N'2025-06-17 13:50:33.1030000', N'1934814744203427841', N'EFCR', N'2025', N'06', N'17', N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1934853776615698434', N'admin', N'2025-06-17 14:01:02.8440000', N'admin', N'2025-06-20 13:16:23.0150000', N'1905536888087691266', N'MSCR', N'2025', N'06', NULL, N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1934854043465707521', N'admin', N'2025-06-17 14:02:06.4700000', N'admin', N'2025-06-20 14:49:18.3610000', N'1922563469951819778', N'SMCR', N'2025', N'06', NULL, N'4')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1934860730443403266', N'admin', N'2025-06-17 14:28:40.7610000', NULL, NULL, N'1902203774154248193', N'PRC', N'2025', N'06', N'17', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1935164771439497218', N'admin', N'2025-06-18 10:36:49.7860000', N'admin', N'2025-06-18 15:34:18.3130000', N'1907312309862907906', N'EIO', N'2025', N'06', N'18', N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1935246657187680258', N'admin', N'2025-06-18 16:02:12.8460000', NULL, NULL, N'1935244162453413890', N'EPPR', N'2025', N'06', N'18', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1935516820136026113', N'admin', N'2025-06-19 09:55:44.7370000', N'admin', N'2025-06-20 14:52:30.3050000', N'1922563625669550081', N'TMCR', N'2025', N'06', NULL, N'3')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1935540986675535874', N'admin', N'2025-06-19 11:31:46.4920000', NULL, NULL, N'1921760981629857793', N'GJFL', N'2025', N'06', NULL, N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1935600911224107009', N'admin', N'2025-06-19 15:29:53.6090000', NULL, NULL, N'1935244162453413890', N'EPPR', N'2025', N'06', N'19', N'1')
GO

INSERT INTO [dbo].[sys_business_code_seq] ([id], [create_by], [create_time], [update_by], [update_time], [rule_id], [prefix], [current_year], [current_month], [current_day], [current_seq]) VALUES (N'1935891092275654657', N'admin', N'2025-06-20 10:42:58.1410000', N'admin', N'2025-06-20 11:10:52.0490000', N'1935244162453413890', N'EPPR', N'2025', N'06', N'20', N'3')
GO


-- ----------------------------
-- Table structure for sys_maintain_depart
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_maintain_depart]') AND type IN ('U'))
    DROP TABLE [dbo].[sys_maintain_depart]
GO

CREATE TABLE [dbo].[sys_maintain_depart] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [parent_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [maintain_name] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [maintain_name_abbr] nvarchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [maintain_order] int  NULL,
  [description] nvarchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [org_type] nvarchar(10) COLLATE Chinese_PRC_CI_AS  NULL,
  [org_code] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [address] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [memo] nvarchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [status] nvarchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [del_flag] nvarchar(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_by] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [maintain_code] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_maintain_depart] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'parent_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'产线名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'maintain_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'缩写',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'maintain_name_abbr'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'maintain_order'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'description'
GO

EXEC sp_addextendedproperty
'MS_Description', N'产线类型 1一级部门 2子部门',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'org_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'产线编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'org_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'地址',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'address'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'memo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态（1启用，0不启用）',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除状态（0，正常，1已删除）',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'del_flag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建日期',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新人',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新日期',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'维修部门编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart',
'COLUMN', N'maintain_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'产线表',
'SCHEMA', N'dbo',
'TABLE', N'sys_maintain_depart'
GO


-- ----------------------------
-- Records of sys_maintain_depart
-- ----------------------------

-- ----------------------------
-- Table structure for sys_position
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_position]') AND type IN ('U'))
    DROP TABLE [dbo].[sys_position]
GO

CREATE TABLE [dbo].[sys_position] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [code] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [post_rank] nvarchar(2) COLLATE Chinese_PRC_CI_AS  NULL,
  [company_id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [sys_org_code] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_position] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'职务编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'职务名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'职级',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'post_rank'
GO

EXEC sp_addextendedproperty
'MS_Description', N'公司id',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'company_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'组织机构编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'sys_org_code'
GO


-- ----------------------------
-- Records of sys_position
-- ----------------------------
INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079838201671681', N'PCR0001', N'操作工', NULL, NULL, N'admin', N'2025-04-07 11:04:37.0720000', NULL, NULL, N'A01')
GO

INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079910381449218', N'PCR0002', N'维修工', NULL, NULL, N'admin', N'2025-04-07 11:04:54.2810000', NULL, NULL, N'A01')
GO

INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079939120820226', N'PCR0003', N'车间班组长', NULL, NULL, N'admin', N'2025-04-07 11:05:01.0000000', N'admin', N'2025-05-19 15:42:08.0230000', N'A01')
GO

INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079969235922946', N'PCR0004', N'车间设备管理员', NULL, NULL, N'admin', N'2025-04-07 11:05:08.0000000', N'admin', N'2025-05-19 15:41:14.8330000', N'A01')
GO

INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1922222199530192898', N'PCR0006', N'公司设备管理员', NULL, NULL, N'admin', N'2025-05-13 17:27:40.0000000', N'admin', N'2025-05-19 15:41:34.2050000', N'A01')
GO

INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1927291533460058114', N'PCR0007', N'备件管理员', NULL, NULL, N'admin', N'2025-05-27 17:11:23.5840000', NULL, NULL, N'A01')
GO


-- ----------------------------
-- Primary Key structure for table sys_business_code_rule
-- ----------------------------
ALTER TABLE [dbo].[sys_business_code_rule] ADD CONSTRAINT [PK__sys_busi__3213E83FAC8ACCD8] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_business_code_seq
-- ----------------------------
ALTER TABLE [dbo].[sys_business_code_seq] ADD CONSTRAINT [PK__sys_busi__3213E83F361CB9BB] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table sys_position
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [uniq_code]
ON [dbo].[sys_position] (
  [code] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_position
-- ----------------------------
ALTER TABLE [dbo].[sys_position] ADD CONSTRAINT [PK__sys_posi__3213E83F22016FDB] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


 db/LS/sys_position.sql

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,124 @@
/*
 Navicat Premium Dump SQL

 Source Server         : localhost-sqlserver
 Source Server Type    : SQL Server
 Source Server Version : 11003000 (11.00.3000)
 Source Host           : localhost:1433
 Source Catalog        : LXZN_TEST_430_NEW
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11003000 (11.00.3000)
 File Encoding         : 65001

 Date: 11/07/2025 10:51:28
*/


-- ----------------------------
-- Table structure for sys_position
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_position]') AND type IN ('U'))
    DROP TABLE [dbo].[sys_position]
GO

CREATE TABLE [dbo].[sys_position] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [code] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [post_rank] nvarchar(2) COLLATE Chinese_PRC_CI_AS  NULL,
  [company_id] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [sys_org_code] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_position] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'职务编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'职务名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'职级',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'post_rank'
GO

EXEC sp_addextendedproperty
'MS_Description', N'公司id',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'company_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'组织机构编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_position',
'COLUMN', N'sys_org_code'
GO


-- ----------------------------
-- Indexes structure for table sys_position
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [uniq_code]
ON [dbo].[sys_position] (
  [code] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_position
-- ----------------------------
ALTER TABLE [dbo].[sys_position] ADD CONSTRAINT [PK__sys_posi__3213E83F22016FDB] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/aspect/EquipmentHistoryLogAspect.java

@@ -118,7 +118,7 @@
                        log.setEquipmentId(order.getEquipmentId());
                        log.setBusinessId(order.getId());
                        log.setOperator(order.getOperator());
                        log.setDescription(order.getLeaderConfirmComment());
                        log.setDescription(order.getProblemDescription());
                        log.setCreateTime(order.getActualEndTime());
                    }
                }

 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/EamThirdMaintenanceChange.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,167 @@
package org.jeecg.modules.eam.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import org.jeecg.common.aspect.annotation.Dict;
import org.jeecg.common.system.base.entity.JeecgEntity;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.util.Date;

/**
 * @Description: ä¸‰ä¿å˜æ›´
 * @Author: jeecg-boot
 * @Date: 2025-07-11
 * @Version: V1.0
 */
@Data
@TableName("eam_third_maintenance_change")
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@ApiModel(value = "eam_third_maintenance_change对象", description = "三保变更")
public class EamThirdMaintenanceChange extends JeecgEntity implements Serializable {

    private static final long serialVersionUID = -5589051394307488593L;

    /**
     * åˆ é™¤æ ‡è®°
     */
    @Excel(name = "删除标记", width = 15)
    @ApiModelProperty(value = "删除标记")
    private Integer delFlag;
    /**
     * ä¸‰ä¿å·¥å•ID
     */
    @Excel(name = "三保工单ID", width = 15)
    @ApiModelProperty(value = "三保工单ID")
    private String orderId;
    /**
     * å˜æ›´å•å·
     */
    @Excel(name = "变更单号", width = 15)
    @ApiModelProperty(value = "变更单号")
    private String changeOrderNum;
    /**
     * ç”³è¯·äºº
     */
    @Excel(name = "申请人", width = 15)
    @ApiModelProperty(value = "申请人")
    @Dict(dicCode = "sys_user, realname, username")
    private String applicant;
    /**
     * ç”³è¯·éƒ¨é—¨
     */
    @Excel(name = "申请部门", width = 15)
    @ApiModelProperty(value = "申请部门")
    private String factoryOrgCode;
    /**
     * ç”³è¯·æ—¥æœŸ
     */
    @ApiModelProperty(value = "申请日期")
    @Excel(name = "申请日期", width = 20, format = "yyyy-MM-dd")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private Date applyDate;
    /**
     * ç”³è¯·ç±»åž‹;报废、延保
     */
    @Excel(name = "申请类型;报废、延保", width = 15)
    @ApiModelProperty(value = "申请类型;报废、延保")
    private String applyCategory;
    /**
     * å˜æ›´çŠ¶æ€;待提交、待主管审核、待部门确认、待保障部确认、已作废、已完成
     */
    @Excel(name = "变更状态;待提交、待主管审核、待部门确认、待保障部确认、已作废、已完成", width = 15)
    @ApiModelProperty(value = "变更状态;待提交、待主管审核、待部门确认、待保障部确认、已作废、已完成")
    private String changeStatus;
    /**
     * å»¶ä¿åŽŸå› ç±»åž‹;生产任务、设备故障、报废、大修项修、搬迁
     */
    @Excel(name = "延保原因类型;生产任务、设备故障、报废、大修项修、搬迁", width = 15)
    @ApiModelProperty(value = "延保原因类型;生产任务、设备故障、报废、大修项修、搬迁")
    private String applyReasonType;
    /**
     * å»¶ä¿(变更)原因
     */
    @Excel(name = "延保(变更)原因", width = 15)
    @ApiModelProperty(value = "延保(变更)原因")
    private String applyReason;
    /**
     * å»¶è¿Ÿä¿å…»æ—¥æœŸ
     */
    @ApiModelProperty(value = "延迟保养日期")
    @Excel(name = "延迟保养日期", width = 20, format = "yyyy-MM-dd")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private Date deferredMaintenanceDate;
    /**
     * ä¸»ç®¡é¢†å¯¼ç­¾å­—
     */
    @Excel(name = "主管领导签字", width = 15)
    @ApiModelProperty(value = "主管领导签字")
    @Dict(dicCode = "sys_user, realname, username")
    private String equipmentManagerSignature;
    /**
     * ä¸»ç®¡é¢†å¯¼ç­¾å­—时间
     */
    @ApiModelProperty(value = "主管领导签字时间")
    @Excel(name = "主管领导签字时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date equipmentManagerSignatureTime;
    /**
     * éƒ¨é—¨é¢†å¯¼ç­¾å­—;根据延保原因类型区分不同的人审批
     */
    @Excel(name = "部门领导签字;根据延保原因类型区分不同的人审批", width = 15)
    @ApiModelProperty(value = "部门领导签字;根据延保原因类型区分不同的人审批")
    @Dict(dicCode = "sys_user, realname, username")
    private String departManagerSignature;
    /**
     * éƒ¨é—¨é¢†å¯¼ç­¾å­—时间
     */
    @ApiModelProperty(value = "部门领导签字时间")
    @Excel(name = "部门领导签字时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date departManagerSignatureTime;
    /**
     * éƒ¨é—¨é¢†å¯¼æ„è§
     */
    @Excel(name = "部门领导意见", width = 15)
    @ApiModelProperty(value = "部门领导意见")
    private String departManagerComment;
    /**
     * ç”Ÿäº§ä¿éšœéƒ¨é¢†å¯¼ç­¾å­—
     */
    @Excel(name = "生产保障部领导签字", width = 15)
    @ApiModelProperty(value = "生产保障部领导签字")
    @Dict(dicCode = "sys_user, realname, username")
    private String productionSupportSignature;
    /**
     * ç”Ÿäº§ä¿éšœéƒ¨é¢†å¯¼ç­¾å­—时间
     */
    @ApiModelProperty(value = "生产保障部领导签字时间")
    @Excel(name = "生产保障部领导签字时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date productionSupportSignatureTime;
    /**
     * ç”Ÿäº§ä¿éšœéƒ¨é¢†å¯¼æ„è§
     */
    @Excel(name = "生产保障部领导意见", width = 15)
    @ApiModelProperty(value = "生产保障部领导意见")
    private String productionSupportComment;
    /**
     * HF编码
     */
    @Excel(name = "HF编码", width = 15)
    @ApiModelProperty(value = "HF编码")
    private String hfCode;
}

 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/EamThirdMaintenanceFurnace.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,129 @@
package org.jeecg.modules.eam.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import org.jeecg.common.aspect.annotation.Dict;
import org.jeecg.common.system.base.entity.JeecgEntity;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.util.Date;

/**
 * @Description: çœŸç©ºçƒ­å¤„理炉三保
 * @Author: jeecg-boot
 * @Date: 2025-07-11
 * @Version: V1.0
 */
@Data
@TableName("eam_third_maintenance_furnace")
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@ApiModel(value = "eam_third_maintenance_furnace对象", description = "真空热处理炉三保")
public class EamThirdMaintenanceFurnace extends JeecgEntity implements Serializable {

    private static final long serialVersionUID = -5799611070364065336L;

    /**
     * åˆ é™¤æ ‡è®°
     */
    @Excel(name = "删除标记", width = 15)
    @ApiModelProperty(value = "删除标记")
    private Integer delFlag;
    /**
     * è®¾å¤‡ID
     */
    @Excel(name = "设备ID", width = 15)
    @ApiModelProperty(value = "设备ID")
    private String equipmentId;
    /**
     * åŽ‹ç¼©ç©ºæ°”压力(MPa)
     */
    @Excel(name = "压缩空气压力(MPa)", width = 15)
    @ApiModelProperty(value = "压缩空气压力(MPa)")
    private String compressedAirPressureValue;
    /**
     * æžé™çœŸç©º(Pa)
     */
    @Excel(name = "极限真空(Pa)", width = 15)
    @ApiModelProperty(value = "极限真空(Pa)")
    private String ultimateVacuumValue;
    /**
     * æ³„漏率(Pa/h)
     */
    @Excel(name = "泄漏率(Pa/h)", width = 15)
    @ApiModelProperty(value = "泄漏率(Pa/h)")
    private String leakRate;
    /**
     * å‡€åŒ–处理
     */
    @Excel(name = "净化处理", width = 15)
    @ApiModelProperty(value = "净化处理")
    private String purificationTreatment;
    /**
     * ç‚‰æ¸©å‡åŒ€æ€§æ£€æµ‹
     */
    @Excel(name = "炉温均匀性检测", width = 15)
    @ApiModelProperty(value = "炉温均匀性检测")
    private String furnaceTemperatureUniformityTesting;
    /**
     * åŠ çƒ­åŠŸçŽ‡æµ‹è¯•
     */
    @Excel(name = "加热功率测试", width = 15)
    @ApiModelProperty(value = "加热功率测试")
    private String heatingPowerTest;
    /**
     * ä¿å…»äºº
     */
    @Excel(name = "保养人", width = 15)
    @ApiModelProperty(value = "保养人")
    @Dict(dicCode = "sys_user, realname, username")
    private String operator;
    /**
     * ä¿å…»æ—¥æœŸ
     */
    @ApiModelProperty(value = "保养日期")
    @Excel(name = "保养日期", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date operateTime;
    /**
     * ä¿å…»çŠ¶æ€;待提交、待确认、已完成
     */
    @Excel(name = "保养状态;待提交、待确认、已完成", width = 15)
    @ApiModelProperty(value = "保养状态;待提交、待确认、已完成")
    private String maintenanceStatus;
    /**
     * èƒ½å¦æ»¡è¶³åŠ å·¥éœ€æ±‚;是否
     */
    @Excel(name = "能否满足加工需求;是否", width = 15)
    @ApiModelProperty(value = "能否满足加工需求;是否")
    private String processingRequirementsFlag;
    /**
     * ç¡®è®¤äºº
     */
    @Excel(name = "确认人", width = 15)
    @ApiModelProperty(value = "确认人")
    @Dict(dicCode = "sys_user, realname, username")
    private String confirmUser;
    /**
     * ç¡®è®¤æ—¥æœŸ
     */
    @ApiModelProperty(value = "确认日期")
    @Excel(name = "确认日期", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date confirmTime;
    /**
     * HF编码
     */
    @Excel(name = "HF编码", width = 15)
    @ApiModelProperty(value = "HF编码")
    private String hfCode;
}

 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/EamThirdMaintenanceOrder.java

@@ -1,8 +1,6 @@
package org.jeecg.modules.eam.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
@@ -11,6 +9,7 @@
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import org.jeecg.common.aspect.annotation.Dict;
import org.jeecg.common.system.base.entity.JeecgEntity;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.format.annotation.DateTimeFormat;

@@ -28,36 +27,10 @@
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@ApiModel(value = "eam_third_maintenance_order对象", description = "设备三级保养")
public class EamThirdMaintenanceOrder implements Serializable {
public class EamThirdMaintenanceOrder extends JeecgEntity implements Serializable {

    /**
     * ä¸»é”®
     */
    @TableId(type = IdType.ASSIGN_ID)
    @ApiModelProperty(value = "主键")
    private String id;
    /**
     * åˆ›å»ºäºº
     */
    @Excel(name = "创建人", width = 15)
    @ApiModelProperty(value = "创建人")
    private String createBy;
    /**
     * åˆ›å»ºæ—¶é—´
     */
    @ApiModelProperty(value = "创建时间")
    private Date createTime;
    /**
     * æ›´æ–°äºº
     */
    @Excel(name = "更新人", width = 15)
    @ApiModelProperty(value = "更新人")
    private String updateBy;
    /**
     * æ›´æ–°æ—¶é—´
     */
    @ApiModelProperty(value = "更新时间")
    private Date updateTime;
    private static final long serialVersionUID = 2805431980389464185L;

    /**
     * åˆ é™¤æ ‡è®°
     */
@@ -90,6 +63,20 @@
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private Date maintenanceDate;
    /**
     * é”å®šå·¥å•æ—¥æœŸ
     */
    @ApiModelProperty(value = "锁定工单日期")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private Date freezeOrderDate;
    /**
     * å·¥å•è¿‡æœŸæ—¥æœŸ
     */
    @ApiModelProperty(value = "工单过期日期")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private Date orderExpirationDate;
    /**
     * å®žé™…开始时间
     */
    @Excel(name = "实际开始时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
@@ -106,12 +93,12 @@
    @ApiModelProperty(value = "实际结束时间")
    private Date actualEndTime;
    /**
     * ä¿å…»äºº
     * ç»´ä¿®äºº
     */
    @Excel(name = "保养人", width = 15)
    @ApiModelProperty(value = "保养人")
    @Excel(name = "维修人", width = 15)
    @ApiModelProperty(value = "维修人")
    @Dict(dicCode = "sys_user, realname, username")
    private String operator;
    private String repairman;
    /**
     * ä¿å…»çŠ¶æ€
     */
@@ -127,71 +114,137 @@
    @Dict(dicCode = "order_creation_method")
    private String creationMethod;
    /**
     * æœºåŠ¨åŠžç¡®è®¤
     * ä¿å…»äºº
     */
    @Excel(name = "机动办确认", width = 15)
    @ApiModelProperty(value = "机动办确认")
    @Excel(name = "保养人", width = 15)
    @ApiModelProperty(value = "保养人")
    @Dict(dicCode = "sys_user, realname, username")
    private String confirmUser;
    private String operator;
    /**
     * ç¡®è®¤æ„è§
     * è®¾å¤‡åŠŸèƒ½æ˜¯å¦é½å¤‡;是否
     */
    @ApiModelProperty(value = "确认意见")
    private String confirmComment;
    @Excel(name = "设备功能是否齐备;是否", width = 15)
    @ApiModelProperty(value = "设备功能是否齐备;是否")
    private String fullyFunctional;
    /**
     * ç¡®è®¤æ—¶é—´
     * è®¾å¤‡åŠŸèƒ½æ˜¯å¦é½å¤‡;是否
     */
    @Excel(name = "确认时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "设备能否正常运转;是否", width = 15)
    @ApiModelProperty(value = "设备功能是否齐备;是否")
    private String runningNormally;
    /**
     * é—®é¢˜æè¿°
     */
    @Excel(name = "问题描述", width = 30)
    @ApiModelProperty(value = "问题描述")
    private String problemDescription;
    /**
     * æ£€æŸ¥äºº
     */
    @Excel(name = "检查人", width = 15)
    @ApiModelProperty(value = "检查人")
    @Dict(dicCode = "sys_user, realname, username")
    private String inspector;
    /**
     * æ£€æŸ¥æ—¶é—´
     */
    @ApiModelProperty(value = "检查时间")
    @Excel(name = "检查时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "确认时间")
    private Date confirmTime;

    private Date inspectTime;
    /**
     * å•ä½é¢†å¯¼ç¡®è®¤
     * æ“ä½œäººç­¾å­—
     */
    @Excel(name = "单位领导确认", width = 15)
    @ApiModelProperty(value = "单位领导确认")
    @Excel(name = "操作人签字", width = 15)
    @ApiModelProperty(value = "操作人签字")
    @Dict(dicCode = "sys_user, realname, username")
    private String confirmLeader;
    private String operatorSignature;
    /**
     * é¢†å¯¼æ„è§
     * ååŠ©æ“ä½œäºº
     */
    @ApiModelProperty(value = "领导意见")
    private String leaderConfirmComment;
    @Excel(name = "协助操作人", width = 15)
    @ApiModelProperty(value = "协助操作人")
    @Dict(dicCode = "sys_user, realname, username")
    private String assistantOperator;
    /**
     * é¢†å¯¼ç¡®è®¤æ—¶é—´
     * æ“ä½œäººç­¾å­—时间
     */
    @ApiModelProperty(value = "领导确认时间")
    @ApiModelProperty(value = "操作人签字时间")
    @Excel(name = "操作人签字时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date leaderConfirmTime;

    @ApiModelProperty(value = "精度检验人")
    @Dict(dicCode = "sys_user, realname, username")
    private String precisionChecker;

    private Date operatorSignatureTime;
    /**
     * ç²¾åº¦æ£€éªŒæ—¶é—´
     * ç»´ä¿®äººç­¾å­—
     */
    @ApiModelProperty(value = "精度检验时间")
    @Excel(name = "维修人签字", width = 15)
    @ApiModelProperty(value = "维修人签字")
    @Dict(dicCode = "sys_user, realname, username")
    private String repairmanSignature;
    /**
     * ååŠ©ç»´ä¿®äºº
     */
    @Excel(name = "协助维修人", width = 15)
    @ApiModelProperty(value = "协助维修人")
    @Dict(dicCode = "sys_user, realname, username")
    private String assistantRepairman;
    /**
     * ç»´ä¿®äººç­¾å­—时间
     */
    @ApiModelProperty(value = "维修人签字时间")
    @Excel(name = "维修人签字时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date precisionCheckTime;

    private Date repairmanSignatureTime;
    /**
     * ä¿å…»ä¸Šä¼ å›¾ç‰‡
     * ç»´ä¿®å®¤ä¸»ä»»ç­¾å­—
     */
    @Excel(name = "保养上传图片", width = 15)
    @ApiModelProperty(value = "保养上传图片")
    private String imageFiles;
    @Excel(name = "维修室主任签字", width = 15)
    @ApiModelProperty(value = "维修室主任签字")
    @Dict(dicCode = "sys_user, realname, username")
    private String repairManagerSignature;
    /**
     * ç»´ä¿®å®¤ä¸»ä»»ç­¾å­—时间
     */
    @ApiModelProperty(value = "维修室主任签字时间")
    @Excel(name = "维修室主任签字时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date repairManagerSignatureTime;
    /**
     * è®¾å¤‡æ£€æŸ¥äººç­¾å­—
     */
    @Excel(name = "设备检查人签字", width = 15)
    @ApiModelProperty(value = "设备检查人签字")
    @Dict(dicCode = "sys_user, realname, username")
    private String inspectorSignature;
    /**
     * è®¾å¤‡æ£€æŸ¥äººç­¾å­—时间
     */
    @ApiModelProperty(value = "设备检查人签字时间")
    @Excel(name = "设备检查人签字时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date inspectorSignatureTime;
    /**
     * å¤‡æ³¨
     */
    @Excel(name = "备注", width = 15)
    @ApiModelProperty(value = "备注")
    private String remark;

    /**
     * ç§»äº¤å•HF编码
     */
    @Excel(name = "移交单HF编码", width = 15)
    @ApiModelProperty(value = "移交单HF编码")
    private String hfCodeA;
    /**
     * éªŒæ”¶å•HF编码
     */
    @Excel(name = "验收单HF编码", width = 15)
    @ApiModelProperty(value = "验收单HF编码")
    private String hfCodeB;
    //列表展示
    @TableField(exist = false)
    private String equipmentCode;

 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/EamThirdMaintenanceOrderDetail.java

@@ -3,80 +3,118 @@
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import org.jeecg.common.system.base.entity.JeecgEntity;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.util.Date;

/**
 * @Description: è®¾å¤‡ä¸‰çº§ä¿å…»æ˜Žç»†
 * @Author: jeecg-boot
 * @Date:   2025-04-29
 * @Date: 2025-04-29
 * @Version: V1.0
 */
@Data
@TableName("eam_third_maintenance_order_detail")
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@ApiModel(value="eam_third_maintenance_order_detail对象", description="设备三级保养明细")
public class EamThirdMaintenanceOrderDetail implements Serializable {
    
    /**主键*/
    @TableId(type = IdType.ASSIGN_ID)
    @ApiModelProperty(value = "主键")
    private String id;
    /**创建人*/
    @Excel(name = "创建人", width = 15)
    @ApiModelProperty(value = "创建人")
    private String createBy;
    /**创建时间*/
    @ApiModelProperty(value = "创建时间")
    private Date createTime;
    /**更新人*/
    @Excel(name = "更新人", width = 15)
    @ApiModelProperty(value = "更新人")
    private String updateBy;
    /**更新时间*/
    @ApiModelProperty(value = "更新时间")
    private Date updateTime;
    /**删除标记*/
    @Excel(name = "删除标记", width = 15)
@ApiModel(value = "eam_third_maintenance_order_detail对象", description = "设备三级保养明细")
public class EamThirdMaintenanceOrderDetail extends JeecgEntity implements Serializable {

    private static final long serialVersionUID = -862977193541514910L;

    /**
     * åˆ é™¤æ ‡è®°
     */
    @Excel(name = "删除标记", width = 15)
    @ApiModelProperty(value = "删除标记")
    private Integer delFlag;
    /**工单ID*/
    @Excel(name = "工单ID", width = 15)
    private Integer delFlag;
    /**
     * å·¥å•ID
     */
    @Excel(name = "工单ID", width = 15)
    @ApiModelProperty(value = "工单ID")
    private String orderId;
    /**项目序号*/
    @Excel(name = "项目序号", width = 15)
    private String orderId;
    /**
     * é¡¹ç›®åºå·
     */
    @Excel(name = "项目序号", width = 15)
    @ApiModelProperty(value = "项目序号")
    private Integer itemCode;
    /**保养项目*/
    @Excel(name = "保养项目", width = 15)
    @ApiModelProperty(value = "保养项目")
    private String itemName;
    /**子项目*/
    @Excel(name = "部位", width = 15)
    private Integer itemCode;
    /**
     * éƒ¨ä½
     */
    @Excel(name = "部位", width = 15)
    @ApiModelProperty(value = "部位")
    private String itemPart;
    /**保养要求*/
    @Excel(name = "保养要求", width = 15)
    @ApiModelProperty(value = "保养要求")
    private String itemDemand;
    /**报修标记*/
    @Excel(name = "报修标记", width = 15)
    @ApiModelProperty(value = "报修标记")
    private String reportFlag;
    /**保养结果*/
    @Excel(name = "保养结果", width = 15)
    private String itemPart;
    /**
     * ä¿å…»å†…容
     */
    @Excel(name = "保养内容", width = 15)
    @ApiModelProperty(value = "保养内容")
    private String itemName;
    /**
     * éªŒæ”¶æ ‡å‡†
     */
    @Excel(name = "验收标准", width = 15)
    @ApiModelProperty(value = "验收标准")
    private String itemDemand;
    /**
     * ä¿å…»ç»“æžœ
     */
    @Excel(name = "保养结果", width = 15)
    @ApiModelProperty(value = "保养结果")
    private String maintenanceResult;
    /**异常描述*/
    @Excel(name = "异常描述", width = 15)
    private String maintenanceResult;
    /**
     * å¼‚常描述
     */
    @Excel(name = "异常描述", width = 15)
    @ApiModelProperty(value = "异常描述")
    private String exceptionDescription;
    private String exceptionDescription;
    /**
     * ç¬¬ä¸€æ¬¡æ£€éªŒç»“æžœ
     */
    @Excel(name = "第一次检验结果", width = 15)
    @ApiModelProperty(value = "第一次检验结果")
    private String firstInspectResult;
    /**
     * ç¬¬ä¸€æ¬¡æ£€éªŒæ—¶é—´
     */
    @ApiModelProperty(value = "第一次检验时间")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date firstInspectTime;
    /**
     * ç¬¬ä¸€æ¬¡æ£€éªŒå¼‚常
     */
    @Excel(name = "第一次检验异常", width = 15)
    @ApiModelProperty(value = "第一次检验异常")
    private String firstInspectException;
    /**
     * ç¬¬äºŒæ¬¡æ£€éªŒç»“æžœ
     */
    @Excel(name = "第二次检验结果", width = 15)
    @ApiModelProperty(value = "第二次检验结果")
    private String secondInspectResult;
    /**
     * ç¬¬äºŒæ¬¡æ£€éªŒæ—¶é—´
     */
    @ApiModelProperty(value = "第二次检验时间")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date secondInspectTime;
    /**
     * ç¬¬äºŒæ¬¡æ£€éªŒå¼‚常
     */
    @Excel(name = "第二次检验异常", width = 15)
    @ApiModelProperty(value = "第二次检验异常")
    private String secondInspectException;
}

 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/EamThirdMaintenanceSpare.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,54 @@
package org.jeecg.modules.eam.entity;

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 org.jeecg.common.system.base.entity.JeecgEntity;
import org.jeecgframework.poi.excel.annotation.Excel;

import java.io.Serializable;
import java.math.BigDecimal;

/**
 * @Description: ä¸‰ä¿å¤‡ä»¶æ˜Žç»†
 * @Author: jeecg-boot
 * @Date: 2025-07-11
 * @Version: V1.0
 */
@Data
@TableName("eam_third_maintenance_spare")
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@ApiModel(value = "eam_third_maintenance_spare对象", description = "三保备件明细")
public class EamThirdMaintenanceSpare extends JeecgEntity implements Serializable {

    private static final long serialVersionUID = -164548817301978100L;

    /**
     * å¤‡ä»¶åç§°
     */
    @Excel(name = "备件名称", width = 15)
    @ApiModelProperty(value = "备件名称")
    private String spareName;
    /**
     * å¤‡ä»¶åž‹å·
     */
    @Excel(name = "备件型号", width = 15)
    @ApiModelProperty(value = "备件型号")
    private String spareModel;
    /**
     * ä½¿ç”¨æ•°é‡
     */
    @Excel(name = "使用数量", width = 15)
    @ApiModelProperty(value = "使用数量")
    private BigDecimal spareQuantity;
    /**
     * å¤‡æ³¨
     */
    @Excel(name = "备注", width = 15)
    @ApiModelProperty(value = "备注")
    private String remark;
}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamThirdMaintenanceChangeController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,153 @@
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.EamThirdMaintenanceChange;
import org.jeecg.modules.eam.service.IEamThirdMaintenanceChangeService;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Arrays;

/**
 * @Description: ä¸‰ä¿å˜æ›´
 * @Author: jeecg-boot
 * @Date: 2025-07-11
 * @Version: V1.0
 */
@Slf4j
@Api(tags = "三保变更")
@RestController
@RequestMapping("/eam/eamThirdMaintenanceChange")
public class EamThirdMaintenanceChangeController extends JeecgController<EamThirdMaintenanceChange, IEamThirdMaintenanceChangeService> {

    @Resource
    private IEamThirdMaintenanceChangeService eamThirdMaintenanceChangeService;

    /**
     * åˆ†é¡µåˆ—表查询
     *
     * @param eamThirdMaintenanceChange
     * @param pageNo
     * @param pageSize
     * @param req
     * @return
     */
    @AutoLog(value = "三保变更-分页列表查询")
    @ApiOperation(value = "三保变更-分页列表查询", notes = "三保变更-分页列表查询")
    @GetMapping(value = "/list")
    public Result<?> queryPageList(EamThirdMaintenanceChange eamThirdMaintenanceChange,
                                   @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
                                   @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
                                   HttpServletRequest req) {
        QueryWrapper<EamThirdMaintenanceChange> queryWrapper = QueryGenerator.initQueryWrapper(eamThirdMaintenanceChange, req.getParameterMap());
        Page<EamThirdMaintenanceChange> page = new Page<EamThirdMaintenanceChange>(pageNo, pageSize);
        IPage<EamThirdMaintenanceChange> pageList = eamThirdMaintenanceChangeService.page(page, queryWrapper);
        return Result.OK(pageList);
    }

    /**
     * æ·»åŠ 
     *
     * @param eamThirdMaintenanceChange
     * @return
     */
    @AutoLog(value = "三保变更-添加")
    @ApiOperation(value = "三保变更-添加", notes = "三保变更-添加")
    @PostMapping(value = "/add")
    public Result<?> add(@RequestBody EamThirdMaintenanceChange eamThirdMaintenanceChange) {
        eamThirdMaintenanceChangeService.save(eamThirdMaintenanceChange);
        return Result.OK("添加成功！");
    }

    /**
     * ç¼–辑
     *
     * @param eamThirdMaintenanceChange
     * @return
     */
    @AutoLog(value = "三保变更-编辑")
    @ApiOperation(value = "三保变更-编辑", notes = "三保变更-编辑")
    @RequestMapping(value = "/edit", method = {RequestMethod.PUT, RequestMethod.POST})
    public Result<?> edit(@RequestBody EamThirdMaintenanceChange eamThirdMaintenanceChange) {
        eamThirdMaintenanceChangeService.updateById(eamThirdMaintenanceChange);
        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) {
        eamThirdMaintenanceChangeService.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.eamThirdMaintenanceChangeService.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) {
        EamThirdMaintenanceChange eamThirdMaintenanceChange = eamThirdMaintenanceChangeService.getById(id);
        return Result.OK(eamThirdMaintenanceChange);
    }

    /**
     * å¯¼å‡ºexcel
     *
     * @param request
     * @param eamThirdMaintenanceChange
     */
    @RequestMapping(value = "/exportXls")
    public ModelAndView exportXls(HttpServletRequest request, EamThirdMaintenanceChange eamThirdMaintenanceChange) {
        return super.exportXls(request, eamThirdMaintenanceChange, EamThirdMaintenanceChange.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, EamThirdMaintenanceChange.class);
    }

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamThirdMaintenanceFurnaceController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,152 @@
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.EamThirdMaintenanceFurnace;
import org.jeecg.modules.eam.service.IEamThirdMaintenanceFurnaceService;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Arrays;

/**
 * @Description: çœŸç©ºçƒ­å¤„理炉三保
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
@Slf4j
@Api(tags="真空热处理炉三保")
@RestController
@RequestMapping("/eam/eamThirdMaintenanceFurnace")
public class EamThirdMaintenanceFurnaceController extends JeecgController<EamThirdMaintenanceFurnace, IEamThirdMaintenanceFurnaceService> {
    @Resource
    private IEamThirdMaintenanceFurnaceService eamThirdMaintenanceFurnaceService;
	
    /**
     * åˆ†é¡µåˆ—表查询
     *
     * @param eamThirdMaintenanceFurnace
     * @param pageNo
     * @param pageSize
     * @param req
     * @return
     */
    @AutoLog(value = "真空热处理炉三保-分页列表查询")
    @ApiOperation(value="真空热处理炉三保-分页列表查询", notes="真空热处理炉三保-分页列表查询")
    @GetMapping(value = "/list")
    public Result<?> queryPageList(EamThirdMaintenanceFurnace eamThirdMaintenanceFurnace,
                                   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
                                   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
                                   HttpServletRequest req) {
        QueryWrapper<EamThirdMaintenanceFurnace> queryWrapper = QueryGenerator.initQueryWrapper(eamThirdMaintenanceFurnace, req.getParameterMap());
        Page<EamThirdMaintenanceFurnace> page = new Page<EamThirdMaintenanceFurnace>(pageNo, pageSize);
        IPage<EamThirdMaintenanceFurnace> pageList = eamThirdMaintenanceFurnaceService.page(page, queryWrapper);
        return Result.OK(pageList);
    }
	
    /**
     * æ·»åŠ 
     *
     * @param eamThirdMaintenanceFurnace
     * @return
     */
    @AutoLog(value = "真空热处理炉三保-添加")
    @ApiOperation(value="真空热处理炉三保-添加", notes="真空热处理炉三保-添加")
    @PostMapping(value = "/add")
    public Result<?> add(@RequestBody EamThirdMaintenanceFurnace eamThirdMaintenanceFurnace) {
        eamThirdMaintenanceFurnaceService.save(eamThirdMaintenanceFurnace);
        return Result.OK("添加成功！");
    }
	
    /**
     * ç¼–辑
     *
     * @param eamThirdMaintenanceFurnace
     * @return
     */
    @AutoLog(value = "真空热处理炉三保-编辑")
    @ApiOperation(value="真空热处理炉三保-编辑", notes="真空热处理炉三保-编辑")
    @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
    public Result<?> edit(@RequestBody EamThirdMaintenanceFurnace eamThirdMaintenanceFurnace) {
        eamThirdMaintenanceFurnaceService.updateById(eamThirdMaintenanceFurnace);
        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) {
        eamThirdMaintenanceFurnaceService.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.eamThirdMaintenanceFurnaceService.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) {
        EamThirdMaintenanceFurnace eamThirdMaintenanceFurnace = eamThirdMaintenanceFurnaceService.getById(id);
        return Result.OK(eamThirdMaintenanceFurnace);
    }

  /**
   * å¯¼å‡ºexcel
   *
   * @param request
   * @param eamThirdMaintenanceFurnace
   */
  @RequestMapping(value = "/exportXls")
  public ModelAndView exportXls(HttpServletRequest request, EamThirdMaintenanceFurnace eamThirdMaintenanceFurnace) {
      return super.exportXls(request, eamThirdMaintenanceFurnace, EamThirdMaintenanceFurnace.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, EamThirdMaintenanceFurnace.class);
  }

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamThirdMaintenanceSpareController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,153 @@
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.EamThirdMaintenanceSpare;
import org.jeecg.modules.eam.service.IEamThirdMaintenanceSpareService;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Arrays;

/**
 * @Description: ä¸‰ä¿å¤‡ä»¶æ˜Žç»†
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
@Slf4j
@Api(tags="三保备件明细")
@RestController
@RequestMapping("/eam/eamThirdMaintenanceSpare")
public class EamThirdMaintenanceSpareController extends JeecgController<EamThirdMaintenanceSpare, IEamThirdMaintenanceSpareService> {

    @Resource
    private IEamThirdMaintenanceSpareService eamThirdMaintenanceSpareService;
	
    /**
     * åˆ†é¡µåˆ—表查询
     *
     * @param eamThirdMaintenanceSpare
     * @param pageNo
     * @param pageSize
     * @param req
     * @return
     */
    @AutoLog(value = "三保备件明细-分页列表查询")
    @ApiOperation(value="三保备件明细-分页列表查询", notes="三保备件明细-分页列表查询")
    @GetMapping(value = "/list")
    public Result<?> queryPageList(EamThirdMaintenanceSpare eamThirdMaintenanceSpare,
                                   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
                                   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
                                   HttpServletRequest req) {
        QueryWrapper<EamThirdMaintenanceSpare> queryWrapper = QueryGenerator.initQueryWrapper(eamThirdMaintenanceSpare, req.getParameterMap());
        Page<EamThirdMaintenanceSpare> page = new Page<EamThirdMaintenanceSpare>(pageNo, pageSize);
        IPage<EamThirdMaintenanceSpare> pageList = eamThirdMaintenanceSpareService.page(page, queryWrapper);
        return Result.OK(pageList);
    }
	
    /**
     * æ·»åŠ 
     *
     * @param eamThirdMaintenanceSpare
     * @return
     */
    @AutoLog(value = "三保备件明细-添加")
    @ApiOperation(value="三保备件明细-添加", notes="三保备件明细-添加")
    @PostMapping(value = "/add")
    public Result<?> add(@RequestBody EamThirdMaintenanceSpare eamThirdMaintenanceSpare) {
        eamThirdMaintenanceSpareService.save(eamThirdMaintenanceSpare);
        return Result.OK("添加成功！");
    }
	
    /**
     * ç¼–辑
     *
     * @param eamThirdMaintenanceSpare
     * @return
     */
    @AutoLog(value = "三保备件明细-编辑")
    @ApiOperation(value="三保备件明细-编辑", notes="三保备件明细-编辑")
    @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
    public Result<?> edit(@RequestBody EamThirdMaintenanceSpare eamThirdMaintenanceSpare) {
        eamThirdMaintenanceSpareService.updateById(eamThirdMaintenanceSpare);
        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) {
        eamThirdMaintenanceSpareService.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.eamThirdMaintenanceSpareService.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) {
        EamThirdMaintenanceSpare eamThirdMaintenanceSpare = eamThirdMaintenanceSpareService.getById(id);
        return Result.OK(eamThirdMaintenanceSpare);
    }

  /**
   * å¯¼å‡ºexcel
   *
   * @param request
   * @param eamThirdMaintenanceSpare
   */
  @RequestMapping(value = "/exportXls")
  public ModelAndView exportXls(HttpServletRequest request, EamThirdMaintenanceSpare eamThirdMaintenanceSpare) {
      return super.exportXls(request, eamThirdMaintenanceSpare, EamThirdMaintenanceSpare.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, EamThirdMaintenanceSpare.class);
  }

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/EamThirdMaintenanceChangeMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,14 @@
package org.jeecg.modules.eam.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.eam.entity.EamThirdMaintenanceChange;

/**
 * @Description: ä¸‰ä¿å˜æ›´
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
public interface EamThirdMaintenanceChangeMapper extends BaseMapper<EamThirdMaintenanceChange> {

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/EamThirdMaintenanceFurnaceMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,14 @@
package org.jeecg.modules.eam.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.eam.entity.EamThirdMaintenanceFurnace;

/**
 * @Description: çœŸç©ºçƒ­å¤„理炉三保
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
public interface EamThirdMaintenanceFurnaceMapper extends BaseMapper<EamThirdMaintenanceFurnace> {

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/EamThirdMaintenanceSpareMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,14 @@
package org.jeecg.modules.eam.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.eam.entity.EamThirdMaintenanceSpare;

/**
 * @Description: ä¸‰ä¿å¤‡ä»¶æ˜Žç»†
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
public interface EamThirdMaintenanceSpareMapper extends BaseMapper<EamThirdMaintenanceSpare> {

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamThirdMaintenanceChangeMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,5 @@
<?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.EamThirdMaintenanceChangeMapper">

</mapper>

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamThirdMaintenanceFurnaceMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,5 @@
<?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.EamThirdMaintenanceFurnaceMapper">

</mapper>

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamThirdMaintenanceSpareMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,5 @@
<?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.EamThirdMaintenanceSpareMapper">

</mapper>

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamThirdMaintenanceChangeService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,14 @@
package org.jeecg.modules.eam.service;

import com.baomidou.mybatisplus.extension.service.IService;
import org.jeecg.modules.eam.entity.EamThirdMaintenanceChange;

/**
 * @Description: ä¸‰ä¿å˜æ›´
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
public interface IEamThirdMaintenanceChangeService extends IService<EamThirdMaintenanceChange> {

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamThirdMaintenanceFurnaceService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,14 @@
package org.jeecg.modules.eam.service;

import com.baomidou.mybatisplus.extension.service.IService;
import org.jeecg.modules.eam.entity.EamThirdMaintenanceFurnace;

/**
 * @Description: çœŸç©ºçƒ­å¤„理炉三保
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
public interface IEamThirdMaintenanceFurnaceService extends IService<EamThirdMaintenanceFurnace> {

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamThirdMaintenanceSpareService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,14 @@
package org.jeecg.modules.eam.service;

import com.baomidou.mybatisplus.extension.service.IService;
import org.jeecg.modules.eam.entity.EamThirdMaintenanceSpare;

/**
 * @Description: ä¸‰ä¿å¤‡ä»¶æ˜Žç»†
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
public interface IEamThirdMaintenanceSpareService extends IService<EamThirdMaintenanceSpare> {

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamThirdMaintenanceChangeServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
package org.jeecg.modules.eam.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.jeecg.modules.eam.entity.EamThirdMaintenanceChange;
import org.jeecg.modules.eam.mapper.EamThirdMaintenanceChangeMapper;
import org.jeecg.modules.eam.service.IEamThirdMaintenanceChangeService;
import org.springframework.stereotype.Service;

/**
 * @Description: ä¸‰ä¿å˜æ›´
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
@Service
public class EamThirdMaintenanceChangeServiceImpl extends ServiceImpl<EamThirdMaintenanceChangeMapper, EamThirdMaintenanceChange> implements IEamThirdMaintenanceChangeService {

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamThirdMaintenanceFurnaceServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
package org.jeecg.modules.eam.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.jeecg.modules.eam.entity.EamThirdMaintenanceFurnace;
import org.jeecg.modules.eam.mapper.EamThirdMaintenanceFurnaceMapper;
import org.jeecg.modules.eam.service.IEamThirdMaintenanceFurnaceService;
import org.springframework.stereotype.Service;

/**
 * @Description: çœŸç©ºçƒ­å¤„理炉三保
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
@Service
public class EamThirdMaintenanceFurnaceServiceImpl extends ServiceImpl<EamThirdMaintenanceFurnaceMapper, EamThirdMaintenanceFurnace> implements IEamThirdMaintenanceFurnaceService {

}

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamThirdMaintenanceOrderServiceImpl.java

@@ -3,8 +3,10 @@
import cn.hutool.core.collection.CollectionUtil;
import cn.hutool.core.util.StrUtil;
import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.fasterxml.jackson.core.JsonProcessingException;
@@ -38,6 +40,10 @@
import org.jeecg.modules.flowable.apithird.service.FlowCommonService;
import org.jeecg.modules.flowable.service.IFlowDefinitionService;
import org.jeecg.modules.flowable.service.IFlowTaskService;
import org.jeecg.modules.system.entity.BaseFactory;
import org.jeecg.modules.system.entity.BaseFactoryUser;
import org.jeecg.modules.system.service.IBaseFactoryService;
import org.jeecg.modules.system.service.IBaseFactoryUserService;
import org.jeecg.modules.system.service.ISysUserService;
import org.jeecg.modules.system.vo.UserSelector;
import org.springframework.beans.factory.annotation.Autowired;
@@ -82,6 +88,11 @@
    @Autowired
    private IEamPrecisionCheckDetailService precisionCheckDetailService;

    @Resource
    private IBaseFactoryUserService baseFactoryUserService;
    @Resource
    private IBaseFactoryService baseFactoryService;

    @Override
    public IPage<EamThirdMaintenanceOrder> queryPageList(Page<EamThirdMaintenanceOrder> page, EamThirdMaintenanceQuery query) {
        QueryWrapper<EamThirdMaintenanceOrder> queryWrapper = new QueryWrapper<>();
@@ -95,8 +106,16 @@
            List<String> equipArr = Arrays.asList(sysUser.getEquipmentIds().split(","));
            queryWrapper.in("e.equipment_code", equipArr);
        } else {
            //没有选择设备，根据车间过滤设备
            queryWrapper.exists("select 1 from mdc_user_production t where t.user_id={0} and t.pro_id=e.org_id ", sysUser.getId());
            //没有选择设备，根据中心过滤设备
            List<BaseFactoryUser> baseFactoryUserList = baseFactoryUserService.
                    list(new LambdaQueryWrapper<BaseFactoryUser>().eq(BaseFactoryUser::getUserId, sysUser.getId()));
            if (!CollectionUtils.isEmpty(baseFactoryUserList)) {
                Set<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toSet());
                Set<String> factoryCode = baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getOrgCode).collect(Collectors.toSet());
                queryWrapper.in("e.factory_org_code", factoryCode);
            }else {
                return page;
            }
        }
        //查询条件过滤
        if (query != null) {
@@ -330,138 +349,138 @@
        if (entity == null) {
            throw new JeecgBootException("审批的数据已删除，请刷新重试！");
        }
        // èŽ·å–当前登录用户
        LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
        if (user == null || StrUtil.isBlank(user.getId())) {
            throw new JeecgBootException("未获取到登录用户，请重新登录后再试！");
        }
        request.setAssignee(user.getUsername());
        // èŽ·å–流程业务记录
        FlowMyBusiness flowMyBusiness = flowMyBusinessService.getFlowMyBusiness(request.getInstanceId(), request.getTaskId());
        if (flowMyBusiness == null) {
            throw new JeecgBootException("流程实例不存在，请刷新后重试！");
        }

        boolean userAuthorized = isUserAuthorized(flowMyBusiness, user);
        if (!userAuthorized) {
            throw new JeecgBootException("用户无权操作此任务，请刷新后重试！");
        }
        // è®¤é¢†ä»»åŠ¡
        if (!claimTask(flowMyBusiness.getTaskId(), user)) {
            throw new JeecgBootException("任务不存在、已完成或已被他人认领！");
        }

        EamEquipment equipment = eamEquipmentService.getById(entity.getEquipmentId());
        if (equipment == null) {
            throw new JeecgBootException("设备不存在，请检查！");
        }

        ThirdMaintenanceStatusEnum status = ThirdMaintenanceStatusEnum.getInstance(entity.getMaintenanceStatus());
        if (status == null) {
            return null;
        }
        //流程变量
        Map<String, Object> values = new HashMap<>();
        List<String> userApprovalList;
        List<UserSelector> userSelectors;
        switch (status) {
            case UNDER_MAINTENANCE:
                boolean parallelCompletion = flowTaskService.checkParallelCompletion(flowMyBusiness.getTaskId());
                //执行完成
                userSelectors = sysUserService.selectOperatorList(equipment.getEquipmentCode(), null, BusinessCodeConst.PCR0006);
                if (CollectionUtil.isEmpty(userSelectors)) {
                    throw new JeecgBootException("设备未分配给车间班组长，无法进入下级审批！");
                }
                userApprovalList = userSelectors.stream().map(UserSelector::getUsername).collect(Collectors.toList());
                values.put("dataId", entity.getId());
                values.put("organization", "三保执行结束");
                values.put("comment", "三保执行结束");
                if (parallelCompletion) {
                    values.put("NextAssignee", userApprovalList);
                }
                request.setComment("三保执行结束");
                //设置entity
                if (parallelCompletion) {
                    entity.setMaintenanceStatus(ThirdMaintenanceStatusEnum.WAIT_CONFIRM.name());
                    entity.setActualEndTime(new Date());
                }
                if ("maintenance_execution".equals(flowMyBusiness.getTaskNameId())) {
                    //执行保养
                    //处理附件
                    if (CollectionUtil.isNotEmpty(request.getImageFilesResult())) {
                        List<FileUploadResult> fileUploadResultList = request.getImageFilesResult();
                        ObjectMapper mapper = new ObjectMapper();
                        try {
                            String referenceFile = mapper.writeValueAsString(fileUploadResultList);
                            entity.setImageFiles(referenceFile);
                        } catch (JsonProcessingException e) {
                            log.error("JSON转换失败：" + e.getMessage(), e);
                        }
                    }
                    //处理详情
                    if (CollectionUtil.isNotEmpty(request.getTableDetailList())) {
                        thirdMaintenanceOrderDetailService.updateBatchById(request.getTableDetailList());
                    }
                } else if ("precision_check".equals(flowMyBusiness.getTaskNameId())) {
                    entity.setPrecisionChecker(user.getUsername());
                    entity.setPrecisionCheckTime(new Date());
                    //处理精度检验
                    if (CollectionUtil.isNotEmpty(request.getPrecisionDetailList())) {
                        precisionCheckDetailService.updateBatchById(request.getPrecisionDetailList());
                    }
                }
                if (parallelCompletion) {
                    //更新设备保养状态
                    eamEquipmentExtendService.updateEquipmentMaintenanceStatus(entity.getEquipmentId(), EquipmentMaintenanceStatus.THIRD_MAINTENANCE_WAIT_CONFIRM.name());
                }
                break;
            case WAIT_CONFIRM:
                userSelectors = sysUserService.selectOperatorList(equipment.getEquipmentCode(),null, BusinessCodeConst.PCR0003);
                if (CollectionUtil.isEmpty(userSelectors)) {
                    throw new JeecgBootException("设备未分配给车间班组长，无法进入下级审批！");
                }
                //班组长确认
                userApprovalList = userSelectors.stream().map(UserSelector::getUsername).collect(Collectors.toList());
                values.put("dataId", entity.getId());
                values.put("organization", request.getConfirmComment());
                values.put("comment", request.getConfirmComment());
                values.put("NextAssignee", userApprovalList);
                values.put("confirmation", request.getConfirmDealType());
                request.setComment(request.getConfirmComment());
                //设置entity
                entity.setMaintenanceStatus(ThirdMaintenanceStatusEnum.WAIT_LEADER_CONFIRM.name());
                entity.setConfirmUser(user.getUsername());
                entity.setConfirmComment(request.getConfirmComment());
                entity.setConfirmTime(new Date());
                //处理报修
                List<EamThirdMaintenanceOrderDetail> collect = request.getTableDetailList().stream().filter((detail) -> CommonConstant.DEFAULT_1.equals(detail.getReportFlag())).collect(Collectors.toList());
                if (CollectionUtil.isNotEmpty(collect)) {
                    eamReportRepairService.reportRepairFromThirdMaintenance(equipment.getId(), entity.getOperator(), collect);
                }
                break;
            case WAIT_LEADER_CONFIRM:
                values.put("dataId", entity.getId());
                values.put("organization", request.getLeaderConfirmComment());
                values.put("comment", request.getLeaderConfirmComment());
                request.setComment(request.getLeaderConfirmComment());
                //设置entity
                entity.setMaintenanceStatus(ThirdMaintenanceStatusEnum.COMPLETE.name());
                entity.setConfirmLeader(user.getUsername());
                entity.setLeaderConfirmComment(request.getLeaderConfirmComment());
                entity.setLeaderConfirmTime(new Date());
                //更新设备保养状态
                eamEquipmentExtendService.updateEquipmentMaintenanceStatus(entity.getEquipmentId(), EquipmentMaintenanceStatus.NORMAL.name());
                break;
        }
        request.setValues(values);

        // å®Œæˆæµç¨‹ä»»åŠ¡
        Result result = flowTaskService.complete(request);
        if (!result.isSuccess()) {
            throw new JeecgBootException("审批失败，请刷新查看！");
        }
        //保存工单
        eamThirdMaintenanceOrderMapper.updateById(entity);
//        // èŽ·å–当前登录用户
//        LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
//        if (user == null || StrUtil.isBlank(user.getId())) {
//            throw new JeecgBootException("未获取到登录用户，请重新登录后再试！");
//        }
//        request.setAssignee(user.getUsername());
//        // èŽ·å–流程业务记录
//        FlowMyBusiness flowMyBusiness = flowMyBusinessService.getFlowMyBusiness(request.getInstanceId(), request.getTaskId());
//        if (flowMyBusiness == null) {
//            throw new JeecgBootException("流程实例不存在，请刷新后重试！");
//        }
//
//        boolean userAuthorized = isUserAuthorized(flowMyBusiness, user);
//        if (!userAuthorized) {
//            throw new JeecgBootException("用户无权操作此任务，请刷新后重试！");
//        }
//        // è®¤é¢†ä»»åŠ¡
//        if (!claimTask(flowMyBusiness.getTaskId(), user)) {
//            throw new JeecgBootException("任务不存在、已完成或已被他人认领！");
//        }
//
//        EamEquipment equipment = eamEquipmentService.getById(entity.getEquipmentId());
//        if (equipment == null) {
//            throw new JeecgBootException("设备不存在，请检查！");
//        }
//
//        ThirdMaintenanceStatusEnum status = ThirdMaintenanceStatusEnum.getInstance(entity.getMaintenanceStatus());
//        if (status == null) {
//            return null;
//        }
//        //流程变量
//        Map<String, Object> values = new HashMap<>();
//        List<String> userApprovalList;
//        List<UserSelector> userSelectors;
//        switch (status) {
//            case UNDER_MAINTENANCE:
//                boolean parallelCompletion = flowTaskService.checkParallelCompletion(flowMyBusiness.getTaskId());
//                //执行完成
//                userSelectors = sysUserService.selectOperatorList(equipment.getEquipmentCode(), null, BusinessCodeConst.PCR0006);
//                if (CollectionUtil.isEmpty(userSelectors)) {
//                    throw new JeecgBootException("设备未分配给车间班组长，无法进入下级审批！");
//                }
//                userApprovalList = userSelectors.stream().map(UserSelector::getUsername).collect(Collectors.toList());
//                values.put("dataId", entity.getId());
//                values.put("organization", "三保执行结束");
//                values.put("comment", "三保执行结束");
//                if (parallelCompletion) {
//                    values.put("NextAssignee", userApprovalList);
//                }
//                request.setComment("三保执行结束");
//                //设置entity
//                if (parallelCompletion) {
//                    entity.setMaintenanceStatus(ThirdMaintenanceStatusEnum.WAIT_CONFIRM.name());
//                    entity.setActualEndTime(new Date());
//                }
//                if ("maintenance_execution".equals(flowMyBusiness.getTaskNameId())) {
//                    //执行保养
//                    //处理附件
//                    if (CollectionUtil.isNotEmpty(request.getImageFilesResult())) {
//                        List<FileUploadResult> fileUploadResultList = request.getImageFilesResult();
//                        ObjectMapper mapper = new ObjectMapper();
//                        try {
//                            String referenceFile = mapper.writeValueAsString(fileUploadResultList);
//                            entity.setImageFiles(referenceFile);
//                        } catch (JsonProcessingException e) {
//                            log.error("JSON转换失败：" + e.getMessage(), e);
//                        }
//                    }
//                    //处理详情
//                    if (CollectionUtil.isNotEmpty(request.getTableDetailList())) {
//                        thirdMaintenanceOrderDetailService.updateBatchById(request.getTableDetailList());
//                    }
//                } else if ("precision_check".equals(flowMyBusiness.getTaskNameId())) {
//                    entity.setPrecisionChecker(user.getUsername());
//                    entity.setPrecisionCheckTime(new Date());
//                    //处理精度检验
//                    if (CollectionUtil.isNotEmpty(request.getPrecisionDetailList())) {
//                        precisionCheckDetailService.updateBatchById(request.getPrecisionDetailList());
//                    }
//                }
//                if (parallelCompletion) {
//                    //更新设备保养状态
//                    eamEquipmentExtendService.updateEquipmentMaintenanceStatus(entity.getEquipmentId(), EquipmentMaintenanceStatus.THIRD_MAINTENANCE_WAIT_CONFIRM.name());
//                }
//                break;
//            case WAIT_CONFIRM:
//                userSelectors = sysUserService.selectOperatorList(equipment.getEquipmentCode(),null, BusinessCodeConst.PCR0003);
//                if (CollectionUtil.isEmpty(userSelectors)) {
//                    throw new JeecgBootException("设备未分配给车间班组长，无法进入下级审批！");
//                }
//                //班组长确认
//                userApprovalList = userSelectors.stream().map(UserSelector::getUsername).collect(Collectors.toList());
//                values.put("dataId", entity.getId());
//                values.put("organization", request.getConfirmComment());
//                values.put("comment", request.getConfirmComment());
//                values.put("NextAssignee", userApprovalList);
//                values.put("confirmation", request.getConfirmDealType());
//                request.setComment(request.getConfirmComment());
//                //设置entity
//                entity.setMaintenanceStatus(ThirdMaintenanceStatusEnum.WAIT_LEADER_CONFIRM.name());
//                entity.setConfirmUser(user.getUsername());
//                entity.setConfirmComment(request.getConfirmComment());
//                entity.setConfirmTime(new Date());
//                //处理报修
//                List<EamThirdMaintenanceOrderDetail> collect = request.getTableDetailList().stream().filter((detail) -> CommonConstant.DEFAULT_1.equals(detail.getReportFlag())).collect(Collectors.toList());
//                if (CollectionUtil.isNotEmpty(collect)) {
//                    eamReportRepairService.reportRepairFromThirdMaintenance(equipment.getId(), entity.getOperator(), collect);
//                }
//                break;
//            case WAIT_LEADER_CONFIRM:
//                values.put("dataId", entity.getId());
//                values.put("organization", request.getLeaderConfirmComment());
//                values.put("comment", request.getLeaderConfirmComment());
//                request.setComment(request.getLeaderConfirmComment());
//                //设置entity
//                entity.setMaintenanceStatus(ThirdMaintenanceStatusEnum.COMPLETE.name());
//                entity.setConfirmLeader(user.getUsername());
//                entity.setLeaderConfirmComment(request.getLeaderConfirmComment());
//                entity.setLeaderConfirmTime(new Date());
//                //更新设备保养状态
//                eamEquipmentExtendService.updateEquipmentMaintenanceStatus(entity.getEquipmentId(), EquipmentMaintenanceStatus.NORMAL.name());
//                break;
//        }
//        request.setValues(values);
//
//        // å®Œæˆæµç¨‹ä»»åŠ¡
//        Result result = flowTaskService.complete(request);
//        if (!result.isSuccess()) {
//            throw new JeecgBootException("审批失败，请刷新查看！");
//        }
//        //保存工单
//        eamThirdMaintenanceOrderMapper.updateById(entity);
        return entity;
    }


 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamThirdMaintenanceSpareServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
package org.jeecg.modules.eam.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.jeecg.modules.eam.entity.EamThirdMaintenanceSpare;
import org.jeecg.modules.eam.mapper.EamThirdMaintenanceSpareMapper;
import org.jeecg.modules.eam.service.IEamThirdMaintenanceSpareService;
import org.springframework.stereotype.Service;

/**
 * @Description: ä¸‰ä¿å¤‡ä»¶æ˜Žç»†
 * @Author: jeecg-boot
 * @Date:   2025-07-11
 * @Version: V1.0
 */
@Service
public class EamThirdMaintenanceSpareServiceImpl extends ServiceImpl<EamThirdMaintenanceSpareMapper, EamThirdMaintenanceSpare> implements IEamThirdMaintenanceSpareService {

}