C#生成XML文件的 函数

来源:互联网 发布:linux设置静态ip地址 编辑:程序博客网 时间:2024/06/06 01:41

protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                string saveFileName = "";
                string rankType = Convert.ToString(this.Request.QueryString["RankType"]);
                if ("JunTuan" == rankType)
                {
                    saveFileName = "JunTuan.xml";
                }
                else if ("GeRen" == rankType)
                {
                    saveFileName = "GeRen.xml";
                }
                else
                {
                    saveFileName = "Other.xml";
                    Response.Write("请输入正确的参数!");
                    Response.End();
                }
                XmlDocument xmlDoc = new XmlDocument(); // 创建dom对象

                string sXml = "<?xml version=/"1.0/" encoding=/"UTF-8/"?>";
                string sOutMsg = "这是调试信息,不要显示给用户";

                sXml += "<Root>";

               // DataTable dt = BLL.Mgr_Test.OutputXmlFile.GetAnyTable();
                int count = int.Parse(ConfigurationManager.AppSettings["TopNforweb"].ToString());
                DataTable dt = AllService.GetDataFromRankNameByTopNRank(count, "", "", "Army_ArmyPower", "sm_ArmyPower").Tables[0];//军团—个人

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    sXml += "<Node index=/"" + i.ToString() + "/" />";
                    sXml += "<Field1>" + dt.Rows[i]["site_id"].ToString() + "</Field1>";
                    sXml += "<Field2>" + dt.Rows[i]["group_id"].ToString() + "</Field2>";
                    sXml += "<Field3>" + dt.Rows[i]["rowtime"].ToString() + "</Field3>";
                    sXml += "<Field4>" + dt.Rows[i]["id"].ToString() + "</Field4>";
                    sXml += "<Field5>" + dt.Rows[i]["parentID"].ToString() + "</Field5>";
                    sXml += "<Field6>" + dt.Rows[i]["sm_ArmyLeaderLevel"].ToString() + "</Field6>";
                    sXml += "<Field7>" + dt.Rows[i]["sm_ArmyLevel"].ToString() + "</Field7>";
                    sXml += "<Field8>" + dt.Rows[i]["sm_ArmyName"].ToString() + "</Field8>";
                    sXml += "<Field9>" + dt.Rows[i]["sm_ArmyPeople"].ToString() + "</Field9>";
                    sXml += "<Field10>" + dt.Rows[i]["sm_ArmyPower"].ToString() + "</Field10>";
                    sXml += "<Field11>" + dt.Rows[i]["sm_CountryID"].ToString() + "</Field11>";
                    sXml += "<Field12>" + dt.Rows[i]["sm_UpState"].ToString() + "</Field12>";
                }

                sXml += "<debugInfo>" + sOutMsg + "</debugInfo>";
                sXml += "</Root>";
                //Response.ContentType = @"text/xml";     // 注意此句为了兼容FireFox
                //Response.ContentEncoding = System.Text.Encoding.UTF8;
                //Response.Write(sXml);

                xmlDoc.LoadXml(sXml);
                xmlDoc.Save(Server.MapPath("") + "//XmlFile//" + saveFileName); // 保存文件
                Response.Write("成功生成[" + saveFileName + "]!");
            }
            catch (Exception)
            {
                Response.Write("生成XML文件失败!");
            }

        }

原创粉丝点击