USP_DATAFORMTEMPLATE_VIEW_PHONEFINDERPAGEEXPRESSION

The load procedure used by the view dataform template "PhoneFinder Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PAGECAPTION	nvarchar(660)	INOUT	Page caption
@PHONEFINDERSUBMITPROCESSID	uniqueidentifier	INOUT	PhoneFinder submit process ID
@PHONEFINDERGETPROCESSID	uniqueidentifier	INOUT	PhoneFinder get process ID
@BATCHID	uniqueidentifier	INOUT	Batch ID
@FILEUPLOADED	bit	INOUT	File uploaded
@FILEDOWNLOADED	bit	INOUT	File downloaded
@FILEAVAILABLE	bit	INOUT	File available
@BATCHSTATUSCODE	tinyint	INOUT	Batch status code
@ALLOWCOMMIT	bit	INOUT	ALLOWCOMMIT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PHONEFINDERPAGEEXPRESSION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @PAGECAPTION nvarchar(660) = null output,
    @PHONEFINDERSUBMITPROCESSID uniqueidentifier = null output,
    @PHONEFINDERGETPROCESSID uniqueidentifier = null output,
    @BATCHID uniqueidentifier = null output,
    @FILEUPLOADED bit = null output,
    @FILEDOWNLOADED bit = null output,
    @FILEAVAILABLE bit = null output,
    @BATCHSTATUSCODE tinyint = null output,
    @ALLOWCOMMIT bit = null output
)
as
begin
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @PAGECAPTION = coalesce(SITE.[NAME] + N' - ', N'') + coalesce(PHONEFINDER.[NAME], N''),
        @PHONEFINDERSUBMITPROCESSID = PHONEFINDERSUBMITPROCESS.[ID],
        @PHONEFINDERGETPROCESSID = PHONEFINDERGETPROCESS.[ID],
        @BATCHID = PHONEFINDER.[BATCHID],
        @FILEUPLOADED = PHONEFINDER.[FILEUPLOADED],
        @FILEDOWNLOADED = PHONEFINDER.[FILEDOWNLOADED],
        @FILEAVAILABLE = PHONEFINDER.[FILEAVAILABLE],
        @BATCHSTATUSCODE = dbo.UFN_BATCH_GETSTATUSCODE(PHONEFINDER.[BATCHID])
    from 
        dbo.PHONEFINDER
        inner join dbo.PHONEFINDERSUBMITPROCESS on PHONEFINDERSUBMITPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
        inner join dbo.PHONEFINDERGETPROCESS on PHONEFINDERGETPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
        left outer join dbo.SITE on SITE.[ID] = PHONEFINDER.[SITEID]
    where PHONEFINDER.[ID] = @ID;

    if @DATALOADED = 1
        select 
            @ALLOWCOMMIT = BATCHWORKFLOWSTATE.[ALLOWCOMMIT]
        from
            dbo.BATCHWORKFLOWSTATE
            inner join dbo.BATCHWORKFLOW on BATCHWORKFLOW.[ID] = BATCHWORKFLOWSTATE.[BATCHWORKFLOWID]
        where
            BATCHWORKFLOW.[BATCHTYPECATALOGID] = '6abf3e1e-25e3-4429-91b2-9496c3dda413';

    return 0;
end