protected void AddControlColumn(XlsGroup band, XlsRow gridRow, BizControl control, SqlQueryDataSet dataSet)
{
if (control.Invisible)
{
return;
}
var header = new XlsTextNode(control.Caption);
band.AddGroup(header);
var info = _adjuster.Find(control);
var attr = dataSet.Reader.Query.FindAttribute(((BizDataControl)control).AttributeDefId ?? Guid.Empty);
if (attr != null)
{
var field = gridRow.AddDataField(new SqlQueryDataSetField(dataSet, attr, control));
if (info != null)
{
header.ColSpan = info.ColSpan;
field.ColSpan = info.ColSpan;
}
}
/*
* var field = gridRow.AddDataField(new SqlQueryDataSetField(dataSet, control));
* if (info != null)
* {
* header.ColSpan = info.ColSpan;
* field.ColSpan = info.ColSpan;
* // if (info.ColSpan == 1)
* // field.Width = info.Size;
* }
*/
}
protected void AddControlColumn(XlsGroup band, XlsRow gridRow, BizControl control)
{
if (control.Invisible)
{
return;
}
band.AddGroup(new XlsTextNode(control.Caption));
if (DataSet != null)
{
gridRow.AddDataField(new DocFormDataSetField(DataSet, control));
}
else if (SqlDataSet != null)
{
if (!(control is BizDataControl))
{
return;
}
var attr = SqlDataSet.Reader.Query.FindAttribute(((BizDataControl)control).AttributeDefId ?? Guid.Empty) ??
SqlDataSet.Reader.Query.FindAttribute(((BizDataControl)control).AttributeName);
if (attr != null)
{
gridRow.AddDataField(new SqlQueryDataSetField(SqlDataSet, attr, control));
}
}
}
protected void BuildHeaderColumns(XlsGroup band, XlsRow gridRow)
{
XlsTextNode header;
foreach (var col in Table.Columns.OfType <CrossDataKeyColumn>())
{
header = new XlsTextNode(col.Caption);
band.AddGroup(header);
var info = _adjuster.Find(col);
if (info != null)
{
header.ColSpan = info.ColSpan;
}
}
var group = Table.Columns.OfType <CrossDataGroupColumn>().FirstOrDefault();
if (group != null)
{
header = new XlsTextNode(group.Caption);
band.AddGroup(header);
if (group.Values != null && group.Values.Count > 0)
{
foreach (var val in group.Values)
{
var h = new XlsTextNode(val.Value != null ? val.Value.ToString() : "");
header.AddGroup(h);
AddGroupBandColumns(h, val);
}
}
else
{
AddGroupBandColumns(header, null);
}
}
}
private void AddRow(XlsRow dRow, CrossDataRow row)
{
foreach (var data in Table.GetRowColumnDatas(row))
{
if (data is int)
{
dRow.AddInt((int)data);
}
else if (data is double)
{
dRow.AddFloat((double)data);
}
else if (data is bool)
{
dRow.AddBool((bool)data);
}
else if (data is DateTime)
{
dRow.AddDateTime((DateTime)data);
}
else
{
dRow.AddText(data != null ? data.ToString() : "");
}
}
dRow.Style.AutoHeight = true;
}
public XlsRow AddRow()
{
var row = new XlsRow();
Items.Add(row);
return(row);
}
public XlsRow AddRow(string text, int colSpan = 0, int rowSpan = 0)
{
var row = new XlsRow();
Items.Add(row);
row.AddText(text, colSpan, rowSpan);
return(row);
}
protected void AddControlBand(XlsGroup band, XlsRow gridRow, BizControl control)
{
if (control.Invisible)
{
return;
}
if (control is BizPanel
/*control is BizTableColumn ||
* control is BizDocumentControl || control is BizDocumentListForm*/)
{
var node = new XlsTextNode(control.Caption);
band.AddGroup(node);
foreach (var child in control.Children)
{
AddControlBand(node, gridRow, child);
}
}
else if (control is BizTableColumn ||
control is BizDocumentControl || control is BizDocumentListForm)
{
if (control.Children != null)
{
foreach (var child in control.Children)
{
AddControlBand(band, gridRow, child);
}
}
}
else if (control is BizDataControl)
{
AddControlColumn(band, gridRow, control);
}
else
if (control.Children != null)
{
foreach (var child in control.Children)
{
AddControlBand(band.AddGroup(new XlsTextNode(child.Caption)), gridRow, child);
}
}
}
protected void AddControlColumn(XlsGroup band, XlsRow gridRow, BizControl control)
{
if (control.Invisible)
{
return;
}
var header = new XlsTextNode(control.Caption);
band.AddGroup(header);
var info = _adjuster.Find(control);
if (DataSet != null)
{
var field = gridRow.AddDataField(new DocFormDataSetField(DataSet, control));
if (info != null)
{
header.ColSpan = info.ColSpan;
field.ColSpan = info.ColSpan;
}
}
else if (SqlDataSet != null)
{
if (!(control is BizDataControl))
{
return;
}
var attr = SqlDataSet.Reader.Query.FindAttribute(((BizDataControl)control).AttributeDefId ?? Guid.Empty);
if (attr != null)
{
var field = gridRow.AddDataField(new SqlQueryDataSetField(SqlDataSet, attr, control));
if (info != null)
{
header.ColSpan = info.ColSpan;
field.ColSpan = info.ColSpan;
}
}
}
}
protected void AddColumn(XlsGroup band, XlsRow gridRow, ReportColumnDef column, Dictionary <Guid, SqlQuerySource> sourceMap)
{
var header = new XlsTextNode(column.Caption);
band.AddGroup(header);
var info = _adjuster.Find(column);
var attrColumn = column as ReportAttributeColumnDef;
if (attrColumn != null && SqlDataSet != null)
{
SqlQuerySource querySource;
var reportSource = Report.GetSourceDef(attrColumn.Attribute.SourceId);
var reportSourceAttr = reportSource.Attributes != null
? reportSource.Attributes.FirstOrDefault(a => a.Id == attrColumn.Attribute.AttributeId)
: null;
var hasQuerySource = sourceMap.TryGetValue(attrColumn.Attribute.SourceId, out querySource);
var attr = reportSourceAttr == null
? !hasQuerySource
? SqlDataSet.Reader.Query.FindAttribute(attrColumn.Attribute.AttributeId)
: SqlDataSet.Reader.Query.FindAttribute(querySource, attrColumn.Attribute.AttributeId)
: !hasQuerySource
? SqlDataSet.Reader.Query.FindAttribute(reportSourceAttr.Ident)
: SqlDataSet.Reader.Query.FindAttribute(querySource, reportSourceAttr.Ident);
if (attr != null)
{
var field = gridRow.AddDataField(new SqlQueryDataSetField(SqlDataSet, attr, attrColumn.ToSqlGrouping()));
if (info != null)
{
header.ColSpan = info.ColSpan;
field.ColSpan = info.ColSpan;
}
}
}
}