根据SQL语句生成同一类型的XML文件

 /// <summary>
       /// 根据SQL语句生成同一类型的XML文件
       /// </summary>
       /// <param name="sql">sql</param>
       /// <param name="fileName">文件名</param>
       /// <param name="fatherName">父节点</param>
       /// <param name="childName1">子节点1</param>
       /// <param name="childName2">子节点2</param>
        public void CreateXmlBySql(string sql, string fileName, string fatherName, string childName1, string childName2)
        {
            HttpServerUtility Server;
            DataTable dt = new DataTable();
            Server = HttpContext.Current.Server;
            XmlDocument xml = new XmlDocument();
            XmlElement xmlFather, xmlChild1, xmlChild2;
            xml.LoadXml(@"<xml name=""StockGrade"" version=""1.0"" encoding=""utf-8"" />");
            XmlElement r = xml.DocumentElement;//创建一个ＸＭＬ对象
            dt = Global.busLogicInner.GetPJBySql(sql);//根据sql语句获取数据
            if (dt != null)
            {
                foreach (var col in from v in dt.AsEnumerable() select v)
                {
                    xmlFather = xml.CreateElement(fatherName);
                    xmlChild1 = xml.CreateElement(childName1);
                    xmlChild1.InnerText = col[childName1].ToString();
                    xmlFather.AppendChild(xmlChild1);
                    xmlChild2 = xml.CreateElement(childName2);
                    xmlChild2.InnerText = col[childName2].ToString();
                    xmlFather.AppendChild(xmlChild2);
                    r.AppendChild(xmlFather);
                }
                xmlFather = xml.CreateElement(fatherName);
                xmlChild1 = xml.CreateElement(childName1);
                xmlChild1.InnerText = "END";
                xmlFather.AppendChild(xmlChild1);
                xmlChild2 = xml.CreateElement(childName2);
                xmlChild2.InnerText = "END";
                xmlFather.AppendChild(xmlChild2);
                r.AppendChild(xmlFather);
                string filePath = Server.MapPath(fileName);
                if (File.Exists(filePath))
                    File.Delete(filePath);
                xml.Save(filePath);
            }
        }