//获取后继节点
private static void GetDescendantNodes(XmlDocument Xml, XmlNode ParentNode, string ParentContent, string Sort, string level)
{
OleDbDataAdapter adapter = new OleDbDataAdapter();
string sqlstr = @"select distinct * from
(select [GNS123].* from [GNS123] right join
(select * from [GNS123] where [GNS123].[名称]='" + ParentContent + "') T1 on [GNS123].[pid] = [T1].[pid]) T2 where ([T2].[属性分类] like '" + Sort + "' or [T2].[属性分类] like '%" + Sort + "' or [T2].[属性分类] like '%" + Sort + "%') and [T2].[关联类型]='" + level + "' order by [T2].[关联名称]";
DataSet reference_DS = new System.Data.DataSet();
adapter.SelectCommand = new OleDbCommand(sqlstr, my_cnt);
adapter.Fill(reference_DS, level);


if ((reference_DS.Tables[level] != null) && (reference_DS.Tables[level].Rows.Count > 0))
{
//在此添加本次递归层级得到的子级
for (int index = 0; index < reference_DS.Tables[level].Rows.Count; index++)
{
string current_title = reference_DS.Tables[level].Rows[index]["关联名称"].ToString();

XmlNode structurediv_node = Global.CreateElement(Xml, ParentNode, "structurediv", null);
Global.CreateElement(Xml, structurediv_node, "title", current_title);
UpdateFinishedNum("GNS123", (int)reference_DS.Tables[level].Rows[index]["ORDER"], 1);
//进行下一次递归
GetDescendantNodes(Xml, structurediv_node, current_title, Sort, level);
}
}

return;
}