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(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
{
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;
}
}
private void AddControlRow(XlsDef def, /*XlsGroup band,*/ BizControl control)
{
if (control.Invisible || control is BizButton)
{
return;
}
if (control is BizPanel || control is BizDocumentControl)
{
var cell = def.AddArea().AddRow().AddText(control.Caption); //band.AddGroup(new XlsRow()).AddText(control.Caption);
cell.Style.FontStyle = FontStyle.Bold;
cell.ColSpan = _adjuster.ColumnCount;
cell.Style.FontColor = IndexedColors.DARK_BLUE.Index; // 18;
cell.Style.HAlign = HAlignment.Center;
cell.Style.AutoHeight = true;
cell.Style.BgColor = IndexedColors.GREY_25_PERCENT.Index;
foreach (var child in control.Children)
{
AddControlRow(def, /*band,*/ child);
}
}
else if (control is BizDocumentListForm)
{
var docListForm = (BizDocumentListForm)control;
var cell = def.AddArea().AddRow().AddText(control.Caption);
cell.Style.FontStyle = FontStyle.Bold;
cell.ColSpan = _adjuster.ColumnCount;
cell.Style.FontColor = IndexedColors.DARK_BLUE.Index; // 18;
cell.Style.HAlign = HAlignment.Center;
cell.Style.AutoHeight = true;
cell.Style.BgColor = IndexedColors.GREY_25_PERCENT.Index;
var tableForm = docListForm.Children != null && docListForm.Children.Count > 0
? docListForm
: (BizControl)docListForm.TableForm;
var docDefId = docListForm.TableForm != null
? docListForm.TableForm.DocumentDefId ?? Guid.Empty
: Guid.Empty;
SqlQueryDataSet dataSet;
var sqb = _sqlQueryBuilderFactory.Create();
if (docListForm.AttributeDefId != null)
{
/*using (
* var query = SqlQueryExBuilder.BuildAttrList(tableForm,
* docListForm.DocumentId ?? Guid.Empty, docDefId, (Guid) docListForm.AttributeDefId, null,
* null,
* UserId, DataContext))*/
/*using (*/
var query = sqb.BuildAttrList(tableForm, docListForm.DocumentId ?? Guid.Empty, docDefId,
(Guid)docListForm.AttributeDefId, null, null);//)
{
query.WithNoLock = true;
dataSet = CreateDataSet(query);
}
}
else if (docListForm.FormAttributeDefId != null)
{
/*using (
* var query = SqlQueryExBuilder.BuildRefList(tableForm,
* docListForm.DocumentId ?? Guid.Empty, docDefId, (Guid) docListForm.FormAttributeDefId, null,
* null,
* UserId, DataContext))*/
//using (
var query = sqb.BuildRefList(tableForm,
docListForm.DocumentId ?? Guid.Empty, docDefId, (Guid)docListForm.FormAttributeDefId, null,
null);//)
{
dataSet = CreateDataSet(query);
}
}
else
{
throw new ApplicationException(
"Недостаточно данных для формирования Excel-файла. Ошибка в данных формы!");
}
/*int count;
* var docs = docRepo.DocAttrListById(out count, docListForm.DocumentId ?? Guid.Empty,
* docListForm.AttributeDefId ?? Guid.Empty, 0, 0);
*
* dataSet = new DocFormDataSet(docs, tableForm, UserId, DataContext);*/
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(dataSet).AddRow();
dRow.ShowAllBorders(true);
if (tableForm.Children != null)
{
foreach (var child in tableForm.Children)
{
AddControlBand(hRow, dRow, child, dataSet);
}
}
}
else
{
var row = def.AddArea().AddRow();//band.AddGroup(new XlsRow());
var cell = row.AddText(control.Caption);
cell.ColSpan = _captionColSpan;
cell.Style.HAlign = HAlignment.Right;
cell.Style.WrapText = true;
if (control is BizDataControl && ((BizDataControl)control).ObjectValue != null)
{
var value = GetDataControlValue((BizDataControl)control);
var dataCell = row.AddText(value);
dataCell.ColSpan = _valueColSpan;
dataCell.Style.FontColor = IndexedColors.DARK_BLUE.Index;
dataCell.Style.WrapText = true;
}
else
{
var emptyCell = row.AddEmptyCell();
emptyCell.ColSpan = _valueColSpan;
}
}
}
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;
}
}
