art: 数据库脚本、流程整理

zhangherong

5 天以前 a2380956b02019058445c71a8707efbf4b3d5e10

art: 数据库脚本、流程整理

 db/430É豸¹ÜÀíÊý¾Ý¿âÉè¼Æ.pdma.json

@@ -4,7 +4,7 @@
  "avatar": "",
  "version": "4.9.2",
  "createdTime": "2025-3-10 16:38:19",
  "updatedTime": "2025-7-17 19:49:48",
  "updatedTime": "2025-7-18 10:15:01",
  "dbConns": [],
  "profile": {
    "default": {
@@ -30278,24 +30278,6 @@
          "extProps": {},
          "domain": "73FD2BAD-2358-4336-B96D-45DC897BD792",
          "id": "589C45F0-0F8C-4497-8999-A8314DE5D601"
        },
        {
          "defKey": "order_id",
          "defName": "技术状态鉴定工单ID",
          "comment": "搬迁使用",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "16120F75-6AA7-4483-868D-F07F511BB081",
          "id": "153169DD-C196-48EC-B0B4-60626C830D64"
        }
      ],
      "correlations": [],
@@ -33216,4 +33198,4 @@
      "enable": true
    }
  ]
}
}

 db/ZHR/business_code_zhr.sql

@@ -1,3 +1,7 @@
--技术状态鉴定相关编码规则
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'1942396178475687937', N'admin', '2025-07-08 09:31:51.5660000', NULL, NULL, 0, N'技术状态鉴定规范编码规则', N'TechnicalStatusStandardCodeRule', N'TSES', N'yyyy', NULL, NULL, 4);
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'1943153060836503553', N'admin', '2025-07-10 11:39:26.4060000', NULL, NULL, 0, N'技术状态鉴定工单编码规则', N'TechnicalStatusEvaluationOrderCodeRule', N'TSEO', N'yyyy', NULL, NULL, 4);
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'1946025937108844545', N'admin', '2025-07-18 09:55:13.4730000', NULL, NULL, 0, N'技术状态鉴定工单变更编码规则', N'TechnicalStatusEvaluationOrderChangeCodeRule', N'TSEOC', N'yyyy', NULL, NULL, 4);
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'1946026069359443970', N'admin', '2025-07-18 09:55:45.0080000', NULL, NULL, 0, N'技术状态变更编码规则', N'TechnicalStatusChangeCodeRule', N'TSC', N'yyyy', NULL, NULL, 4);
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'1946026402634645506', N'admin', '2025-07-18 09:57:04.4710000', NULL, NULL, 0, N'技术状态鉴定申请编码规则', N'TechnicalStatusEvaluationApplyCodeRule', N'TSEA', N'yyyy', NULL, NULL, 4);
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'1946026519441817602', N'admin', '2025-07-18 09:57:32.3160000', NULL, NULL, 0, N'停用加工设备申请编码规则', N'TechnicalStatusDeactivateCodeRule', N'TSD', N'yyyy', NULL, NULL, 4);

 db/ZHR/create_table_zhr.sql

@@ -1049,89 +1049,247 @@


--技术状态鉴定工单变更
IF EXISTS (SELECT *
           FROM sys.objects
           WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order_change]')
             AND type in (N'U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_order_change];
CREATE TABLE [dbo].[eam_technical_status_evaluation_order_change]
(
    id                                NVARCHAR(32) NOT NULL,
    create_by                         NVARCHAR(50),
    create_time                       DATETIME2,
    update_by                         NVARCHAR(50),
    update_time                       DATETIME2,
    del_flag                          INT,
    order_id                          NVARCHAR(32),
    change_order_num                  NVARCHAR(100),
    applicant                         NVARCHAR(50),
    factory_org_code                  NVARCHAR(100),
    apply_date                        DATETIME2,
    change_status                     NVARCHAR(64),
    apply_reason                      NVARCHAR(64),
    deferred_maintenance_date         DATETIME2,
    equipment_manager_signature       NVARCHAR(50),
    equipment_manager_signature_time  DATETIME2,
    depart_manager_signature          NVARCHAR(50),
    depart_manager_signature_time     DATETIME2,
    depart_manager_comment            NVARCHAR(255),
    production_support_signature      NVARCHAR(50),
    production_support_signature_time DATETIME2,
    production_support_comment        NVARCHAR(255),
    hf_code                           NVARCHAR(100),
    PRIMARY KEY (id)
);
    [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,
    [order_id]                            nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
    [equipment_id]                        nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
    [change_order_num]                    nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [applicant]                           nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [factory_org_code]                    nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [apply_date]                          datetime2(7)                            NULL,
    [change_status]                       nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [apply_reason]                        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [deferred_evaluation_date]            datetime2(7)                            NULL,
    [equipment_manager_signature]         nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [equipment_manager_signature_time]    datetime2(7)                            NULL,
    [equipment_manager_signature_result]  nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [equipment_manager_comment]           nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [depart_manager_signature]            nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_manager_signature_time]       datetime2(7)                            NULL,
    [depart_manager_signature_result]     nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_manager_comment]              nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [production_support_signature]        nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [production_support_signature_time]   datetime2(7)                            NULL,
    [production_support_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [production_support_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_code]                             nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    CONSTRAINT [PK__eam_tech__3213E83FFE6D6178] 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]
)
    ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', '技术状态鉴定工单变更', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, null, null;
EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', create_by;
EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', create_time;
EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', update_by;
EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', update_time;
EXEC sp_addextendedproperty 'MS_Description', '删除标记', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', del_flag;
EXEC sp_addextendedproperty 'MS_Description', '工单ID', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', order_id;
EXEC sp_addextendedproperty 'MS_Description', '变更单号', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', change_order_num;
EXEC sp_addextendedproperty 'MS_Description', '申请人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', applicant;
EXEC sp_addextendedproperty 'MS_Description', '申请部门', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', factory_org_code;
EXEC sp_addextendedproperty 'MS_Description', '申请日期', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', apply_date;
EXEC sp_addextendedproperty 'MS_Description', '变更状态;待提交、待主管审核、待部门确认、待保障部确认、已作废、已完成',
     'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order_change, 'column', change_status;
EXEC sp_addextendedproperty 'MS_Description',
     '变更原因;生产任务急无法停机、设备故障正处于维修状态、设备已报废、设备大修、搬迁、改造', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', apply_reason;
EXEC sp_addextendedproperty 'MS_Description', '变更鉴定日期', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', deferred_maintenance_date;
EXEC sp_addextendedproperty 'MS_Description', '主管领导签字', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature;
EXEC sp_addextendedproperty 'MS_Description', '主管领导签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '部门领导签字;根据变更原因类型区分不同的人审批', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', depart_manager_signature;
EXEC sp_addextendedproperty 'MS_Description', '部门领导签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', depart_manager_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '部门领导意见', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', depart_manager_comment;
EXEC sp_addextendedproperty 'MS_Description', '生产保障部领导签字', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', production_support_signature;
EXEC sp_addextendedproperty 'MS_Description', '生产保障部领导签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', production_support_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '生产保障部领导意见', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', production_support_comment;
EXEC sp_addextendedproperty 'MS_Description', 'HF编码', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', hf_code;
ALTER TABLE [dbo].[eam_technical_status_evaluation_order_change]
    SET (LOCK_ESCALATION = TABLE)
GO

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

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

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

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

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

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

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

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

EXEC sp_addextendedproperty
     'MS_Description', N'变更单号',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'change_order_num'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'申请人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'applicant'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'申请部门',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'factory_org_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'申请日期',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'apply_date'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更状态;待提交、待主管审核、待部门确认、待保障部确认、已作废、已完成',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'change_status'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更原因;生产任务急无法停机、设备故障正处于维修状态、设备已报废、设备大修、搬迁、改造',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'apply_reason'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更鉴定日期',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'deferred_evaluation_date'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主管领导签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'equipment_manager_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主管领导签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'equipment_manager_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主管领导签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'equipment_manager_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主管领导意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'equipment_manager_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'部门领导签字;根据变更原因类型区分不同的人审批',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'depart_manager_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'部门领导签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'depart_manager_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'部门领导签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'depart_manager_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'部门领导意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'depart_manager_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'生产保障部领导签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'production_support_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'生产保障部领导签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'production_support_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'生产保障部领导签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'production_support_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'生产保障部领导意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'production_support_comment'
GO

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

EXEC sp_addextendedproperty
     'MS_Description', N'技术状态鉴定工单变更',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change'

--技术状态变更申请
IF EXISTS (SELECT *
@@ -1141,61 +1299,189 @@
    DROP TABLE [dbo].[eam_technical_status_change];
CREATE TABLE [dbo].[eam_technical_status_change]
(
    id                              NVARCHAR(32) NOT NULL,
    create_by                       NVARCHAR(50),
    create_time                     DATETIME2,
    update_by                       NVARCHAR(50),
    update_time                     DATETIME2,
    del_flag                        INT,
    change_order_num                NVARCHAR(100),
    change_status                   NVARCHAR(64),
    designer                        NVARCHAR(50),
    designer_time                   DATETIME2,
    depart_header_signature         NVARCHAR(50),
    depart_header_signature_time    DATETIME2,
    depart_header_signature_comment NVARCHAR(255),
    depart_leader_signature         NVARCHAR(50),
    depart_leader_signature_time    DATETIME2,
    depart_leader_signature_comment NVARCHAR(255),
    hf_code                         NVARCHAR(100),
    PRIMARY KEY (id)
);
    [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,
    [change_order_num]               nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [change_status]                  nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [factory_org_code]               nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [designer]                       nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [designer_time]                  datetime2(7)                            NULL,
    [depart_header_signature]        nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_header_signature_time]   datetime2(7)                            NULL,
    [depart_header_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_header_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [depart_leader_signature]        nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_leader_signature_time]   datetime2(7)                            NULL,
    [depart_leader_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_leader_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_code]                        nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [remark]                         nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    CONSTRAINT [PK__eam_tech__3213E83F5B1204F4] 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]
)
    ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', '技术状态变更申请', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     null, null;
EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     create_by;
EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     create_time;
EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     update_by;
EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     update_time;
EXEC sp_addextendedproperty 'MS_Description', '删除标记', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     del_flag;
EXEC sp_addextendedproperty 'MS_Description', '变更单号', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     change_order_num;
EXEC sp_addextendedproperty 'MS_Description', '变更单状态', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', change_status;
EXEC sp_addextendedproperty 'MS_Description', '编制人', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     designer;
EXEC sp_addextendedproperty 'MS_Description', '编制时间', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     designer_time;
EXEC sp_addextendedproperty 'MS_Description', '使用单位室主管签字', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', depart_header_signature;
EXEC sp_addextendedproperty 'MS_Description', '使用单位室主管签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_change, 'column', depart_header_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '使用单位室主管意见', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', depart_header_signature_comment;
EXEC sp_addextendedproperty 'MS_Description', '使用单位部主管签字', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', depart_leader_signature;
EXEC sp_addextendedproperty 'MS_Description', '使用单位部主管签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_change, 'column', depart_leader_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '使用单位部主管签字', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', depart_leader_signature_comment;
EXEC sp_addextendedproperty 'MS_Description', 'HF编码', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     hf_code;
ALTER TABLE [dbo].[eam_technical_status_change]
    SET (LOCK_ESCALATION = TABLE)
GO

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

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

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

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

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

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

EXEC sp_addextendedproperty
     'MS_Description', N'变更单号',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'change_order_num'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更单状态',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'change_status'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'申请单位',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'factory_org_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'编制人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'designer'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'编制时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'designer_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位室级主管签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_header_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位室级主管签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_header_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位室级主管签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_header_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位室级主管意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_header_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位部级主管签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_leader_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位部级主管签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_leader_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位部级主管签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_leader_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位部级主管签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_leader_comment'
GO

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

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

EXEC sp_addextendedproperty
     'MS_Description', N'技术状态变更申请',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change'


--技术状态变更申请明细

 db/ZHR/process/Í£Óüӹ¤É豸ÉêÇë.bpmn20.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef">
  <process id="technical_status_deactivate_process" name="停用加工设备申请" flowable:processCategory="TECHNICAL_STATUS_DEACTIVATE_PROCESS">
    <startEvent id="startNode1" name="开始">
      <outgoing>Flow_0yfurvp</outgoing>
    </startEvent>
    <sequenceFlow id="Flow_0yfurvp" name="提交" sourceRef="startNode1" targetRef="Activity_02hq39f" />
    <userTask id="Activity_02hq39f" name="申请提交">
      <incoming>Flow_0yfurvp</incoming>
      <outgoing>Flow_06c497o</outgoing>
    </userTask>
    <sequenceFlow id="Flow_06c497o" name="提交完成" sourceRef="Activity_02hq39f" targetRef="Activity_1aymxw6" />
    <userTask id="Activity_1aymxw6" name="使用单位室级主管审批">
      <incoming>Flow_06c497o</incoming>
      <outgoing>Flow_07sm00g</outgoing>
      <outgoing>Flow_1y4h64d</outgoing>
    </userTask>
    <sequenceFlow id="Flow_07sm00g" name="通过" sourceRef="Activity_1aymxw6" targetRef="Activity_1abilq7">
      <conditionExpression xsi:type="tFormalExpression">${departHeaderConfrimFlag == 1}</conditionExpression>
    </sequenceFlow>
    <userTask id="Activity_1abilq7" name="使用单位部级主管审批">
      <incoming>Flow_07sm00g</incoming>
      <outgoing>Flow_16q19a6</outgoing>
    </userTask>
    <endEvent id="Event_0w00roh">
      <incoming>Flow_16q19a6</incoming>
    </endEvent>
    <sequenceFlow id="Flow_16q19a6" name="通过或驳回" sourceRef="Activity_1abilq7" targetRef="Event_0w00roh" />
    <endEvent id="Event_057c1tu">
      <incoming>Flow_1y4h64d</incoming>
    </endEvent>
    <sequenceFlow id="Flow_1y4h64d" name="驳回" sourceRef="Activity_1aymxw6" targetRef="Event_057c1tu">
      <conditionExpression xsi:type="tFormalExpression">${departHeaderConfrimFlag == 2}</conditionExpression>
    </sequenceFlow>
  </process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_flow">
    <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="technical_status_deactivate_process">
      <bpmndi:BPMNEdge id="Flow_1y4h64d_di" bpmnElement="Flow_1y4h64d">
        <di:waypoint x="310" y="340" />
        <di:waypoint x="372" y="340" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="330" y="322" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_16q19a6_di" bpmnElement="Flow_16q19a6">
        <di:waypoint x="260" y="520" />
        <di:waypoint x="260" y="592" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="192" y="554" width="56" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_07sm00g_di" bpmnElement="Flow_07sm00g">
        <di:waypoint x="260" y="380" />
        <di:waypoint x="260" y="440" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="228" y="407" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_06c497o_di" bpmnElement="Flow_06c497o">
        <di:waypoint x="260" y="240" />
        <di:waypoint x="260" y="300" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="207" y="266" width="45" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0yfurvp_di" bpmnElement="Flow_0yfurvp">
        <di:waypoint x="260" y="115" />
        <di:waypoint x="260" y="160" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="228" y="135" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke="">
        <omgdc:Bounds x="245" y="85" width="30" height="30" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="248" y="63" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_0d1w8ij_di" bpmnElement="Activity_02hq39f">
        <omgdc:Bounds x="210" y="160" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1fbagra_di" bpmnElement="Activity_1aymxw6">
        <omgdc:Bounds x="210" y="300" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_144fdht_di" bpmnElement="Activity_1abilq7">
        <omgdc:Bounds x="210" y="440" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_0w00roh_di" bpmnElement="Event_0w00roh">
        <omgdc:Bounds x="242" y="592" width="36" height="36" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_057c1tu_di" bpmnElement="Event_057c1tu">
        <omgdc:Bounds x="372" y="322" width="36" height="36" />
      </bpmndi:BPMNShape>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</definitions>

 db/ZHR/process/¼¼Êõ״̬±ä¸üÉêÇëÁ÷³Ì.bpmn20.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef">
  <process id="technical_status_change_process" name="技术状态变更申请流程" flowable:processCategory="TECHNICAL_STATUS_CHANGE_PROCESS">
    <startEvent id="startNode1" name="开始">
      <outgoing>Flow_1a5561e</outgoing>
    </startEvent>
    <sequenceFlow id="Flow_1a5561e" sourceRef="startNode1" targetRef="Activity_0vjpbto" />
    <userTask id="Activity_0vjpbto" name="变更提交">
      <incoming>Flow_1a5561e</incoming>
      <outgoing>Flow_049516g</outgoing>
    </userTask>
    <sequenceFlow id="Flow_049516g" name="提交完成" sourceRef="Activity_0vjpbto" targetRef="Activity_13y6uei" />
    <userTask id="Activity_13y6uei" name="使用单位室级领导审核">
      <incoming>Flow_049516g</incoming>
      <outgoing>Flow_1p7phbk</outgoing>
      <outgoing>Flow_0kncgmv</outgoing>
    </userTask>
    <userTask id="Activity_00rff81" name="使用单位部级领导审核">
      <incoming>Flow_1p7phbk</incoming>
      <outgoing>Flow_09781az</outgoing>
    </userTask>
    <sequenceFlow id="Flow_1p7phbk" name="通过" sourceRef="Activity_13y6uei" targetRef="Activity_00rff81">
      <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 1}</conditionExpression>
    </sequenceFlow>
    <endEvent id="Event_0jo3kio">
      <incoming>Flow_0kncgmv</incoming>
    </endEvent>
    <sequenceFlow id="Flow_0kncgmv" name="驳回" sourceRef="Activity_13y6uei" targetRef="Event_0jo3kio">
      <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 2}</conditionExpression>
    </sequenceFlow>
    <endEvent id="Event_1nq08yu" name="">
      <incoming>Flow_09781az</incoming>
    </endEvent>
    <sequenceFlow id="Flow_09781az" name="通过或驳回" sourceRef="Activity_00rff81" targetRef="Event_1nq08yu" />
  </process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_flow">
    <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="technical_status_change_process">
      <bpmndi:BPMNEdge id="Flow_09781az_di" bpmnElement="Flow_09781az">
        <di:waypoint x="150" y="350" />
        <di:waypoint x="150" y="402" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="162" y="371" width="56" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0kncgmv_di" bpmnElement="Flow_0kncgmv">
        <di:waypoint x="200" y="170" />
        <di:waypoint x="292" y="170" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="228" y="152" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1p7phbk_di" bpmnElement="Flow_1p7phbk">
        <di:waypoint x="150" y="210" />
        <di:waypoint x="150" y="270" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="154" y="236" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_049516g_di" bpmnElement="Flow_049516g">
        <di:waypoint x="150" y="70" />
        <di:waypoint x="150" y="130" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="157" y="96" width="45" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1a5561e_di" bpmnElement="Flow_1a5561e">
        <di:waypoint x="150" y="-65" />
        <di:waypoint x="150" y="-10" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke="">
        <omgdc:Bounds x="135" y="-95" width="30" height="30" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="138" y="-117" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1kksbkh_di" bpmnElement="Activity_0vjpbto">
        <omgdc:Bounds x="100" y="-10" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1nkn08l_di" bpmnElement="Activity_13y6uei">
        <omgdc:Bounds x="100" y="130" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_018xpql_di" bpmnElement="Activity_00rff81">
        <omgdc:Bounds x="100" y="270" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_0jo3kio_di" bpmnElement="Event_0jo3kio">
        <omgdc:Bounds x="292" y="152" width="36" height="36" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_1nq08yu_di" bpmnElement="Event_1nq08yu">
        <omgdc:Bounds x="132" y="402" width="36" height="36" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="145" y="525" width="12" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNShape>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</definitions>

 db/ZHR/process/¼¼Êõ״̬¼ø¶¨¹¤µ¥±ä¸üÁ÷³Ì.bpmn20.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,130 @@
<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef">
  <process id="evaluation_order_change_process" name="技术状态鉴定工单变更流程" flowable:processCategory="EVALUATION_ORDER_CHANGE_PROCESS">
    <startEvent id="startNode1" name="开始">
      <outgoing>Flow_1lrjfyh</outgoing>
    </startEvent>
    <userTask id="Activity_0xr313b" name="提交变更">
      <incoming>Flow_1lrjfyh</incoming>
      <outgoing>Flow_0rs715w</outgoing>
    </userTask>
    <sequenceFlow id="Flow_0rs715w" name="提交完成" sourceRef="Activity_0xr313b" targetRef="Activity_0o3p1rw" />
    <sequenceFlow id="Flow_1lrjfyh" name="" sourceRef="startNode1" targetRef="Activity_0xr313b" />
    <endEvent id="Event_1ljzz5l">
      <incoming>Flow_03s2kfi</incoming>
    </endEvent>
    <sequenceFlow id="Flow_03s2kfi" name="驳回" sourceRef="Activity_0o3p1rw" targetRef="Event_1ljzz5l">
      <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 2 }</conditionExpression>
    </sequenceFlow>
    <userTask id="Activity_0o3p1rw" name="使用单位室级领导审核">
      <incoming>Flow_0rs715w</incoming>
      <outgoing>Flow_03s2kfi</outgoing>
      <outgoing>Flow_1bl4oj1</outgoing>
    </userTask>
    <endEvent id="Event_094wrnm">
      <incoming>Flow_0glq4rb</incoming>
    </endEvent>
    <userTask id="Activity_0e2mtnc" name="部门领导审核">
      <incoming>Flow_1bl4oj1</incoming>
      <outgoing>Flow_1rtxiqx</outgoing>
      <outgoing>Flow_0glq4rb</outgoing>
    </userTask>
    <sequenceFlow id="Flow_1bl4oj1" name="通过" sourceRef="Activity_0o3p1rw" targetRef="Activity_0e2mtnc">
      <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 1 }</conditionExpression>
    </sequenceFlow>
    <userTask id="Activity_1ugagrs" name="生产保障部领导审核">
      <incoming>Flow_1rtxiqx</incoming>
      <outgoing>Flow_1qk08w9</outgoing>
    </userTask>
    <sequenceFlow id="Flow_1rtxiqx" name="通过" sourceRef="Activity_0e2mtnc" targetRef="Activity_1ugagrs">
      <conditionExpression xsi:type="tFormalExpression">${departLeaderConfirmFlag == 1}</conditionExpression>
    </sequenceFlow>
    <endEvent id="Event_1byavvu">
      <incoming>Flow_1qk08w9</incoming>
    </endEvent>
    <sequenceFlow id="Flow_1qk08w9" name="通过或驳回" sourceRef="Activity_1ugagrs" targetRef="Event_1byavvu" />
    <sequenceFlow id="Flow_0glq4rb" name="驳回" sourceRef="Activity_0e2mtnc" targetRef="Event_094wrnm">
      <conditionExpression xsi:type="tFormalExpression">${departLeaderConfirmFlag == 2}</conditionExpression>
    </sequenceFlow>
  </process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_flow">
    <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="evaluation_order_change_process">
      <bpmndi:BPMNEdge id="Flow_0glq4rb_di" bpmnElement="Flow_0glq4rb">
        <di:waypoint x="340" y="360" />
        <di:waypoint x="340" y="288" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="344" y="321" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1qk08w9_di" bpmnElement="Flow_1qk08w9">
        <di:waypoint x="570" y="400" />
        <di:waypoint x="662" y="400" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="582" y="382" width="56" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1rtxiqx_di" bpmnElement="Flow_1rtxiqx">
        <di:waypoint x="390" y="400" />
        <di:waypoint x="470" y="400" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="418" y="382" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1bl4oj1_di" bpmnElement="Flow_1bl4oj1">
        <di:waypoint x="220" y="400" />
        <di:waypoint x="290" y="400" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="244" y="382" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_03s2kfi_di" bpmnElement="Flow_03s2kfi">
        <di:waypoint x="170" y="440" />
        <di:waypoint x="170" y="492" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="174" y="463" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1lrjfyh_di" bpmnElement="Flow_1lrjfyh">
        <di:waypoint x="170" y="135" />
        <di:waypoint x="170" y="200" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="180" y="153" width="11" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0rs715w_di" bpmnElement="Flow_0rs715w">
        <di:waypoint x="170" y="280" />
        <di:waypoint x="170" y="360" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="117" y="317" width="45" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke="">
        <omgdc:Bounds x="155" y="105" width="30" height="30" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="158" y="81" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1f3p44a_di" bpmnElement="Activity_0xr313b">
        <omgdc:Bounds x="120" y="200" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_1ljzz5l_di" bpmnElement="Event_1ljzz5l">
        <omgdc:Bounds x="152" y="492" width="36" height="36" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_0vfhldg_di" bpmnElement="Activity_0o3p1rw">
        <omgdc:Bounds x="120" y="360" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_094wrnm_di" bpmnElement="Event_094wrnm">
        <omgdc:Bounds x="322" y="252" width="36" height="36" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1iibt8n_di" bpmnElement="Activity_0e2mtnc">
        <omgdc:Bounds x="290" y="360" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_17vz2zb_di" bpmnElement="Activity_1ugagrs">
        <omgdc:Bounds x="470" y="360" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_1byavvu_di" bpmnElement="Event_1byavvu">
        <omgdc:Bounds x="662" y="382" width="36" height="36" />
      </bpmndi:BPMNShape>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</definitions>

 db/ZHR/process/¼¼Êõ״̬¼ø¶¨Á÷³Ì.bpmn20.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,342 @@
<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef">
  <process id="technical_status_evaluation_process" name="技术状态鉴定流程" flowable:processCategory="TECHNICAL_STATUS_EVALUATION">
    <startEvent id="startNode1" name="开始">
      <outgoing>Flow_08kar5y</outgoing>
    </startEvent>
    <sequenceFlow id="Flow_08kar5y" name="领取" sourceRef="startNode1" targetRef="Activity_1nstx24" />
    <inclusiveGateway id="Gateway_0t8e1ct">
      <incoming>Flow_14ezqsp</incoming>
      <outgoing>Flow_1aeofia</outgoing>
      <outgoing>Flow_0qu8c97</outgoing>
      <outgoing>Flow_0j0xozz</outgoing>
    </inclusiveGateway>
    <sequenceFlow id="Flow_14ezqsp" name="分配候选人" sourceRef="Activity_1nstx24" targetRef="Gateway_0t8e1ct" />
    <sequenceFlow id="Flow_1aeofia" name="存在安全装置检查项" sourceRef="Gateway_0t8e1ct" targetRef="safety_equipment_check">
      <conditionExpression xsi:type="tFormalExpression">${hasSafetyEquipmentCheck == 1}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_0qu8c97" name="存在设备精度检查项" sourceRef="Gateway_0t8e1ct" targetRef="equipment_precision_check">
      <conditionExpression xsi:type="tFormalExpression">${hasPrecisionCheck == 1}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_0j0xozz" name="存在其他检查项" sourceRef="Gateway_0t8e1ct" targetRef="other_check">
      <conditionExpression xsi:type="tFormalExpression">${hasOtherCheck == 1}</conditionExpression>
    </sequenceFlow>
    <userTask id="Activity_1nstx24" name="工单领取">
      <incoming>Flow_08kar5y</incoming>
      <outgoing>Flow_14ezqsp</outgoing>
    </userTask>
    <userTask id="safety_equipment_check" name="安全装置检查">
      <incoming>Flow_1aeofia</incoming>
      <incoming>Flow_17a4vks</incoming>
      <outgoing>Flow_1b2jdti</outgoing>
    </userTask>
    <userTask id="equipment_precision_check" name="设备精度检查">
      <incoming>Flow_0qu8c97</incoming>
      <incoming>Flow_10sx1x8</incoming>
      <outgoing>Flow_0etgxyr</outgoing>
    </userTask>
    <userTask id="other_check" name="其他检查">
      <incoming>Flow_0j0xozz</incoming>
      <incoming>Flow_0qmhfoe</incoming>
      <outgoing>Flow_0x0nou7</outgoing>
    </userTask>
    <inclusiveGateway id="Gateway_05inlwj">
      <incoming>Flow_0ce2jd6</incoming>
      <incoming>Flow_1830g31</incoming>
      <incoming>Flow_14d65ly</incoming>
      <outgoing>Flow_0gawkvp</outgoing>
    </inclusiveGateway>
    <userTask id="Activity_0vx3umo" name="维修室主任签字">
      <incoming>Flow_1r37r0q</incoming>
      <outgoing>Flow_0l049xa</outgoing>
      <outgoing>Flow_0iqfkbu</outgoing>
    </userTask>
    <userTask id="Activity_1o9pk5t" name="工艺员签字">
      <incoming>Flow_0iqfkbu</incoming>
      <incoming>Flow_0iu1nap</incoming>
      <outgoing>Flow_1d2uh4m</outgoing>
    </userTask>
    <userTask id="Activity_1ebqzed" name="使用单位技术主管签字">
      <incoming>Flow_1d2uh4m</incoming>
      <outgoing>Flow_0k09keo</outgoing>
      <outgoing>Flow_0iu1nap</outgoing>
    </userTask>
    <userTask id="Activity_0yigfu5" name="设备检查员签字">
      <incoming>Flow_0k09keo</incoming>
      <outgoing>Flow_01nyfzi</outgoing>
    </userTask>
    <endEvent id="Event_1lkemxs">
      <incoming>Flow_01nyfzi</incoming>
    </endEvent>
    <sequenceFlow id="Flow_1b2jdti" name="检查完成" sourceRef="safety_equipment_check" targetRef="safety_equipment_check_confirm" />
    <sequenceFlow id="Flow_0etgxyr" name="检查完成" sourceRef="equipment_precision_check" targetRef="equipment_precision_check_confirm" />
    <sequenceFlow id="Flow_0x0nou7" name="检查完成" sourceRef="other_check" targetRef="other_check_confirm" />
    <userTask id="safety_equipment_check_confirm" name="维修室主任签字">
      <incoming>Flow_1b2jdti</incoming>
      <outgoing>Flow_0ce2jd6</outgoing>
      <outgoing>Flow_17a4vks</outgoing>
    </userTask>
    <userTask id="equipment_precision_check_confirm" name="维修室主任签字">
      <incoming>Flow_0etgxyr</incoming>
      <outgoing>Flow_1830g31</outgoing>
      <outgoing>Flow_10sx1x8</outgoing>
    </userTask>
    <userTask id="other_check_confirm" name="维修室主任签字">
      <incoming>Flow_0x0nou7</incoming>
      <outgoing>Flow_14d65ly</outgoing>
      <outgoing>Flow_0qmhfoe</outgoing>
    </userTask>
    <sequenceFlow id="Flow_0ce2jd6" name="通过" sourceRef="safety_equipment_check_confirm" targetRef="Gateway_05inlwj">
      <conditionExpression xsi:type="tFormalExpression">${safetyEquipmentCheckFlag == 1}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_1830g31" name="通过" sourceRef="equipment_precision_check_confirm" targetRef="Gateway_05inlwj">
      <conditionExpression xsi:type="tFormalExpression">${precisionCheckFlag == 1}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_14d65ly" name="通过" sourceRef="other_check_confirm" targetRef="Gateway_05inlwj">
      <conditionExpression xsi:type="tFormalExpression">${otherCheckFlag == 1}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_17a4vks" name="驳回" sourceRef="safety_equipment_check_confirm" targetRef="safety_equipment_check">
      <conditionExpression xsi:type="tFormalExpression">${safetyEquipmentCheckFlag == 2}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_10sx1x8" name="驳回" sourceRef="equipment_precision_check_confirm" targetRef="equipment_precision_check">
      <conditionExpression xsi:type="tFormalExpression">${precisionCheckFlag == 2}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_0qmhfoe" name="驳回" sourceRef="other_check_confirm" targetRef="other_check">
      <conditionExpression xsi:type="tFormalExpression">${otherCheckFlag == 2}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_0gawkvp" name="通过" sourceRef="Gateway_05inlwj" targetRef="Activity_0w2esvf" />
    <sequenceFlow id="Flow_1r37r0q" name="通过" sourceRef="Activity_0w2esvf" targetRef="Activity_0vx3umo" />
    <sequenceFlow id="Flow_0l049xa" name="驳回" sourceRef="Activity_0vx3umo" targetRef="Activity_0w2esvf">
      <conditionExpression xsi:type="tFormalExpression">${repairManagerApprovalFlag == 2}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_0iqfkbu" name="通过" sourceRef="Activity_0vx3umo" targetRef="Activity_1o9pk5t">
      <conditionExpression xsi:type="tFormalExpression">${repairManagerApprovalFlag == 1}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_1d2uh4m" name="通过" sourceRef="Activity_1o9pk5t" targetRef="Activity_1ebqzed" />
    <sequenceFlow id="Flow_0k09keo" name="通过" sourceRef="Activity_1ebqzed" targetRef="Activity_0yigfu5">
      <conditionExpression xsi:type="tFormalExpression">${technicalLeaderApprovalFlag == 1}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_01nyfzi" name="通过" sourceRef="Activity_0yigfu5" targetRef="Event_1lkemxs" />
    <sequenceFlow id="Flow_0iu1nap" name="驳回" sourceRef="Activity_1ebqzed" targetRef="Activity_1o9pk5t">
      <conditionExpression xsi:type="tFormalExpression">${technicalLeaderApprovalFlag == 2}</conditionExpression>
    </sequenceFlow>
    <userTask id="Activity_0w2esvf" name="维修人员签字">
      <incoming>Flow_0gawkvp</incoming>
      <incoming>Flow_0l049xa</incoming>
      <outgoing>Flow_1r37r0q</outgoing>
    </userTask>
  </process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_flow">
    <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="technical_status_evaluation_process">
      <bpmndi:BPMNEdge id="Flow_0iu1nap_di" bpmnElement="Flow_0iu1nap">
        <di:waypoint x="730" y="400" />
        <di:waypoint x="800" y="400" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="756" y="403" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_01nyfzi_di" bpmnElement="Flow_01nyfzi">
        <di:waypoint x="460" y="380" />
        <di:waypoint x="378" y="380" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="408" y="362" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0k09keo_di" bpmnElement="Flow_0k09keo">
        <di:waypoint x="630" y="380" />
        <di:waypoint x="560" y="380" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="584" y="362" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1d2uh4m_di" bpmnElement="Flow_1d2uh4m">
        <di:waypoint x="800" y="360" />
        <di:waypoint x="730" y="360" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="754" y="342" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0iqfkbu_di" bpmnElement="Flow_0iqfkbu">
        <di:waypoint x="850" y="280" />
        <di:waypoint x="850" y="340" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="854" y="303" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0l049xa_di" bpmnElement="Flow_0l049xa">
        <di:waypoint x="880" y="200" />
        <di:waypoint x="880" y="140" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="888" y="167" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1r37r0q_di" bpmnElement="Flow_1r37r0q">
        <di:waypoint x="840" y="140" />
        <di:waypoint x="840" y="200" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="808" y="167" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0gawkvp_di" bpmnElement="Flow_0gawkvp">
        <di:waypoint x="735" y="100" />
        <di:waypoint x="800" y="100" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="756" y="82" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0qmhfoe_di" bpmnElement="Flow_0qmhfoe">
        <di:waypoint x="510" y="220" />
        <di:waypoint x="430" y="220" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="459" y="223" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_10sx1x8_di" bpmnElement="Flow_10sx1x8">
        <di:waypoint x="510" y="120" />
        <di:waypoint x="430" y="120" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="459" y="122" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_17a4vks_di" bpmnElement="Flow_17a4vks">
        <di:waypoint x="510" y="20" />
        <di:waypoint x="430" y="20" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="459" y="23" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_14d65ly_di" bpmnElement="Flow_14d65ly">
        <di:waypoint x="610" y="200" />
        <di:waypoint x="710" y="200" />
        <di:waypoint x="710" y="125" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="649" y="182" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1830g31_di" bpmnElement="Flow_1830g31">
        <di:waypoint x="610" y="100" />
        <di:waypoint x="685" y="100" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="636" y="82" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0ce2jd6_di" bpmnElement="Flow_0ce2jd6">
        <di:waypoint x="610" y="0" />
        <di:waypoint x="710" y="0" />
        <di:waypoint x="710" y="75" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="649" y="-18" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0x0nou7_di" bpmnElement="Flow_0x0nou7">
        <di:waypoint x="430" y="200" />
        <di:waypoint x="510" y="200" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="448" y="182" width="45" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0etgxyr_di" bpmnElement="Flow_0etgxyr">
        <di:waypoint x="430" y="100" />
        <di:waypoint x="510" y="100" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="448" y="82" width="45" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1b2jdti_di" bpmnElement="Flow_1b2jdti">
        <di:waypoint x="430" y="0" />
        <di:waypoint x="510" y="0" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="448" y="-18" width="45" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0j0xozz_di" bpmnElement="Flow_0j0xozz">
        <di:waypoint x="240" y="125" />
        <di:waypoint x="240" y="200" />
        <di:waypoint x="330" y="200" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="241" y="183" width="78" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0qu8c97_di" bpmnElement="Flow_0qu8c97">
        <di:waypoint x="265" y="100" />
        <di:waypoint x="330" y="100" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="251" y="66" width="78" height="27" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1aeofia_di" bpmnElement="Flow_1aeofia">
        <di:waypoint x="240" y="75" />
        <di:waypoint x="240" y="0" />
        <di:waypoint x="330" y="0" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="241" y="-34" width="78" height="27" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_14ezqsp_di" bpmnElement="Flow_14ezqsp">
        <di:waypoint x="120" y="100" />
        <di:waypoint x="215" y="100" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="140" y="82" width="56" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_08kar5y_di" bpmnElement="Flow_08kar5y">
        <di:waypoint x="-45" y="100" />
        <di:waypoint x="20" y="100" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="-24" y="82" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke="">
        <omgdc:Bounds x="-75" y="85" width="30" height="30" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="-73" y="122" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Gateway_0n5p3kz_di" bpmnElement="Gateway_0t8e1ct">
        <omgdc:Bounds x="215" y="75" width="50" height="50" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_15ga6fi_di" bpmnElement="Activity_1nstx24">
        <omgdc:Bounds x="20" y="60" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1axd1mf_di" bpmnElement="safety_equipment_check">
        <omgdc:Bounds x="330" y="-40" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_09f2psv_di" bpmnElement="equipment_precision_check">
        <omgdc:Bounds x="330" y="60" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_0hka9ht_di" bpmnElement="other_check">
        <omgdc:Bounds x="330" y="160" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Gateway_1yf4krn_di" bpmnElement="Gateway_05inlwj">
        <omgdc:Bounds x="685" y="75" width="50" height="50" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_0jqk7kf_di" bpmnElement="Activity_0vx3umo">
        <omgdc:Bounds x="800" y="200" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1utlj8v_di" bpmnElement="Activity_1o9pk5t">
        <omgdc:Bounds x="800" y="340" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_093o9g6_di" bpmnElement="Activity_1ebqzed">
        <omgdc:Bounds x="630" y="340" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1pq8o9r_di" bpmnElement="Activity_0yigfu5">
        <omgdc:Bounds x="460" y="340" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_1lkemxs_di" bpmnElement="Event_1lkemxs">
        <omgdc:Bounds x="342" y="362" width="36" height="36" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_11446n6_di" bpmnElement="safety_equipment_check_confirm">
        <omgdc:Bounds x="510" y="-40" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1yeaht6_di" bpmnElement="equipment_precision_check_confirm">
        <omgdc:Bounds x="510" y="60" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_10ic56v_di" bpmnElement="other_check_confirm">
        <omgdc:Bounds x="510" y="160" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_0o51wl1_di" bpmnElement="Activity_0w2esvf">
        <omgdc:Bounds x="800" y="60" width="100" height="80" />
      </bpmndi:BPMNShape>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</definitions>

 db/ZHR/process/¼¼Êõ״̬¼ø¶¨ÉêÇëÁ÷³Ì.bpmn20.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,130 @@
<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef">
  <process id="technical_status_evaluation_apply_process" name="技术状态鉴定申请流程" flowable:processCategory="TECHNICAL_STATUS_EVALUATION_APPLY_PROCESS">
    <startEvent id="startNode1" name="开始">
      <outgoing>Flow_047mezk</outgoing>
    </startEvent>
    <sequenceFlow id="Flow_047mezk" name="提交" sourceRef="startNode1" targetRef="Activity_0phqw21" />
    <userTask id="Activity_0phqw21" name="申请提交">
      <incoming>Flow_047mezk</incoming>
      <outgoing>Flow_11nxzgi</outgoing>
    </userTask>
    <userTask id="Activity_1b9d829" name="申请单位室级领导审批">
      <incoming>Flow_11nxzgi</incoming>
      <outgoing>Flow_0b42mpn</outgoing>
      <outgoing>Flow_09iuey6</outgoing>
    </userTask>
    <sequenceFlow id="Flow_11nxzgi" name="提交完成" sourceRef="Activity_0phqw21" targetRef="Activity_1b9d829" />
    <sequenceFlow id="Flow_0b42mpn" name="通过" sourceRef="Activity_1b9d829" targetRef="Activity_0s463r9">
      <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 1}</conditionExpression>
    </sequenceFlow>
    <sequenceFlow id="Flow_1gcy86s" name="通过" sourceRef="Activity_0s463r9" targetRef="Activity_1c09htz">
      <conditionExpression xsi:type="tFormalExpression">${productionHeaderConfirmFlag == 1}</conditionExpression>
    </sequenceFlow>
    <endEvent id="Event_0d71i5o">
      <incoming>Flow_1q3g8eo</incoming>
    </endEvent>
    <userTask id="Activity_1c09htz" name="生产保障部领导审批">
      <incoming>Flow_1gcy86s</incoming>
      <outgoing>Flow_1q3g8eo</outgoing>
    </userTask>
    <userTask id="Activity_0s463r9" name="生产设备管理主管审批">
      <incoming>Flow_0b42mpn</incoming>
      <outgoing>Flow_1gcy86s</outgoing>
      <outgoing>Flow_1wzlz4a</outgoing>
    </userTask>
    <sequenceFlow id="Flow_1q3g8eo" name="通过或驳回" sourceRef="Activity_1c09htz" targetRef="Event_0d71i5o" />
    <endEvent id="Event_0qjd1ay">
      <incoming>Flow_1wzlz4a</incoming>
    </endEvent>
    <sequenceFlow id="Flow_1wzlz4a" name="驳回" sourceRef="Activity_0s463r9" targetRef="Event_0qjd1ay">
      <conditionExpression xsi:type="tFormalExpression">${productionHeaderConfirmFlag == 2}</conditionExpression>
    </sequenceFlow>
    <endEvent id="Event_14kz3sw">
      <incoming>Flow_09iuey6</incoming>
    </endEvent>
    <sequenceFlow id="Flow_09iuey6" name="驳回" sourceRef="Activity_1b9d829" targetRef="Event_14kz3sw">
      <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 2}</conditionExpression>
    </sequenceFlow>
  </process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_flow">
    <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="technical_status_evaluation_apply_process">
      <bpmndi:BPMNEdge id="Flow_09iuey6_di" bpmnElement="Flow_09iuey6">
        <di:waypoint x="260" y="320" />
        <di:waypoint x="332" y="320" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="285" y="302" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1wzlz4a_di" bpmnElement="Flow_1wzlz4a">
        <di:waypoint x="260" y="460" />
        <di:waypoint x="332" y="460" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="285" y="442" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1q3g8eo_di" bpmnElement="Flow_1q3g8eo">
        <di:waypoint x="210" y="650" />
        <di:waypoint x="210" y="702" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="152" y="673" width="56" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1gcy86s_di" bpmnElement="Flow_1gcy86s">
        <di:waypoint x="210" y="500" />
        <di:waypoint x="210" y="570" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="178" y="532" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0b42mpn_di" bpmnElement="Flow_0b42mpn">
        <di:waypoint x="210" y="360" />
        <di:waypoint x="210" y="420" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="178" y="387" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_11nxzgi_di" bpmnElement="Flow_11nxzgi">
        <di:waypoint x="210" y="220" />
        <di:waypoint x="210" y="280" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="157" y="247" width="45" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_047mezk_di" bpmnElement="Flow_047mezk">
        <di:waypoint x="210" y="75" />
        <di:waypoint x="210" y="140" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="178" y="93" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke="">
        <omgdc:Bounds x="195" y="45" width="30" height="30" />
        <bpmndi:BPMNLabel>
          <omgdc:Bounds x="198" y="23" width="23" height="14" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_0kpg64e_di" bpmnElement="Activity_0phqw21">
        <omgdc:Bounds x="160" y="140" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1xg7mgb_di" bpmnElement="Activity_1b9d829">
        <omgdc:Bounds x="160" y="280" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_0d71i5o_di" bpmnElement="Event_0d71i5o">
        <omgdc:Bounds x="192" y="702" width="36" height="36" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_1eozmdz_di" bpmnElement="Activity_1c09htz">
        <omgdc:Bounds x="160" y="570" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_0cax4o1_di" bpmnElement="Activity_0s463r9">
        <omgdc:Bounds x="160" y="420" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_0qjd1ay_di" bpmnElement="Event_0qjd1ay">
        <omgdc:Bounds x="332" y="442" width="36" height="36" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_14kz3sw_di" bpmnElement="Event_14kz3sw">
        <omgdc:Bounds x="332" y="302" width="36" height="36" />
      </bpmndi:BPMNShape>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</definitions>

 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/BusinessCodeConst.java

@@ -35,7 +35,7 @@
    String TECHNICAL_STATUS_EVALUATION_ORDER_CHANGE_CODE_RULE = "TechnicalStatusEvaluationOrderChangeCodeRule";
    //技术状态变更编码规则
    String TECHNICAL_STATUS_CHANGE_CODE_RULE = "TechnicalStatusChangeCodeRule";
    //技术状态变更编码规则
    //技术状态鉴定申请编码规则
    String TECHNICAL_STATUS_EVALUATION_APPLY_CODE_RULE = "TechnicalStatusEvaluationApplyCodeRule";
    //停用加工设备申请编码规则
    String TECHNICAL_STATUS_DEACTIVATE_CODE_RULE = "TechnicalStatusDeactivateCodeRule";

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

@@ -65,9 +65,6 @@
    /**验收检查结果;大修、改造 éœ€è¦å¡«å†™éªŒæ”¶ç»“果，搬迁按照技术状态鉴定工单维护，其他暂未使用到，只预留此类型*/
    @ApiModelProperty(value = "验收检查结果;大修、改造 éœ€è¦å¡«å†™éªŒæ”¶ç»“果，搬迁按照技术状态鉴定工单维护，其他暂未使用到，只预留此类型")
    private String acceptanceCheckResult;
    /**技术状态鉴定工单ID;搬迁使用*/
    @ApiModelProperty(value = "技术状态鉴定工单ID;搬迁使用")
    private String orderId;

    //列表展示
    @TableField(exist = false)