1         //清空原有图形
 2         LineChart1.Graphs.Clear();
 3         //准备数据
 4         //Response.Write(DropDownList1.SelectedValue + "," + DropDownList1.SelectedItem);
 5         string sql = "SELECT stcd,DATENAME(YEAR,tm)+DATENAME(MONTH,tm) as date,SUM(dyp) as dyp from ST_PPTN_R WHERE stcd='" +
 6             DropDownList1.SelectedValue +
 7             "' GROUP BY stcd,DATENAME(YEAR,tm)+DATENAME(MONTH,tm) ORDER BY stcd,date ";
 8         DataSet dataSet =
 9             SqlHelper.ExecuteDataset(
10                 ConfigurationManager.ConnectionStrings["RWDB"].ConnectionString, CommandType.Text,
11                 sql);
12         //添加数据线对象
13         LineChartGraph lineChartGraph = new LineChartGraph();
14         //顶点形状为正方形
15         lineChartGraph.Bullet = LineChartBulletTypes.Square;
16         //顶点颜色
17         //lineChartGraph.BulletColor = Color.Yellow;
18         //向下面积图的颜色
19         lineChartGraph.FillColor = Color.Yellow;
20         //向下面积图的透明度
21         lineChartGraph.FillAlpha = Convert.ToByte(40);
22         //添加数据
23         //Y轴值在右边(默认在左边)
24         //lineChartGraph.Axis = LineChartAxes.Right;
25         
26         lineChartGraph.DataSource = dataSet;//数据源
27         lineChartGraph.DataSeriesItemIDField = "date";//标识字段
28         lineChartGraph.DataValueField = "dyp";//值字段
29         lineChartGraph.Title = DropDownList1.SelectedItem.Text.Trim();//数据系列标题
30         //添加线条到图形
31         LineChart1.Graphs.Add(lineChartGraph);
32 
33         //添加平均值线条
34         double averagePre = 0;
35         int count = 0;
36         foreach (DataRow dataRow in dataSet.Tables[0].Rows)
37         {
38             if (dataRow["dyp"] != DBNull.Value)
39             {
40                 averagePre += Convert.ToDouble(dataRow["dyp"]);
41                 count++;
42             }
43         }
44         //Response.Write("average=" + averagePre.ToString() + ",count=" + count.ToString());
45         averagePre /= count;
46         averagePre = Math.Round(averagePre, 2);//保留两位小数
47         DataColumn dc_v = new DataColumn("average");//添加平均值的数据列到原dataset里
48         dataSet.Tables[0].Columns.Add(dc_v);
49         for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
50         {
51             dataSet.Tables[0].Rows[i][dc_v] = averagePre;
52         }
53         LineChartGraph lcg = new LineChartGraph();
54         lcg.DataSource = dataSet;
55         lcg.DataSeriesItemIDField = "date";
56         lcg.DataValueField = "average";
57         lcg.Title = "平均值";
58         LineChart1.Graphs.Add(lcg);
59         //添加Y轴单位说明
60         LineChart1.Labels.Add(new ChartLabel("mm",new Unit(30),new Unit(30))); //单位为mm
61         LineChart1.DataSource = dataSet;
62         LineChart1.DataSeriesIDField = "date";
63         LineChart1.DataBind();