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 InfoSoftGlobal;
public partial class SumUserOrderSuccessFail : System.Web.UI.Page
{
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");
}
BindData();
}
public Database DB
{
get
{
if (Session["CurrentDataBase"] == null)
this.Session["CurrentDataBase"] = DatabaseFactory.CreateDatabase();
return Session["CurrentDataBase"] as Database;
}
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindData()
{
DataSet ds = DB.ExecuteDataSet("SP_UserNoBankOrderSummary", string.Format("{0} {1}", this.beginDate.Value, beginTime.Value), string.Format("{0} {1}", endDate.Value, endTime.Value));
if (ds.Tables.Count > 0)
dsUserRegister.DataSource = ds.Tables[0];
dsUserRegister.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
BindData();
}
public string CreateChart()
{
DataTable dt = new DataTable();
DataSet ds = DB.ExecuteDataSet("SP_UserNoBankOrderSummary", string.Format("{0} {1}", this.beginDate.Value, beginTime.Value), string.Format("{0} {1}", endDate.Value, endTime.Value));
dt = ds.Tables[0];
string[,] array = new string[dt.Rows.Count, 3];
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < 3; 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='支付模式' color='AFD8F8' >";
strDataQty = "<dataset seriesName='成功单数' parentYAxis='S' color='FF8000' >";
for (int k = 0; k < dt.Rows.Count; k++)
{
strCategories += "<category name='" +AdminPay.PayMode.ReturnPayMode( int.Parse(array[k, 2])) + "' />";
strDataRev += "<set value='" + array[k, 0] + "' />";
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);
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ReportOrder.aspx.cs" Inherits="ReportOrder"
MasterPageFile="~/Admin.master" %>
<asp:Content ContentPlaceHolderID="main" ID="content1" runat="server">
<script type="text/javascript" src="FusionCharts/FusionCharts.js"></script>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" background="img/huishadow.jpg">
</td>
</tr>
<tr>
<td style="padding: 9px;">
<div class="location">
您所在位置： 管理首页 -> <span class="black"><strong>每小时的订单数量</strong></span></div>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" class="menutd"
style="border: 1px solid #ccc;">
<tr>
<td class="contenttd1">
<table cellpadding="0" cellspacing="0">
<tr>
<td align="left">
开始时间(yyyy-MM-dd) ：
</td>
<td align="left">
<input type="text" id="beginDate" runat="server" />
</td>
<td align="left">
</td>
<td align="left">
hh:mm
<input type="text" id="beginTime" style="width: 90px;" runat="server" />
</td>
<td rowspan="2" align="left">
<asp:Button ID="btnSearch" runat="server" Text="查询" Style="width: 60px; height: 30px;" />
</td>
</tr>
<tr>
<td align="left">
结束时间(yyyy-MM-dd) ：
</td>
<td align="left">
<input type="text" id="endDate" runat="server" />
</td>
<td align="left">
</td>
<td align="left">
hh:mm
<input type="text" id="endTime" style="width: 90px;" runat="server" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
</td>
</tr>
</table> <%=CreateChart() %>
</asp:Content>
/** 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);
}
}