vue与C#实现自定义表单审批流程构建-后端_c# 审批流

作者：小丑西瓜9 | 2024-06-02 22:35:30

踩

c# 审批流

实现自定义审批流程，表设计分两类，一是流程模板，2是流程实例与任务日志

流程模板包含：流程模板主表、流程节点表、流程分支表、表单与流程关系表

流程实例:流程实例主表、流程实例节点表、流程实例分支表、流程任务、流程日志。

业务思路大致是：先构建流程模板、绑定模板与表单、发起表单时调用对应的模板进行生成流程实例、冗余模板对应的流程到实例中、审核流转过程中对任务进行下发预处理。

CREATE TABLE [dbo].[approveflow_formbasicinfo](
   [Id] [bigint] NOT NULL,
   [FormCode] [nvarchar](50) NULL,
   [FormEntityName] [nvarchar](500) NULL,
   [FormTableName] [nvarchar](50) NULL,
   [FormDesc] [nvarchar](50) NULL,
   [CreaterID] [bigint] NULL,
   [CreateTime] [datetime] NULL,
   [ModifierID] [bigint] NULL,
   [ModifyTime] [datetime] NULL,
   [IsDeleted] [bit] NULL,
   [CreaterName] [nvarchar](50) NULL,
   [ModifierName] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED
(
   [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ((0)) FOR [Id]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ('') FOR [FormCode]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ('') FOR [FormEntityName]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ('') FOR [FormTableName]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ('') FOR [FormDesc]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ((0)) FOR [CreaterID]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT (getdate()) FOR [CreateTime]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ((0)) FOR [ModifierID]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT (getdate()) FOR [ModifyTime]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ((0)) FOR [IsDeleted]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ('') FOR [CreaterName]
GO

ALTER TABLE [dbo].[approveflow_formbasicinfo] ADD DEFAULT ('') FOR [ModifierName]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'Id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表单编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'FormCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表单实体名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'FormEntityName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表单数据表名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'FormTableName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表单描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'FormDesc'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'CreaterID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编辑人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'ModifierID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编辑时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'ModifyTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'approveflow_formbasicinfo', @level2type=N'COLUMN',@level2name=N'IsDeleted'
GO

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小丑西瓜9/article/detail/664636