IDictionary _Items; // list of report items
internal DataSets(Report rpt, DataSetsDefn dsn)
{
_rpt = rpt;
if (dsn.Items.Count < 10)
_Items = new ListDictionary(); // Hashtable is overkill for small lists
else
_Items = new Hashtable(dsn.Items.Count);
// Loop thru all the child nodes
foreach(DataSetDefn dsd in dsn.Items.Values)
{
DataSet ds = new DataSet(rpt, dsd);
_Items.Add(dsd.Name.Nm, ds);
}
}
string _ExprName; // name of the expression; this isn't always set
internal NameLookup(IDictionary f, IDictionary p, IDictionary r,
IDictionary gbl, IDictionary u, IDictionary ascope,
Grouping ag, Matrix mt, CodeModules cm, Classes i, DataSetsDefn ds, Type ct)
{
fields=f;
parameters=p;
reportitems=r;
globals=gbl;
user=u;
aggrScope = ascope;
g=ag;
m = mt;
cms = cm;
instances = i;
dsets = ds;
codeType = ct;
}
string _ExprName; // name of the expression; this isn't always set
internal NameLookup(IDictionary f, IDictionary p, IDictionary r,
IDictionary gbl, IDictionary u, IDictionary ascope,
Grouping ag, Matrix mt, CodeModules cm, Classes i, DataSetsDefn ds, Type ct)
{
fields = f;
parameters = p;
reportitems = r;
globals = gbl;
user = u;
aggrScope = ascope;
g = ag;
m = mt;
cms = cm;
instances = i;
dsets = ds;
codeType = ct;
}
IDictionary _Items; // list of report items
internal DataSets(Report rpt, DataSetsDefn dsn)
{
_rpt = rpt;
if (dsn.Items.Count < 10)
{
_Items = new ListDictionary(); // Hashtable is overkill for small lists
}
else
{
_Items = new Hashtable(dsn.Items.Count);
}
// Loop thru all the child nodes
foreach (DataSetDefn dsd in dsn.Items.Values)
{
DataSet ds = new DataSet(rpt, dsd);
_Items.Add(dsd.Name.Nm, ds);
}
}
Type _CodeType; // used for parsing of expressions; DONT USE AT RUNTIME
// Constructor
internal ReportDefn(XmlNode xNode, ReportLog replog, string folder, NeedPassword getpswd, int objcount) // report has no parents
{
rl = replog; // used for error reporting
_ObjectCount = objcount; // starting number for objects in this report; 0 other than for subreports
GetDataSourceReferencePassword = getpswd;
_ParseFolder = folder;
_Description = null;
_Author = null;
_AutoRefresh = -1;
_DataSourcesDefn = null;
_DataSetsDefn = null;
_Body = null;
_Width = null;
_PageHeader = null;
_PageFooter = null;
_PageHeight = null;
_PageWidth = null;
_LeftMargin = null;
_RightMargin = null;
_TopMargin = null;
_BottomMargin = null;
_EmbeddedImages = null;
_Language = null;
_CodeModules = null;
_Code = null;
_Classes = null;
_DataTransform = null;
_DataSchema = null;
_DataElementName = null;
_DataElementStyle = DataElementStyleEnum.AttributeNormal;
_LUReportItems = new Hashtable(); // to hold all the textBoxes
_LUAggrScope = new ListDictionary(); // to hold all dataset, dataregion, grouping names
_LUEmbeddedImages = new ListDictionary(); // probably not very many
_LUDynamicNames = new Hashtable();
_DataCache = new List<ICacheData>();
// Run thru the attributes
foreach(XmlAttribute xAttr in xNode.Attributes)
{
switch (xAttr.Name)
{
case "Name":
_Name = new Name(xAttr.Value);
break;
}
}
// Loop thru all the child nodes
foreach(XmlNode xNodeLoop in xNode.ChildNodes)
{
if (xNodeLoop.NodeType != XmlNodeType.Element)
continue;
switch (xNodeLoop.Name)
{
case "Description":
_Description = xNodeLoop.InnerText;
break;
case "Author":
_Author = xNodeLoop.InnerText;
break;
case "AutoRefresh":
_AutoRefresh = XmlUtil.Integer(xNodeLoop.InnerText);
break;
case "DataSources":
_DataSourcesDefn = new DataSourcesDefn(this, null, xNodeLoop);
break;
case "DataSets":
_DataSetsDefn = new DataSetsDefn(this, null, xNodeLoop);
break;
case "Body":
_Body = new Body(this, null, xNodeLoop);
break;
case "ReportParameters":
_ReportParameters = new ReportParameters(this, null, xNodeLoop);
break;
case "Width":
_Width = new RSize(this, xNodeLoop);
break;
case "PageHeader":
_PageHeader = new PageHeader(this, null, xNodeLoop);
break;
case "PageFooter":
_PageFooter = new PageFooter(this, null, xNodeLoop);
break;
case "PageHeight":
_PageHeight = new RSize(this, xNodeLoop);
break;
case "PageWidth":
_PageWidth = new RSize(this, xNodeLoop);
break;
case "LeftMargin":
_LeftMargin = new RSize(this, xNodeLoop);
break;
case "RightMargin":
_RightMargin = new RSize(this, xNodeLoop);
break;
case "TopMargin":
_TopMargin = new RSize(this, xNodeLoop);
break;
case "BottomMargin":
_BottomMargin = new RSize(this, xNodeLoop);
break;
case "EmbeddedImages":
_EmbeddedImages = new EmbeddedImages(this, null, xNodeLoop);
break;
case "Language":
_Language = new Expression(this, null, xNodeLoop, ExpressionType.String);
break;
case "Code":
_Code = new Code(this, null, xNodeLoop);
break;
case "CodeModules":
_CodeModules = new CodeModules(this, null, xNodeLoop);
break;
case "Classes":
_Classes = new Classes(this, null, xNodeLoop);
break;
case "DataTransform":
_DataTransform = xNodeLoop.InnerText;
break;
case "DataSchema":
_DataSchema = xNodeLoop.InnerText;
break;
case "DataElementName":
_DataElementName = xNodeLoop.InnerText;
break;
case "DataElementStyle":
_DataElementStyle = fyiReporting.RDL.DataElementStyle.GetStyle(xNodeLoop.InnerText, this.rl);
break;
default:
// don't know this element - log it
this.rl.LogError(4, "Unknown Report element '" + xNodeLoop.Name + "' ignored.");
break;
}
}
if (_Body == null)
rl.LogError(8, "Body not specified for report.");
if (_Width == null)
rl.LogError(4, "Width not specified for report. Assuming page width.");
if (rl.MaxSeverity <= 4) // don't do final pass if already have serious errors
{
FinalPass(folder); // call final parser pass for expression resolution
}
// Cleanup any dangling resources
if (_DataSourcesDefn != null)
_DataSourcesDefn.CleanUp(null);
}
Type _CodeType; // used for parsing of expressions; DONT USE AT RUNTIME
// Constructor
internal ReportDefn(XmlNode xNode, ReportLog replog, string folder, NeedPassword getpswd, int objcount) // report has no parents
{
rl = replog; // used for error reporting
_ObjectCount = objcount; // starting number for objects in this report; 0 other than for subreports
GetDataSourceReferencePassword = getpswd;
_ParseFolder = folder;
_Description = null;
_Author = null;
_AutoRefresh = -1;
_DataSourcesDefn = null;
_DataSetsDefn = null;
_Body = null;
_Width = null;
_PageHeader = null;
_PageFooter = null;
_PageHeight = null;
_PageWidth = null;
_LeftMargin = null;
_RightMargin = null;
_TopMargin = null;
_BottomMargin = null;
_EmbeddedImages = null;
_Language = null;
_CodeModules = null;
_Code = null;
_Classes = null;
_DataTransform = null;
_DataSchema = null;
_DataElementName = null;
_DataElementStyle = DataElementStyleEnum.AttributeNormal;
_LUReportItems = new Hashtable(); // to hold all the textBoxes
_LUAggrScope = new ListDictionary(); // to hold all dataset, dataregion, grouping names
_LUEmbeddedImages = new ListDictionary(); // probably not very many
_LUDynamicNames = new Hashtable();
_DataCache = new List <ICacheData>();
// Run thru the attributes
foreach (XmlAttribute xAttr in xNode.Attributes)
{
switch (xAttr.Name)
{
case "Name":
_Name = new Name(xAttr.Value);
break;
}
}
// Loop thru all the child nodes
foreach (XmlNode xNodeLoop in xNode.ChildNodes)
{
if (xNodeLoop.NodeType != XmlNodeType.Element)
{
continue;
}
switch (xNodeLoop.Name)
{
case "Description":
_Description = xNodeLoop.InnerText;
break;
case "Author":
_Author = xNodeLoop.InnerText;
break;
case "AutoRefresh":
_AutoRefresh = XmlUtil.Integer(xNodeLoop.InnerText);
break;
case "DataSources":
_DataSourcesDefn = new DataSourcesDefn(this, null, xNodeLoop);
break;
case "DataSets":
_DataSetsDefn = new DataSetsDefn(this, null, xNodeLoop);
break;
case "Body":
_Body = new Body(this, null, xNodeLoop);
break;
case "ReportParameters":
_ReportParameters = new ReportParameters(this, null, xNodeLoop);
break;
case "Width":
_Width = new RSize(this, xNodeLoop);
break;
case "PageHeader":
_PageHeader = new PageHeader(this, null, xNodeLoop);
break;
case "PageFooter":
_PageFooter = new PageFooter(this, null, xNodeLoop);
break;
case "PageHeight":
_PageHeight = new RSize(this, xNodeLoop);
break;
case "PageWidth":
_PageWidth = new RSize(this, xNodeLoop);
break;
case "LeftMargin":
_LeftMargin = new RSize(this, xNodeLoop);
break;
case "RightMargin":
_RightMargin = new RSize(this, xNodeLoop);
break;
case "TopMargin":
_TopMargin = new RSize(this, xNodeLoop);
break;
case "BottomMargin":
_BottomMargin = new RSize(this, xNodeLoop);
break;
case "EmbeddedImages":
_EmbeddedImages = new EmbeddedImages(this, null, xNodeLoop);
break;
case "Language":
_Language = new Expression(this, null, xNodeLoop, ExpressionType.String);
break;
case "Code":
_Code = new Code(this, null, xNodeLoop);
break;
case "CodeModules":
_CodeModules = new CodeModules(this, null, xNodeLoop);
break;
case "Classes":
_Classes = new Classes(this, null, xNodeLoop);
break;
case "DataTransform":
_DataTransform = xNodeLoop.InnerText;
break;
case "DataSchema":
_DataSchema = xNodeLoop.InnerText;
break;
case "DataElementName":
_DataElementName = xNodeLoop.InnerText;
break;
case "DataElementStyle":
_DataElementStyle = fyiReporting.RDL.DataElementStyle.GetStyle(xNodeLoop.InnerText, this.rl);
break;
default:
// don't know this element - log it
this.rl.LogError(4, "Unknown Report element '" + xNodeLoop.Name + "' ignored.");
break;
}
}
if (_Body == null)
{
rl.LogError(8, "Body not specified for report.");
}
if (_Width == null)
{
rl.LogError(4, "Width not specified for report. Assuming page width.");
}
if (rl.MaxSeverity <= 4) // don't do final pass if already have serious errors
{
FinalPass(folder); // call final parser pass for expression resolution
}
// Cleanup any dangling resources
if (_DataSourcesDefn != null)
{
_DataSourcesDefn.CleanUp(null);
}
}
// Constructor
internal ReportDefn(XmlNode xNode, ReportLog replog, string folder, NeedPassword getpswd, int objcount, CrossDelegate crossdel, string overwriteConnectionString, bool overwriteInSubreport, List <Param> sqlParams = null) // report has no parents
{
rl = replog; // used for error reporting
_ObjectCount = objcount; // starting number for objects in this report; 0 other than for subreports
GetDataSourceReferencePassword = getpswd;
_ParseFolder = folder;
_Description = null;
_Author = null;
_AutoRefresh = -1;
_DataSourcesDefn = null;
_DataSetsDefn = null;
_Body = null;
_Width = null;
_PageHeader = null;
_PageFooter = null;
_PageHeight = null;
_PageWidth = null;
_LeftMargin = null;
_RightMargin = null;
_TopMargin = null;
_BottomMargin = null;
_EmbeddedImages = null;
_Language = null;
_CodeModules = null;
_Code = null;
_Classes = null;
_DataTransform = null;
_DataSchema = null;
_DataElementName = null;
_DataElementStyle = DataElementStyleEnum.AttributeNormal;
_LUReportItems = new Hashtable(); // to hold all the textBoxes
_LUAggrScope = new ListDictionary(); // to hold all dataset, dataregion, grouping names
_LUEmbeddedImages = new ListDictionary(); // probably not very many
_LUDynamicNames = new Hashtable();
_DataCache = new List <ICacheData>();
// EBN 30/03/2014
SubReportGetContent = crossdel;
_OverwriteConnectionString = overwriteConnectionString;
_OverwriteInSubreport = overwriteInSubreport;
// Run thru the attributes
foreach (XmlAttribute xAttr in xNode.Attributes)
{
switch (xAttr.Name)
{
case "Name":
_Name = new Name(xAttr.Value);
break;
}
}
// Loop thru all the child nodes
foreach (XmlNode xNodeLoop in xNode.ChildNodes)
{
if (xNodeLoop.NodeType != XmlNodeType.Element)
{
continue;
}
switch (xNodeLoop.Name)
{
case "Description":
_Description = xNodeLoop.InnerText;
break;
case "Author":
_Author = xNodeLoop.InnerText;
break;
case "AutoRefresh":
_AutoRefresh = XmlUtil.Integer(xNodeLoop.InnerText);
break;
case "DataSources":
_DataSourcesDefn = new DataSourcesDefn(this, null, xNodeLoop);
break;
case "DataSets":
_DataSetsDefn = new DataSetsDefn(this, null, xNodeLoop);
ParseSQLParams(sqlParams);
break;
case "Body":
_Body = new Body(this, null, xNodeLoop);
break;
case "ReportParameters":
_ReportParameters = new ReportParameters(this, null, xNodeLoop);
break;
case "Width":
_Width = new RSize(this, xNodeLoop);
break;
case "PageHeader":
_PageHeader = new PageHeader(this, null, xNodeLoop);
break;
case "PageFooter":
_PageFooter = new PageFooter(this, null, xNodeLoop);
break;
case "PageHeight":
_PageHeight = new RSize(this, xNodeLoop);
break;
case "PageWidth":
_PageWidth = new RSize(this, xNodeLoop);
break;
case "LeftMargin":
_LeftMargin = new RSize(this, xNodeLoop);
break;
case "RightMargin":
_RightMargin = new RSize(this, xNodeLoop);
break;
case "TopMargin":
_TopMargin = new RSize(this, xNodeLoop);
break;
case "BottomMargin":
_BottomMargin = new RSize(this, xNodeLoop);
break;
case "EmbeddedImages":
_EmbeddedImages = new EmbeddedImages(this, null, xNodeLoop);
break;
case "Language":
_Language = new Expression(this, null, xNodeLoop, ExpressionType.String);
break;
case "Code":
_Code = new Code(this, null, xNodeLoop);
break;
case "CodeModules":
_CodeModules = new CodeModules(this, null, xNodeLoop);
break;
case "Classes":
_Classes = new Classes(this, null, xNodeLoop);
break;
case "DataTransform":
_DataTransform = xNodeLoop.InnerText;
break;
case "DataSchema":
_DataSchema = xNodeLoop.InnerText;
break;
case "DataElementName":
_DataElementName = xNodeLoop.InnerText;
break;
case "DataElementStyle":
_DataElementStyle = fyiReporting.RDL.DataElementStyle.GetStyle(xNodeLoop.InnerText, this.rl);
break;
default:
// don't know this element - log it
this.rl.LogError(4, "Unknown Report element '" + xNodeLoop.Name + "' ignored.");
break;
}
}
//if (sqlParams != null && sqlParams.Count > 0)
//{
// foreach (var item in sqlParams)
// {
// var a = ((System.Collections.Specialized.ListDictionary)_DataSetsDefn.Items).Values;
// foreach (fyiReporting.RDL.DataSetDefn ibj in a)
// {
// if (ibj.Query.DataSourceName == item.Dataset)
// {
// var query = ibj.Query.CommandText.Source.Replace($"@{item.Key}", $"'{item.Value}'");
// ibj.Query.CommandText.SetSource(query);
// //ibj.Query.CommandText.SetSource(ibj.Query.CommandText.Source.Replace($"@{item.Key}", $"'{item.Value}'"));
// if (ibj.Query.QueryParameters == null) continue;
// var queryItem = ibj.Query.QueryParameters.Items.FirstOrDefault(q => q.Name.ToString() == item.Key);
// ibj.Query.QueryParameters.Items.Remove(queryItem);
// }
// }
// }
//}
if (_Body == null)
{
rl.LogError(8, "Body not specified for report.");
}
if (_Width == null)
{
rl.LogError(4, "Width not specified for report. Assuming page width.");
}
if (rl.MaxSeverity <= 4) // don't do final pass if already have serious errors
{
FinalPass(folder); // call final parser pass for expression resolution
}
// Cleanup any dangling resources
if (_DataSourcesDefn != null)
{
_DataSourcesDefn.CleanUp(null);
}
}
