MYASP-fusionChart报表源代码(包能运行)
5星 · 超过95%的资源 需积分: 0 3 浏览量
更新于2012-05-29
收藏 6.52MB RAR 举报
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)
{
}
}
}
jilongliang
- 粉丝: 40
- 资源: 94