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文件失败!");
}
}