chart

/** 1. 功能：统计指定时间范围的用户在线时间
 *  2. 作者：龚义
 *  3. 创建日期：2009-4-29
 *  4. 最后修改日期：2009-4-29
**/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using InfoSoftGlobal;

public partial class ReportOrder : System.Web.UI.Page
{
    string connectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    private SqlConnection GetSqlConnection()
    {
        SqlConnection conn = new SqlConnection(connectionString);
        return conn;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.beginDate.Value = this.endDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
            this.beginTime.Value = "00:00";
            this.endTime.Value = DateTime.Now.ToString("HH:mm");
        }

    }

    protected DataTable GetOrderDataTable()
    {
        string begin = beginDate.Value + " " + beginTime.Value;
        string end = endDate.Value + " " + endTime.Value;
        DataTable dt = new DataTable();
        string str = "select substring(convert(varchar(13),ordereddate,120),12,2) as hour,count(*) ordercount from t_payorder where ordereddate           >='" + begin + "' and ordereddate <'" + end + "' and orderstatus=1 group by substring(convert(varchar(13),ordereddate,120),12,2) order by hour";
        using (SqlConnection conn = GetSqlConnection())
        {
            SqlCommand cmd = new SqlCommand(str, conn);
            cmd.CommandText = str;
            SqlDataAdapter apt = new SqlDataAdapter(cmd);
            apt.Fill(dt);
            dt.TableName = "table";
            cmd.Dispose();
            conn.Close();
        }

        return dt;

    }

 

    public string CreateChart()
    {
        DataTable dt = new DataTable();
        dt = GetOrderDataTable();

        string[,] array = new string[dt.Rows.Count, 2];

        for (int i = 0; i < dt.Rows.Count; i++)
        {
            for (int j = 0; j < 2; j++)
            {
                array[i, j] = dt.Rows[i][j].ToString();
            }
        }

        string strXML, strCategories, strDataRev, strDataQty;

 

        strXML = "<graph caption='订单走势图' PYAxisName='Revenue' SYAxisName='Quantity (in Units)' numberPrefix='笔' formatNumberScale='0' showValues='0' decimalPrecision='0' anchorSides='14' anchorRadius='3' anchorBorderColor='FF8000'>";

        strCategories = "<categories>";

        strDataRev = "<dataset seriesName='24小时' color='AFD8F8' >";
        strDataQty = "<dataset seriesName='订单数量' parentYAxis='S' color='FF8000' >";

 

        for (int k = 0; k < dt.Rows.Count; k++)
        {

            strCategories += "<category name='" + array[k, 0] + "' />";
            strDataRev += "<set value='" + array[k, 1] + "' />";
            strDataQty += "<set value='" + array[k, 1] + "' />";
        }

        strCategories += "</categories>";

        //关闭<dataset>要素
        strDataRev += "</dataset>";
        strDataQty += "</dataset>";

        //组装现在整个的XML
        strXML += strCategories + strDataRev + strDataQty + "</graph>";

        //创建图表-质谱柱线组合三维图的数据载于strXML
        return FusionCharts.RenderChart("FusionCharts/FCF_MSColumn3DLineDY.swf", "", strXML, "", "780", "330", false, false);

    }

 

 

}