流程添加字段映射

一、目的

流程实例，待处理流程，我发起的流程，我处理的流程，抄送我的流程添加一些流程表单的字段

二、效果

界面可以添加上其他的表单，PC和APP流程中心相关返回值会自动有新添加的字段

三、解决方法

流程添加字段映射视频讲解：流程添加字段映射.wmv

1、在ApplicationSetting的WorkFlowInstance表里面新增想要的字段
2、为“ApplicationSetting.PendingWorkFlowInstance”及ApplicationSetting.WorkFlowInstanceNew添加字段配置
select * FROM [FormColumnSetting] where formkey='ApplicationSetting.PendingWorkFlowInstance'
select * FROM [FormColumnSetting] where formkey='ApplicationSetting.WorkFlowInstanceNew'

模板（替换 WorkFlowInstanceCode 为新增的字段，替换 流程编号 为新增字段的显示名称，替换55为实际的排序号）：
INSERT [FormColumnSetting] ([FormKey],[DataBaseTableName],[ColumnName],[ColumnNameCN],[ColumnLabel],[ColumnObjectType],[DataType],[ObjectID],[IsNotAllowNullValueField],[IsRestrictMode],[AdditionalMsgLayout],[IsReadOnly],[IsDisable],[ValidateOnBlur],[IsSearchable],[IsSortable],[ComboBoxMultiSelect],[ComboBoxEditable],[RadioAutoSelectFirstOne],[CheckBoxNeedCheckAllFunction],[Width],[Height],[IsAllowUploadMultiFile],[IsSerializeToBinary],[NeedResetButton],[AllowFileExtensionList],[InitiateUploadFormNumber],[IsPreviewColumn],[IsSystemColumn],[PreviewColumnWidth],[IsCheckDuplicated],[IsNotSummaryField],[IsAccurateToMinute],[OrderNumber],[IsHidden],[DisplayAsImages]) VALUES ( N'ApplicationSetting.WorkFlowInstanceNew',N'WorkFlowInstance',N'WorkFlowInstanceCode',N'流程编号',N'流程编号',N'TextField',N'NVARCHAR',N'WorkFlowInstanceCode',1,1,N'table',0,0,1,1,1,0,0,0,0,0,0,1,0,0,N'*',1,1,0,0,0,0,0,55,0,0)
INSERT [FormColumnSetting] ([FormKey],[DataBaseTableName],[ColumnName],[ColumnNameCN],[ColumnLabel],[ColumnObjectType],[DataType],[ObjectID],[IsNotAllowNullValueField],[IsRestrictMode],[AdditionalMsgLayout],[IsReadOnly],[IsDisable],[ValidateOnBlur],[IsSearchable],[IsSortable],[ComboBoxMultiSelect],[ComboBoxEditable],[RadioAutoSelectFirstOne],[CheckBoxNeedCheckAllFunction],[Width],[Height],[IsAllowUploadMultiFile],[IsSerializeToBinary],[NeedResetButton],[AllowFileExtensionList],[InitiateUploadFormNumber],[IsPreviewColumn],[IsSystemColumn],[PreviewColumnWidth],[IsCheckDuplicated],[IsNotSummaryField],[IsAccurateToMinute],[OrderNumber],[IsHidden],[DisplayAsImages]) VALUES ( N'ApplicationSetting.PendingWorkFlowInstance',N'PendingWorkFlowInstance',N'WorkFlowInstanceCode',N'流程编号',N'流程编号',N'TextField',N'NVARCHAR',N'WorkFlowInstanceCode',1,1,N'table',0,0,1,1,1,0,0,0,0,0,0,1,0,0,N'*',1,1,0,0,0,0,0,55,0,0)

3、修改ApplicationSetting的视图PendingWorkFlowInstance，往里面添加新增的联查字段。
4、在系统字典里面添加 流程通用字段 的KEY

5、在各流程设置里面“流程通用字段映射”