Thursday, 27 October 2016

PO Inquiry
------------------------------
inqueiry using dynamic query:-

-----------------------------------------------------------------------------------------


init method:-
-----------------------------------------------------------------------------------------


public void init()
{
    super();
    delete_from M_purchTemp;
}


------------------------------------------------------------------------------------------



clicked method:-
-----------------------------------------------------------------------------------------
void clicked()
{
    Query query;
    QueryBuildDataSource qbds;
    QueryBuildRange qbr;
    QueryRun qr;
    void clicked()
{
    Query query;
    QueryBuildDataSource qbds;
    QueryBuildRange qbr,qbr1,qbr2;
    QueryRun qr;
    PurchTable purchTable;
    M_purchTemp obj;



    str var;
    str id;

    super();
    delete_from m_purchTemp;

        query   =   new query();
        qbds    =   Query.addDataSource(tableNum(purchTable));
        var     =   M_purchTemp_InvoiceAccount.valueStr();
        id      =   M_purchTemp_PurchId.valueStr();
   
        qbr     =   qbds.addRange(fieldNum(purchTable,invoiceAccount));
        qbr1    =   qbds.addRange(fieldNum(purchTable,PurchId));
        qbr2    =   qbds.addRange(fieldNum(purchTable,PurchStatus));
       
        qbr.value(var);
        qbr1.value(id);
        qbr2.value(queryValue(any2enum(M_purchTemp_PurchStatus1.selection())));

        qr=new QueryRun(query);
     while(qr.next())
     {
        purchTable            =     qr.get(tableNum(PurchTable));
        obj.InvoiceAccount    =     purchTable.InvoiceAccount;
        obj.VendGroup         =     purchTable.VendGroup;
        obj.Name              =     purchTable.PurchName;
        obj.DocumentStatus    =     purchTable.DocumentStatus;
        obj.PurchStatus       =     purchTable.PurchStatus;
        obj.PurchId           =     purchTable.PurchId;
        obj.insert();
    }

    M_purchTemp_ds.refresh();
     M_purchTemp_ds.research();
     //M_purchTemp_ds.reread();


}

No comments:

Post a Comment