private void CreateChart(DataTable _dt, DevExpress.XtraCharts.ChartControl _chartControl)
{
try
{
_dt.Rows.RemoveAt(0);
((XYDiagram)_chartControl.Diagram).EnableAxisXZooming = true;
//((XYDiagram)barChartControl.Diagram).AxisX.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Automatic;
((XYDiagram)_chartControl.Diagram).AxisX.VisualRange.Auto = false;
((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", 12F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)_chartControl.Diagram).AxisX.Title.Text = "Model";
((XYDiagram)_chartControl.Diagram).AxisX.Title.Font = new Font("Calibri", 14F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Label.Font = new System.Drawing.Font("Calibri", 12F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)_chartControl.Diagram).AxisY.Title.Text = " Inventory (Prs)";
((XYDiagram)_chartControl.Diagram).AxisY.Label.TextPattern = "{V:###,###}";
((XYDiagram)_chartControl.Diagram).AxisY.Title.Font = new Font("Calibri", 14F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Title.TextColor = Color.DarkOrange;
((XYDiagram)_chartControl.Diagram).AxisX.Title.TextColor = Color.DarkOrange;
((XYDiagram)_chartControl.Diagram).AxisX.Label.Angle = 50;
DevExpress.XtraCharts.LineSeriesView splineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView();
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesSlideAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
_chartControl.AnimationStartMode = DevExpress.XtraCharts.ChartAnimationMode.OnDataChanged;
_chartControl.Series.Clear();
_chartControl.Titles.Clear();
Series series1 = new Series("Inventory", ViewType.Bar);
Series series2 = new Series("Leadtime", ViewType.Line);
Legend lgBox = new Legend();
lgBox.Visibility = DevExpress.Utils.DefaultBoolean.True;
lgBox.Font = new Font("Calibri", 16F, System.Drawing.FontStyle.Bold);
if (_dt != null && _dt.Rows.Count > 0)
{
for (int iRow = 0; iRow < _dt.Rows.Count; iRow++)
{
if (_dt.Rows[iRow]["INV_QTY"].ToString() != "")
{
series1.Points.Add(new SeriesPoint(_dt.Rows[iRow]["MODEL_NAME"].ToString(), Convert.ToInt32(_dt.Rows[iRow]["INV_QTY"].ToString())));
}
else
{
series1.Points.Add(new SeriesPoint(_dt.Rows[iRow]["MODEL_NAME"].ToString(), 0));
}
if (_dt.Rows[iRow]["LEADTIME"].ToString() != "")
{
series2.Points.Add(new SeriesPoint(_dt.Rows[iRow]["MODEL_NAME"].ToString(), Convert.ToDouble(_dt.Rows[iRow]["LEADTIME"].ToString())));
}
else
{
series2.Points.Add(new SeriesPoint(_dt.Rows[iRow]["MODEL_NAME"].ToString(), 0));
}
}
}
sideBySideBarSeriesView1.ColorEach = false;
sideBySideBarSeriesView1.Shadow.Visible = false;
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series1.Label.TextPattern = "{V:###,###}";
series1.ArgumentScaleType = ScaleType.Qualitative;
series1.View = sideBySideBarSeriesView1;
splineSeriesView1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(240)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))));
splineSeriesView1.LineStyle.Thickness = 2;
splineSeriesView1.SeriesAnimation = xySeriesSlideAnimation1;
splineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
splineSeriesView1.LineMarkerOptions.Size = 15;
splineSeriesView1.LineMarkerOptions.Color = Color.DodgerBlue;
series2.Label.BackColor = Color.White;
series2.Label.Font = new System.Drawing.Font("Calibri", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.Label.TextPattern = "{V:##0.#}";
series2.ArgumentScaleType = ScaleType.Qualitative;
series2.View = splineSeriesView1;
// Access the type-specific options of the diagram.
_chartControl.Series.AddRange(new Series[] { series1, series2 });
SecondaryAxisY myAxisY = new SecondaryAxisY("my Y-Axis");
//myAxisY.VisualRange.SetMinMaxValues(0, 20);
myAxisY.Title.Text = "Leadtime (Days)";
myAxisY.Tickmarks.MinorVisible = true;
//((XYDiagram)barChartControl.Diagram).AxisY.WholeRange.SetMinMaxValues(90, 100);
myAxisY.Label.Font = new System.Drawing.Font("Calibri", 11F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
myAxisY.Title.Font = new System.Drawing.Font("Calibri", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
myAxisY.Label.TextPattern = "{V:##0.##}";
myAxisY.Title.TextColor = Color.DarkOrange;
myAxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((XYDiagram)_chartControl.Diagram).SecondaryAxesY.Clear();
((XYDiagram)_chartControl.Diagram).SecondaryAxesY.Add(myAxisY);
((LineSeriesView)series2.View).AxisY = myAxisY;
// _chartControl.Legends.Add(lgBox);
// Add a title to the chart (if necessary).
// _chartControl.Titles.Add(new ChartTitle());
//_chartControl.Titles[0].Text = "Production";
}
catch (Exception EX)
{
}
}
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)
{
// 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 BindingPareto(DevExpress.XtraCharts.ChartControl charControl, DataTable dt, string iColPoint, string iColValue, string iColPercent, string _ChartTitle, string _sYTitle, string _sXTitle)
{
try
{
((XYDiagram)charControl.Diagram).AxisX.NumericScaleOptions.AutoGrid = true;
((XYDiagram)charControl.Diagram).AxisX.Title.TextColor = Color.DarkOrange;
((XYDiagram)charControl.Diagram).AxisX.Title.Text = _sXTitle;
((XYDiagram)charControl.Diagram).AxisY.Title.TextColor = Color.DarkOrange;
((XYDiagram)charControl.Diagram).AxisY.Title.Text = _sYTitle;
((XYDiagram)charControl.Diagram).AxisX.Title.Font = new System.Drawing.Font("Calibri", 8F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)charControl.Diagram).AxisX.Label.Font = new System.Drawing.Font("Calibri", 8F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)charControl.Diagram).AxisY.Title.Font = new System.Drawing.Font("Calibri", 8F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)charControl.Diagram).AxisY.Label.Font = new System.Drawing.Font("Calibri", 8F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)charControl.Diagram).AxisX.Label.Angle = 50;
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
DevExpress.XtraCharts.SplineSeriesView splineSeriesView1 = new DevExpress.XtraCharts.SplineSeriesView();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesSlideAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
sideBySideBarSeriesView1.ColorEach = true;
charControl.Series.Clear();
charControl.AnimationStartMode = DevExpress.XtraCharts.ChartAnimationMode.OnDataChanged;
//charControl.SeriesSorting = SortingMode.Descending;
Series series1 = new Series(_ChartTitle, ViewType.Bar);
Series series2 = new Series("%", ViewType.Spline);
for (int i = 0; i < dt.Rows.Count; i++)
{
series1.Points.Add(new SeriesPoint(dt.Rows[i][iColPoint].ToString(), dt.Rows[i][iColValue].ToString()));
series2.Points.Add(new SeriesPoint(dt.Rows[i][iColPoint].ToString(), dt.Rows[i][iColPercent].ToString()));
}
series1.ArgumentScaleType = ScaleType.Qualitative;
series2.ArgumentScaleType = ScaleType.Qualitative;
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
sideBySideBarSeriesView1.ColorEach = false;
series1.View = sideBySideBarSeriesView1;
series1.Label.Font = new System.Drawing.Font("Calibri", 8.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
splineSeriesView1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(240)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))));
splineSeriesView1.LineStyle.Thickness = 2;
splineSeriesView1.SeriesAnimation = xySeriesSlideAnimation1;
splineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
splineSeriesView1.LineMarkerOptions.Size = 15;
splineSeriesView1.LineMarkerOptions.Color = Color.DodgerBlue;
series2.Label.BackColor = Color.White;
series2.Label.Font = new System.Drawing.Font("Calibri", 8.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
series2.Label.TextPattern = "{V:###.##}%";
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.View = splineSeriesView1;
charControl.Series.AddRange(new Series[] { series1, series2 });
//((XYDiagram)charControl.Diagram).AxisY.VisualRange.SideMarginsValue = 1;
charControl.Titles[0].Text = _ChartTitle;
charControl.Titles[0].Font = new System.Drawing.Font("Calibri", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
SecondaryAxisY myAxisY = new SecondaryAxisY("my Y-Axis");
((XYDiagram)charControl.Diagram).SecondaryAxesY.Clear();
((XYDiagram)charControl.Diagram).SecondaryAxesY.Add(myAxisY);
myAxisY.VisualRange.SetMinMaxValues(0, 95);
myAxisY.Title.Text = "%";
myAxisY.Tickmarks.MinorVisible = false;
//((XYDiagram)barChartControl.Diagram).AxisY.WholeRange.SetMinMaxValues(90, 100);
myAxisY.Label.Font = new System.Drawing.Font("Calibri", 11F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
myAxisY.Title.Font = new System.Drawing.Font("Calibri", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
myAxisY.Label.TextPattern = "{V:###.##}";
myAxisY.Title.TextColor = Color.DarkOrange;
myAxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
((SplineSeriesView)series2.View).AxisY = myAxisY;
((XYDiagram)charControl.Diagram).AxisX.QualitativeScaleOptions.AutoGrid = false;
}
catch (Exception ex)
{
}
}
private void CreateChart(DataTable _dt, DevExpress.XtraCharts.ChartControl _chartControl)
{
try
{
((XYDiagram)_chartControl.Diagram).EnableAxisXZooming = true;
((XYDiagram)_chartControl.Diagram).AxisX.VisualRange.Auto = false;
((XYDiagram)_chartControl.Diagram).AxisX.VisualRange.AutoSideMargins = false;
((XYDiagram)_chartControl.Diagram).AxisX.VisualRange.SideMarginsValue = 1;
((XYDiagram)_chartControl.Diagram).AxisX.Label.Angle = 0;
((XYDiagram)_chartControl.Diagram).AxisX.Label.Font = new System.Drawing.Font("Calibri", 12F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)_chartControl.Diagram).AxisX.Title.Text = "Date";
((XYDiagram)_chartControl.Diagram).AxisX.Title.Font = new Font("Calibri", 14F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Label.Font = new System.Drawing.Font("Calibri", 12F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)_chartControl.Diagram).AxisY.Title.Text = " OS&D (Prs)";
((XYDiagram)_chartControl.Diagram).AxisY.Label.TextPattern = "{V:###,###}";
((XYDiagram)_chartControl.Diagram).AxisY.Title.Font = new Font("Calibri", 14F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Title.TextColor = Color.DarkOrange;
((XYDiagram)_chartControl.Diagram).AxisX.Title.TextColor = Color.DarkOrange;
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesSlideAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
_chartControl.AnimationStartMode = DevExpress.XtraCharts.ChartAnimationMode.OnDataChanged;
_chartControl.Series.Clear();
_chartControl.Titles.Clear();
Legend lgBox = new Legend();
Series[] arrSeries = new Series[_dt.Rows.Count - 1];
lgBox.Visibility = DevExpress.Utils.DefaultBoolean.True;
lgBox.Font = new Font("Calibri", 16F, System.Drawing.FontStyle.Bold);
if (_dt != null && _dt.Rows.Count > 0)
{
for (int iRow = 0; iRow < _dt.Rows.Count; iRow++)
{
if (_dt.Rows[iRow]["DIV"].ToString() == "1")
{
arrSeries[iRow] = new Series(_dt.Rows[iRow]["LINE_CD"].ToString(), ViewType.Spline);
for (int iCol = 2; iCol < _dt.Columns.Count; iCol++)
{
if (_dt.Rows[iRow][iCol].ToString() != "" && _dt.Rows[iRow][iCol] != null)
{
arrSeries[iRow].Points.Add(new SeriesPoint(DateTime.ParseExact(_dt.Columns[iCol].Caption.ToString().Substring(1, 8), "yyyyMMdd", CultureInfo.InvariantCulture).ToString("MMM\ndd"), Convert.ToDouble(_dt.Rows[iRow][iCol].ToString())));
}
else
{
arrSeries[iRow].Points.Add(new SeriesPoint(DateTime.ParseExact(_dt.Columns[iCol].Caption.ToString().Substring(1, 8), "yyyyMMdd", CultureInfo.InvariantCulture).ToString("MMM\ndd"), 0));
}
}
}
}
}
for (int i = 0; i < arrSeries.Length; i++)
{
DevExpress.XtraCharts.SplineSeriesView splineSeriesView = new DevExpress.XtraCharts.SplineSeriesView();
splineSeriesView.LineStyle.Thickness = 2;
splineSeriesView.SeriesAnimation = xySeriesSlideAnimation1;
splineSeriesView.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
splineSeriesView.LineMarkerOptions.Size = 15;
splineSeriesView.LineMarkerOptions.Color = Color.DodgerBlue;
splineSeriesView.Color = getColor(arrSeries[i].Name.ToString());
arrSeries[i].LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
arrSeries[i].Label.TextPattern = "{V:###,###.#}";
arrSeries[i].ArgumentScaleType = ScaleType.Qualitative;
arrSeries[i].View = splineSeriesView;
}
// Access the type-specific options of the diagram.
_chartControl.Series.AddRange(arrSeries);
_chartControl.Legends.Add(lgBox);
((XYDiagram)_chartControl.Diagram).AxisX.QualitativeScaleOptions.AutoGrid = false;
}
catch (Exception EX)
{
}
}
private void CreateByModelChart()
{
//Reset Chart beforce biding Data
ChartByModel.Series.Clear();
ChartByModel.Titles.Clear();
// Create an empty chart. (No need).
ChartByModel.AppearanceNameSerializable = "Slipstream";
//create New object
DevExpress.XtraCharts.LineSeriesView lineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesUnwindAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
DevExpress.XtraCharts.PowerEasingFunction powerEasingFunction1 = new DevExpress.XtraCharts.PowerEasingFunction();
DevExpress.XtraCharts.BarSlideAnimation barSlideAnimation1 = new DevExpress.XtraCharts.BarSlideAnimation();
DevExpress.XtraCharts.LineSeriesView lineSeriesView2 = new DevExpress.XtraCharts.LineSeriesView();
// Create the first side-by-side bar series and add points to it.
Series series1 = new Series("Inv", ViewType.Bar);
Series series2 = new Series("%", ViewType.Line);
// Create the second side-by-side bar series and add points to it.
DataTable dt = SEL_FG_BY_MODEL(Line, Mline);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
series1.Points.Add(new SeriesPoint(dt.Rows[i]["MODEL_NAME"].ToString(), dt.Rows[i]["INV"]));
series2.Points.Add(new SeriesPoint(dt.Rows[i]["MODEL_NAME"].ToString(), dt.Rows[i]["PAR"]));
}
}
series1.ArgumentScaleType = ScaleType.Qualitative;
series2.ArgumentScaleType = ScaleType.Qualitative;
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
(series1.Label as SideBySideBarSeriesLabel).Position = DevExpress.XtraCharts.BarSeriesLabelPosition.Top;
sideBySideBarSeriesView1.ColorEach = false;
sideBySideBarSeriesView1.Animation = barSlideAnimation1;
sideBySideBarSeriesView1.Color = Color.DarkOrange;
series1.View = sideBySideBarSeriesView1;
//marker
lineSeriesView1.LineMarkerOptions.Color = System.Drawing.Color.Gold;
lineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
//fORMAT LINE
lineSeriesView1.Color = Color.DeepPink;
series2.View = lineSeriesView1;
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
lineSeriesView2.LineMarkerOptions.Color = System.Drawing.Color.Gold;
lineSeriesView2.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
// Add the series to the chart.
ChartByModel.SeriesSerializable = new Series[] { series1, series2 };
//Dailychart.Series.Add(series1);
//Dailychart.Series.Add(series2);
// Create two secondary axes, and add them to the chart's Diagram.
SecondaryAxisY myAxisY = new SecondaryAxisY("my Y-Axis");
((XYDiagram)ChartByModel.Diagram).SecondaryAxesY.Clear();
((XYDiagram)ChartByModel.Diagram).SecondaryAxesY.Add(myAxisY);
myAxisY.Label.TextPattern = "{V:#,#}";
myAxisY.Title.TextColor = System.Drawing.Color.OrangeRed;
myAxisY.Title.Font = new Font("Calibri", 16, FontStyle.Regular);
myAxisY.Title.Text = "%";
myAxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
// myAxisY.Label.Font = new System.Drawing.Font("Calibri", 12F);
((LineSeriesView)series2.View).AxisY = myAxisY;
((XYDiagram)ChartByModel.Diagram).AxisX.Title.Text = "Model";
((XYDiagram)ChartByModel.Diagram).AxisY.Title.Text = "Inv (Prs)";
// Rotate the diagram (if necessary).
((XYDiagram)ChartByModel.Diagram).Rotated = false;
//ScaleBreak NUmber
((XYDiagram)ChartByModel.Diagram).AxisX.NumericScaleOptions.AutoGrid = false;
//Title
((XYDiagram)ChartByModel.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)ChartByModel.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
//legend
ChartByModel.Legend.AlignmentHorizontal = DevExpress.XtraCharts.LegendAlignmentHorizontal.RightOutside;
ChartByModel.Legend.Direction = DevExpress.XtraCharts.LegendDirection.TopToBottom;
ChartByModel.Legend.MarkerMode = DevExpress.XtraCharts.LegendMarkerMode.CheckBoxAndMarker;
ChartByModel.Legend.Name = "Default Legend";
ChartByModel.Legend.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)Dailychart.Diagram).AxisY.Label.TextPattern = "{V:#,#}";
//Label
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series1.Label.TextPattern = "{V:#,#}";
series2.Label.TextPattern = "{V}" + "%";
(series1.Label as SideBySideBarSeriesLabel).Position = DevExpress.XtraCharts.BarSeriesLabelPosition.Top;
((XYDiagram)ChartByModel.Diagram).AxisY.Label.TextPattern = "{V:#,#}";
// Add a title to the chart (if necessary).
ChartTitle chartTitle1 = new ChartTitle();
chartTitle1.Text = "Inventory by Model";
ChartByModel.Titles.Add(chartTitle1);
// Add the chart to the form.
ChartByModel.Dock = DockStyle.Fill;
splitChart_Detail.Panel1.Controls.Add(ChartByModel);
}
private void CreateChart(DataTable _dt, DevExpress.XtraCharts.ChartControl _chartControl)
{
try
{
((XYDiagram)_chartControl.Diagram).EnableAxisXZooming = true;
//((XYDiagram)barChartControl.Diagram).AxisX.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Automatic;
((XYDiagram)_chartControl.Diagram).AxisX.VisualRange.Auto = false;
((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", 12F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)_chartControl.Diagram).AxisX.Title.Text = "Date";
((XYDiagram)_chartControl.Diagram).AxisX.Title.Font = new Font("Calibri", 14F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Label.Font = new System.Drawing.Font("Calibri", 12F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)_chartControl.Diagram).AxisY.Title.Text = " Qty (Prs)";
((XYDiagram)_chartControl.Diagram).AxisY.Label.TextPattern = "{V:###,###}";
((XYDiagram)_chartControl.Diagram).AxisY.Title.Font = new Font("Calibri", 14F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Title.TextColor = Color.DarkOrange;
((XYDiagram)_chartControl.Diagram).AxisX.Title.TextColor = Color.DarkOrange;
DevExpress.XtraCharts.LineSeriesView splineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView();
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesSlideAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
_chartControl.AnimationStartMode = DevExpress.XtraCharts.ChartAnimationMode.OnDataChanged;
_chartControl.Series.Clear();
_chartControl.Titles.Clear();
Series series1 = new Series("Production", ViewType.Bar);
Series series2 = new Series("Plan", ViewType.Line);
Legend lgBox = new Legend();
lgBox.Visibility = DevExpress.Utils.DefaultBoolean.True;
lgBox.Font = new Font("Calibri", 16F, System.Drawing.FontStyle.Bold);
if (_dt != null && _dt.Rows.Count > 0)
{
for (int iRow = 0; iRow < _dt.Rows.Count; iRow++)
{
if (_dt.Rows[iRow]["DIV"].ToString() == "1")
{
for (int iCol = 1; iCol < _dt.Columns.Count; iCol++)
{
if (_dt.Rows[iRow][iCol].ToString() != "")
{
series2.Points.Add(new SeriesPoint(_dt.Columns[iCol].Caption.ToString().Substring(7, 2), Convert.ToInt32(_dt.Rows[iRow][iCol].ToString())));
}
else
{
series2.Points.Add(new SeriesPoint(_dt.Columns[iCol].Caption.ToString().Substring(7, 2), 0));
}
}
}
if (_dt.Rows[iRow]["DIV"].ToString() == "2")
{
for (int iCol = 1; iCol < _dt.Columns.Count; iCol++)
{
if (_dt.Rows[iRow][iCol].ToString() != "")
{
series1.Points.Add(new SeriesPoint(_dt.Columns[iCol].Caption.ToString().Substring(7, 2), Convert.ToInt32(_dt.Rows[iRow][iCol].ToString())));
}
else
{
series1.Points.Add(new SeriesPoint(_dt.Columns[iCol].Caption.ToString().Substring(7, 2), 0));
}
}
}
}
}
sideBySideBarSeriesView1.ColorEach = false;
sideBySideBarSeriesView1.Shadow.Visible = false;
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series1.Label.TextPattern = "{V:###,###}";
series1.ArgumentScaleType = ScaleType.Qualitative;
series1.View = sideBySideBarSeriesView1;
splineSeriesView1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(240)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))));
splineSeriesView1.LineStyle.Thickness = 2;
splineSeriesView1.SeriesAnimation = xySeriesSlideAnimation1;
splineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
splineSeriesView1.LineMarkerOptions.Size = 15;
splineSeriesView1.LineMarkerOptions.Color = Color.DodgerBlue;
series2.Label.BackColor = Color.White;
series2.Label.Font = new System.Drawing.Font("Calibri", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.Label.TextPattern = "{V:###,###}";
series2.ArgumentScaleType = ScaleType.Qualitative;
series2.View = splineSeriesView1;
// Access the type-specific options of the diagram.
_chartControl.Series.AddRange(new Series[] { series1, series2 });
_chartControl.Legends.Add(lgBox);
// Add a title to the chart (if necessary).
// _chartControl.Titles.Add(new ChartTitle());
//_chartControl.Titles[0].Text = "Production";
}
catch (Exception EX)
{
}
}
private void CreateDailyChart()
{
//Reset Chart beforce biding Data
Dailychart.Series.Clear();
Dailychart.Titles.Clear();
// Create an empty chart. (No need).
Dailychart.AppearanceNameSerializable = "Slipstream";
//create New object
DevExpress.XtraCharts.LineSeriesView lineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesUnwindAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
DevExpress.XtraCharts.PowerEasingFunction powerEasingFunction1 = new DevExpress.XtraCharts.PowerEasingFunction();
// Create the first side-by-side bar series and add points to it.
Series series1 = new Series("Inv", ViewType.Bar);
// Create the second side-by-side bar series and add points to it.
Series series2 = new Series("Amount", ViewType.Line);
DataTable dt = SEL_FG_INV_MONTHLY_CHART(Line, Mline);
try
{
string YM = null;
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
YM = dt.Rows[i]["YM"].ToString();
series1.Points.Add(new SeriesPoint(YM, dt.Rows[i]["INV"]));
series2.Points.Add(new SeriesPoint(YM, dt.Rows[i]["AMT"]));
}
}
series1.ArgumentScaleType = ScaleType.Qualitative;
series2.ArgumentScaleType = ScaleType.Qualitative;
//for (int i = 0; i <= 30; i++)
//{
// series1.Points.Add(new SeriesPoint(i.ToString(), GetRandomNumber(10, 1000)));
// series2.Points.Add(new SeriesPoint(i.ToString(), GetRandomNumber(1000, 10000)));
//}
//marker
lineSeriesView1.LineMarkerOptions.Color = System.Drawing.Color.Gold;
lineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.View = lineSeriesView1;
// Add the series to the chart.
Dailychart.SeriesSerializable = new Series[] { series1, series2 };
//Dailychart.Series.Add(series1);
//Dailychart.Series.Add(series2);
// Create two secondary axes, and add them to the chart's Diagram.
SecondaryAxisY myAxisY = new SecondaryAxisY("my Y-Axis");
((XYDiagram)Dailychart.Diagram).SecondaryAxesY.Clear();
((XYDiagram)Dailychart.Diagram).SecondaryAxesY.Add(myAxisY);
myAxisY.Label.TextPattern = "{V:#,#}";
myAxisY.Title.TextColor = System.Drawing.Color.OrangeRed;
myAxisY.Title.Font = new Font("Calibri", 16, FontStyle.Italic);
myAxisY.Title.Text = "Money";
myAxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
// myAxisY.Label.Font = new System.Drawing.Font("Calibri", 12F);
((LineSeriesView)series2.View).AxisY = myAxisY;
// Hide the legend (if necessary).
Dailychart.Legend.Visibility = DevExpress.Utils.DefaultBoolean.False;
// Rotate the diagram (if necessary).
((XYDiagram)Dailychart.Diagram).Rotated = false;
//ScaleBreak NUmber
((XYDiagram)Dailychart.Diagram).AxisX.NumericScaleOptions.AutoGrid = false;
//Title
((XYDiagram)Dailychart.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)Dailychart.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)Dailychart.Diagram).AxisX.Title.Text = "Monthly";
((XYDiagram)Dailychart.Diagram).AxisY.Title.Text = "Inventory (Prs)";
//Animation Series
lineSeriesView1.Color = System.Drawing.Color.DeepPink;
xySeriesUnwindAnimation1.EasingFunction = powerEasingFunction1;
lineSeriesView1.SeriesAnimation = xySeriesUnwindAnimation1;
((XYDiagram)Dailychart.Diagram).AxisY.Label.TextPattern = "{V:#,#}";
//Label
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series1.Label.TextPattern = "{V:#,#}";
(series1.Label as SideBySideBarSeriesLabel).Position = DevExpress.XtraCharts.BarSeriesLabelPosition.Center;
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.Label.TextPattern = "{V:#,#}";
// Add a title to the chart (if necessary).
Dailychart.Legend.Visibility = DevExpress.Utils.DefaultBoolean.True;
ChartTitle chartTitle1 = new ChartTitle();
chartTitle1.Text = "Inventory";
Dailychart.Titles.Add(chartTitle1);
// Add the chart to the form.
Dailychart.Dock = DockStyle.Fill;
splMainV.Panel1.Controls.Add(Dailychart);
}
catch
{ }
}
private void CreateModelChart()
{
//Reset Chart beforce biding Data
Modelchart.Series.Clear();
Modelchart.Titles.Clear();
// Create an empty chart. (No need).
Modelchart.AppearanceNameSerializable = "Slipstream";
//create New object
DevExpress.XtraCharts.LineSeriesView lineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesUnwindAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
DevExpress.XtraCharts.PowerEasingFunction powerEasingFunction1 = new DevExpress.XtraCharts.PowerEasingFunction();
DevExpress.XtraCharts.LineSeriesView lineSeriesView2 = new DevExpress.XtraCharts.LineSeriesView();
// Create the first side-by-side bar series and add points to it.
Series series1 = new Series("Inv", ViewType.Bar);
Series series2 = new Series("CTN", ViewType.Bar);
// Create the second side-by-side bar series and add points to it.
DataTable dt = SEL_FG_INV_DAILY_INCOM_CHART(Line, Mline);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
series1.Points.Add(new SeriesPoint(dt.Rows[i]["YMD"].ToString(), dt.Rows[i]["CTN"]));
series2.Points.Add(new SeriesPoint(dt.Rows[i]["YMD"].ToString(), dt.Rows[i]["PRS"]));
}
}
series1.ArgumentScaleType = ScaleType.Qualitative;
series2.ArgumentScaleType = ScaleType.Qualitative;
//for (int i = 0; i <= 30; i++)
//{
// series1.Points.Add(new SeriesPoint(i.ToString(), GetRandomNumber(10, 1000)));
//}
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView2 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
(series1.Label as SideBySideBarSeriesLabel).Position = DevExpress.XtraCharts.BarSeriesLabelPosition.Top;
(series2.Label as SideBySideBarSeriesLabel).Position = DevExpress.XtraCharts.BarSeriesLabelPosition.Top;
sideBySideBarSeriesView1.ColorEach = false;
sideBySideBarSeriesView2.ColorEach = false;
sideBySideBarSeriesView1.Color = Color.SeaGreen; sideBySideBarSeriesView2.Color = Color.HotPink;
series1.View = sideBySideBarSeriesView1;
series2.View = sideBySideBarSeriesView2;
//marker
lineSeriesView1.LineMarkerOptions.Color = System.Drawing.Color.Gold;
lineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
lineSeriesView2.LineMarkerOptions.Color = System.Drawing.Color.Gold;
lineSeriesView2.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
// Add the series to the chart.
Modelchart.SeriesSerializable = new Series[] { series1 };
//Dailychart.Series.Add(series1);
//Dailychart.Series.Add(series2);
((XYDiagram)Modelchart.Diagram).AxisX.Title.Text = "Date";
((XYDiagram)Modelchart.Diagram).AxisY.Title.Text = "Qty (Prs)";
// Rotate the diagram (if necessary).
((XYDiagram)Modelchart.Diagram).Rotated = false;
//ScaleBreak NUmber
((XYDiagram)Modelchart.Diagram).AxisX.NumericScaleOptions.AutoGrid = false;
//Title
((XYDiagram)Modelchart.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)Modelchart.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
//legend
Modelchart.Legend.AlignmentHorizontal = DevExpress.XtraCharts.LegendAlignmentHorizontal.RightOutside;
Modelchart.Legend.Direction = DevExpress.XtraCharts.LegendDirection.LeftToRight;
Modelchart.Legend.MarkerMode = DevExpress.XtraCharts.LegendMarkerMode.CheckBoxAndMarker;
Modelchart.Legend.Name = "Default Legend";
Modelchart.Legend.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)Dailychart.Diagram).AxisY.Label.TextPattern = "{V:#,#}";
//Label
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series1.Label.TextPattern = "{V:#,#}";
(series1.Label as SideBySideBarSeriesLabel).Position = DevExpress.XtraCharts.BarSeriesLabelPosition.Top;
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.Label.TextPattern = "{V:#,#}";
(series2.Label as SideBySideBarSeriesLabel).Position = DevExpress.XtraCharts.BarSeriesLabelPosition.Top;
((XYDiagram)Modelchart.Diagram).AxisY.Label.TextPattern = "{V:#,#}";
// Add a title to the chart (if necessary).
ChartTitle chartTitle1 = new ChartTitle();
chartTitle1.Text = "Daily Incoming Status";
Modelchart.Titles.Add(chartTitle1);
// Add the chart to the form.
Modelchart.Dock = DockStyle.Fill;
splitChart_Detail.Panel1.Controls.Add(Modelchart);
}
private void CreateChart(DataTable _dt, DevExpress.XtraCharts.ChartControl _chartControl)
{
try
{
((XYDiagram)_chartControl.Diagram).EnableAxisXZooming = true;
//((XYDiagram)barChartControl.Diagram).AxisX.NumericScaleOptions.ScaleMode = DevExpress.XtraCharts.ScaleMode.Automatic;
((XYDiagram)_chartControl.Diagram).AxisX.VisualRange.Auto = false;
((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", 12F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)_chartControl.Diagram).AxisX.Title.Text = "Model";
((XYDiagram)_chartControl.Diagram).AxisX.Title.Font = new Font("Calibri", 14F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Label.Font = new System.Drawing.Font("Calibri", 12F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)_chartControl.Diagram).AxisY.Title.Text = " Leadtime (Hours) ";
((XYDiagram)_chartControl.Diagram).AxisY.Label.TextPattern = "{V:###,##0.#}";
((XYDiagram)_chartControl.Diagram).AxisY.Title.Font = new Font("Calibri", 14F, System.Drawing.FontStyle.Bold);
((XYDiagram)_chartControl.Diagram).AxisY.Title.TextColor = Color.DarkOrange;
((XYDiagram)_chartControl.Diagram).AxisX.Title.TextColor = Color.DarkOrange;
((XYDiagram)_chartControl.Diagram).AxisX.Label.Angle = 50;
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView2 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesSlideAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
_chartControl.AnimationStartMode = DevExpress.XtraCharts.ChartAnimationMode.OnDataChanged;
_chartControl.Series.Clear();
_chartControl.Titles.Clear();
Series series1 = new Series("Stockfit Leadtime", ViewType.Bar);
Series series2 = new Series("Phylon Leadtime", ViewType.Bar);
Legend lgBox = new Legend();
lgBox.Visibility = DevExpress.Utils.DefaultBoolean.True;
lgBox.Font = new Font("Calibri", 16F, System.Drawing.FontStyle.Bold);
if (_dt != null && _dt.Rows.Count > 0)
{
for (int iRow = 0; iRow < _dt.Rows.Count; iRow++)
{
if (_dt.Rows[iRow]["DIV"].ToString() != "0")
{
if (_dt.Rows[iRow]["LEADTIME"].ToString() != "")
{
series1.Points.Add(new SeriesPoint(_dt.Rows[iRow]["MODEL_NAME"].ToString(), Convert.ToDouble(_dt.Rows[iRow]["LEADTIME"].ToString())));
}
else
{
series1.Points.Add(new SeriesPoint(_dt.Rows[iRow]["MODEL_NAME"].ToString(), 0));
}
double dUV_LT = 0;
double dSP_LT = 0;
if (_dt.Rows[iRow]["UV_LT"].ToString() != "")
{
dUV_LT = Convert.ToDouble(_dt.Rows[iRow]["UV_LT"].ToString());
}
if (_dt.Rows[iRow]["SP_LT"].ToString() != "")
{
dSP_LT = Convert.ToDouble(_dt.Rows[iRow]["SP_LT"].ToString());
}
series2.Points.Add(new SeriesPoint(_dt.Rows[iRow]["MODEL_NAME"].ToString(), dUV_LT + dSP_LT));
}
}
}
sideBySideBarSeriesView1.ColorEach = false;
sideBySideBarSeriesView1.Shadow.Visible = false;
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series1.Label.TextPattern = "{V:##0.#}";
series1.ArgumentScaleType = ScaleType.Qualitative;
series1.View = sideBySideBarSeriesView1;
sideBySideBarSeriesView2.ColorEach = false;
sideBySideBarSeriesView2.Shadow.Visible = false;
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.Label.TextPattern = "{V:##0.#}";
series2.ArgumentScaleType = ScaleType.Qualitative;
series2.View = sideBySideBarSeriesView2;
// Access the type-specific options of the diagram.
_chartControl.Series.AddRange(new Series[] { series1, series2 });
}
catch (Exception EX)
{
}
}
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 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 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
{
}
}
private void Create_chart(ChartControl arg_chart, DataTable arg_dt, string arg_name)
{
//Reset Chart beforce biding Data
arg_chart.Series.Clear();
arg_chart.Titles.Clear();
// Create an empty chart. (No need).
arg_chart.AppearanceNameSerializable = "Slipstream";
//create New object
DevExpress.XtraCharts.LineSeriesView lineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView();
DevExpress.XtraCharts.XYSeriesUnwindAnimation xySeriesUnwindAnimation1 = new DevExpress.XtraCharts.XYSeriesUnwindAnimation();
DevExpress.XtraCharts.PowerEasingFunction powerEasingFunction1 = new DevExpress.XtraCharts.PowerEasingFunction();
// Create the first side-by-side bar series and add points to it.
Series series1 = new Series("Lead Time", ViewType.Bar);
// Create the second side-by-side bar series and add points to it.
Series series2 = new Series("Inventory", ViewType.Line);
int iCount = 0, iShow = 0;;
for (int i = 0; i < arg_dt.Rows.Count; i++)
{
if (arg_dt.Rows[i]["STYLE_CD"].ToString().ToUpper() != "TOTAL")
{
iShow++;
if (iShow == 3)
{
series1.Points.Add(new SeriesPoint(arg_dt.Rows[i]["SUM_GRP_DETAIL"].ToString() + "\n" + arg_dt.Rows[i]["STYLE_CD"].ToString()
, arg_dt.Rows[i]["LT"] == null || arg_dt.Rows[i]["LT"].ToString() == "" ? 0 : arg_dt.Rows[i]["LT"]));
series2.Points.Add(new SeriesPoint(arg_dt.Rows[i]["SUM_GRP_DETAIL"].ToString() + "\n" + arg_dt.Rows[i]["STYLE_CD"].ToString()
, arg_dt.Rows[i]["INV"] == null || arg_dt.Rows[i]["INV"].ToString() == "" ? 0 : arg_dt.Rows[i]["INV"]));
}
else
{
series1.Points.Add(new SeriesPoint(arg_dt.Rows[i]["SUM_GRP_DETAIL"].ToString() + "\n" + addBlank(iCount)
, arg_dt.Rows[i]["LT"] == null || arg_dt.Rows[i]["LT"].ToString() == "" ? 0 : arg_dt.Rows[i]["LT"]));
series2.Points.Add(new SeriesPoint(arg_dt.Rows[i]["SUM_GRP_DETAIL"].ToString() + "\n" + addBlank(iCount)
, arg_dt.Rows[i]["INV"] == null || arg_dt.Rows[i]["INV"].ToString() == "" ? 0 : arg_dt.Rows[i]["INV"]));
}
if (i + 1 < arg_dt.Rows.Count &&
arg_dt.Rows[i + 1]["STYLE_CD"].ToString().ToUpper() != "TOTAL" &&
arg_dt.Rows[i]["STYLE_CD"].ToString() != arg_dt.Rows[i + 1]["STYLE_CD"].ToString())
{
iCount++;
iShow = 0;
series1.Points.Add(new SeriesPoint(addBlank(iCount)));
series2.Points.Add(new SeriesPoint(addBlank(iCount)));
}
}
}
//marker
lineSeriesView1.LineMarkerOptions.Color = System.Drawing.Color.Gold;
lineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
series2.View = lineSeriesView1;
// Add the series to the chart.
series1.ArgumentScaleType = ScaleType.Qualitative;
series2.ArgumentScaleType = ScaleType.Qualitative;
arg_chart.SeriesSerializable = new Series[] { series1, series2 };
//arg_chart.Series.Add(series1);
//arg_chart.Series.Add(series2);
// Create two secondary axes, and add them to the chart's Diagram.
SecondaryAxisY axisYSecond = new SecondaryAxisY("my Y-Axis");
((XYDiagram)arg_chart.Diagram).SecondaryAxesY.Clear();
((XYDiagram)arg_chart.Diagram).SecondaryAxesY.Add(axisYSecond);
axisYSecond.Label.TextPattern = "{V:#,#}";
axisYSecond.Title.TextColor = Color.Orange;
axisYSecond.Title.Font = new Font("Tahoma", 16F, FontStyle.Bold);
axisYSecond.Title.Text = "Inventory";
axisYSecond.Title.Visibility = DevExpress.Utils.DefaultBoolean.Default;
axisYSecond.Label.Font = new System.Drawing.Font("Tahoma", 10F, System.Drawing.FontStyle.Bold);
((LineSeriesView)series2.View).AxisY = axisYSecond;
// Hide the legend (if necessary).
arg_chart.Legend.Visibility = DevExpress.Utils.DefaultBoolean.True;
arg_chart.Legend.AlignmentVertical = LegendAlignmentVertical.TopOutside;
arg_chart.Legend.AlignmentHorizontal = LegendAlignmentHorizontal.Center;
arg_chart.Legend.Direction = LegendDirection.LeftToRight;
// Rotate the diagram (if necessary).
((XYDiagram)arg_chart.Diagram).Rotated = false;
//ScaleBreak NUmber
((XYDiagram)arg_chart.Diagram).AxisX.NumericScaleOptions.AutoGrid = false;
//Title
((XYDiagram)arg_chart.Diagram).AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)arg_chart.Diagram).AxisX.Title.Text = "";
if (iCount > 2)
{
((XYDiagram)arg_chart.Diagram).AxisX.Label.Font = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
}
else
{
((XYDiagram)arg_chart.Diagram).AxisX.Label.Font = new System.Drawing.Font("Tahoma", 10F, System.Drawing.FontStyle.Bold);
}
((XYDiagram)arg_chart.Diagram).AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)arg_chart.Diagram).AxisY.Title.TextColor = Color.Orange;
((XYDiagram)arg_chart.Diagram).AxisY.Title.Text = "Lead Time";
((XYDiagram)arg_chart.Diagram).AxisY.Title.Font = new System.Drawing.Font("Tahoma", 16F, System.Drawing.FontStyle.Bold);
((XYDiagram)arg_chart.Diagram).AxisY.Label.Font = new System.Drawing.Font("Tahoma", 10F, System.Drawing.FontStyle.Bold);
//((XYDiagram)arg_chart.Diagram).AxisY.WholeRange.Auto = true;
// ((XYDiagram)arg_chart.Diagram).AxisY.WholeRange.SetMinMaxValues(0, 2);
//Animation Series
lineSeriesView1.Color = System.Drawing.Color.DarkOrange;
xySeriesUnwindAnimation1.EasingFunction = powerEasingFunction1;
lineSeriesView1.SeriesAnimation = xySeriesUnwindAnimation1;
((XYDiagram)arg_chart.Diagram).AxisY.Label.TextPattern = "{V:#,0.##}";
//Label
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False;
series1.Label.TextPattern = "{V:#,#}";
(series1.Label as SideBySideBarSeriesLabel).Position = DevExpress.XtraCharts.BarSeriesLabelPosition.Top;
series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False;
series2.Label.TextPattern = "{V:#,#}";
// Add a title to the chart (if necessary).
ChartTitle chartTitle1 = new ChartTitle();
chartTitle1.Font = new System.Drawing.Font("Calibri", 20F, System.Drawing.FontStyle.Bold);
chartTitle1.Text = arg_dt.Rows[0]["CHART_TITLE"].ToString();
arg_chart.Titles.Add(chartTitle1);
// Add the chart to the form.
pnMain.Controls.Add(arg_chart);
}
