public bool getDataSourceColumnsInfo(string str, csDataSourceType csDataSourceType)
{
string sqlstmt;
if (m_dataSourceType == csDataSourceType.CDDTPROCEDURE)
{
if (!fillParameters(m_dataSource))
{
return(false);
}
fParameters f = new fParameters();
f.setParameters(m_parameters);
f.ShowDialog();
if (f.getOk())
{
sqlstmt = "[" + m_dataSource + "] " + f.getSqlParameters();
}
else
{
return(false);
}
}
else
{
sqlstmt = "select * from [" + m_dataSource + "]";
}
return(fillColumns(sqlstmt));
}
internal bool load(CSXml.cXml xDoc, XmlNode nodeObj)
{
XmlNode nodeObjAux = null;
XmlNode nodeObjAux2 = null;
m_dataSource = xDoc.getNodeProperty(nodeObj, "DataSource").getValueString(eTypes.eText);
m_dataSourceType = (csDataSourceType)xDoc.getNodeProperty(nodeObj, "DataSourceType").getValueInt(eTypes.eInteger);
m_strConnect = xDoc.getNodeProperty(nodeObj, "StrConnect").getValueString(eTypes.eText);
nodeObjAux2 = xDoc.getNodeFromNode(nodeObj, C_RPTCOLUMNS);
if (xDoc.nodeHasChild(nodeObjAux2))
{
nodeObjAux = xDoc.getNodeChild(nodeObjAux2);
while (nodeObjAux != null)
{
String key = xDoc.getNodeProperty(nodeObjAux, "Key").getValueString(eTypes.eText);
if (!m_columns.add(null, key).load(xDoc, nodeObjAux))
{
return(false);
}
nodeObjAux = xDoc.getNextNode(nodeObjAux);
}
}
nodeObjAux2 = xDoc.getNodeFromNode(nodeObj, C_RPTPARAMETERS);
if (xDoc.nodeHasChild(nodeObjAux2))
{
nodeObjAux = xDoc.getNodeChild(nodeObjAux2);
while (nodeObjAux != null)
{
String key = xDoc.getNodeProperty(nodeObjAux, "Key").getValueString(eTypes.eText);
if (!m_parameters.add(null, key).load(xDoc, nodeObjAux))
{
return(false);
}
nodeObjAux = xDoc.getNextNode(nodeObjAux);
}
}
return(true);
}
public void setDataSourceType(csDataSourceType dataSourceType)
{
m_dataSourceType = dataSourceType;
}
public bool getDataSourceColumnsInfo(string str, csDataSourceType csDataSourceType)
{
string sqlstmt;
if(m_dataSourceType == csDataSourceType.CDDTPROCEDURE)
{
if(! fillParameters(m_dataSource))
{
return false;
}
fParameters f = new fParameters();
f.setParameters(m_parameters);
f.ShowDialog();
if (f.getOk())
{
sqlstmt = "[" + m_dataSource + "] " + f.getSqlParameters();
}
else
{
return false;
}
}
else
{
sqlstmt = "select * from [" + m_dataSource + "]";
}
return fillColumns(sqlstmt);
}
public void setDataSourceType(csDataSourceType dataSourceType)
{
m_dataSourceType = dataSourceType;
}
public void setDataSourceType(csDataSourceType rhs)
{
m_dataSourceType = rhs;
}
public void setDataSourceType(csDataSourceType rhs)
{
m_dataSourceType = rhs;
}
internal bool load(CSXml.cXml xDoc, XmlNode nodeObj)
{
XmlNode nodeObjAux = null;
XmlNode nodeObjAux2 = null;
m_dataSource = xDoc.getNodeProperty(nodeObj, "DataSource").getValueString(eTypes.eText);
m_dataSourceType = (csDataSourceType)xDoc.getNodeProperty(nodeObj, "DataSourceType").getValueInt(eTypes.eInteger);
m_strConnect = xDoc.getNodeProperty(nodeObj, "StrConnect").getValueString(eTypes.eText);
nodeObjAux2 = xDoc.getNodeFromNode(nodeObj, C_RPTCOLUMNS);
if (xDoc.nodeHasChild(nodeObjAux2))
{
nodeObjAux = xDoc.getNodeChild(nodeObjAux2);
while (nodeObjAux != null)
{
String key = xDoc.getNodeProperty(nodeObjAux, "Key").getValueString(eTypes.eText);
if (!m_columns.add(null, key).load(xDoc, nodeObjAux))
{
return false;
}
nodeObjAux = xDoc.getNextNode(nodeObjAux);
}
}
nodeObjAux2 = xDoc.getNodeFromNode(nodeObj, C_RPTPARAMETERS);
if (xDoc.nodeHasChild(nodeObjAux2))
{
nodeObjAux = xDoc.getNodeChild(nodeObjAux2);
while (nodeObjAux != null)
{
String key = xDoc.getNodeProperty(nodeObjAux, "Key").getValueString(eTypes.eText);
if (!m_parameters.add(null, key).load(xDoc, nodeObjAux))
{
return false;
}
nodeObjAux = xDoc.getNextNode(nodeObjAux);
}
}
return true;
}
