230 lines
14 KiB
Transact-SQL
230 lines
14 KiB
Transact-SQL
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('F5585C62-1F12-4073-8733-C0826FB692DB','质量策划','',190,'0','Menu_CQMS',0,0,1)
|
|
go
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('1D3CAAD1-690B-4F30-9E3E-6B31D0CF60FA','项目质量计划','CQMS/QualityPlanning/ProjectQualityPlan.aspx',10,'F5585C62-1F12-4073-8733-C0826FB692DB','Menu_CQMS',0,1,1)
|
|
go
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('8DEF71B6-6097-44A6-AFE0-84AB92DD7455','1D3CAAD1-690B-4F30-9E3E-6B31D0CF60FA','增加',1)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('BAD25B64-2D8F-4B30-B137-7986FF523473','1D3CAAD1-690B-4F30-9E3E-6B31D0CF60FA','修改',2)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('71B220CB-07CE-4DAF-8517-5BBDF22D4BBD','1D3CAAD1-690B-4F30-9E3E-6B31D0CF60FA','删除',3)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('40EBFB1C-F001-4594-BC7C-86EBFEF5FA13','1D3CAAD1-690B-4F30-9E3E-6B31D0CF60FA','保存',4)
|
|
go
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('46E6F0A6-A6A2-4904-9B69-CD91342D7DF8','质量管理制度','CQMS/QualityPlanning/QualityManagementSys.aspx',20,'F5585C62-1F12-4073-8733-C0826FB692DB','Menu_CQMS',0,1,1)
|
|
go
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('7ADC74D8-FDED-49CA-B8C9-C01A7D9A187A','46E6F0A6-A6A2-4904-9B69-CD91342D7DF8','增加',1)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('3C62B9BD-03B1-4A70-AFA3-F7EC65AFE851','46E6F0A6-A6A2-4904-9B69-CD91342D7DF8','修改',2)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('FBC917B6-1477-4ABB-AE6B-4ED7F9F484D7','46E6F0A6-A6A2-4904-9B69-CD91342D7DF8','删除',3)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('6DC9D9A7-92C9-4F04-9001-214ED0DE992F','46E6F0A6-A6A2-4904-9B69-CD91342D7DF8','保存',4)
|
|
go
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('6769098A-53D7-4585-87CC-2DADBCBC2C74','类似项目施工经验总结清单','CQMS/QualityPlanning/ConExperienceSummary.aspx',30,'F5585C62-1F12-4073-8733-C0826FB692DB','Menu_CQMS',0,1,1)
|
|
go
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('B1933915-149F-4A3C-9DA0-410C53C55DA4','6769098A-53D7-4585-87CC-2DADBCBC2C74','增加',1)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('6B198C01-41CC-4CE0-8DB4-74AC278E9E7B','6769098A-53D7-4585-87CC-2DADBCBC2C74','修改',2)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('AC64DDB9-8E3B-40F3-9CF0-0F83CA4C959A','6769098A-53D7-4585-87CC-2DADBCBC2C74','删除',3)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('AA27DD51-31A8-496A-9F6D-7117AA94A4EF','6769098A-53D7-4585-87CC-2DADBCBC2C74','保存',4)
|
|
go
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('B340205A-8857-4D0D-9E4C-41D91A417A77','质量管理组织机构','CQMS/QualityPlanning/Organizational.aspx',40,'F5585C62-1F12-4073-8733-C0826FB692DB','Menu_CQMS',0,1,1)
|
|
go
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('1AF561F4-5EE1-43BA-B171-9FB7A4AF9BDC','B340205A-8857-4D0D-9E4C-41D91A417A77','查看',1)
|
|
go
|
|
|
|
CREATE TABLE [dbo].[QualityPlanning_ProjectQualityPlan](
|
|
[ProjectQualityPlanId] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[FileCode] [nvarchar](50) NULL,
|
|
[FileName] [nvarchar](100) NULL,
|
|
[CompileMan] [nvarchar](50) NULL,
|
|
[CompileDate] [datetime] NULL,
|
|
[Auditor] [nvarchar](50) NULL,
|
|
[Approver] [nvarchar](50) NULL,
|
|
[ApprovalDate] [datetime] NULL,
|
|
CONSTRAINT [PK_QualityPlanning_ProjectQualityPlan] PRIMARY KEY CLUSTERED
|
|
(
|
|
[ProjectQualityPlanId] 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].[QualityPlanning_ProjectQualityPlan] WITH CHECK ADD CONSTRAINT [FK_QualityPlanning_ProjectQualityPlan_Base_Project] FOREIGN KEY([ProjectId])
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[QualityPlanning_ProjectQualityPlan] CHECK CONSTRAINT [FK_QualityPlanning_ProjectQualityPlan_Base_Project]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[QualityPlanning_ProjectQualityPlan] WITH CHECK ADD CONSTRAINT [FK_QualityPlanning_ProjectQualityPlan_Sys_User] FOREIGN KEY([CompileMan])
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[QualityPlanning_ProjectQualityPlan] CHECK CONSTRAINT [FK_QualityPlanning_ProjectQualityPlan_Sys_User]
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_ProjectQualityPlan', @level2type=N'COLUMN',@level2name=N'ProjectQualityPlanId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_ProjectQualityPlan', @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'QualityPlanning_ProjectQualityPlan', @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'QualityPlanning_ProjectQualityPlan', @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'QualityPlanning_ProjectQualityPlan', @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'QualityPlanning_ProjectQualityPlan', @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'QualityPlanning_ProjectQualityPlan', @level2type=N'COLUMN',@level2name=N'Auditor'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批准人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_ProjectQualityPlan', @level2type=N'COLUMN',@level2name=N'Approver'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批准日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_ProjectQualityPlan', @level2type=N'COLUMN',@level2name=N'ApprovalDate'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目质量计划' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_ProjectQualityPlan'
|
|
GO
|
|
|
|
|
|
|
|
|
|
CREATE TABLE [dbo].[QualityPlanning_QualityManagementSys](
|
|
[QualityManagementSysId] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[FileCode] [nvarchar](50) NULL,
|
|
[FileName] [nvarchar](100) NULL,
|
|
[CompileMan] [nvarchar](50) NULL,
|
|
[CompileDate] [datetime] NULL,
|
|
[Auditor] [nvarchar](50) NULL,
|
|
[Approver] [nvarchar](50) NULL,
|
|
[ApprovalDate] [datetime] NULL,
|
|
CONSTRAINT [PK_QualityPlanning_QualityManagementSys] PRIMARY KEY CLUSTERED
|
|
(
|
|
[QualityManagementSysId] 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].[QualityPlanning_QualityManagementSys] WITH CHECK ADD CONSTRAINT [FK_QualityPlanning_QualityManagementSys_Base_Project] FOREIGN KEY([ProjectId])
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[QualityPlanning_QualityManagementSys] CHECK CONSTRAINT [FK_QualityPlanning_QualityManagementSys_Base_Project]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[QualityPlanning_QualityManagementSys] WITH CHECK ADD CONSTRAINT [FK_QualityPlanning_QualityManagementSys_Sys_User] FOREIGN KEY([CompileMan])
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[QualityPlanning_QualityManagementSys] CHECK CONSTRAINT [FK_QualityPlanning_QualityManagementSys_Sys_User]
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_QualityManagementSys', @level2type=N'COLUMN',@level2name=N'QualityManagementSysId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_QualityManagementSys', @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'QualityPlanning_QualityManagementSys', @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'QualityPlanning_QualityManagementSys', @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'QualityPlanning_QualityManagementSys', @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'QualityPlanning_QualityManagementSys', @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'QualityPlanning_QualityManagementSys', @level2type=N'COLUMN',@level2name=N'Auditor'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批准人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_QualityManagementSys', @level2type=N'COLUMN',@level2name=N'Approver'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批准日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_QualityManagementSys', @level2type=N'COLUMN',@level2name=N'ApprovalDate'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量管理制度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_QualityManagementSys'
|
|
GO
|
|
|
|
|
|
CREATE TABLE [dbo].[QualityPlanning_ConExperienceSummary](
|
|
[ConExperienceSummaryId] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[FileName] [nvarchar](100) NULL,
|
|
[CompileMan] [nvarchar](50) NULL,
|
|
[CompileDate] [datetime] NULL,
|
|
CONSTRAINT [PK_QualityPlanning_ConExperienceSummary] PRIMARY KEY CLUSTERED
|
|
(
|
|
[ConExperienceSummaryId] 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].[QualityPlanning_ConExperienceSummary] WITH CHECK ADD CONSTRAINT [FK_QualityPlanning_ConExperienceSummary_Base_Project] FOREIGN KEY([ProjectId])
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[QualityPlanning_ConExperienceSummary] CHECK CONSTRAINT [FK_QualityPlanning_ConExperienceSummary_Base_Project]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[QualityPlanning_ConExperienceSummary] WITH CHECK ADD CONSTRAINT [FK_QualityPlanning_ConExperienceSummary_Sys_User] FOREIGN KEY([CompileMan])
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[QualityPlanning_ConExperienceSummary] CHECK CONSTRAINT [FK_QualityPlanning_ConExperienceSummary_Sys_User]
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_ConExperienceSummary', @level2type=N'COLUMN',@level2name=N'ConExperienceSummaryId'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'QualityPlanning_ConExperienceSummary', @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'QualityPlanning_ConExperienceSummary', @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'QualityPlanning_ConExperienceSummary', @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'QualityPlanning_ConExperienceSummary', @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'QualityPlanning_ConExperienceSummary'
|
|
GO
|
|
|
|
alter table Comprehensive_GeneralPlanApproval alter column PlanName nvarchar(300)
|
|
go
|
|
|
|
|
|
create view View_ProjectUserWorkPost
|
|
as
|
|
select ProjectUserId,ProjectUser.UserId,ProjectUser.UnitId,ProjectUser.ProjectId,UserName,WorkPostName
|
|
from Project_ProjectUser ProjectUser
|
|
LEFT JOIN Sys_User AS Users ON ProjectUser.UserId = Users.UserId
|
|
LEFT JOIN SitePerson_Person AS Person ON ProjectUser.ProjectId =Person.ProjectId AND Users.IdentityCard = Person.IdentityCard
|
|
LEFT JOIN Base_WorkPost AS WorkPost ON Person.WorkPostId =WorkPost.WorkPostId
|
|
GO
|