Simple batch job by using RunBaseBatch framework

 This code will help you to create simple batch job

class BASBBRMyDemoBatch extends RunBaseBatch

{

    DialogField         dlgStartDate;

    DialogField         dlgEndDate;

    DialogField         dlgSalesStatus;

    TransDate           startDate;

    TransDate           endDate;

    SalesStatus         salesStatus;


    //<summary>

    //Adds the <c>SalesID</c> to the dialog box

    //allowing the user to run a batch over the selected

    //<c>SalesID</c>.

    //</summary>

    //<returns>

    //The dialog box box.

    //</returns>

    public Object dialog()

    {

        DialogRunbase               dialog;


        //Setup the dialog

        dialog = super();

        dialog.caption("@MCR12442");


        dlgStartDate = dialog.addField(extendedtypestr(TransDate), "@SYS35856" );

        dlgStartDate.value('');


        dlgEndDate = dialog.addField(extendedtypestr(TransDate), "@SYS22882" );

        dlgEndDate.value('');


        dlgSalesStatus = dialog.addField(enumStr(salesStatus), "Sales status" );


        return dialog;

    }


    /// <summary>

    /// Retrieves the user entered values from dialog form.

    /// </summary>

    /// <returns>

    /// true if the values are retrieved successfully; otherwise, false.

    /// </returns>

    public boolean getFromDialog()

    {

        boolean ret;


        ret = super();


        startDate   = dlgStartDate.value();

        if (!startDate)

        {

            startDate = DateTimeUtil::date(DateTimeUtil::minValue());

        }


        endDate     = dlgEndDate.value();

        if (!endDate)

        {

            endDate = DateTimeUtil::date(DateTimeUtil::maxValue());

        }


        salesStatus = dlgSalesStatus.value();


        return ret;

    }


    public static BASBBRMyDemoBatch construct()

    {

        return new BASBBRMyDemoBatch();

    }


    public boolean canRunInNewSession()

    {

        return false;

    }


    public void run()

    {

        //11:59:59

        int                     time = 86399;

        SalesTable salesTable;

        BASBBRSalesTable basSalesTable,localBASBBR;


        while select * from salesTable

            where salesTable.CreatedDateTime > DateTimeUtil::newDateTime(startDate,0)

            && salesTable.CreatedDateTime < DateTimeUtil::newDateTime(endDate,time)

            && salesTable.SalesStatus == salesStatus

        {

            ttsbegin;

            basSalesTable.SalesId     = salesTable.SalesId;

            basSalesTable.SalesStatus = salesTable.SalesStatus;

            basSalesTable.insert();

            ttscommit;

        }

    }


    public static ClassDescription description()

    {

        return "Demo batch job";

    }


    public static void main(Args args)

    {

        BASBBRMyDemoBatch myDemoBatch = new BASBBRMyDemoBatch();

        myDemoBatch.parmInBatch(false);


        if (myDemoBatch.prompt())

            myDemoBatch.runOperation();

    }


}

Comments

Post a Comment

Popular posts from this blog

How to Create a wizard in x++ d365

Image
 step1: Create a form and apply form pattern as wizard step2 : create a class and extend the class with SysWizard. code :            class BAS_WIzardScreen extends SysWizard {     #MACROLIB.AviFiles     FormName formname()     {         return formstr(BAS_WIzardForm);  // name of the wizard form     }     public void run()     {         info(strFmt("Thankyou"));     }     public void setupNavigation()     {     }     public boolean validate()     {         return true;     }     public static str description()     {         return "BASOFA WIZARD";  // title of the wizard     }     public static void main(Args _args)     {         BAS_WIzardScreen wizard = new BAS_WIz...
Read more

how to post trade agreement journals automatically using x++ code

  In Microsoft Dynamics AX, you can post trade agreement journals automatically using X++ code. Here are the steps to do so: Create a new job in X++. Write a code to fetch data from the trade agreement table. Create a journal header and journal lines based on the fetched data. Call the post() method of the journal header to post the journal. Repeat steps 2 to 4 for each trade agreement. Here's a sample code in X++: static void postTradeAgreementJournals(Args _args) { TradeAgreementTable tradeAgreementTable; GeneralJournalHeader generalJournalHeader; GeneralJournalLine generalJournalLine; // Fetch data from the Trade Agreement table select tradeAgreementTable where tradeAgreementTable.JournalPosting == NoYes::No; // Loop through each trade agreement while (tradeAgreementTable) { // Create a journal header generalJournalHeader = new GeneralJournalHeader(); generalJournalHeader.initValue(); generalJournalHeader.tra...
Read more

X++ code to CREATE AND POST A TRADE AGREEMENT IN MICROSOFT DYNAMICS 365 in D365 F & O

Reuirement : I have to create a table called BASTradeAgreementTable with fields like following Item number Product Name ToDate FromDate InventSiteId InventLocationId Amount From Unit Step2: After Creating Table I have to create a form and add the created table into the form datasource and add all the fields of that datasource to form grid. I have to create a button called Post whenever user clicks on that button i have to create and post Trade Agreement Journals with the data provided in the form grid. [Control("Button")]     class Post     {         /// <summary>         ///         /// </summary>         public void clicked()         {             int             recordsCount;              BASTradeAgreementTable    tradeAgreement;     ...
Read more