日期:2014-05-17  浏览次数:21060 次

在Asp.Net上使用fusionchart报表 图解

?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using InfoSoftGlobal;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace MYASP
{
	/// <summary>
	/// Author:jilongliang
	/// </summary>
	public partial class index : System.Web.UI.Page
	{
		protected void Page_Load (object sender, EventArgs e)
		{
		}
		/// <summary>
		/// 直接在控件加载出来
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		protected void Literal1_Load (object sender, EventArgs e)
		{
            Literal1.Text = FusionCharts.RenderChart("swf/ScrollCombiDY2D.swf",
			 "fusioncharts.xml", "", "fusioncharts1", "500", "500", false, true);
		}
		/// <summary>
		/// 用户输入显示的图形fusioncharts
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		protected void btnSubmit_Click (object sender, EventArgs e)
		{
			//Request.Form() 
			//Label1.Text = Request["ponit1"];
			StringBuilder xmlData = new StringBuilder();
			xmlData.Append("<chart caption='报表' subCaption='报表' showPercentValues='1' pieSliceDepth='30' showBorder='1'>");
			xmlData.AppendFormat("<set label='Java' value='{0}' />", txtPoint1.Text); //txtPoint1.Text
			xmlData.AppendFormat("<set label='asp.net' value='{0}' />", txtPoint2.Text);
			xmlData.AppendFormat("<set label='C++' value='{0}' />", txtPoint3.Text);
			xmlData.AppendFormat("<set label='Android' value='{0}' />", txtPoint4.Text);
			xmlData.Append("</chart>");
			Literal1.Text = FusionCharts.RenderChart("swf/Pie3D.swf", "", xmlData.ToString(), "fusioncharts2", "800", "500", false, false);
		}

		/// <summary>
		/// 从数据库读数据
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		protected void Literal2_Load (object sender, EventArgs e)
		{
			string query = "select Team ,Points from tb_charts";

			StringBuilder xmlData = new StringBuilder();
			using(SqlDataReader dr = SQLDBHelper.ExecuteReader(CommandType.Text, query, null))
			{
				//<chart caption='某公司部门报表数据显示' xAxisName='Teams' yAxisName='Points'  showValues='0' formatNumberScale='0' showBorder='0'>

				xmlData.AppendFormat("<chart caption='某公司报表数据显示'>");
				while(dr.Read())
				{
					xmlData.AppendFormat("<set label='{0}' value='{1}'/>", dr ["Team"].ToString(), dr ["Points"].ToString());
				}
				xmlData.AppendFormat("</chart>");
				Literal2.Text = FusionCharts.RenderChart("swf/Column3D.swf", "", xmlData.ToString(), "testChart", "500", "500", false, true);
			}
		}
		/// <summary>
		/// 
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		protected void test2_Click (object sender, EventArgs e)
		{
            string str1=Request ["ponit1"];
            Label1.Text=str1;

			StringBuilder xmlData = new StringBuilder();
			xmlData.Append("<chart caption='报表' subCaption='报表' showPercentValues='1' pieSliceDepth='30' showBorder='1'>");
			xmlData.AppendFormat("<set label='Java' value='{0}' />", txtPoint1.Text); //txtPoint1.Text
			xmlData.AppendFormat("<set label='asp.net' value='{0}' />", txtPoint2.Text);
			xmlData.AppendFormat("<set label='C++' value='{0}' />", txtPoint3.Text);
			xmlData.AppendFormat("<set label='Android' value='{0}' />", txtPoint4.Text);
			xmlData.Append("</chart>");
			Literal1.Text = FusionCharts.RenderChart("swf/Pie3D.swf", "", xmlData.ToString(), "fusioncharts2", "800", "500", false, false);
		}

        protected void test2_Click1 (object sender, EventArgs e)
        {

        }
	}
}

?

fusionchart.xml配置

?

?

?

<