void CReporter::BuildHtmlDoc( QDateTime& dtStart, QDateTime& dtEnd, CommonDataType::ReportType rType, QWebView& wvReport )
{
QStringList lstData;
QString strStart;
QString strEnd;
//QString strType = QString::number( rType );
CCommonFunction::DateTime2String( dtStart, strStart );
CCommonFunction::DateTime2String( dtEnd, strEnd );
QString strSql;// = QString( "call GenerateReport( '%1', '%2', %3 )" ).arg( strStart, strEnd, strType );
QDateTime dtTimeEnd = dtEnd;
GetSQL( strSql, rType, dtStart, dtEnd );
if ( strSql.isEmpty( ) ) {
return;
}
CLogicInterface::GetInterface( )->ExecuteSql( strSql, lstData );
//strSql= "Select @f1,@f2,@f3,@f4,@f5,@f6,@f7,@f8";
//CLogicInterface::GetInterface( )->ExecuteSql( strSql, lstData );
QDate dStart = dtStart.date( );
QDate dEnd = dtEnd.date( );
CCommonFunction::Date2String( dStart, strStart );
CCommonFunction::Date2String( dEnd, strEnd );
QString strTitle;
QString strFooter;
QString strTableBody;
GetHtml( rType, strTitle, strFooter, strTableBody, lstData );
QString strTitleDate;
GetTitle( rType, dtStart, dtTimeEnd, strTitleDate );
QString strHtml = QString( "<HTML>\
<BODY>\
<H3 ALIGN = \"CENTER\">报表日期：%1</H1>\
<br><br>\
<TABLE ALIGN = \"CENTER\" BORDER = \"1\" frame=\"box\" rules=\"all\"CELLPADDING = \"2\">\
%2\
%3\
</TABLE>\
</BODY>\
</HTML>" ).arg( strTitleDate, strTitle, strTableBody + strFooter );
wvReport.setHtml( strHtml );
}
bool CTest::Save(IOperation* pIOperation)
{
CDBData::SetOperatType(E_UPDATE);
CDatabaseOperation* pDBOperation=(CDatabaseOperation*)pIOperation;
if (pDBOperation!=nullptr)
{
list<string> lstSQL;
GetSQL(lstSQL);
for (list<string>::iterator iter=lstSQL.begin();iter!=lstSQL.end();iter++ )
{
pDBOperation->CompileStatement(*iter);
int nRow=0;
pDBOperation->ExcuteDML(nRow);
}
}
return true;
}
