260 lines
14 KiB
Transact-SQL
260 lines
14 KiB
Transact-SQL
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
|
||
values('62B150A1-37F3-44FE-A884-103E15BB47AC','밗돛쓰든쌈뒈꿎桿션쩌','JGZL/ElectrostaticGrounding.aspx',250,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
|
||
go
|
||
insert into ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
values('8C84EDE9-D33B-4A69-B79C-88D4C2EDD6F8','62B150A1-37F3-44FE-A884-103E15BB47AC','藤속',1)
|
||
insert into ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
values('10BB2DFA-D1FF-454E-A50F-82FD1747F746','62B150A1-37F3-44FE-A884-103E15BB47AC','錦맣',2)
|
||
insert into ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
values('CD7A8CB3-00F6-415E-BA8D-C936C82FBBF8','62B150A1-37F3-44FE-A884-103E15BB47AC','<EFBFBD>뇜',3)
|
||
insert into ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
values('5BADD172-1F7C-44CB-9023-64440152F816','62B150A1-37F3-44FE-A884-103E15BB47AC','괏닸',4)
|
||
go
|
||
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
|
||
values('E64FC226-8164-43F7-AA4D-6E268EDEC5BC','밗돛뉘<EFBFBD>/헌求쇱駱션쩌','JGZL/BlowingCleaning.aspx',290,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
|
||
go
|
||
insert into ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
values('A6993211-A98A-49DE-92DF-E560A3A89AED','E64FC226-8164-43F7-AA4D-6E268EDEC5BC','藤속',1)
|
||
insert into ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
values('EA6CD8CD-F7FB-4596-9A2E-1600236A3DB3','E64FC226-8164-43F7-AA4D-6E268EDEC5BC','錦맣',2)
|
||
insert into ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
values('0C89BE7E-A733-4D37-A8FD-73DF8A657851','E64FC226-8164-43F7-AA4D-6E268EDEC5BC','<EFBFBD>뇜',3)
|
||
insert into ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
values('6C643F79-5C0E-4257-9970-58F5EEDC0DC5','E64FC226-8164-43F7-AA4D-6E268EDEC5BC','괏닸',4)
|
||
go
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
|
||
values('1D05ECF8-2EAC-4A24-AA6E-92CDA534A836','밗돛보왯쇱꿎悧官辜데','JGZL/PipelineTotalTrust.aspx',300,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
|
||
go
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
|
||
values('43785833-4FEE-415E-B1DC-53FEAB07C5A1','밗돛보왯쇱꿎官辜데','JGZL/PipelineWeldJointTrust.aspx',310,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
|
||
go
|
||
|
||
|
||
CREATE TABLE [dbo].[JGZL_ElectrostaticGrounding](
|
||
[ElectrostaticGroundingId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[PipelineCode] [nvarchar](50) NULL,
|
||
[ConnectionType] [nvarchar](50) NULL,
|
||
[BWSpecification] [nvarchar](50) NULL,
|
||
[BWMaterial] [nvarchar](50) NULL,
|
||
[BWResistance] [decimal](18, 2) NULL,
|
||
[GWSpecification] [nvarchar](50) NULL,
|
||
[GWMaterial] [nvarchar](50) NULL,
|
||
[GWResistance] [decimal](18, 2) NULL,
|
||
[CompileMan] [nvarchar](50) NULL,
|
||
[CompileDate] [datetime] NULL,
|
||
CONSTRAINT [PK_JGZL_ElectrostaticGrounding] PRIMARY KEY CLUSTERED
|
||
(
|
||
[ElectrostaticGroundingId] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_ElectrostaticGrounding] WITH CHECK ADD CONSTRAINT [FK_JGZL_ElectrostaticGrounding_Base_Project] FOREIGN KEY([ProjectId])
|
||
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_ElectrostaticGrounding] CHECK CONSTRAINT [FK_JGZL_ElectrostaticGrounding_Base_Project]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_ElectrostaticGrounding] WITH CHECK ADD CONSTRAINT [FK_JGZL_ElectrostaticGrounding_Sys_User] FOREIGN KEY([CompileMan])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_ElectrostaticGrounding] CHECK CONSTRAINT [FK_JGZL_ElectrostaticGrounding_Sys_User]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @level2type=N'COLUMN',@level2name=N'ElectrostaticGroundingId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淃커Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @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'JGZL_ElectrostaticGrounding', @level2type=N'COLUMN',@level2name=N'PipelineCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쌈庫謹駕' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @level2type=N'COLUMN',@level2name=N'ConnectionType'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'욜쌈돔窟-방목' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @level2type=N'COLUMN',@level2name=N'BWSpecification'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'욜쌈돔窟-꼼醴' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @level2type=N'COLUMN',@level2name=N'BWMaterial'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'욜쌈돔窟-든羸令' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @level2type=N'COLUMN',@level2name=N'BWResistance'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쌈뒈多窟-방목' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @level2type=N'COLUMN',@level2name=N'GWSpecification'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쌈뒈多窟-꼼醴' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @level2type=N'COLUMN',@level2name=N'GWMaterial'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쌈뒈多窟-뚤뒈든羸' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @level2type=N'COLUMN',@level2name=N'GWResistance'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'긍齡훙' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ElectrostaticGrounding', @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'JGZL_ElectrostaticGrounding', @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'JGZL_ElectrostaticGrounding'
|
||
GO
|
||
|
||
|
||
CREATE TABLE [dbo].[JGZL_BlowingCleaning](
|
||
[BlowingCleaningId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[BlowingCleaningDate] [datetime] NULL,
|
||
[SystemName] [nvarchar](50) NULL,
|
||
[SystemCode] [nvarchar](50) NULL,
|
||
[Results] [nvarchar](500) NULL,
|
||
[CompileMan] [nvarchar](50) NULL,
|
||
[CompileDate] [datetime] NULL,
|
||
CONSTRAINT [PK_JGZL_BlowingCleaning] PRIMARY KEY CLUSTERED
|
||
(
|
||
[BlowingCleaningId] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaning] WITH CHECK ADD CONSTRAINT [FK_JGZL_BlowingCleaning_Base_Project] FOREIGN KEY([ProjectId])
|
||
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaning] CHECK CONSTRAINT [FK_JGZL_BlowingCleaning_Base_Project]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaning] WITH CHECK ADD CONSTRAINT [FK_JGZL_BlowingCleaning_Sys_User] FOREIGN KEY([CompileMan])
|
||
REFERENCES [dbo].[Sys_User] ([UserId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaning] CHECK CONSTRAINT [FK_JGZL_BlowingCleaning_Sys_User]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaning', @level2type=N'COLUMN',@level2name=N'BlowingCleaningId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淃커Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaning', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'헌<EFBFBD>珂쇌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaning', @level2type=N'COLUMN',@level2name=N'BlowingCleaningDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'溝固츰냔' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaning', @level2type=N'COLUMN',@level2name=N'SystemName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'溝固긍뵀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaning', @level2type=N'COLUMN',@level2name=N'SystemCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쇱駱렘랬섟써쬠' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaning', @level2type=N'COLUMN',@level2name=N'Results'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'긍齡훙' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaning', @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'JGZL_BlowingCleaning', @level2type=N'COLUMN',@level2name=N'CompileDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'밗돛뉘<EFBFBD>/헌求쇱駱션쩌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaning'
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[JGZL_BlowingCleaningItem](
|
||
[BlowingCleaningItemId] [nvarchar](50) NOT NULL,
|
||
[BlowingCleaningId] [nvarchar](50) NOT NULL,
|
||
[ISO_Id] [varchar](50) NOT NULL,
|
||
[STE_ID] [varchar](50) NULL,
|
||
[OperatingMedium] [nvarchar](50) NULL,
|
||
[ScrubbingMedium] [nvarchar](50) NULL,
|
||
[CleaningMedium] [nvarchar](50) NULL,
|
||
CONSTRAINT [PK_JGZL_BlowingCleaningItem] PRIMARY KEY CLUSTERED
|
||
(
|
||
[BlowingCleaningItemId] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaningItem] WITH CHECK ADD CONSTRAINT [FK_JGZL_BlowingCleaningItem_HJGL_BS_Steel] FOREIGN KEY([STE_ID])
|
||
REFERENCES [dbo].[HJGL_BS_Steel] ([STE_ID])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaningItem] CHECK CONSTRAINT [FK_JGZL_BlowingCleaningItem_HJGL_BS_Steel]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaningItem] WITH CHECK ADD CONSTRAINT [FK_JGZL_BlowingCleaningItem_HJGL_PW_IsoInfo] FOREIGN KEY([ISO_Id])
|
||
REFERENCES [dbo].[HJGL_PW_IsoInfo] ([ISO_ID])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaningItem] CHECK CONSTRAINT [FK_JGZL_BlowingCleaningItem_HJGL_PW_IsoInfo]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaningItem] WITH CHECK ADD CONSTRAINT [FK_JGZL_BlowingCleaningItem_JGZL_BlowingCleaning] FOREIGN KEY([BlowingCleaningId])
|
||
REFERENCES [dbo].[JGZL_BlowingCleaning] ([BlowingCleaningId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_BlowingCleaningItem] CHECK CONSTRAINT [FK_JGZL_BlowingCleaningItem_JGZL_BlowingCleaning]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaningItem', @level2type=N'COLUMN',@level2name=N'BlowingCleaningItemId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮깊Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaningItem', @level2type=N'COLUMN',@level2name=N'BlowingCleaningId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'밗窟Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaningItem', @level2type=N'COLUMN',@level2name=N'ISO_Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'꼼醴Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaningItem', @level2type=N'COLUMN',@level2name=N'STE_ID'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'꾸鱗썽醴' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaningItem', @level2type=N'COLUMN',@level2name=N'OperatingMedium'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'뉘<EFBFBD>썽醴' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaningItem', @level2type=N'COLUMN',@level2name=N'ScrubbingMedium'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'헌求썽醴' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaningItem', @level2type=N'COLUMN',@level2name=N'CleaningMedium'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'밗돛뉘<EFBFBD>/헌求쇱駱션쩌츠玖' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_BlowingCleaningItem'
|
||
GO
|
||
|
||
|
||
CREATE PROCEDURE [dbo].[sp_rpt_Trust]
|
||
(
|
||
@projectId NVARCHAR(50),
|
||
@isoNo nvarchar(50)=null
|
||
)
|
||
AS
|
||
select IsoInfo.ISO_ID,
|
||
IsoInfo.ProjectId,
|
||
IsoInfo.ISO_IsoNo,--밗돛긍뵀
|
||
IsoInfo.Specification,--방목
|
||
steel.STE_Code, --꼼醴
|
||
isoClass.ISC_IsoName,--밗돛섬깎
|
||
'' as NDTR_Name, --쇱꿎궐절
|
||
isnull(gdJoint.gdCount,0) as gdCount,--미땍왯
|
||
isnull(hdJoint.hdCount,0) as hdCount,--삶땡왯
|
||
(case IsoInfo.IsHot when 1 then '角' when 0 then '뤠' else '' end) as isHot,--角뤠훑뇹잿
|
||
'' as NDT_Code, --쇱꿎렘랬
|
||
--(case Trust.CH_AcceptGrade when '1' then '<27>' when '2' then '<27>' when '3' then '<27>' when '4' then '<27>' when '5' then '<27>' end) as AcceptGrade, --북목섬깎
|
||
'' as AcceptGrade,
|
||
'' as CH_NDTCriteria,--쇱꿎깃硫
|
||
'' AS ISO_Executive, --駱澗깃硫
|
||
IsoInfo.ISO_Remark as Remark
|
||
from HJGL_PW_IsoInfo IsoInfo
|
||
left join HJGL_BS_IsoClass as isoClass on isoClass.ISC_ID = IsoInfo.ISC_ID
|
||
left join HJGL_BS_Steel as steel on steel.STE_ID = IsoInfo.STE_ID
|
||
left join (select count(*) as gdCount,ISO_ID from HJGL_PW_JointInfo where JOT_JointAttribute='미땍' group by ISO_ID) as gdJoint on gdJoint.ISO_ID = IsoInfo.ISO_ID
|
||
left join (select count(*) as hdCount,ISO_ID from HJGL_PW_JointInfo where JOT_JointAttribute='삶땡' group by ISO_ID) as hdJoint on hdJoint.ISO_ID = IsoInfo.ISO_ID
|
||
where IsoInfo.ProjectId=@projectId
|
||
and (ISO_IsoNo like @isoNo or @isoNo is null)
|
||
|
||
go
|
||
|
||
|