<%@ Page Language="C#" %><%@import namespace="System.Data"%><%@import namespace="System.Data.OleDb"%><%@import namespace="System.Drawing"%><%@import namespace="System.Drawing.Imaging"%><script language="c#" runat="server"> public void page_load(Object obj,EventArgs e){//把连接字串指定为一个常量const String strconn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=c://mess.mdb";OleDbConnection conn=new OleDbConnection(strconn);conn.Open();string sql="select * from title";OleDbCommand cmd=new OleDbCommand(sql,conn);DataSet ds=new DataSet();OleDbDataAdapter adapter1=new OleDbDataAdapter(cmd);adapter1.Fill(ds);conn.Close();float total=0.0f,tmp;int iloop;
for(iloop=0;iloop<ds.Tables[0].Rows.Count;iloop++) { tmp=Convert.ToSingle(ds.Tables[0].Rows[iloop]["point"]);//转换成单精度,投票不可能投半票。也可写成Convert.ToInt32 total+=tmp;
}//Response.Write(Convert.ToString(total));Font fontlegend=new Font("verdana",9),fonttitle=new Font("verdana",10,FontStyle.Bold);//设置字体//fonttitle为主标题的字体int width=230;//白色背景宽const int bufferspace=15;int legendheight=fontlegend.
Height*(ds.Tables[0].Rows.Count+1)+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 (iloop = 0;
iloop < ds.Tables[0].Rows.Count;
iloop++) colors.Add(new SolidBrush(Color.FromArgb(rnd.Next(255), rnd.Next(255), rnd.Next(255))));Bitmap objbitmap=new Bitmap(width,height);//创建一个bitmap实例//Bitmap objbitmap=new Bitmap(230,500);//创建一个bitmap实例Graphics objgraphics=Graphics.FromImage(objbitmap);objgraphics.FillRectangle(new SolidBrush(Color.White), 0, 0, width, height);//画一个白色背景objgraphics.FillRectangle(new SolidBrush(Color.LightYellow), pierect);//画一个亮黄色背景//以下为画饼图(有几行row画几个)float currentdegree=0.0f;for (iloop = 0;
iloop < ds.Tables[0].Rows.Count;
iloop++){ objgraphics.FillPie((SolidBrush) colors[iloop], pierect, currentdegree, Convert.ToSingle(ds.Tables[0].Rows[iloop]["point"]) / total * 360);
currentdegree += Convert.ToSingle(ds.Tables[0].Rows[iloop]["point"]) / total * 360;}//---以下为生成主标题SolidBrush blackbrush=new SolidBrush(Color.Black);string title="本次《程序员大本营》推出了配套的专刊，您对专刊满意吗？";StringFormat stringFormat = new StringFormat();stringFormat.Alignment = StringAlignment.Center;stringFormat.LineAlignment = StringAlignment.Center;objgraphics.DrawString(title, fonttitle, blackbrush, new Rectangle(0, 0, width, titleheight), stringFormat);//列出各字段与得票数objgraphics.DrawRectangle(new Pen(Color.Black, 2), 0, height - legendheight, width, legendheight);
for (iloop = 0;
iloop < ds.Tables[0].Rows.Count;
iloop++) { objgraphics.FillRectangle((SolidBrush) colors[iloop], 5, height - legendheight + fontlegend.
Height * iloop + 5, 10, 10);
objgraphics.DrawString(((String) ds.Tables[0].Rows[iloop]["title"]) + " - " + Convert.ToString(ds.Tables[0].Rows[iloop]["point"]), fontlegend, blackbrush, 20, height - legendheight + fontlegend.
Height * iloop + 1);
}//objgraphics.DrawString("总票数是:"+Convert.ToString(total),fontlegend,blackbrush, 5, height - fontlegend.
Height );//图像总的高度-一行字体的高度，即是最底行的一行字体高度(height - fontlegend.
Height )Response.ContentType="image/jpeg";objbitmap.Save(Response.OutputStream,ImageFormat.Jpeg);//objbitmap.Save("myyyyyyyyyyy.jpg", ImageFormat.Jpeg);//输出到文件objgraphics.Dispose();objbitmap.Dispose();
}</script>
