using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Text;
using?Spring.Context;
using?Spring.Context.Support;
using?Dxkj.Business.SysAdmin;

public?partial?class?highcharts?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????title?=?tit（“aaa“）;

????????subtitle?=?tit（“bbb“）;

????????XAxisCategories?=?xAxisAndDate（“XAxisCategories“?“10038823“）;

????????data?=?xAxisAndDate（“data“?“10038823“）;
????}

????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????title?=?tit（“ccc“）;

????????subtitle?=?tit（“ddd“）;

????????XAxisCategories?=?xAxisAndDate（“XAxisCategories“?“10038963“）;

????????data?=?xAxisAndDate（“data“?“10038963“）;
????}

????protected?string?tit（string?zhubiaoti）
????{
????????return?“{text:?‘“?+?““?+?zhubiaoti?+?““?+?“‘}“;
????}

????protected?string?xAxisAndDate（string?type?string?sysAqSeqid）
????{
????????IApplicationContext?ctx?=?ContextRegistry.GetContext（）;
????????SysHelper?sysHelper?=?new?SysHelper（（Spring.Data.Common.IDbProvider）ctx.Getobject（“dbProvider“））;

????????//string?sql?=?“select?l.aq_xm_classid?XAxisCategories?count（*）?data?from?linkphoto?l?where?l.sys_aq_seqid?=?‘“?+?sysAqSeqid?+?“‘?group?by?l.aq_xm_classid?order?by?l.aq_xm_classid“;
????????//測試使用的?sql?語句

????????DataTable?dt?=?sysHelper.gethighCharts（sysAqSeqid）;

????????StringBuilder?sb?=?new?StringBuilder（）;
????????sb.Append（“[“）;

????????foreach?（DataRowView?drv?in?dt.DefaultView）
????????{
????????????if?（type?==?“data“）
????????????{
????????????????sb.Append（drv[type].ToString（））;
????????????????sb.Append（““）;
????????????}
????????????else
????????????{
????????????????sb.Append（“‘“）;
????????????????sb.Append（drv[type].ToString（））;
????????????????sb.Append（“‘“）;
????????????}
????????}

????????return?sb.Replace（““?““?sb.Length?-?1?1）.Append（“]“）.ToString（）;?//這里是去掉最后一個多余的逗號（）
????}

????protected?string?title?=?““;?//?圖表標題

????protected?string?subtitle?=?““;?//?圖表副標題

????protected?string?XAxisCategories?=?““;?//?X軸的坐標值

????protected?string?data?=?““;?//?圖表數據

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????7123??2013-06-05?11:28??highchartsJsAndCss\exporting.js

?????文件???????1795??2013-06-05?11:28??highchartsJsAndCss\grid.js

?????文件?????134656??2013-06-05?11:27??highchartsJsAndCss\highcharts.js

?????文件??????93064??2013-06-15?10:39??highchartsJsAndCss\jquery-1.10.1.min.js

?????文件?????242727??2013-06-15?10:30??highchartsJsAndCss\jquery-2.0.1.js

?????文件???????3147??2013-06-15?18:57??highcharts.aspx

?????文件???????2485??2013-06-15?18:10??highcharts.aspx.cs

?????文件?????151286??2013-06-15?19:00??按好按鈕之后.jpg

?????文件?????164794??2013-06-15?19:00??初始綁定highcharts.jpg

?????目錄??????????0??2013-06-15?19:11??highchartsJsAndCss

-----------?---------??----------?-----??----

???????????????801077????????????????????10