Exemple #1
0
        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);
        }
Exemple #2
0
        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);
        }