185 lines
10 KiB
Transact-SQL
185 lines
10 KiB
Transact-SQL
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
|