[
SRSReportParameterAttribute(classstr(CHINTWqwReportTestContract)),
SRSReportQueryAttribute(queryStr(CHINTCustConfirmTrans))
]
class CHINTWqwReportTestDP extends SrsReportDataProviderPreProcessTempDB
{
CHINTWqwReportTestDataTableTmp talbleTmp;
[SRSReportDataSetAttribute(tablestr(CHINTWqwReportTestDataTableTmp))]
public CHINTWqwReportTestDataTableTmp getTalbleTmp()
{
select talbleTmp;
return talbleTmp;
}
public void processReport()
{
CHINTWqwReportTestContract contract = this.parmDataContract() as CHINTWqwReportTestContract;
FromDate fromDate = contract.parmFromDate();
ToDate todate = contract.parmToDate();
Query query = this.parmQuery();
QueryBuildDataSource qbds = query.dataSourceTable(tableNum(CustConfirmTrans));
QueryBuildRange qbr = qbds.addRange(fieldNum(CustConfirmTrans, DlvDate));
qbr.value(SysQuery::range(fromDate, todate));
QueryBuildRange qbr1 = qbds.addRange(fieldNum(CustConfirmTrans, ConfirmId));
qbr1.value("CCF-000004");
QueryRun queryRun = new QueryRun(query);
while (queryRun.next())
{
CustConfirmTrans custConfirmTrans = queryRun.get(tableNum(CustConfirmTrans));
talbleTmp.clear();
talbleTmp.name = custConfirmTrans.Name;
talbleTmp.confirmId = custConfirmTrans.ConfirmId;
talbleTmp.insert();
}
}
}