public Exporter NewExport(IExport export)
{
if (_title == null)
{
_title = new List <List <Column> >();
_title.Add(new List <Column>());
EachHelper.EachListHeader(_data, (i, field, type) => _title[0].Add(new Column()
{
title = field, field = field, rowspan = 1, colspan = 1
}));
}
Dictionary <int, int> currentHeadRow = new Dictionary <int, int>();
Dictionary <string, List <int> > fieldIndex = new Dictionary <string, List <int> >();
Func <int, int> GetCurrentHeadRow = cell => currentHeadRow.ContainsKey(cell) ? currentHeadRow[cell] : 0;
// var currentRowindex = 2;
var currentRow = 2;
var currentCell = 0;
export.Init(_data);
//生成多行题头
for (var i = 0; i < _title.Count; i++)
{
currentCell = 0;
for (var j = 0; j < _title[i].Count; j++)
{
var item = _title[i][j];
if (item.hidden)
{
continue;
}
while (currentRow < GetCurrentHeadRow(currentCell) + 2)
{
currentCell++;
}
if (item.field != "ck")
{
export.FillData(currentCell, currentRow, "title_" + item.field, item.title);
if (item.rowspan + item.colspan > 2)
{
export.MergeCell(currentCell, currentRow, currentCell + item.colspan - 1, currentRow + item.rowspan - 1);
}
if (!string.IsNullOrEmpty(item.field))
{
if (!fieldIndex.ContainsKey(item.field))
{
fieldIndex[item.field] = new List <int>();
}
fieldIndex[item.field].Add(currentCell);
}
for (var k = 0; k < item.colspan; k++)
{
currentHeadRow[currentCell] = GetCurrentHeadRow(currentCell++) + item.rowspan;
}
}
}
currentRow++;
}
export.FillTitleData(0, 0, "", _toptile);
export.MergeCell(0, 0, currentCell - 1, 1);
//设置题头样式
export.SetHeadStyle(0, 0, currentCell - 1, currentRow - 1);
//设置数据样式
var dataCount = 0;
dataCount = _datatable.Rows.Count;
//EachHelper.EachListRow(_data, (i, r) => dataCount++);
export.SetRowsStyle(0, currentRow, currentCell - 1, currentRow + dataCount - 1);
//填充数据
// EachHelper.EachListRow(_data, (rowIndex, rowData) =>
// {
// EachHelper.EachObjectProperty(rowData, (i, name, value) =>
// {
// if (fieldIndex.ContainsKey(name))
// foreach (int cellIndex in fieldIndex[name])
// {
// if (_fieldFormatter.ContainsKey(name))
// value = _fieldFormatter[name].Format(value);
// export.FillData(cellIndex, currentRow, name, value);
// }
// });
// currentRow++;
// });
int cellIndex = 0;
int cellnum = currentCell;
int h = 0;
if (_datatable.Columns.Contains("ck"))
{
cellnum++;
h++;
}
if (_datatable.Columns.Contains("ID"))
{
cellnum++;
h++;
}
foreach (DataRow row in _datatable.Rows)
{
int k = 0;
for (int i = h; i < cellnum; i++)
{
export.FillData(k, currentRow, "", row[i]);
k++;
}
currentRow++;
}
export.SaveAsStream(Path);
//_suffix = export.suffix;
//if (string.IsNullOrEmpty(_fileName))
// _fileName = DateTime.Now.ToString("yyyyMMddHHmmss");
return(this);
}
public Exporter Export(IExport export)
{
if (_title == null)
{
_title = new List <List <Column> >();
_title.Add(new List <Column>());
EachHelper.EachListHeader(_data, (i, field, type) => _title[0].Add(new Column()
{
title = field, field = field, rowspan = 1, colspan = 1
}));
}
Dictionary <int, int> currentHeadRow = new Dictionary <int, int>();
Dictionary <string, List <int> > fieldIndex = new Dictionary <string, List <int> >();
Func <int, int> GetCurrentHeadRow = cell => currentHeadRow.ContainsKey(cell) ? currentHeadRow[cell] : 0;
var currentRow = 0;
var currentCell = 0;
export.Init(_data);
//生成多行题头
for (var i = 0; i < _title.Count; i++)
{
currentCell = 0;
for (var j = 0; j < _title[i].Count; j++)
{
var item = _title[i][j];
if (item.hidden)
{
continue;
}
while (currentRow < GetCurrentHeadRow(currentCell))
{
currentCell++;
}
export.FillData(currentCell, currentRow, "title_" + item.field, item.title);
if (item.rowspan + item.colspan > 2)
{
export.MergeCell(currentCell, currentRow, currentCell + item.colspan - 1, currentRow + item.rowspan - 1);
}
if (!string.IsNullOrEmpty(item.field))
{
if (!fieldIndex.ContainsKey(item.field))
{
fieldIndex[item.field] = new List <int>();
}
fieldIndex[item.field].Add(currentCell);
}
for (var k = 0; k < item.colspan; k++)
{
currentHeadRow[currentCell] = GetCurrentHeadRow(currentCell++) + item.rowspan;
}
}
currentRow++;
}
//设置题头样式
export.SetHeadStyle(0, 0, currentCell - 1, currentRow - 1);
//设置数据样式
var dataCount = 0;
EachHelper.EachListRow(_data, (i, r) => dataCount++);
export.SetRowsStyle(0, currentRow, currentCell - 1, currentRow + dataCount - 1);
//填充数据
EachHelper.EachListRow(_data, (rowIndex, rowData) =>
{
EachHelper.EachObjectProperty(rowData, (i, name, value) =>
{
if (fieldIndex.ContainsKey(name))
{
foreach (int cellIndex in fieldIndex[name])
{
if (_fieldFormatter.ContainsKey(name))
{
value = _fieldFormatter[name].Format(value);
}
export.FillData(cellIndex, currentRow, name, value);
}
}
});
currentRow++;
});
_fileStream = export.SaveAsStream();
_suffix = export.suffix;
if (string.IsNullOrEmpty(_fileName))
{
_fileName = DateTime.Now.ToString("yyyyMMddHHmmss");
}
return(this);
}
public Exporter Export(IExport export)
{
int i = 0;
if (_title == null)
{
_title = new List <List <StoreColumn> >();
_title.Add(new List <StoreColumn>());
//PFDataHelper.EachListHeader(_data, (i, field, type) => _title[0].Add(new StoreColumn() { title = field, field = field, rowspan = 1, colspan = 1 }));
PFDataHelper.EachListHeader(_data, (a, field, type) => _title[0].Add(new StoreColumn()
{
title = field,
data = field
//, rowspan = 1, colspan = 1
}));
}
Dictionary <int, int> currentHeadRow = new Dictionary <int, int>();
Dictionary <string, List <int> > fieldIndex = new Dictionary <string, List <int> >();
int titleRowCount = 0;
if (!string.IsNullOrWhiteSpace(_sheetTitle))
{
titleRowCount++;
}
Func <int, int> GetCurrentHeadRow = cell => currentHeadRow.ContainsKey(cell) ? currentHeadRow[cell] : titleRowCount;
var currentRow = 0;
var currentCell = 0;
export.Init(_data, _printPageScheme);
//标题--wxj20181011
var temp = new StoreColumn {
Children = _columns
};
int columnCount = temp.GetAllLeafCount(a => a.visible);
var firstData = temp.FirstLeaf(a => true).data;
if (!string.IsNullOrWhiteSpace(_sheetTitle))
{
export.FillData(0, 0, firstData, _sheetTitle);
export.SetTitleStyle(0, 0, columnCount - 1, 0);
currentRow++;
}
//Stopwatch sw = new Stopwatch();
//sw.Start();
//int resultCount = 0;
#region 3秒(后来发现只有调试时特别慢,原因未明)
////生成多行题头
for (i = 0; i < _title.Count; i++)
{
currentCell = 0;
for (var j = 0; j < _title[i].Count; j++)
{
var item = _title[i][j];
if (item.visible == false)
{
continue;
} //隐藏列不导出--wxj20181009
while (currentRow < GetCurrentHeadRow(currentCell))
{
currentCell++;
}
//export.FillData(currentCell, currentRow, "title_" + item.data, item.title);
export.FillData(currentCell, currentRow, "title_" + item.data, item.title ?? item.data);//e:\svn\businesssys2018\yjquery.web\areas\bonus\views\reportquery05\treegrid.cshtml里的title是null
if (item.rowspan + item.colspan > 2)
{
export.MergeCell(currentCell, currentRow, currentCell + item.colspan - 1, currentRow + item.rowspan - 1);
}
if (!string.IsNullOrEmpty(item.data))
{
if (!fieldIndex.ContainsKey(item.data))
{
fieldIndex[item.data] = new List <int>();
}
fieldIndex[item.data].Add(currentCell);
}
for (var k = 0; k < item.colspan; k++)
{
currentHeadRow[currentCell] = GetCurrentHeadRow(currentCell++) + item.rowspan;
}
//resultCount++;
}
currentRow++;
}
#endregion
#region 一样是3秒
////生成多行题头
//foreach (var ii in _title)
//{
// currentCell = 0;
// foreach (var j in ii)
// {
// //var item = _title[i][j];
// var item = j;
// if (item.visible == false) { continue; }//隐藏列不导出--wxj20181009
// //if (item.hidden) continue;
// while (currentRow < GetCurrentHeadRow(currentCell))
// currentCell++;
// //export.FillData(currentCell, currentRow, "title_" + item.data, item.title);
// export.FillData(currentCell, currentRow, "title_" + item.data, item.title ?? item.data);//e:\svn\businesssys2018\yjquery.web\areas\bonus\views\reportquery05\treegrid.cshtml里的title是null
// if (item.rowspan + item.colspan > 2)
// export.MergeCell(currentCell, currentRow, currentCell + item.colspan - 1, currentRow + item.rowspan - 1);
// if (!string.IsNullOrEmpty(item.data))
// {
// if (!fieldIndex.ContainsKey(item.data))
// fieldIndex[item.data] = new List<int>();
// fieldIndex[item.data].Add(currentCell);
// }
// for (var k = 0; k < item.colspan; k++)
// currentHeadRow[currentCell] = GetCurrentHeadRow(currentCell++) + item.rowspan;
// }
// currentRow++;
//}
#endregion
//sw.Stop();
//var aa = string.Format("插入{0}条记录共花费{1}毫秒，{2}分钟", resultCount, sw.ElapsedMilliseconds, sw.ElapsedMilliseconds / 1000 / 60);
//设置题头样式
//export.SetHeadStyle(0, 0, currentCell - 1, currentRow - 1);
export.SetHeadStyle(0, titleRowCount, currentHeadRow.Count - 1, currentRow - 1);//上面那样,当后面的列不是多表头时,背景色只填到最后一个多表头为止
////设置数据样式
var dataCount = 0;
if (_data is PagingResult)
{
var data = _data as PagingResult;
var list = data.data as ArrayList;
if (list != null)
{
for (var rowIndex = 0; rowIndex < list.Count; rowIndex++)
{
dataCount++;
}
}
else
{
var list1 = data.data as List <TreeListItem>;
if (list1 != null)
{
(new TreeListItem {
Children = list1
}).EachChild(a => dataCount++);
}
}
}
else
{
PFDataHelper.EachListRow(_data, (a, r) => dataCount++);//原版
}
////export.SetRowsStyle(0, currentRow, currentCell - 1, currentRow + dataCount - 1);
//此句内报错，要优化--benjamin todo
if (!PFDataHelper.IsDebug)
{
export.SetRowsStyle(0, currentRow, currentHeadRow.Count - 1, currentRow + dataCount - 1);//上面那样,当后面的列不是多表头时,边框不见了
}
//填充数据
if (_data is PagingResult)
{
var data = _data as PagingResult;
if (data.data is List <TreeListItem> )
{
export.SetFont(0, currentRow, 0, currentRow + dataCount - 1, "宋体");//默认的Arial字体中,树型的┝等符号对不齐--benjamin20190711
var tree = new TreeListItem();
tree.Children = data.data as List <TreeListItem>;
int rowIndex = 0;
//int colIndex = 0;
var matrix = new TreeMatrix(tree.Children);
tree.EachChild((a, deep) =>
{
//colIndex = 0;
PFDataHelper.EachObjectProperty(a.Data, (b, name, value) =>
{
if (fieldIndex.ContainsKey(name))
{
foreach (int cellIndex in fieldIndex[name])
{
if (_fieldFormatter.ContainsKey(name))
{
value = _fieldFormatter[name].Format(value);
}
//if (colIndex == 0)
if (cellIndex == 0)
{
var line = "";
for (var j = 0; j < deep - 2; j++)
{
//line += string.Format("<div class='{0} {1}'></div>", "tree-tr-linearea ", GetClassByTreeMatrixNetLine(matrix.GetNetLine(j, rowIdx)));
line += matrix.GetNetLineString(j, rowIndex);
}
value = line + PFDataHelper.ObjectToString(value);
//var line = GetClassByTreeMatrixNetLine(matrix.GetNetLine(cellIndex, currentRow))
}
export.FillData(cellIndex, currentRow, name, value);
}
//colIndex++;
}
});
rowIndex++;
currentRow++;
});
}
else
{
var list = data.data as ArrayList;
for (var rowIndex = 0; rowIndex < list.Count; rowIndex++)
{
var rowData = list[rowIndex] as Dictionary <string, object>;
for (i = 0; i < rowData.Count; i++)
{
var name = rowData.ElementAt(i).Key;
var value = rowData.ElementAt(i).Value;
if (fieldIndex.ContainsKey(name))
{
foreach (int cellIndex in fieldIndex[name])
{
if (_fieldFormatter.ContainsKey(name))
{
value = _fieldFormatter[name].Format(value);
}
export.FillData(cellIndex, currentRow, name, value);
}
}
}
currentRow++;
}
}
}
else
{
//原版
PFDataHelper.EachListRow(_data, (rowIndex, rowData) =>
{
PFDataHelper.EachObjectProperty(rowData, (a, name, value) =>
{
if (fieldIndex.ContainsKey(name))
{
foreach (int cellIndex in fieldIndex[name])
{
if (_fieldFormatter.ContainsKey(name))
{
value = _fieldFormatter[name].Format(value);
}
export.FillData(cellIndex, currentRow, name, value);
}
}
});
currentRow++;
});
}
//汇总行
bool hasSummary = false;
i = 0;
int firstSummary = 0;//第一个有汇总的格的位置
string firstSummaryField = "";
new StoreColumn {
Children = _columns
}.EachLeaf(a =>
{
//设置列宽--wxjtodo20190417
if (!PFDataHelper.StringIsNullOrWhiteSpace(a.width))
{
//export.SetColumnWidth(i, PFDataHelper.WebWidthToExcel(a.width).Value);
export.SetColumnWidth(i, a.width);
}
//if (a.excelWidth.HasValue)
//{
// export.SetColumnWidth(i, double.Parse(a.width.Replace("px", "")));
//}
//var column = _title[_title.Count - 1][i];
if (a.visible)
{
var column = a;
if (!hasSummary)
{
firstSummary = i; firstSummaryField = column.data;
}
if (column.summary != null)
{
hasSummary = true;
export.FillData(i, currentRow, column.data, column.summary);
}
i++;
}
});
if (hasSummary)
{
export.FillData(firstSummary - 1, currentRow, firstSummaryField, "合计：");
export.SetRowsStyle(0, currentRow, columnCount - 1, currentRow);//上面那样,当后面的列不是多表头时,边框不见了
currentRow++;
}
//Foot--wxj20181011
if (!string.IsNullOrWhiteSpace(_sheetFoot))
{
export.FillData(0, currentRow, firstData, _sheetFoot);
export.SetFootStyle(0, currentRow, columnCount - 1, currentRow);
//titleRowCount++;
currentRow++;
}
_exporter = export;
//_fileStream = export.SaveAsStream();
_suffix = export.suffix;
if (string.IsNullOrEmpty(_fileName))
{
_fileName = DateTime.Now.ToString("yyyyMMddHHmmss");
}
return(this);
}