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); }