USP_DATAFORMTEMPLATE_VIEW_SALESORDER_ORDERCOMPLETE

The load procedure used by the view dataform template "Advance Sales Order Complete Panel"

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.
@CONSTITUENTEXISTS	bit	INOUT	CONSTITUENTEXISTS
@ORDERTOTAL	money	INOUT	ORDERTOTAL
@ORDERITEMCOUNT	int	INOUT	ORDERITEMCOUNT
@AMOUNTPAID	money	INOUT	AMOUNTPAID
@STATUSCODE	tinyint	INOUT	STATUSCODE

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SALESORDER_ORDERCOMPLETE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CONSTITUENTEXISTS bit = null output,
    @ORDERTOTAL money = null output,
    @ORDERITEMCOUNT int = null output,
    @AMOUNTPAID money = null output,
    @STATUSCODE tinyint = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @CONSTITUENTEXISTS = case when CONSTITUENTID is null then 0 else 1 end,
        @ORDERTOTAL = TOTALS.TOTAL,
        @AMOUNTPAID = TOTALS.AMOUNTPAID,
        @ORDERITEMCOUNT = coalesce((select count(SALESORDERITEM.ID) from dbo.SALESORDERITEM where SALESORDERITEM.SALESORDERID = @ID and SALESORDERITEM.TYPECODE in (0,1,2,6)), 0),
        @STATUSCODE = STATUSCODE
    from
        dbo.SALESORDER
    outer apply
        dbo.UFN_SALESORDER_TOTALS(SALESORDER.ID) as TOTALS
    where
        SALESORDER.ID = @ID

    if @DATALOADED = 0
    begin
        select
            @DATALOADED = 1,
            @CONSTITUENTEXISTS = 0,
            @ORDERTOTAL = 0,
            @ORDERITEMCOUNT = 0
    end

    return 0;