185 lines
10 KiB
Plaintext
185 lines
10 KiB
Plaintext
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TemplateChannelsInsert]') AND type in (N'P', N'PC'))
|
|
DROP PROCEDURE [dbo].[sp_TemplateChannelsInsert]
|
|
GO
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TemplateChannelsInsert]') AND type in (N'P', N'PC'))
|
|
BEGIN
|
|
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TemplateChannelsInsert] AS'
|
|
END
|
|
GO
|
|
ALTER PROCEDURE [dbo].[sp_TemplateChannelsInsert]
|
|
@TemplateId int = 0
|
|
,@TestObjectNumber varchar(50)
|
|
,@NameOfTheChannel varchar(100)
|
|
,@LaboratoryChannelCode nvarchar(50)
|
|
,@CustomerChannelCode nvarchar(50)
|
|
,@Comments1 nvarchar(50)
|
|
,@Location nvarchar(50)
|
|
,@Dimension nvarchar(50)
|
|
,@Direction nvarchar(50)
|
|
,@ChannelFrequencyClass nvarchar(50)
|
|
,@Unit nvarchar(50)
|
|
,@ReferenceSystem nvarchar(50)
|
|
,@TransducerType nvarchar(50)
|
|
,@TransducerId nvarchar(50)
|
|
,@PreFilterType nvarchar(50)
|
|
,@CutOffFrequency nvarchar(50)
|
|
,@ChannelAmplitudeClass nvarchar(50)
|
|
,@ReferenceChannel nvarchar(50)
|
|
,@ReferenceChannelName nvarchar(50)
|
|
,@DataSource nvarchar(50)
|
|
,@DataStatus nvarchar(50)
|
|
,@SamplingInterval nvarchar(50)
|
|
,@BitResolution nvarchar(50)
|
|
,@TimeOfFirstSample nvarchar(50)
|
|
,@NumberOfSamples nvarchar(50)
|
|
,@OffsetPostTest nvarchar(50)
|
|
,@TransducerNaturalFrequency nvarchar(50)
|
|
,@TransducerDampingRatio nvarchar(50)
|
|
,@Comments nvarchar(50)
|
|
,@FirstGlobalMaximumValue nvarchar(50)
|
|
,@TimeOfMaximumValue nvarchar(50)
|
|
,@FirstGlobalMinimumValue nvarchar(50)
|
|
,@TimeOfMinimumValue nvarchar(50)
|
|
,@StartOffsetInterval nvarchar(50)
|
|
,@EndOffsetInterval nvarchar(50)
|
|
,@Required bit
|
|
,@LocalOnly bit
|
|
,@MMEChannelId bigint
|
|
,@MMEChannelType int
|
|
,@TemplateName nvarchar(255)
|
|
,@DisplayOrder int
|
|
,@new_id int output
|
|
,@errorNumber int output
|
|
,@errorMessage nvarchar(250) output
|
|
AS
|
|
BEGIN
|
|
set @errorMessage = space(0); set @errorNumber = 0;
|
|
begin try
|
|
if(@TemplateId =0)
|
|
begin
|
|
set @TemplateId = dbo.foo_IdGetTemplate(@TemplateName)
|
|
end
|
|
|
|
insert into [dbo].[TemplateChannels]
|
|
([TestObjectNumber]
|
|
,[NameOfTheChannel]
|
|
,[LaboratoryChannelCode]
|
|
,[CustomerChannelCode]
|
|
,[Comments1]
|
|
,[Location]
|
|
,[Dimension]
|
|
,[Direction]
|
|
,[ChannelFrequencyClass]
|
|
,[Unit]
|
|
,[ReferenceSystem]
|
|
,[TransducerType]
|
|
,[TransducerId]
|
|
,[PreFilterType]
|
|
,[CutOffFrequency]
|
|
,[ChannelAmplitudeClass]
|
|
,[ReferenceChannel]
|
|
,[ReferenceChannelName]
|
|
,[DataSource]
|
|
,[DataStatus]
|
|
,[SamplingInterval]
|
|
,[BitResolution]
|
|
,[TimeOfFirstSample]
|
|
,[NumberOfSamples]
|
|
,[OffsetPostTest]
|
|
,[TransducerNaturalFrequency]
|
|
,[TransducerDampingRatio]
|
|
,[Comments]
|
|
,[FirstGlobalMaximumValue]
|
|
,[TimeOfMaximumValue]
|
|
,[FirstGlobalMinimumValue]
|
|
,[TimeOfMinimumValue]
|
|
,[StartOffsetInterval]
|
|
,[EndOffsetInterval]
|
|
,[Required]
|
|
,[LocalOnly]
|
|
,[MMEChannelId]
|
|
,[MMEChannelType]
|
|
,[TemplateId]
|
|
,[DisplayOrder])
|
|
VALUES
|
|
(@TestObjectNumber
|
|
,@NameOfTheChannel
|
|
,@LaboratoryChannelCode
|
|
,@CustomerChannelCode
|
|
,@Comments1
|
|
,@Location
|
|
,@Dimension
|
|
,@Direction
|
|
,@ChannelFrequencyClass
|
|
,@Unit
|
|
,@ReferenceSystem
|
|
,@TransducerType
|
|
,@TransducerId
|
|
,@PreFilterType
|
|
,@CutOffFrequency
|
|
,@ChannelAmplitudeClass
|
|
,@ReferenceChannel
|
|
,@ReferenceChannelName
|
|
,@DataSource
|
|
,@DataStatus
|
|
,@SamplingInterval
|
|
,@BitResolution
|
|
,@TimeOfFirstSample
|
|
,@NumberOfSamples
|
|
,@OffsetPostTest
|
|
,@TransducerNaturalFrequency
|
|
,@TransducerDampingRatio
|
|
,@Comments
|
|
,@FirstGlobalMaximumValue
|
|
,@TimeOfMaximumValue
|
|
,@FirstGlobalMinimumValue
|
|
,@TimeOfMinimumValue
|
|
,@StartOffsetInterval
|
|
,@EndOffsetInterval
|
|
,@Required
|
|
,@LocalOnly
|
|
,@MMEChannelId
|
|
,@MMEChannelType
|
|
,@TemplateId
|
|
,@DisplayOrder)
|
|
|
|
set @new_id = scope_identity()
|
|
end try
|
|
begin catch
|
|
set @errorMessage = error_message()
|
|
set @errorNumber = error_number()
|
|
end catch;
|
|
END
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GO
|