USP_DATAFORMTEMPLATE_EDIT_BATCH2NUMBERINGSCHEME

The save procedure used by the edit dataform template "Batch Numbering Scheme Edit Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(200)	IN	Name
@NUMBERINGSCHEMECODE	tinyint	IN	Type
@ACTUALSEQUENCE	int	IN	Next sequence
@SEQUENCEPLACECODE	tinyint	IN
@SEQUENCESEPARATORCODE	tinyint	IN	Sequence separator
@NUMBERFORMATCODE	tinyint	IN	Leading zeroes
@INCLUDELABEL	bit	IN
@USERDEFINEDLABEL	nvarchar(20)	IN	Batch identifier
@LABELPLACECODE	tinyint	IN
@LABELSEPARATORCODE	tinyint	IN	Label separator
@INCLUDEDATEFORMAT	bit	IN
@DATEFORMATCODE	tinyint	IN	Date
@DATEFORMATPLACECODE	tinyint	IN
@DATESEPARATORCODE	tinyint	IN	Date separator
@EXCEPTIONBATCHNUMBERCODE	tinyint	IN
@INCLUDEEXCEPTIONPREFIX	bit	IN	Include exception identifier
@EXCEPTIONPREFIX	nvarchar(8)	IN	Exception identifier

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCH2NUMBERINGSCHEME
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(200),
    @NUMBERINGSCHEMECODE tinyint,
    @ACTUALSEQUENCE int,
    @SEQUENCEPLACECODE tinyint,
    @SEQUENCESEPARATORCODE tinyint,
    @NUMBERFORMATCODE tinyint,
    @INCLUDELABEL bit,
    @USERDEFINEDLABEL nvarchar(20),
    @LABELPLACECODE tinyint,
    @LABELSEPARATORCODE tinyint,
    @INCLUDEDATEFORMAT bit,
    @DATEFORMATCODE tinyint,
    @DATEFORMATPLACECODE tinyint,
    @DATESEPARATORCODE tinyint,
    @EXCEPTIONBATCHNUMBERCODE tinyint,
    @INCLUDEEXCEPTIONPREFIX bit, 
    @EXCEPTIONPREFIX nvarchar(8)
)
as

    set nocount on;

    begin try
        declare @CHANGEDATE datetime;
        set @CHANGEDATE = getdate();

        if @CHANGEAGENTID is null
            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        if @NUMBERINGSCHEMECODE = 1 
            begin
              if exists (SELECT 1 from dbo.BATCHTEMPLATE where BATCHNUMBERINGSCHEMEID = @ID and TEMPLATEUSECODE<>1)
          raiserror('ERR_BATCHNUMBERICNGSCHEME_TEMPLATE', 13, 1);    
        end    


        update
            dbo.BATCHNUMBERINGSCHEME
        set
            NAME = @NAME,
            NUMBERINGSCHEMECODE = @NUMBERINGSCHEMECODE,
            STARTSEQUENCE = @ACTUALSEQUENCE,
            ACTUALSEQUENCE = @ACTUALSEQUENCE,
            SEQUENCEPLACECODE = @SEQUENCEPLACECODE,
            SEQUENCESEPARATORCODE = @SEQUENCESEPARATORCODE,
            NUMBERFORMATCODE = @NUMBERFORMATCODE,
            INCLUDELABEL = @INCLUDELABEL,
            USERDEFINEDLABEL = @USERDEFINEDLABEL,
            LABELPLACECODE = @LABELPLACECODE,
            LABELSEPARATORCODE = @LABELSEPARATORCODE,
            INCLUDEDATEFORMAT = @INCLUDEDATEFORMAT,
            DATEFORMATCODE = @DATEFORMATCODE,
            DATEFORMATPLACECODE = @DATEFORMATPLACECODE,
            DATESEPARATORCODE = @DATESEPARATORCODE,
            EXCEPTIONBATCHNUMBERCODE = @EXCEPTIONBATCHNUMBERCODE, 
            INCLUDEEXCEPTIONPREFIX = @INCLUDEEXCEPTIONPREFIX,
            EXCEPTIONPREFIX = @EXCEPTIONPREFIX,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
        where
            (ID = @ID);
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;