USP_DATAFORMTEMPLATE_VIEW_BILLINGINDIVIDUALCHARGETOTAL

The load procedure used by the view dataform template "Billing Individual Charge Total 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.
@CHARGETOTALSBYBILLINGCYCLE	xml	INOUT	CHARGETOTALSBYBILLINGCYCLE
@CHARGETOTALSBYYEAR	xml	INOUT	CHARGETOTALSBYYEAR

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BILLINGINDIVIDUALCHARGETOTAL
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CHARGETOTALSBYBILLINGCYCLE xml = null output,
                    @CHARGETOTALSBYYEAR xml = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select @DATALOADED = 1,
                           @CHARGETOTALSBYBILLINGCYCLE = (select BILLINGITEMNAME,
                                                                    ISTOTAL,
                                                                    TOTAL1AMOUNT,
                                                                    TOTAL1LABEL,
                                                                    TOTAL2AMOUNT,
                                                                    TOTAL2LABEL,
                                                                    TOTAL3AMOUNT,
                                                                    TOTAL3LABEL
                                                            from dbo.UFN_BILLINGINDIVIDUALCHARGETOTAL(@ID, getdate(), 0)
                                                            order by ISTOTAL desc,
                                                                        BILLINGITEMNAME asc
                                                            for xml raw('ITEM'),type,elements,root('CHARGETOTALSBYBILLINGCYCLE'),BINARY BASE64),
                           @CHARGETOTALSBYYEAR = (select BILLINGITEMNAME,
                                                            ISTOTAL,
                                                            TOTAL1AMOUNT,
                                                            TOTAL1LABEL,
                                                            TOTAL2AMOUNT,
                                                            TOTAL2LABEL,
                                                            TOTAL3AMOUNT,
                                                            TOTAL3LABEL
                                                    from dbo.UFN_BILLINGINDIVIDUALCHARGETOTAL(@ID, getdate(), 1)
                                                            order by ISTOTAL desc,
                                                                        BILLINGITEMNAME asc
                                                    for xml raw('ITEM'),type,elements,root('CHARGETOTALSBYYEAR'),BINARY BASE64)

                    return 0;