private void CreateChartBar(ChartControl arg_chart, DataTable arg_dt, string arg_name)
{
// Create a new chart.
arg_chart.Series.Clear();
arg_chart.Titles.Clear();
// ((XYDiagram)arg_chart.Diagram).AxisX.CustomLabels.Clear();
//DataSource
string Now = DateTime.Now.ToString("yyyyMMdd");
// Create two series.
//Series series1 = new Series("Production Qty", ViewType.Bar);
Series series2 = new Series("POD", ViewType.Bar);
// DevExpress.XtraCharts.SplineSeriesView splineSeriesView1 = new DevExpress.XtraCharts.SplineSeriesView();
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
DevExpress.XtraCharts.PointSeriesLabel pointSeriesLabel1 = new DevExpress.XtraCharts.PointSeriesLabel();
//DevExpress.XtraCharts.BarWidenAnimation barWidenAnimation1 = new DevExpress.XtraCharts.BarWidenAnimation();
//DevExpress.XtraCharts.ElasticEasingFunction elasticEasingFunction1 = new DevExpress.XtraCharts.ElasticEasingFunction();
// DevExpress.XtraCharts.XYSeriesBlowUpAnimation xySeriesBlowUpAnimation1 = new DevExpress.XtraCharts.XYSeriesBlowUpAnimation();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesUnwindAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
// DevExpress.XtraCharts.XYSeriesUnwrapAnimation xySeriesUnwrapAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwrapAnimation();
DevExpress.XtraCharts.PowerEasingFunction powerEasingFunction1 = new DevExpress.XtraCharts.PowerEasingFunction();
DevExpress.XtraCharts.SineEasingFunction sineEasingFunction1 = new DevExpress.XtraCharts.SineEasingFunction();
DevExpress.XtraCharts.ConstantLine constantLine1 = new DevExpress.XtraCharts.ConstantLine();
// Add points to them, with their arguments different.
for (int i = 0; i < arg_dt.Rows.Count; i++)
{
//series1.Points.Add(new SeriesPoint(dt.Rows[i]["HMS"].ToString(), dt.Rows[i]["QTY"])); //GetRandomNumber(10, 50)
series2.Points.Add(new SeriesPoint(arg_dt.Rows[i]["LB"].ToString().Replace("_", "\n"),
arg_dt.Rows[i]["POD"] == null || arg_dt.Rows[i]["POD"].ToString() == "" ? 0 : arg_dt.Rows[i]["POD"]));
if ((arg_dt.Rows[i]["POD"] == null || arg_dt.Rows[i]["POD"].ToString() == "" ? 0 : Convert.ToDouble(arg_dt.Rows[i]["POD"])) > Convert.ToDouble(arg_dt.Rows[0]["TARGET"]))
{
series2.Points[i].Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(176)))), ((int)(((byte)(240)))));
}
else
{
series2.Points[i].Color = Color.Red;
}
}
(series2.Label as SideBySideBarSeriesLabel).Position = DevExpress.XtraCharts.BarSeriesLabelPosition.Top;
// series2 = splineSeriesView1;
// Add both series to the chart.
//chartControl1.Series.AddRange(new Series[] { series1, series2 });
arg_chart.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series2 };
((XYDiagram)arg_chart.Diagram).AxisY.Title.Text = "POD";
((XYDiagram)arg_chart.Diagram).AxisY.Title.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(176)))), ((int)(((byte)(240)))));
((XYDiagram)arg_chart.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)arg_chart.Diagram).AxisX.Title.Text = "Date";
((XYDiagram)arg_chart.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)arg_chart.Diagram).AxisX.Title.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(176)))), ((int)(((byte)(240)))));
((XYDiagram)arg_chart.Diagram).AxisX.Tickmarks.MinorVisible = true;
sideBySideBarSeriesView1.ColorEach = false;
series2.View = sideBySideBarSeriesView1;
//title
DevExpress.XtraCharts.ChartTitle chartTitle2 = new DevExpress.XtraCharts.ChartTitle();
chartTitle2.Alignment = System.Drawing.StringAlignment.Near;
chartTitle2.Font = new System.Drawing.Font("Tahoma", 24F, System.Drawing.FontStyle.Bold);
chartTitle2.Text = arg_name;
chartTitle2.TextColor = System.Drawing.Color.Blue;
arg_chart.Titles.AddRange(new DevExpress.XtraCharts.ChartTitle[] { chartTitle2 });
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
xySeriesUnwindAnimation1.EasingFunction = sineEasingFunction1; //powerEasingFunction1;
//splineSeriesView1.SeriesAnimation = xySeriesUnwindAnimation1;//xySeriesBlowUpAnimation1;//xySeriesUnwindAnimation1; // xySeriesUnwrapAnimation1;
arg_chart.Legend.Direction = LegendDirection.LeftToRight;
//Constant line
//constantLine1.ShowInLegend = false;
constantLine1.AxisValueSerializable = arg_dt.Rows[0]["TARGET"].ToString();
constantLine1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(176)))), ((int)(((byte)(80)))));
constantLine1.Name = "Target";
constantLine1.ShowBehind = false;
constantLine1.Title.Visible = false;
//constantLine1.Title.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//constantLine1.Title.Text = "Target";
constantLine1.LineStyle.Thickness = 2;
constantLine1.Title.Alignment = DevExpress.XtraCharts.ConstantLineTitleAlignment.Far;
((XYDiagram)arg_chart.Diagram).AxisY.ConstantLines.Clear();
((XYDiagram)arg_chart.Diagram).AxisY.ConstantLines.AddRange(new DevExpress.XtraCharts.ConstantLine[] { constantLine1 });
//((XYDiagram)arg_chart.Diagram).AxisX.NumericScaleOptions.AutoGrid = false;
//((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.Auto = false;
//((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.AutoSideMargins = false;
//((XYDiagram)arg_chart.Diagram).AxisX.Label.Angle = 90;
//((XYDiagram)arg_chart.Diagram).AxisX.Label.ResolveOverlappingOptions.AllowHide = false;
//((XYDiagram)arg_chart.Diagram).AxisX.Label.ResolveOverlappingOptions.AllowStagger = true;
((XYDiagram)arg_chart.Diagram).AxisX.Tickmarks.MinorVisible = false;
((XYDiagram)arg_chart.Diagram).AxisX.GridLines.Visible = false;
((XYDiagram)arg_chart.Diagram).AxisX.Label.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold);
//((XYDiagram)arg_chart.Diagram).AxisY.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Continuous;
//((XYDiagram)_chartControl1.Diagram).AxisY.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Automatic;
//((XYDiagram)arg_chart.Diagram).AxisX.
((XYDiagram)arg_chart.Diagram).AxisY.Label.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold);
((XYDiagram)arg_chart.Diagram).AxisX.Title.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)arg_chart.Diagram).AxisY.Title.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
pn_body.Controls.Add(arg_chart);
}
private void CreateChartLine(ChartControl arg_chart, DataTable arg_dt, string arg_name)
{
if (arg_dt == null || arg_dt.Rows.Count == 0)
{
return;
}
arg_chart.Series.Clear();
arg_chart.Titles.Clear();
//----------create--------------------
Series series2 = new Series("POD", ViewType.Spline);
DevExpress.XtraCharts.SplineSeriesView splineSeriesView1 = new DevExpress.XtraCharts.SplineSeriesView();
//DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
//DevExpress.XtraCharts.PointSeriesLabel pointSeriesLabel1 = new DevExpress.XtraCharts.PointSeriesLabel();
//DevExpress.XtraCharts.BarWidenAnimation barWidenAnimation1 = new DevExpress.XtraCharts.BarWidenAnimation();
//DevExpress.XtraCharts.ElasticEasingFunction elasticEasingFunction1 = new DevExpress.XtraCharts.ElasticEasingFunction();
//DevExpress.XtraCharts.XYSeriesBlowUpAnimation xySeriesBlowUpAnimation1 = new DevExpress.XtraCharts.XYSeriesBlowUpAnimation();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesUnwindAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
//DevExpress.XtraCharts.XYSeriesUnwrapAnimation xySeriesUnwrapAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwrapAnimation();
//DevExpress.XtraCharts.PowerEasingFunction powerEasingFunction1 = new DevExpress.XtraCharts.PowerEasingFunction();
DevExpress.XtraCharts.SineEasingFunction sineEasingFunction1 = new DevExpress.XtraCharts.SineEasingFunction();
DevExpress.XtraCharts.ConstantLine constantLine1 = new DevExpress.XtraCharts.ConstantLine();
//--------- Add data Point------------
for (int i = 0; i < arg_dt.Rows.Count; i++)
{
if (arg_dt.Rows[i]["POD"] == null || arg_dt.Rows[i]["POD"].ToString() == "")
{
series2.Points.Add(new SeriesPoint(arg_dt.Rows[i]["LB"].ToString().Replace("_", "\n")));
}
else
{
series2.Points.Add(new SeriesPoint(arg_dt.Rows[i]["LB"].ToString().Replace("_", "\n"), arg_dt.Rows[i]["POD"]));
}
}
arg_chart.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series2 };
//title
DevExpress.XtraCharts.ChartTitle chartTitle2 = new DevExpress.XtraCharts.ChartTitle();
chartTitle2.Alignment = System.Drawing.StringAlignment.Near;
chartTitle2.Font = new System.Drawing.Font("Calibri", 24F, System.Drawing.FontStyle.Bold);
chartTitle2.Text = arg_name;
chartTitle2.TextColor = System.Drawing.Color.Black;
arg_chart.Titles.AddRange(new DevExpress.XtraCharts.ChartTitle[] { chartTitle2 });
// format Series
splineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
splineSeriesView1.Color = System.Drawing.Color.DodgerBlue;
splineSeriesView1.LineMarkerOptions.BorderColor = System.Drawing.Color.DodgerBlue;
splineSeriesView1.LineMarkerOptions.BorderVisible = false;
splineSeriesView1.LineMarkerOptions.Kind = DevExpress.XtraCharts.MarkerKind.Circle;
splineSeriesView1.LineMarkerOptions.Color = System.Drawing.Color.DodgerBlue;
splineSeriesView1.LineMarkerOptions.Size = 10;
splineSeriesView1.LineStyle.Thickness = 3;
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.Label.ResolveOverlappingMode = ResolveOverlappingMode.JustifyAllAroundPoint;
//series2.Label.TextPattern = "{V:#,0}";
series2.View = splineSeriesView1;
xySeriesUnwindAnimation1.EasingFunction = sineEasingFunction1;
splineSeriesView1.SeriesAnimation = xySeriesUnwindAnimation1;
arg_chart.Legend.Direction = LegendDirection.LeftToRight;
//Constant line
//constantLine1.ShowInLegend = false;
constantLine1.AxisValueSerializable = arg_dt.Rows[0]["TARGET"].ToString();
constantLine1.Color = System.Drawing.Color.Green;
constantLine1.Name = "Target";
// constantLine1.ShowBehind = false;
constantLine1.Title.Visible = false;
constantLine1.Title.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//constantLine1.Title.Text = "Target";
constantLine1.LineStyle.Thickness = 2;
// constantLine1.Title.Alignment = DevExpress.XtraCharts.ConstantLineTitleAlignment.Far;
((XYDiagram)arg_chart.Diagram).AxisY.ConstantLines.Clear();
((XYDiagram)arg_chart.Diagram).AxisY.ConstantLines.AddRange(new DevExpress.XtraCharts.ConstantLine[] { constantLine1 });
//((XYDiagram)arg_chart.Diagram).AxisX.Tickmarks.MinorVisible = false;
((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.Auto = false;
((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.AutoSideMargins = false;
((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.SideMarginsValue = 2;
((XYDiagram)arg_chart.Diagram).AxisX.Label.Angle = 0;
((XYDiagram)arg_chart.Diagram).AxisX.Label.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold);
((XYDiagram)arg_chart.Diagram).AxisX.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Continuous;
((XYDiagram)arg_chart.Diagram).AxisY.Label.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold);
((XYDiagram)arg_chart.Diagram).AxisX.Title.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)arg_chart.Diagram).AxisY.Title.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//--------Text AxisX/ AxisY
((XYDiagram)arg_chart.Diagram).AxisY.Title.Text = "POD";
((XYDiagram)arg_chart.Diagram).AxisY.Title.TextColor = System.Drawing.Color.Orange;
((XYDiagram)arg_chart.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)arg_chart.Diagram).AxisX.Title.Text = "Date";
((XYDiagram)arg_chart.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)arg_chart.Diagram).AxisX.Title.TextColor = System.Drawing.Color.Orange;
//---------------add chart in panel
pn_body.Controls.Add(arg_chart);
}
private void CreateChartBar(ChartControl arg_chart, DataTable arg_dt, string arg_name)
{
if (arg_dt == null || arg_dt.Rows.Count == 0)
{
return;
}
arg_chart.Series.Clear();
arg_chart.Titles.Clear();
arg_chart.Legend.CustomItems.Clear();
Series series2 = new Series("POD", ViewType.Bar);
//DevExpress.XtraCharts.XYSeriesBlowUpAnimation xySeriesBlowUpAnimation1 = new DevExpress.XtraCharts.XYSeriesBlowUpAnimation();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesUnwindAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
//DevExpress.XtraCharts.XYSeriesUnwrapAnimation xySeriesUnwrapAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwrapAnimation();
//DevExpress.XtraCharts.PowerEasingFunction powerEasingFunction1 = new DevExpress.XtraCharts.PowerEasingFunction();
DevExpress.XtraCharts.SineEasingFunction sineEasingFunction1 = new DevExpress.XtraCharts.SineEasingFunction();
DevExpress.XtraCharts.ConstantLine constantLine1 = new DevExpress.XtraCharts.ConstantLine();
DevExpress.XtraCharts.CustomLegendItem customLegendItem1 = new DevExpress.XtraCharts.CustomLegendItem();
DevExpress.XtraCharts.CustomLegendItem customLegendItem2 = new DevExpress.XtraCharts.CustomLegendItem();
DevExpress.XtraCharts.CustomLegendItem customLegendItem3 = new DevExpress.XtraCharts.CustomLegendItem();
DevExpress.XtraCharts.CustomLegendItem customLegendItem4 = new DevExpress.XtraCharts.CustomLegendItem();
// Add points to them, with their arguments different.
for (int i = 0; i < arg_dt.Rows.Count; i++)
{
//series1.Points.Add(new SeriesPoint(dt.Rows[i]["HMS"].ToString(), dt.Rows[i]["QTY"])); //GetRandomNumber(10, 50)
series2.Points.Add(new SeriesPoint(arg_dt.Rows[i]["DD"].ToString() + "\n" + arg_dt.Rows[i]["DY"].ToString(),
arg_dt.Rows[i]["POD"] == null || arg_dt.Rows[i]["POD"].ToString() == "" ? 0 : arg_dt.Rows[i]["POD"]));
if (arg_dt.Rows[i]["POD"] != null && arg_dt.Rows[i]["POD"].ToString() != "")
{
series2.Points[i].Color = Color.FromName(arg_dt.Rows[i]["COLOR"].ToString());
}
else
{
series2.Points[i].Color = Color.Empty;
}
}
series2.Points.Add(new SeriesPoint(" "));
arg_chart.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series2 };
((XYDiagram)arg_chart.Diagram).AxisY.Title.Text = "POD";
((XYDiagram)arg_chart.Diagram).AxisY.Title.TextColor = System.Drawing.Color.Orange;
((XYDiagram)arg_chart.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)arg_chart.Diagram).AxisX.Title.Text = "Date";
((XYDiagram)arg_chart.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)arg_chart.Diagram).AxisX.Title.TextColor = System.Drawing.Color.Orange;
((XYDiagram)arg_chart.Diagram).AxisX.Tickmarks.MinorVisible = false;
//title
DevExpress.XtraCharts.ChartTitle chartTitle2 = new DevExpress.XtraCharts.ChartTitle();
chartTitle2.Alignment = System.Drawing.StringAlignment.Near;
chartTitle2.Font = new System.Drawing.Font("Tahoma", 24F, System.Drawing.FontStyle.Bold);
chartTitle2.Text = arg_name;
chartTitle2.TextColor = System.Drawing.Color.Black;
arg_chart.Titles.AddRange(new DevExpress.XtraCharts.ChartTitle[] { chartTitle2 });
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
//series2.Label.ResolveOverlappingMode = ResolveOverlappingMode.JustifyAllAroundPoint;
xySeriesUnwindAnimation1.EasingFunction = sineEasingFunction1; //powerEasingFunction1;
//arg_chart.Legend.CustomItems.AddRange(new DevExpress.XtraCharts.CustomLegendItem[] {
//customLegendItem1,
//customLegendItem2,
//customLegendItem3});
// arg_chart.Legend.CustomItems[0].Text = "<8.0";
series2.ShowInLegend = false;
arg_chart.Legend.Direction = LegendDirection.LeftToRight;
//Constant line
//constantLine1.ShowInLegend = false;
constantLine1.AxisValueSerializable = arg_dt.Rows[0]["TAR_GREEN"].ToString();
constantLine1.Color = Color.DodgerBlue;
constantLine1.Name = "Target";
constantLine1.ShowBehind = false;
constantLine1.Title.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
constantLine1.Title.Text = arg_dt.Rows[0]["TAR_GREEN"].ToString();
constantLine1.Title.Visible = true;
constantLine1.LineStyle.Thickness = 2;
constantLine1.Title.Alignment = DevExpress.XtraCharts.ConstantLineTitleAlignment.Far;
//Legend
customLegendItem1.MarkerColor = System.Drawing.Color.Red;
customLegendItem1.Text = "<" + arg_dt.Rows[0]["TAR_YELLOW"].ToString();
customLegendItem2.MarkerColor = System.Drawing.Color.Yellow;
customLegendItem2.Text = arg_dt.Rows[0]["TAR_YELLOW"].ToString() + " ~ " + arg_dt.Rows[0]["TAR_GREEN"].ToString();
customLegendItem3.MarkerColor = System.Drawing.Color.Green;
customLegendItem3.Text = ">" + arg_dt.Rows[0]["TAR_GREEN"].ToString();
customLegendItem4.MarkerColor = System.Drawing.Color.DodgerBlue;
customLegendItem4.Text = "Target";
arg_chart.Legend.CustomItems.AddRange(new DevExpress.XtraCharts.CustomLegendItem[] {
customLegendItem1,
customLegendItem2,
customLegendItem3,
customLegendItem4
});
//((XYDiagram)arg_chart.Diagram).AxisY.WholeRange.MinValue = 0;
//((XYDiagram)arg_chart.Diagram).AxisY.WholeRange.MaxValue = arg_dt.Rows[0]["TARGET"].ToString() + 10;
((XYDiagram)arg_chart.Diagram).AxisY.ConstantLines.Clear();
((XYDiagram)arg_chart.Diagram).AxisY.ConstantLines.AddRange(new DevExpress.XtraCharts.ConstantLine[] { constantLine1 });
// ((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.Auto = true;
((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.AutoSideMargins = false;
((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.SideMarginsValue = 2;
((XYDiagram)arg_chart.Diagram).AxisX.Label.Angle = 0;
((XYDiagram)arg_chart.Diagram).AxisX.Label.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold);
((XYDiagram)arg_chart.Diagram).AxisX.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Continuous;
//((XYDiagram)_chartControl1.Diagram).AxisY.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Automatic;
((XYDiagram)arg_chart.Diagram).AxisY.Label.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold);
((XYDiagram)arg_chart.Diagram).AxisX.Title.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)arg_chart.Diagram).AxisY.Title.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
pn_body.Controls.Add(arg_chart);
}
private void CreateChart(string line_cd, string mline_cd, string op_cd, DevExpress.XtraCharts.ChartControl _chartControl, string _title)
{
// Create a new chart.
_chartControl.Series.Clear();
//DataSource
DataTable dt = SP_MGL_PRODUCTION_DATA_SELECT("Q2", line_cd, mline_cd);
string Now = DateTime.Now.ToString("yyyyMMdd");
// Create two series.
Series series1 = new Series("Target Qty", ViewType.Line);
Series series2 = new Series("Prod. Qty", ViewType.Spline);
DevExpress.XtraCharts.SplineSeriesView splineSeriesView1 = new DevExpress.XtraCharts.SplineSeriesView();
DevExpress.XtraCharts.SplineSeriesView splineSeriesView2 = new DevExpress.XtraCharts.SplineSeriesView();
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
DevExpress.XtraCharts.PointSeriesLabel pointSeriesLabel1 = new DevExpress.XtraCharts.PointSeriesLabel();
DevExpress.XtraCharts.BarWidenAnimation barWidenAnimation1 = new DevExpress.XtraCharts.BarWidenAnimation();
DevExpress.XtraCharts.ElasticEasingFunction elasticEasingFunction1 = new DevExpress.XtraCharts.ElasticEasingFunction();
DevExpress.XtraCharts.XYSeriesBlowUpAnimation xySeriesBlowUpAnimation2 = new DevExpress.XtraCharts.XYSeriesBlowUpAnimation();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesUnwindAnimation2 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
DevExpress.XtraCharts.XYSeriesUnwrapAnimation xySeriesUnwrapAnimation2 = new DevExpress.XtraCharts.XYSeriesUnwrapAnimation();
DevExpress.XtraCharts.PowerEasingFunction powerEasingFunction2 = new DevExpress.XtraCharts.PowerEasingFunction();
DevExpress.XtraCharts.SineEasingFunction sineEasingFunction2 = new DevExpress.XtraCharts.SineEasingFunction();
// Add points to them, with their arguments different.
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
series1.Points.Add(new SeriesPoint(dt.Rows[i]["HMS"].ToString(), dt.Rows[i]["TARGET"])); //GetRandomNumber(10, 50)
series2.Points.Add(new SeriesPoint(dt.Rows[i]["HMS"].ToString(), dt.Rows[i]["QTY"])); //dt.Rows[i]["HMS"]
}
//_chartControl1.Series[0].ArgumentScaleType = ScaleType.Qualitative;
}
else
{
for (int i = 1; i < 9; i++)
{
//series1.Points.Add(new SeriesPoint(dt.Rows[i]["HMS"].ToString(), dt.Rows[i]["QTY"])); //GetRandomNumber(10, 50)
series1.Points.Add(new SeriesPoint(i + "H", 0));
series2.Points.Add(new SeriesPoint(i + "H", 0)); //dt.Rows[i]["HMS"]
}
}
_chartControl.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1, series2 };
((XYDiagram)_chartControl.Diagram).AxisY.Title.Text = "Product Qty (Prs)";
((XYDiagram)_chartControl.Diagram).AxisY.Label.TextPattern = "{V:#,#}";
((XYDiagram)_chartControl.Diagram).AxisY.Title.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(176)))), ((int)(((byte)(240)))));
((XYDiagram)_chartControl.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)_chartControl.Diagram).AxisX.Title.Text = "Hour";
((XYDiagram)_chartControl.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)_chartControl.Diagram).AxisX.Title.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(176)))), ((int)(((byte)(240)))));
_chartControl.Titles[0].Text = _title;
splineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
splineSeriesView1.Shadow.Visible = false;
splineSeriesView1.Color = System.Drawing.Color.Green;
splineSeriesView1.LineMarkerOptions.BorderColor = System.Drawing.Color.DodgerBlue;
splineSeriesView1.LineMarkerOptions.BorderVisible = false;
splineSeriesView2.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
splineSeriesView2.Shadow.Visible = false;
splineSeriesView2.Color = System.Drawing.Color.DodgerBlue;
splineSeriesView2.LineMarkerOptions.BorderColor = System.Drawing.Color.DodgerBlue;
splineSeriesView2.LineMarkerOptions.BorderVisible = false;
//splineSeriesView1.LineMarkerOptions.Color = System.Drawing.Color.Red;
splineSeriesView2.LineMarkerOptions.Kind = DevExpress.XtraCharts.MarkerKind.Circle;
splineSeriesView2.LineMarkerOptions.Color = System.Drawing.Color.DodgerBlue;
splineSeriesView2.LineMarkerOptions.Size = 15;
splineSeriesView2.LineStyle.Thickness = 3;
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
//pointSeriesLabel1.TextPattern = "{V:#,#}";
series1.View = splineSeriesView1;
series2.Label.TextPattern = "{V:#,#}";
series2.View = splineSeriesView2;
xySeriesUnwindAnimation2.EasingFunction = sineEasingFunction2; //powerEasingFunction1;
splineSeriesView2.SeriesAnimation = xySeriesUnwindAnimation2; //xySeriesBlowUpAnimation1;//xySeriesUnwindAnimation1; // xySeriesUnwrapAnimation1;
((XYDiagram)_chartControl.Diagram).AxisX.VisualRange.Auto = true;
((XYDiagram)_chartControl.Diagram).AxisX.VisualRange.AutoSideMargins = false;
((XYDiagram)_chartControl.Diagram).AxisX.VisualRange.SideMarginsValue = 2;
((XYDiagram)_chartControl.Diagram).AxisX.Label.Angle = 0;
((XYDiagram)_chartControl.Diagram).AxisX.Label.Font = new System.Drawing.Font("Calibri", 12, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisX.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Automatic;
((XYDiagram)_chartControl.Diagram).AxisY.Label.Font = new System.Drawing.Font("Calibri", 12, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisX.Title.Font = new System.Drawing.Font("Calibri", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)_chartControl.Diagram).AxisY.Title.Font = new System.Drawing.Font("Calibri", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)_chartControl.Diagram).AxisY.Title.TextColor = Color.DarkOrange;
((XYDiagram)_chartControl.Diagram).AxisX.Title.TextColor = Color.DarkOrange;
}
private void CreateChartBar2(ChartControl arg_chart, DataTable arg_dt, string arg_name)
{
try
{
if (arg_dt == null || arg_dt.Rows.Count == 0)
{
return;
}
arg_chart.Series.Clear();
arg_chart.Titles.Clear();
arg_chart.Legend.CustomItems.Clear();
Series series1 = new Series("Lean LD", ViewType.Bar);
Series series2 = new Series("Lean LE", ViewType.Bar);
//Series series3 = new Series("Lean I", ViewType.Bar);
//Series series4 = new Series("Lean J", ViewType.Bar);
//Series series5 = new Series("Lean K", ViewType.Bar);
//Series series6 = new Series("Lean T", ViewType.Bar);
//DevExpress.XtraCharts.XYSeriesBlowUpAnimation xySeriesBlowUpAnimation1 = new DevExpress.XtraCharts.XYSeriesBlowUpAnimation();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesUnwindAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
//DevExpress.XtraCharts.XYSeriesUnwrapAnimation xySeriesUnwrapAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwrapAnimation();
//DevExpress.XtraCharts.PowerEasingFunction powerEasingFunction1 = new DevExpress.XtraCharts.PowerEasingFunction();
DevExpress.XtraCharts.SineEasingFunction sineEasingFunction1 = new DevExpress.XtraCharts.SineEasingFunction();
DevExpress.XtraCharts.ConstantLine constantLine1 = new DevExpress.XtraCharts.ConstantLine();
DevExpress.XtraCharts.CustomLegendItem customLegendItem1 = new DevExpress.XtraCharts.CustomLegendItem();
DevExpress.XtraCharts.CustomLegendItem customLegendItem2 = new DevExpress.XtraCharts.CustomLegendItem();
DevExpress.XtraCharts.CustomLegendItem customLegendItem3 = new DevExpress.XtraCharts.CustomLegendItem();
DevExpress.XtraCharts.CustomLegendItem customLegendItem4 = new DevExpress.XtraCharts.CustomLegendItem();
// Add points to them, with their arguments different.
int irow = 0;
for (int i = 0; i < arg_dt.Rows.Count; i++)
{
//series2.Points.Add(new SeriesPoint(arg_dt.Rows[i]["DD"].ToString() + "\n" + arg_dt.Rows[i]["DY"].ToString(),
// arg_dt.Rows[i]["POD"] == null || arg_dt.Rows[i]["POD"].ToString() == "" ? 0 : arg_dt.Rows[i]["POD"]));
//if (arg_dt.Rows[i]["POD"] != null && arg_dt.Rows[i]["POD"].ToString() != "")
// series2.Points[i].Color = Color.FromName(arg_dt.Rows[i]["COLOR"].ToString());
//else
// series2.Points[i].Color = Color.Empty;
switch (arg_dt.Rows[i]["RN"].ToString())
{
case "1":
add_series(ref series1, arg_dt, irow, i);
break;
case "2":
add_series(ref series2, arg_dt, irow, i);
break;
//case "3":
// add_series(ref series3, arg_dt, irow, i);
// break;
//case "4":
// add_series(ref series4, arg_dt, irow, i);
// break;
//case "5":
// add_series(ref series5, arg_dt, irow, i);
// break;
//case "6":
// add_series(ref series6, arg_dt, irow, i);
// break;
}
if (i + 1 < arg_dt.Rows.Count && arg_dt.Rows[i + 1]["DD"].ToString() != arg_dt.Rows[i]["DD"].ToString())
{
irow++;
}
}
series1.Points.Add(new SeriesPoint(" "));
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series1.Label.TextPattern = "{S}";
((SideBySideBarSeriesLabel)series1.Label).Position = BarSeriesLabelPosition.Top;
series1.Label.TextOrientation = TextOrientation.BottomToTop;
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.Label.TextPattern = "{S}";
((SideBySideBarSeriesLabel)series2.Label).Position = BarSeriesLabelPosition.Top;
series2.Label.TextOrientation = TextOrientation.BottomToTop;
//series3.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
//series3.Label.TextPattern = "{S}";
//((SideBySideBarSeriesLabel)series3.Label).Position = BarSeriesLabelPosition.Top;
//series3.Label.TextOrientation = TextOrientation.BottomToTop;
//series4.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
//series4.Label.TextPattern = "{S}";
//((SideBySideBarSeriesLabel)series4.Label).Position = BarSeriesLabelPosition.Top;
//series4.Label.TextOrientation = TextOrientation.BottomToTop;
//series5.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
//series5.Label.TextPattern = "{S}";
//((SideBySideBarSeriesLabel)series5.Label).Position = BarSeriesLabelPosition.Top;
//series5.Label.TextOrientation = TextOrientation.BottomToTop;
//series6.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
//series6.Label.TextPattern = "{S}";
//((SideBySideBarSeriesLabel)series6.Label).Position = BarSeriesLabelPosition.Top;
//series6.Label.TextOrientation = TextOrientation.BottomToTop;
arg_chart.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1, series2 };
((XYDiagram)arg_chart.Diagram).AxisY.Title.Text = "POD";
((XYDiagram)arg_chart.Diagram).AxisY.Title.TextColor = System.Drawing.Color.Orange;
((XYDiagram)arg_chart.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)arg_chart.Diagram).AxisX.Title.Text = "Date";
((XYDiagram)arg_chart.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)arg_chart.Diagram).AxisX.Title.TextColor = System.Drawing.Color.Orange;
((XYDiagram)arg_chart.Diagram).AxisX.Tickmarks.MinorVisible = false;
//title
DevExpress.XtraCharts.ChartTitle chartTitle2 = new DevExpress.XtraCharts.ChartTitle();
chartTitle2.Alignment = System.Drawing.StringAlignment.Near;
chartTitle2.Font = new System.Drawing.Font("Tahoma", 24F, System.Drawing.FontStyle.Bold);
chartTitle2.Text = arg_name;
chartTitle2.TextColor = System.Drawing.Color.Black;
arg_chart.Titles.AddRange(new DevExpress.XtraCharts.ChartTitle[] { chartTitle2 });
xySeriesUnwindAnimation1.EasingFunction = sineEasingFunction1; //powerEasingFunction1;
series1.ShowInLegend = false;
arg_chart.Legend.Direction = LegendDirection.LeftToRight;
//Constant line
//constantLine1.ShowInLegend = false;
constantLine1.AxisValueSerializable = arg_dt.Rows[0]["TAR_GREEN"].ToString();
constantLine1.Color = Color.DodgerBlue;
constantLine1.Name = "Target";
constantLine1.ShowBehind = false;
constantLine1.Title.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
constantLine1.Title.Text = arg_dt.Rows[0]["TAR_GREEN"].ToString();
constantLine1.Title.Visible = true;
constantLine1.LineStyle.Thickness = 2;
constantLine1.Title.Alignment = DevExpress.XtraCharts.ConstantLineTitleAlignment.Far;
//Legend
customLegendItem1.MarkerColor = System.Drawing.Color.Red;
customLegendItem1.Text = "<" + arg_dt.Rows[0]["TAR_YELLOW"].ToString();
customLegendItem2.MarkerColor = System.Drawing.Color.Yellow;
customLegendItem2.Text = arg_dt.Rows[0]["TAR_YELLOW"].ToString() + " ~ " + arg_dt.Rows[0]["TAR_GREEN"].ToString();
customLegendItem3.MarkerColor = System.Drawing.Color.Green;
customLegendItem3.Text = ">" + arg_dt.Rows[0]["TAR_GREEN"].ToString();
customLegendItem4.MarkerColor = System.Drawing.Color.DodgerBlue;
customLegendItem4.Text = "Target";
arg_chart.Legend.CustomItems.AddRange(new DevExpress.XtraCharts.CustomLegendItem[] {
customLegendItem1,
customLegendItem2,
customLegendItem3,
customLegendItem4
});
//((XYDiagram)arg_chart.Diagram).AxisY.WholeRange.MinValue = 0;
//((XYDiagram)arg_chart.Diagram).AxisY.WholeRange.MaxValue = arg_dt.Rows[0]["TARGET"].ToString() + 10;
((XYDiagram)arg_chart.Diagram).AxisY.ConstantLines.Clear();
((XYDiagram)arg_chart.Diagram).AxisY.ConstantLines.AddRange(new DevExpress.XtraCharts.ConstantLine[] { constantLine1 });
// ((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.Auto = true;
((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.AutoSideMargins = false;
((XYDiagram)arg_chart.Diagram).AxisX.VisualRange.SideMarginsValue = 2;
((XYDiagram)arg_chart.Diagram).AxisX.Label.Angle = 0;
((XYDiagram)arg_chart.Diagram).AxisX.Label.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold);
((XYDiagram)arg_chart.Diagram).AxisX.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Continuous;
//((XYDiagram)_chartControl1.Diagram).AxisY.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Automatic;
((XYDiagram)arg_chart.Diagram).AxisY.Label.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold);
((XYDiagram)arg_chart.Diagram).AxisX.Title.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)arg_chart.Diagram).AxisY.Title.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//pn_body.Controls.Add(arg_chart);
}
catch
{
}
}