基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

其中用到了 timer控件

    public partial class Frm_Main : Form
    {
        public class PyPanel : Panel
        {
            public PyPanel()
            {
                SetStyle(ControlStyles.OptimizedDoubleBuffer | ControlStyles.AllPaintingInWmPaint, true);
                UpdateStyles();
            }
        }
        public Frm_Main()
        {
            InitializeComponent();
        }
        SqlConnection con;
        SqlCommand cmd;
        
        private void Conn()
        {
            con = new SqlConnection("server=WRET-MOSY688YVW\\MRGLL;UID=sa;Pwd=hbyt2008!@#;database=db_TomeOne");
            con.Open();
        }

        Bitmap bt;
        Bitmap bt1;
        int flag = 0;
        PyPanel panel1 = new PyPanel();
        private void ShowPic(string SexCode, float f)							// ShowPic方法绘制饼图
        {
            this.Controls.Add(panel1);									//将Panel控件添加到窗体中
            panel1.Width = 230;										//设置Panel控件的宽度
            panel1.Height = 230;										//设置Panel控件的高度
            bt = new Bitmap(panel1.Width, panel1.Height);						//创建画布
            Graphics g = Graphics.FromImage(bt);							//创建Graphics对象
            Pen p = new Pen(new SolidBrush(Color.Blue));						//创建画笔
            Point p1 = new Point(0, 0);									//创建一个Point对象
            Size s = new Size(this.panel1.Width, this.panel1.Height);				//创建Size对象
            Rectangle trct = new Rectangle(p1, s);							//创建Rectangle对象
            g.FillEllipse(new SolidBrush(Color.Red), trct);						//绘制椭圆
            g.FillPie(new SolidBrush(Color.Blue), trct, flag, f * 360);				//绘制扇形
            bt1 = new Bitmap(panel2.Width, panel2.Height);						//创建画布
            Graphics ginfo = Graphics.FromImage(bt1);						//创建Graphics对象
            Font font = new Font("宋体", 10, FontStyle.Regular);				//设置字体
            ginfo.DrawString(SexCode   " "   f.ToString().Substring(0, 4), font, new SolidBrush(Color.Blue), 0, 5);
            ginfo.DrawString("女"   " "   (1.0 - Convert.ToDouble(f.ToString().Substring(0, 4))).ToString().Substring(0, 4), font, new SolidBrush(Color.Red), 0, 25);											//绘制性别及比率
            panel1.BackgroundImage = bt;								//显示饼图
            panel2.BackgroundImage = bt1;								//显示性别及比率
        }

        private void button1_Click(object sender, EventArgs e)					//单击“显示”按钮显示饼图
        {
            Conn();												//连接数据库
            //using (cmd = new SqlCommand("SELECT sex,COUNT(sex) num FROM tb_sex group by sex", con))
            using (cmd = new SqlCommand("SELECT sex,COUNT(sex) num FROM tb_sex group by sex", con))
            {
                SqlDataReader dr = cmd.ExecuteReader();						//创建SqlDataReader对象
                string[] str = new string[2];
                int i = 0;
                while (dr.Read())										//读取记录
                {
                    str[i] = dr[0].ToString()   ","   dr[1].ToString();			//获取数据库中存储的性别及比例
                    i  ;
                }
                float N = Convert.ToInt16(str[0].Substring(2))   Convert.ToInt16(str[1].Substring(2));//男女性别比例之和
                float f = Convert.ToInt16(str[0].Substring(2)) / N;				//男性的比例
                flag = 180;											//开始绘制的起始角度
                ShowPic(str[0].Substring(0, 1), f);							//调用ShowPic方法绘制饼图
            }
            con.Close();
        }

        private void timer1_Tick(object sender, EventArgs e)						//当单击“旋转”按钮时开始旋转饼图
        {
            flag  = 1;												//每次转动一度
            Conn();												//连接数据库
            using (cmd = new SqlCommand("SELECT sex,COUNT(sex) num FROM tb_sex group by sex", con))
            {
                SqlDataReader dr = cmd.ExecuteReader();						//创建SqlDataReader对象
                string[] str = new string[2];								//声明数组存储性别及比例
                int i = 0;
                while (dr.Read())
                {
                    str[i] = dr[0].ToString()   ","   dr[1].ToString();			//获取数据库中存储的性别及比例
                    i  ;
                }
                float N = Convert.ToInt16(str[0].Substring(2))   Convert.ToInt16(str[1].Substring(2)); //男女性别比例之和
                float f = Convert.ToInt16(str[0].Substring(2)) / N;				//男性的比例
                ShowPic(str[0].Substring(0, 1), f);							//调用ShowPic方法绘制饼图
            }
            con.Close();												//关闭连接
        }

        private void button2_Click(object sender, EventArgs e)					//“旋转”按钮
        {
            if (button2.Text == "旋转")									//如果按钮显示“旋转”文本
            {
                timer1.Start();										//开始Timer控件
                button2.Text = "停止";									//将按钮的文本设为“停止”
            }
            else													//如果按钮的文本为“停止”
            {
                timer1.Stop();										//停止Timer控件
                button2.Text = "旋转";									//将按钮的文本设为“旋转”
            }
        }
    }