workflow.sql

OA编程 源代码

/*   流程使用表开始     */
CREATE TABLE [dbo].[用户留言] (
	[用户] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[部门] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[留言] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[DocTemp] (
	[TempKind] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[InputTitle] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[InputName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[InputType] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[TempFile] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[InputId] [int] NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[动作] (
	[动作名称] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[处理记录] (
	[实例编号] [int] NULL ,
	[实例路线序号] [int] NULL ,
	[操作人] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[去向] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[动作] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[批示] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[附件] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[处理时间] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[实例路线] (
	[实例编号] [int] NULL ,
	[主路线序号] [int] NULL ,
	[实例路线序号] [int] NULL ,
	[流程名称] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[角色名称] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[动作] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[目标角色] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[操作标志] [int] NULL ,
	[会签标志] [int] NULL ,
	[实例名称] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[定义时间] [datetime] NULL ,
	[ExmTempId] [numeric](20, 0) NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[流程] (
	[流程编号] [int] NULL ,
	[流程名称] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[定义人] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[流程说明] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[角色] (
	[实例编号] [int] NULL ,
	[角色名称] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[操作人] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[部门] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[完成标志] [int] NULL ,
	[主路线序号] [int] NULL ,
	[角色序号] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[流程路线] (
	[流程编号] [int] NULL ,
	[主路线序号] [int] NULL ,
	[角色名称] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[动作] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[跳转目标] [int] NULL 
) ON [PRIMARY]

/*  流程使用表结束 */



/* 流程数据开始  */
insert into doctemp values('ww','a1','w1','1','TEST.DOT','1')
insert into doctemp values('ww','a2','w2','1','TEST.DOT','2')
insert into doctemp values('ww','a3','w3','2','TEST.DOT','3')
insert into doctemp values('me','china','beijing','1','2001-04-25.dot','1')
insert into doctemp values('me','chinabeijing','beijinghaidiann','1','EmployeeTemplate.dot','1')
insert into doctemp values('支出凭证','年','year','1','GIVE.DOT','1')
insert into doctemp values('支出凭证','月','month','1','GIVE.DOT','2')
insert into doctemp values('支出凭证','日','day','1','GIVE.DOT','3')
insert into doctemp values('发文稿纸','发文号','SendNum','1','SendFile.dot','1')
insert into doctemp values('发文稿纸','密级','Pwd','1','SendFile.dot','2')
insert into doctemp values('发文稿纸','保存期限','LimitDate','1','SendFile.dot','3')
insert into doctemp values('发文稿纸','缓急','SorQ','1','SendFile.dot','4')
insert into doctemp values('发文稿纸','定密依据','SetThing','1','SendFile.dot','5')
insert into doctemp values('发文稿纸','签发','Putup','1','SendFile.dot','6')
insert into doctemp values('发文稿纸','会签','Together','1','SendFile.dot','7')
insert into doctemp values('发文稿纸','主送','MainSend','1','SendFile.dot','8')
insert into doctemp values('发文稿纸','抄送','CopySend','1','SendFile.dot','9')
insert into doctemp values('发文稿纸','拟稿单位','DraftDep','1','SendFile.dot','10')
insert into doctemp values('发文稿纸','拟稿','Draft','1','SendFile.dot','11')
insert into doctemp values('发文稿纸','核稿','Check','1','SendFile.dot','12')
insert into doctemp values('发文稿纸','印制','Print','1','SendFile.dot','13')
insert into doctemp values('发文稿纸','校对','CheckAgain','1','SendFile.dot','14')
insert into doctemp values('发文稿纸','份数','Amount','1','SendFile.dot','15')
insert into doctemp values('发文稿纸','附件','Attach','1','SendFile.dot','16')
insert into doctemp values('发文稿纸','主题词','TitleWord','1','SendFile.dot','17')
insert into doctemp values('发文稿纸','标题','Title','1','SendFile.dot','18')
insert into doctemp values('发文稿纸','内容','Contain','1','SendFile.dot','19')
insert into doctemp values('收文稿纸','收文号','accept','1','公文流转_领导批示.dot','1')
insert into doctemp values('收文稿纸','密级','pwd','1','公文流转_领导批示.dot','2')
insert into doctemp values('收文稿纸','缓急','sorq','1','公文流转_领导批示.dot','3')
insert into doctemp values('收文稿纸','定密依据','setthing','1','公文流转_领导批示.dot','4')
insert into doctemp values('收文稿纸','签发','putup','1','公文流转_领导批示.dot','5')
insert into doctemp values('收文稿纸','会签','together','1','公文流转_领导批示.dot','6')
insert into doctemp values('收文稿纸','主送','mainsend','1','公文流转_领导批示.dot','7')
insert into doctemp values('收文稿纸','抄送','copysend','1','公文流转_领导批示.dot','8')
insert into doctemp values('收文稿纸','拟稿单位','draftdep','1','公文流转_领导批示.dot','9')
insert into doctemp values('收文稿纸','拟稿','draft','1','公文流转_领导批示.dot','10')
insert into doctemp values('收文稿纸','核稿','check','1','公文流转_领导批示.dot','11')
insert into doctemp values('收文稿纸','印制','print','1','公文流转_领导批示.dot','12')
insert into doctemp values('收文稿纸','校对','checkagain','1','公文流转_领导批示.dot','13')
insert into doctemp values('收文稿纸','份数','amount','1','公文流转_领导批示.dot','14')
insert into doctemp values('收文稿纸','附件','attach','1','公文流转_领导批示.dot','15')
insert into doctemp values('收文稿纸','主题词','titleword','1','公文流转_领导批示.dot','16')
insert into doctemp values('收文稿纸','标题','title','1','公文流转_领导批示.dot','17')
insert into doctemp values('收文稿纸','内容','contain','1','公文流转_领导批示.dot','18')
insert into doctemp values('test','topic1','topic1','1','公文流转_领导批示.dot','1')
insert into doctemp values('test','topic2','topic2','1','公文流转_领导批示.dot','2')
insert into doctemp values('用车申请1','申请人','name','1','用车申请模块.dot','1')
insert into doctemp values('用车申请1','时间','ttt','1','用车申请模块.dot','2')
insert into doctemp values('2001-04-25模板','姓名','name','1','2001-04-25.dot','1')
insert into doctemp values('2001-04-25模板','性别','sex','1','2001-04-25.dot','2')
insert into doctemp values('2001-04-25模板','年龄','age','1','2001-04-25.dot','3')
insert into doctemp values('用车申请1','审批结果','rrr','1','用车申请模块.dot','3')
insert into doctemp values('支出凭证','款项','t1','1','GIVE.DOT','4')
insert into doctemp values('支出凭证','金额','t2','1','GIVE.DOT','5')
insert into doctemp values('支出凭证','领款人','t3','1','GIVE.DOT','6')
insert into doctemp values('支出凭证','会计','T4','1','GIVE.DOT','7')
insert into doctemp values('支出凭证','出纳','T5','1','GIVE.DOT','8')
insert into doctemp values('sadf','asdf','fdsa','1','EmployeeTemplate.dot','1')
insert into doctemp values('sadf','sadfsadf','sadfsdaf','1','EmployeeTemplate.dot','2')

insert into 动作 values('同意')
insert into 动作 values('不同意')
insert into 动作 values('取消')
insert into 处理记录 values('5','4','吴文华','结束','同意','','5.doc','20011128')
insert into 处理记录 values('4','4','吴文华','结束','同意','','4.doc','20011128')
insert into 处理记录 values('4','4','吴文华','结束','同意','','4.doc','20011128')