以树型目录化的数据库表数据通过递归转换成xml格式的xmldoc
/// <summary>
/// 将以树型目录化的数据通过递归转换成xml格式的数据绑定到Flex软件中的树型目录中
/// </summary>
public XmlDocument FillTreeViewOfXmlDocParam(string strReportType_Id, string strReportType_ParentId, string strReportType_Name, string strReportType_ClassType, string strChkReport, string strTableName, decimal iRoot, string strWhere)
{
XmlDocument xmldoc = new XmlDocument();
XmlNode xmlelem_chart = null;
XmlNode xmlnode_CurrP = null;
XmlNode xmlnode_Sun_Emp = null;
XmlNode xmlnode_Sun = null;
return GetXmlDocOfAddXmlParam(xmldoc, xmlelem_chart, xmlnode_CurrP, xmlnode_Sun_Emp, xmlnode_Sun, strReportType_Id, strReportType_ParentId, strReportType_Name, strReportType_ClassType, strChkReport, strTableName, iRoot, strWhere);
}
/// <summary>
/// 将以树型目录化的数据通过递归转换成xml格式的数据绑定到Flex软件中的树型目录中
/// </summary>
/// <param name="xmldoc">XmlDocument对象</param>
/// <param name="xmlelem_chart">XmlNode对象</param>
/// <param name="xmlnode_CurrP">XmlNode对象</param>
/// <param name="xmlnode_Sun_Emp">XmlNode对象</param>
/// <param name="xmlnode_Sun">XmlNode对象</param>
/// <param name="iRoot">根的父节点</param>
/// <returns></returns>
private XmlDocument GetXmlDocOfAddXmlParam(XmlDocument xmldoc, XmlNode xmlelem_chart, XmlNode xmlnode_CurrP, XmlNode xmlnode_Sun_Emp, XmlNode xmlnode_Sun, string strReportType_Id, string strReportType_ParentId, string strReportType_Name, string strReportType_ClassType, string strChkReport, string strTableName, decimal iRoot, string strWhere)
{
if (xmldoc.DocumentElement == null)
{
XmlDeclaration xmldec = xmldoc.CreateXmlDeclaration("1.0", "UTF-8", "yes");
xmldoc.InsertBefore(xmldec, xmldoc.DocumentElement);
string strSql = " SELECT distinct " + strReportType_Id;
strSql += " ," + strReportType_ParentId;
strSql += " ," + strReportType_Name;
strSql += " ," + strReportType_ClassType;
strSql += " ," + strChkReport;
strSql += " FROM " + strTableName;
strSql += " where 1=1 and " + strReportType_ParentId;
strSql += " =" + iRoot;
strSql += " " + strWhere;
DataSet ds = RtnDataSet(strSql);
if (ds.Tables[0].Rows.Count == 0)
{
return xmldoc;
}
DataView dview = ds.Tables[0].DefaultView;
foreach (DataRowView row in dview)
{
//将要传递的父级节点的值
dPartId = decimal.Parse(row[strReportType_Id].ToString());
strName = "x" + row[strReportType_Id].ToString();
//产生xml文件的根元素
xmlelem_chart = xmldoc.CreateElement("x" + row[strReportType_Id].ToString());
//XmlNode root = xmldoc.DocumentElement;
XmlNode NewAtt;
//属性id
NewAtt = xmldoc.CreateAttribute("Id");
NewAtt.Value = row[strReportType_Id].ToString();
xmlelem_chart.Attributes.SetNamedItem(NewAtt);
//属性Name
NewAtt = xmldoc.CreateAttribute("Name");
NewAtt.Value = row[strReportType_Name].ToString();
xmlelem_chart.Attributes.SetNamedItem(NewAtt);
//属性ParentId
NewAtt = xmldoc.CreateAttribute("ParentId");
NewAtt.Value = row[strReportType_ParentId].ToString();
xmlelem_chart.Attributes.SetNamedItem(NewAtt);
//属性ClassType
NewAtt = xmldoc.CreateAttribute("ClassType");
NewAtt.Value = row[strReportType_ClassType].ToString();
xmlelem_chart.Attributes.SetNamedItem(NewAtt);
//添加根元素
xmldoc.AppendChild(xmlelem_chart);
GetXmlDocOfAddXmlParam(xmldoc, xmlelem_chart, xmlnode_CurrP, xmlnode_Sun_Emp, xmlnode_Sun, strReportType_Id, strReportType_ParentId, strReportType_Name, strReportType_ClassType, strChkReport, strTableName, iRoot, strWhere);
}
}
else
{
string strSql = null;
//获取根节点，当为根节点
if (xmldoc.LastChild.Name == strName)
{
xmlnode_Sun_Emp = xmlelem_chart;
xmlnode_CurrP = xmlnode_Sun_Emp;
}
else
{
xmlnode_Sun_Emp = xmlnode_Sun;
xmlnode_CurrP = xmlnode_Sun_Emp;
}
strSql = "SELECT ";
strSql += strReportType_Id;
strSql += "," + strReportType_ParentId;
strSql += "," + strReportType_Name;
strSql += "," + strReportType_ClassType;
strSql += "," + strChkReport;
strSql += " FROM " + strTableName;
strSql += " where 1=1 and " + strReportType_ParentId;
strSql += " =" + "'" + dPartId + "'";
strSql += " " + strWhere;
DataSet ds = RtnDataSet(strSql);
if (ds.Tables[0].Rows.Count == 0)
{
xmlnode_CurrP = xmlnode_Sun_Emp.ParentNode;
booli = false;//判断是否还有下级节点
return xmldoc;
}
else
{
booli = true;
DataView dview = ds.Tables[0].DefaultView;
XmlNode NewAtt;
//xmlelem_Curr = xmlelem;
foreach (DataRowView row in dview)
{
//要传递的ReportType_ParentId，用以区别父节点
dPartId = decimal.Parse(row[strReportType_Id].ToString());
//要传递的Name，用以区别父节点
strName = "x" + row[strReportType_Id].ToString();
//创建节点，并设置节点值
xmlnode_Sun = xmldoc.CreateElement("x" + row[strReportType_Id].ToString());
//属性id
NewAtt = xmldoc.CreateAttribute("Id");
NewAtt.Value = row[strReportType_Id].ToString();
xmlnode_Sun.Attributes.SetNamedItem(NewAtt);
//属性Name
NewAtt = xmldoc.CreateAttribute("Name");
NewAtt.Value = row[strReportType_Name].ToString();
xmlnode_Sun.Attributes.SetNamedItem(NewAtt);
//属性ParentId
NewAtt = xmldoc.CreateAttribute("ParentId");
NewAtt.Value = row[strReportType_ParentId].ToString();
xmlnode_Sun.Attributes.SetNamedItem(NewAtt);
//属性ClassType
NewAtt = xmldoc.CreateAttribute("ClassType");
NewAtt.Value = row[strReportType_ClassType].ToString();
xmlnode_Sun.Attributes.SetNamedItem(NewAtt);
xmlnode_CurrP.AppendChild(xmlnode_Sun);
if (booli == true)
{
xmlnode_Sun_Emp = xmlnode_CurrP;
}
//如果子节点还有子节点，则递归
GetXmlDocOfAddXmlParam(xmldoc, xmlelem_chart, xmlnode_CurrP, xmlnode_Sun_Emp, xmlnode_Sun, strReportType_Id, strReportType_ParentId, strReportType_Name, strReportType_ClassType, strChkReport, strTableName, iRoot, strWhere);
}
}
}
return xmldoc;
}
