Asp中C#中做統(tǒng)計圖.docx

Asp.Net實例：C# 繪制統(tǒng)計圖(柱狀圖, 折線圖, 扇形圖)2008-9-24 19:30:32 已被閱讀： 3582 發(fā)表評論統(tǒng)計圖形種類繁多, 有柱狀圖, 折線圖, 扇形圖等等, 而統(tǒng)計圖形的繪制方法也有很多, 有Flash制作的統(tǒng)計圖形, 有水晶報表生成統(tǒng)計圖形, 有專門制圖軟件制作, 也有編程語言自己制作的；這里我們用就C# 制作三款最經(jīng)典的統(tǒng)計圖: 柱狀圖, 折線圖和扇形圖；既然是統(tǒng)計, 當然需要數(shù)據(jù), 這里演示的數(shù)據(jù)存于Sql Server2000中, 三款統(tǒng)計圖形都是動態(tài)生成. 其中柱狀圖我會附上制作步驟, 其他兩款統(tǒng)計圖直接附源碼.說明: 需求不一樣, 統(tǒng)計圖形繪制后的顯示效果也不一樣, 比如這里柱狀圖的主要需求是為了比較每一期報名人數(shù)與通過人數(shù)的差, 因此會把兩根柱子放在一起會使比較結(jié)果一目了然. 因此大家可以根據(jù)需要靈活繪制. 一. 柱狀圖的繪制.繪制步驟如下: 1. 定義繪圖用到的類.定義繪圖類int height = 500, width = 700;Bitmap image = new Bitmap(width, height);Graphics g = Graphics.FromImage(image);Pen mypen = new Pen(brush, 1);2. 繪制圖框.繪制圖框g.FillRectangle(Brushes.WhiteSmoke, 0, 0, width, height); 3. 繪制橫向坐標線繪制橫向坐標線for (int i = 0; i 14; i+) g.DrawLine(mypen, x, 80, x, 340);x = x + 40;4. 繪制縱向坐標線繪制縱向坐標線for (int i = 0; i 9; i+) g.DrawLine(mypen, 60, y, 620, y);y = y + 26;5. 繪制橫坐標值繪制橫坐標值String n = 第一期, 第二期, 第三期, 第四期, 全年 ;for (int i = 0; i 7; i+) g.DrawString(ni.ToString(), font, Brushes.Blue, x, 348); x = x + 78;6. 繪制縱坐標值繪制縱坐標String m = 250,225, 200, 175, 150, 125, 100“;for (int i = 0; i 10; i+) g.DrawString(mi.ToString(), font, Brushes.Blue, 25, y);y = y + 26;7. 定義數(shù)組存儲數(shù)據(jù)庫中統(tǒng)計的數(shù)據(jù)定義存儲統(tǒng)計數(shù)據(jù)的數(shù)組int Count1 = new int7; /存儲從數(shù)據(jù)庫讀取的報名人數(shù)int Count2 = new int7; /存儲從數(shù)據(jù)庫讀取的通過人數(shù) 8. 從數(shù)據(jù)庫中讀取報名人數(shù)與通過人數(shù)讀取數(shù)據(jù)SqlConnection Con = new SqlConnection(Server=(Local);Database=committeeTraining;);Con.Open();string cmdtxt2 = SELECT * FROM #Count where Company= + *+ ;SqlDataAdapter da = new SqlDataAdapter(cmdtxt2, Con);DataSet ds = new DataSet();da.Fill(ds); 9. 將讀取的數(shù)據(jù)存儲到數(shù)組中將數(shù)據(jù)存儲到數(shù)組中Count10 = Convert.ToInt32(ds.Tables0.Rows0“count1”.ToString(); Count11 = Convert.ToInt32(ds.Tables0.Rows0“count3”.ToString(); Count20 = Convert.ToInt32(ds.Tables0.Rows0“count2”.ToString(); Count21 = Convert.ToInt32(ds.Tables0.Rows0count4.ToString();10.定義畫筆和畫刷準備繪圖 準備繪制柱狀圖x = 80; Font font2 = new System.Drawing.Font(Arial, 10, FontStyle.Bold);SolidBrush mybrush = new SolidBrush(Color.Red);SolidBrush mybrush2 = new SolidBrush(Color.Green);11. 根據(jù)數(shù)組中的值繪制柱狀圖繪制柱狀圖(1)第一期報名人數(shù)g.FillRectangle(mybrush, x, 340 - Count10, 20, Count10);g.DrawString(Count10.ToString(), font2, Brushes.Red, x, 340 - Count10 - 15);(2) 第一期通過人數(shù)x = x + 20;g.FillRectangle(mybrush2, x, 340 - Count20, 20, Count20);g.DrawString(Count20.ToString(), font2, Brushes.Green, x, 340 - Count20 - 15);12. 將圖形輸出到頁面.將頁面輸出到頁中System.IO.MemoryStream ms = new System.IO.MemoryStream();image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);Response.ClearContent();Response.ContentType = image/Jpeg;Response.BinaryWrite(ms.ToArray(); 最終柱狀圖的效果圖: 柱狀圖的完整代碼:繪制柱狀統(tǒng)計圖的完整代碼private void CreateImage()int height = 500, width = 700;Bitmap image = new Bitmap(width, height);/創(chuàng)建Graphics類對象Graphics g = Graphics.FromImage(image);try/清空圖片背景色g.Clear(Color.White);Font font = new Font(Arial, 10, FontStyle.Regular);Font font1 = new Font(宋體, 20, FontStyle.Bold);LinearGradientBrush brush = new LinearGradientBrush(new Rectangle(0, 0, image.Width, image.Height), Color.Blue, Color.BlueViolet, 1.2f, true);g.FillRectangle(Brushes.WhiteSmoke, 0, 0, width, height);/ Brush brush1 = new SolidBrush(Color.Blue);g.DrawString(this.ddlTaget.SelectedItem.Text + + this.ddlYear.SelectedItem.Text + 成績統(tǒng)計柱狀圖, font1, brush, new PointF(70, 30);/畫圖片的邊框線g.DrawRectangle(new Pen(Color.Blue), 0, 0, image.Width - 1, image.Height - 1);Pen mypen = new Pen(brush, 1);/繪制線條/繪制橫向線條int x = 100;for (int i = 0; i 14; i+)g.DrawLine(mypen, x, 80, x, 340);x = x + 40;Pen mypen1 = new Pen(Color.Blue, 2);x = 60;g.DrawLine(mypen1, x, 80, x, 340);/繪制縱向線條int y = 106;for (int i = 0; i 9; i+)g.DrawLine(mypen, 60, y, 620, y);y = y + 26;g.DrawLine(mypen1, 60, y, 620, y);/x軸String n = 第一期, 第二期, 第三期, 第四期, 上半年, 下半年, 全年統(tǒng)計 ;x = 78;for (int i = 0; i 7; i+)g.DrawString(ni.ToString(), font, Brushes.Blue, x, 348); /設(shè)置文字內(nèi)容及輸出位置x = x + 78;/y軸String m = 250,225, 200, 175, 150, 125, 100, 75, 50, 25, 0;y = 72;for (int i = 0; i 10; i+)g.DrawString(mi.ToString(), font, Brushes.Blue, 25, y); /設(shè)置文字內(nèi)容及輸出位置y = y + 26;int Count1 = new int7;int Count2 = new int7;SqlConnection Con = new SqlConnection(Server=(Local);Database=committeeTraining;Uid=sa;Pwd=*);Con.Open();string cmdtxt2 = SELECT * FROM #Count where Company= + this.ddlTaget.SelectedItem.Text.Trim() + ;SqlDataAdapter da = new SqlDataAdapter(cmdtxt2, Con);DataSet ds = new DataSet();da.Fill(ds);Count10 = Convert.ToInt32(ds.Tables0.Rows0count1.ToString();Count11 = Convert.ToInt32(ds.Tables0.Rows0count3.ToString();Count12 = Convert.ToInt32(ds.Tables0.Rows0count5.ToString();Count13 = Convert.ToInt32(ds.Tables0.Rows0count7.ToString();Count14 = Count10 + Count11;Count15 = Count12 + Count13;Count16 = Convert.ToInt32(ds.Tables0.Rows0count9.ToString();Count20 = Convert.ToInt32(ds.Tables0.Rows0count2.ToString();Count21 = Convert.ToInt32(ds.Tables0.Rows0count4.ToString();Count22 = Convert.ToInt32(ds.Tables0.Rows0count6.ToString();Count23 = Convert.ToInt32(ds.Tables0.Rows0count8.ToString();Count24 = Count20 + Count21;Count25 = Count22 + Count23;Count26 = Convert.ToInt32(ds.Tables0.Rows0count10.ToString();/繪制柱狀圖.x = 80;Font font2 = new System.Drawing.Font(Arial, 10, FontStyle.Bold);SolidBrush mybrush = new SolidBrush(Color.Red);SolidBrush mybrush2 = new SolidBrush(Color.Green);/第一期g.FillRectangle(mybrush, x, 340 - Count10, 20, Count10);g.DrawString(Count10.ToString(), font2, Brushes.Red, x, 340 - Count10 - 15);x = x + 20;g.FillRectangle(mybrush2, x, 340 - Count20, 20, Count20);g.DrawString(Count20.ToString(), font2, Brushes.Green, x, 340 - Count20 - 15);/第二期x = x + 60;g.FillRectangle(mybrush, x, 340 - Count11, 20, Count11);g.DrawString(Count11.ToString(), font2, Brushes.Red, x, 340 - Count11 - 15);x = x + 20;g.FillRectangle(mybrush2, x, 340 - Count21, 20, Count21);g.DrawString(Count21.ToString(), font2, Brushes.Green, x, 340 - Count21 - 15);/第三期x = x + 60;g.FillRectangle(mybrush, x, 340 - Count12, 20, Count12);g.DrawString(Count12.ToString(), font2, Brushes.Red, x, 340 - Count12 - 15);x = x + 20;g.FillRectangle(mybrush2, x, 340 - Count22, 20, Count22);g.DrawString(Count22.ToString(), font2, Brushes.Green, x, 340 - Count22 - 15);/第四期x = x + 60;g.FillRectangle(mybrush, x, 340 - Count13, 20, Count13);g.DrawString(Count13.ToString(), font2, Brushes.Red, x, 340 - Count13 - 15);x = x + 20;g.FillRectangle(mybrush2, x, 340 - Count23, 20, Count23);g.DrawString(Count23.ToString(), font2, Brushes.Green, x, 340 - Count23 - 15);/上半年x = x + 60;g.FillRectangle(mybrush, x, 340 - Count14, 20, Count14);g.DrawString(Count14.ToString(), font2, Brushes.Red, x, 340 - Count14 - 15);x = x + 20;g.FillRectangle(mybrush2, x, 340 - Count24, 20, Count24);g.DrawString(Count24.ToString(), font2, Brushes.Green, x, 340 - Count24 - 15);/下半年x = x + 60;g.FillRectangle(mybrush, x, 340 - Count15, 20, Count15);g.DrawString(Count15.ToString(), font2, Brushes.Red, x, 340 - Count15 - 15);x = x + 20;g.FillRectangle(mybrush2, x, 340 - Count25, 20, Count25);g.DrawString(Count25.ToString(), font2, Brushes.Green, x, 340 - Count25 - 15);/全年x = x + 60;g.FillRectangle(mybrush, x, 340 - Count16, 20, Count16);g.DrawString(Count16.ToString(), font2, Brushes.Red, x, 340 - Count16 - 15);x = x + 20;g.FillRectangle(mybrush2, x, 340 - Count26, 20, Count26);g.DrawString(Count26.ToString(), font2, Brushes.Green, x, 340 - Count26 - 15);/繪制標識Font font3 = new System.Drawing.Font(Arial, 10, FontStyle.Regular);g.DrawRectangle(new Pen(Brushes.Blue), 170, 400, 250, 50); /繪制范圍框g.FillRectangle(Brushes.Red, 270, 410, 20, 10); /繪制小矩形g.DrawString(報名人數(shù), font3, Brushes.Red, 292, 408);g.FillRectangle(Brushes.Green, 270, 430, 20, 10);g.DrawString(通過人數(shù), font3, Brushes.Green, 292, 428);System.IO.MemoryStream ms = new System.IO.MemoryStream();image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);Response.ClearContent();Response.ContentType = image/Jpeg;Response.BinaryWrite(ms.ToArray();finallyg.Dispose();image.Dispose(); 二. 折線統(tǒng)計圖的繪制效果:折線圖的完整代碼:折線圖的完整代碼private void CreateImage()int height = 480, width = 700;Bitmap image = new Bitmap(width, height);Graphics g = Graphics.FromImage(image);try/清空圖片背景色g.Clear(Color.White);Font font = new System.Drawing.Font(Arial, 9, FontStyle.Regular);Font font1 = new System.Drawing.Font(宋體, 20, FontStyle.Regular);Font font2 = new System.Drawing.Font(Arial, 8, FontStyle.Regular);LinearGradientBrush brush = new LinearGradientBrush(new Rectangle(0, 0, image.Width, image.Height), Color.Blue, Color.Blue, 1.2f, true);g.FillRectangle(Brushes.AliceBlue, 0, 0, width, height);Brush brush1 = new SolidBrush(Color.Blue);Brush brush2 = new SolidBrush(Color.SaddleBrown);g.DrawString(this.ddlTaget.SelectedItem.Text + + this.ddlYear.SelectedItem.Text + 成績統(tǒng)計折線圖, font1, brush1, new PointF(85, 30);/畫圖片的邊框線g.DrawRectangle(new Pen(Color.Blue), 0, 0, image.Width - 1, image.Height - 1);Pen mypen = new Pen(brush, 1);Pen mypen2 = new Pen(Color.Red, 2);/繪制線條/繪制縱向線條int x = 60;for (int i = 0; i 8; i+)g.DrawLine(mypen, x, 80, x, 340);x = x + 80;Pen mypen1 = new Pen(Color.Blue, 3);x = 60;g.DrawLine(mypen1, x, 82, x, 340);/繪制橫向線條int y = 106;for (int i = 0; i 10; i+)g.DrawLine(mypen, 60, y, 620, y);y = y + 26;/ y = 106;g.DrawLine(mypen1, 60, y - 26, 620, y - 26);/x軸String n = 第一期, 第二期, 第三期, 第四期, 上半年, 下半年, 全年統(tǒng)計 ;x = 45;for (int i = 0; i 7; i+)g.DrawString(ni.ToString(), font, Brushes.Red, x, 348); /設(shè)置文字內(nèi)容及輸出位置x = x + 77;/y軸String m = 220人, 200人, 175人, 150人, 125人, 100人, 75人, 50人, 25人;y = 100;for (int i = 0; i 9; i+)g.DrawString(mi.ToString(), font, Brushes.Red, 10, y); /設(shè)置文字內(nèi)容及輸出位置y = y + 26;int Count1 = new int7;int Count2 = new int7;SqlConnection Con = new SqlConnection(Server=(Local);Database=committeeTraining;Uid=sa;Pwd=eesoft);Con.Open();string cmdtxt2 = SELECT * FROM #Count where Company= + this.ddlTaget.SelectedItem.Text.Trim() + ;SqlDataAdapter da = new SqlDataAdapter(cmdtxt2, Con);DataSet ds = new DataSet();da.Fill(ds);/報名人數(shù)Count10 = Convert.ToInt32(ds.Tables0.Rows0count1.ToString();Count11 = Convert.ToInt32(ds.Tables0.Rows0count3.ToString();Count12 = Convert.ToInt32(ds.Tables0.Rows0count5.ToString();Count13 = Convert.ToInt32(ds.Tables0.Rows0count7.ToString();Count16 = Convert.ToInt32(ds.Tables0.Rows0count9.ToString(); /全年Count14 = Count10 + Count11;Count15 = Count12 + Count13;Count20 = Convert.ToInt32(ds.Tables0.Rows0count2.ToString();Count21 = Convert.ToInt32(ds.Tables0.Rows0count4.ToString();Count22 = Convert.ToInt32(ds.Tables0.Rows0count6.ToString();Count23 = Convert.ToInt32(ds.Tables0.Rows0count8.ToString();Count26 = Convert.ToInt32(ds.Tables0.Rows0count10.ToString(); /全年Count24 = Count20 + Count21;Count25 = Count22 + Count23;/顯示折線效果Font font3 = new System.Drawing.Font(Arial, 10, FontStyle.Bold);SolidBrush mybrush = new SolidBrush(Color.Red);Point points1 = new Point7;points10.X = 60; points10.Y = 340 - Count10; /從106縱坐標開始, 到(0, 0)坐標時points11.X = 140; points11.Y = 340 - Count11;points12.X = 220; points12.Y = 340 - Count12;points13.X = 300; points13.Y = 340 - Count13;points14.X = 380; points14.Y = 340 - Count14;points15.X = 460; points15.Y = 340 - Count15;points16.X = 540; points16.Y = 340 - Count16;g.DrawLines(mypen2, points1); /繪制折線/繪制數(shù)字g.DrawString(Count10.ToString(), font3, Brushes.Red, 58, points10.Y - 20);g.DrawString(Count11.ToString(), font3, Brushes.Red, 138, points11.Y - 20);g.DrawString(Count12.ToString(), font3, Brushes.Red, 218, points12.Y - 20);g.DrawString(Count13.ToString(), font3, Brushes.Red, 298, points13.Y - 20);g.DrawString(Count14.ToString(), font3, Brushes.Red, 378, points14.Y - 20);g.DrawString(Count15.ToString(), font3, Brushes.Red, 458, points15.Y - 20);g.DrawString(Count16.ToString(), font3, Brushes.Red, 538, points16.Y - 20);Pen mypen3 = new Pen(Color.Green, 2);Point points2 = new Point7;points20.X = 60; points20.Y = 340 - Count20;points21.X = 140; points21.Y = 340 - Count21;points22.X = 220; points22.Y = 340 - Count22;points23.X = 300; points23.Y = 340 - Count23;points24.X = 380; points24.Y = 340 - Count24;points25.X = 460; points25.Y = 340 - Count25;points26.X = 540; points26.Y = 340 - Count26;g.DrawLines(mypen3, points2); /繪制折線/繪制通過人數(shù)g.DrawString(Count20.ToString(), font3, Brushes.Green, 61, points20.Y - 15);g.DrawString(Count21.ToString(), font3, Brushes.Green, 131, points21.Y - 15);g.DrawString(Count22.ToString(), font3, Brushes.Green, 221, points22.Y - 15);g.DrawString(Count23.ToString(), font3, Brushes.Green, 301, points23.Y - 15);g.DrawString(Count24.ToString(), font3, Brushes.Green, 381, points24.Y - 15);g.DrawString(Count25.ToString(), font3, Brushes.Green, 461, points25.Y - 15);g.DrawString(Count26.ToString(), font3, Brushes.Green, 541, points26.Y - 15);/繪制標識g.DrawRectangle(new Pen(Brushes.Red), 180, 390, 250, 50); /繪制范圍框g.FillRectangle(Brushes.Red, 270, 402, 20, 10); /繪制小矩形g.DrawString(報名人數(shù), font2, Brushes.Red, 292, 400);g.FillRectangle(Brushes.Green, 270, 422, 20, 10);g.DrawString(通過人數(shù), font2, Brushes.Green, 292, 420);System.IO.MemoryStream ms = new System.IO.MemoryStream();image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);Response.ClearContent();Response.ContentType = image/Jpeg;Response.BinaryWrite(ms.ToArray();finallyg.Dispose();image.Dispose();三. 扇形統(tǒng)計圖的繪制效果圖:完整代碼:扇形統(tǒng)計圖的繪制private void CreateImage()/把連接字串指定為一個常量SqlConnection Con = new SqlConnection(Server=(Local);Database=committeeTraining;Uid=sa;Pwd=*);Con.Open();string cmdtxt = selectString; / select * from #Count; /SqlCommand Com = new SqlCommand(cmdtxt, Con);DataSet ds = new DataSet();SqlDataAdapter Da = new SqlDataAdapter(cmdtxt, Con);Da.Fill(ds);Con.Close();float Total = 0.0f, Tmp;/轉(zhuǎn)換成單精度。也可寫成Convert.ToInt32Total = Convert.ToSingle(ds.Tables0.Rows0this.count0);/ Total=Convert.ToSingle(ds.Tables0.Rows0this.count0);/設(shè)置字體，fonttitle為主標題的字體Font fontlegend = new Font(verdana, 9);Font fonttitle = new Font(verdana, 10, FontStyle.Bold);/背景寬int width = 350;int bufferspace = 15;int legendheight = fontlegend.Height * 10 + bufferspace; /高度int titleheight = fonttitle.Height + bufferspace;int height = width + legendheight + titleheight + bufferspace;/白色背景高int pieheight = width;Rectangle pierect = new Rectangle(0, titleheight, width, pieheight);/加上各種隨機色ArrayList colors = new ArrayList();Random rnd = new Random();for (int i = 0; i 2; i+)colors.Add(new SolidBrush(Color.FromArgb(rnd.Next(255), rnd.Next(255), rnd.Next(255);/創(chuàng)建一個bitmap實例Bitmap objbitmap = new Bitmap(width, height);Graphics objgraphics = Graphics.FromImage(objbitmap);/畫一個白色背景objgraphics.FillRectangle(new SolidBrush(Color.White), 0, 0, width, height);/畫一個亮黃色背景 objgraphics.FillRectangle(new SolidBrush(Color.Beige), pierect);/以下為畫餅圖(有幾行row畫幾個)float currentdegree = 0.0f;/畫通過人數(shù)objgraphics.FillPie(SolidBrush)colors1, pierect, currentdegree,Convert.ToSingle(ds.Tables0.Rows0this.count1) / Total * 360);currentdegree += Convert.ToSingle(ds.Tables0.Rows0this.count1) / Total * 360;/未通過人數(shù)餅狀圖objgraphics.FillPie(SolidBrush)colors0, pierect, currentdegree,(Convert.ToSingle(ds.Tables0.Rows0this.count0)-(Convert.ToSingle(ds.Tables0.Rows0this.count1) / Total * 360);currentdegree += (Convert.ToSingle(ds.Tables0.Rows0this.count0) - (Convert.ToSingle(ds.Tables0.Rows0this.count1) / Total * 360;/以下為生成主標題SolidBrush blackbrush = new SolidBrush(Color.Black);SolidBrush bluebrush = new SolidBrush(Color.Blue);string title = 機關(guān)單位成績統(tǒng)計餅狀圖: + n nn;StringFormat stringFormat = new StringFormat();stringFormat.Alignment = StringAlignment.Center;stringFormat.LineAlignment = StringAlignment.Center;objgraphics.DrawString(title, fonttitle, blackbrush,new Rectangle(0, 0, width, titleheight), stringFormat);/列出各字段與得數(shù)目objgraphics.DrawRectangle(new Pen(Color.Red, 2), 0, height + 10 - legendheight, width, legen