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 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; } 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; } } } }