.工具类ChartServices
using System;
using System.Data;
using System.Drawing;
using DevExpress.XtraCharts;
namespace HraWeb.Common
{
public static class ChartServices
{
/// <summary>
/// 绘制图形
/// </summary>
/// <param name="control">图表控件</param>
/// <param name="seriesName">系列名</param>
/// <param name="type">类型</param>
/// <param name="dt">数据源</param>
/// <param name="column1"></param>
/// <param name="column2"></param>
public static void DrawChart(DevExpress.XtraCharts.Web.WebChartControl control, string seriesName, ViewType type, DataTable dt, string column1, string column2)
{
Series series = new Series(seriesName, type);
DataTable table = dt;
SeriesPoint point = null;
for (int i = ; i < table.Rows.Count; i++)
{
point = new SeriesPoint(table.Rows[i][column1].ToString(), Convert.ToDouble(table.Rows[i][column2].ToString()));
series.Points.Add(point);
}
control.Series.Add(series);
//针对饼图的特殊处理
if (type == ViewType.Pie)
{
//设置显示方式(Argument:显示图例说明，ArgumentAndValues:显示图例内容和数据)
series.Label.PointOptions.PointView = PointView.ArgumentAndValues;
//设置数据显示形式(Percent:百分比,Currency:货币类型，数据前添加￥,Scientific:科学计数法)
series.Label.PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;
//数据是否保留小数(0：不保留小数位，1保留一位小数，2保留两位小数)
series.Label.PointOptions.ValueNumericOptions.Precision = ;
//数据以百分比显示时只能是Default和None
((PieSeriesLabel)series.Label).ResolveOverlappingMode = ResolveOverlappingMode.Default;
}
}
/// <summary>
/// 设置图表标题
/// </summary>
/// <param name="control">图表控件</param>
/// /// <param name="isVisible">标题是否可见</param>
/// <param name="text">标题文本</param>
/// <param name="isWordWrop">是否换行</param>
/// <param name="maxLineCount">最大允许行数</param>
/// <param name="alignment">对齐方式</param>
/// <param name="dock">位置</param>
/// <param name="isAntialiasing">是否允许设置外观</param>
/// <param name="font">字体</param>
/// <param name="textColor">文本颜色</param>
/// <param name="indent">字体缩进值</param>
public static void SetChartTitle(DevExpress.XtraCharts.Web.WebChartControl control, bool isVisible, String text, bool isWordWrop, int maxLineCount, StringAlignment alignment, ChartTitleDockStyle dock, bool isAntialiasing, Font font, Color textColor, int indent)
{
//设置标题
ChartTitle title = new ChartTitle();
title.Visible = isVisible;
//显示文本
title.Text = text;
//是否允许换行
title.WordWrap = isWordWrop;
//最大允许行数
title.MaxLineCount = maxLineCount;
//对齐方式
title.Alignment = alignment;
//位置
title.Dock = dock;
//是否允许设置外观
title.Antialiasing = isAntialiasing;
//字体
title.Font = font;
//字体颜色
title.TextColor = textColor;
//缩进值
title.Indent = indent;
control.Titles.Add(title);
}
/// <summary>
/// 为X轴添加标题
/// </summary>
/// <param name="control">图形控件</param>
/// <param name="isVisible">标题是否可见</param>
/// <param name="aligment">对齐方式</param>
/// <param name="text">标题显示文本</param>
/// <param name="color">标题字体颜色</param>
/// <param name="isAntialiasing">是否允许设置外观</param>
/// <param name="font">字体</param>
public static void SetAxisX(DevExpress.XtraCharts.Web.WebChartControl control, bool isVisible, StringAlignment aligment, string text, Color color, bool isAntialiasing, Font font)
{
XYDiagram xydiagram = (XYDiagram)control.Diagram;
xydiagram.AxisX.Title.Visible = isVisible;
xydiagram.AxisX.Title.Alignment = aligment;
xydiagram.AxisX.Title.Text = text;
xydiagram.AxisX.Title.TextColor = color;
xydiagram.AxisX.Title.Antialiasing = isAntialiasing;
xydiagram.AxisX.Title.Font = font;
}
/// <summary>
/// 为X轴添加标题
/// </summary>
/// <param name="control">图形控件</param>
/// <param name="isVisible">标题是否可见</param>
/// <param name="aligment">对齐方式</param>
/// <param name="text">标题显示文本</param>
/// <param name="color">标题字体颜色</param>
/// <param name="isAntialiasing">是否允许设置外观</param>
/// <param name="font">字体</param>
public static void SetAxisY(DevExpress.XtraCharts.Web.WebChartControl control, bool isVisible, StringAlignment aligment, string text, Color color, bool isAntialiasing, Font font)
{
XYDiagram xydiagram = (XYDiagram)control.Diagram;
xydiagram.AxisY.Title.Visible = isVisible;
xydiagram.AxisY.Title.Alignment = aligment;
xydiagram.AxisY.Title.Text = text;
xydiagram.AxisY.Title.TextColor = color;
xydiagram.AxisY.Title.Antialiasing = isAntialiasing;
xydiagram.AxisY.Title.Font = font;
}
}
}
.webform.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm2.aspx.cs" Inherits="HraWeb.WebForm2" %>
<%@ Register assembly="DevExpress.XtraCharts.v15.1.Web, Version=15.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraCharts.Web" tagprefix="dxchartsui" %>
<%@ Register TagPrefix="dx" Namespace="DevExpress.Web" Assembly="DevExpress.Web.v15.1, Version=15.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" %>
<%@ Register assembly="DevExpress.XtraCharts.v15.1, Version=15.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraCharts" tagprefix="cc1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<dxchartsui:WebChartControl ID="WebChartControl5" runat="server" CrosshairEnabled="True" Height="200px" PaletteName="Flow" Width="229px">
<seriesserializable>
<cc1:Series Name="Series 1">
<points>
<cc1:SeriesPoint ArgumentSerializable="" Values="">
</cc1:SeriesPoint>
<cc1:SeriesPoint ArgumentSerializable="" Values="">
</cc1:SeriesPoint>
<cc1:SeriesPoint ArgumentSerializable="" Values="">
</cc1:SeriesPoint>
<cc1:SeriesPoint ArgumentSerializable="" Values="">
</cc1:SeriesPoint>
<cc1:SeriesPoint ArgumentSerializable="" Values="">
</cc1:SeriesPoint>
</points>
<viewserializable>
<cc1:FunnelSeriesView>
</cc1:FunnelSeriesView>
</viewserializable>
</cc1:Series>
</seriesserializable>
</dxchartsui:WebChartControl>
<dx:ASPxGridView ID="ASPxGridView1" runat="server" KeyFieldName="类型" Caption="公司基本面信息" Width="600px" >
<SettingsPager Visible="False">
</SettingsPager>
<Styles>
<AlternatingRow Enabled="true" BackColor="#D5FEFF" />
</Styles>
</dx:ASPxGridView>
<dxchartsui:WebChartControl ID="WebChartControl2" runat="server" Width="600px" Height="300px" AppearanceNameSerializable="Gray" CrosshairEnabled="True" PaletteName="Green">
</dxchartsui:WebChartControl>
<table>
<td>
<dxchartsui:WebChartControl ID="WebChartControl4" runat="server" Width="300px" Height="250px" AppearanceNameSerializable="Gray" CrosshairEnabled="True" PaletteName="Green">
</dxchartsui:WebChartControl>
</td>
<td>
<dxchartsui:WebChartControl ID="WebChartControl6" runat="server" Width="300px" Height="250px" AppearanceNameSerializable="Gray" CrosshairEnabled="True" PaletteName="Green">
</dxchartsui:WebChartControl>
</td>
</table>
<dxchartsui:WebChartControl ID="WebChartControl3" runat="server" Width="600px" Height="300px" AppearanceNameSerializable="Gray" CrosshairEnabled="True" PaletteName="Green">
</dxchartsui:WebChartControl>
<dxchartsui:WebChartControl ID="WebChartControl1" runat="server" Width="600px" Height="300px" AppearanceNameSerializable="Gray" CrosshairEnabled="True" PaletteName="Green">
</dxchartsui:WebChartControl>
<dx:ASPxGridView ID="ASPxGridView2" runat="server" KeyFieldName="类型" Caption="公司基本面信息" Width="600px" >
<SettingsPager Visible="False">
</SettingsPager>
<Styles>
<AlternatingRow Enabled="true" BackColor="#D5FEFF" />
</Styles>
</dx:ASPxGridView>
<dx:ASPxGridView ID="ASPxGridView3" runat="server" KeyFieldName="类型" Caption="公司基本面信息" Width="600px" >
<SettingsPager Visible="False">
</SettingsPager>
<Styles>
<AlternatingRow Enabled="true" BackColor="#D5FEFF" />
</Styles>
</dx:ASPxGridView>
</div>
</form>
</body>
</html>
.webform.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using DevExpress.XtraCharts;
using System.Drawing;
using DevExpress.Web;
using Framework;
using HraWeb.Common;
namespace HraWeb
{
public partial class WebForm2 : BasePage
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = CreateData();
this.ASPxGridView1.DataSource = dt;
this.ASPxGridView1.DataBind();
this.ASPxGridView2.DataSource = dt;
this.ASPxGridView2.DataBind();
this.ASPxGridView3.DataSource = dt;
this.ASPxGridView3.DataBind();
for (int i = ; i < ASPxGridView1.Columns.Count; i++)
this.ASPxGridView1.DataSource = dt;
this.ASPxGridView1.DataBind();
for (int i = ; i < ASPxGridView1.Columns.Count; i++)
{
ASPxGridView1.Columns[i].HeaderStyle.BackColor = Color.Green;
ASPxGridView1.Columns[i].HeaderStyle.ForeColor = Color.White;
}
for (int i = ; i < ASPxGridView2.Columns.Count; i++)
{
ASPxGridView2.Columns[i].HeaderStyle.BackColor = Color.Green;
ASPxGridView2.Columns[i].HeaderStyle.ForeColor = Color.White;
}
for (int i = ; i < ASPxGridView3.Columns.Count; i++)
{
ASPxGridView3.Columns[i].HeaderStyle.BackColor = Color.Green;
ASPxGridView3.Columns[i].HeaderStyle.ForeColor = Color.White;
}
}
ASPxGridView1.HtmlDataCellPrepared += ASPxGridView1_HtmlDataCellPrepared;
ASPxGridView2.HtmlDataCellPrepared += ASPxGridView2_HtmlDataCellPrepared;
ASPxGridView3.HtmlDataCellPrepared += ASPxGridView3_HtmlDataCellPrepared;
this.DrawBar();
this.DrawLine();
this.DrawPie();
this.DrawBarAndLine();
}
private void ASPxGridView1_HtmlDataCellPrepared(object sender, ASPxGridViewTableDataCellEventArgs e)
{
if (e.DataColumn.FieldName == "类型")
{
e.Cell.BackColor = Color.Green;
e.Cell.ForeColor = Color.White;
}
}
private static Contract.IService.IDaoService GetDao()
{
Spring.Context.IApplicationContext ctx = Spring.Context.Support.ContextRegistry.GetContext();
Contract.IService.IDaoService _dao = (Contract.IService.IDaoService)ctx["DaoService"];
return _dao;
}
private void ASPxGridView2_HtmlDataCellPrepared(object sender, ASPxGridViewTableDataCellEventArgs e)
{
if (e.DataColumn.FieldName == "类型")
{
e.Cell.BackColor = Color.Green;
e.Cell.ForeColor = Color.White;
}
}
private void ASPxGridView3_HtmlDataCellPrepared(object sender, ASPxGridViewTableDataCellEventArgs e)
{
if (e.DataColumn.FieldName == "类型")
{
e.Cell.BackColor = Color.Green;
e.Cell.ForeColor = Color.White;
}
}
public static DataTable GetWeekMoneyAndCost()
{
var Dao = GetDao();
QueryInfo dtInfo = new QueryInfo();
dtInfo.CustomSQL = @"
select '2013年年度' type,t.total_asset value1,t.sale_revenue value2,t.return_total_asset value3,t.inventory_turnover value4,
t.current_ratio value5,t.sale_cash_ratio value6,6.5 z_score,6.3 ANN from ccr_credit_input_data t
where t.input_date=to_date('2013/12/31','yyyy/mm/dd') and t.company_name=209045 and t.purpose=102601
union all
select '2014年年度' type,t.total_asset value1,t.sale_revenue value2,t.return_total_asset value3,t.inventory_turnover value4,
t.current_ratio value5,t.sale_cash_ratio value6, 6.5 z_score,6.3 ANN from ccr_credit_input_data t
where t.input_date=to_date('2013-12-31','yyyy-mm-dd') and t.company_name=209039 and t.purpose=102601
";
DataTable dt2 = Dao.ExcuteDataSet(dtInfo).Tables[];
return dt2;
}
private DataTable CreateData()
{
QueryInfo dtInfo = new QueryInfo();
dtInfo.CustomSQL = @"
select '2013年年度' type,t.total_asset value1,t.sale_revenue value2,t.return_total_asset value3,t.inventory_turnover value4,
t.current_ratio value5,t.sale_cash_ratio value6,6.5 z_score,6.3 ANN from ccr_credit_input_data t
where t.input_date=to_date('2013/12/31','yyyy/mm/dd') and t.company_name=209045 and t.purpose=102601
union all
select '2014年年度' type,t.total_asset value1,t.sale_revenue value2,t.return_total_asset value3,t.inventory_turnover value4,
t.current_ratio value5,t.sale_cash_ratio value6, 6.5 z_score,6.3 ANN from ccr_credit_input_data t
where t.input_date=to_date('2013-12-31','yyyy-mm-dd') and t.company_name=209039 and t.purpose=102601
";
DataTable dt2 = Dao.ExcuteDataSet(dtInfo).Tables[];
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("类型"));
dt.Columns.Add(new DataColumn("总资产", typeof(decimal)));
dt.Columns.Add(new DataColumn("销售收入", typeof(decimal)));
dt.Columns.Add(new DataColumn("总资产报酬率", typeof(decimal)));
dt.Columns.Add(new DataColumn("存货周转率", typeof(decimal)));
dt.Columns.Add(new DataColumn("流动比率", typeof(decimal)));
dt.Columns.Add(new DataColumn("销售现金比率", typeof(decimal)));
foreach (DataRow row in dt2.Rows)
{
dt.Rows.Add(new object[] { row[], row[], row[], row[], row[], row[], row[] });
}
return dt;
}
/// <summary>
/// 绘制柱状图
/// </summary>
private void DrawBar()
{
ChartServices.SetChartTitle(this.WebChartControl1, true, "神经网络结构拟合情况表", true, , StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", , FontStyle.Bold), Color.Blue, ); //如不需显示图表标题可不用调用本段代码，下同
ChartServices.DrawChart(this.WebChartControl1, "Z SCORE", ViewType.Bar, GetWeekMoneyAndCost(), "TYPE", "Z_SCORE");
ChartServices.DrawChart(this.WebChartControl1, "ANN", ViewType.Bar, GetWeekMoneyAndCost(), "TYPE", "ANN");
}
/// <summary>
/// 绘制折线图
/// </summary>
private void DrawLine()
{
ChartServices.SetChartTitle(this.WebChartControl3, true, "2012年12月第1周收入情况", true, , StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", , FontStyle.Bold), Color.OrangeRed, );
ChartServices.DrawChart(this.WebChartControl3, "收益", ViewType.Line, GetWeekMoneyAndCost(), "TYPE", "Z_SCORE");
ChartServices.DrawChart(this.WebChartControl3, "成本", ViewType.Line, GetWeekMoneyAndCost(), "TYPE", "ANN");
}
/// <summary>
/// 柱状图和折线图在同一图表中
/// </summary>
private void DrawBarAndLine()
{
ChartServices.SetChartTitle(this.WebChartControl2, true, "2012年12月第1周收入情况", true, , StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", , FontStyle.Bold), Color.Red, );
ChartServices.DrawChart(this.WebChartControl2, "收益", ViewType.Bar, GetWeekMoneyAndCost(), "TYPE", "Z_SCORE");
ChartServices.DrawChart(this.WebChartControl2, "成本", ViewType.Bar, GetWeekMoneyAndCost(), "TYPE", "ANN");
ChartServices.SetChartTitle(this.WebChartControl2, false, "2012年12月第1周收入情况", true, , StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", , FontStyle.Bold), Color.Red, );
ChartServices.DrawChart(this.WebChartControl2, "收益", ViewType.Line, GetWeekMoneyAndCost(), "TYPE", "Z_SCORE");
ChartServices.DrawChart(this.WebChartControl2, "成本", ViewType.Line, GetWeekMoneyAndCost(), "TYPE", "ANN");
}
/// <summary>
/// 绘制饼图
/// </summary>
private void DrawPie()
{
ChartServices.SetChartTitle(this.WebChartControl4, true, "2012年12月第1周收入情况", true, , StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", , FontStyle.Bold), Color.Red, );
ChartServices.DrawChart(this.WebChartControl4, GetWeekMoneyAndCost().Rows[][].ToString(), ViewType.Pie, GetWeekMoneyAndCost(), "TYPE", "Z_SCORE");
ChartServices.SetChartTitle(this.WebChartControl6, true, "2012年12月第1周收入情况", true, , StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", , FontStyle.Bold), Color.Red, );
ChartServices.DrawChart(this.WebChartControl6, GetWeekMoneyAndCost().Rows[][].ToString(), ViewType.Pie, GetWeekMoneyAndCost(), "TYPE", "ANN");
}
}
}
