Exemplo n.º 1
0
    public void ExportDataUnattended(string fileName)
    {
        string originalMinDuration = _dataViewerParametersDataViewer1.Columns["MinDuration"][4];
        string originalMaxDuration = _dataViewerParametersDataViewer1.Columns["MaxDuration"][4];
        string originalAvgDuration = _dataViewerParametersDataViewer1.Columns["AvgDuration"][4];
        string originalDevDuration = _dataViewerParametersDataViewer1.Columns["DevDuration"][4];
        string originalVarDuration = _dataViewerParametersDataViewer1.Columns["VarDuration"][4];
        string originalSumDuration = _dataViewerParametersDataViewer1.Columns["SumDuration"][4];
        string originalMinReads    = _dataViewerParametersDataViewer1.Columns["MinReads"][4];
        string originalMaxReads    = _dataViewerParametersDataViewer1.Columns["MaxReads"][4];
        string originalAvgReads    = _dataViewerParametersDataViewer1.Columns["AvgReads"][4];
        string originalDevReads    = _dataViewerParametersDataViewer1.Columns["DevReads"][4];
        string originalVarReads    = _dataViewerParametersDataViewer1.Columns["VarReads"][4];
        string originalSumReads    = _dataViewerParametersDataViewer1.Columns["SumReads"][4];
        string originalMinWrites   = _dataViewerParametersDataViewer1.Columns["MinWrites"][4];
        string originalMaxWrites   = _dataViewerParametersDataViewer1.Columns["MaxWrites"][4];
        string originalAvgWrites   = _dataViewerParametersDataViewer1.Columns["AvgWrites"][4];
        string originalDevWrites   = _dataViewerParametersDataViewer1.Columns["DevWrites"][4];
        string originalVarWrites   = _dataViewerParametersDataViewer1.Columns["VarWrites"][4];
        string originalSumWrites   = _dataViewerParametersDataViewer1.Columns["SumWrites"][4];
        string originalMinCPU      = _dataViewerParametersDataViewer1.Columns["MinCPU"][4];
        string originalMaxCPU      = _dataViewerParametersDataViewer1.Columns["MaxCPU"][4];
        string originalAvgCPU      = _dataViewerParametersDataViewer1.Columns["AvgCPU"][4];
        string originalDevCPU      = _dataViewerParametersDataViewer1.Columns["DevCPU"][4];
        string originalVarCPU      = _dataViewerParametersDataViewer1.Columns["VarCPU"][4];
        string originalSumCPU      = _dataViewerParametersDataViewer1.Columns["SumCPU"][4];
        string originalMinRows     = _dataViewerParametersDataViewer1.Columns["MinRows"][4];
        string originalMaxRows     = _dataViewerParametersDataViewer1.Columns["MaxRows"][4];
        string originalAvgRows     = _dataViewerParametersDataViewer1.Columns["AvgRows"][4];
        string originalDevRows     = _dataViewerParametersDataViewer1.Columns["DevRows"][4];
        string originalVarRows     = _dataViewerParametersDataViewer1.Columns["VarRows"][4];
        string originalSumRows     = _dataViewerParametersDataViewer1.Columns["SumRows"][4];

        _dataViewerParametersDataViewer1.Columns["MinDuration"][4] = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["MaxDuration"][4] = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["AvgDuration"][4] = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["DevDuration"][4] = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["VarDuration"][4] = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["SumDuration"][4] = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["MinReads"][4]    = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["MaxReads"][4]    = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["AvgReads"][4]    = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["DevReads"][4]    = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["VarReads"][4]    = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["SumReads"][4]    = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["MinWrites"][4]   = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["MaxWrites"][4]   = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["AvgWrites"][4]   = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["DevWrites"][4]   = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["VarWrites"][4]   = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["SumWrites"][4]   = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["MinCPU"][4]      = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["MaxCPU"][4]      = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["AvgCPU"][4]      = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["DevCPU"][4]      = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["VarCPU"][4]      = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["SumCPU"][4]      = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["MinRows"][4]     = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["MaxRows"][4]     = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["AvgRows"][4]     = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["DevRows"][4]     = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["VarRows"][4]     = "SearchableShow";
        _dataViewerParametersDataViewer1.Columns["SumRows"][4]     = "SearchableShow";

        ExportForm form = new ExportForm();

        form.DisableExportSql();
        form.DisableExportPtt();
        form.DisableExportSession();
        form.Initialize(_databaseOperation, dataViewer1, _dataViewerParametersDataViewer1);

        form.DoExportCsvAllPagesUnattended(fileName, _totalRows);

        _minStartTime = form.GetMinStartTime();
        _maxStartTime = form.GetMaxStartTime();

        _dataViewerParametersDataViewer1.Columns["MinDuration"][4] = originalMinDuration;
        _dataViewerParametersDataViewer1.Columns["MaxDuration"][4] = originalMaxDuration;
        _dataViewerParametersDataViewer1.Columns["AvgDuration"][4] = originalAvgDuration;
        _dataViewerParametersDataViewer1.Columns["DevDuration"][4] = originalDevDuration;
        _dataViewerParametersDataViewer1.Columns["VarDuration"][4] = originalVarDuration;
        _dataViewerParametersDataViewer1.Columns["SumDuration"][4] = originalSumDuration;
        _dataViewerParametersDataViewer1.Columns["MinReads"][4]    = originalMinReads;
        _dataViewerParametersDataViewer1.Columns["MaxReads"][4]    = originalMaxReads;
        _dataViewerParametersDataViewer1.Columns["AvgReads"][4]    = originalAvgReads;
        _dataViewerParametersDataViewer1.Columns["DevReads"][4]    = originalDevReads;
        _dataViewerParametersDataViewer1.Columns["VarReads"][4]    = originalVarReads;
        _dataViewerParametersDataViewer1.Columns["SumReads"][4]    = originalSumReads;
        _dataViewerParametersDataViewer1.Columns["MinWrites"][4]   = originalMinWrites;
        _dataViewerParametersDataViewer1.Columns["MaxWrites"][4]   = originalMaxWrites;
        _dataViewerParametersDataViewer1.Columns["AvgWrites"][4]   = originalAvgWrites;
        _dataViewerParametersDataViewer1.Columns["DevWrites"][4]   = originalDevWrites;
        _dataViewerParametersDataViewer1.Columns["VarWrites"][4]   = originalVarWrites;
        _dataViewerParametersDataViewer1.Columns["SumWrites"][4]   = originalSumWrites;
        _dataViewerParametersDataViewer1.Columns["MinCPU"][4]      = originalMinCPU;
        _dataViewerParametersDataViewer1.Columns["MaxCPU"][4]      = originalMaxCPU;
        _dataViewerParametersDataViewer1.Columns["AvgCPU"][4]      = originalAvgCPU;
        _dataViewerParametersDataViewer1.Columns["DevCPU"][4]      = originalDevCPU;
        _dataViewerParametersDataViewer1.Columns["VarCPU"][4]      = originalVarCPU;
        _dataViewerParametersDataViewer1.Columns["SumCPU"][4]      = originalSumCPU;
        _dataViewerParametersDataViewer1.Columns["MinRows"][4]     = originalMinRows;
        _dataViewerParametersDataViewer1.Columns["MaxRows"][4]     = originalMaxRows;
        _dataViewerParametersDataViewer1.Columns["AvgRows"][4]     = originalAvgRows;
        _dataViewerParametersDataViewer1.Columns["DevRows"][4]     = originalDevRows;
        _dataViewerParametersDataViewer1.Columns["VarRows"][4]     = originalVarRows;
        _dataViewerParametersDataViewer1.Columns["SumRows"][4]     = originalSumRows;
    }