146 lines
9.6 KiB
Transact-SQL
146 lines
9.6 KiB
Transact-SQL
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TemplateChannelsUpdate]') AND type in (N'P', N'PC'))
|
||
DROP PROCEDURE [dbo].[sp_TemplateChannelsUpdate]
|
||
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_TemplateChannelsUpdate]') AND type in (N'P', N'PC'))
|
||
BEGIN
|
||
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TemplateChannelsUpdate] AS'
|
||
END
|
||
GO
|
||
ALTER PROCEDURE [dbo].[sp_TemplateChannelsUpdate]
|
||
@TemplateId int = 0
|
||
,@TemplateChannelId 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
|
||
,@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
|
||
|
||
UPDATE [dbo].[TemplateChannels]
|
||
SET [NameOfTheChannel] = @NameOfTheChannel
|
||
,[LaboratoryChannelCode] = @LaboratoryChannelCode
|
||
,[CustomerChannelCode] = @CustomerChannelCode
|
||
,[Comments1] = @Comments1
|
||
,[Location] = @Location
|
||
,[Dimension] = @Dimension
|
||
,[Direction] = @Direction
|
||
,[ChannelFrequencyClass] = @ChannelFrequencyClass
|
||
,[Unit] = @Unit
|
||
,[ReferenceSystem] = @ReferenceSystem
|
||
,[TransducerType] = @TransducerType
|
||
,[TransducerId] = @TransducerId
|
||
,[PreFilterType] = @PreFilterType
|
||
,[CutOffFrequency] = @CutOffFrequency
|
||
,[ChannelAmplitudeClass] = @ChannelAmplitudeClass
|
||
,[ReferenceChannel] = @ReferenceChannel
|
||
,[ReferenceChannelName] = @ReferenceChannelName
|
||
,[DataSource] = @DataSource
|
||
,[DataStatus] = @DataStatus
|
||
,[SamplingInterval] = @SamplingInterval
|
||
,[BitResolution] = @BitResolution
|
||
,[TimeOfFirstSample] = @TimeOfFirstSample
|
||
,[NumberOfSamples] = @NumberOfSamples
|
||
,[OffsetPostTest] = @OffsetPostTest
|
||
,[TransducerNaturalFrequency] = @TransducerNaturalFrequency
|
||
,[TransducerDampingRatio] = @TransducerDampingRatio
|
||
,[Comments] = @Comments
|
||
,[FirstGlobalMaximumValue] = @FirstGlobalMaximumValue
|
||
,[TimeOfMaximumValue] = @TimeOfMaximumValue
|
||
,[FirstGlobalMinimumValue] = @FirstGlobalMinimumValue
|
||
,[TimeOfMinimumValue] = @TimeOfMinimumValue
|
||
,[StartOffsetInterval] = @StartOffsetInterval
|
||
,[EndOffsetInterval] = @EndOffsetInterval
|
||
,[Required] = @Required
|
||
,[LocalOnly] = @LocalOnly
|
||
,[MMEChannelId] = @MMEChannelId
|
||
,[MMEChannelType] = @MMEChannelType
|
||
,[TemplateId] = @TemplateId
|
||
,[DisplayOrder] = @DisplayOrder
|
||
WHERE [TemplateChannelId] = @TemplateChannelId
|
||
end try
|
||
begin catch
|
||
set @errorMessage = error_message()
|
||
set @errorNumber = error_number()
|
||
end catch;
|
||
END
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
GO
|