📄 acceptsend.sql

📁 OA编程源代码
💻 SQL
字号:


CREATE TABLE [dbo].[AcceptFile] (
	[acceptID] [numeric](20, 0) NOT NULL ,
	[fileOrder] [int] NOT NULL ,
	[dispName] [varchar] (255) NOT NULL ,
	[saveName] [varchar] (255) NOT NULL ,
	[username] [varchar] (30) NOT NULL ,
	[operateDate] [varchar] (10) NOT NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[AcceptKind] (
	[AcceptCode] [varchar] (10) NOT NULL ,
	[acceptKind] [varchar] (20) NOT NULL 
) ON [PRIMARY]




CREATE TABLE [dbo].[ArchiveBorrow] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[Acceptid] [numeric](18, 0) NOT NULL ,
	[BookId] [numeric](18, 0) NOT NULL ,
	[BrwDate] [varchar] (10) NOT NULL ,
	[Brwdept] [varchar] (100) NOT NULL ,
	[Title] [varchar] (255) NOT NULL ,
	[useclassid] [int] NOT NULL ,
	[deadline] [varchar] (10) NULL ,
	[rollnum] [varchar] (6) NOT NULL ,
	[flownum] [int] NOT NULL ,
	[brwName] [varchar] (50) NOT NULL ,
	[GbackDate] [varchar] (10) NULL ,
	[Comments] [varchar] (255) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[ArchiveDisposal] (
	[acceptID] [numeric](23, 0) NOT NULL ,
	[DispReasion] [varchar] (255) NULL ,
	[CensorAdvice] [varchar] (255) NULL ,
	[DispDate] [char] (10) NULL ,
	[comments] [varchar] (255) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[BookCatalog] (
	[bookId] [numeric](20, 0) NOT NULL ,
	[rollNum] [varchar] (6) NOT NULL ,
	[roomNum] [varchar] (10) NULL ,
	[shopNum] [varchar] (10) NULL ,
	[bookTitle] [varchar] (255) NOT NULL ,
	[year] [char] (4) NOT NULL ,
	[deadLine] [varchar] (10) NOT NULL ,
	[archiveDepart] [varchar] (100) NOT NULL ,
	[comments] [varchar] (255) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[FILE_TRANSFER_RULE] (
	[SendSide] [varchar] (30) NOT NULL ,
	[AcceptSide] [varchar] (30) NOT NULL ,
	[AcceptType] [char] (1) NULL ,
	[SendType] [char] (1) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[OUTER_SEND] (
	[SendID] [numeric](18, 0) NOT NULL ,
	[joinUnits] [varchar] (50) NULL ,
	[signal] [varchar] (50) NULL ,
	[signalDate] [char] (10) NULL ,
	[SignalContent] [varchar] (255) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[SEND_ATTACH] (
	[SendID] [numeric](18, 0) NOT NULL ,
	[AttachID] [int] NULL ,
	[DispName] [varchar] (255) NULL ,
	[SaveName] [varchar] (255) NULL ,
	[Username] [varchar] (50) NULL ,
	[OperateDate] [char] (10) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[SEND_DEAL] (
	[SendID] [numeric](18, 0) NOT NULL ,
	[SendOrder] [int] NOT NULL ,
	[DealID] [int] NOT NULL ,
	[OperKind] [int] NULL ,
	[Username] [varchar] (50) NULL ,
	[DealDate] [char] (10) NULL ,
	[DealContent] [varchar] (255) NULL ,
	[DealNotion] [varchar] (255) NULL ,
	[TagPassWord] [varchar] (50) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[SEND_HASTEN] (
	[HastenID] [numeric](18, 0) NULL ,
	[SendID] [numeric](18, 0) NULL ,
	[OriginDepart] [varchar] (200) NULL ,
	[OriginDate] [char] (10) NULL ,
	[UndertakeDepart] [varchar] (200) NULL ,
	[LimitDate] [char] (10) NULL ,
	[FeedbackDate] [char] (10) NULL ,
	[HeadWord] [varchar] (255) NULL ,
	[HastenNotion] [varchar] (255) NULL ,
	[FeedbackInfo] [varchar] (255) NULL ,
	[DealFlag] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[SEND_HEAD] (
	[SendID] [numeric](18, 0) NOT NULL ,
	[DocKind] [varchar] (50) NULL ,
	[SendCode] [varchar] (50) NULL ,
	[SendYear] [char] (4) NULL ,
	[SendNum] [varchar] (50) NULL ,
	[SecretLevel] [varchar] (50) NULL ,
	[secretLimit] [varchar] (10) NULL ,
	[DelayHurry] [char] (10) NULL ,
	[SecretGist] [varchar] (50) NULL ,
	[MainDepart] [varchar] (255) NULL ,
	[CopyDepart] [varchar] (255) NULL ,
	[Amount] [int] NULL ,
	[TopicContent] [varchar] (255) NULL ,
	[HeadWord] [varchar] (255) NULL ,
	[CompFlag] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[SEND_LINE] (
	[SendID] [numeric](18, 0) NOT NULL ,
	[SendOrder] [int] NOT NULL ,
	[Username] [varchar] (255) NULL ,
	[deparment_c] [varchar] (255) NULL ,
	[groupname] [varchar] (255) NULL ,
	[SendTime] [char] (10) NULL ,
	[LimitDate] [char] (10) NULL ,
	[OperKind] [int] NULL ,
	[DealFlag] [int] NULL ,
	[SendFlag] [int] NULL ,
	[FinishFlag] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[SEND_MATCHING] (
	[DocKind] [varchar] (50) NULL ,
	[DocName] [varchar] (255) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[SEND_TEXT] (
	[SendID] [numeric](18, 0) NOT NULL ,
	[TextID] [int] NOT NULL ,
	[DispName] [varchar] (255) NULL ,
	[SaveName] [varchar] (255) NULL ,
	[Username] [varchar] (50) NULL ,
	[OperateDate] [char] (10) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[SendCode] (
	[SendCode] [varchar] (10) NULL ,
	[CodeName] [varchar] (50) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[USER_CODE] (
	[UserName] [varchar] (50) NULL ,
	[Username_c] [varchar] (50) NULL ,
	[Password] [varchar] (50) NULL ,
	[Department_c] [varchar] (50) NULL ,
	[ArrangeOrder] [varchar] (50) NULL ,
	[DutyName] [varchar] (50) NULL ,
	[LevelName] [varchar] (50) NULL ,
	[RoleName] [varchar] (50) NULL ,
	[TagPsw] [varchar] (50) NULL ,
	[GroupName] [varchar] (50) NULL ,
	[Field1] [varchar] (50) NULL ,
	[Field2] [varchar] (50) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[UseClass] (
	[Classid] [int] NOT NULL ,
	[Description] [varchar] (255) NOT NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[acceptDeal] (
	[acceptID] [numeric](20, 0) NOT NULL ,
	[acceptOrder] [int] NULL ,
	[dealOrder] [int] NULL ,
	[username] [varchar] (30) NULL ,
	[operKind] [int] NULL ,
	[dealDate] [varchar] (10) NULL ,
	[dealContent] [text] NULL ,
	[dealPassword] [varchar] (50) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [dbo].[acceptHasten] (
	[acceptId] [numeric](20, 0) NOT NULL ,
	[promptId] [numeric](20, 0) NULL ,
	[username] [varchar] (30) NULL ,
	[originDepart] [varchar] (200) NULL ,
	[originDate] [varchar] (10) NULL ,
	[undertakeDepart] [varchar] (200) NULL ,
	[limitDate] [varchar] (10) NULL ,
	[feedbackDate] [varchar] (10) NULL ,
	[headWord] [varchar] (255) NULL ,
	[hastenNotion] [varchar] (255) NULL ,
	[feedbackInfo] [varchar] (255) NULL ,
	[dealFlag] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[acceptLabel] (
	[acceptId] [numeric](20, 0) NOT NULL ,
	[allNum] [varchar] (10) NULL ,
	[dirNum] [varchar] (6) NULL ,
	[rollNum] [varchar] (6) NULL ,
	[rollOrder] [int] NULL ,
	[acceptKind] [varchar] (30) NULL ,
	[kindCode] [varchar] (10) NULL ,
	[kindOrder] [int] NULL ,
	[fileCode] [varchar] (30) NULL ,
	[fileYear] [varchar] (4) NULL ,
	[fileOrder] [int] NULL ,
	[fileNum] [varchar] (30) NULL ,
	[acceptDate] [varchar] (10) NULL ,
	[acceptTitle] [varchar] (255) NULL ,
	[sendLead] [varchar] (20) NULL ,
	[topicContent] [varchar] (255) NULL ,
	[amount] [int] NULL ,
	[pageNum] [int] NULL ,
	[comeDepart] [varchar] (50) NULL ,
	[shapeDate] [varchar] (10) NULL ,
	[secretLevel] [varchar] (20) NULL ,
	[delayHurry] [varchar] (20) NULL ,
	[doResulst] [varchar] (255) NULL ,
	[userName] [varchar] (30) NULL ,
	[sendFlag] [int] NULL ,
	[dealDepart] [varchar] (50) NULL ,
	[deadLine] [varchar] (50) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[acceptLine] (
	[acceptId] [numeric](20, 0) NOT NULL ,
	[acceptOrder] [int] NULL ,
	[dealOrder] [int] NULL ,
	[username] [varchar] (30) NULL ,
	[deparment_c] [varchar] (50) NULL ,
	[groupname] [varchar] (50) NULL ,
	[limitDate] [varchar] (10) NULL ,
	[sendTime] [varchar] (10) NULL ,
	[operKind] [int] NULL ,
	[returnFlag] [int] NULL ,
	[dealFlag] [int] NULL ,
	[sendFlag] [int] NULL ,
	[finishFlag] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[archive] (
	[acceptId] [numeric](20, 0) NOT NULL ,
	[allNum] [varchar] (10) NULL ,
	[dirNum] [varchar] (6) NULL ,
	[rollNum] [varchar] (6) NULL ,
	[rollOrder] [int] NULL ,
	[acceptKind] [varchar] (30) NULL ,
	[kindCode] [varchar] (10) NULL ,
	[kindOrder] [int] NULL ,
	[fileCode] [varchar] (30) NULL ,
	[fileYear] [varchar] (4) NULL ,
	[fileOrder] [int] NULL ,
	[fileNum] [varchar] (30) NULL ,
	[acceptDate] [varchar] (10) NULL ,
	[acceptTitle] [varchar] (255) NULL ,
	[sendLead] [varchar] (20) NULL ,
	[topicContent] [varchar] (255) NULL ,
	[amount] [int] NULL ,
	[pageNum] [int] NULL ,
	[comeDepart] [varchar] (50) NULL ,
	[shapeDate] [varchar] (10) NULL ,
	[secretLevel] [varchar] (20) NULL ,
	[delayHurry] [varchar] (20) NULL ,
	[doResulst] [varchar] (255) NULL ,
	[userName] [varchar] (30) NULL ,
	[sendFlag] [int] NULL ,
	[dealDepart] [varchar] (50) NULL ,
	[deadLine] [varchar] (50) NULL ,
	[flowNum] [int] NULL ,
	[bookID] [numeric](20, 0) NULL ,
	[archiveFlag] [int] NULL ,
	[disposaldFlag] [int] NULL ,
	[comments] [varchar] (255) NULL 
) ON [PRIMARY]


ALTER TABLE [dbo].[ArchiveBorrow] WITH NOCHECK ADD 
	CONSTRAINT [PK_ArchiveBorrow] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 


ALTER TABLE [dbo].[BookCatalog] WITH NOCHECK ADD 
	CONSTRAINT [PK_BookCatalog] PRIMARY KEY  CLUSTERED 
	(
		[bookId]
	)  ON [PRIMARY] 


ALTER TABLE [dbo].[UseClass] WITH NOCHECK ADD 
	CONSTRAINT [PK_UseClass] PRIMARY KEY  CLUSTERED 
	(
		[Classid]
	)  ON [PRIMARY] 


ALTER TABLE [dbo].[archive] WITH NOCHECK ADD 
	CONSTRAINT [DF_archive_archiveFlag] DEFAULT (0) FOR [archiveFlag],
	CONSTRAINT [DF_archive_disposaldFlag] DEFAULT (0) FOR [disposaldFlag],
	CONSTRAINT [PK_archive] PRIMARY KEY  CLUSTERED 
	(
		[acceptId]
	)  ON [PRIMARY] 



/*XXX单位参量脚本文件 */ 


CREATE TABLE [dbo].[syspara] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[ParaType] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[paraOrder] [int] NULL ,
	[FstPara] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[SecPara] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[paraExp] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



delete from syspara

/*打印批办单*/
insert into syspara (paratype,paraorder,fstpara,secpara,paraexp) values('printppd',1,'XXX单位','','Titl1(右上角)')
insert into syspara (paratype,paraorder,fstpara,secpara,paraexp) values('printppd',2,'XXX单位公文批办单','','titl2(中间表头)')
insert into syspara (paratype,paraorder,fstpara,secpara,paraexp) values('printppd',3,'XXX单位办公室','','Titl3(右上角)')

/*打印文件传阅单*/
insert into syspara (paratype,paraorder,fstpara,secpara,paraexp) values('printcyd',1,'XXX单位办公室','','Titl3(右下角)')

/*打印文头纸*/
insert into syspara (paratype,paraorder,fstpara,secpara,paraexp) values('sendhead',1,'XXX单位发文稿纸','','发文的拟稿中')
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -