日期:2014-05-17  浏览次数:21062 次

C# winform如何根据数据库生成饼状图?
有这么一句从数据库提取出胜平负百分比的SQL语句:
select left(case win when 0 then null else win/(win+draw+lose) end,4),
left(case draw when 0 then null else draw/(win+draw+lose) end,4),
left(case lose when 0 then null else lose/(win+draw+lose) end,4) from achievement
如何根据其生成一张饼状图在winfrom窗体上,并标识胜平负为不同颜色?

------解决方案--------------------
看看这个 功能强大 http://www.chartingcontrol.net/Download.aspx
------解决方案--------------------

http://www.advsofteng.com/
有源码
------解决方案--------------------
自己收集的资料 
C#中使用GDI+实现饼状图和柱状图跟数据库联接显示数据的方法。

using System;
using System.IO;//用于文件存取
using System.Data;//用于数据访问
using System.Drawing;//提供画GDI+图形的基本功能
using System.Drawing.Text;//提供画GDI+图形的高级功能
using System.Drawing.Drawing2D;//提供画高级二维,矢量图形功能
using System.Drawing.Imaging;//提供画GDI+图形的高级功能
namespace BaseLayer
{
 public class PieChart
 {
public PieChart()
{
}

//Render是图形大标题,图开小标题,图形宽度,图形长度,饼图的数据集和饼图的数据集要表示出来的数据

public Image Render(string title, string subTitle, int width, int height, DataSet chartData,int DataLine)
{
const int SIDE_LENGTH = 400;
const int PIE_DIAMETER = 200;
DataTable dt = chartData.Tables[0];
  
//通过输入参数,取得饼图中的总基数
float sumData = 0;
foreach(DataRow dr in dt.Rows)
{
sumData += Convert.ToSingle(dr[DataLine]);
}
//产生一个image对象,并由此产生一个Graphics对象
Bitmap bm = new Bitmap(width,height);
Graphics g = Graphics.FromImage(bm);
//设置对象g的属性
g.ScaleTransform((Convert.ToSingle(width))/SIDE_LENGTH,(Convert.ToSingle(height))/SIDE_LENGTH);
g.SmoothingMode = SmoothingMode.Default;
g.TextRenderingHint = TextRenderingHint.AntiAlias;
  
//画布和边的设定
g.Clear(Color.White);
g.DrawRectangle(Pens.Black,0,0,SIDE_LENGTH-1,SIDE_LENGTH-1);
//画饼图标题
g.DrawString(title,new Font("Tahoma",14),Brushes.Black,new PointF(5,5));
//画饼图的图例
g.DrawString(subTitle,new Font("Tahoma",12),Brushes.Black,new PointF(7,35));
//画饼图
float curAngle = 0;
float totalAngle = 0;
for(int i=0;i<dt.Rows.Count;i++)
{
curAngle = Convert.ToSingle(dt.Rows[i][DataLine]) / sumData * 360;
  
g.FillPie(new SolidBrush(ChartUtil.GetChartItemColor(i)),100,65,PIE_DIAMETER,PIE_DIAMETER,totalAngle,curAngle);
g.DrawPie(Pens.Black,100,65,PIE_DIAMETER,PIE_DIAMETER,totalAngle,curAngle);
totalAngle += curAngle;
}
//画图例框及其文字
g.DrawRectangle(Pens.Black,200,300,199,99);
g.DrawString("图表说明",new Font("Tahoma",12,FontStyle.Bold),Brushes.Black,new PointF(200,300));
  
//画图例各项
PointF boxOrigin = new PointF(210,330);
PointF textOrigin = new PointF(235,326);
float percent = 0;
for(int i=0;i<dt.Rows.Count;i++)
{
g.FillRectangle(new SolidBrush(ChartUtil.GetChartItemColor(i)),boxOrigin.X,boxOrigin.Y,20,10);
g.DrawRectangle(Pens.Black,boxOrigin.X,boxOrigin.Y,20,10);
percent = Convert.ToSingle(dt.Rows[i][DataLine]) / sumData * 100;
g.DrawString(dt.Rows[i][1].ToString() + " - " + dt.Rows[i][0].ToString() + " (" + percent.ToString("0") + "%)",new Font("Tahoma",10),Brushes.Black,textOrigin);
boxOrigin.Y += 15;
textOrigin.Y += 15;
}
//回收资源
g.Dispose();
return (Image) bm;
  
}
 }
  
 //画条形图
 public class BarChart
 {
public BarChart()
{
}

//Render是图形大标题,图开小标题,图形宽度,图形长度,饼图的数据集和饼图的数据集
public Image Render(string title, string subTit