4,818
社区成员
发帖
与我相关
我的任务
分享 private void draw01()//houdu1
{
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ToString();
using (OleDbConnection conn = new OleDbConnection(connStr))
{
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter();
string com = "select top 8 [ID],[DateAndTime],[HouDu1] from [No1Gear] order by [ID] desc ";
TextBox4.Attributes.Add("onkeypress", "this.value = this.value.replace(/[^0-9]/g,'')");
string com2 = "select top " + TextBox4.Text.ToString() + " [ID],[DateAndTime],[HouDu1] from [No1Gear] order by [ID] desc";
int num;
if (TextBox4.Text.ToString() == "" || TextBox4.Text.ToString() == "0")
{
da.SelectCommand = new OleDbCommand(com, conn);
num = 0;
}
else
{
da.SelectCommand = new OleDbCommand(com2, conn);
num = Convert.ToInt32(TextBox4.Text.ToString());
}
da.Fill(ds);
Chart1.DataSource = ds;
Chart1.Titles.Clear();
Chart1.Series.Clear();
Chart1.ChartAreas.Clear();
Chart1.Legends.Clear();
string s1 = "1#测点";
Chart1.ChartAreas.Add("1#测点");
Chart1.Series.Add(s1);
Chart1.Series[s1].ChartType = SeriesChartType.Line;
Chart1.Series[s1].Color = Color.Tomato;
if (num > 40)
{
Chart1.Series[s1].IsValueShownAsLabel = false;
Chart1.ChartAreas[s1].AxisX.IntervalOffset = 1;
Chart1.ChartAreas[s1].AxisX.Interval = 10;
}
else if (num >= 20 && num <= 40)
{
Chart1.Series[s1].IsValueShownAsLabel = false;
Chart1.ChartAreas[s1].AxisX.IntervalOffset = 1;
Chart1.ChartAreas[s1].AxisX.Interval = 5;
}
else if (num < 20 && num > 8)
{
Chart1.Series[s1].IsValueShownAsLabel = true;
Chart1.ChartAreas[s1].AxisX.IntervalOffset = 1;
Chart1.ChartAreas[s1].AxisX.Interval = 2;
}
else if (num <= 8)
{
Chart1.Series[s1].IsValueShownAsLabel = true;
Chart1.ChartAreas[s1].AxisX.IntervalOffset = 1;
Chart1.ChartAreas[s1].AxisX.Interval = 2;
}
Chart1.Series[s1].BorderWidth = 2;
foreach (DataRow row in ds.Tables[0].Rows)
{
string colName = ds.Tables[0].Columns[1].ColumnName;
string date = row[colName].ToString();
string tmp = ds.Tables[0].Columns[2].ColumnName;
string test = row[tmp].ToString();
Chart1.Series[s1].Points.AddXY(date, test);
}
ds.Clear();
}
}
这是我以前写的一个折现图 你感受一下 涨涨姿势