static void Job2runDP(Args _args)
{
TenantBalanceDetailsTmpTbl TenantBalanceDetailsTmpTbl; //temp table name
Query q;
TenantBalanceBuildingLevRDP dataProvider = new TenantBalanceBuildingLevRDP();
//DP class name
TenantBalanceBuildingLevContract contract = new TenantBalanceBuildingLevContract();
//contract class name
contract.parmNetBuildingId('CEU-000022');
//parameter that you passing in contract class
q = dataProvider.parmQuery();
dataProvider.parmDataContract(contract);
dataProvider.processReport();
TenantBalanceDetailsTmpTbl = dataProvider.getTenantBalanceDetailsTmpTbl();
while select TenantBalanceDetailsTmpTbl group by buildingId
{
print(TenantBalanceDetailsTmpTbl.BuildingId);
//Just print the filed that you want see the output
print(TenantBalanceDetailsTmpTbl.TotalCredit);
print(TenantBalanceDetailsTmpTbl.TotalDebit);
print(TenantBalanceDetailsTmpTbl.BalanceCredit);
print(TenantBalanceDetailsTmpTbl.BalanceDebit);
}
pause;
}
{
TenantBalanceDetailsTmpTbl TenantBalanceDetailsTmpTbl; //temp table name
Query q;
TenantBalanceBuildingLevRDP dataProvider = new TenantBalanceBuildingLevRDP();
//DP class name
TenantBalanceBuildingLevContract contract = new TenantBalanceBuildingLevContract();
//contract class name
contract.parmNetBuildingId('CEU-000022');
//parameter that you passing in contract class
q = dataProvider.parmQuery();
dataProvider.parmDataContract(contract);
dataProvider.processReport();
TenantBalanceDetailsTmpTbl = dataProvider.getTenantBalanceDetailsTmpTbl();
while select TenantBalanceDetailsTmpTbl group by buildingId
{
print(TenantBalanceDetailsTmpTbl.BuildingId);
//Just print the filed that you want see the output
print(TenantBalanceDetailsTmpTbl.TotalCredit);
print(TenantBalanceDetailsTmpTbl.TotalDebit);
print(TenantBalanceDetailsTmpTbl.BalanceCredit);
print(TenantBalanceDetailsTmpTbl.BalanceDebit);
}
pause;
}
Thank you!
ReplyDeleteYou are always welcome
ReplyDelete