internal List <GroupEntry> Groups; // Runtime groups; array of GroupEntry
internal WorkClass(List l)
{
CalcHeight = l.Height == null? 0: l.Height.ToPoints();
Data = null;
Groups = null;
}
override internal void Run(IPresent ip, Row row)
{
Report r = ip.Report();
TableWorkClass wc = GetValue(r);
if (_IsGrid)
{
wc.Data = Rows.CreateOneRow(r);
}
else
{
wc.Data = GetFilteredData(r, row);
}
if (!AnyRows(ip, wc.Data)) // if no rows return
{
return; // nothing left to do
}
RunPrep(r, row, wc);
if (!ip.TableStart(this, row))
{
return; // render doesn't want to continue
}
if (_TableColumns != null)
{
_TableColumns.Run(ip, row);
}
// Header
if (_Header != null)
{
ip.TableHeaderStart(_Header, row);
Row frow = wc.Data.Data.Count > 0? wc.Data.Data[0]: null;
_Header.Run(ip, frow);
ip.TableHeaderEnd(_Header, row);
}
// Body
ip.TableBodyStart(this, row);
if (wc.RecursiveGroup != null)
{
RunRecursiveGroups(ip, wc);
}
else
{
RunGroups(ip, wc.Groups, wc);
}
ip.TableBodyEnd(this, row);
// Footer
if (_Footer != null)
{
ip.TableFooterStart(_Footer, row);
Row lrow = wc.Data.Data.Count > 0? wc.Data.Data[wc.Data.Data.Count - 1]: null;
_Footer.Run(ip, lrow);
ip.TableFooterEnd(_Footer, row);
}
ip.TableEnd(this, row);
RemoveValue(r);
}
override internal void RunPage(Pages pgs, Row row)
{
Report r = pgs.Report;
if (IsHidden(r, row))
{
return;
}
TableWorkClass wc = GetValue(r);
if (_IsGrid)
{
wc.Data = Rows.CreateOneRow(r);
}
else
{
wc.Data = GetFilteredData(r, row);
}
SetPagePositionBegin(pgs);
if (!AnyRowsPage(pgs, wc.Data)) // if no rows return
{
return; // nothing left to do
}
RunPrep(r, row, wc);
RunPageRegionBegin(pgs);
Page p = pgs.CurrentPage;
p.YOffset += this.RelativeY(r);
// Calculate the xpositions of the columns
TableColumns.CalculateXPositions(r, GetOffsetCalc(r) + LeftCalc(r), row);
RunPageHeader(pgs, wc.Data.Data[0], true, null);
if (wc.RecursiveGroup != null)
{
RunRecursiveGroupsPage(pgs, wc);
}
else
{
RunGroupsPage(pgs, wc, wc.Groups, wc.Data.Data.Count - 1, 0);
}
// Footer
if (_Footer != null)
{
Row lrow = wc.Data.Data.Count > 0? wc.Data.Data[wc.Data.Data.Count - 1]: null;
p = pgs.CurrentPage;
// make sure the footer fits on the page
if (p.YOffset + _Footer.HeightOfRows(pgs, lrow) > pgs.BottomOfPage)
{
p = RunPageNew(pgs, p);
RunPageHeader(pgs, row, false, null);
}
_Footer.RunPage(pgs, lrow);
}
RunPageRegionEnd(pgs);
SetPagePositionEnd(pgs, pgs.CurrentPage.YOffset);
RemoveValue(r);
}
internal void SetData(Report rpt, IEnumerable ie, Fields flds, Filters f)
{
if (ie == null) // Does user want to remove user data?
{
SetMyUserData(rpt, null);
return;
}
Rows rows = new Rows(rpt, null, null, null); // no sorting and grouping at base data
List <Row> ar = new List <Row>();
rows.Data = ar;
int rowCount = 0;
int maxRows = _RowLimit > 0? _RowLimit: int.MaxValue;
int fieldCount = flds.Items.Count;
foreach (object dt in ie)
{
// Get the type.
Type myType = dt.GetType();
// Build the row
Row or = new Row(rows, fieldCount);
// Go thru each field and try to obtain a value
foreach (Field fld in flds)
{
// Get the type and fields of FieldInfoClass.
FieldInfo fi = myType.GetField(fld.Name.Nm, BindingFlags.Instance | BindingFlags.Public);
if (fi != null)
{
or.Data[fld.ColumnNumber] = fi.GetValue(dt);
}
else
{
// Try getting it as a property as well
PropertyInfo pi = myType.GetProperty(fld.Name.Nm, BindingFlags.Instance | BindingFlags.Public);
if (pi != null)
{
or.Data[fld.ColumnNumber] = pi.GetValue(dt, null);
}
}
}
// Apply the filters
if (f == null || f.Apply(rpt, or))
{
or.RowNumber = rowCount; //
rowCount++;
ar.Add(or);
}
if (--maxRows <= 0) // don't retrieve more than max
{
break;
}
}
ar.TrimExcess(); // free up any extraneous space; can be sizeable for large # rows
if (f != null)
{
f.ApplyFinalFilters(rpt, rows, false);
}
SetMyUserData(rpt, rows);
}
internal void SetData(Report rpt, XmlDocument xmlDoc, Fields flds, Filters f)
{
if (xmlDoc == null) // Does user want to remove user data?
{
SetMyUserData(rpt, null);
return;
}
Rows rows = new Rows(rpt, null, null, null); // no sorting and grouping at base data
XmlNode xNode;
xNode = xmlDoc.LastChild;
if (xNode == null || !(xNode.Name == "Rows" || xNode.Name == "fyi:Rows"))
{
throw new Exception("XML Data must contain top level element Rows.");
}
List <Row> ar = new List <Row>();
rows.Data = ar;
int rowCount = 0;
int fieldCount = flds.Items.Count;
foreach (XmlNode xNodeRow in xNode.ChildNodes)
{
if (xNodeRow.NodeType != XmlNodeType.Element)
{
continue;
}
if (xNodeRow.Name != "Row")
{
continue;
}
Row or = new Row(rows, fieldCount);
foreach (XmlNode xNodeColumn in xNodeRow.ChildNodes)
{
Field fld = (Field)(flds.Items[xNodeColumn.Name]); // Find the column
if (fld == null)
{
continue; // Extraneous data is ignored
}
if (xNodeColumn.InnerText == null || xNodeColumn.InnerText.Length == 0)
{
or.Data[fld.ColumnNumber] = null;
}
else if (fld.Type == TypeCode.String)
{
or.Data[fld.ColumnNumber] = xNodeColumn.InnerText;
}
else
{
try
{
or.Data[fld.ColumnNumber] =
Convert.ChangeType(xNodeColumn.InnerText, fld.Type, NumberFormatInfo.InvariantInfo);
}
catch // all conversion errors result in a null value
{
or.Data[fld.ColumnNumber] = null;
}
}
}
// Apply the filters
if (f == null || f.Apply(rpt, or))
{
or.RowNumber = rowCount; //
rowCount++;
ar.Add(or);
}
}
ar.TrimExcess(); // free up any extraneous space; can be sizeable for large # rows
if (f != null)
{
f.ApplyFinalFilters(rpt, rows, false);
}
SetMyUserData(rpt, rows);
}
internal bool GetData(Report rpt, Fields flds, Filters f)
{
Rows uData = this.GetMyUserData(rpt);
if (uData != null)
{
this.SetMyData(rpt, uData);
return(uData.Data == null || uData.Data.Count == 0 ? false : true);
}
// Treat this as a SQL statement
DataSourceDefn ds = _DataSourceDefn;
if (ds == null || _CommandText == null)
{
this.SetMyData(rpt, null);
return(false);
}
IDbConnection cnSQL = ds.SqlConnect(rpt);
if (cnSQL == null)
{
this.SetMyData(rpt, null);
return(false);
}
Rows _Data = new Rows(rpt, null, null, null); // no sorting and grouping at base data
String sql = _CommandText.EvaluateString(rpt, null);
IDbCommand cmSQL = null;
IDataReader dr = null;
try
{
cmSQL = cnSQL.CreateCommand();
cmSQL.CommandText = AddParametersAsLiterals(rpt, cnSQL, sql, true);
if (this._QueryCommandType == QueryCommandTypeEnum.StoredProcedure)
{
cmSQL.CommandType = CommandType.StoredProcedure;
}
if (this._Timeout > 0)
{
cmSQL.CommandTimeout = this._Timeout;
}
AddParameters(rpt, cnSQL, cmSQL, true);
dr = cmSQL.ExecuteReader(CommandBehavior.SingleResult);
List <Row> ar = new List <Row>();
_Data.Data = ar;
int rowCount = 0;
int maxRows = _RowLimit > 0? _RowLimit: int.MaxValue;
int fieldCount = flds.Items.Count;
// Determine the query column number for each field
int[] qcn = new int[flds.Items.Count];
foreach (Field fld in flds)
{
qcn[fld.ColumnNumber] = -1;
if (fld.Value != null)
{
continue;
}
try
{
qcn[fld.ColumnNumber] = dr.GetOrdinal(fld.DataField);
}
catch
{
qcn[fld.ColumnNumber] = -1;
}
}
while (dr.Read())
{
Row or = new Row(_Data, fieldCount);
foreach (Field fld in flds)
{
if (qcn[fld.ColumnNumber] != -1)
{
or.Data[fld.ColumnNumber] = dr.GetValue(qcn[fld.ColumnNumber]);
}
}
// Apply the filters
if (f == null || f.Apply(rpt, or))
{
or.RowNumber = rowCount; //
rowCount++;
ar.Add(or);
}
if (--maxRows <= 0) // don't retrieve more than max
{
break;
}
}
ar.TrimExcess(); // free up any extraneous space; can be sizeable for large # rows
if (f != null)
{
f.ApplyFinalFilters(rpt, _Data, false);
}
//#if DEBUG
// rpt.rl.LogError(4, "Rows Read:" + ar.Count.ToString() + " SQL:" + sql );
//#endif
}
catch (Exception e)
{
rpt.rl.LogError(8, "SQL Exception" + e.Message + "\r\n" + e.StackTrace);
}
finally
{
if (cmSQL != null)
{
cmSQL.Dispose();
if (dr != null)
{
dr.Close();
}
}
}
this.SetMyData(rpt, _Data);
return(_Data == null || _Data.Data == null || _Data.Data.Count == 0 ? false : true);
}
// Obtain the data from the XML
internal bool GetData(Report rpt, string xmlData, Fields flds, Filters f)
{
Rows uData = this.GetMyUserData(rpt);
if (uData != null)
{
this.SetMyData(rpt, uData);
return(uData.Data == null || uData.Data.Count == 0? false: true);
}
int fieldCount = flds.Items.Count;
XmlDocument doc = new XmlDocument();
doc.PreserveWhitespace = false;
doc.LoadXml(xmlData);
XmlNode xNode;
xNode = doc.LastChild;
if (xNode == null || !(xNode.Name == "Rows" || xNode.Name == "fyi:Rows"))
{
throw new Exception("Error: XML Data must contain top level rows.");
}
Rows _Data = new Rows(rpt, null, null, null);
List <Row> ar = new List <Row>();
_Data.Data = ar;
int rowCount = 0;
foreach (XmlNode xNodeRow in xNode.ChildNodes)
{
if (xNodeRow.NodeType != XmlNodeType.Element)
{
continue;
}
if (xNodeRow.Name != "Row")
{
continue;
}
Row or = new Row(_Data, fieldCount);
foreach (XmlNode xNodeColumn in xNodeRow.ChildNodes)
{
Field fld = (Field)(flds.Items[xNodeColumn.Name]); // Find the column
if (fld == null)
{
continue; // Extraneous data is ignored
}
TypeCode tc = fld.qColumn != null? fld.qColumn.colType: fld.Type;
if (xNodeColumn.InnerText == null || xNodeColumn.InnerText.Length == 0)
{
or.Data[fld.ColumnNumber] = null;
}
else if (tc == TypeCode.String)
{
or.Data[fld.ColumnNumber] = xNodeColumn.InnerText;
}
else if (tc == TypeCode.DateTime)
{
try
{
or.Data[fld.ColumnNumber] =
Convert.ToDateTime(xNodeColumn.InnerText,
System.Globalization.DateTimeFormatInfo.InvariantInfo);
}
catch // all conversion errors result in a null value
{
or.Data[fld.ColumnNumber] = null;
}
}
else
{
try
{
or.Data[fld.ColumnNumber] =
Convert.ChangeType(xNodeColumn.InnerText, tc, NumberFormatInfo.InvariantInfo);
}
catch // all conversion errors result in a null value
{
or.Data[fld.ColumnNumber] = null;
}
}
}
// Apply the filters
if (f == null || f.Apply(rpt, or))
{
or.RowNumber = rowCount; //
rowCount++;
ar.Add(or);
}
}
ar.TrimExcess(); // free up any extraneous space; can be sizeable for large # rows
if (f != null)
{
f.ApplyFinalFilters(rpt, _Data, false);
}
SetMyData(rpt, _Data);
return(_Data == null || _Data.Data == null || _Data.Data.Count == 0 ? false : true);
}
int _ColSpan; // # of columns spanned
internal MatrixCellEntry(Rows d, ReportItem ri)
{
_Data = d;
_DisplayItem = ri;
_ColSpan = 1;
}
void DrawPlotAreaDoughnut(Report rpt, Graphics g)
{
// Draw Plot area data
int widthPie = Layout.PlotArea.Width;
int maxHeight = Layout.PlotArea.Height;
int maxPieSize = Math.Min(widthPie, maxHeight);
int doughWidth = maxPieSize / 4 / CategoryCount;
if (doughWidth < 2)
{
doughWidth = 2; // enforce minimum width
}
float startAngle;
float endAngle;
int pieLocX;
int pieLocY;
int pieSize;
// Go and draw the pies
int left = Layout.PlotArea.Left + (maxPieSize == widthPie? 0: (widthPie - maxPieSize) / 2);
int top = Layout.PlotArea.Top + (maxPieSize == maxHeight? 0: (maxHeight - maxPieSize) / 2);
for (int iRow = 1; iRow <= CategoryCount; iRow++)
{
pieLocX = left + ((iRow - 1) * doughWidth);
pieLocY = top + ((iRow - 1) * doughWidth);
double total = 0; // sum up for this category
for (int iCol = 1; iCol <= SeriesCount; iCol++)
{
total += this.GetDataValue(rpt, iRow, iCol);
}
// Pie size decreases as we go in
startAngle = 0.0f;
pieSize = maxPieSize - ((iRow - 1) * doughWidth * 2);
for (int iCol = 1; iCol <= SeriesCount; iCol++)
{
double v = this.GetDataValue(rpt, iRow, iCol);
endAngle = (float)(startAngle + v / total * 360);
DrawPie(g, rpt, GetSeriesBrush(rpt, iRow, iCol),
new System.Drawing.Rectangle(pieLocX, pieLocY, pieSize, pieSize), iRow, iCol, startAngle, endAngle);
startAngle = endAngle;
}
}
// Now draw the center hole with the plot area style
if (ChartDefn.PlotArea == null || ChartDefn.PlotArea.Style == null)
{
return;
}
pieLocX = left + (CategoryCount * doughWidth);
pieLocY = top + (CategoryCount * doughWidth);
pieSize = maxPieSize - (CategoryCount * doughWidth * 2);
System.Drawing.Rectangle rect = new System.Drawing.Rectangle(pieLocX, pieLocY, pieSize, pieSize);
Style s = ChartDefn.PlotArea.Style;
Rows cData = ChartDefn.ChartMatrix.GetMyData(rpt);
Row r = cData.Data[0];
s.DrawBackgroundCircle(rpt, g, r, rect);
}
internal Row(Rows r, int columnCount)
{
_R = r;
_Data = new object[columnCount];
_Level = 0;
}
object[] _Data; // Row of data
internal Row(Rows r, Row rd) // Constructor that uses existing Row data
{
_R = r;
_Data = rd.Data;
_Level = rd.Level;
}
override internal void RunPage(Pages pgs, Row row)
{
Report rpt = pgs.Report;
if (IsHidden(pgs.Report, row))
{
return;
}
_ChartMatrix.RunReset(rpt);
Rows _Data = GetFilteredData(rpt, row);
SetMyData(rpt, _Data);
SetPagePositionBegin(pgs);
if (!AnyRowsPage(pgs, _Data)) // if no rows return
{
return; // nothing left to do
}
// Build the Chart bitmap, along with data regions
Page p = pgs.CurrentPage;
ChartBase cb = null;
try
{
cb = RunChartBuild(rpt, row); // Build the chart
if (!_isHYNEsWonderfulVector.EvaluateBoolean(rpt, row)) //AJM GJL 14082008 'Classic' Rendering
{
System.Drawing.Image im = cb.Image(rpt); // Grab the image
int height = im.Height; // save height and width
int width = im.Width;
MemoryStream ostrm = new MemoryStream();
/* The following is a new image saving logic which will allow for higher
* quality images using JPEG with 100% quality
* 06122007AJM */
System.Drawing.Imaging.ImageCodecInfo[] info;
info = ImageCodecInfo.GetImageEncoders();
EncoderParameters encoderParameters;
encoderParameters = new EncoderParameters(1);
// 20022008 AJM GJL - Centralised class with global encoder settings
encoderParameters.Param[0] = new EncoderParameter(Encoder.Quality, ImageQualityManager.ChartImageQuality);
System.Drawing.Imaging.ImageCodecInfo codec = null;
for (int i = 0; i < info.Length; i++)
{
if (info[i].FormatDescription == "JPEG")
{
codec = info[i];
break;
}
}
im.Save(ostrm, codec, encoderParameters);
// 06122007AJM The follow has been replaced with the code above
//im.Save(ostrm, info); // generate a jpeg TODO: get png to work with pdf
byte[] ba = ostrm.ToArray();
ostrm.Close();
PageImage pi = new PageImage(IMAGEFORMAT, ba, width, height); // Create an image
RunPageRegionBegin(pgs);
SetPagePositionAndStyle(rpt, pi, row);
pi.SI.BackgroundImage = null; // chart already has the background image
if (pgs.CurrentPage.YOffset + pi.Y + pi.H >= pgs.BottomOfPage && !pgs.CurrentPage.IsEmpty())
{ // force page break if it doesn't fit on the page
pgs.NextOrNew();
pgs.CurrentPage.YOffset = OwnerReport.TopOfPage;
if (this.YParents != null)
{
pi.Y = 0;
}
}
p = pgs.CurrentPage;
p.AddObject(pi); // Put image onto the current page
RunPageRegionEnd(pgs);
if (!this.PageBreakAtEnd && !IsTableOrMatrixCell(rpt))
{
float newY = pi.Y + pi.H;
p.YOffset += newY; // bump the y location
}
SetPagePositionEnd(pgs, pi.Y + pi.H);
}
else //Ultimate Rendering - Vector //AJM GJL 14082008
{
System.Drawing.Imaging.Metafile im = cb.Image(rpt); // Grab the image
//im could still be saved to a bitmap at this point
//if we were to offer a choice of raster or vector, it would probably
//be easiest to draw the chart to the EMF and then save as bitmap if needed
int height = im.Height; // save height and width
int width = im.Width;
byte[] ba = cb._aStream.ToArray();
cb._aStream.Close();
PageImage pi = new PageImage(ImageFormat.Wmf, ba, width, height);
RunPageRegionBegin(pgs);
SetPagePositionAndStyle(rpt, pi, row);
pi.SI.BackgroundImage = null; // chart already has the background image
if (pgs.CurrentPage.YOffset + pi.Y + pi.H >= pgs.BottomOfPage && !pgs.CurrentPage.IsEmpty())
{ // force page break if it doesn't fit on the page
pgs.NextOrNew();
pgs.CurrentPage.YOffset = OwnerReport.TopOfPage;
if (this.YParents != null)
{
pi.Y = 0;
}
}
p = pgs.CurrentPage;
//GJL 25072008 - Charts now draw in EMFplus format and not in bitmap. Still using the "PageImage" for the positioning
//paging etc, but we don't add it to the page.
// ******************************************************************************************************************
// New EMF Processing... we want to add the EMF Components to the page and not the actual EMF...
EMF emf = new EMF(pi.X, pi.Y, width, height);
emf.ProcessEMF(ba); //Process takes the bytearray of EMFplus data and breaks it down into lines,ellipses,text,rectangles
//etc... There are still a lot of GDI+ functions I haven't got to (and some I have no intention of getting to!).
foreach (PageItem emfItem in emf.PageItems)
{
p.AddObject(emfItem);
}
// ******************************************************************************************************************
//p.AddObject(pi);
RunPageRegionEnd(pgs);
pi.Y += p.YOffset;
if (!this.PageBreakAtEnd && !IsTableOrMatrixCell(rpt))
{
float newY = pi.Y + pi.H;
p.YOffset += newY; // bump the y location
}
SetPagePositionEnd(pgs, pi.Y + pi.H); //our emf size seems to be bigger than the jpeg...
}
}
catch (Exception ex)
{
rpt.rl.LogError(8, string.Format("Exception in Chart handling.\n{0}\n{1}", ex.Message, ex.StackTrace));
}
finally
{
if (cb != null)
{
cb.Dispose();
}
}
return;
}
