USP_DATAFORMTEMPLATE_EDITLOAD_PROJECT

The load procedure used by the edit dataform template "Project Edit 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.
@SHORTID	nvarchar(100)	INOUT	ID
@DESCRIPTION	nvarchar(60)	INOUT	Description
@TYPECODEID	uniqueidentifier	INOUT	Type
@LOCATIONCODEID	uniqueidentifier	INOUT	Location
@DIVISIONCODEID	uniqueidentifier	INOUT	Division
@DEPARTMENTCODEID	uniqueidentifier	INOUT	Department
@STARTDATE	datetime	INOUT	Start date
@ENDDATE	datetime	INOUT	End date
@PREVENTDATAENTRY	bit	INOUT	Prevent data entry
@PREVENTDATAENTRYBEFOREDATE	datetime	INOUT	Before
@PREVENTDATAENTRYAFTERDATE	datetime	INOUT	After
@PREVENTPOST	bit	INOUT	Prevent posting
@PREVENTPOSTBEFOREDATE	datetime	INOUT	Before
@PREVENTPOSTAFTERDATE	datetime	INOUT	After
@ELEMENTNAME	nvarchar(100)	INOUT
@ELEMENTLENGTH	int	INOUT
@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.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PROJECT(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @SHORTID nvarchar(100) = null output,
    @DESCRIPTION nvarchar(60) = null output,
    @TYPECODEID uniqueidentifier = null output,
    @LOCATIONCODEID uniqueidentifier = null output,
    @DIVISIONCODEID uniqueidentifier = null output,
    @DEPARTMENTCODEID uniqueidentifier = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
  @PREVENTDATAENTRY bit = null output,
  @PREVENTDATAENTRYBEFOREDATE datetime = null output,
  @PREVENTDATAENTRYAFTERDATE datetime = null output,
  @PREVENTPOST bit = null output,
  @PREVENTPOSTBEFOREDATE datetime = null output,
  @PREVENTPOSTAFTERDATE datetime = null output,
    @ELEMENTNAME nvarchar(100) = null output,
    @ELEMENTLENGTH integer = null output,
    @TSLONG bigint = 0 output
)
as

    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @SHORTID = PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION ,
        @DESCRIPTION = PDACCOUNTSEGMENTVALUE.DESCRIPTION ,
        @TYPECODEID= PROJECT.PROJECTTYPECODEID,
        @LOCATIONCODEID= PROJECT.PROJECTLOCATIONCODEID,
        @DIVISIONCODEID= PROJECT.PROJECTDIVISIONCODEID,
        @DEPARTMENTCODEID= PROJECT.PROJECTDEPARTMENTCODEID,
        @STARTDATE=PROJECT.STARTDATE,
        @ENDDATE=PROJECT.ENDDATE,
    @PREVENTDATAENTRY = PDACCOUNTSEGMENTVALUE.PREVENTDATAENTRY,
    @PREVENTDATAENTRYBEFOREDATE = PDACCOUNTSEGMENTVALUE.PREVENTDATAENTRYBEFOREDATE,
    @PREVENTDATAENTRYAFTERDATE = PDACCOUNTSEGMENTVALUE.PREVENTDATAENTRYAFTERDATE,
    @PREVENTPOST = PDACCOUNTSEGMENTVALUE.PREVENTPOST,
    @PREVENTPOSTBEFOREDATE = PDACCOUNTSEGMENTVALUE.PREVENTPOSTBEFOREDATE,
    @PREVENTPOSTAFTERDATE = PDACCOUNTSEGMENTVALUE.PREVENTPOSTAFTERDATE,
        @ELEMENTNAME = PDACCOUNTSTRUCTURE.DESCRIPTION,
        @ELEMENTLENGTH = (case PDACCOUNTSTRUCTURE.LENGTH when 0 then 100 else PDACCOUNTSTRUCTURE.LENGTH end) ,
        @TSLONG = PROJECT.TSLONG
    from
        dbo.PROJECT
        inner join dbo.PDACCOUNTSEGMENTVALUE on PDACCOUNTSEGMENTVALUE.ID = PROJECT.ID
        inner join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID = PDACCOUNTSTRUCTURE.ID
        left join dbo.PROJECTTYPECODE on PROJECTTYPECODE.ID = PROJECT.PROJECTTYPECODEID
        left join dbo.PROJECTLOCATIONCODE on PROJECTLOCATIONCODE.ID = PROJECT.PROJECTLOCATIONCODEID
        left join dbo.PROJECTDIVISIONCODE on PROJECTDIVISIONCODE.ID = PROJECT.PROJECTDIVISIONCODEID
        left join dbo.PROJECTDEPARTMENTCODE on PROJECTDEPARTMENTCODE.ID = PROJECT.PROJECTDEPARTMENTCODEID
    where
        PROJECT.ID = @ID;


    return 0;