备案控制台
探索云世界
开发者社区 开发与运维 文章 正文

构建ASP.NET MVC4+EF5+EasyUI+Unity2.x注入的后台管理系统（42）-工作流设计01

2015-04-07 876
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： 原文:构建ASP.NET MVC4+EF5+EasyUI+Unity2.x注入的后台管理系统（42）-工作流设计01工作流在实际应用中还是比较广泛，网络中存在很多工作流的图形化插件，可以做到拉拽的工作流设计，非常简便，再配合第三方编辑器，可以直接生成表单，我没有刻意的浏览很多工作流的实际设计，我认...
原文: 构建ASP.NET MVC4+EF5+EasyUI+Unity2.x注入的后台管理系统（42）-工作流设计01

工作流在实际应用中还是比较广泛，网络中存在很多工作流的图形化插件，可以做到拉拽的工作流设计，非常简便，再配合第三方编辑器，可以直接生成表单，我没有刻意的浏览很多工作流的实际设计，我认为工作流只要有动态可修改的流转，有时可按角色，部门，上级或者职位流转即是比较好的正常工作流！这里只带给一个思路的简单工作流...

工作流其实有几种，也可以设计得很简单：

1.固定的工作流，很小的公司，很固定的流程！

2.自定义表单和字段，有时候可以校验表单

3.自定义流转的人员，即按角色流转，用户每一次提交工作流都必须在步骤中添加要转的人员

4.直接设置职位和部门，然后根据人员所属的部门、职位或者上级进行流转

上面可以是一个交集，只有4点合起来才能做一个比较动态的工作流，否则可以直接用固定的工作流即可

这是本次要做的一般大众化工作流

当生成表单之后，用户将直接用此表单的模版，并提交公文到下一步，最后流程完成后，反馈给发起人

数据库的设计也有这巧妙之处

Flow_Form：表单模版

Flow_FormAttr：表单字段

Flow_Step：表单的流转步骤，如请假天数小于3天直接上级审批，大于3天需要进行第二步的老总审批

Flow_StepRule：根据字段决定流转的条件

Flow_StepState：正在进行的步骤状态，如第一步是否完成

Flow_Type：工作流种类，如行政管理

Flow_FormCentent：根据模版提交的内容

Flow_FormContentStepCheck：步骤总状态

Flow_FormContentStepCheckState：步骤的细分状态

USE [AppDB]
GO
/****** Object:  Table [dbo].[Flow_Type]    Script Date: 03/21/2015 22:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Flow_Type](
    [Id] [varchar](50) NOT NULL,
    [Name] [varchar](50) NOT NULL,
    [Remark] [varchar](500) NULL,
    [CreateTime] [datetime] NOT NULL,
    [Sort] [int] NOT NULL,
 CONSTRAINT [PK_Flow_Type] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Type', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Type', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Type', @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'Flow_Type', @level2type=N'COLUMN',@level2name=N'Sort'
GO
/****** Object:  Table [dbo].[Flow_Seal]    Script Date: 03/21/2015 22:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Flow_Seal](
    [Id] [varchar](50) NOT NULL,
    [Path] [varchar](200) NULL,
    [CreateTime] [datetime] NULL,
    [Using] [varchar](4000) NULL,
 CONSTRAINT [PK_Flow_Seal] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'使用者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Seal', @level2type=N'COLUMN',@level2name=N'Using'
GO
/****** Object:  Table [dbo].[Flow_FormAttr]    Script Date: 03/21/2015 22:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Flow_FormAttr](
    [Id] [varchar](50) NOT NULL,
    [Title] [varchar](50) NOT NULL,
    [Name] [varchar](50) NOT NULL,
    [AttrType] [varchar](50) NOT NULL,
    [CheckJS] [varchar](500) NULL,
    [TypeId] [varchar](50) NOT NULL,
    [CreateTime] [datetime] NULL,
    [OptionList] [varchar](500) NULL,
    [IsValid] [bit] NULL,
 CONSTRAINT [PK_Flow_FormAttr] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormAttr', @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'Flow_FormAttr', @level2type=N'COLUMN',@level2name=N'Title'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字段英文名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormAttr', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文本,日期,数字,多行文本' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormAttr', @level2type=N'COLUMN',@level2name=N'AttrType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'校验脚本' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormAttr', @level2type=N'COLUMN',@level2name=N'CheckJS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormAttr', @level2type=N'COLUMN',@level2name=N'TypeId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下拉框的值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormAttr', @level2type=N'COLUMN',@level2name=N'OptionList'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否必填' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormAttr', @level2type=N'COLUMN',@level2name=N'IsValid'
GO
/****** Object:  Table [dbo].[Flow_Form]    Script Date: 03/21/2015 22:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Flow_Form](
    [Id] [varchar](50) NOT NULL,
    [Name] [varchar](100) NOT NULL,
    [Remark] [varchar](500) NULL,
    [UsingDep] [varchar](2000) NULL,
    [TypeId] [varchar](50) NOT NULL,
    [State] [bit] NOT NULL,
    [CreateTime] [datetime] NULL,
    [HtmlForm] [text] NULL,
    [AttrA] [varchar](50) NULL,
    [AttrB] [varchar](50) NULL,
    [AttrC] [varchar](50) NULL,
    [AttrD] [varchar](50) NULL,
    [AttrE] [varchar](50) NULL,
    [AttrF] [varchar](50) NULL,
    [AttrG] [varchar](50) NULL,
    [AttrH] [varchar](50) NULL,
    [AttrI] [varchar](50) NULL,
    [AttrJ] [varchar](50) NULL,
    [AttrK] [varchar](50) NULL,
    [AttrL] [varchar](50) NULL,
    [AttrM] [varchar](50) NULL,
    [AttrN] [varchar](50) NULL,
    [AttrO] [varchar](50) NULL,
    [AttrP] [varchar](50) NULL,
    [AttrQ] [varchar](50) NULL,
    [AttrR] [varchar](50) NULL,
    [AttrS] [varchar](50) NULL,
    [AttrT] [varchar](50) NULL,
    [AttrU] [varchar](50) NULL,
    [AttrV] [varchar](50) NULL,
    [AttrW] [varchar](50) NULL,
    [AttrX] [varchar](50) NULL,
    [AttrY] [varchar](50) NULL,
    [AttrZ] [varchar](50) NULL,
 CONSTRAINT [PK_Flow_Form] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否完成流程' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Form', @level2type=N'COLUMN',@level2name=N'State'
GO
/****** Object:  Table [dbo].[Flow_Step]    Script Date: 03/21/2015 22:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Flow_Step](
    [Id] [varchar](50) NOT NULL,
    [Name] [varchar](50) NOT NULL,
    [Remark] [varchar](500) NULL,
    [Sort] [int] NOT NULL,
    [FormId] [varchar](50) NOT NULL,
    [FlowRule] [varchar](50) NOT NULL,
    [IsCustom] [bit] NOT NULL,
    [IsAllCheck] [bit] NOT NULL,
    [Execution] [varchar](4000) NULL,
    [CompulsoryOver] [bit] NOT NULL,
    [IsEditAttr] [bit] NOT NULL,
 CONSTRAINT [PK_Flow_Step] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'步骤名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'步骤说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'Sort'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属表单' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'FormId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流转规则' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'FlowRule'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'该流程的 发起人/创建者 是否可以 自行选择 该步骤的审批者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'IsCustom'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当规则或者角色被选择为多人时候，是否启用多人审核才通过' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'IsAllCheck'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'执行者与规则对应' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'Execution'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否可以强制完成整个流程' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'CompulsoryOver'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核者是否可以编辑发起者的附件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_Step', @level2type=N'COLUMN',@level2name=N'IsEditAttr'
GO
/****** Object:  Table [dbo].[Flow_FormContent]    Script Date: 03/21/2015 22:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Flow_FormContent](
    [Id] [varchar](50) NOT NULL,
    [Title] [varchar](200) NOT NULL,
    [UserId] [varchar](50) NOT NULL,
    [FormId] [varchar](50) NOT NULL,
    [FormLevel] [varchar](50) NOT NULL,
    [CreateTime] [datetime] NOT NULL,
    [AttrA] [varchar](2048) NULL,
    [AttrB] [varchar](2048) NULL,
    [AttrC] [varchar](2048) NULL,
    [AttrD] [varchar](2048) NULL,
    [AttrE] [varchar](2048) NULL,
    [AttrF] [varchar](2048) NULL,
    [AttrG] [varchar](2048) NULL,
    [AttrH] [varchar](2048) NULL,
    [AttrI] [varchar](2048) NULL,
    [AttrJ] [varchar](2048) NULL,
    [AttrK] [varchar](2048) NULL,
    [AttrL] [varchar](2048) NULL,
    [AttrM] [varchar](2048) NULL,
    [AttrN] [varchar](2048) NULL,
    [AttrO] [varchar](2048) NULL,
    [AttrP] [varchar](2048) NULL,
    [AttrQ] [varchar](2048) NULL,
    [AttrR] [varchar](2048) NULL,
    [AttrS] [varchar](2048) NULL,
    [AttrT] [varchar](2048) NULL,
    [AttrU] [varchar](2048) NULL,
    [AttrV] [varchar](2048) NULL,
    [AttrW] [varchar](2048) NULL,
    [AttrX] [varchar](2048) NULL,
    [AttrY] [varchar](2048) NULL,
    [AttrZ] [varchar](2048) NULL,
    [CustomMember] [varchar](4000) NULL,
    [TimeOut] [datetime] NOT NULL,
 CONSTRAINT [PK_Flow_FormContent] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormContent', @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'Flow_FormContent', @level2type=N'COLUMN',@level2name=N'UserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应表单' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormContent', @level2type=N'COLUMN',@level2name=N'FormId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公文级别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormContent', @level2type=N'COLUMN',@level2name=N'FormLevel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormContent', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
/****** Object:  Table [dbo].[Flow_FormContentStepCheck]    Script Date: 03/21/2015 22:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Flow_FormContentStepCheck](
    [Id] [varchar](50) NOT NULL,
    [ContentId] [varchar](50) NOT NULL,
    [StepId] [varchar](50) NOT NULL,
    [State] [int] NOT NULL,
    [StateFlag] [bit] NOT NULL,
    [CreateTime] [datetime] NOT NULL,
    [IsEnd] [bit] NOT NULL,
 CONSTRAINT [PK_Flow_StepState] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormContentStepCheck', @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'Flow_FormContentStepCheck', @level2type=N'COLUMN',@level2name=N'ContentId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0不通过1通过2审核中' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormContentStepCheck', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'true此步骤审核完成' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormContentStepCheck', @level2type=N'COLUMN',@level2name=N'StateFlag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormContentStepCheck', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
/****** Object:  Table [dbo].[Flow_StepRule]    Script Date: 03/21/2015 22:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Flow_StepRule](
    [Id] [varchar](50) NOT NULL,
    [StepId] [varchar](50) NOT NULL,
    [AttrId] [varchar](50) NOT NULL,
    [Operator] [varchar](10) NOT NULL,
    [Result] [varchar](50) NOT NULL,
    [NextStep] [varchar](50) NULL,
 CONSTRAINT [PK_Flow_StepRule] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Flow_FormContentStepCheckState]    Script Date: 03/21/2015 22:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Flow_FormContentStepCheckState](
    [Id] [varchar](50) NOT NULL,
    [StepCheckId] [varchar](50) NOT NULL,
    [UserId] [varchar](50) NOT NULL,
    [CheckFlag] [int] NOT NULL,
    [Reamrk] [varchar](2000) NULL,
    [TheSeal] [varchar](50) NULL,
    [CreateTime] [datetime] NOT NULL,
 CONSTRAINT [PK_Flow_FormContentStepCheckState] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1通过0不通过2审核中' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Flow_FormContentStepCheckState', @level2type=N'COLUMN',@level2name=N'CheckFlag'
GO
/****** Object:  Default [DF_Flow_FormContent_DrafText_Time]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_FormContent] ADD  CONSTRAINT [DF_Flow_FormContent_DrafText_Time]  DEFAULT (getdate()) FOR [CreateTime]
GO
/****** Object:  ForeignKey [FK_Flow_Form_Flow_Type]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_Form]  WITH CHECK ADD  CONSTRAINT [FK_Flow_Form_Flow_Type] FOREIGN KEY([TypeId])
REFERENCES [dbo].[Flow_Type] ([Id])
GO
ALTER TABLE [dbo].[Flow_Form] CHECK CONSTRAINT [FK_Flow_Form_Flow_Type]
GO
/****** Object:  ForeignKey [FK_Flow_FormAttr_Flow_Type]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_FormAttr]  WITH CHECK ADD  CONSTRAINT [FK_Flow_FormAttr_Flow_Type] FOREIGN KEY([TypeId])
REFERENCES [dbo].[Flow_Type] ([Id])
GO
ALTER TABLE [dbo].[Flow_FormAttr] CHECK CONSTRAINT [FK_Flow_FormAttr_Flow_Type]
GO
/****** Object:  ForeignKey [FK_Flow_FormContent_Flow_Form]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_FormContent]  WITH CHECK ADD  CONSTRAINT [FK_Flow_FormContent_Flow_Form] FOREIGN KEY([FormId])
REFERENCES [dbo].[Flow_Form] ([Id])
GO
ALTER TABLE [dbo].[Flow_FormContent] CHECK CONSTRAINT [FK_Flow_FormContent_Flow_Form]
GO
/****** Object:  ForeignKey [FK_Flow_FormContent_SysUser]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_FormContent]  WITH CHECK ADD  CONSTRAINT [FK_Flow_FormContent_SysUser] FOREIGN KEY([UserId])
REFERENCES [dbo].[SysUser] ([Id])
GO
ALTER TABLE [dbo].[Flow_FormContent] CHECK CONSTRAINT [FK_Flow_FormContent_SysUser]
GO
/****** Object:  ForeignKey [FK_Flow_StepState_Flow_StepState]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_FormContentStepCheck]  WITH CHECK ADD  CONSTRAINT [FK_Flow_StepState_Flow_StepState] FOREIGN KEY([ContentId])
REFERENCES [dbo].[Flow_FormContent] ([Id])
GO
ALTER TABLE [dbo].[Flow_FormContentStepCheck] CHECK CONSTRAINT [FK_Flow_StepState_Flow_StepState]
GO
/****** Object:  ForeignKey [FK_Flow_FormContentStepCheckState_Flow_FormContentStepCheck]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_FormContentStepCheckState]  WITH CHECK ADD  CONSTRAINT [FK_Flow_FormContentStepCheckState_Flow_FormContentStepCheck] FOREIGN KEY([StepCheckId])
REFERENCES [dbo].[Flow_FormContentStepCheck] ([Id])
GO
ALTER TABLE [dbo].[Flow_FormContentStepCheckState] CHECK CONSTRAINT [FK_Flow_FormContentStepCheckState_Flow_FormContentStepCheck]
GO
/****** Object:  ForeignKey [FK_Flow_FormContentStepCheckState_SysUser]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_FormContentStepCheckState]  WITH CHECK ADD  CONSTRAINT [FK_Flow_FormContentStepCheckState_SysUser] FOREIGN KEY([UserId])
REFERENCES [dbo].[SysUser] ([Id])
GO
ALTER TABLE [dbo].[Flow_FormContentStepCheckState] CHECK CONSTRAINT [FK_Flow_FormContentStepCheckState_SysUser]
GO
/****** Object:  ForeignKey [FK_Flow_Step_Flow_Form]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_Step]  WITH CHECK ADD  CONSTRAINT [FK_Flow_Step_Flow_Form] FOREIGN KEY([FormId])
REFERENCES [dbo].[Flow_Form] ([Id])
GO
ALTER TABLE [dbo].[Flow_Step] CHECK CONSTRAINT [FK_Flow_Step_Flow_Form]
GO
/****** Object:  ForeignKey [FK_Flow_StepRule_Flow_Step]    Script Date: 03/21/2015 22:36:52 ******/
ALTER TABLE [dbo].[Flow_StepRule]  WITH CHECK ADD  CONSTRAINT [FK_Flow_StepRule_Flow_Step] FOREIGN KEY([StepId])
REFERENCES [dbo].[Flow_Step] ([Id])
GO
ALTER TABLE [dbo].[Flow_StepRule] CHECK CONSTRAINT [FK_Flow_StepRule_Flow_Step]
GO
View Code

 

文章标签：
Go
.NET
数据库
开发框架
关键词：
.NET系统
ASP MVC
.NET mvc
ASP.NET mvc
ASP系统
杰克.陈
目录
相关文章
亚丁号
|
3月前
|
开发框架 前端开发 .NET
ASP.NET CORE 3.1 MVC“指定的网络名不再可用\企图在不存在的网络连接上进行操作”的问题解决过程
ASP.NET CORE 3.1 MVC“指定的网络名不再可用\企图在不存在的网络连接上进行操作”的问题解决过程
亚丁号
38 0
穆雄雄.
|
30天前
|
开发框架 前端开发 .NET
进入ASP .net mvc的世界
进入ASP .net mvc的世界
穆雄雄.
28 0
穆雄雄.
|
30天前
mvc.net分页查询案例——mvc-paper.css
mvc.net分页查询案例——mvc-paper.css
穆雄雄.
5 0
GoodTime
|
1月前
|
开发框架 前端开发 .NET
C# .NET面试系列六：ASP.NET MVC
<h2>ASP.NET MVC #### 1. MVC 中的 TempData\ViewBag\ViewData 区别? 在ASP.NET MVC中，TempData、ViewBag 和 ViewData 都是用于在控制器和视图之间传递数据的机制，但它们有一些区别。 <b>TempData：</b> 1、生命周期 ```c# TempData 的生命周期是短暂的，数据只在当前请求和下一次请求之间有效。一旦数据被读取，它就会被标记为已读，下一次请求时就会被清除。 ``` 2、用途 ```c# 主要用于在两个动作之间传递数据，例如在一个动作中设置 TempData，然后在重定向到另
GoodTime
95 5
亚丁号
|
3月前
|
XML 前端开发 定位技术
C#(NET Core3.1 MVC)生成站点地图（sitemap.xml）
C#(NET Core3.1 MVC)生成站点地图（sitemap.xml）
亚丁号
25 0
亚丁号
|
3月前
|
前端开发
.net core mvc获取IP地址和IP所在地（其实是百度的）
.net core mvc获取IP地址和IP所在地（其实是百度的）
亚丁号
123 0
编程乐趣
|
5月前
|
开发框架 自然语言处理 前端开发
基于ASP.NET MVC开发的、开源的个人博客系统
基于ASP.NET MVC开发的、开源的个人博客系统
编程乐趣
51 0
老码识途
|
8月前
|
存储 开发框架 前端开发
[回馈]ASP.NET Core MVC开发实战之商城系统(五)
经过一段时间的准备，新的一期【ASP.NET Core MVC开发实战之商城系统】已经开始，在之前的文章中，讲解了商城系统的整体功能设计，页面布局设计，环境搭建，系统配置，及首页【商品类型，banner条，友情链接，降价促销，新品爆款】，商品列表页面，商品详情等功能的开发，今天继续讲解购物车功能开发，仅供学习分享使用，如有不足之处，还请指正。
老码识途
114 0
老码识途
|
9月前
|
开发框架 前端开发 .NET
[回馈]ASP.NET Core MVC开发实战之商城系统(一)
[回馈]ASP.NET Core MVC开发实战之商城系统(一)
老码识途
113 0
老码识途
|
9月前
|
SQL 开发框架 前端开发
[回馈]ASP.NET Core MVC开发实战之商城系统(开篇)
[回馈]ASP.NET Core MVC开发实战之商城系统(开篇)
老码识途
144 0

热门文章

最新文章

  • 1
    三款.NET 代码混淆工具比较分析：ConfuserEx、Obfuscar 和 Ipa Guard
  • 2
    深入.net平台的分层开发
  • 3
    C#/.NET/.NET Core优秀项目和框架2024年3月简报
  • 4
    【干货】Java开发者快速上手.NET指南
  • 5
    MQTT常见问题之调用.net sdk 报“不知道这样的主机”如何解决
  • 6
    .NET智慧手术室管理平台源码
  • 7
    .NET开源、免费、强大的交互式绘图库
  • 8
    .NET开源免费、功能强大的 Windows 截图录屏神器
  • 9
    .NET开源、免费、跨平台的Git可视化管理工具
  • 10
    .NET从入门到精通，零基础也能搞定的基础知识教程
  • 1
    ASP.NET体检中心源码，实现检前、检中、检后全流程管理
    35
  • 2
    C# .NET面试系列七：ASP.NET Core
    60
  • 3
    C# .NET面试系列六：ASP.NET MVC
    95
  • 4
    ASP.NET云LIS区域检验云SaaS平台源码
    45
  • 5
    ASP.NET实验室LIS系统源码 Oracle数据库
    35
  • 6
    ASP.NETMVC数据库完整CRUD操作示例
    29
  • 7
    ASP.NET WEB+EntityFramework数据持久化——考核练习库——1、用户管理系统(考点：查询列表、增加、删除)
    67
  • 8
    ASP.NET WEB项目中GridView与Repeater数据绑定控件的用法
    32
  • 9
    ASP.NET WEB——项目中Cookie与Session的用法
    29
  • 10
    ASP.NET WEB——项目创建与文件上传操作
    46

    • 相关课程

    更多
  • SpringMVC框架入门
  • 前端开发框架Bootstrap使用教程
  • Java Web项目实战 - 图书商城

    • 相关电子书

    更多
  • Java Spring Boot开发实战系列课程【第7讲】：Spring Boot 2.0安全机制与MVC身份验证实战(Java面试题)
  • Web应用系统性能优化
  • QQ移动页面框架优化实践

    • 相关实验场景

    更多
  • WEB网页编程实战
  • Web Terminal环境使用指南
    • 下一篇
    阿里云oss简介和使用流程