USP_DATAFORMTEMPLATE_PRELOAD_BATCHTEMPLATE

The load procedure used by the edit dataform template "Batch Design Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHTYPECATALOGID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@DATAFORMINSTANCEID	uniqueidentifier	INOUT	DATAFORMINSTANCEID
@TEMPLATEPERMISSIONS	xml	INOUT
@BATCHWORKFLOWID	uniqueidentifier	INOUT	Workflow
@BATCHSPEC	xml	INOUT	Batch spec
@CUSTOMIZEPERMISSIONS	xml	INOUT
@SITEID	uniqueidentifier	INOUT	Site
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_BATCHTEMPLATE
    (                        
        @BATCHTYPECATALOGID uniqueidentifier,
        @DATAFORMINSTANCEID uniqueidentifier = null output,
        @TEMPLATEPERMISSIONS xml = null output,
        @BATCHWORKFLOWID uniqueidentifier = null output,
        @BATCHSPEC xml = null output,
        @CUSTOMIZEPERMISSIONS xml = null output,
        @SITEID uniqueidentifier = null output,
        @CURRENTAPPUSERID uniqueidentifier
    )
    as
    set nocount on;

    declare @ID uniqueidentifier;
    set @ID = newID()

    declare @WORKFLOWCOUNT int
    select top 1 @BATCHWORKFLOWID= BATCHWORKFLOW.ID, @WORKFLOWCOUNT = (select count(BWF.ID) from dbo.BATCHWORKFLOW as BWF where BWF.ID = BATCHWORKFLOW.ID) from dbo.BATCHWORKFLOW
        inner join dbo.BATCHWORKFLOWSTATE on BATCHWORKFLOW.ID = BATCHWORKFLOWSTATE.BATCHWORKFLOWID
        where (BATCHWORKFLOW.BATCHTYPECATALOGID = @BATCHTYPECATALOGID or BATCHWORKFLOW.BATCHTYPECATALOGID is null) and BATCHWORKFLOWSTATE.ISINITIALSTATE = 1

    if @WORKFLOWCOUNT <> 1
        set @BATCHWORKFLOWID = null;

    select @DATAFORMINSTANCEID = (Select TEMPLATESPECXML.value('declare namespace bbfa="bb_appfx_adddataformtemplate";/bbfa:AddDataFormTemplateSpec[1]/@DataFormInstanceID','uniqueidentifier') from DATAFORMTEMPLATECATALOG where ID = BATCHTYPECATALOG.ADDROWDATAFORMTEMPLATEID),
    @BATCHSPEC=BATCHTYPECATALOG.SPECXML,
    @TEMPLATEPERMISSIONS = dbo.UFN_BATCHTEMPLATE_GETSYSTEMROLEPERMISSIONS_TOITEMLISTXML(@ID),
    @CUSTOMIZEPERMISSIONS = dbo.UFN_BATCHTEMPLATE_GETSYSTEMROLECUSTOMIZEPERMISSIONS_TOITEMLISTXML(@ID)
    from dbo.BATCHTYPECATALOG                     
    where BATCHTYPECATALOG.ID = @BATCHTYPECATALOGID

    set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);

    return 0