4,815
社区成员




SqlDataReader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
string date = myReader["dtJCSJ"].ToString();
string x = date.Substring(7, 2);
y = Convert.ToInt32(myReader["iYLZ"]);
//为每个图表绘点
chart1.Series[(string.Format("Series" + (i + 1).ToString()))].Points.AddXY(x, y); //增加数据点
chart1.ChartAreas[(string.Format("ChartArea" + (i + 1).ToString()))].AxisX.Title = "钻孔号:" + myReader["vZKName"].ToString() + "\n监测区:" + myReader["vJCQM"].ToString();//设置图表对应的钻孔号
}
myReader.Close();
int y = 0;
try
{
string sql = string.Format("select * from tab_ZKSC inner join tab_YLJC on tab_ZKSC.vZKID=tab_YLJC.iListZKID inner join tab_JCQM on tab_YLJC.vJCQMID=tab_JCQM.vJCQMID where tab_ZKSC.vZKName='{0}'", UserHelper.vZKID);
SqlCommand myCommand = new SqlCommand(sql, DBHelper.connection);
DBHelper.connection.Open();
SqlDataReader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
string date = myReader["dtJCSJ"].ToString();
string x = date.Substring(7, 2);
y = Convert.ToInt32(myReader["iYLZ"]);
//为图表绘点
chart1.Series["Series1"].Points.AddXY(x, y); //增加数据点
chart1.ChartAreas["ChartArea1"].AxisX.Title = "\n监测区:" + myReader["vJCQM"].ToString() + "\t\t\t钻孔号:" + myReader["vZKName"].ToString();//设置图表对应的钻孔号
//chart1.ChartAreas["ChartArea1"].AxisX.TitleFont=Font.("宋体",12);
}
chart1.Series["Series1"].ChartType = SeriesChartType.Spline;
chart1.Series["Series1"].Color = System.Drawing.Color.Red;
chart1.Series["Series1"].MarkerColor = System.Drawing.Color.Red;
chart1.Series["Series1"].MarkerSize = 5;
chart1.Series["Series1"].MarkerStyle = MarkerStyle.Circle;
chart1.ChartAreas["ChartArea1"].AxisY.Interval = 5;
myReader.Close();
double y = 0;
while (myReader.Read())
{
string date = myReader["dtJCSJ"].ToString();
string x = date.Substring(8, 2);
y = Convert.ToDouble(myReader["iYLZ"]);
Chart1.Series["Series1"].Points.AddXY(x, y);
}
//外观设置
Chart1.Series["Series1"].ChartType = SeriesChartType.Spline;
Chart1.Series["Series1"].Color = System.Drawing.Color.Red;
Chart1.Series["Series1"].MarkerColor = System.Drawing.Color.Red;
Chart1.Series["Series1"].MarkerSize = 5;
Chart1.Series["Series1"].MarkerStyle = MarkerStyle.Circle;
Chart1.ChartAreas["ChartArea1"].AxisY.Interval = 5;