/// <summary> /// 复制填充行(非分组更新单元格值) /// </summary> /// <param name="holder"></param> /// <param name="currentRowIndex"></param> /// <param name="table"></param> /// <param name="valueRowIndex"></param> /// <returns></returns> public bool FillLine(GroupDataHolder holder, int currentRowIndex, DataTable table, int valueRowIndex) { var startCellIndex = IsNeedNewLine(holder, currentRowIndex, table, valueRowIndex); if (startCellIndex < 0) { return(false); } RangeHelper.InsertCopyRange(TplRange.Worksheet, TplRange, StartColumnIndex, currentRowIndex, CellList.Count, 1, InsertRangeDirection.Down); InsertedRowList.Add(currentRowIndex); UpdateLine(holder, currentRowIndex, startCellIndex, table, valueRowIndex, MergeOption.Left, false); UpdateLine(holder, currentRowIndex, startCellIndex, table, valueRowIndex, MergeOption.Up, true); return(true); }
public void InsertColumn(TplBlock block, GroupDataHolder holder, DataTable dataTable, int valueIndex, bool hasData) { if (InsertCount > 0) { if (hasData) { var range = RangeHelper.GetRange(TplRange.Worksheet, (StartColIndex + InsertCount) - GroupColumnCount, block.StartParseRowIndex, GroupColumnCount, block.RowsCount); //Console.WriteLine(string.Format( // "orign1:[StartColIndex-{4},InsertCount-{0},groupColumnCount-{1},StartRowIndex-{2},RowCount{3},tplLastColumnIndex{5}]", // InsertCount, groupColumnCount, block.StartRowIndex, block.RowCount, StartCellIndex, tplLastColumnIndex)); RangeHelper.InsertCopyRange(TplRange.Worksheet, range, StartColIndex + InsertCount, block.StartParseRowIndex, GroupColumnCount, block.RowsCount, InsertRangeDirection.Right, TplLastColumnIndex); } var orign = RangeHelper.GetRange(TplRange.Worksheet, (StartColIndex + InsertCount) - GroupColumnCount, block.TplRange.Row, GroupColumnCount, block.TplRowCount); RangeHelper.InsertCopyRange(TplRange.Worksheet, orign, StartColIndex + InsertCount, orign.Row, GroupColumnCount, block.TplRowCount, InsertRangeDirection.Right, TplLastColumnIndex); RefreshLineTplRanges(block, GroupColumnCount); block.TplColumCount += GroupColumnCount; block.ColumnsCount += GroupColumnCount; } for (var i = 0; i < block.TplLineList.Count; i++) { var line = block.TplLineList[i]; for (var j = 0; j < GroupColumnCount; j++) { var num3 = (StartCellIndex + ((InsertCount > 0) ? (InsertCount - GroupColumnCount) : 0)) + j; var tplCell = line.CellList[num3]; if (InsertCount > 0) { tplCell = tplCell.Copy(); tplCell.LastColIndex += GroupColumnCount; line.CellList.Insert(num3 + GroupColumnCount, tplCell); } if (tplCell.Formula != null) { foreach (var groupKey in tplCell.Formula.KeyList) { for (var searchKey = groupKey.SearchKey; searchKey != null; searchKey = searchKey.NextKey) { if (IsGroupedColumn(searchKey.KeyName)) { searchKey.KeyValue = RangeHelper.GetTableValue(dataTable, valueIndex, searchKey.KeyName); searchKey.IsFixedValue = true; } } block.GroupKeyList.Add(groupKey.Copy()); if (groupKey.SearchKey != null) { groupKey.SearchKey.FillKey(dataTable, valueIndex); } block.Holder.AddValue(block.CountedMap, groupKey, dataTable, valueIndex); } } else if (tplCell.HgOption != InsertOption.Never) { tplCell.TplTextContent = Convert.ToString( RangeHelper.GetTableValue(dataTable, valueIndex, tplCell.TplValueColName)); } tplCell.GroupAlign = GroupAlign.None; Console.WriteLine(string.Concat("Inserted hg [", i.ToString().PadLeft(3), "][", num3.ToString().PadLeft(3), "] = ", tplCell.Formula)); if (i < block.RowsCount) { var currentCellRange = RangeHelper.GetCell(TplRange.Worksheet, (StartColIndex + InsertCount) + j, block.StartParseRowIndex + i); tplCell.WriteCell(Tpl, holder, currentCellRange, dataTable, valueIndex); } } } InsertCount += GroupColumnCount; }
public void InsertOneColumn(TplBlock block, int colIndex, GroupDataHolder holder, DataTable columnTalbe, int valueIndex, bool hasData) { if (hasData) { var range = RangeHelper.GetRange(TplRange.Worksheet, StartColIndex + colIndex, block.StartParseRowIndex, 1, block.RowsCount); RangeHelper.InsertCopyRange(TplRange.Worksheet, range, (StartColIndex + GroupColumnCount) + InsertCount, block.StartParseRowIndex, 1, block.RowsCount, InsertRangeDirection.Right, TplLastColumnIndex); } var orign = RangeHelper.GetRange(TplRange.Worksheet, StartColIndex + colIndex, block.TplRange.Row, 1, block.TplRowCount); RangeHelper.InsertCopyRange(TplRange.Worksheet, orign, (StartColIndex + GroupColumnCount) + InsertCount, orign.Row, 1, block.TplRowCount, InsertRangeDirection.Right, TplLastColumnIndex); RefreshLineTplRanges(block, 1); block.TplColumCount++; block.ColumnsCount++; for (var i = 0; i < block.TplLineList.Count; i++) { var line = block.TplLineList[i]; var num2 = StartCellIndex + colIndex; var tplCell = line.CellList[num2].Copy(); tplCell.LastColIndex++; line.CellList.Insert((StartCellIndex + GroupColumnCount) + InsertCount, tplCell); if (tplCell.Formula != null) { foreach (var groupKey in tplCell.Formula.KeyList) { if (groupKey.ReusedKey == null) { groupKey.ReusedKey = SearchKey.FindReusedKey(groupKey.ValueColName); } for (var key3 = groupKey.SearchKey; key3 != null; key3 = key3.NextKey) { if (IsGroupedColumn(key3.KeyName)) { key3.KeyValue = RangeHelper.GetTableValue(columnTalbe, valueIndex, key3.KeyName); key3.IsFixedValue = true; } } block.GroupKeyList.Add(groupKey.Copy()); if (groupKey.SearchKey != null) { groupKey.SearchKey.FillKey(columnTalbe, valueIndex); } block.Holder.AddValue(block.CountedMap, groupKey, columnTalbe, valueIndex); } } tplCell.GroupAlign = GroupAlign.None; Console.WriteLine(string.Concat("Inserted hg [", i.ToString().PadLeft(3), "][", num2.ToString().PadLeft(3), "] = ", tplCell.Formula)); if (i < block.RowsCount) { var currentCellRange = RangeHelper.GetCell(TplRange.Worksheet, (StartColIndex + GroupColumnCount) + InsertCount, block.StartParseRowIndex + i); tplCell.WriteCell(Tpl, holder, currentCellRange, columnTalbe, valueIndex); } } InsertCount++; }
public void FillTemplate() { foreach (var block in BlockList) { if (block.CopyOnly) { #region Copy 传入参数部分 var rangeCells = RangeHelper.GetRangeCells( RangeHelper.InsertCopyRange(Sheet, block.TplRange, block.StartParseColumnIndex, TemplateFlags.IndexTemplateEndRow + AlreadyWriteRows, block.TplColumCount, block.TplRowCount, InsertRangeDirection.Down)); while (rangeCells.MoveNext()) { var currentCell = (CellRange)rangeCells.Current; if (!currentCell.HasMerged) { var cellValue = currentCell.Value2 as string; if (((cellValue != null) && cellValue.StartsWith("#")) && ((cellValue.Length > 1) && (ParamMap != null))) { var strArray = cellValue.Substring(1) .Split(new[] { ':' }, StringSplitOptions.RemoveEmptyEntries); object paramValue; ParamMap.TryGetValue(strArray[0], out paramValue); var format = ""; if (strArray.Length > 1) { format = strArray[1].ToLower(); } RangeHelper.UpdateCellValue(this, currentCell, paramValue, format); } //模版单元格为合并单元格时进行合并 var templateCell = RangeHelper.GetRange(Sheet, currentCell.Column, ((currentCell.Row - TemplateFlags.IndexTemplateEndRow) - AlreadyWriteRows) + block.StartParseRowIndex, 1, 1); if (templateCell.HasMerged) { var startColumn = templateCell.MergeArea.Column; var startRow = ((templateCell.MergeArea.Row + TemplateFlags.IndexTemplateEndRow) + AlreadyWriteRows) - block.StartParseRowIndex; var mergeColumnCount = templateCell.MergeArea.ColumnCount; var mergeRowCount = templateCell.MergeArea.RowCount; var needMergeArea = RangeHelper.GetRange(Sheet, startColumn, startRow, mergeColumnCount, mergeRowCount); if (!needMergeArea.HasMerged) { needMergeArea.Merge(); } } } } AlreadyWriteRows += block.TplRowCount; #endregion Copy 传入参数部分 } else { block.StartParseRowIndex = TemplateFlags.IndexTemplateEndRow + AlreadyWriteRows; if (block.TplColumnTableIndex >= 0 && DataSource.Tables.Count > block.TplColumnTableIndex) { //动态填充模版列 block.CreateDynamicColumn(DataSource.Tables[block.TplColumnTableIndex]); } if (block.DataTableIndex < 0 || DataSource.Tables.Count <= block.DataTableIndex) { throw new ArgumentException(string.Format( "DataTable [{0}] of Block [{1}] not found in DataSet!", block.DataTableIndex, block.Name)); } if ((DataSource.Tables[block.DataTableIndex].Rows.Count <= 0)) { var emptyTable = new DataTable(); #region 数据源无数据时填充EmptyTable var stringType = Type.GetType("System.String"); if (stringType != null) { if (EmptyFieldsDict != null && EmptyFieldsDict.Count > 0) { foreach (var key in EmptyFieldsDict.Keys) { emptyTable.Columns.Add(new DataColumn(key, stringType)); } var row = emptyTable.NewRow(); foreach (DataColumn column in emptyTable.Columns) { var field = EmptyFieldsDict[column.ColumnName]; if (field.StartsWith("#") && ParamMap != null) { object paramValue; if (ParamMap.TryGetValue(field.Substring(1), out paramValue)) { row[column.ColumnName] = paramValue.ToString(); } else { row[column.ColumnName] = field; } } else { row[column.ColumnName] = field; } } emptyTable.Rows.Add(row); } else { emptyTable.Columns.Add(new DataColumn("column1", stringType)); emptyTable.Columns.Add(new DataColumn("column2", stringType)); emptyTable.Rows.Add("0", "0"); } } #endregion 数据源无数据时填充EmptyTable AlreadyWriteRows += block.FillBlock(emptyTable); } else { AlreadyWriteRows += block.FillBlock(DataSource.Tables[block.DataTableIndex]); } } } JoinTable(); }