Steema Central

Code: Select all

using System;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using Steema.TeeChart;
using Steema.TeeChart.Web;
using Steema.TeeChart.Tools;

namespace Lilly.B130BatchTools
{
	/// <summary>
	/// Summary description for WebForm1.
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected Steema.TeeChart.Web.WebChart webChart;
		private int m_maxCount = 0;
		private const string dbPath = @"c:\inetpub\wwwroot\db1.mdb";
		private const string filePath = @"c:\inetpub\wwwroot\labels.txt";
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			Steema.TeeChart.Styles.Line lineValue = null;
			Steema.TeeChart.Chart trendChart = null;
			Axis multiAxes = null;

			if (File.Exists(filePath))
			{
				File.Delete(filePath);
			}
			webChart.Clear();
			trendChart = webChart.Chart;
			trendChart.Legend.Alignment = 
				Steema.TeeChart.LegendAlignments.Top;

			trendChart.Axes.Bottom.Title.Text = "Time";
			trendChart.Axes.Bottom.Title.Font.Color = Color.DarkGray;
			trendChart.Axes.Bottom.Labels.Angle = 90;
			trendChart.Axes.Bottom.Increment = 
				(double)Steema.TeeChart.DateTimeSteps.OneSecond;
			trendChart.Axes.Bottom.Labels.Separation = 0;

			trendChart.Axes.Left.Title.Text = "Point Values";
			trendChart.Axes.Left.Title.Font.Color = Color.DarkGray;
				
			trendChart.Aspect.View3D = false;
			trendChart.Walls.Visible = false;
			webChart.Chart.Series.RemoveAllSeries();

			string query = "SELECT PointValue, TimeValue FROM Point{0}";
			OleDbConnection cn = new OleDbConnection(
				"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbPath);
			cn.Open();
			DataSet dataSet = null;
			OleDbDataAdapter da = null;
			DataTable table = null;
			m_maxCount = 0;
				
			for (int i = 1; i < 3; i++)
			{
				query = String.Format(query, i.ToString());
				da = new OleDbDataAdapter(query, cn);
				dataSet = new DataSet();
				da.Fill(dataSet);
				table = dataSet.Tables[0];

				if (table.Rows.Count > m_maxCount)
				{
					m_maxCount = table.Rows.Count;
				}

				lineValue = new Steema.TeeChart.Styles.Line();
				lineValue.Title = "Point" + i.ToString();
				lineValue.YValues.DataMember = 
					table.Columns["PointValue"].ToString();
				lineValue.XValues.DateTime = true;
				lineValue.LabelMember = table.Columns["TimeValue"].ToString();
				lineValue.XValues.DataMember = 
					table.Columns["TimeValue"].ToString();
				lineValue.DataSource = table;
				trendChart.Series.Add(lineValue);
				
				if (i == 1)
				{
					trendChart.Axes.Left.AxisPen.Color = 
						lineValue.Color;
				}
				else
				{
					multiAxes = new Axis(
						false, false, webChart.Chart);
					multiAxes.AxisPen.Color = lineValue.Color;
					multiAxes.PositionUnits = PositionUnits.Percent;
					multiAxes.RelativePosition = 6 * (i-1);
					webChart.Chart.Axes.Custom.Add(multiAxes);
					lineValue.CustomVertAxis = multiAxes;
				}
			}

			cn.Close();
			Steema.TeeChart.Themes.ColorPalettes.ApplyPalette(
				trendChart.Chart,7);
			webChart.Chart.Legend.LegendStyle = 
				Steema.TeeChart.LegendStyles.Series;	
			webChart.Chart.Header.Visible = false;
			webChart.Visible = true;
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.webChart.GetAxisLabel += new Steema.TeeChart.GetAxisLabelEventHandler(this.webChart_GetAxisLabel);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void webChart_GetAxisLabel(object sender, Steema.TeeChart.GetAxisLabelEventArgs e)
		{
			if(((Steema.TeeChart.Axis)sender).Equals(webChart.Chart.Axes.Bottom))
			{
				StreamWriter sw = File.AppendText(filePath);
				sw.WriteLine(e.LabelText);
				sw.Close();
				if (e.ValueIndex > 0 && e.ValueIndex < (m_maxCount - 1))
				{
					e.LabelText = "";
				}
			}
		}
	}
}

Code: Select all

		public Form1()
		{
			InitializeComponent();
			InitializeChart();
		}

		private void InitializeChart()
		{
			int length = 60;
			DateTime now = DateTime.Now;
			Random rnd = new Random();

			for (int i = 0; i < length; i++)
			{
				line1.Add(now, rnd.NextDouble());
				now = now.AddMinutes(1);
			}

			tChart1.Aspect.View3D = false;
		}

		private bool first = true;
		private DateTime newDate;

		private void tChart1_GetNextAxisLabel(object sender, Steema.TeeChart.GetNextAxisLabelEventArgs e)
		{
			if ((sender as Steema.TeeChart.Axis).Equals(tChart1.Axes.Bottom))
			{
				e.Stop = false;

				if (first)
				{
					double value = e.LabelValue;
					DateTime date = DateTime.FromOADate(value);
					newDate = new DateTime(date.Year, date.Month, date.Day, date.Hour, 0, 0);
					if (date.Minute >= 15)
					{
						newDate = newDate.AddMinutes(15);
					}
					else if (date.Minute >= 30)
					{
						newDate = newDate.AddMinutes(30);
					}
					else if (date.Minute >= 45)
					{
						newDate = newDate.AddMinutes(45);
					}
					first = false;
				}
				else
				{
					newDate = newDate.AddMinutes(15);
				}
		
				switch (e.LabelIndex)
				{
					case 0:
						//e.LabelValue = newDate.ToOADate();
						e.LabelValue = tChart1.Axes.Bottom.CalcPosPoint(tChart1.Axes.Left.Position);
						break;
					case 1:
						e.LabelValue = newDate.ToOADate();
						break;
					case 2:
						e.LabelValue = newDate.ToOADate();
						break;
					case 3:
						e.LabelValue = newDate.ToOADate();
						break;
					case 4:
						e.LabelValue = newDate.ToOADate();
						break;
					case 5:
						e.LabelValue = newDate.ToOADate();
						break;
					case 6:
						//e.LabelValue = newDate.ToOADate();
						e.LabelValue = tChart1.Axes.Bottom.CalcPosPoint(tChart1.Axes.Bottom.IEndPos);
						break;
					default:
						e.Stop = true;
						first = true;
						break;
				}
			} 
		}