lpf
/
xinjiang
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
xinjiang/DataBase/版本日志/SGGLDB_V2023-03-30_gaofei.sql

2996 lines
187 KiB
Transact-SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

INSERT sys_menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed) VALUES ( N'ECDD89AC-1E16-4D82-B3BE-5D62F31B7A14',N'化工行业能源节约与生态环境保护汇总表',N'ZHGL/Environmental/ChemicalReport.aspx',120,N'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001',N'Menu_ZHGL',1,1,1)
go
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'46920D17-DBED-49FC-AE0C-7FB67ECEB489',N'ECDD89AC-1E16-4D82-B3BE-5D62F31B7A14',N'增加',1)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'55E6ABFD-302A-4069-BFB3-0CA4A8A2378B',N'ECDD89AC-1E16-4D82-B3BE-5D62F31B7A14',N'修改',2)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'D00DEFA7-5B40-4DBF-8B9E-A9EAAE45A32B',N'ECDD89AC-1E16-4D82-B3BE-5D62F31B7A14',N'删除',3)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'848805D2-91A1-4D20-9D04-108D44B08860',N'ECDD89AC-1E16-4D82-B3BE-5D62F31B7A14',N'保存',4)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'D0B18467-8D51-4D4A-A446-3BB140FF29A7',N'ECDD89AC-1E16-4D82-B3BE-5D62F31B7A14',N'保存并上报',5)
go
CREATE TABLE [dbo].[Environmental_ChemicalReport](
[ChemicalReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Month] [int] NULL,
[FillingMan] [nvarchar](50) NULL,
[FillingDate] [datetime] NULL,
[DutyPerson] [nvarchar](50) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Environmental_ChemicalReport] PRIMARY KEY CLUSTERED
(
[ChemicalReportId] 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
ALTER TABLE [dbo].[Environmental_ChemicalReport] WITH CHECK ADD CONSTRAINT [FK_Environmental_ChemicalReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Environmental_ChemicalReport] CHECK CONSTRAINT [FK_Environmental_ChemicalReport_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReport', @level2type=N'COLUMN',@level2name=N'ChemicalReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReport', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'月份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReport', @level2type=N'COLUMN',@level2name=N'Month'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReport', @level2type=N'COLUMN',@level2name=N'FillingMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReport', @level2type=N'COLUMN',@level2name=N'FillingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReport', @level2type=N'COLUMN',@level2name=N'DutyPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'化工行业能源节约与生态环境保护汇总表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReport'
GO
CREATE TABLE [dbo].[Environmental_ChemicalReportItem](
[ChemicalReportItemId] [nvarchar](50) NOT NULL,
[ChemicalReportId] [nvarchar](50) NULL,
[SortIndex] [nvarchar](50) NULL,
[LastYearValue] [nvarchar](50) NULL,
[ThisYearValue] [nvarchar](50) NULL,
[Rate] [nvarchar](50) NULL,
CONSTRAINT [PK_Environmental_ChemicalReportItem] PRIMARY KEY CLUSTERED
(
[ChemicalReportItemId] 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].[Environmental_ChemicalReportItem] WITH CHECK ADD CONSTRAINT [FK_Environmental_ChemicalReportItem_Environmental_ChemicalReport] FOREIGN KEY([ChemicalReportId])
REFERENCES [dbo].[Environmental_ChemicalReport] ([ChemicalReportId])
GO
ALTER TABLE [dbo].[Environmental_ChemicalReportItem] CHECK CONSTRAINT [FK_Environmental_ChemicalReportItem_Environmental_ChemicalReport]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReportItem', @level2type=N'COLUMN',@level2name=N'ChemicalReportItemId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'外键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReportItem', @level2type=N'COLUMN',@level2name=N'ChemicalReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上年累计完成值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReportItem', @level2type=N'COLUMN',@level2name=N'LastYearValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReportItem', @level2type=N'COLUMN',@level2name=N'ThisYearValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'与上年同期比较增减(%)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReportItem', @level2type=N'COLUMN',@level2name=N'Rate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'化工行业能源节约与生态环境保护汇总明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ChemicalReportItem'
GO
/*************化工行业能源节约与生态环境保护汇总表**************/
CREATE VIEW [dbo].[View_Environmental_ChemicalReport]
AS
SELECT
Report.ChemicalReportId,
Report.UnitId,
Report.FillingDate,
(ISNULL(Group_0008.ConstText,'-') + ISNULL(Group_0009.ConstText,'-')) AS ReportDate,
Group_0008.ConstText as YearStr,
Group_0009.ConstText as MonthStr,
U.UnitName,
Report.Year,
Report.Month,
Report.UpState,
Report.DutyPerson
FROM dbo.Environmental_ChemicalReport AS Report
LEFT JOIN Base_Unit AS U ON U.UnitId=Report.UnitId
LEFT JOIN Sys_Const AS Group_0008 ON Group_0008.GroupId='0008' AND Group_0008.ConstValue =Report.[Year]
LEFT JOIN Sys_Const AS Group_0009 ON Group_0009.GroupId='0009' AND Group_0009.ConstValue =Report.[Month]
GO
INSERT sys_menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed) VALUES ( N'7C47F078-D4C9-40D9-BEEF-E657EAFEC650',N'建筑行业能源节约与生态环境保护汇总表',N'ZHGL/Environmental/ArchitectureReport.aspx',110,N'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001',N'Menu_ZHGL',1,1,1)
go
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'18E91EB6-C21B-46ED-9F98-438C8EABD1BE',N'7C47F078-D4C9-40D9-BEEF-E657EAFEC650',N'增加',1)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'B42F1CA0-A07C-4B02-98B5-602820C550D5',N'7C47F078-D4C9-40D9-BEEF-E657EAFEC650',N'修改',2)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'8B675F10-97BC-4D6D-B675-2C1DCD91C691',N'7C47F078-D4C9-40D9-BEEF-E657EAFEC650',N'删除',3)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'1B762DE4-5B26-42B2-AAFD-4ED2F6505A26',N'7C47F078-D4C9-40D9-BEEF-E657EAFEC650',N'保存',4)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'EF3CB7FF-3B65-485C-8414-D2955B7C7BFB',N'7C47F078-D4C9-40D9-BEEF-E657EAFEC650',N'保存并上报',5)
go
CREATE TABLE [dbo].[Environmental_ArchitectureReport](
[ArchitectureReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Month] [int] NULL,
[FillingMan] [nvarchar](50) NULL,
[FillingDate] [datetime] NULL,
[DutyPerson] [nvarchar](50) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Environmental_ArchitectureReport] PRIMARY KEY CLUSTERED
(
[ArchitectureReportId] 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
ALTER TABLE [dbo].[Environmental_ArchitectureReport] WITH CHECK ADD CONSTRAINT [FK_Environmental_ArchitectureReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Environmental_ArchitectureReport] CHECK CONSTRAINT [FK_Environmental_ArchitectureReport_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReport', @level2type=N'COLUMN',@level2name=N'ArchitectureReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReport', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'月份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReport', @level2type=N'COLUMN',@level2name=N'Month'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReport', @level2type=N'COLUMN',@level2name=N'FillingMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReport', @level2type=N'COLUMN',@level2name=N'FillingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReport', @level2type=N'COLUMN',@level2name=N'DutyPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'建筑行业能源节约与生态环境保护汇总表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReport'
GO
CREATE TABLE [dbo].[Environmental_ArchitectureReportItem](
[ArchitectureReportItemId] [nvarchar](50) NOT NULL,
[ArchitectureReportId] [nvarchar](50) NULL,
[SortIndex] [nvarchar](50) NULL,
[LastYearValue] [nvarchar](50) NULL,
[ThisYearValue] [nvarchar](50) NULL,
[Rate] [nvarchar](50) NULL,
CONSTRAINT [PK_Environmental_ArchitectureReportItem] PRIMARY KEY CLUSTERED
(
[ArchitectureReportItemId] 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].[Environmental_ArchitectureReportItem] WITH CHECK ADD CONSTRAINT [FK_Environmental_ArchitectureReportItem_Environmental_ArchitectureReport] FOREIGN KEY([ArchitectureReportId])
REFERENCES [dbo].[Environmental_ArchitectureReport] ([ArchitectureReportId])
GO
ALTER TABLE [dbo].[Environmental_ArchitectureReportItem] CHECK CONSTRAINT [FK_Environmental_ArchitectureReportItem_Environmental_ArchitectureReport]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'ArchitectureReportItemId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'外键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'ArchitectureReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上年累计完成值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'LastYearValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'ThisYearValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'与上年同期比较增减(%)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'Rate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'建筑行业能源节约与生态环境保护汇总明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ArchitectureReportItem'
GO
/*************建筑行业能源节约与生态环境保护汇总表**************/
CREATE VIEW [dbo].[View_Environmental_ArchitectureReport]
AS
SELECT
Report.ArchitectureReportId,
Report.UnitId,
Report.FillingDate,
(ISNULL(Group_0008.ConstText,'-') + ISNULL(Group_0009.ConstText,'-')) AS ReportDate,
Group_0008.ConstText as YearStr,
Group_0009.ConstText as MonthStr,
U.UnitName,
Report.Year,
Report.Quarters,
Report.UpState,
Report.DutyPerson
FROM dbo.Environmental_ArchitectureReport AS Report
LEFT JOIN Base_Unit AS U ON U.UnitId=Report.UnitId
LEFT JOIN Sys_Const AS Group_0008 ON Group_0008.GroupId='0008' AND Group_0008.ConstValue =Report.[Year]
LEFT JOIN Sys_Const AS Group_0009 ON Group_0009.GroupId='0009' AND Group_0009.ConstValue =Report.Quarters
GO
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('07FEEC9D-09C1-4C19-9269-62F69532086C','安全管理工作总结报告','ZHGL/Information/WorkSummaryReport.aspx',90,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('FD088090-FD25-4548-9B7F-49247A8F601B','07FEEC9D-09C1-4C19-9269-62F69532086C','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('8ADC4E94-8182-4AE7-8D69-CEF3004B6AAE','07FEEC9D-09C1-4C19-9269-62F69532086C','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('7A3C8A43-9585-4E27-BDE2-F66FEE9435BD','07FEEC9D-09C1-4C19-9269-62F69532086C','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('AD4FB77C-2B53-4970-87F3-3DF8B675C9A8','07FEEC9D-09C1-4C19-9269-62F69532086C','保存',4)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('2F222D01-838E-4BE6-9212-4C6AE0B0BC6A','07FEEC9D-09C1-4C19-9269-62F69532086C','保存并上报',5)
go
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('12941594-2171-411A-8CC8-32E3BD9FCDDF','质量管理工作总结报告','ZHGL/Information/QualityWorkSummaryReport.aspx',100,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('EC9D2B2F-E61B-4E87-8F38-26ED0D7F3F10','12941594-2171-411A-8CC8-32E3BD9FCDDF','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('A1F10A53-693D-4AA8-A28D-A60151828325','12941594-2171-411A-8CC8-32E3BD9FCDDF','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('0948549B-7CAC-4810-8113-66843F4C4969','12941594-2171-411A-8CC8-32E3BD9FCDDF','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('254F6A15-4A4B-4BF3-929B-FBC9174B4FC5','12941594-2171-411A-8CC8-32E3BD9FCDDF','保存',4)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('817CF1AA-4F75-41A4-A8F6-E30448D62FFC','12941594-2171-411A-8CC8-32E3BD9FCDDF','保存并上报',5)
go
CREATE TABLE [dbo].[Information_WorkSummaryReport](
[WorkSummaryReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[ResponsiblePersonTel] [nvarchar](50) NULL,
[ContactPerson] [nvarchar](50) NULL,
[ContactPersonTel] [nvarchar](50) NULL,
[ReportDate] [datetime] NULL,
[SafeLaborTime] [decimal](18, 2) NULL,
[SafetyObjectives] [nvarchar](max) NULL,
[AccidentSituation] [nvarchar](max) NULL,
[Awards] [nvarchar](max) NULL,
[WorkDevelopment] [nvarchar](max) NULL,
[PersonnelTraining] [nvarchar](max) NULL,
[GovernanceSituation] [nvarchar](max) NULL,
[ManagementActivity] [nvarchar](max) NULL,
[WorkExperience] [nvarchar](max) NULL,
[Countermeasures] [nvarchar](max) NULL,
[NextYearWorkPlan] [nvarchar](max) NULL,
[JobSuggestion] [nvarchar](max) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Information_WorkSummaryReport] PRIMARY KEY CLUSTERED
(
[WorkSummaryReportId] 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
ALTER TABLE [dbo].[Information_WorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_Information_WorkSummaryReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Information_WorkSummaryReport] CHECK CONSTRAINT [FK_Information_WorkSummaryReport_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报告时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ReportDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全人工时' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'SafeLaborTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全目标及完成情况（按责任书相应内容进行总结）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'SafetyObjectives'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全事故情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'AccidentSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'获奖情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Awards'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'重点工作开展情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkDevelopment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员培训情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'PersonnelTraining'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织开展安全监督检查、隐患排查治理情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'GovernanceSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全月、职业健康宣传周等其他管理活动情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ManagementActivity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要工作经验及亮点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkExperience'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要问题及应对措施' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Countermeasures'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下一年度工作计划打算' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'NextYearWorkPlan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对集团公司的工作建议' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'JobSuggestion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全管理工作总结报告' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport'
GO
CREATE TABLE [dbo].[Information_QualityWorkSummaryReport](
[QualityWorkSummaryReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[ResponsiblePersonTel] [nvarchar](50) NULL,
[ContactPerson] [nvarchar](50) NULL,
[ContactPersonTel] [nvarchar](50) NULL,
[ReportDate] [datetime] NULL,
[Performance] [nvarchar](max) NULL,
[AccidentSituation] [nvarchar](max) NULL,
[Awards] [nvarchar](max) NULL,
[WorkDevelopment] [nvarchar](max) NULL,
[PersonnelTraining] [nvarchar](max) NULL,
[CheckSituation] [nvarchar](max) NULL,
[ManagementActivity] [nvarchar](max) NULL,
[WorkExperience] [nvarchar](max) NULL,
[Countermeasures] [nvarchar](max) NULL,
[NextYearWorkPlan] [nvarchar](max) NULL,
[JobSuggestion] [nvarchar](max) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Information_QualityWorkSummaryReport] PRIMARY KEY CLUSTERED
(
[QualityWorkSummaryReportId] 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
ALTER TABLE [dbo].[Information_QualityWorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_Information_QualityWorkSummaryReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Information_QualityWorkSummaryReport] CHECK CONSTRAINT [FK_Information_QualityWorkSummaryReport_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报告时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ReportDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量管理绩效（单位工程质量状况等）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Performance'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量事故情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'AccidentSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'获奖情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Awards'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量提升行动、质量首件及质量管理重点工作开展情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkDevelopment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员培训情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'PersonnelTraining'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织开展质量监督检查情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'CheckSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量月等其他管理活动情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ManagementActivity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要工作经验及亮点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkExperience'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要问题及应对措施' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Countermeasures'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下一年度工作计划打算' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'NextYearWorkPlan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对集团公司的工作建议' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'JobSuggestion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量管理工作总结报告' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport'
GO
alter table [dbo].[Environmental_ChemicalReportItem] add BaseNumber nvarchar(50) null
GO
alter table [dbo].[Environmental_ArchitectureReportItem] add BaseNumber nvarchar(50) null
GO
CREATE TABLE [dbo].[Environmental_ProjectChemicalReport](
[ChemicalReportId] [nvarchar](50) NOT NULL,
[ProjectId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Month] [int] NULL,
[FillingMan] [nvarchar](50) NULL,
[FillingDate] [datetime] NULL,
[DutyPerson] [nvarchar](50) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Environmental_ProjectChemicalReport] PRIMARY KEY CLUSTERED
(
[ChemicalReportId] 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
ALTER TABLE [dbo].[Environmental_ProjectChemicalReport] WITH CHECK ADD CONSTRAINT [FK_Environmental_ProjectChemicalReport_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
GO
ALTER TABLE [dbo].[Environmental_ProjectChemicalReport] CHECK CONSTRAINT [FK_Environmental_ProjectChemicalReport_Base_Project]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReport', @level2type=N'COLUMN',@level2name=N'ChemicalReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReport', @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'Environmental_ProjectChemicalReport', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'月份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReport', @level2type=N'COLUMN',@level2name=N'Month'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReport', @level2type=N'COLUMN',@level2name=N'FillingMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReport', @level2type=N'COLUMN',@level2name=N'FillingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReport', @level2type=N'COLUMN',@level2name=N'DutyPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'化工行业能源节约与生态环境保护汇总表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReport'
GO
CREATE TABLE [dbo].[Environmental_ProjectChemicalReportItem](
[ChemicalReportItemId] [nvarchar](50) NOT NULL,
[ChemicalReportId] [nvarchar](50) NULL,
[SortIndex] [nvarchar](50) NULL,
[LastYearValue] [nvarchar](50) NULL,
[ThisYearValue] [nvarchar](50) NULL,
[Rate] [nvarchar](50) NULL,
[BaseNumber] [nvarchar](50) NULL,
CONSTRAINT [PK_Environmental_ProjectChemicalReportItem] PRIMARY KEY CLUSTERED
(
[ChemicalReportItemId] 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].[Environmental_ProjectChemicalReportItem] WITH CHECK ADD CONSTRAINT [FK_Environmental_ProjectChemicalReportItem_Environmental_ProjectChemicalReport] FOREIGN KEY([ChemicalReportId])
REFERENCES [dbo].[Environmental_ProjectChemicalReport] ([ChemicalReportId])
GO
ALTER TABLE [dbo].[Environmental_ProjectChemicalReportItem] CHECK CONSTRAINT [FK_Environmental_ProjectChemicalReportItem_Environmental_ProjectChemicalReport]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReportItem', @level2type=N'COLUMN',@level2name=N'ChemicalReportItemId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'外键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReportItem', @level2type=N'COLUMN',@level2name=N'ChemicalReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上年累计完成值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReportItem', @level2type=N'COLUMN',@level2name=N'LastYearValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReportItem', @level2type=N'COLUMN',@level2name=N'ThisYearValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'与上年同期比较增减(%)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReportItem', @level2type=N'COLUMN',@level2name=N'Rate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'化工行业能源节约与生态环境保护汇总明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectChemicalReportItem'
GO
/*************化工行业能源节约与生态环境保护汇总表**************/
CREATE VIEW [dbo].[View_Environmental_ProjectChemicalReport]
AS
SELECT
Report.ChemicalReportId,
Report.ProjectId,
Report.FillingDate,
(ISNULL(Group_0008.ConstText,'-') + ISNULL(Group_0009.ConstText,'-')) AS ReportDate,
Group_0008.ConstText as YearStr,
Group_0009.ConstText as MonthStr,
U.ProjectName,
Report.Year,
Report.Month,
Report.UpState,
Report.DutyPerson
FROM dbo.Environmental_ProjectChemicalReport AS Report
LEFT JOIN Base_Project AS U ON U.ProjectId=Report.ProjectId
LEFT JOIN Sys_Const AS Group_0008 ON Group_0008.GroupId='0008' AND Group_0008.ConstValue =Report.[Year]
LEFT JOIN Sys_Const AS Group_0009 ON Group_0009.GroupId='0009' AND Group_0009.ConstValue =Report.[Month]
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('A44E98F6-E9FE-43F8-8349-C166263BF608','化工行业能源节约与生态环境保护汇总表','ZHGL/Environmental/ProjectChemicalReport.aspx',60,'C554E471-B740-4559-B543-E00F247289FD','Menu_HSSE',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('61C72BD2-4B76-4595-BFBF-0E9FEB6A7B80','A44E98F6-E9FE-43F8-8349-C166263BF608','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('504F9B5D-88F7-4ED7-B5F4-48AC089AABBF','A44E98F6-E9FE-43F8-8349-C166263BF608','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5208AF92-6632-4226-BC28-2392D3BF43FD','A44E98F6-E9FE-43F8-8349-C166263BF608','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('58B8415B-61C8-4D23-9AEE-1290E7FF8F2B','A44E98F6-E9FE-43F8-8349-C166263BF608','保存',4)
GO
CREATE TABLE [dbo].[Environmental_ProjectArchitectureReport](
[ArchitectureReportId] [nvarchar](50) NOT NULL,
[ProjectId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Quarters] [int] NULL,
[FillingMan] [nvarchar](50) NULL,
[FillingDate] [datetime] NULL,
[DutyPerson] [nvarchar](50) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Environmental_ProjectArchitectureReport] PRIMARY KEY CLUSTERED
(
[ArchitectureReportId] 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
ALTER TABLE [dbo].[Environmental_ProjectArchitectureReport] WITH CHECK ADD CONSTRAINT [FK_Environmental_ProjectArchitectureReport_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
GO
ALTER TABLE [dbo].[Environmental_ProjectArchitectureReport] CHECK CONSTRAINT [FK_Environmental_ProjectArchitectureReport_Base_Project]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReport', @level2type=N'COLUMN',@level2name=N'ArchitectureReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReport', @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'Environmental_ProjectArchitectureReport', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'月份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReport', @level2type=N'COLUMN',@level2name=N'Quarters'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReport', @level2type=N'COLUMN',@level2name=N'FillingMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReport', @level2type=N'COLUMN',@level2name=N'FillingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReport', @level2type=N'COLUMN',@level2name=N'DutyPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'建筑行业能源节约与生态环境保护汇总表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReport'
GO
CREATE TABLE [dbo].[Environmental_ProjectArchitectureReportItem](
[ArchitectureReportItemId] [nvarchar](50) NOT NULL,
[ArchitectureReportId] [nvarchar](50) NULL,
[SortIndex] [nvarchar](50) NULL,
[LastYearValue] [nvarchar](50) NULL,
[ThisYearValue] [nvarchar](50) NULL,
[Rate] [nvarchar](50) NULL,
[BaseNumber] [nvarchar](50) NULL,
CONSTRAINT [PK_Environmental_ProjectArchitectureReportItem] PRIMARY KEY CLUSTERED
(
[ArchitectureReportItemId] 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].[Environmental_ProjectArchitectureReportItem] WITH CHECK ADD CONSTRAINT [FK_Environmental_ProjectArchitectureReportItem_Environmental_ProjectArchitectureReport] FOREIGN KEY([ArchitectureReportId])
REFERENCES [dbo].[Environmental_ProjectArchitectureReport] ([ArchitectureReportId])
GO
ALTER TABLE [dbo].[Environmental_ProjectArchitectureReportItem] CHECK CONSTRAINT [FK_Environmental_ProjectArchitectureReportItem_Environmental_ProjectArchitectureReport]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'ArchitectureReportItemId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'外键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'ArchitectureReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上年累计完成值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'LastYearValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'ThisYearValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'与上年同期比较增减(%)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReportItem', @level2type=N'COLUMN',@level2name=N'Rate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'建筑行业能源节约与生态环境保护汇总明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectArchitectureReportItem'
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('25CE6894-2840-4DC4-AD2E-D72292849CEE','建筑行业能源节约与生态环境保护汇总表','ZHGL/Environmental/ProjectArchitectureReport.aspx',70,'C554E471-B740-4559-B543-E00F247289FD','Menu_HSSE',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5CDC4DA8-D6CE-49F8-962B-5A24A7A2CE66','25CE6894-2840-4DC4-AD2E-D72292849CEE','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('3066BA22-F86B-4B98-8FA1-914DDB95FB52','25CE6894-2840-4DC4-AD2E-D72292849CEE','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0B96AAC4-4E76-484F-932A-806BF910791D','25CE6894-2840-4DC4-AD2E-D72292849CEE','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('11C043C8-B557-4DDD-9E0A-64BC44BD3D7B','25CE6894-2840-4DC4-AD2E-D72292849CEE','保存',4)
GO
/*************建筑行业能源节约与生态环境保护汇总表**************/
CREATE VIEW [dbo].[View_Environmental_ProjectArchitectureReport]
AS
SELECT
Report.ArchitectureReportId,
Report.ProjectId,
Report.FillingDate,
(ISNULL(Group_0008.ConstText,'-') + ISNULL(Group_0011.ConstText,'-')) AS ReportDate,
Group_0008.ConstText as YearStr,
Group_0011.ConstText as QuartersStr,
U.ProjectName,
Report.Year,
Report.Quarters,
Report.UpState,
Report.DutyPerson
FROM dbo.Environmental_ProjectArchitectureReport AS Report
LEFT JOIN Base_Project AS U ON U.ProjectId=Report.ProjectId
LEFT JOIN Sys_Const AS Group_0008 ON Group_0008.GroupId='0008' AND Group_0008.ConstValue =Report.[Year]
LEFT JOIN Sys_Const AS Group_0011 ON Group_0011.GroupId='0011' AND Group_0011.ConstValue =Report.[Quarters]
GO
alter table [dbo].[Information_MillionsMonthlyReportItem] add DeathAccidentNum int null
GO
alter table [dbo].[Information_MillionsMonthlyReportItem] add DeathAccidentPersonNum int null
GO
alter table [dbo].[Information_MillionsMonthlyReportItem] add DeathAccidentLossHour int null
GO
alter table [dbo].[Information_MillionsMonthlyReportItem] add EnvironmenNum int null
GO
alter table [dbo].[InformationProject_MillionsMonthlyReport] add DeathAccidentNum int null
GO
alter table [dbo].[InformationProject_MillionsMonthlyReport] add DeathAccidentPersonNum int null
GO
alter table [dbo].[InformationProject_MillionsMonthlyReport] add DeathAccidentLossHour int null
GO
alter table [dbo].[InformationProject_MillionsMonthlyReport] add EnvironmenNum int null
GO
alter table Information_MillionsMonthlyReport add InputCosts decimal(18,4) null
alter table Information_MillionsMonthlyReport add TrainNum int null
alter table Information_MillionsMonthlyReport add GeneralHazardNum int null
alter table Information_MillionsMonthlyReport add MajorHazardNum int null
alter table Information_MillionsMonthlyReport add NotProofLargeProjectNum int null
alter table Information_MillionsMonthlyReport add ProofLargeProjectNum int null
alter table Information_MillionsMonthlyReport add FireLicenseNum int null
alter table Information_MillionsMonthlyReport add LimitLicenseNum int null
alter table Information_MillionsMonthlyReport add HighLicenseNum int null
alter table Information_MillionsMonthlyReport add HoistingLicenseNum int null
alter table Information_MillionsMonthlyReport add BreakGroundLicenseNum int null
alter table Information_MillionsMonthlyReport add ElectricityLicenseNum int null
alter table Information_MillionsMonthlyReport add RTLicenseNum int null
alter table Information_MillionsMonthlyReport add NightLicenseNum int null
alter table Information_MillionsMonthlyReport add CommissionerNum int null
alter table Information_MillionsMonthlyReport add SoleDutyNum int null
GO
alter table InformationProject_MillionsMonthlyReport add InputCosts decimal(18,4) null
alter table InformationProject_MillionsMonthlyReport add TrainNum int null
alter table InformationProject_MillionsMonthlyReport add GeneralHazardNum int null
alter table InformationProject_MillionsMonthlyReport add MajorHazardNum int null
alter table InformationProject_MillionsMonthlyReport add NotProofLargeProjectNum int null
alter table InformationProject_MillionsMonthlyReport add ProofLargeProjectNum int null
alter table InformationProject_MillionsMonthlyReport add FireLicenseNum int null
alter table InformationProject_MillionsMonthlyReport add LimitLicenseNum int null
alter table InformationProject_MillionsMonthlyReport add HighLicenseNum int null
alter table InformationProject_MillionsMonthlyReport add HoistingLicenseNum int null
alter table InformationProject_MillionsMonthlyReport add BreakGroundLicenseNum int null
alter table InformationProject_MillionsMonthlyReport add ElectricityLicenseNum int null
alter table InformationProject_MillionsMonthlyReport add RTLicenseNum int null
alter table InformationProject_MillionsMonthlyReport add NightLicenseNum int null
alter table InformationProject_MillionsMonthlyReport add CommissionerNum int null
alter table InformationProject_MillionsMonthlyReport add SoleDutyNum int null
GO
update [Sys_Menu] set [MenuName]='企业安全数据统计月报' where MenuId='3156A9F0-276D-4AD4-BF84-45CF6DFC215C'
update [Sys_Menu] set [MenuName]='企业安全数据统计月报' where MenuId='6E7DC075-A7AF-4E42-8F8B-0174EFDD54A1'
GO
delete from Sys_ButtonToMenu where MenuId='8B17DC64-A4B9-4283-B7A1-D2E944205FA5'
delete from [Sys_Menu] where MenuId='8B17DC64-A4B9-4283-B7A1-D2E944205FA5'
delete from Sys_ButtonToMenu where MenuId='A3894BAD-3F4A-4BB4-98CF-A76C588AE53F'
delete from [Sys_Menu] where MenuId='A3894BAD-3F4A-4BB4-98CF-A76C588AE53F'
GO
INSERT sys_menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed) VALUES ( N'7652D239-1897-4886-8DF2-B71E3B060D21',N'中央企业节能环保产业企业基本情况和经营情况报表',N'ZHGL/Environmental/OperationReport.aspx',200,N'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001',N'Menu_ZHGL',1,1,1)
go
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'6FF2A6A9-797D-4581-B3A6-4B0F55E40DA0',N'7652D239-1897-4886-8DF2-B71E3B060D21',N'增加',1)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'20C8D28A-51FC-4AE4-9545-A8D2C9C61CBB',N'7652D239-1897-4886-8DF2-B71E3B060D21',N'修改',2)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'0E3A8AA4-0E0E-4A47-9B70-74503ACAB056',N'7652D239-1897-4886-8DF2-B71E3B060D21',N'删除',3)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'84A185EC-13CD-4C09-A415-F666138877AC',N'7652D239-1897-4886-8DF2-B71E3B060D21',N'保存',4)
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'87F2FE97-0CCA-4F42-B297-43DC026334FF',N'7652D239-1897-4886-8DF2-B71E3B060D21',N'保存并上报',5)
go
CREATE TABLE [dbo].[Environmental_OperationReport](
[BusinessReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Quarters] [int] NULL,
[Code] [nvarchar](50) NULL,
[UnitLevel] [nvarchar](50) NULL,
[CreateDate] [datetime] NULL,
[Place] [nvarchar](200) NULL,
[PersonNum] [int] NULL,
[TotalAssets] [decimal](18, 4) NULL,
[TotalValue] [decimal](18, 4) NULL,
[NewInvestment] [decimal](18, 4) NULL,
[FillingMan] [nvarchar](50) NULL,
[FillingDate] [datetime] NULL,
[StatisticsDutyPerson] [nvarchar](50) NULL,
[UnitDutyPerson] [nvarchar](50) NULL,
[Remark] [nvarchar](500) NULL,
CONSTRAINT [PK_Environmental_OperationReport] PRIMARY KEY CLUSTERED
(
[BusinessReportId] 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].[Environmental_OperationReport] WITH CHECK ADD CONSTRAINT [FK_Environmental_OperationReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Environmental_OperationReport] CHECK CONSTRAINT [FK_Environmental_OperationReport_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'BusinessReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'季度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'Quarters'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'Code'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'企业层级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'UnitLevel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成立时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所在地' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'Place'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职工人数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'PersonNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'资产总额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'TotalAssets'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'总产值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'TotalValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新增投资' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'NewInvestment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填表人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'FillingMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'FillingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'统计负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'StatisticsDutyPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @level2type=N'COLUMN',@level2name=N'UnitDutyPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_OperationReport', @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'Environmental_OperationReport'
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('EFA6E45F-1267-4804-BEE7-41E0C5461204','中央企业节能环保产业企业基本情况和经营情况报表','ZHGL/Environmental/ProjectOperationReport.aspx',170,'C554E471-B740-4559-B543-E00F247289FD','Menu_HSSE',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D8F40684-8EE9-4E79-B18E-FFA339E3B441','EFA6E45F-1267-4804-BEE7-41E0C5461204','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('9BF9DDC9-66C5-4FB2-8AA6-B0B748F41F56','EFA6E45F-1267-4804-BEE7-41E0C5461204','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('DD2E36DE-C736-4D96-9972-D686C8A1ED23','EFA6E45F-1267-4804-BEE7-41E0C5461204','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('220E0F3B-1254-46DA-AF9A-9C21CA3EFEF8','EFA6E45F-1267-4804-BEE7-41E0C5461204','保存',4)
GO
CREATE TABLE [dbo].[Environmental_ProjectOperationReport](
[BusinessReportId] [nvarchar](50) NOT NULL,
[ProjectId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Quarters] [int] NULL,
[Code] [nvarchar](50) NULL,
[PersonNum] [int] NULL,
[TotalAssets] [decimal](18, 4) NULL,
[TotalValue] [decimal](18, 4) NULL,
[NewInvestment] [decimal](18, 4) NULL,
[FillingMan] [nvarchar](50) NULL,
[FillingDate] [datetime] NULL,
[StatisticsDutyPerson] [nvarchar](50) NULL,
[Remark] [nvarchar](500) NULL,
CONSTRAINT [PK_Environmental_ProjectOperationReport] PRIMARY KEY CLUSTERED
(
[BusinessReportId] 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].[Environmental_ProjectOperationReport] WITH CHECK ADD CONSTRAINT [FK_Environmental_ProjectOperationReport_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
GO
ALTER TABLE [dbo].[Environmental_ProjectOperationReport] CHECK CONSTRAINT [FK_Environmental_ProjectOperationReport_Base_Project]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'BusinessReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @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'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'季度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'Quarters'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'Code'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职工人数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'PersonNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'资产总额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'TotalAssets'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'总产值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'TotalValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新增投资' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'NewInvestment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填表人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'FillingMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'FillingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'统计负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @level2type=N'COLUMN',@level2name=N'StatisticsDutyPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectOperationReport', @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'Environmental_ProjectOperationReport'
GO
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('FB174DD6-CBAE-43AF-9356-B098A17B719D','安全管理工作总结报告','HSSE/InformationProject/WorkSummaryReport.aspx',60,'C554E471-B740-4559-B543-E00F247289FD','Menu_HSSE',0,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('22B517A8-7267-483D-8D25-DC46DA4781A2','FB174DD6-CBAE-43AF-9356-B098A17B719D','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('0118B4F5-C954-4FD7-9D63-6BF46BD63555','FB174DD6-CBAE-43AF-9356-B098A17B719D','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('2A952B21-96B8-4647-BBFD-5C9F8A71FF96','FB174DD6-CBAE-43AF-9356-B098A17B719D','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('A3D4C846-E1AE-4EBC-A13E-6565EBCD8921','FB174DD6-CBAE-43AF-9356-B098A17B719D','保存',4)
go
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('1443C901-A9C3-4CCC-B858-55512DE8C5CA','质量管理工作总结报告','CQMS/ManageReport/QualityWorkSummaryReport.aspx',20,'7ecf0229-8a0b-40ce-8b04-e556f7bd3394','Menu_CQMS',0,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('7A6247ED-5953-4A97-8C9A-25D592B19D9E','1443C901-A9C3-4CCC-B858-55512DE8C5CA','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('C87345B5-882C-4F02-86F1-65B53CBEAA79','1443C901-A9C3-4CCC-B858-55512DE8C5CA','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('95349CD9-4EC8-47BA-8B6D-2A5AD8D48234','1443C901-A9C3-4CCC-B858-55512DE8C5CA','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('DF651BA5-4F8E-469F-ADF2-0538C37445EC','1443C901-A9C3-4CCC-B858-55512DE8C5CA','保存',4)
go
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('267064F1-88F7-4468-998A-49A1A2F25BB8','季度工程项目质量信息表','CQMS/ManageReport/QuarterlyProjectQuality.aspx',30,'7ecf0229-8a0b-40ce-8b04-e556f7bd3394','Menu_CQMS',0,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('E826DFE2-76B9-4C39-82E4-5E8541F1A603','267064F1-88F7-4468-998A-49A1A2F25BB8','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('47653071-D7D5-4BC7-8351-479FB7C49840','267064F1-88F7-4468-998A-49A1A2F25BB8','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('F4CE6F86-AB36-4AED-B449-2E8DA69B5278','267064F1-88F7-4468-998A-49A1A2F25BB8','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('8E5ABEC0-1D1B-4479-99F0-FB778BBE43E4','267064F1-88F7-4468-998A-49A1A2F25BB8','保存',4)
go
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('86F71934-7149-470E-BEAB-FFDC5BF3C0F2','实业安全简报','SHIYE/InformationProject/SafetyBriefing.aspx',10,'C554E471-B740-4559-B543-E00F247289FD','Menu_HSSE',1,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('90297D4C-047D-4E24-8FCB-3B216846B94E','86F71934-7149-470E-BEAB-FFDC5BF3C0F2','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('A7F2EF10-6EE2-468F-93E4-BAE3051920C0','86F71934-7149-470E-BEAB-FFDC5BF3C0F2','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('08156CE2-51A2-42A7-BDCF-5840D514445B','86F71934-7149-470E-BEAB-FFDC5BF3C0F2','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('1AED7984-B050-4EAF-9CD5-D25CF500B61F','86F71934-7149-470E-BEAB-FFDC5BF3C0F2','保存',4)
go
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('AAC7C263-6E25-49DC-985B-DC3FA7AAF3A1','实业安全简报','ZHGL/Information/SafetyBriefing.aspx',110,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('135DC125-8594-4AEF-AF99-F98890ACCA28','AAC7C263-6E25-49DC-985B-DC3FA7AAF3A1','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('6EC0B8E7-4612-4D41-8274-8CAA884A23C5','AAC7C263-6E25-49DC-985B-DC3FA7AAF3A1','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('C610B07D-5AC7-4135-97C8-F926AD8AD6D1','AAC7C263-6E25-49DC-985B-DC3FA7AAF3A1','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('FBA6A803-B81B-4415-BAF3-B998BE113AA6','AAC7C263-6E25-49DC-985B-DC3FA7AAF3A1','保存',4)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('C4ACDB39-C54D-48FF-8612-1E805E023B3D','AAC7C263-6E25-49DC-985B-DC3FA7AAF3A1','保存并上报',5)
go
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('CF9C1F00-34B8-42E5-B2D1-704094169CA3','季度工程项目质量信息表','ZHGL/Information/QuarterlyProjectQuality.aspx',120,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('FA8D2BB9-0C94-420A-BD04-96A6CE473552','CF9C1F00-34B8-42E5-B2D1-704094169CA3','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('8D88009F-F4DB-4D91-82DD-936FC68690F1','CF9C1F00-34B8-42E5-B2D1-704094169CA3','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('E9DE1C73-803B-45DC-8F76-517521183EEA','CF9C1F00-34B8-42E5-B2D1-704094169CA3','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('DA437AA6-0728-444E-9A42-D48443606475','CF9C1F00-34B8-42E5-B2D1-704094169CA3','保存',4)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('A5156A57-B748-4F59-955B-1B37444694CF','CF9C1F00-34B8-42E5-B2D1-704094169CA3','保存并上报',5)
go
CREATE TABLE [dbo].[InformationProject_WorkSummaryReport](
[WorkSummaryReportId] [nvarchar](50) NOT NULL,
[ProjectId] [nvarchar](50) NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[ResponsiblePersonTel] [nvarchar](50) NULL,
[ContactPerson] [nvarchar](50) NULL,
[ContactPersonTel] [nvarchar](50) NULL,
[ReportDate] [datetime] NULL,
[SafeLaborTime] [decimal](18, 2) NULL,
[SafetyObjectives] [nvarchar](500) NULL,
[AccidentSituation] [nvarchar](500) NULL,
[Awards] [nvarchar](500) NULL,
[WorkDevelopment] [nvarchar](500) NULL,
[PersonnelTraining] [nvarchar](500) NULL,
[GovernanceSituation] [nvarchar](500) NULL,
[ManagementActivity] [nvarchar](500) NULL,
[WorkExperience] [nvarchar](500) NULL,
[Countermeasures] [nvarchar](500) NULL,
[NextYearWorkPlan] [nvarchar](500) NULL,
[JobSuggestion] [nvarchar](500) NULL,
[CompileMan] [nvarchar](50) NULL,
[CompileDate] [datetime] NULL,
CONSTRAINT [PK_InformationProject_WorkSummaryReport] PRIMARY KEY CLUSTERED
(
[WorkSummaryReportId] 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].[InformationProject_WorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_InformationProject_WorkSummaryReport_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
GO
ALTER TABLE [dbo].[InformationProject_WorkSummaryReport] CHECK CONSTRAINT [FK_InformationProject_WorkSummaryReport_Base_Project]
GO
ALTER TABLE [dbo].[InformationProject_WorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_InformationProject_WorkSummaryReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[InformationProject_WorkSummaryReport] CHECK CONSTRAINT [FK_InformationProject_WorkSummaryReport_Base_Unit]
GO
ALTER TABLE [dbo].[InformationProject_WorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_InformationProject_WorkSummaryReport_Sys_User] FOREIGN KEY([CompileMan])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[InformationProject_WorkSummaryReport] CHECK CONSTRAINT [FK_InformationProject_WorkSummaryReport_Sys_User]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报告时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ReportDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全人工时' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'SafeLaborTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全目标及完成情况（按责任书相应内容进行总结）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'SafetyObjectives'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全事故情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'AccidentSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'获奖情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Awards'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'重点工作开展情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkDevelopment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员培训情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'PersonnelTraining'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织开展安全监督检查、隐患排查治理情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'GovernanceSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全月、职业健康宣传周等其他管理活动情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ManagementActivity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要工作经验及亮点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkExperience'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要问题及应对措施' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Countermeasures'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下一年度工作计划打算' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'NextYearWorkPlan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对集团公司的工作建议' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'JobSuggestion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_WorkSummaryReport', @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'InformationProject_WorkSummaryReport', @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'InformationProject_WorkSummaryReport'
GO
CREATE TABLE [dbo].[InformationProject_QualityWorkSummaryReport](
[QualityWorkSummaryReportId] [nvarchar](50) NOT NULL,
[ProjectId] [nvarchar](50) NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[ResponsiblePersonTel] [nvarchar](50) NULL,
[ContactPerson] [nvarchar](50) NULL,
[ContactPersonTel] [nvarchar](50) NULL,
[ReportDate] [datetime] NULL,
[Performance] [nvarchar](500) NULL,
[AccidentSituation] [nvarchar](500) NULL,
[Awards] [nvarchar](500) NULL,
[WorkDevelopment] [nvarchar](500) NULL,
[PersonnelTraining] [nvarchar](500) NULL,
[CheckSituation] [nvarchar](500) NULL,
[ManagementActivity] [nvarchar](500) NULL,
[WorkExperience] [nvarchar](500) NULL,
[Countermeasures] [nvarchar](500) NULL,
[NextYearWorkPlan] [nvarchar](500) NULL,
[JobSuggestion] [nvarchar](500) NULL,
[CompileMan] [nvarchar](50) NULL,
[CompileDate] [datetime] NULL,
CONSTRAINT [PK_InformationProject_QualityWorkSummaryReport] PRIMARY KEY CLUSTERED
(
[QualityWorkSummaryReportId] 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].[InformationProject_QualityWorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_InformationProject_QualityWorkSummaryReport_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
GO
ALTER TABLE [dbo].[InformationProject_QualityWorkSummaryReport] CHECK CONSTRAINT [FK_InformationProject_QualityWorkSummaryReport_Base_Project]
GO
ALTER TABLE [dbo].[InformationProject_QualityWorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_InformationProject_QualityWorkSummaryReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[InformationProject_QualityWorkSummaryReport] CHECK CONSTRAINT [FK_InformationProject_QualityWorkSummaryReport_Base_Unit]
GO
ALTER TABLE [dbo].[InformationProject_QualityWorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_InformationProject_QualityWorkSummaryReport_Sys_User] FOREIGN KEY([CompileMan])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[InformationProject_QualityWorkSummaryReport] CHECK CONSTRAINT [FK_InformationProject_QualityWorkSummaryReport_Sys_User]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报告时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ReportDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量管理绩效（单位工程质量状况等）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Performance'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量事故情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'AccidentSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'获奖情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Awards'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量提升行动、质量首件及质量管理重点工作开展情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkDevelopment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员培训情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'PersonnelTraining'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织开展质量监督检查情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'CheckSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量月等其他管理活动情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ManagementActivity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要工作经验及亮点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkExperience'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要问题及应对措施' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Countermeasures'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下一年度工作计划打算' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'NextYearWorkPlan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对集团公司的工作建议' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'JobSuggestion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QualityWorkSummaryReport', @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'InformationProject_QualityWorkSummaryReport', @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'InformationProject_QualityWorkSummaryReport'
GO
CREATE TABLE [dbo].[InformationProject_SafetyBriefing](
[SafetyBriefingId] [nvarchar](50) NOT NULL,
[ProjectId] [nvarchar](50) NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[Month] [int] NULL,
[CompileMan] [nvarchar](50) NULL,
[CompileDate] [datetime] NULL,
[Auditor] [nvarchar](50) NULL,
[Approver] [nvarchar](50) NULL,
[MainWork] [nvarchar](500) NULL,
[HazardRecording] [nvarchar](500) NULL,
[SafetyAccident] [nvarchar](50) NULL,
[EPAccident] [nvarchar](50) NULL,
[OHAccident] [nvarchar](50) NULL,
[WorkPermitNum] [nvarchar](500) NULL,
[HiddenDangerDetection] [nvarchar](500) NULL,
[RectificationSituation] [nvarchar](500) NULL,
[CheckProblemsRectification] [nvarchar](500) NULL,
[PendingProject] [nvarchar](500) NULL,
[ContractorManagement] [nvarchar](500) NULL,
[EnvironmentalEmissions] [nvarchar](500) NULL,
[NextMonthWorkPlan] [nvarchar](500) NULL,
CONSTRAINT [PK_InfomationProject_SafetyBriefing] PRIMARY KEY CLUSTERED
(
[SafetyBriefingId] 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].[InformationProject_SafetyBriefing] WITH CHECK ADD CONSTRAINT [FK_InfomationProject_SafetyBriefing_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
GO
ALTER TABLE [dbo].[InformationProject_SafetyBriefing] CHECK CONSTRAINT [FK_InfomationProject_SafetyBriefing_Base_Project]
GO
ALTER TABLE [dbo].[InformationProject_SafetyBriefing] WITH CHECK ADD CONSTRAINT [FK_InfomationProject_SafetyBriefing_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[InformationProject_SafetyBriefing] CHECK CONSTRAINT [FK_InfomationProject_SafetyBriefing_Base_Unit]
GO
ALTER TABLE [dbo].[InformationProject_SafetyBriefing] WITH CHECK ADD CONSTRAINT [FK_InfomationProject_SafetyBriefing_Sys_User] FOREIGN KEY([CompileMan])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[InformationProject_SafetyBriefing] CHECK CONSTRAINT [FK_InfomationProject_SafetyBriefing_Sys_User]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'SafetyBriefingId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @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'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'月' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'Month'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编制人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @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'InformationProject_SafetyBriefing', @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'InformationProject_SafetyBriefing', @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'InformationProject_SafetyBriefing', @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'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'MainWork'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'重大危险源备案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'HazardRecording'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全事故' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'SafetyAccident'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'环保事故' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'EPAccident'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职业卫生事故' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'OHAccident'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业许可证数量统计' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'WorkPermitNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本月隐患排查项目' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'HiddenDangerDetection'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本月隐患整改完成情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'RectificationSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'集团检查问题整改情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'CheckProblemsRectification'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'待完成的隐患整改项目' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'PendingProject'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'承包商管理' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'ContractorManagement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'环保排放量及达标情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'EnvironmentalEmissions'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下月安全工作计划' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'NextMonthWorkPlan'
GO
CREATE TABLE [dbo].[Information_SafetyBriefing](
[SafetyBriefingId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[Month] [int] NULL,
[CompileMan] [nvarchar](50) NULL,
[CompileDate] [datetime] NULL,
[Auditor] [nvarchar](50) NULL,
[Approver] [nvarchar](50) NULL,
[MainWork] [nvarchar](max) NULL,
[HazardRecording] [nvarchar](max) NULL,
[SafetyAccident] [nvarchar](max) NULL,
[EPAccident] [nvarchar](max) NULL,
[OHAccident] [nvarchar](max) NULL,
[WorkPermitNum] [nvarchar](max) NULL,
[HiddenDangerDetection] [nvarchar](max) NULL,
[RectificationSituation] [nvarchar](max) NULL,
[CheckProblemsRectification] [nvarchar](max) NULL,
[PendingProject] [nvarchar](max) NULL,
[ContractorManagement] [nvarchar](max) NULL,
[EnvironmentalEmissions] [nvarchar](max) NULL,
[NextMonthWorkPlan] [nvarchar](max) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Infomation_SafetyBriefing] PRIMARY KEY CLUSTERED
(
[SafetyBriefingId] 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
ALTER TABLE [dbo].[Information_SafetyBriefing] WITH CHECK ADD CONSTRAINT [FK_Information_SafetyBriefing_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Information_SafetyBriefing] CHECK CONSTRAINT [FK_Information_SafetyBriefing_Base_Unit]
GO
ALTER TABLE [dbo].[Information_SafetyBriefing] WITH CHECK ADD CONSTRAINT [FK_Information_SafetyBriefing_Sys_User] FOREIGN KEY([CompileMan])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[Information_SafetyBriefing] CHECK CONSTRAINT [FK_Information_SafetyBriefing_Sys_User]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'SafetyBriefingId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'月' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'Month'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编制人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @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'Information_SafetyBriefing', @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'Information_SafetyBriefing', @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'Information_SafetyBriefing', @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'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'MainWork'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'重大危险源备案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'HazardRecording'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全事故' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'SafetyAccident'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'环保事故' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'EPAccident'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职业卫生事故' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'OHAccident'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业许可证数量统计' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'WorkPermitNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本月隐患排查项目' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'HiddenDangerDetection'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本月隐患整改完成情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'RectificationSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'集团检查问题整改情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'CheckProblemsRectification'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'待完成的隐患整改项目' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'PendingProject'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'承包商管理' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'ContractorManagement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'环保排放量及达标情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'EnvironmentalEmissions'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下月安全工作计划' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_SafetyBriefing', @level2type=N'COLUMN',@level2name=N'NextMonthWorkPlan'
GO
CREATE TABLE [dbo].[InformationProject_QuarterlyProjectQuality](
[QuarterlyProjectQualityId] [nvarchar](50) NOT NULL,
[ProjectId] [nvarchar](50) NULL,
[UnitId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Quarter] [int] NULL,
[QualityManagePersonNum] [int] NULL,
[AdvancedTitlePersonNum] [int] NULL,
[IntermediateTitlePersonNum] [int] NULL,
[BeImplementedProjectNum] [int] NULL,
[StartImplementedProjectNum] [int] NULL,
[AccumulativeStartImplemented] [int] NULL,
[CompleteProjectNum] [int] NULL,
[YearCompleteProjectNum] [int] NULL,
[QuarterTotal] [int] NULL,
[QuarterFirstPassNum] [int] NULL,
[QuarterFirstPassRate] [decimal](18, 2) NULL,
[YearTotal] [int] NULL,
[YearFirstPassNum] [int] NULL,
[YearFirstPassRate] [decimal](18, 2) NULL,
[QuaterCheckSuperviseNum] [int] NULL,
[QuaterCorrectiveNoticeNum] [int] NULL,
[QuaterQualityProblemNum] [int] NULL,
[QuaterClosedQualityProblemNum] [int] NULL,
[YearCheckSuperviseNum] [int] NULL,
[YearCorrectiveNoticeNum] [int] NULL,
[YearQualityProblemNum] [int] NULL,
[YearClosedQualityProblemNum] [int] NULL,
[QuaterQualityAccidentNum] [int] NULL,
[QuaterDirectEconomicLoss] [decimal](18, 2) NULL,
[YearQualityAccidentNum] [int] NULL,
[YearDirectEconomicLoss] [decimal](18, 2) NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[CompileMan] [nvarchar](50) NULL,
[CompileDate] [datetime] NULL,
[Tel] [nvarchar](50) NULL,
CONSTRAINT [PK_InformationProject_QuarterlyProjectQuality] PRIMARY KEY CLUSTERED
(
[QuarterlyProjectQualityId] 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].[InformationProject_QuarterlyProjectQuality] WITH CHECK ADD CONSTRAINT [FK_InformationProject_QuarterlyProjectQuality_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
GO
ALTER TABLE [dbo].[InformationProject_QuarterlyProjectQuality] CHECK CONSTRAINT [FK_InformationProject_QuarterlyProjectQuality_Base_Project]
GO
ALTER TABLE [dbo].[InformationProject_QuarterlyProjectQuality] WITH CHECK ADD CONSTRAINT [FK_InformationProject_QuarterlyProjectQuality_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[InformationProject_QuarterlyProjectQuality] CHECK CONSTRAINT [FK_InformationProject_QuarterlyProjectQuality_Base_Unit]
GO
ALTER TABLE [dbo].[InformationProject_QuarterlyProjectQuality] WITH CHECK ADD CONSTRAINT [FK_InformationProject_QuarterlyProjectQuality_Sys_User] FOREIGN KEY([CompileMan])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[InformationProject_QuarterlyProjectQuality] CHECK CONSTRAINT [FK_InformationProject_QuarterlyProjectQuality_Sys_User]
GO
ALTER TABLE [dbo].[InformationProject_QuarterlyProjectQuality] WITH CHECK ADD CONSTRAINT [FK_InformationProject_QuarterlyProjectQuality_Sys_User1] FOREIGN KEY([ResponsiblePerson])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[InformationProject_QuarterlyProjectQuality] CHECK CONSTRAINT [FK_InformationProject_QuarterlyProjectQuality_Sys_User1]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuarterlyProjectQualityId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'ProjectId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'季度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'Quarter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专职质量管理人员数（人）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QualityManagePersonNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其中具有高级职称人数（人）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'AdvancedTitlePersonNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其中具有中级职称人数（人）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'IntermediateTitlePersonNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度正在实施项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'BeImplementedProjectNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度开始实施项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'StartImplementedProjectNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计开始实施项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'AccumulativeStartImplemented'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度完成（竣工）项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'CompleteProjectNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成（竣工）项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearCompleteProjectNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度完成总数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuarterTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度完成一次合格数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuarterFirstPassNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度完成一次合格率' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuarterFirstPassRate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成总数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成一次合格数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearFirstPassNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成一次合格率' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearFirstPassRate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度开展质量监督检查次数（次）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterCheckSuperviseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度发出质量整改通知单份数（份）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterCorrectiveNoticeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度涉及质量问题项数（项）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterQualityProblemNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度已关闭质量问题项数（项）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterClosedQualityProblemNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成开展质量监督检查次数（次）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearCheckSuperviseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成发出质量整改通知单份数（份）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearCorrectiveNoticeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成涉及质量问题项数（项）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearQualityProblemNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成已关闭质量问题项数（项）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearClosedQualityProblemNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'较大及以上质量事故情况-本季度-发生起数（起）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterQualityAccidentNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'较大及以上质量事故情况-本季度-直接经济损失（万元）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterDirectEconomicLoss'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'较大及以上质量事故情况-本年度-发生起数（起）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearQualityAccidentNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'较大及以上质量事故情况-本年度-直接经济损失（万元）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearDirectEconomicLoss'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报单位负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N' 填报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality', @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'InformationProject_QuarterlyProjectQuality', @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'InformationProject_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'Tel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'季度工程项目质量信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'InformationProject_QuarterlyProjectQuality'
GO
--drop table Information_QuarterlyProjectQuality
CREATE TABLE [dbo].[Information_QuarterlyProjectQuality](
[QuarterlyProjectQualityId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Quarter] [int] NULL,
[QualityManagePersonNum] [int] NULL,
[AdvancedTitlePersonNum] [int] NULL,
[IntermediateTitlePersonNum] [int] NULL,
[BeImplementedProjectNum] [int] NULL,
[StartImplementedProjectNum] [int] NULL,
[AccumulativeStartImplemented] [int] NULL,
[CompleteProjectNum] [int] NULL,
[YearCompleteProjectNum] [int] NULL,
[QuarterTotal] [int] NULL,
[QuarterFirstPassNum] [int] NULL,
[QuarterFirstPassRate] [decimal](18, 2) NULL,
[YearTotal] [int] NULL,
[YearFirstPassNum] [int] NULL,
[YearFirstPassRate] [decimal](18, 2) NULL,
[QuaterCheckSuperviseNum] [int] NULL,
[QuaterCorrectiveNoticeNum] [int] NULL,
[QuaterQualityProblemNum] [int] NULL,
[QuaterClosedQualityProblemNum] [int] NULL,
[YearCheckSuperviseNum] [int] NULL,
[YearCorrectiveNoticeNum] [int] NULL,
[YearQualityProblemNum] [int] NULL,
[YearClosedQualityProblemNum] [int] NULL,
[QuaterQualityAccidentNum] [int] NULL,
[QuaterDirectEconomicLoss] [decimal](18, 2) NULL,
[YearQualityAccidentNum] [int] NULL,
[YearDirectEconomicLoss] [decimal](18, 2) NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[CompileMan] [nvarchar](50) NULL,
[CompileDate] [datetime] NULL,
[Tel] [nvarchar](50) NULL,
[UpState] [nvarchar](50) NULL,
CONSTRAINT [PK_Information_QuarterlyProjectQuality] PRIMARY KEY CLUSTERED
(
[QuarterlyProjectQualityId] 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].[Information_QuarterlyProjectQuality] WITH CHECK ADD CONSTRAINT [FK_Information_QuarterlyProjectQuality_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Information_QuarterlyProjectQuality] CHECK CONSTRAINT [FK_Information_QuarterlyProjectQuality_Base_Unit]
GO
ALTER TABLE [dbo].[Information_QuarterlyProjectQuality] WITH CHECK ADD CONSTRAINT [FK_Information_QuarterlyProjectQuality_Sys_User] FOREIGN KEY([CompileMan])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[Information_QuarterlyProjectQuality] CHECK CONSTRAINT [FK_Information_QuarterlyProjectQuality_Sys_User]
GO
ALTER TABLE [dbo].[Information_QuarterlyProjectQuality] WITH CHECK ADD CONSTRAINT [FK_Information_QuarterlyProjectQuality_Sys_User1] FOREIGN KEY([ResponsiblePerson])
REFERENCES [dbo].[Sys_User] ([UserId])
GO
ALTER TABLE [dbo].[Information_QuarterlyProjectQuality] CHECK CONSTRAINT [FK_Information_QuarterlyProjectQuality_Sys_User1]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuarterlyProjectQualityId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'季度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'Quarter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专职质量管理人员数（人）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QualityManagePersonNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其中具有高级职称人数（人）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'AdvancedTitlePersonNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其中具有中级职称人数（人）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'IntermediateTitlePersonNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度正在实施项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'BeImplementedProjectNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度开始实施项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'StartImplementedProjectNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计开始实施项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'AccumulativeStartImplemented'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度完成（竣工）项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'CompleteProjectNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成（竣工）项目数量（个）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearCompleteProjectNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度完成总数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuarterTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度完成一次合格数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuarterFirstPassNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度完成一次合格率' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuarterFirstPassRate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成总数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成一次合格数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearFirstPassNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成一次合格率' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearFirstPassRate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度开展质量监督检查次数（次）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterCheckSuperviseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度发出质量整改通知单份数（份）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterCorrectiveNoticeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度涉及质量问题项数（项）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterQualityProblemNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季度已关闭质量问题项数（项）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterClosedQualityProblemNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成开展质量监督检查次数（次）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearCheckSuperviseNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成发出质量整改通知单份数（份）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearCorrectiveNoticeNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成涉及质量问题项数（项）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearQualityProblemNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年累计完成已关闭质量问题项数（项）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearClosedQualityProblemNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'较大及以上质量事故情况-本季度-发生起数（起）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterQualityAccidentNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'较大及以上质量事故情况-本季度-直接经济损失（万元）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'QuaterDirectEconomicLoss'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'较大及以上质量事故情况-本年度-发生起数（起）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearQualityAccidentNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'较大及以上质量事故情况-本年度-直接经济损失（万元）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'YearDirectEconomicLoss'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报单位负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N' 填报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality', @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'Information_QuarterlyProjectQuality', @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'Information_QuarterlyProjectQuality', @level2type=N'COLUMN',@level2name=N'Tel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'季度工程项目质量信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QuarterlyProjectQuality'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'JobSuggestion'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'NextYearWorkPlan'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Countermeasures'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkExperience'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ManagementActivity'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'GovernanceSituation'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'PersonnelTraining'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkDevelopment'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Awards'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'AccidentSituation'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'SafetyObjectives'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'SafeLaborTime'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ReportDate'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPersonTel'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPerson'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePersonTel'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
ALTER TABLE [dbo].[Information_WorkSummaryReport] DROP CONSTRAINT [FK_Information_WorkSummaryReport_Base_Unit]
GO
/****** Object: Table [dbo].[Information_WorkSummaryReport] Script Date: 2023/3/25 22:34:19 ******/
DROP TABLE [dbo].[Information_WorkSummaryReport]
GO
/****** Object: Table [dbo].[Information_WorkSummaryReport] Script Date: 2023/3/25 22:34:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Information_WorkSummaryReport](
[WorkSummaryReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[ResponsiblePersonTel] [nvarchar](50) NULL,
[ContactPerson] [nvarchar](50) NULL,
[ContactPersonTel] [nvarchar](50) NULL,
[ReportDate] [datetime] NULL,
[SafeLaborTime] [decimal](18, 2) NULL,
[SafetyObjectives] [nvarchar](max) NULL,
[AccidentSituation] [nvarchar](max) NULL,
[Awards] [nvarchar](max) NULL,
[WorkDevelopment] [nvarchar](max) NULL,
[PersonnelTraining] [nvarchar](max) NULL,
[GovernanceSituation] [nvarchar](max) NULL,
[ManagementActivity] [nvarchar](max) NULL,
[WorkExperience] [nvarchar](max) NULL,
[Countermeasures] [nvarchar](max) NULL,
[NextYearWorkPlan] [nvarchar](max) NULL,
[JobSuggestion] [nvarchar](max) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Information_WorkSummaryReport] PRIMARY KEY CLUSTERED
(
[WorkSummaryReportId] 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
ALTER TABLE [dbo].[Information_WorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_Information_WorkSummaryReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Information_WorkSummaryReport] CHECK CONSTRAINT [FK_Information_WorkSummaryReport_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报告时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ReportDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全人工时' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'SafeLaborTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全目标及完成情况（按责任书相应内容进行总结）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'SafetyObjectives'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全事故情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'AccidentSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'获奖情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Awards'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'重点工作开展情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkDevelopment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员培训情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'PersonnelTraining'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织开展安全监督检查、隐患排查治理情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'GovernanceSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全月、职业健康宣传周等其他管理活动情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ManagementActivity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要工作经验及亮点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkExperience'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要问题及应对措施' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Countermeasures'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下一年度工作计划打算' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'NextYearWorkPlan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对集团公司的工作建议' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport', @level2type=N'COLUMN',@level2name=N'JobSuggestion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全管理工作总结报告' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_WorkSummaryReport'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'JobSuggestion'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'NextYearWorkPlan'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Countermeasures'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkExperience'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ManagementActivity'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'CheckSituation'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'PersonnelTraining'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkDevelopment'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Awards'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'AccidentSituation'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Performance'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ReportDate'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPersonTel'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPerson'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePersonTel'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
ALTER TABLE [dbo].[Information_QualityWorkSummaryReport] DROP CONSTRAINT [FK_Information_QualityWorkSummaryReport_Base_Unit]
GO
/****** Object: Table [dbo].[Information_QualityWorkSummaryReport] Script Date: 2023/3/25 22:34:49 ******/
DROP TABLE [dbo].[Information_QualityWorkSummaryReport]
GO
/****** Object: Table [dbo].[Information_QualityWorkSummaryReport] Script Date: 2023/3/25 22:34:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Information_QualityWorkSummaryReport](
[QualityWorkSummaryReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[ResponsiblePersonTel] [nvarchar](50) NULL,
[ContactPerson] [nvarchar](50) NULL,
[ContactPersonTel] [nvarchar](50) NULL,
[ReportDate] [datetime] NULL,
[Performance] [nvarchar](max) NULL,
[AccidentSituation] [nvarchar](max) NULL,
[Awards] [nvarchar](max) NULL,
[WorkDevelopment] [nvarchar](max) NULL,
[PersonnelTraining] [nvarchar](max) NULL,
[CheckSituation] [nvarchar](max) NULL,
[ManagementActivity] [nvarchar](max) NULL,
[WorkExperience] [nvarchar](max) NULL,
[Countermeasures] [nvarchar](max) NULL,
[NextYearWorkPlan] [nvarchar](max) NULL,
[JobSuggestion] [nvarchar](max) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Information_QualityWorkSummaryReport] PRIMARY KEY CLUSTERED
(
[QualityWorkSummaryReportId] 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
ALTER TABLE [dbo].[Information_QualityWorkSummaryReport] WITH CHECK ADD CONSTRAINT [FK_Information_QualityWorkSummaryReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Information_QualityWorkSummaryReport] CHECK CONSTRAINT [FK_Information_QualityWorkSummaryReport_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'YearId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ResponsiblePersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ContactPersonTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报告时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ReportDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量管理绩效（单位工程质量状况等）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Performance'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量事故情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'AccidentSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'获奖情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Awards'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量提升行动、质量首件及质量管理重点工作开展情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkDevelopment'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员培训情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'PersonnelTraining'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织开展质量监督检查情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'CheckSituation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量月等其他管理活动情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'ManagementActivity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要工作经验及亮点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'WorkExperience'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要问题及应对措施' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'Countermeasures'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下一年度工作计划打算' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'NextYearWorkPlan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对集团公司的工作建议' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport', @level2type=N'COLUMN',@level2name=N'JobSuggestion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质量管理工作总结报告' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information_QualityWorkSummaryReport'
GO
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('FD572EFA-8E87-43D1-B514-25A39768106F','生态环保工作总结报告','HSSE/InformationProject/EPSummaryReport.aspx',90,'C554E471-B740-4559-B543-E00F247289FD','Menu_HSSE',0,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('CB232557-CC35-459B-AFFE-F5F8F7C1D920','FD572EFA-8E87-43D1-B514-25A39768106F','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('E45E505D-B790-45DC-AFC3-81D1AE987B89','FD572EFA-8E87-43D1-B514-25A39768106F','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('9E6C0E2C-E432-41FF-B07C-D959440AEDC6','FD572EFA-8E87-43D1-B514-25A39768106F','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('23F57663-B49D-4FA8-BBBD-BB7155F661CE','FD572EFA-8E87-43D1-B514-25A39768106F','保存',4)
go
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
values('5B344750-79DD-40AA-8AA7-34B04E41FA72','生态环保工作总结报告','ZHGL/Information/EPSummaryReport.aspx',130,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
go
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('DEA42323-22EE-47EB-9C32-204674F359E8','5B344750-79DD-40AA-8AA7-34B04E41FA72','增加',1)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('E5E41ADA-782B-441D-A340-DE61A6812C10','5B344750-79DD-40AA-8AA7-34B04E41FA72','修改',2)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('D7CB0313-02BD-4457-99F2-F39DA70EC0B2','5B344750-79DD-40AA-8AA7-34B04E41FA72','删除',3)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('E04D28D4-04BB-457B-A05E-3A886B2E132C','5B344750-79DD-40AA-8AA7-34B04E41FA72','保存',4)
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
values('F8DCA6D5-7B75-4903-96A1-39899DC32689','5B344750-79DD-40AA-8AA7-34B04E41FA72','保存并上报',5)
go
CREATE TABLE [dbo].[InformationProject_EPSummaryReport](
[EPSummaryReportId] [nvarchar](50) NOT NULL,
[ProjectId] [nvarchar](50) NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[ResponsiblePersonTel] [nvarchar](50) NULL,
[ContactPerson] [nvarchar](50) NULL,
[ContactPersonTel] [nvarchar](50) NULL,
[ReportDate] [datetime] NULL,
[Description1] [nvarchar](500) NULL,
[Description2] [nvarchar](500) NULL,
[Description3] [nvarchar](500) NULL,
[Description4] [nvarchar](500) NULL,
[Description5] [nvarchar](500) NULL,
[Description6] [nvarchar](500) NULL,
[Description7] [nvarchar](500) NULL,
[Description8] [nvarchar](500) NULL,
[Description9] [nvarchar](500) NULL,
CONSTRAINT [PK_InformationProject_EPSummaryReport] PRIMARY KEY CLUSTERED
(
[EPSummaryReportId] 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].[InformationProject_EPSummaryReport] WITH CHECK ADD CONSTRAINT [FK_InformationProject_EPSummaryReport_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
GO
ALTER TABLE [dbo].[InformationProject_EPSummaryReport] CHECK CONSTRAINT [FK_InformationProject_EPSummaryReport_Base_Project]
GO
ALTER TABLE [dbo].[InformationProject_EPSummaryReport] WITH CHECK ADD CONSTRAINT [FK_InformationProject_EPSummaryReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[InformationProject_EPSummaryReport] CHECK CONSTRAINT [FK_InformationProject_EPSummaryReport_Base_Unit]
GO
CREATE TABLE [dbo].[Information_EPSummaryReport](
[EPSummaryReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[YearId] [int] NULL,
[ResponsiblePerson] [nvarchar](50) NULL,
[ResponsiblePersonTel] [nvarchar](50) NULL,
[ContactPerson] [nvarchar](50) NULL,
[ContactPersonTel] [nvarchar](50) NULL,
[ReportDate] [datetime] NULL,
[Description1] [nvarchar](max) NULL,
[Description2] [nvarchar](max) NULL,
[Description3] [nvarchar](max) NULL,
[Description4] [nvarchar](max) NULL,
[Description5] [nvarchar](max) NULL,
[Description6] [nvarchar](max) NULL,
[Description7] [nvarchar](max) NULL,
[Description8] [nvarchar](max) NULL,
[Description9] [nvarchar](max) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Information_EPSummaryReport] PRIMARY KEY CLUSTERED
(
[EPSummaryReportId] 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
ALTER TABLE [dbo].[Information_EPSummaryReport] WITH CHECK ADD CONSTRAINT [FK_Information_EPSummaryReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Information_EPSummaryReport] CHECK CONSTRAINT [FK_Information_EPSummaryReport_Base_Unit]
GO
ALTER TABLE dbo.Environmental_OperationReport ADD
UpState char(1) NULL
GO
DECLARE @v sql_variant
SET @v = N'上报状态'
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'TABLE', N'Environmental_OperationReport', N'COLUMN', N'UpState'
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('30579BFE-AB4B-49A7-A73D-B7CE902A8B69','中央企业节能环保产业企业生产和服务业务情况报表','ZHGL/Environmental/EnergyReport.aspx',90,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B13C617B-C152-4B09-92C6-C14E3B7F9150','30579BFE-AB4B-49A7-A73D-B7CE902A8B69','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('35C3D2C5-F980-4160-A0B5-95733DE0D41E','30579BFE-AB4B-49A7-A73D-B7CE902A8B69','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('56F9E8D7-E218-48CC-A06A-93FD8B8C57AC','30579BFE-AB4B-49A7-A73D-B7CE902A8B69','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2702BC5C-0D02-4C3F-8C75-57955AD0D170','30579BFE-AB4B-49A7-A73D-B7CE902A8B69','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('9DE996D9-A2CF-40C8-86D3-6A472AB30E5D','中央企业节能环保产业企业生产和服务业务情况报表','ZHGL/Environmental/ProjectEnergyReport.aspx',70,'C554E471-B740-4559-B543-E00F247289FD','Menu_HSSE',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B7E38639-4E7A-47D3-A7F0-218921B80AD1','9DE996D9-A2CF-40C8-86D3-6A472AB30E5D','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('E443CE17-ACED-4C3A-9D42-A068E5EC3BFF','9DE996D9-A2CF-40C8-86D3-6A472AB30E5D','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2B161A21-9CE8-4470-B772-715865E17AB3','9DE996D9-A2CF-40C8-86D3-6A472AB30E5D','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8CA53BDE-A127-40C0-8D1E-28FAB9E8A0C6','9DE996D9-A2CF-40C8-86D3-6A472AB30E5D','保存',4)
GO
/****** Object: Table [dbo].[Environmental_EnergyReport] Script Date: 2023/3/26 18:01:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Environmental_EnergyReport](
[EnergyReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Quarters] [int] NULL,
[FillingMan] [nvarchar](50) NULL,
[FillingDate] [datetime] NULL,
[DutyPerson] [nvarchar](50) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Environmental_EnergyReport] PRIMARY KEY CLUSTERED
(
[EnergyReportId] 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
ALTER TABLE [dbo].[Environmental_EnergyReport] WITH CHECK ADD CONSTRAINT [FK_Environmental_EnergyReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Environmental_EnergyReport] CHECK CONSTRAINT [FK_Environmental_EnergyReport_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReport', @level2type=N'COLUMN',@level2name=N'EnergyReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReport', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'季度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReport', @level2type=N'COLUMN',@level2name=N'Quarters'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReport', @level2type=N'COLUMN',@level2name=N'FillingMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReport', @level2type=N'COLUMN',@level2name=N'FillingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReport', @level2type=N'COLUMN',@level2name=N'DutyPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'中央企业节能环保产业企业生产和服务业务情况报表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReport'
GO
/****** Object: Table [dbo].[Environmental_EnergyReportItem] Script Date: 2023/3/26 18:28:21 ******/
GO
CREATE TABLE [dbo].[Environmental_EnergyReportItem](
[EnergyReportItemId] [nvarchar](50) NOT NULL,
[EnergyReportId] [nvarchar](50) NULL,
[SortIndex] [nvarchar](50) NULL,
[BusinessCategory] [nvarchar](50) NULL,
[Throughput_BasePeriod] [nvarchar](50) NULL,
[Throughput_LastPeriod] [nvarchar](50) NULL,
[Throughput_ThisPeriod] [nvarchar](50) NULL,
[Throughput_UnitOfMeasurement] [nvarchar](50) NULL,
[Yield_BasePeriod] [nvarchar](50) NULL,
[Yield_LastPeriod] [nvarchar](50) NULL,
[Yield_ThisPeriod] [nvarchar](50) NULL,
[Yield_UnitOfMeasurement] [nvarchar](50) NULL,
[OutputValue_BasePeriod] [nvarchar](50) NULL,
[OutputValue_LastYear] [nvarchar](50) NULL,
[OutputValue_ThisYear] [nvarchar](50) NULL,
[OperationScale_BasePeriod] [nvarchar](50) NULL,
[OperationScale_LastYear] [nvarchar](50) NULL,
[OperationScale_ThisYear] [nvarchar](50) NULL,
[OperationScale_UnitOfMeasurement] [nvarchar](50) NULL,
[ServiceOperatingIncome_BasePeriod] [nvarchar](50) NULL,
[ServiceOperatingIncome_LastYear] [nvarchar](50) NULL,
[ServiceOperatingIncome_ThisYear] [nvarchar](50) NULL,
CONSTRAINT [PK_Environmental_EnergyReportItem] PRIMARY KEY CLUSTERED
(
[EnergyReportItemId] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'BusinessCategory'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产能力-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'Throughput_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产能力-上期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'Throughput_LastPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产能力-本期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'Throughput_ThisPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产能力-计量单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'Throughput_UnitOfMeasurement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产量-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'Yield_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产量-上期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'Yield_LastPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产量-本期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'Yield_ThisPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产量-计量单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'Yield_UnitOfMeasurement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产值-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'OutputValue_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产值-上年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'OutputValue_LastYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产值-本年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'OutputValue_ThisYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运营规模-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'OperationScale_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运营规模-上年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'OperationScale_LastYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运营规模-本年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'OperationScale_ThisYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运营规模-计量单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'OperationScale_UnitOfMeasurement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务营业收入-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'ServiceOperatingIncome_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务营业收入-上年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'ServiceOperatingIncome_LastYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务营业收入-本年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem', @level2type=N'COLUMN',@level2name=N'ServiceOperatingIncome_ThisYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'中央企业节能环保产业企业生产和服务业务情况报表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_EnergyReportItem'
/****** Object: View [dbo].[View_Environmental_ChemicalReport] Script Date: 2023/3/26 18:33:36 ******/
GO
/*************中央企业节能环保产业企业生产和服务业务情况报表**************/
CREATE VIEW [dbo].[View_Environmental_EnergyReport]
AS
SELECT
Report.EnergyReportId,
Report.UnitId,
Report.FillingDate,
(ISNULL(Group_0008.ConstText,'-') + ISNULL(Group_0011.ConstText,'-')) AS ReportDate,
Group_0008.ConstText as YearStr,
Group_0011.ConstText as QuartersStr,
U.UnitName,
Report.Year,
Report.Quarters,
Report.UpState,
Report.DutyPerson
FROM dbo.Environmental_EnergyReport AS Report
LEFT JOIN Base_Unit AS U ON U.UnitId=Report.UnitId
LEFT JOIN Sys_Const AS Group_0008 ON Group_0008.GroupId='0008' AND Group_0008.ConstValue =Report.[Year]
LEFT JOIN Sys_Const AS Group_0011 ON Group_0011.GroupId='0011' AND Group_0011.ConstValue =Report.[Quarters]
GO
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template','合计','01')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 1.节能产业','02')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （1）节能技术装备产品','03')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 节能锅炉/窑炉','04')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 高效电机系统','05')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 高效换热器','06')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 节能制冷设备和空调','07')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 工业控制装置和仪器仪表','08')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 节能照明和家电','09')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 绿色建材','10')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 储能设备','11')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他节能装备/产品','12')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （2）节能服务','13')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 合同能源管理','14')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','15')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 2.环保产业','16')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （1）大气污染防治','17')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 除尘脱硫脱硝','18')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' CVOCs','19')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','20')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （2）水污染防治','21')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 城镇污水','22')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 农村生活污水','23')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 再生水','24')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 工业废水','25')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 水环境综合整治','26')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','27')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （3）固废处理','28')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 生活垃圾处理','29')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 餐厨废弃物处理','30')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 危险废物处置','31')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 污泥处置','32')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','33')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （4）生态修复','34')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 土壤修复','35')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 矿山修复','36')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 地下水修复','37')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','38')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （5）环保服务','39')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 环境监测和检测','40')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 环境咨询服务','41')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 环保工程施工','42')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','43')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 3.资源循环利用产业','44')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （1）大宗工业固废','45')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （2）尾矿','46')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （3）产品拆解和废旧金属','47')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （4）低值废弃物','48')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （5）农林废弃物','49')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （6）新品种废弃物','50')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （7）海水资源综合利用','51')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （8）再制造','52')
insert into Environmental_EnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （9） 其他','53')
CREATE TABLE [dbo].[Environmental_ProjectEnergyReport](
[EnergyReportId] [nvarchar](50) NOT NULL,
[UnitId] [nvarchar](50) NULL,
[ProjectId] [nvarchar](50) NULL,
[Year] [int] NULL,
[Quarters] [int] NULL,
[FillingMan] [nvarchar](50) NULL,
[FillingDate] [datetime] NULL,
[DutyPerson] [nvarchar](50) NULL,
[UpState] [char](1) NULL,
CONSTRAINT [PK_Environmental_ProjectEnergyReport] PRIMARY KEY CLUSTERED
(
[EnergyReportId] 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
ALTER TABLE [dbo].[Environmental_ProjectEnergyReport] WITH CHECK ADD CONSTRAINT [FK_Environmental_ProjectEnergyReport_Base_Unit] FOREIGN KEY([UnitId])
REFERENCES [dbo].[Base_Unit] ([UnitId])
GO
ALTER TABLE [dbo].[Environmental_ProjectEnergyReport] CHECK CONSTRAINT [FK_Environmental_ProjectEnergyReport_Base_Unit]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReport', @level2type=N'COLUMN',@level2name=N'EnergyReportId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReport', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReport', @level2type=N'COLUMN',@level2name=N'Year'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'季度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReport', @level2type=N'COLUMN',@level2name=N'Quarters'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReport', @level2type=N'COLUMN',@level2name=N'FillingMan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReport', @level2type=N'COLUMN',@level2name=N'FillingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReport', @level2type=N'COLUMN',@level2name=N'DutyPerson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'中央企业节能环保产业企业生产和服务业务情况报表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReport'
GO
/****** Object: Table [dbo].[Environmental_ProjectEnergyReportItem] Script Date: 2023/3/26 18:28:21 ******/
GO
CREATE TABLE [dbo].[Environmental_ProjectEnergyReportItem](
[EnergyReportItemId] [nvarchar](50) NOT NULL,
[EnergyReportId] [nvarchar](50) NULL,
[SortIndex] [nvarchar](50) NULL,
[BusinessCategory] [nvarchar](50) NULL,
[Throughput_BasePeriod] [nvarchar](50) NULL,
[Throughput_LastPeriod] [nvarchar](50) NULL,
[Throughput_ThisPeriod] [nvarchar](50) NULL,
[Throughput_UnitOfMeasurement] [nvarchar](50) NULL,
[Yield_BasePeriod] [nvarchar](50) NULL,
[Yield_LastPeriod] [nvarchar](50) NULL,
[Yield_ThisPeriod] [nvarchar](50) NULL,
[Yield_UnitOfMeasurement] [nvarchar](50) NULL,
[OutputValue_BasePeriod] [nvarchar](50) NULL,
[OutputValue_LastYear] [nvarchar](50) NULL,
[OutputValue_ThisYear] [nvarchar](50) NULL,
[OperationScale_BasePeriod] [nvarchar](50) NULL,
[OperationScale_LastYear] [nvarchar](50) NULL,
[OperationScale_ThisYear] [nvarchar](50) NULL,
[OperationScale_UnitOfMeasurement] [nvarchar](50) NULL,
[ServiceOperatingIncome_BasePeriod] [nvarchar](50) NULL,
[ServiceOperatingIncome_LastYear] [nvarchar](50) NULL,
[ServiceOperatingIncome_ThisYear] [nvarchar](50) NULL,
CONSTRAINT [PK_Environmental_ProjectEnergyReportItem] PRIMARY KEY CLUSTERED
(
[EnergyReportItemId] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'BusinessCategory'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产能力-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'Throughput_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产能力-上期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'Throughput_LastPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产能力-本期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'Throughput_ThisPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产能力-计量单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'Throughput_UnitOfMeasurement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产量-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'Yield_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产量-上期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'Yield_LastPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产量-本期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'Yield_ThisPeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产量-计量单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'Yield_UnitOfMeasurement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产值-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'OutputValue_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产值-上年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'OutputValue_LastYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产值-本年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'OutputValue_ThisYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运营规模-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'OperationScale_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运营规模-上年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'OperationScale_LastYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运营规模-本年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'OperationScale_ThisYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运营规模-计量单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'OperationScale_UnitOfMeasurement'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务营业收入-基期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'ServiceOperatingIncome_BasePeriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务营业收入-上年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'ServiceOperatingIncome_LastYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务营业收入-本年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem', @level2type=N'COLUMN',@level2name=N'ServiceOperatingIncome_ThisYear'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'中央企业节能环保产业企业生产和服务业务情况报表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Environmental_ProjectEnergyReportItem'
/****** Object: View [dbo].[View_Environmental_ChemicalReport] Script Date: 2023/3/26 18:33:36 ******/
GO
/*************中央企业节能环保产业企业生产和服务业务情况报表**************/
CREATE VIEW [dbo].[View_Environmental_ProjectEnergyReport]
AS
SELECT
Report.EnergyReportId,
Report.ProjectId,
Report.FillingDate,
(ISNULL(Group_0008.ConstText,'-') + ISNULL(Group_0011.ConstText,'-')) AS ReportDate,
Group_0008.ConstText as YearStr,
Group_0011.ConstText as QuartersStr,
U.ProjectName,
Report.Year,
Report.Quarters,
Report.UpState,
Report.DutyPerson
FROM dbo.Environmental_ProjectEnergyReport AS Report
LEFT JOIN Base_Project AS U ON U.ProjectId=Report.ProjectId
LEFT JOIN Sys_Const AS Group_0008 ON Group_0008.GroupId='0008' AND Group_0008.ConstValue =Report.[Year]
LEFT JOIN Sys_Const AS Group_0011 ON Group_0011.GroupId='0011' AND Group_0011.ConstValue =Report.[Quarters]
GO
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template','合计','01')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 1.节能产业','02')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （1）节能技术装备产品','03')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 节能锅炉/窑炉','04')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 高效电机系统','05')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 高效换热器','06')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 节能制冷设备和空调','07')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 工业控制装置和仪器仪表','08')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 节能照明和家电','09')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 绿色建材','10')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 储能设备','11')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他节能装备/产品','12')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （2）节能服务','13')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 合同能源管理','14')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','15')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 2.环保产业','16')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （1）大气污染防治','17')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 除尘脱硫脱硝','18')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' CVOCs','19')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','20')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （2）水污染防治','21')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 城镇污水','22')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 农村生活污水','23')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 再生水','24')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 工业废水','25')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 水环境综合整治','26')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','27')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （3）固废处理','28')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 生活垃圾处理','29')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 餐厨废弃物处理','30')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 危险废物处置','31')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 污泥处置','32')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','33')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （4）生态修复','34')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 土壤修复','35')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 矿山修复','36')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 地下水修复','37')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','38')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （5）环保服务','39')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 环境监测和检测','40')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 环境咨询服务','41')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 环保工程施工','42')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 其他','43')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' 3.资源循环利用产业','44')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （1）大宗工业固废','45')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （2）尾矿','46')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （3）产品拆解和废旧金属','47')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （4）低值废弃物','48')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （5）农林废弃物','49')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （6）新品种废弃物','50')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （7）海水资源综合利用','51')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （8）再制造','52')
insert into Environmental_ProjectEnergyReportItem (EnergyReportItemId,EnergyReportId,BusinessCategory,SortIndex) values(NEWID(),'Template',' （9） 其他','53')
GO
update [Sys_Menu] set SortIndex=60 where [MenuId]='AAC7C263-6E25-49DC-985B-DC3FA7AAF3A1'
update [Sys_Menu] set SortIndex=70 where [MenuId]='07FEEC9D-09C1-4C19-9269-62F69532086C'
update [Sys_Menu] set SortIndex=80 where [MenuId]='CF9C1F00-34B8-42E5-B2D1-704094169CA3'
update [Sys_Menu] set SortIndex=90 where [MenuId]='12941594-2171-411A-8CC8-32E3BD9FCDDF'
update [Sys_Menu] set SortIndex=100 where [MenuId]='5B344750-79DD-40AA-8AA7-34B04E41FA72'
update [Sys_Menu] set SortIndex=110 where [MenuId]='7C47F078-D4C9-40D9-BEEF-E657EAFEC650'
update [Sys_Menu] set SortIndex=120 where [MenuId]='ECDD89AC-1E16-4D82-B3BE-5D62F31B7A14'
update [Sys_Menu] set SortIndex=130 where [MenuId]='7652D239-1897-4886-8DF2-B71E3B060D21'
update [Sys_Menu] set SortIndex=140 where [MenuId]='30579BFE-AB4B-49A7-A73D-B7CE902A8B69'
GO
update [Sys_Menu] set SortIndex=100 where [MenuId]='25CE6894-2840-4DC4-AD2E-D72292849CEE'
update [Sys_Menu] set SortIndex=110 where [MenuId]='A44E98F6-E9FE-43F8-8349-C166263BF608'
update [Sys_Menu] set SortIndex=180 where [MenuId]='9DE996D9-A2CF-40C8-86D3-6A472AB30E5D'
update [Sys_Menu] set SortIndex=55 where [MenuId]='86F71934-7149-470E-BEAB-FFDC5BF3C0F2'
GO
EXEC sp_rename '[Environmental_ArchitectureReport].[Month]','Quarters'
GO
/*************建筑行业能源节约与生态环境保护汇总表**************/
ALTER VIEW [dbo].[View_Environmental_ArchitectureReport]
AS
SELECT
Report.ArchitectureReportId,
Report.UnitId,
Report.FillingDate,
(ISNULL(Group_0008.ConstText,'-') + ISNULL(Group_0011.ConstText,'-')) AS ReportDate,
Group_0008.ConstText as YearStr,
Group_0011.ConstText as QuartersStr,
U.UnitName,
Report.Year,
Report.Quarters,
Report.UpState,
Report.DutyPerson
FROM dbo.Environmental_ArchitectureReport AS Report
LEFT JOIN Base_Unit AS U ON U.UnitId=Report.UnitId
LEFT JOIN Sys_Const AS Group_0008 ON Group_0008.GroupId='0008' AND Group_0008.ConstValue =Report.[Year]
LEFT JOIN Sys_Const AS Group_0011 ON Group_0011.GroupId='0011' AND Group_0011.ConstValue =Report.[Quarters]
GO
Reference in New Issue View Git Blame Copy Permalink