172 lines
9.9 KiB
Transact-SQL
172 lines
9.9 KiB
Transact-SQL
update Sys_Menu set IsUsed=0 where MenuId='a4f071a6-51cb-45b1-bbac-93a02f1cb98a'
|
|
update Sys_Menu set IsUsed=0 where MenuId='4a9df3ce-88fd-42a4-aac2-5a7b86edd578'
|
|
go
|
|
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('E7C8C938-661C-438F-852F-F0A4C285306B','资料收发文登记记录','CQMS/Comprehensive/DataReceivingDoc.aspx',100,'4a0e62cb-ee50-4a14-80b7-377602e9902c','Menu_CQMS',0,1,1)
|
|
go
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('4591188A-5877-4751-B303-11126ABC8463','E7C8C938-661C-438F-852F-F0A4C285306B','增加',1)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('3BD831A3-7F32-4F5C-8AD0-83DF10BA6E05','E7C8C938-661C-438F-852F-F0A4C285306B','修改',2)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('EAC5D385-83D4-441E-A1F1-619C163241DD','E7C8C938-661C-438F-852F-F0A4C285306B','删除',3)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('26758668-2253-4B3C-8EAE-F2E36BE87BBF','E7C8C938-661C-438F-852F-F0A4C285306B','保存',4)
|
|
go
|
|
|
|
|
|
|
|
CREATE TABLE [dbo].[Comprehensive_DataReceivingDoc](
|
|
[DataReceivingDocId] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[FileCode] [nvarchar](100) NULL,
|
|
[FileName] [nvarchar](150) NULL,
|
|
[ReceiveDate] [datetime] NULL,
|
|
[FileType] [nvarchar](50) NULL,
|
|
[CNProfessionalId] [nvarchar](50) NULL,
|
|
[SendUnit] [nvarchar](500) NULL,
|
|
[SendMan] [nvarchar](50) NULL,
|
|
[Copies] [int] NULL,
|
|
[DocumentHandler] [nvarchar](50) NULL,
|
|
[SendDate] [datetime] NULL,
|
|
[ReceiveUnit] [nvarchar](500) NULL,
|
|
[ReceiveMan] [nvarchar](50) NULL,
|
|
[IsReply] [bit] NULL,
|
|
[ReturnWuhuangDate] [datetime] NULL,
|
|
[RetrunWuhuangCopies] [int] NULL,
|
|
[IssueToUnit] [nvarchar](500) NULL,
|
|
[IssueCopies] [int] NULL,
|
|
[IssueUnitReceiver] [nvarchar](50) NULL,
|
|
[IsOnFile] [bit] NULL,
|
|
[CompileMan] [nvarchar](50) NULL,
|
|
[CompileDate] [datetime] NULL,
|
|
[Status] [nchar](2) NULL,
|
|
[AuditMan] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Comprehensive_DataReceivingDoc] PRIMARY KEY CLUSTERED
|
|
(
|
|
[DataReceivingDocId] 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
|
|
|
|
ALTER TABLE [dbo].[Comprehensive_DataReceivingDoc] WITH CHECK ADD CONSTRAINT [FK_Comprehensive_DataReceivingDoc_Base_CNProfessional] FOREIGN KEY([CNProfessionalId])
|
|
REFERENCES [dbo].[Base_CNProfessional] ([CNProfessionalId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Comprehensive_DataReceivingDoc] CHECK CONSTRAINT [FK_Comprehensive_DataReceivingDoc_Base_CNProfessional]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Comprehensive_DataReceivingDoc] WITH CHECK ADD CONSTRAINT [FK_Comprehensive_DataReceivingDoc_Base_Project] FOREIGN KEY([ProjectId])
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Comprehensive_DataReceivingDoc] CHECK CONSTRAINT [FK_Comprehensive_DataReceivingDoc_Base_Project]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Comprehensive_DataReceivingDoc] WITH CHECK ADD CONSTRAINT [FK_Comprehensive_DataReceivingDoc_Sys_User] FOREIGN KEY([CompileMan])
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Comprehensive_DataReceivingDoc] CHECK CONSTRAINT [FK_Comprehensive_DataReceivingDoc_Sys_User]
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'DataReceivingDocId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'FileCode'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'FileName'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接收日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'ReceiveDate'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'FileType'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专业' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'CNProfessionalId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发件单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'SendUnit'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发件人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'SendMan'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'份数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'Copies'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件处理人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'DocumentHandler'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发出日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'SendDate'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接收单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'ReceiveUnit'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接收人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'ReceiveMan'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否需回复' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'IsReply'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'返回五环日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'ReturnWuhuangDate'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'返回五环份数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'RetrunWuhuangCopies'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下发至单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'IssueToUnit'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下发份数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'IssueCopies'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下发单位接收人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'IssueUnitReceiver'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否存档' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'IsOnFile'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编制人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'CompileMan'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编制日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'CompileDate'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Comprehensive_DataReceivingDoc', @level2type=N'COLUMN',@level2name=N'Status'
|
|
GO
|
|
|
|
|
|
CREATE TABLE [dbo].[Comprehensive_DataReceivingDocApprove](
|
|
[DataReceivingDocApproveId] [nvarchar](50) NOT NULL,
|
|
[DataReceivingDocId] [nvarchar](50) NULL,
|
|
[ApproveMan] [nvarchar](50) NULL,
|
|
[ApproveDate] [datetime] NULL,
|
|
[IsAgree] [bit] NULL,
|
|
[ApproveType] [varchar](2) NULL,
|
|
[ApproveIdea] [nvarchar](255) NULL,
|
|
CONSTRAINT [PK_Comprehensive_DataReceivingDocApprove] PRIMARY KEY CLUSTERED
|
|
(
|
|
[DataReceivingDocApproveId] 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
|
|
|
|
ALTER TABLE [dbo].[Comprehensive_DataReceivingDocApprove] WITH CHECK ADD CONSTRAINT [FK_Comprehensive_DataReceivingDocApprove_Comprehensive_DataReceivingDoc] FOREIGN KEY([DataReceivingDocId])
|
|
REFERENCES [dbo].[Comprehensive_DataReceivingDoc] ([DataReceivingDocId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Comprehensive_DataReceivingDocApprove] CHECK CONSTRAINT [FK_Comprehensive_DataReceivingDocApprove_Comprehensive_DataReceivingDoc]
|
|
GO
|
|
|
|
alter table Report_TextBoxContent add imageUrl nvarchar(100)
|
|
go
|
|
|