public XlsDef Build() { var def = new XlsDef(); try { AdjustDocListForms(Report); _adjuster.Adjust(); def.Style.FontName = "Arial Narrow"; def.AddArea().AddEmptyRow(); var headArea = def.AddArea(); BuildSections(headArea, Headers); def.AddArea().AddEmptyRow(); var hRow = def.AddArea().AddRow(); hRow.ShowAllBorders(true); hRow.Style.FontStyle = FontStyle.Bold; hRow.Style.HAlign = HAlignment.Center; hRow.Style.BgColor = IndexedColors.BLUE_GREY.Index; //48; hRow.Style.FontColor = IndexedColors.WHITE.Index; hRow.Style.WrapText = true; var dRow = def.AddGrid(SqlDataSet).AddRow(); dRow.ShowAllBorders(true); dRow.Style.WrapText = true; var sourceMap = MapSources(); if (Report.Columns != null) { foreach (var column in Report.Columns) { AddColumn(hRow, dRow, column, sourceMap); } } def.AddArea().AddEmptyRow(); var footArea = def.AddArea(); BuildSections(footArea, Footers); def.ColumnWidths = _adjuster.ColumnSizes; return(def); } catch { def.Dispose(); throw; } }
public XlsDef Build() { var def = new XlsDef(); try { def.Style.FontName = "Arial Narrow"; var title = def.AddArea().AddRow().AddText(Form.Caption); title.Style.FontDSize = 2; title.Style.FontStyle = FontStyle.Bold; title.Style.FontColor = IndexedColors.DARK_BLUE.Index; // 18; title.Style.HAlign = HAlignment.Center; title.Style.AutoHeight = true; def.AddArea().AddEmptyRow(); var hRow = def.AddArea().AddRow(); hRow.ShowAllBorders(true); hRow.Style.FontStyle = FontStyle.Bold; hRow.Style.HAlign = HAlignment.Center; hRow.Style.BgColor = IndexedColors.BLUE_GREY.Index; //48; hRow.Style.FontColor = IndexedColors.WHITE.Index; hRow.Style.WrapText = true; var ds = ((DataSet)DataSet ?? SqlDataSet); var dRow = def.AddGrid(ds).AddRow(); dRow.ShowAllBorders(true); dRow.Style.AutoWidth = true; if (Form.Children != null) { foreach (var control in Form.Children) { AddControlBand(hRow, dRow, control); } } title.ColSpan = dRow.GetCols(); return(def); } catch { def.Dispose(); throw; } }
protected XlsDef Build() { var def = new XlsDef(); try { AdjustDocListForms(Form); _adjuster.Adjust(); _captionColSpan = _adjuster.GetColumnSpanForPercent(50); _valueColSpan = Math.Max(_adjuster.ColumnCount - _captionColSpan, 1); def.Style.FontName = "Arial Narrow"; def.DefaultRowHeight = 13; var cell = def.AddArea().AddRow().AddText(Form.Caption); cell.Style.FontDSize = 2; cell.Style.FontStyle = FontStyle.Bold; cell.Style.FontColor = IndexedColors.DARK_BLUE.Index; // 18; cell.Style.HAlign = HAlignment.Center; cell.Style.AutoHeight = true; cell.ColSpan = _adjuster.ColumnCount; def.AddArea().AddEmptyRow(); // var area = def.AddArea(); if (Form.Children != null) { foreach (var control in Form.Children) { AddControlRow(def, /*area,*/ control); } } def.ColumnWidths = _adjuster.ColumnSizes; return(def); } catch { def.Dispose(); throw; } }
public XlsDef Build() { var def = new XlsDef(); try { AdjustDocListForms(Form); _adjuster.Adjust(); def.Style.FontName = "Arial Narrow"; /*var title = def.AddArea().AddRow().AddText(Form.Caption); * title.Style.FontDSize = 2; * title.Style.FontStyle = FontStyle.Bold; * title.Style.FontColor = IndexedColors.DARK_BLUE.Index; // 18; * title.Style.HAlign = HAlignment.Center; * title.Style.AutoHeight = true;*/ def.AddArea().AddEmptyRow(); var headArea = def.AddArea(); BuildSections(headArea, Headers); def.AddArea().AddEmptyRow(); var hRow = def.AddArea().AddRow(); hRow.ShowAllBorders(true); hRow.Style.FontStyle = FontStyle.Bold; hRow.Style.HAlign = HAlignment.Center; hRow.Style.BgColor = IndexedColors.BLUE_GREY.Index; //48; hRow.Style.FontColor = IndexedColors.WHITE.Index; hRow.Style.WrapText = true; var ds = ((DataSet)DataSet ?? SqlDataSet); var dRow = def.AddGrid(ds).AddRow(); dRow.ShowAllBorders(true); dRow.Style.WrapText = true; if (Form.Children != null) { foreach (var control in Form.Children) { AddControlBand(hRow, dRow, control); } } def.AddArea().AddEmptyRow(); var footArea = def.AddArea(); BuildSections(footArea, Footers); def.ColumnWidths = _adjuster.ColumnSizes; //title.ColSpan = dRow.GetCols(); return(def); } catch { def.Dispose(); throw; } }
public XlsDef Build() { var def = new XlsDef(); try { AdjustReportColumns(Table); _adjuster.Adjust(); def.Style.FontName = "Arial Narrow"; def.AddArea().AddEmptyRow(); var headArea = def.AddArea(); BuildSections(headArea, Headers); def.AddArea().AddEmptyRow(); var hRow = def.AddArea().AddRow(); hRow.ShowAllBorders(true); hRow.Style.FontStyle = FontStyle.Bold; hRow.Style.HAlign = HAlignment.Center; hRow.Style.BgColor = IndexedColors.BLUE_GREY.Index; //48; hRow.Style.FontColor = IndexedColors.WHITE.Index; hRow.Style.WrapText = true; var dRow = def.AddArea().AddRow(); dRow.ShowAllBorders(true); dRow.Style.WrapText = true; if (Report.Columns != null) { BuildHeaderColumns(hRow, dRow); foreach (var row in Table.Rows) { dRow = def.AddArea().AddRow(); dRow.ShowAllBorders(true); dRow.Style.WrapText = true; AddRow(dRow, row); } // Add Summary Row dRow = def.AddArea().AddRow(); dRow.ShowAllBorders(true); dRow.Style.WrapText = true; dRow.Style.FontStyle = FontStyle.Bold; var summaries = Table.GetColumnSummaries(); foreach (var data in summaries) { if (data is int) { dRow.AddInt((int)data); } else if (data is double) { dRow.AddFloat((double)data); } else { dRow.AddEmptyCell(); } } dRow.Style.AutoHeight = true; } def.AddArea().AddEmptyRow(); var footArea = def.AddArea(); BuildSections(footArea, Footers); def.ColumnWidths = _adjuster.ColumnSizes; return(def); } catch { def.Dispose(); throw; } }