namespaceZedGraphDemo
{publicpartialclassYear : System.Web.UI.Page
{protectedvoidPage_Load(objectsender, EventArgs e)
{this.ZgwYear.RenderGraph+=newZedGraphWebControlEventHandler(ZgwYear_RenderGraph);
}voidZgwYear_RenderGraph(ZedGraphWeb webObject, System.Drawing.Graphics g, MasterPane pane)
{
GraphPane myPane=pane[0];//标题myPane.Title.Text="每年分析(月为单位)";
myPane.XAxis.Title.Text="时间";
myPane.YAxis.Title.Text="访问量";//坐标对集PointPairList list=newPointPairList();//PointPairList list1 = new PointPairList();//PointPairList list2 = new PointPairList();//从数据库中获取数据集DataTable dtYear=GetData();if(dtYear==null)return;for(inti=0; i
{
list.Add(Convert.ToDouble(i), Convert.ToDouble(dtYear.Rows[i]["Count"]));//如果有多种类型,可以添加多个//list1.Add(Convert.ToDouble(i), Convert.ToDouble(dtYear.Rows[i]["Count1"]));//list2.Add(Convert.ToDouble(i), Convert.ToDouble(dtYear.Rows[i]["Count2"]));}
BarItem myBar=myPane.AddBar("页面访问", list, Color.Blue);//BarItem myBar1 = myPane.AddBar("", list1, Color.Red);//BarItem myBar2 = myPane.AddBar("", list2, Color.Yellow);myBar.Bar.Fill=newFill(Color.Blue, Color.White, Color.Blue);//myBar1.Bar.Fill = new Fill(Color.Red, Color.White, Color.Red);//myBar2.Bar.Fill = new Fill(Color.Yellow, Color.White, Color.Yellow);myPane.XAxis.MajorTic.IsBetweenLabels=true;//X轴Labelstring[] labels=newstring[] {"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"};//设置x轴刻度myPane.XAxis.Scale.TextLabels=labels;
myPane.XAxis.Type=AxisType.Text;//颜色填充myPane.Fill=newFill(Color.White, Color.FromArgb(200,200,255),45.0f);
myPane.Chart.Fill=newFill(Color.White, Color.LightGoldenrodYellow,45.0f);
pane.AxisChange(g);
myPane.YAxis.Scale.Max+=myPane.YAxis.Scale.MajorStep;
BarItem.CreateBarLabels(myPane,false,"f0");//在柱状图上方显示统计数}protectedvoidbtnQuerys_Click(objectsender, EventArgs e)
{
GetData();
}privateDataTable GetData()
{
SqlHelper.ConnectionString=ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlParameter[] parameters=newSqlParameter[1];
parameters[0]=newSqlParameter("@Year", SqlDbType.Int,4);
parameters[0].Value=this.txtYear.Value.Trim().Length==0?DateTime.Now.Year :
Convert.ToInt32(txtYear.Value.Trim());
DataSet ds=SqlHelper.ExecuteDataset("Counter_CounterYear", parameters);if(ds!=null&&ds.Tables.Count>0&&ds.Tables[0].Rows.Count>0)
{returnds.Tables[0];
}else{returnnull;
}
}
}
}