其中用到了 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 = "旋转";//将按钮的文本设为“旋转” } } }
评论