WinFrom饼形图

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.SqlClient;

using System.Drawing.Drawing2D;

namespace MyFillPie

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        SqlConnection conn;     //声明一个connection变量

        private void Form1_Paint(object sender, PaintEventArgs e)

        {

            //连接SQLserver数据库

            conn = new SqlConnection("server=.;database=AssetSys;uid=sa;pwd=sa");

            conn.Open();

            string str2 = string.Format("select SUM(tp) from tb_vote");

            SqlCommand cmd=new SqlCommand (str2,conn);

            int sum = Convert.ToInt32(cmd.ExecuteScalar());

            SqlDataAdapter sda = new SqlDataAdapter("select * from tb_vote",conn);

            DataSet ds = new DataSet();

            sda.Fill(ds);

            int man20and25 = Convert.ToInt32(ds.Tables[].Rows[][].ToString());

            int man26and30 = Convert.ToInt32(ds.Tables[].Rows[][].ToString());

            int man31and40 = Convert.ToInt32(ds.Tables[].Rows[][].ToString());

            int width = , height = ;

            Bitmap bitmap = new Bitmap(width, height);

            Graphics g = Graphics.FromImage(bitmap);

            try

            {

                 g.Clear(Color.White); //使用Clear方法使画布变成白色

                 Pen pen = new Pen(Color.Red);

                //创建4个Brush对象,用于填充颜色

                Brush brush1 = new SolidBrush(Color.PowderBlue);

                Brush brush2 = new SolidBrush(Color.Blue);

                Brush brush3 = new SolidBrush(Color.Wheat);

                Brush brush4 = new SolidBrush(Color.Orange);

                Font f1 = new Font("Courier New", , FontStyle.Bold);

                Font f2 = new Font("Courier New", );

                g.FillRectangle(brush1, , , width, height);   //绘制背景图

                g.DrawString("点赞比例", f1, brush2, new Point(, )); //绘制标题

                int piex = , piey = , piew = , pieh = ;

                float age1 = Convert.ToSingle((/Convert.ToSingle(sum))*man20and25);

                float age2 = Convert.ToSingle(( / Convert.ToSingle(sum)) * man26and30);

                float age3 = Convert.ToSingle(( / Convert.ToSingle(sum)) * man31and40);

                g.FillPie(brush2,piex,piey,piew,pieh,,age1);

                g.FillPie(brush3, piex, piey, piew, pieh, age1,age2);

                g.FillPie(brush4, piex, piey, piew, pieh, age1+age2,age3);

                g.DrawRectangle(pen,,,,);

                g.FillRectangle(brush2,,,,);

                g.DrawString("点赞比例1:" + Convert.ToSingle(man20and25) *  / sum + "%", f2, brush2, , );

                g.FillRectangle(brush3, , , , );

                g.DrawString("点赞比例2:" + Convert.ToSingle(man26and30) *  / sum + "%", f2, brush2, , );

                g.FillRectangle(brush4, , , , );

                g.DrawString("点赞比例3:" + Convert.ToSingle(man31and40) *  / sum + "%", f2, brush2, , );

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

            pictureBox1.Image = bitmap;

        }

    }

}

T-SQL：

USE [AssetSys]

GO

/****** Object:  Table [dbo].[tb_vote]    Script Date: 2018/10/27 9:12:00 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tb_vote](

    [Id] [int] IDENTITY(1,1) NOT NULL,

    [Name] [nvarchar](50) NOT NULL,

    [TP] [int] NOT NULL,

    [CreateTime] [datetime] NOT NULL,

    [Remake] [nvarchar](50) NOT NULL,

    [State] [int] NOT NULL,

    [Sort] [int] NOT NULL,

 CONSTRAINT [PK_tb_vote] PRIMARY KEY CLUSTERED

(

    [Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tb_vote] ADD  CONSTRAINT [DF_tb_vote_CreateTime]  DEFAULT (getdate()) FOR [CreateTime]

GO