62,046
社区成员
发帖
与我相关
我的任务
分享
sqlText = "select 时分秒,频率B from SaveL where 年月日 like '" + date + "' and 仪器编号=" + cid;
DataTable dt = DBClass.GetDataTable(sqlText, conn);
ArrayList al = new ArrayList();
for (int i = 0; i < dt.Rows.Count; i++)
al.Add(dt.Rows[i]["频率B"].ToString().Trim());
al.Sort();
Chart2.DataSource = dt;//绑定数据
Chart2.Series["Series1"].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Line;//设置图表类型
Chart2.Series[0].XValueMember = "时分秒";//X轴数据成员列
Chart2.Series[0].YValueMembers = "频率B";//Y轴数据成员列
Chart2.ChartAreas["ChartArea1"].AxisX.Title = "时间";//X轴标题
// Chart1.ChartAreas["ChartArea1"].AxisX.TitleAlignment = StringAlignment.Far;//设置Y轴标题的名称所在位置位远
Chart2.ChartAreas["ChartArea1"].AxisY.Title = "频率";//X轴标题11 Chart1.ChartAreas["ChartArea1"].AxisY.TitleAlignment = StringAlignment.Far;//设置Y轴标题的名称所在位置位远
Chart2.ChartAreas["ChartArea1"].AxisX.Interval = 60;//X轴数据的间距
// Chart1.ChartAreas["ChartArea1"].AxisY.Maximum = (double)dt.Compute("max(频率A)", "");
// dt.Select("max(频率A) as maxdata");
Chart2.ChartAreas["ChartArea1"].AxisY.Maximum = Convert.ToDouble(al[al.Count - 1].ToString());
Chart2.ChartAreas["ChartArea1"].AxisY.Minimum = Convert.ToDouble(al[0].ToString());
Chart2.ChartAreas["ChartArea1"].AxisX.MajorGrid.Enabled = false;//不显示竖着的分割线
Series series = new Series("金额", ViewType.Line);
Series series_cost = new Series("成本", ViewType.Line);
SeriesPoint point;
DataTable dt = GetDataSource;
for (int i = 0; i < dt.Rows.Count; i++)
{
point = new SeriesPoint(dt.Rows[i]["week"].ToString(), Convert.ToDouble(dt.Rows[i]["money"].ToString()));
series.Points.Add(point);
point = new SeriesPoint(dt.Rows[i]["week"].ToString(), Convert.ToDouble(dt.Rows[i]["cost"].ToString()));
series_cost.Points.Add(point);
}
this.WebChartControl1.Series.Add(series);
this.WebChartControl1.Series.Add(series_cost);