private void setSQLReportDs(clsRequest_sqlReport oSQLReport
, XmlNode xNodeParent)
{
var dsNodes = xNodeParent.SelectNodes("ds");
foreach (XmlNode xNode in dsNodes)
{
var sType = xNode.getXmlAttributeValue("type");
var sName = xNode.getXmlAttributeValue("name");
var sPath = xNode.getXmlAttributeValue("path");
DataTable t = null;
sqlReportTableBase oSQLReportTbl = null;
switch (sType)
{
case "sql":
var objTbl_sql = new sqlReportTableSQL();
objTbl_sql.setTier(this);
objTbl_sql.name = sName;
objTbl_sql.sql = xNode.InnerText;
oSQLReport.ds.Add(objTbl_sql);
break;
case "bll":
var objTbl_bll = new sqlReportTableBll();
objTbl_bll.setTier(this);
objTbl_bll.name = sName;
objTbl_bll.path = sPath;
oSQLReport.ds.Add(objTbl_bll);
break;
}
}
}
private void setSQLReport(string sKeyAttr, XmlDocument xDoc)
{
if (xDoc == null)
{
return;
}
XmlNodeList xNodeList = xDoc.SelectNodes("//appConfig/requestData[@type='sqlreport']/sqlreport");
foreach (XmlNode xNode in xNodeList)
{
string sKey = sKeyAttr + xNode.getXmlAttributeValue("name");
string sRdlPath = xNode.getXmlAttributeValue("rdlPath");
string downloadName = xNode.getXmlText("downloadName");
var osqlReport = new clsRequest_sqlReport();
osqlReport.setTier(this);
setValidationFrom_Node(xNode, osqlReport.oValidation);
setSQLReportDs(osqlReport, xNode);
osqlReport.rdlPath = sRdlPath;
osqlReport.downloadName = downloadName;
clnSQLReport.Add(sKey, osqlReport);
}
}
