multi datasource lookup

multi datasource lookup

public void lookup()
{

#define.seperator(‘, ‘)
SysTableLookup tablelookup;
QueryBuildRange qbr;
QueryRun qrun;
QueryBuildDataSource qbds1, qbds2;
QueryBuildLink qblink1;
Query q = new Query();
IPMPFBanks iPMPFBanks;
Name allPackIds;
;

tablelookup = SysTableLookup::newParameters(tableNum(BankAccountTable),this);
qbds1 = q.addDataSource(tableNum(BankAccountTable));
qbds2= qbds1.addDataSource(tableNum(IPMPFBanks));
qbds2.joinMode(JoinMode::InnerJoin);
qblink1 = qbds2.addLink(fieldNum(IPMPFBanks,PortfolioAccount), fieldNum(BankAccountTable, AccountNum));
qbds2.relations(true);
while select iPMPFBanks where iPMPFBanks.PortfolioID ==IPMPFComodityTable.PortfolioID
{
allPackIds += (iPMPFBanks.PortfolioAccount + #seperator);
}
qbds1.addRange(fieldNum(BankAccountTable,AccountNum)).value(allPackIds);//(queryValue(iPMPFBanks.PortfolioAccount));
qbds1.addOrderByField(fieldnum(BankAccountTable,AccountNum ));
qbds1.addOrderByField(fieldnum(BankAccountTable,AccountID ));
qbds1.addOrderByField(fieldnum(BankAccountTable,Name ));
qbds1.orderMode(OrderMode::GroupBy);
tablelookup.parmQuery(q);
//tablelookup.addLookupField(fieldNum(IPMPFBanks,PortfolioAccount));
tablelookup.addLookupfield(fieldNum(BankAccountTable,AccountNum));
tablelookup.addLookupfield(fieldNum(BankAccountTable, AccountID));
tablelookup.addLookupfield(fieldNum(BankAccountTable, Name));

tablelookup.performFormLookup();
}

/*public void lookup()
{

IPMPFBanks IPMPFBanks;
//IPMPFComodityTable IPMPFComodityTable;
SysTableLookup IPMPFBankslookup;
Query query = new Query();
IPMPFBanks iPMPFBanksloc;
String255 append;
QueryBuildDataSource qbdsIPMPFBanks;
// QueryBuildDataSource qbdsVendTable;
//QueryBuildDataSource qbdsDirpartyTable;
//QueryBuildRange qbrPortfolioID;
// VendTable Vendtable;

 IPMPFBankslookup = SysTableLookup::newParameters(tableNum(IPMPFBanks), this);

qbdsIPMPFBanks = query.addDataSource(tableNum(IPMPFBanks));
//qbdsIPMPortfolioMembers = query.addDataSource(tableNum(CustTable));

qbdsIPMPFBanks.addRange(fieldNum(IPMPFBanks,PortfolioID)).value(queryValue(IPMPFComodityTable.PortfolioID));
//qbdsIPMPortfolioMembers.addRange(fieldNum(CustTable,AccountNum)).value(queryValue(IPMPfInvestmentLines.PortfolioID));
IPMPFBankslookup.parmQuery(query);

IPMPFBankslookup.addLookupfield(fieldNum(IPMPFBanks,PortfolioAccount),true);
// IPMPFBankslookup.addLookupfield(fieldNum(IPMPFBanks,PortfolioID));
//IPMPFBankslookup.addLookupfield(fieldNum(BankAccountTable,AccountID),true);
//IPMpfmemberslookup.addLookupfield(fieldNum(CustTable,AccountNum),true);

//IPMpfmemberslookup.addLookupfield(fieldNum(IPMPortfolioMembers,IPMPortfolioMemberID),true);

IPMPFBankslookup.performFormLookup();
}*/

lookup method

lookup method

Look up-

public void lookup()

{

    //super();

    Query               query;

    SysTableLookup      sysTableLookup;

    query = new Query();

    sysTableLookup = SysTableLookup::newParameters(tableNum(DirPerson), this);

    query.addDataSource(tableNum(DirPerson));

    sysTableLookup.addLookupfield(fieldNum(DirPerson, Name));

    sysTableLookup.addLookupfield(fieldNum(DirPerson, PartyNumber));

   // sysTableLookup.addLookupfield(fieldNum(LogisticsAddressCountryRegionNameView, ShortName));

   // sysTableLookup.setLabel(“@SYS7576″);

   // sysTableLookup.addLookupfield(fieldNum(LogisticsAddressCountryRegionNameView, AddrFormat));

    sysTableLookup.parmQuery(query);

   sysTableLookup.performFormLookup();

}

Job for SSRS Report:

Job for SSRS Report:

static void debugreport(Args _args)

    {

      /*  JmgEmplSignedInDP empl;

        JmgEmplSignedInContract con;

        Query q;

        ;

         empl = new JmgEmplSignedInDP();

        con = new JmgEmplSignedInContract();

        q = new Query(querystr(JmgEmplSignedInQuery));

        empl.parmQuery(q);

        empl.parmDataContract(con);

         empl.processReport();*/

         AlkhaldiPOTransRptDP empl;

        AlkhaldiPOTransRptContract con;

        Query q;

        AlkhaldiPOTransTmp      AlkhaldiPOTransTmp;

        ;

         empl = new AlkhaldiPOTransRptDP();

        con = new AlkhaldiPOTransRptContract();

        q = new Query(querystr(AlkhaldiPOTransQry));

        empl.parmQuery(q);

        empl.parmDataContract(con);

         empl.processReport();

        AlkhaldiPOTransTmp = empl.getLedgerJournalTmp();

    //    empl.insertalkPOTranstmp();

    }

Job for SSRS Report:

 static void DpDebug(Args _args)

{

    SaleInvTmp      SaleInvTmp;

    SalesInvDp    SalesInvDp;

    SaleInvContract SaleInvContract;

    SalesInvDp   dataprovider = new SalesInvDp();

   // SaleInvContract = new SaleInvContract();

    dataprovider.processReport();

    SaleInvTmp = dataprovider.getSaleInvTmp();

}

Job for SSRS Report:

static void Debugging(Args _args)

{

    /*ProdRouteTrans  prodRouteTrans;

    ConsSummaryMTmp  consSummaryMTmp;

    ProductConsumptionSummaryReportDP   dataprovider = new ProductConsumptionSummaryReportDP();*/

    SalesConfirmDp  dataprovider = new SalesConfirmDp();

    recId ret;

    //ContractClass    contract    = new ConsSummaryMContractClass();

    SalesConfirmContract    contract    = new SalesConfirmContract();

    SalesConfirmDetailsTmp  SalesConfirmDetailsTmp;

    salesConfirmHeaderTmp  salesConfirmHeaderTmp;

    ;

 // contract.parmAgentCode(“CEU-000009″);

    /*contract.parmFromDate(str2Date(“12/15/2012″,213));

    contract.parmToDate(str2Date(“12/15/2012″,213));

   // contract.parmProdUnitId(“2″);

    contract.parmwrkCtrlId(“CFW1″);

    dataProvider.parmDataContract(contract);

    dataProvider.processReport();

    consSummaryMTmp = dataProvider.getConsSummaryMTmp();*/

  //  ACWATransferhistoryTmp = dataProvider.getNSGFinalQuittanceAvowalTmp();

     //pause;

   /* ;

    while select prodRouteTrans group by TransRefId

         where (prodRouteTrans.TransRefId == “PRD_00000002″ || prodRouteTrans.TransRefId == “PRD_00000010″)

            && prodRouteTrans.TransType == ProdRouteTransType::Qty

          //  && prodRouteTrans.DateWIP == str2Date(“12/5/2012″,213)

            && prodRouteTrans.ProdUnitId == “1″

            && prodRouteTrans.WrkCtrId == “00102″

    {

        info(prodRouteTrans.TransRefId);

    }

    */

    ret = 5637145081;

    contract.parmDocumentTitle(“confirmation copy”);

    contract.parmFormLetterRecordId(0);

    //contract.parmRecordId(recId _recordId = 5637145081);

dataprovider.parmDataContract(contract);

    dataprovider.processReport();

    SalesConfirmDetailsTmp = dataprovider.getSalesConfirmDetailsTmp();

    SalesConfirmHeaderTmp = dataprovider.getSalesConfirmHeaderTmp();

}

UI and Contract Class and methods

UI and Contract Class

Contract : 

[

    DataContractAttribute,

   SysOperationContractProcessingAttribute(classStr(ProjHourUtilisationUIBuilder))

    // SysOperationContractProcessingAttribute(classstr(ProjHourUtilisationUIBuilder), SysOperationDataContractProcessingMode::CreateSeparateUIBuilderForEachContract)

    //SysOperationGroupAttribute('PrintOut', "@SYS12608", '2')

]

class ProjHourUtilisationContract implements SysOperationValidatable

{

    ProjWorkerRecId projWorkerRecId;

    ProjId projId;

    ProjCategoryId category;

    FromDate fromDate;

    ToDate toDate;

}

/// <summary>

[

    DataMemberAttribute('ToDate'),

    SysOperationGroupMemberAttribute('Date'),

    SysOperationDisplayOrderAttribute('5')

]

public ToDate parmToDate(ToDate _toDate = toDate)

{

    toDate = _toDate;

    return toDate;

}

=================================================public boolean validate()

{

    boolean             isValid = true;

    if(!projWorkerRecId)

        throw error(“Select Employee ID”);*/

    return isValid;

}

[

    DataMemberAttribute('Category'),

 SysOperationDisplayOrderAttribute('2')

]

public ProjCategoryId parmCategory(ProjCategoryId _ProjCategoryId = category)

{

    category = _ProjCategoryId;

    return category;

}

[

    DataMemberAttribute('FromDate'),

   SysOperationGroupMemberAttribute('Date'),

   SysOperationDisplayOrderAttribute('4')

]

public FromDate parmFromDate(FromDate _fromDate = fromDate)

{

    fromDate = _fromDate;

    return fromDate;

}

UI Builder Class:

class ProjHourUtilisationUIBuilder extendsSysOperationAutomaticUIBuilder

{

    ProjHourUtilisationContract projHourUtilisationContract;

    DialogField dialogCategory;

    DialogField dialogProject;

    DialogField dialogEmployee;

    DialogField fromDate;

    DialogField toDate;

}

public void build()

{

    Dialog      dialogLocal = this.dialog();

     projHourUtilisationContract = this.dataContractObject();

    this.addDialogField(methodStr(ProjHourUtilisationContract,parmProjectId), projHourUtilisationContract);

    this.addDialogField(methodStr(ProjHourUtilisationContract,parmCategory), projHourUtilisationContract);

    this.addDialogField(methodStr(ProjHourUtilisationContract,parmEmployeeId), projHourUtilisationContract);

   this.addDialogField(methodStr(projHourUtilisationContract,parmFromDate),projHourUtilisationContract);

   this.addDialogField(methodStr(projHourUtilisationContract,parmToDate),projHourUtilisationContract);

}

public void getFromDialog()

{

    projHourUtilisationContract = this.dataContractObject();

    super();

}

public void initializeFields()

{

    projHourUtilisationContract = this.dataContractObject();

}

 public void lookupCategory(FormStringControl _control)

{

    Query query = new Query();

    SysTableLookup sysTablelookup;

    sysTablelookup =SysTableLookup::newParameters(tableNum(ProjCategory),_control);

    sysTablelookup.addLookupfield(fieldNum(ProjCategory,CategoryId));

    sysTablelookup.addLookupfield(fieldnum(ProjCategory,Name));

//that table display method(show in lookup) for thatbelowline

sysTablelookup.addLookupMethod(“EmplName”);

    sysTablelookup.addLookupfield(fieldnum(ProjCategory,CategoryType));

     query.addDataSource(tableNum(ProjCategory));

    query.dataSourceTable(tableNum(ProjCategory)).addRange(fieldNum(ProjCategory, CategoryType)).value(queryValue(ProjCategoryType::Hour));

    sysTablelookup.parmQuery(query);

    sysTablelookup.performFormLookup();

}

 // <summary>

/// Override this method in order to register the dialog field methods to capture events.

/// </summary>

public void postRun()

{

    Dialog dialogLocal = this.dialog();

    super();

    // This method should be called in order to handle events on dialogs.

   dialogLocal.dialogForm().formRun().controlMethodOverload(false);

 }

 public void postBuild()

{

    ;

    super();

    dialogCategory = this.bindInfo().getDialogField(

                         this.dataContractObject(),

                         methodStr(ProjHourUtilisationContract,parmCategory));

    // register override method for lookup customer

    dialogCategory.registerOverrideMethod(methodStr(FormStringControl, lookup),methodStr(ProjHourUtilisationUIBuilder,lookupCategory),this);

    dialogProject = this.bindInfo().getDialogField(

                         this.dataContractObject(),

                         methodStr(ProjHourUtilisationContract,parmProjectId));

    dialogEmployee = this.bindInfo().getDialogField(

                         this.dataContractObject(),

                         methodStr(ProjHourUtilisationContract,parmEmployeeId));

    fromDate = this.bindInfo().getDialogField(

                         this.dataContractObject(),

                         methodStr(ProjHourUtilisationContract,parmFromDate));

    toDate =this.bindInfo().getDialogField(

                         this.dataContractObject(),

                         methodStr(ProjHourUtilisationContract,parmToDate));

  }