USP_DATAFORMTEMPLATE_VIEW_DISCOUNTGROUPDETAILMERCHANDISE

The load procedure used by the view dataform template "Discount Group Detail Merchandise 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.
@DISCOUNTGROUPDETAILAPPLICATION	nvarchar(255)	INOUT	Applies to
@DISCOUNTTYPECODE	tinyint	INOUT	DISCOUNTTYPECODE
@APPLIESTOMERCHANDISE	bit	INOUT	APPLIESTOMERCHANDISE
@MERCHANDISEAMOUNT	money	INOUT	Value
@MERCHANDISEPERCENT	decimal(5, 2)	INOUT	Value
@CALCULATIONTYPE	nvarchar(100)	INOUT	Calculation type
@CALCULATIONTYPECODE	tinyint	INOUT	CALCULATIONTYPECODE
@APPLIESTOCODE	tinyint	INOUT	APPLIESTOCODE

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DISCOUNTGROUPDETAILMERCHANDISE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @DISCOUNTGROUPDETAILAPPLICATION nvarchar(255) = null output,
    @DISCOUNTTYPECODE tinyint = null output,
    @APPLIESTOMERCHANDISE bit = null output,
    @MERCHANDISEAMOUNT money = null output,
    @MERCHANDISEPERCENT decimal(5,2) = null output,
    @CALCULATIONTYPE nvarchar(100) = null output,
    @CALCULATIONTYPECODE tinyint = null output,
    @APPLIESTOCODE tinyint = null output
)
as
    set nocount on;

    set @DATALOADED = 1;

    select top 1
        @DISCOUNTGROUPDETAILAPPLICATION = DISCOUNTGROUPDETAIL.DISCOUNTGROUPDETAILAPPLICATION,
        @CALCULATIONTYPE = CALCULATIONTYPE,
        @CALCULATIONTYPECODE = CALCULATIONTYPECODE,
        @DISCOUNTTYPECODE = DISCOUNT.DISCOUNTTYPECODE,
        @APPLIESTOMERCHANDISE = DISCOUNT.APPLIESTOMERCHANDISE,
        @MERCHANDISEAMOUNT = DISCOUNT.MERCHANDISEAMOUNT,
        @MERCHANDISEPERCENT = DISCOUNT.MERCHANDISEPERCENT,
        @APPLIESTOCODE = DISCOUNT.APPLIESTOCODE,
        @DATALOADED = 1
    from dbo.DISCOUNTGROUPDETAIL
    inner join dbo.DISCOUNTGROUP
        on DISCOUNTGROUPDETAIL.DISCOUNTGROUPID = DISCOUNTGROUP.ID
    inner join dbo.DISCOUNT
        on DISCOUNT.ID = DISCOUNTGROUP.DISCOUNTID
    where DISCOUNT.ID = @ID
        and DISCOUNTEDITEM = 1
        and DISCOUNTGROUPDETAIL.DISCOUNTGROUPDETAILAPPLICATIONCODE <> 3

    return 0;