1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
| -- 菜单维修履历修改
| UPDATE [dbo].[sys_permission] SET [parent_id] = N'1647845086853693442', [name] = N'维修履历', [url] = N'/eam/RepairOrder', [component] = N'eam/RepairOrderList', [component_name] = NULL, [redirect] = NULL, [menu_type] = 1, [perms] = NULL, [perms_type] = N'1', [sort_no] = 1.2, [always_show] = 0, [icon] = NULL, [is_route] = 1, [is_leaf] = 1, [keep_alive] = 0, [hidden] = 0, [hide_tab] = 0, [description] = NULL, [create_by] = N'admin', [create_time] = '2023-04-24 16:56:44.0000000', [update_by] = N'admin', [update_time] = '2023-12-11 11:32:06.0090000', [del_flag] = 0, [rule_flag] = 0, [status] = N'1', [internal_or_external] = 0 WHERE CONVERT(NVARCHAR(MAX), [id]) = N'1650423515662295042';
| -- 菜单设备事故登记表修改
| UPDATE [dbo].[sys_permission] SET [parent_id] = N'1647845086853693442', [name] = N'设备事故登记表', [url] = N'/eam/FaultInfoList', [component] = N'eam/FaultInfoList', [component_name] = NULL, [redirect] = NULL, [menu_type] = 1, [perms] = NULL, [perms_type] = N'1', [sort_no] = 2.1, [always_show] = 0, [icon] = NULL, [is_route] = 1, [is_leaf] = 1, [keep_alive] = 0, [hidden] = 0, [hide_tab] = 0, [description] = NULL, [create_by] = N'admin', [create_time] = '2023-11-13 09:39:39.0000000', [update_by] = N'admin', [update_time] = '2023-12-11 11:38:21.9880000', [del_flag] = 0, [rule_flag] = NULL, [status] = N'1', [internal_or_external] = 0 WHERE CONVERT(NVARCHAR(MAX), [id]) = N'1723878256194232322';
| --ABC标识变更单单据号
| INSERT INTO [dbo].[mom_sys_identity] ([id], [num], [month_value], [year_value], [type], [remark], [create_by], [create_time], [update_by], [update_time], [prifix], [encode_rule_id]) VALUES (N'1726910264274141186', 10, N'12', N'2023', N'ABCAssement', NULL, N'admin', '2023-11-21 18:27:46', N'admin', '2023-12-12 15:52:18', NULL, NULL);
| -- 保养计划生成原因字段添加
| ALTER TABLE [dbo].[mom_eam_equipment_maintenance_plan] ADD [create_reason] varchar(255) NULL
| GO
|
| EXEC sp_addextendedproperty
| 'MS_Description', N'生产原因',
| 'SCHEMA', N'dbo',
| 'TABLE', N'mom_eam_equipment_maintenance_plan',
| 'COLUMN', N'create_reason'
| -- 设备台账增加两个字段
| ALTER TABLE [dbo].[mom_eam_equipment] ADD [is_line_equip] nvarchar(32) NULL
| GO
|
| ALTER TABLE [dbo].[mom_eam_equipment] ADD [is_judging] nvarchar(32) NULL
| GO
|
| EXEC sp_addextendedproperty
| 'MS_Description', N'是否生产线设备（是：yes，否：no）',
| 'SCHEMA', N'dbo',
| 'TABLE', N'mom_eam_equipment',
| 'COLUMN', N'is_line_equip'
| GO
|
| EXEC sp_addextendedproperty
| 'MS_Description', N'是否在评分当中（是：yes，否：no）',
| 'SCHEMA', N'dbo',
| 'TABLE', N'mom_eam_equipment',
| 'COLUMN', N'is_judging'
|
|
