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; }