USP_DATAFORMTEMPLATE_ADD_BATCH2NUMBERINGSCHEME

The save procedure used by the add dataform template "Batch Numbering Scheme Add Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@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_ADD_BATCH2NUMBERINGSCHEME
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(200),
    @NUMBERINGSCHEMECODE tinyint = 0,
    @ACTUALSEQUENCE int = 1,
    @SEQUENCEPLACECODE tinyint = 1,
    @SEQUENCESEPARATORCODE tinyint = 0,
    @NUMBERFORMATCODE tinyint = 0,
    @INCLUDELABEL bit = 0,
    @USERDEFINEDLABEL nvarchar(20) = null,
    @LABELPLACECODE tinyint = 2,
    @LABELSEPARATORCODE tinyint = 0,
    @INCLUDEDATEFORMAT bit = 0,
    @DATEFORMATCODE tinyint = 1,
    @DATEFORMATPLACECODE tinyint = 3,
    @DATESEPARATORCODE tinyint = 0,     
    @EXCEPTIONBATCHNUMBERCODE tinyint = 0,
    @INCLUDEEXCEPTIONPREFIX bit = 0, 
    @EXCEPTIONPREFIX nvarchar(8) = null
)
as

    set nocount on;

    declare @DATEADDED datetime;
    set @DATEADDED = getdate();

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

    if @ID is null
        set @ID = newid();

    begin try

        insert into dbo.BATCHNUMBERINGSCHEME (
            ID,
            NAME,
            NUMBERINGSCHEMECODE,
            STARTSEQUENCE,
            ACTUALSEQUENCE,
            SEQUENCEPLACECODE,
            SEQUENCESEPARATORCODE,
            NUMBERFORMATCODE,
            INCLUDELABEL,
            USERDEFINEDLABEL,
            LABELPLACECODE,
            LABELSEPARATORCODE,
            INCLUDEDATEFORMAT,
            DATEFORMATCODE,
            DATEFORMATPLACECODE,
            DATESEPARATORCODE, 
            EXCEPTIONBATCHNUMBERCODE, 
            INCLUDEEXCEPTIONPREFIX,
            EXCEPTIONPREFIX,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED
        )
        values (
            @ID,
            @NAME,
            @NUMBERINGSCHEMECODE,
            @ACTUALSEQUENCE,
            @ACTUALSEQUENCE,
            @SEQUENCEPLACECODE,
            @SEQUENCESEPARATORCODE,
            @NUMBERFORMATCODE,
            @INCLUDELABEL,
            @USERDEFINEDLABEL,
            @LABELPLACECODE,
            @LABELSEPARATORCODE,
            @INCLUDEDATEFORMAT,
            @DATEFORMATCODE,
            @DATEFORMATPLACECODE,
            @DATESEPARATORCODE,
            @EXCEPTIONBATCHNUMBERCODE, 
            @INCLUDEEXCEPTIONPREFIX,
            @EXCEPTIONPREFIX,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @DATEADDED,
            @DATEADDED
        )

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;