sysperfana/heapanalyser/Libraries/Engine/HeapComparisonLib/CSV/Comparers/ComparerBase.cs
author Matti Laitinen <matti.t.laitinen@nokia.com>
Tue, 15 Jun 2010 12:47:20 +0300
changeset 8 15296fd0af4a
permissions -rw-r--r--
HeapAnalyser 1.1.0
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
8
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
     1
/*
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
     2
* Copyright (c) 2010 Nokia Corporation and/or its subsidiary(-ies).
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
     3
* All rights reserved.
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
     4
*
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
     5
* Redistribution and use in source and binary forms, with or without
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
     6
* modification, are permitted provided that the following conditions are met:
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
     7
*
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
     8
* - Redistributions of source code must retain the above copyright notice,
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
     9
*   this list of conditions and the following disclaimer.
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    10
* - Redistributions in binary form must reproduce the above copyright notice,
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    11
*   this list of conditions and the following disclaimer in the documentation
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    12
*   and/or other materials provided with the distribution.
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    13
* - Neither the name of Nokia Corporation nor the names of its contributors
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    14
*   may be used to endorse or promote products derived from this software
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    15
*   without specific prior written permission.
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    16
*
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    17
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    18
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    19
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    20
* ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    21
* LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    22
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    23
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    24
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    25
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    26
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    27
* POSSIBILITY OF SUCH DAMAGE.
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    28
* 
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    29
* Initial Contributors:
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    30
* Nokia Corporation - initial contribution.
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    31
*
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    32
* Contributors:
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    33
*
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    34
* Description: 
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    35
*
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    36
*/
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    37
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    38
using System;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    39
using System.Runtime.InteropServices;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    40
using Microsoft.Office.Interop.Excel;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    41
using SymbianExcelUtils;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    42
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    43
namespace HeapComparisonLib.CSV.Comparers
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    44
{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    45
    internal abstract class ComparerBase
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    46
	{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    47
		#region Constructors & destructor
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    48
		protected ComparerBase( Worksheet aSheet, string aFileName1, string aFileName2 )
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    49
		{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    50
			iWorksheet = aSheet;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    51
			iFileName1 = aFileName1;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    52
			iFileName2 = aFileName2;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    53
		}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    54
		#endregion
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    55
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    56
		#region API
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    57
		public abstract void PrepareWorksheetReadyForData();
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    58
		public abstract void FinaliseWorksheet();
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    59
        public abstract void Compare( CSVThread aOther, CSVThread aMaster );
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    60
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    61
		public virtual string DeltaFormula( int aIndex )
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    62
		{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    63
			return string.Empty;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    64
		}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    65
		#endregion
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    66
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    67
		#region Internal Properties
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    68
		protected int Row
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    69
		{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    70
			get { return iRowNumber; }
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    71
		}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    72
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    73
		protected Worksheet Sheet
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    74
		{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    75
			get { return iWorksheet; }
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    76
		}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    77
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    78
		protected string FileName1
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    79
		{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    80
			get { return iFileName1; }
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    81
		}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    82
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    83
		protected string FileName2
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    84
		{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    85
			get { return iFileName2; }
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    86
		}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    87
		#endregion
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    88
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    89
		#region Internal methods
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    90
		protected void NextRow()
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    91
		{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    92
			++iRowNumber;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    93
		}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    94
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    95
        protected void CompareAndWriteItems( CSVThread aItem1, long aItemVal1, CSVThread aItem2, long aItemVal2, int aColumn, int aGrowColour, int aShrinkColour )
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    96
		{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    97
			// First write the values to the columns
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    98
			if	( !aItem1.IsDefault )
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
    99
				Utils.SetValue( Row, aColumn   , Sheet, aItemVal1.ToString() );
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   100
			if	( !aItem2.IsDefault )
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   101
				Utils.SetValue( Row, aColumn + 1, Sheet, aItemVal2.ToString() );
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   102
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   103
			// Delta
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   104
			long delta = aItemVal1 - aItemVal2;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   105
			Utils.SetValue( Row, aColumn + 2, Sheet, ( delta * -1).ToString() );
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   106
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   107
			// Colour code accordingly
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   108
			int colour = 0x000000; // black
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   109
			if	( aItemVal1 < aItemVal2 )
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   110
			{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   111
				colour = aGrowColour; // 0x0000FF; // red
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   112
			}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   113
			else if ( aItemVal1 > aItemVal2 )
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   114
			{
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   115
				colour = aShrinkColour; // 0x00FF00; // green
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   116
			}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   117
			Utils.SetRangeFontColour( Row, aColumn + 2, Row, aColumn + 2, Sheet, colour );
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   118
		}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   119
		#endregion
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   120
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   121
		#region Data members
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   122
		private readonly string iFileName1;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   123
		private readonly string iFileName2;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   124
		private readonly Worksheet iWorksheet;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   125
		private int iRowNumber = 1;
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   126
		#endregion
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   127
	}
15296fd0af4a HeapAnalyser 1.1.0
Matti Laitinen <matti.t.laitinen@nokia.com>
parents:
diff changeset
   128
}