📄 excel.cpp
字号:
if(Out.m_AdvancedFtpTestParam.m_bAutoRemoteFile)
sValue = "Yes";
else
sValue = "No";
SetCell(Row, COL, sValue, 0, false, false);
sValue = "IsAssignPreferentialFileSize:";
SetCell(Row, COL, sValue, 0, false, false);
if(Out.m_AdvancedFtpTestParam.m_bAssignPreferentialFileSize)
sValue = "Yes";
else
sValue = "No";
SetCell(Row, COL, sValue, 0, false, false);
sValue = "IsAssignPreferentialFileExtend:";
SetCell(Row, COL, sValue, 0, false, false);
if(Out.m_AdvancedFtpTestParam.m_bAssignPreferentialFileExtend)
sValue = "Yes";
else
sValue = "No";
SetCell(Row, COL, sValue, 0, false, false);
/**************------------DS_ADVANCED_FTP-row7--------******************/
sValue = "PreferentialFileSize(KB):";
SetCell(Row, COL, sValue, 0, false, true);
sValue = IntToStr(Out.m_AdvancedFtpTestParam.m_PreferentialFileSize);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "PreferentialFileExtend:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = Out.m_AdvancedFtpTestParam.m_PreferentialFileExtend;
SetCell(Row, COL, sValue, 0, false, false);
/**************------------DS_ADVANCED_FTP-row8--------******************/
UINT CallCount = Out.m_vAdvFtpResult.size();
for(UINT i=0; i<CallCount; i++)
{
sValue = "Test"+IntToStr(i+1)+"_Direction:";
SetCell(Row, COL, sValue, ColorTestCount, false, true);
sValue = IntToStr(Out.m_vAdvFtpResult[i].Direction);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Restore:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(Out.m_vAdvFtpResult[i].Restore);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "State:";
SetCell(Row, COL, sValue, 0, false, false);
String TestStae = "";
switch(Out.m_vAdvFtpResult[i].State)
{
case STATE_CONNECTED: TestStae = STATE1_CONNECTED;
case STATE_DISCONNECTED: TestStae = STATE2_DISCONNECTED;
case STATE_TRANSFERING: TestStae = STATE3_TRANSFERING;
default: ;
}
sValue = TestStae;
SetCell(Row, COL, sValue, 0, false, false);
sValue = "TotalSize(KB):";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(Out.m_vAdvFtpResult[i].TotalSize);
SetCell(Row, COL, sValue, 0, false, false);
/**************------------DS_ADVANCED_FTP-row9--------******************/
sValue = "StartPos:";
SetCell(Row, COL, sValue, 0, false, true);
sValue = IntToStr(Out.m_vAdvFtpResult[i].StartPos);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Transferred(KB)";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(Out.m_vAdvFtpResult[i].Transferred);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "ConnectTime(s):";
SetCell(Row, COL, sValue, 0, false, false);
sValue = FloatToStr(Out.m_vAdvFtpResult[i].ConnectTime/1000.0);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "TransferTime(s):";
SetCell(Row, COL, sValue, 0, false, false);
sValue = FloatToStr(Out.m_vAdvFtpResult[i].TransferTime/1000.0);
SetCell(Row, COL, sValue, 0, false, false);
/**************------------DS_ADVANCED_FTP-row10--------******************/
sValue = "WParam:";
SetCell(Row, COL, sValue, 0, false, true);
sValue = IntToStr(Out.m_vAdvFtpResult[i].WParam);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "LParam:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(Out.m_vAdvFtpResult[i].LParam);
SetCell(Row, COL, sValue, 0, false, false);
}
break;
}
default:
{
break;
}
}
}
}
}
//---------------------------------------------------------------------------
/**********************************************************************
* 函数名称：OutputPicture
* 功能描述：输出数据测试的速率图
* 输入参数：无
* 输出参数：无
* 返 回 值： 无
* 其它说明：// 其它说明
* 修改日期 版本号 修改人 修改内容
* -----------------------------------------------
* 2009-3-13 V1.0 wzl First Version
***********************************************************************/
void TExcelReport::OutputPicture(UINT type)
{
ExcelWorksheet1->ConnectTo(ExcelWorkbook1->Worksheets->get_Item(V("全部数据")));
SheetIndex = 3;
Row = 2;
Col = 2;
if(bData && type == 1)
{
for(UINT i=0; i<m_vPictureData.size(); i++)
{
Col = 2;
String Time = FloatToStr(m_vPictureData[i].time);
String Up = FloatToStr(m_vPictureData[i].up);
String Down = FloatToStr(m_vPictureData[i].down);
SetCell(Row, Col,Time , 0, false, false);
Col++;
SetCell(Row, Col,Up , 0, false, false);
Col++;
SetCell(Row, Col,Down , 0, false, false);
Row++;
}
}
else if(bFitful && type == 2)
{
for(UINT i=0; i<m_vFitfulPicData.size(); i++)
{
Col = 2;
String Time = FloatToStr(m_vFitfulPicData[i].time);
String Up = FloatToStr(m_vFitfulPicData[i].up);
String Down = FloatToStr(m_vFitfulPicData[i].down);
SetCell(Row, Col,Time , 0, false, false);
Col++;
SetCell(Row, Col,Up , 0, false, false);
Col++;
SetCell(Row, Col,Down , 0, false, false);
Row++;
}
}
}
/**********************************************************************
* 函数名称：OutputDataITResult
* 功能描述：输出数据交互测试结果
* 输入参数：无
* 输出参数：无
* 返 回 值： 无
* 其它说明：// 其它说明
* 修改日期 版本号 修改人 修改内容
* -----------------------------------------------
* 2009-3-13 V1.0 wzl First Version
***********************************************************************/
void TExcelReport::OutputDataITResult()
{
if(m_FtpITResult.m_CallTotal != 0 ||m_FtpITResult.m_SendSMSTotal != 0)
{
char TestTime[30] = "";
sValue = "InteractiveTest(ShortMsgs Enter When FTP Testing) Result";
SetCell(Row, COL, sValue, ColorTestMenu, true, true);
////////////////////row 1////////////
sValue = "Task Name:";
SetCell(Row, COL, sValue, ColorTestItem, false, true);
sValue = "Plan1";
SetCell(Row, COL, sValue, 0, false, false);
sValue = "URL:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = m_FtpITResult.m_sUrl;
SetCell(Row, COL, sValue, 0, false, false);
sValue = "FTP Option:";
SetCell(Row, COL, sValue, 0, false, false);
if(m_FtpITResult.m_bFtpContinous )
{
sValue = "Continuous";
}
else
{
sValue = "Once";
}
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Data Link:";
SetCell(Row, COL, sValue, 0, false, false);
if(m_FtpITResult.m_bFtpContinous )
{
sValue = "Download";
}
else
{
sValue = "Upload";
}
SetCell(Row, COL, sValue, 0, false, false);
////////////////////row 2////////////
sValue = "OnceTest Time(s):";
SetCell(Row, COL, sValue, 0, false, true);
if(m_FtpITResult.m_bFtpContinous )
{
sValue = "--";
}
else
{
sValue = IntToStr(m_FtpITResult.m_Interval).c_str();
}
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Test Time(s):";
SetCell(Row, COL, sValue, 0, false, false);
double Time3 = (m_FtpITResult.m_ConnectEndTestTime -m_FtpITResult.m_ConnectStartTestTime) * DAY2SECONDS ;
memset(TestTime, 0, 30);
TransferDBToChar(Time3, TestTime);
if( m_FtpITResult.m_ConnectStartTestTime != 0 && m_FtpITResult.m_ConnectStartTestTime!=0 && Time3 > 0)
{
sValue = String(TestTime);
}
else
{
sValue = "0";
}
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Drop Count:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(m_FtpITResult.m_PPPDropCount);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Average Rate(kb/s):";
SetCell(Row, COL, sValue, 0, false, false);
memset(TestTime, 0, 30);
TransferDBToChar(m_FtpITResult.m_FTPAverage, TestTime);
if(m_FtpITResult.m_FTPAverage == 0)
sValue = "0";
else
sValue = String(TestTime);
SetCell(Row, COL, sValue, 0, false, false);
////////////////////row 3////////////
if(m_FtpITResult.m_CallTotal != -1)
{
sValue = "Call Tatal:";
SetCell(Row, COL, sValue, 0, false, true);
sValue = IntToStr(m_FtpITResult.m_CallTotal);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Call Success:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(m_FtpITResult.m_CallSuccess);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Call Fail:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(m_FtpITResult.m_CallFail);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Answer Total:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(m_FtpITResult.m_AnswerTotal);
SetCell(Row, COL, sValue, 0, false, false);
}
////////////////////row 4////////////
if(m_FtpITResult.m_SendSMSTotal != -1)
{
sValue = "Send Tatal:";
SetCell(Row, COL, sValue, 0, false, true);
sValue = IntToStr(m_FtpITResult.m_SendSMSTotal);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Send Success:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(m_FtpITResult.m_SendSMSSuccess);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Send Fail:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(m_FtpITResult.m_SendSMSFail);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Receive Total:";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(m_FtpITResult.m_ReceiveSMSTotal);
SetCell(Row, COL, sValue, 0, false, false);
}
}
}
/**********************************************************************
* 函数名称：OutputFitfulResult
* 功能描述：输出数据测试中的断点续传测试结果
* 输入参数：double time, char *c_time
* 输出参数：无
* 返 回 值：
* 其它说明：// 其它说明
* 修改日期 版本号 修改人 修改内容
* -----------------------------------------------
* 2008-12-24 V1.0 wzl First Version
***********************************************************************/
void TExcelReport::OutputFitfulResult()
{
if(m_vFitfulResult.size() != 0)
{
sValue = "FitfulFTP_Test_Result";
SetCell(Row, COL, sValue, ColorTestMenu, true, true);
//--------------------------------------------------------
sValue = "DropCount:";
SetCell(Row, COL, sValue, ColorTestItem, false, true);
sValue = IntToStr(m_FitfulTestResult.m_EspecialSetPPPvsAdvFTP.m_PPPDropCount);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Disconnect Time(s):";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(m_FitfulTestResult.m_EspecialSetPPPvsAdvFTP.m_DisconnectedTime);
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Watting Time(s):";
SetCell(Row, COL, sValue, 0, false, false);
sValue = IntToStr(m_FitfulTestResult.m_EspecialSetPPPvsAdvFTP.m_WaittingTime);
SetCell(Row, COL, sValue, 0, false, false);
//--------------------------------------------------------
for(UINT i=0; i<m_vFitfulResult.size(); i++)
{
TDSTestPlanItems Out = m_vFitfulResult[i];
switch(Out.m_ServiceType)
{
case DS_ADVANCED_FTP:
{
/**************------------DS_ADVANCED_FTP-row1--------******************/
sValue = "AdvFtpSetParam:";
SetCell(Row, COL, sValue, 0, false, true);
sValue = Out.m_Name;
SetCell(Row, COL, sValue, 0, false, false);
sValue = "Continuous:";
SetCell(Row, CO⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -