USP_DATAFORMTEMPLATE_EDITLOAD_COMMITMULTIPLEBATCHES2PROCESS

The load procedure used by the edit dataform template "Commit Multiple Batches Edit Form 2"

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.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(1000)	INOUT	Description
@COMMITEDIT	tinyint	INOUT	Commit
@RECORDTYPEID	uniqueidentifier	INOUT
@SELECTIONID	uniqueidentifier	INOUT	Selection
@QUERYID	uniqueidentifier	INOUT	Query id
@QUERYTYPE	nvarchar(10)	INOUT	Query type
@CREATEOUTPUTSELECTION	bit	INOUT	Create output selections
@CREATEEXCEPTIONBATCHES	bit	INOUT	Create exception batches
@PURGEBATCHES	bit	INOUT	Delete batches after commit
@CREATEBATCHCONTROLREPORTS	bit	INOUT	Create control reports
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEID	uniqueidentifier	INOUT	Site

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COMMITMULTIPLEBATCHES2PROCESS(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@NAME nvarchar(100) = null output,
@DESCRIPTION nvarchar(1000) = null output,
@COMMITEDIT tinyint = null output,
@RECORDTYPEID uniqueidentifier = null output,
@SELECTIONID uniqueidentifier = null output,
@QUERYID uniqueidentifier = null output,
@QUERYTYPE nvarchar(10) = null output,
@CREATEOUTPUTSELECTION bit = null output,
@CREATEEXCEPTIONBATCHES bit = null output,
@PURGEBATCHES bit = null output,
@CREATEBATCHCONTROLREPORTS bit = null output,
@TSLONG bigint = 0 output,
@CURRENTAPPUSERID uniqueidentifier = null,
@SITEID uniqueidentifier = null output
)
as
begin
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;
    declare @BUSINESSPROCESSCATALOGID uniqueidentifier = '8bda5883-5fc0-4b1e-b88a-b6cba975f515';

    select
        @DATALOADED = 1,
        @NAME = BATCHESCOMMITPROCESS.NAME,
        @DESCRIPTION = BATCHESCOMMITPROCESS.DESCRIPTION,
        @SELECTIONID = BATCHESCOMMITPROCESS.SELECTIONID,
        @CREATEOUTPUTSELECTION = BATCHESCOMMITPROCESS.CREATEOUTPUTSELECTION,
        @CREATEEXCEPTIONBATCHES = BATCHESCOMMITPROCESS.CREATEEXCEPTIONBATCHES,
        @PURGEBATCHES = BATCHESCOMMITPROCESS.PURGEBATCHES,
    @CREATEBATCHCONTROLREPORTS = BATCHESCOMMITPROCESS.CREATEBATCHCONTROLREPORTS,
        @TSLONG = BATCHESCOMMITPROCESS.TSLONG,
        @SITEID = BUSINESSPROCESSINSTANCE.SITEID
    from dbo.BATCHESCOMMITPROCESS
    left join dbo.BUSINESSPROCESSINSTANCE 
        on  BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID = BATCHESCOMMITPROCESS.ID
        and BUSINESSPROCESSINSTANCE.BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID
    where BATCHESCOMMITPROCESS.ID = @ID;

    select @RECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'BATCH';
    select @QUERYID = dbo.UFN_IDSET_GETQUERYID(@SELECTIONID);
    select @QUERYTYPE = dbo.UFN_IDSET_GETQUERYTYPE(@SELECTIONID);
  IF (@SELECTIONID is null) 
    select @COMMITEDIT = 0 
  Else
    select @COMMITEDIT = 1

    return 0;
 end