Engineer / Solution Architect / Dynamics 365-AX Technical Consultant / Instructor (MCT)

Global  değişkenler

class ETGHRMKariyerSync

{

    CCADOConnection         ADOConnection;

    CCADOConnection         Connection;

}

UPDATE

public static server void HRMEducationTypeUpdate(HRMEducationType _HRMEducationType )

{

    Statement   statement;

    str         SQLCommand;

    ;

    // Set the SQL statement

    SQLCommand = ‘SET DATEFORMAT DMY ‘;

    SQLCommand += “UPDATE [Kariyer].[dbo].[WHRMEDUCATIONTYPE]“;

    SQLCommand += strfmt(“SET [HRMEDUCATIONTYPEID] = ‘%1′ , [DESCRIPTION] = ‘%2′ , [DATAAREAID] = ‘%3′ , [RECVERSION] = %4 WHERE [RECID] = %5″

                        ,_HRMEducationType.hrmEducationTypeId

                        ,_HRMEducationType.description

                        ,_HRMEducationType.dataAreaId

                        ,_HRMEducationType.recVersion

                        ,_HRMEducationType.RecId);

    //Execute Command

    ETGHRMKariyerSync::execCommand(SQLCommand);

}

                INSERT

public static server void HRMEducationTypeInsert(HRMEducationType _HRMEducationType )

{

    Statement   statement;

    str         SQLCommand;

    ;

    // Set the SQL statement

    SQLCommand = ‘SET DATEFORMAT DMY ‘;

    SQLCommand += ‘INSERT INTO [KariyerZaman].[dbo].[WHRMEDUCATIONTYPE] ([HRMEDUCATIONTYPEID] ,[DESCRIPTION] ,[DATAAREAID] ,[RECVERSION] ,[RECID])’;

    SQLCommand += strfmt(“VALUES ( ‘%1′ , ‘%2′ , ‘%3′ , %4 , %5)”

                        ,_HRMEducationType.hrmEducationTypeId

                        ,_HRMEducationType.description

                        ,_HRMEducationType.dataAreaId

                        ,_HRMEducationType.recVersion

                        ,_HRMEducationType.RecId);

    //Execute Command

    ETGHRMKariyerSync::execCommand(SQLCommand);

}

                DELETE

public static server void HRMEducationTypeDelete (HRMEducationType _HRMEducationType )

{

    Statement   statement;

    str         SQLCommand;

    ;

    // Set the SQL statement

    SQLCommand = “DELETE [Kariyer].[dbo].[WHRMEDUCATIONTYPE]“;

    SQLCommand += strfmt(“WHERE [RECID] = %1″

                        ,_HRMEducationType.RecId);

    //Execute Command

    ETGHRMKariyerSync::execCommand(SQLCommand);

}