static void TestEOSCompensation(Args _args)
{
EmplContractTmp EmplContractTmp;
Query q; date sdate = str2Date('31/12/2012',123);
//date sdate = systemDateGet();
NSGEOSCompensationDP dataProvider = new NSGEOSCompensationDP();
NSGEOSCompensationContractClass contract = new NSGEOSCompensationContractClass();
contract.parmUptoDate(sdate);
q = dataProvider.parmQuery(); q.dataSourceTable(tableNum(EmplContract)).addRange(fieldNum(EmplContract, EmplId)).value("I0012"); //000545"); //"000042"); //"DNG998877");
dataProvider.parmDataContract(contract);
dataProvider.processReport();
EmplContractTmp = dataProvider.getEmplContractTmp();
while select EmplContractTmp
{ print(EmplContractTmp.EmplId);
print(EmplContractTmp.StartDate);
print(EmplContractTmp.Housing);
print(EmplContractTmp.Phone);
print(EmplContractTmp.Fuel);
print(EmplContractTmp.Other);
print(EmplContractTmp.CompensationValue);
print (EmplContractTmp.DeptDescription);
print (EmplContractTmp.JobPosition);
print(EmplContractTmp.DeptDescription);
print(EmplContractTmp.BasicSalary);
print(EmplContractTmp.Housing);
print(EmplContractTmp.Transportation);
print(EmplContractTmp.Other);
print(EmplContractTmp.TotalPackage);
print(EmplContractTmp.StartDate);
print(EmplContractTmp.UptoDate);
print(EmplContractTmp.EoSDaysOfService);
print(EmplContractTmp.CompensationValue);
} pause;
}
{
EmplContractTmp EmplContractTmp;
Query q; date sdate = str2Date('31/12/2012',123);
//date sdate = systemDateGet();
NSGEOSCompensationDP dataProvider = new NSGEOSCompensationDP();
NSGEOSCompensationContractClass contract = new NSGEOSCompensationContractClass();
contract.parmUptoDate(sdate);
q = dataProvider.parmQuery(); q.dataSourceTable(tableNum(EmplContract)).addRange(fieldNum(EmplContract, EmplId)).value("I0012"); //000545"); //"000042"); //"DNG998877");
dataProvider.parmDataContract(contract);
dataProvider.processReport();
EmplContractTmp = dataProvider.getEmplContractTmp();
while select EmplContractTmp
{ print(EmplContractTmp.EmplId);
print(EmplContractTmp.StartDate);
print(EmplContractTmp.Housing);
print(EmplContractTmp.Phone);
print(EmplContractTmp.Fuel);
print(EmplContractTmp.Other);
print(EmplContractTmp.CompensationValue);
print (EmplContractTmp.DeptDescription);
print (EmplContractTmp.JobPosition);
print(EmplContractTmp.DeptDescription);
print(EmplContractTmp.BasicSalary);
print(EmplContractTmp.Housing);
print(EmplContractTmp.Transportation);
print(EmplContractTmp.Other);
print(EmplContractTmp.TotalPackage);
print(EmplContractTmp.StartDate);
print(EmplContractTmp.UptoDate);
print(EmplContractTmp.EoSDaysOfService);
print(EmplContractTmp.CompensationValue);
} pause;
}
No comments:
Post a Comment