public override bool Equals(object obj)
{
if (this == obj)
{
return(true);
}
GroupValueSearchKey groupValueSearchKey = obj as GroupValueSearchKey;
if (groupValueSearchKey == null)
{
return(false);
}
if (!Equals(key, groupValueSearchKey.key))
{
return(false);
}
if (!Equals(valueColName, groupValueSearchKey.valueColName))
{
return(false);
}
if (!Equals(formula, groupValueSearchKey.formula))
{
return(false);
}
return(true);
}
public object GetValue(GroupValueSearchKey gkey, object defaultValue)
{
object value;
if (valueList.TryGetValue(gkey, out value))
{
return(value);
}
else
{
return(defaultValue);
}
}
public CellForumla Copy()
{
CellForumla f = new CellForumla();
f.formulaName = formulaName;
for (int i = 0; i < keyList.Count; i++)
{
GroupValueSearchKey gkey = keyList [i];
f.keyList.Add(gkey.Copy());
}
return(f);
}
public GroupValueSearchKey Copy()
{
GroupValueSearchKey gkey = new GroupValueSearchKey();
if (key != null)
{
gkey.key = key.Copy();
}
gkey.formula = formula;
gkey.valueColName = valueColName;
gkey.rKey = rKey;
return(gkey);
}
public override string ToString()
{
StringBuilder buf = new StringBuilder();
buf.Append("CellForumla [" + formulaName + "] keyCount = " + keyList.Count + "\n");
for (int i = 0; i < keyList.Count; i++)
{
GroupValueSearchKey key = keyList [i];
buf.Append("\t");
buf.Append(key.ToString());
buf.Append("\n");
}
return(buf.ToString());
}
public object GetValue(GroupDataHolder holder, System.Data.DataTable table, int rowIndex)
{
object lastValue = 0;
for (int i = 0; i < keyList.Count; i++)
{
GroupValueSearchKey gkey = keyList [i];
if (gkey.key != null)
{
gkey.key.FillKey(table, rowIndex);
}
object value = holder.GetValue(gkey, null);
/*
* Console.WriteLine ("row ["+ rowIndex + "] Get value for gkey: " + gkey );
* Console.WriteLine ("row [" + rowIndex + "] = [" + value + "]") ;
*/
lastValue = Calculate(formulaName, lastValue, value);
}
return(lastValue);
}
private static void ParseCell(TplBlock block, TplLine line, TplCell cell, string text)
{
text = text.Trim();
if (text.StartsWith("R1C1:"))
{
cell.useR1C1Formula = true;
cell.tplTextContent = text.Substring(5);
return;
}
if (text [0] != '{')
{
// as text
cell.tplTextContent = text;
return;
}
int i = text.IndexOf('}');
if (i > 0)
{
if (i + 1 != text.Length)
{
cell.tplTextContent = text.Substring(i + 1);
}
text = text.Substring(1, i - 1);
}
// using text as col name.
cell.tplValueColName = text;
Dictionary <string, string> pair = ParseKeyValuePair(text);
// parse format string
cell.tplFormat = GetPairValue(pair, "f");
if (!string.IsNullOrEmpty(cell.tplFormat))
{
cell.tplFormat = cell.tplFormat.ToLower();
}
// parse Merge option.
cell.mOption = ParseMergeOption(GetPairValue(pair, "m"));
// parse group options.
if (GetPairValue(pair, "vg") != null)
{
cell.align = GroupAlign.vGroup;
cell.tplGroupColName = GetPairValue(pair, "vg").Trim().ToUpper();
}
else if (GetPairValue(pair, "hg") != null)
{
cell.align = GroupAlign.hGroup;
cell.tplGroupColName = GetPairValue(pair, "hg").ToUpper();
line.containsHGroup = true;
InsertOption option = GetLineInsertOption(GetPairValue(pair, "hgo"));
if (option != InsertOption.afterChange && option != InsertOption.BeforeChange)
{
option = InsertOption.afterChange;
}
cell.hgOption = option;
}
// parse value string including formula.
string v = GetPairValue(pair, "v");
if (string.IsNullOrEmpty(v))
{
if (!string.IsNullOrEmpty(cell.tplGroupColName))
{
cell.tplValueColName = cell.tplGroupColName;
}
return;
}
//pase default value
cell.tplDefaultContent = GetPairValue(pair, "default");
i = v.IndexOf('(');
if (i < 0)
{
cell.tplValueColName = v.Trim().ToUpper();
return;
}
cell.formula = new CellForumla();
cell.formula.formulaName = i == 0 ? "" : v.Substring(0, i).ToLower();
int i2 = v.IndexOf(')');
if (i2 < 0)
{
Console.WriteLine("Warning:: formula not closed. [" + v + "]");
v = v.Substring(i + 1);
}
else
{
v = v.Substring(i + 1, i2 - i - 1);
}
v = v.Trim();
string[] colList = v.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
SearchKey pkey = null;
GroupValueSearchKey gkey = new GroupValueSearchKey();
gkey.formula = cell.formula.formulaName;
cell.formula.keyList.Add(gkey);
string colName = "";
for (int j = 0; j < colList.Length; j++)
{
string colPair = colList [j];
string[] cs = colPair.Split(new char[] { '=' }, StringSplitOptions.RemoveEmptyEntries);
if (j == 0)
{
colName = cs [0];
/* gkey.formula = "" ; */
gkey.valueColName = colName.Trim().ToUpper();
continue;
}
SearchKey key = new SearchKey();
key.colName = cs [0].ToUpper();
if (cs.Length > 1)
{
key.isFixedValue = true;
key.keyValue = cs [1];
}
if (key.colName == "%")
{
key = GetGroupedKeys(block, line);
if (key == null)
{
continue;
}
}
if (pkey == null)
{
gkey.key = key;
pkey = key;
}
else
{
pkey.nextKey = key;
pkey = key;
}
while (pkey.nextKey != null)
{
pkey = pkey.nextKey;
}
}
block.gkeyList.Add(gkey.Copy());
}
public void InsertColumn(TplBlock block, GroupDataHolder holder, DataTable table, int valueIndex, bool hasData)
{
// do insert
if (insertCount > 0)
{
if (hasData)
{
// block.startRowIndex ;
Range colRange = RangeHelper.GetRange(tplRange.Worksheet,
startColIndex + insertCount - gCols, block.startRowIndex,
gCols, block.rowCount);
// Insert new ;
RangeHelper.InsertCopyRange(tplRange.Worksheet, colRange,
gCols, block.rowCount,
startColIndex + insertCount, block.startRowIndex,
XlInsertShiftDirection.xlShiftToRight, tplLastColCount);
}
// Insert new Col in Template.
Range tplColRange = RangeHelper.GetRange(tplRange.Worksheet,
startColIndex + insertCount - gCols, block.tplRange.Row,
gCols, block.tplRowCount);
RangeHelper.InsertCopyRange(tplRange.Worksheet, tplColRange,
gCols, block.tplRowCount,
startColIndex + insertCount, tplColRange.Row,
XlInsertShiftDirection.xlShiftToRight, tplLastColCount);
// Refresh Line.TplRange ;
RefreshLineTplRanges(block, gCols);
block.tplColumCount += gCols;
block.colCount += gCols;
}
// Insert cell into exsit lineList.
for (int lineIndex = 0; lineIndex < block.lineList.Count; lineIndex++)
{
TplLine line = block.lineList [lineIndex];
for (int j = 0; j < gCols; j++)
{
int cellIndex = startCellIndex + (insertCount > 0 ? (insertCount - gCols) : 0) + j;
TplCell cell = line.cellList [cellIndex];
/* if (cell.lastColIndex != nextCloIndex - (insertCount > 0 ? 1 : 0)) */
// if (cell.lastColIndex < nextCloIndex || cell.lastColIndex >= nextCloIndex + gCols)
// continue ;
// if (lineIndex == 2)
// lineIndex = 2 ;
if (insertCount > 0)
{
cell = cell.Copy();
cell.lastColIndex += gCols;
line.cellList.Insert(cellIndex + gCols, cell);
}
if (cell.formula != null)
{
for (int keyIndex = 0; keyIndex < cell.formula.keyList.Count; keyIndex++)
{
GroupValueSearchKey gkey = cell.formula.keyList[keyIndex];
SearchKey key = gkey.key;
while (key != null)
{
if (IsGroupedColumn(key.colName))
{
key.keyValue = RangeHelper.GetColValue(table, valueIndex, key.colName);
key.isFixedValue = true;
}
key = key.nextKey;
}
block.gkeyList.Add(gkey.Copy());
if (gkey.key != null)
{
gkey.key.FillKey(table, valueIndex);
}
block.holder.AddValue(block.countedMap, gkey, table, valueIndex);
}
}
else
if (cell.hgOption != InsertOption.never)
{
cell.tplTextContent = Convert.ToString(cell.GetValueByIndex(valueIndex, table));
}
cell.align = GroupAlign.none;
Console.WriteLine("Inserted hg Line[" + lineIndex + "]cell[" + cellIndex + "] = " + cell.formula);
/* update Row Value */
if (lineIndex < block.rowCount)
{
Range cellRange = RangeHelper.GetCell(tplRange.Worksheet, startColIndex + (insertCount /* == 0 ? 0 : insertCount - 1*/) + j,
block.startRowIndex + lineIndex);
cell.WriteCell(tpl, holder, cellRange, table, valueIndex);
}
}
}
// Console.WriteLine ("---- End of " + valueIndex);
// increment next
nextCloIndex += gCols;
insertCount += gCols;
}
public void InsertOneColumn(TplBlock block, int colIndex, GroupDataHolder holder, DataTable table, int valueIndex, bool hasData)
{
if (hasData)
{
// block.startRowIndex ;
Range colRange = RangeHelper.GetRange(tplRange.Worksheet,
startColIndex + colIndex, block.startRowIndex,
1, block.rowCount);
// Insert new ;
RangeHelper.InsertCopyRange(tplRange.Worksheet, colRange,
1, block.rowCount,
startColIndex + gCols + insertCount, block.startRowIndex,
XlInsertShiftDirection.xlShiftToRight, tplLastColCount);
}
// Insert new Col in Template.
Range tplColRange = RangeHelper.GetRange(tplRange.Worksheet,
startColIndex + colIndex, block.tplRange.Row,
1, block.tplRowCount);
RangeHelper.InsertCopyRange(tplRange.Worksheet, tplColRange,
1, block.tplRowCount,
startColIndex + gCols + insertCount, tplColRange.Row,
XlInsertShiftDirection.xlShiftToRight, tplLastColCount);
// Refresh Line.TplRange ;
RefreshLineTplRanges(block, 1);
block.tplColumCount += 1;
block.colCount += 1;
// Insert cell into exsit lineList.
for (int lineIndex = 0; lineIndex < block.lineList.Count; lineIndex++)
{
TplLine line = block.lineList[lineIndex];
int cellIndex = startCellIndex + colIndex;
TplCell cell0 = line.cellList[cellIndex];
TplCell cell = cell0.Copy();
cell.lastColIndex += 1;
line.cellList.Insert(startCellIndex + gCols + insertCount, cell);
/*
* if (cell.useExcelFormula)
* {
* cell.tplRange = cell0.tplRange ;
* }
*/
if (cell.formula != null)
{
for (int keyIndex = 0; keyIndex < cell.formula.keyList.Count; keyIndex++)
{
GroupValueSearchKey gkey = cell.formula.keyList[keyIndex];
if (gkey.rKey == null)
{
SearchKey key0 = new SearchKey();
key0.colName = gkey.valueColName;
gkey.rKey = ReusedKey.FindReusedKey(key0);
}
SearchKey key = gkey.key;
while (key != null)
{
if (IsGroupedColumn(key.colName))
{
key.keyValue = RangeHelper.GetColValue(table, valueIndex, key.colName);
key.isFixedValue = true;
}
key = key.nextKey;
}
block.gkeyList.Add(gkey.Copy());
if (gkey.key != null)
{
gkey.key.FillKey(table, valueIndex);
}
block.holder.AddValue(block.countedMap, gkey, table, valueIndex);
}
}
/*
* else if (cell.hgOption != InsertOption.never)
* {
* // set fixed text
* cell.tplTextContent = Convert.ToString(RangeHelper.GetColValue (table, valueIndex, cell.tplValueColName)) ;
* }
*/
cell.align = GroupAlign.none;
Console.WriteLine("Inserted hg Line[" + lineIndex + "]cell[" + cellIndex + "] = " + cell.formula);
/* update Row Value */
if (lineIndex < block.rowCount)
{
Range cellRange = RangeHelper.GetCell(tplRange.Worksheet, startColIndex + gCols + insertCount,
block.startRowIndex + lineIndex);
cell.WriteCell(tpl, holder, cellRange, table, valueIndex);
}
}
// Console.WriteLine ("---- End of " + valueIndex);
// increment next
nextCloIndex += 1;
insertCount++;
}
public int FillBlock(DataTable table)
{
int rowIndex = startRowIndex;
for (int valueIndex = 0; valueIndex < table.Rows.Count; valueIndex++)
{
countedMap.Clear();
// fill key for each line, and count Data.
// Check is Need Row ;
if (dColumn != null && !dCloumnsCreated)
{
dColumn.CheckColumn(this, holder, rowIndex,
table, valueIndex);
}
// fill key for each line, and count Data.
for (int j = 0; j < gkeyList.Count; j++)
{
GroupValueSearchKey gkey = gkeyList [j];
if (gkey.rKey == null)
{
SearchKey key = new SearchKey();
key.colName = gkey.valueColName;
gkey.rKey = ReusedKey.FindReusedKey(key);
}
gkey = gkey.Copy();
if (gkey.key != null)
{
gkey.key.FillKey(table, valueIndex);
}
holder.AddValue(countedMap, gkey, table, valueIndex);
}
// fill Data
for (int j = 0; j < lineList.Count; j++)
{
TplLine line = lineList[j];
/*
* if (j == 4)
* j = 4 ;
*/
int nl = line.FillLine(holder, rowIndex, table, valueIndex);
if (nl > 0)
{
FillLastLine(j, lastUsedLine, rowIndex - 1, table, lastUsedLineValueIndex);
lastUsedLine = line;
lastUsedLineValueIndex = valueIndex;
// is LastLine, update current line
if (valueIndex + 1 >= table.Rows.Count)
{
FillLastLine(j, line, rowIndex, table, lastUsedLineValueIndex);
}
}
/*else
* {
* // Ensure Each Column is OK.
* if (dColumn != null && lastUsedLine != null && lastUsedLine == line)
* {
* if (! lastUsedLine.containsHGroup)
* lastUsedLine.UpdateRowData (holder, rowIndex - 1, table, valueIndex);
*
* if (updateAllRow)
* {
* for (int k = 0 ; k <= j ; k ++)
* {
* TplLine hLine = lineList [k] ;
* if (hLine.containsHGroup && hLine.insertedRowList.Count > 0)
* {
* hLine.UpdateRowData(holder,
* hLine.insertedRowList[hLine.insertedRowList.Count - 1],
* table, valueIndex);
* }
* }
* }
*
* }
* }*/
rowIndex += nl;
rowCount += nl;
}
}
MergeHGroupCells();
//if the table is custum empty ,ignor the MergeVGroupCells
if (table.ExtendedProperties.ContainsKey("TableType") &&
table.ExtendedProperties["TableType"].ToString() == "CustumEmpty")
{
return(rowCount);
}
MergeVGroupCells();
return(rowCount);
}
public void AddValue(Dictionary <GroupValueSearchKey, bool> map, GroupValueSearchKey gkey,
System.Data.DataTable table, int valueIndex)
{
if (map.ContainsKey(gkey))
{
// ignored.
return;
}
// judge Data is Match
if (gkey.key != null)
{
SearchKey tmpKey = gkey.key;
while (tmpKey != null)
{
if (tmpKey.rKey == null)
{
tmpKey.rKey = ReusedKey.FindReusedKey(tmpKey);
}
if (tmpKey.isFixedValue)
{
// Compare Fixed value Key only
object keyValue = null;
keyValue = tmpKey.rKey.GetReusedValue(table, valueIndex);
// RangeHelper.GetColValue (table, valueIndex, tmpKey.colName) ;
// Not match, return .
if (!Equals(keyValue, tmpKey.keyValue))
{
return;
}
}
tmpKey = tmpKey.nextKey;
}
/*SearchKey copyKey = gkey.key.Copy0 (false) ;
* copyKey.FillKey (table, valueIndex);
*
* // not match.
* if (! copyKey.Equals (gkey.key))
* return ;*/
}
object lastValue;
if (!valueList.TryGetValue(gkey, out lastValue))
{
lastValue = 0;
valueList.Add(gkey, lastValue);
}
if (gkey.rKey == null)
{
SearchKey key = new SearchKey();
key.colName = gkey.valueColName;
gkey.rKey = ReusedKey.FindReusedKey(key);
}
valueList [gkey] = CalculateForumla(gkey.formula, lastValue,
gkey.rKey.GetReusedValue(table, valueIndex));
map[gkey /*.Copy()*/] = true;
}