/// <summary>
/// 设置图表标题
/// </summary>
/// <param name="control">图表控件</param>
/// /// <param name="isVisible">标题是否可见</param>
/// <param name="text">标题文本</param>
/// <param name="isWordWrop">是否换行</param>
/// <param name="maxLineCount">最大允许行数</param>
/// <param name="alignment">对齐方式</param>
/// <param name="dock">位置</param>
/// <param name="isAntialiasing">是否允许设置外观</param>
/// <param name="font">字体</param>
/// <param name="textColor">文本颜色</param>
/// <param name="indent">字体缩进值</param>
public static void SetChartTitle(DevExpress.XtraCharts.ChartControl control, bool isVisible, String text, bool isWordWrop, int maxLineCount, StringAlignment alignment, ChartTitleDockStyle dock, bool isAntialiasing, Font font, Color textColor, int indent)
{
//设置标题
ChartTitle title = new ChartTitle();
title.Visible = isVisible;
//显示文本
title.Text = text;
//是否允许换行
title.WordWrap = isWordWrop;
//最大允许行数
title.MaxLineCount = maxLineCount;
//对齐方式
title.Alignment = alignment;
//位置
title.Dock = dock;
//是否允许设置外观
title.Antialiasing = isAntialiasing;
//字体
title.Font = font;
//字体颜色
title.TextColor = textColor;
//缩进值
title.Indent = indent;
control.Titles.Add(title);
}
private void InitDataChart(string sChart, DevExpress.XtraCharts.ChartControl ChartControl, DataTable dt)
{
try
{
DataTable dtChart = null;
switch (sChart)
{
case "TOT":
if (dt.Select("SUP_CD = 'TOT'").Count() > 0)
{
dtChart = dt.Select("SUP_CD = 'TOT'").CopyToDataTable();
}
break;
default:
if (dt.Select("SUP_CD = '" + sChart + "'").Count() > 0)
{
dtChart = dt.Select("SUP_CD = '" + sChart + "'").CopyToDataTable();
}
break;
}
Series series1 = new Series("REPLENISHMENT", ViewType.Bar);
Series series2 = new Series("C.GRADE RETURN", ViewType.Bar);
Series series3 = new Series("%", ViewType.Spline);
if (dtChart != null && dtChart.Rows.Count > 0)
{
for (int i = 0; i < dtChart.Rows.Count; i++)
{
series1.Points.Add(new SeriesPoint(dtChart.Rows[i]["STYLE_NAME"].ToString(), dtChart.Rows[i]["QTY"]));
series2.Points.Add(new SeriesPoint(dtChart.Rows[i]["STYLE_NAME"].ToString(), dtChart.Rows[i]["R_QTY"]));
series3.Points.Add(new SeriesPoint(dtChart.Rows[i]["STYLE_NAME"].ToString(), dtChart.Rows[i]["RATE"]));
if (Convert.ToDouble(dtChart.Rows[i]["QTY"]) == Convert.ToDouble(dtChart.Rows[i]["R_QTY"]))
{
series1.Points[i].Color = Color.Green;
series2.Points[i].Color = Color.Green;
}
else
{
series1.Points[i].Color = System.Drawing.Color.FromArgb(255, 128, 0);
series2.Points[i].Color = System.Drawing.Color.DodgerBlue;
}
}
}
else
{
series1.Points.Add(new SeriesPoint("", 0));
series2.Points.Add(new SeriesPoint("", 0));
series3.Points.Add(new SeriesPoint("", 0));
}
ChartControl.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1, series2, series3 };
}
catch { }
finally
{
((XYDiagram)ChartControl.Diagram).AxisY.WholeRange.Auto = false;
((XYDiagram)ChartControl.Diagram).AxisY.WholeRange.MaxValueSerializable = "100";
((XYDiagram)ChartControl.Diagram).AxisY.WholeRange.MinValueSerializable = "0";
}
}
/// <summary>
/// Inicializace objektu ChartControl = objekt zobrazující graf
/// </summary>
private void InitChart()
{
_ChartControl = new DevExpress.XtraCharts.ChartControl()
{
Dock = DockStyle.Fill
};
_MainSplitContainer.Panel2.Controls.Add(_ChartControl);
}
public static void ChangeChartTitle(DevExpress.XtraCharts.ChartControl chart, string title)
{
ChartTitle chartTitle1 = new ChartTitle();
chartTitle1.Text = title;
chart.Titles.Clear();
chart.Titles.AddRange(new ChartTitle[] { chartTitle1 });
}
private void bindingdatachart(DevExpress.XtraCharts.ChartControl _chart, DataTable dt, string col1, string col2)
{
_chart.DataSource = dt;
_chart.Series[0].ArgumentDataMember = "DAY";
_chart.Series[0].ValueDataMembers.AddRange(new string[] { col1 });
//chartControl1.Series[0].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Numerical;
_chart.Series[1].ArgumentDataMember = "DAY";
_chart.Series[1].ValueDataMembers.AddRange(new string[] { col2 });
//chartControl1.Series[1].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Numerical;
}
private void CreateDifferenceChart(DevExpress.XtraCharts.ChartControl control, string ColumnName)
{
try
{
DataTable stable = ResultTable;
ChartControl chartControl1 = control;
double BegMeasure = stable.AsEnumerable().Min(x => Convert.ToDouble(x[EvConfig.IMUAlignmentMeasureField]));
double endMeasure = stable.AsEnumerable().Max(x => Convert.ToDouble(x[EvConfig.IMUAlignmentMeasureField]));
chartControl1.Series.Clear();
DevExpress.XtraCharts.Series series = new DevExpress.XtraCharts.Series(ColumnName, ViewType.RangeBar);
series.ShowInLegend = false;
foreach (DataRow r in stable.Rows)
{
double m; double z;
if (r[ColumnName] == DBNull.Value)
continue;
m = Math.Round(Math.Abs(Convert.ToDouble(r[EvConfig.IMUAlignmentMeasureField])), 2);
z = Math.Round(Math.Abs(Convert.ToDouble(r[ColumnName])), 2);
series.Points.Add(new SeriesPoint(m, z,-1));
}
// System.Windows.Forms.DataVisualization.Charting.Chart chart1 = new System.Windows.Forms.DataVisualization.Charting.Chart();
chartControl1.Series.Add(series);
chartControl1.Titles.Clear();
((XYDiagram)chartControl1.Diagram).SecondaryAxesY.Clear();
((XYDiagram)chartControl1.Diagram).AxisX.VisualRange.SetMinMaxValues(BegMeasure, endMeasure);
XYDiagram diagram = ((XYDiagram)chartControl1.Diagram);
// Customize the appearance of the X-axis title.
diagram.AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
diagram.AxisX.Title.Alignment = StringAlignment.Center;
diagram.AxisX.Title.Text = "匹配异常里程";
diagram.AxisX.Title.TextColor = Color.Black;
diagram.AxisX.Title.EnableAntialiasing = DevExpress.Utils.DefaultBoolean.True;
diagram.AxisX.Title.Font = new Font("Tahoma", 9, FontStyle.Regular);
// Customize the appearance of the Y-axis title.
diagram.AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True;
diagram.AxisY.Title.Alignment = StringAlignment.Center;
diagram.AxisY.Title.Text = ColumnName;
diagram.AxisY.Title.TextColor = Color.Black;
diagram.AxisY.Title.EnableAntialiasing = DevExpress.Utils.DefaultBoolean.True;
diagram.AxisY.Title.Font = new Font("Tahoma", 9, FontStyle.Regular);
//((XYDiagram)chartControl1.Diagram).AxisX.Title.Text = "对齐里程";
//((XYDiagram)chartControl1.Diagram).AxisY.Title.Text = "特征点里程差";
}
catch (SystemException ex)
{
MessageBox.Show(ex.Message);
}
// return image;
}
private void InitChart(string sChart, DataTable dt, DevExpress.XtraCharts.ChartControl chartControl)
{
try
{
var sTitle = new List <string>();
int mLineStart = Convert.ToInt32(line.Equals("099") ? mline : line);
if (mLineStart == 3)
{
mLineStart = 2;
}
else if (mLineStart == 2)
{
mLineStart = 3;
}
if (!sChart.Equals("UPC"))
{
switch (line)
{
case "001":
case "002":
case "003":
case "004":
case "005":
case "006":
for (int i = 1; i <= 3; i++)
{
sTitle.Add("Stitching " + ((mLineStart - 1) * 3 + i).ToString());
}
break;
default:
for (int i = 1; i <= 2; i++)
{
sTitle.Add("Stitching " + ((mLineStart - 1) * 2 + i).ToString());
}
break;
}
}
DevExpress.XtraCharts.ChartTitle chartTitle = new DevExpress.XtraCharts.ChartTitle();
chartControl.DataSource = dt.Select("HMS <>'TOTAL'").CopyToDataTable();
chartControl.Series[0].ArgumentDataMember = "HMS";
chartControl.Series[0].ValueDataMembers.AddRange(new string[] { sChart + "_RATE1" });
((DevExpress.XtraCharts.XYDiagram)chartControl.Diagram).AxisX.QualitativeScaleOptions.AutoGrid = false;
if (!sChart.Equals("UPC"))
{
chartTitle.Text = sTitle[Convert.ToInt32(sChart.Substring(3, 1)) - 1];
chartControl.Titles.Clear();
chartControl.Titles.AddRange(new DevExpress.XtraCharts.ChartTitle[] { chartTitle });
}
}
catch { }
finally {
BindingGauge(dt);
}
}
/// <summary>
/// 为X轴添加标题
/// </summary>
/// <param name="control">图形控件</param>
/// <param name="isVisible">标题是否可见</param>
/// <param name="aligment">对齐方式</param>
/// <param name="text">标题显示文本</param>
/// <param name="color">标题字体颜色</param>
/// <param name="isAntialiasing">是否允许设置外观</param>
/// <param name="font">字体</param>
public static void SetAxisY(DevExpress.XtraCharts.ChartControl control, bool isVisible, StringAlignment aligment, string text, Color color, bool isAntialiasing, Font font)
{
XYDiagram xydiagram = (XYDiagram)control.Diagram;
xydiagram.AxisY.Title.Visible = isVisible;
xydiagram.AxisY.Title.Alignment = aligment;
xydiagram.AxisY.Title.Text = text;
xydiagram.AxisY.Title.TextColor = color;
xydiagram.AxisY.Title.Antialiasing = isAntialiasing;
xydiagram.AxisY.Title.Font = font;
}
private void InitChart(string sChart, DataTable dt, DevExpress.XtraCharts.ChartControl chartControl)
{
try
{
chartControl.DataSource = dt;
chartControl.Series[0].ArgumentDataMember = "DAY";
chartControl.Series[0].ValueDataMembers.AddRange(new string[] { sChart + "_TAR" });
chartControl.Series[1].ArgumentDataMember = "DAY";
chartControl.Series[1].ValueDataMembers.AddRange(new string[] { sChart + "_ACT" });
}
catch { }
}
private void InitDataChart(string sChart, DevExpress.XtraCharts.ChartControl ChartControl, DataTable dt)
{
try
{
DataTable dtChart;
switch (sChart)
{
case "TOT":
dtChart = dt.Select("SUP_CD = 'TOT'").CopyToDataTable();
break;
default:
dtChart = dt.Select("SUP_CD = '" + sChart + "'").CopyToDataTable();
break;
}
Series series1 = new Series("REPLENISHMENT", ViewType.Bar);
Series series2 = new Series("C.GRADE RETURN", ViewType.Bar);
Series series3 = new Series("%", ViewType.Spline);
for (int i = 0; i < dtChart.Rows.Count; i++)
{
series1.Points.Add(new SeriesPoint(dtChart.Rows[i]["STYLE_NAME"].ToString(), dtChart.Rows[i]["QTY"]));
series2.Points.Add(new SeriesPoint(dtChart.Rows[i]["STYLE_NAME"].ToString(), dtChart.Rows[i]["R_QTY"]));
series3.Points.Add(new SeriesPoint(dtChart.Rows[i]["STYLE_NAME"].ToString(), dtChart.Rows[i]["RATE"]));
if (Convert.ToDouble(dtChart.Rows[i]["QTY"]) == Convert.ToDouble(dtChart.Rows[i]["R_QTY"]))
{
series1.Points[i].Color = Color.Green;
series2.Points[i].Color = Color.Green;
}
else
{
series1.Points[i].Color = System.Drawing.Color.FromArgb(255, 128, 0);
series2.Points[i].Color = System.Drawing.Color.DodgerBlue;
}
}
ChartControl.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1, series2, series3 };
//ChartControl.DataSource = dtChart;
//ChartControl.Series[0].ArgumentDataMember = "STYLE_NAME";
//ChartControl.Series[0].ValueDataMembers.AddRange(new string[] { "QTY" });
//ChartControl.Series[1].ArgumentDataMember = "STYLE_NAME";
//ChartControl.Series[1].ValueDataMembers.AddRange(new string[] { "R_QTY" });
//ChartControl.Series[2].ArgumentDataMember = "STYLE_NAME";
//ChartControl.Series[2].ValueDataMembers.AddRange(new string[] { "RATE" });
}
catch { }
}
private void InitChart(string sChart, DataTable dt, DevExpress.XtraCharts.ChartControl chartControl)
{
try
{
var sTitle = new List <string>();
//int mLineStart = Convert.ToInt32(line.Equals("202") ? mline : line);
//if (mLineStart == 3)
// mLineStart = 2;
//else if (mLineStart == 2)
// mLineStart = 3;
//if (!sChart.Equals("UPC"))
//{
// switch (line)
// {
// case "001":
// case "002":
// case "003":
// case "004":
// case "005":
// case "006":
// for (int i = 1; i <= 3; i++)
// sTitle.Add("Stitching " + ((mLineStart - 1) * 3 + i).ToString());
// break;
// default:
// for (int i = 1; i <= 2; i++)
// sTitle.Add("Stitching " + ((mLineStart - 1) * 2 + i).ToString());
// break;
// }
//}
DevExpress.XtraCharts.ChartTitle chartTitle = new DevExpress.XtraCharts.ChartTitle();
chartControl.DataSource = dt.Select("DAY <> 'AVG'", "DAY").CopyToDataTable();
chartControl.Series[1].ArgumentDataMember = "DAY";
chartControl.Series[1].ValueDataMembers.AddRange(new string[] { sChart + "_TAR" });
chartControl.Series[0].ArgumentDataMember = "DAY";
chartControl.Series[0].ValueDataMembers.AddRange(new string[] { sChart + "_ACT" });
((DevExpress.XtraCharts.XYDiagram)chartControl.Diagram).AxisX.QualitativeScaleOptions.AutoGrid = false;
if (!sChart.Equals("UPC"))
{
chartTitle.Text = sTitle[Convert.ToInt32(sChart.Substring(3, 1)) - 1];
chartControl.Titles.Clear();
chartControl.Titles.AddRange(new DevExpress.XtraCharts.ChartTitle[] { chartTitle });
}
}
catch { }
finally { BindingGauge(dt); }
}
private void InitChart(string sChart, DataTable dt, DevExpress.XtraCharts.ChartControl chartControl)
{
try
{
chartControl.DataSource = dt.Select("DAY <> 'AVG'", "DAY").CopyToDataTable();
chartControl.Series[1].ArgumentDataMember = "DAY";
chartControl.Series[1].ValueDataMembers.AddRange(new string[] { sChart + "_TAR" });
chartControl.Series[0].ValueDataMembers.AddRange(new string[] { sChart + "_ACT" });
chartControl.Series[0].ArgumentDataMember = "DAY";
((DevExpress.XtraCharts.XYDiagram)chartControl.Diagram).AxisX.QualitativeScaleOptions.AutoGrid = false;
}
catch { }
finally
{
BindingGauge(dt);
}
}
public void BindingDxChartControl(DevExpress.XtraCharts.ChartControl chartControl, List <ChartSeriesInfo> seriesList)
{
try
{
if (seriesList != null && seriesList.Count > 0)
{
foreach (ChartSeriesInfo seriesInfo in seriesList)
{
ViewType viewType = ViewType.Bar;
try {
viewType = (ViewType)Enum.Parse(typeof(ViewType), seriesInfo.ViewType, true);
}
catch {
//ignore the exception
}
DevExpress.XtraCharts.Series newSeries = new DevExpress.XtraCharts.Series(seriesInfo.Name, viewType);
if (!string.IsNullOrEmpty(seriesInfo.ArgumentDataMember))
{
newSeries.ArgumentDataMember = seriesInfo.ArgumentDataMember;
newSeries.ValueDataMembers.AddRange(seriesInfo.ValueDataMember);
newSeries.ValueScaleType = (ScaleType)Enum.Parse(typeof(ScaleType), seriesInfo.ViewType);
newSeries.View.Color = seriesInfo.Color;
}
else if (seriesInfo.SeriesPoints != null && seriesInfo.SeriesPoints.Count > 0)
{
foreach (ChartSeriesPointInfo point in seriesInfo.SeriesPoints)
{
newSeries.Points.Add(new SeriesPoint(point.Argument, point.ValueParams));
}
}
chartControl.Series.Add(newSeries);
}
}
chartControl.RefreshData();
}
catch (Exception ex)
{
MB.Util.TraceEx.Write(ex.StackTrace);
throw new MB.Util.APPException(ex.Message, Util.APPMessageType.SysErrInfo);
}
}
private void InitChart(string sChart, DataTable dt, DevExpress.XtraCharts.ChartControl chartControl)
{
try
{
var sTitle = new List <string>();
DevExpress.XtraCharts.ChartTitle chartTitle = new DevExpress.XtraCharts.ChartTitle();
chartControl.DataSource = dt.Select("HMS <>'TOTAL'").CopyToDataTable();
chartControl.Series[1].ArgumentDataMember = "HMS";
chartControl.Series[1].ValueDataMembers.AddRange(new string[] { sChart + "_TAR" });
chartControl.Series[0].ArgumentDataMember = "HMS";
chartControl.Series[0].ValueDataMembers.AddRange(new string[] { sChart + "_ACT" });
chartTitle.Text = sTitle[Convert.ToInt32(sChart.Substring(3, 1)) - 1];
chartControl.Titles.Clear();
chartControl.Titles.AddRange(new DevExpress.XtraCharts.ChartTitle[] { chartTitle });
((DevExpress.XtraCharts.XYDiagram)chartControl.Diagram).AxisX.QualitativeScaleOptions.AutoGrid = false;
}
catch { }
}
/// <summary>
/// 绘制图形
/// </summary>
/// <param name="control">图表控件</param>
/// <param name="seriesName">系列名</param>
/// <param name="type">类型</param>
/// <param name="dt">数据源</param>
/// <param name="column1"></param>
/// <param name="column2"></param>
public static void DrawChart(DevExpress.XtraCharts.ChartControl control, string seriesName, ViewType type, DataTable dt, string column1, string column2)
{
Series series = new Series(seriesName, type);
DataTable table = dt;
SeriesPoint point = null;
for (int i = 0; i < table.Rows.Count; i++)
{
if (string.IsNullOrEmpty(table.Rows[i][column2].ToString()))
{
point = new SeriesPoint(table.Rows[i][column1].ToString(), 0);
}
else
{
point = new SeriesPoint(table.Rows[i][column1].ToString(), Convert.ToDouble(table.Rows[i][column2].ToString()));
}
series.Points.Add(point);
}
SideBySideBarSeriesLabel label = series.Label as SideBySideBarSeriesLabel;
series.LabelsVisibility = DefaultBoolean.True;
label.Position = BarSeriesLabelPosition.Center;
BarSeriesView barview = series.View as BarSeriesView;
barview.BarWidth = 0.3;
control.Series.Add(series);
//针对饼图的特殊处理
if (type == ViewType.Pie)
{
//设置显示方式(Argument:显示图例说明，ArgumentAndValues:显示图例内容和数据)
series.Label.PointOptions.PointView = PointView.ArgumentAndValues;
//设置数据显示形式(Percent:百分比,Currency:货币类型，数据前添加￥,Scientific:科学计数法)
series.Label.PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;
//数据是否保留小数(0：不保留小数位，1保留一位小数，2保留两位小数)
series.Label.PointOptions.ValueNumericOptions.Precision = 0;
//数据以百分比显示时只能是Default和None
((PieSeriesLabel)series.Label).ResolveOverlappingMode = ResolveOverlappingMode.Default;
}
}
private void InitializeComponent()
{
this.layoutControl1 = new DevExpress.XtraLayout.LayoutControl();
this.chartControl1 = new DevExpress.XtraCharts.ChartControl();
this.comboBoxEdit1 = new DevExpress.XtraEditors.ComboBoxEdit();
this.layoutControlGroup1 = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlItem1 = new DevExpress.XtraLayout.LayoutControlItem();
this.layoutControlItem2 = new DevExpress.XtraLayout.LayoutControlItem();
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit();
this.layoutControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.chartControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.comboBoxEdit1.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).BeginInit();
this.SuspendLayout();
//
// layoutControl1
//
this.layoutControl1.Controls.Add(this.chartControl1);
this.layoutControl1.Controls.Add(this.comboBoxEdit1);
this.layoutControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.layoutControl1.Location = new System.Drawing.Point(0, 0);
this.layoutControl1.Name = "layoutControl1";
this.layoutControl1.Root = this.layoutControlGroup1;
this.layoutControl1.Size = new System.Drawing.Size(920, 491);
this.layoutControl1.TabIndex = 0;
this.layoutControl1.Text = "layoutControl1";
//
// chartControl1
//
this.chartControl1.Location = new System.Drawing.Point(12, 38);
this.chartControl1.Name = "chartControl1";
this.chartControl1.SeriesSerializable = new DevExpress.XtraCharts.Series[0];
this.chartControl1.Size = new System.Drawing.Size(896, 441);
this.chartControl1.TabIndex = 5;
//
// comboBoxEdit1
//
this.comboBoxEdit1.Location = new System.Drawing.Point(12, 12);
this.comboBoxEdit1.Name = "comboBoxEdit1";
this.comboBoxEdit1.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
});
this.comboBoxEdit1.Size = new System.Drawing.Size(896, 22);
this.comboBoxEdit1.StyleController = this.layoutControl1;
this.comboBoxEdit1.TabIndex = 4;
this.comboBoxEdit1.SelectedIndexChanged += new System.EventHandler(this.comboBoxEdit1_SelectedIndexChanged);
//
// layoutControlGroup1
//
this.layoutControlGroup1.CustomizationFormText = "layoutControlGroup1";
this.layoutControlGroup1.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;
this.layoutControlGroup1.GroupBordersVisible = false;
this.layoutControlGroup1.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
this.layoutControlItem1,
this.layoutControlItem2
});
this.layoutControlGroup1.Location = new System.Drawing.Point(0, 0);
this.layoutControlGroup1.Name = "layoutControlGroup1";
this.layoutControlGroup1.Size = new System.Drawing.Size(920, 491);
this.layoutControlGroup1.Text = "layoutControlGroup1";
this.layoutControlGroup1.TextVisible = false;
//
// layoutControlItem1
//
this.layoutControlItem1.Control = this.comboBoxEdit1;
this.layoutControlItem1.CustomizationFormText = "layoutControlItem1";
this.layoutControlItem1.Location = new System.Drawing.Point(0, 0);
this.layoutControlItem1.Name = "layoutControlItem1";
this.layoutControlItem1.Size = new System.Drawing.Size(900, 26);
this.layoutControlItem1.Text = "layoutControlItem1";
this.layoutControlItem1.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItem1.TextToControlDistance = 0;
this.layoutControlItem1.TextVisible = false;
//
// layoutControlItem2
//
this.layoutControlItem2.Control = this.chartControl1;
this.layoutControlItem2.CustomizationFormText = "layoutControlItem2";
this.layoutControlItem2.Location = new System.Drawing.Point(0, 26);
this.layoutControlItem2.Name = "layoutControlItem2";
this.layoutControlItem2.Size = new System.Drawing.Size(900, 445);
this.layoutControlItem2.Text = "layoutControlItem2";
this.layoutControlItem2.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItem2.TextToControlDistance = 0;
this.layoutControlItem2.TextVisible = false;
//
// FrmStatasByRoadChart2D
//
this.ClientSize = new System.Drawing.Size(920, 491);
this.Controls.Add(this.layoutControl1);
this.Name = "FrmStatasByRoadChart2D";
this.ShowIcon = false;
this.Text = "道路统计图表";
this.Load += new System.EventHandler(this.FrmStatasByRoadChart2D_Load);
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).EndInit();
this.layoutControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.chartControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.comboBoxEdit1.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).EndInit();
this.ResumeLayout(false);
}
public void InitPanel(DevExpress.XtraPivotGrid.PivotGridControl pivotGridCntrol, DevExpress.XtraCharts.ChartControl chartCntrol)
{
this.pivotGridCntrol = pivotGridCntrol;
this.chartCntrol = chartCntrol;
#region ChartInitialization
pivotGridCntrol.OptionsChartDataSource.ProvideDataByColumns = ceChartDataVertical.Checked;
pivotGridCntrol.OptionsChartDataSource.SelectionOnly = ceSelectionOnly.Checked;
pivotGridCntrol.OptionsChartDataSource.ProvideColumnGrandTotals = ceShowColumnGrandTotals.Checked;
pivotGridCntrol.OptionsChartDataSource.ProvideRowGrandTotals = ceShowRowGrandTotals.Checked;
ChartCntrol.SeriesTemplate.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;// = this.checkShowPointLabels.Checked;
ViewType[] restrictedTypes = new ViewType[] { ViewType.PolarArea, ViewType.PolarLine, ViewType.SideBySideGantt,
ViewType.SideBySideRangeBar, ViewType.RangeBar, ViewType.Gantt, ViewType.PolarPoint, ViewType.Stock, ViewType.CandleStick,
ViewType.Bubble };
foreach (ViewType type in Enum.GetValues(typeof(ViewType)))
{
if (Array.IndexOf <ViewType>(restrictedTypes, type) >= 0)
{
continue;
}
comboChartType.Properties.Items.Add(type);
}
comboChartType.SelectedItem = ViewType.Pie;
#endregion
#region BuildColorsComboBox
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Apex", "Color set #01");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Black and White", "Color set #02");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Chameleon", "Color set #03");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Civic", "Color set #04");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Concourse", "Color set #05");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Equity", "Color set #05");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Flow", "Color set #06");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Foundry", "Color set #07");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Grayscale", "Color set #08");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("In A Fog", "Color set #09");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Median", "Color set #10");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Metro", "Color set #11");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Mixed", "Color set #12");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Module", "Color set #13");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Nature Colors", "Color set #14");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Northern Lights", "Color set #15");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Office", "Color set #16");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Opulent", "Color set #17");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Oriel", "Color set #18");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Origin", "Color set #19");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Paper", "Color set #20");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Pastel Kit", "Color set #21");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Solstice", "Color set #22");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Technic", "Color set #23");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Terracotta Pie", "Color set #24");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("The Trees", "Color set #25");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Trek", "Color set #26");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Urban", "Color set #27");
appServicesDataSet.ChartPaletteDataTable.AddChartPaletteDataTableRow("Verve", "Color set #28");
chartPaletteDataTableBindingSource.EndEdit();
#endregion
}
private void InitializeComponent()
{
DevExpress.XtraCharts.PieSeriesLabel pieSeriesLabel1 = new DevExpress.XtraCharts.PieSeriesLabel();
DevExpress.XtraCharts.PiePointOptions piePointOptions1 = new DevExpress.XtraCharts.PiePointOptions();
DevExpress.XtraCharts.PieSeriesView pieSeriesView1 = new DevExpress.XtraCharts.PieSeriesView();
this.layoutControl1 = new DevExpress.XtraLayout.LayoutControl();
this.chartControl2 = new DevExpress.XtraCharts.ChartControl();
this.chartControl1 = new DevExpress.XtraCharts.ChartControl();
this.layoutControlGroup1 = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlGroup3 = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlItem2 = new DevExpress.XtraLayout.LayoutControlItem();
this.layoutControlGroup2 = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlItem1 = new DevExpress.XtraLayout.LayoutControlItem();
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit();
this.layoutControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.chartControl2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(pieSeriesLabel1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(pieSeriesView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.chartControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).BeginInit();
this.SuspendLayout();
//
// layoutControl1
//
this.layoutControl1.Controls.Add(this.chartControl2);
this.layoutControl1.Controls.Add(this.chartControl1);
this.layoutControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.layoutControl1.Location = new System.Drawing.Point(0, 0);
this.layoutControl1.Name = "layoutControl1";
this.layoutControl1.Root = this.layoutControlGroup1;
this.layoutControl1.Size = new System.Drawing.Size(523, 435);
this.layoutControl1.TabIndex = 0;
this.layoutControl1.Text = "layoutControl1";
//
// chartControl2
//
this.chartControl2.Location = new System.Drawing.Point(5, 272);
this.chartControl2.Name = "chartControl2";
this.chartControl2.SeriesSerializable = new DevExpress.XtraCharts.Series[0];
piePointOptions1.ValueNumericOptions.Format = DevExpress.XtraCharts.NumericFormat.General;
pieSeriesLabel1.PointOptions = piePointOptions1;
this.chartControl2.SeriesTemplate.Label = pieSeriesLabel1;
pieSeriesView1.ExplodeMode = DevExpress.XtraCharts.PieExplodeMode.MinValue;
pieSeriesView1.RuntimeExploding = true;
this.chartControl2.SeriesTemplate.View = pieSeriesView1;
this.chartControl2.Size = new System.Drawing.Size(513, 158);
this.chartControl2.TabIndex = 5;
//
// chartControl1
//
this.chartControl1.Legend.Visible = false;
this.chartControl1.Location = new System.Drawing.Point(5, 25);
this.chartControl1.Name = "chartControl1";
this.chartControl1.SeriesSerializable = new DevExpress.XtraCharts.Series[0];
this.chartControl1.Size = new System.Drawing.Size(513, 217);
this.chartControl1.TabIndex = 4;
//
// layoutControlGroup1
//
this.layoutControlGroup1.CustomizationFormText = "layoutControlGroup1";
this.layoutControlGroup1.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;
this.layoutControlGroup1.GroupBordersVisible = false;
this.layoutControlGroup1.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
this.layoutControlGroup3,
this.layoutControlGroup2
});
this.layoutControlGroup1.Location = new System.Drawing.Point(0, 0);
this.layoutControlGroup1.Name = "layoutControlGroup1";
this.layoutControlGroup1.Padding = new DevExpress.XtraLayout.Utils.Padding(0, 0, 0, 0);
this.layoutControlGroup1.Size = new System.Drawing.Size(523, 435);
this.layoutControlGroup1.Text = "layoutControlGroup1";
this.layoutControlGroup1.TextVisible = false;
//
// layoutControlGroup3
//
this.layoutControlGroup3.CustomizationFormText = "饼状图";
this.layoutControlGroup3.ExpandButtonLocation = DevExpress.Utils.GroupElementLocation.AfterText;
this.layoutControlGroup3.ExpandButtonVisible = true;
this.layoutControlGroup3.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
this.layoutControlItem2
});
this.layoutControlGroup3.Location = new System.Drawing.Point(0, 247);
this.layoutControlGroup3.Name = "layoutControlGroup3";
this.layoutControlGroup3.Padding = new DevExpress.XtraLayout.Utils.Padding(0, 0, 0, 0);
this.layoutControlGroup3.Size = new System.Drawing.Size(523, 188);
this.layoutControlGroup3.Text = "饼状图";
//
// layoutControlItem2
//
this.layoutControlItem2.Control = this.chartControl2;
this.layoutControlItem2.CustomizationFormText = "layoutControlItem2";
this.layoutControlItem2.Location = new System.Drawing.Point(0, 0);
this.layoutControlItem2.Name = "layoutControlItem2";
this.layoutControlItem2.Size = new System.Drawing.Size(517, 162);
this.layoutControlItem2.Text = "layoutControlItem2";
this.layoutControlItem2.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItem2.TextToControlDistance = 0;
this.layoutControlItem2.TextVisible = false;
//
// layoutControlGroup2
//
this.layoutControlGroup2.CustomizationFormText = "统计图";
this.layoutControlGroup2.ExpandButtonLocation = DevExpress.Utils.GroupElementLocation.AfterText;
this.layoutControlGroup2.ExpandButtonVisible = true;
this.layoutControlGroup2.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
this.layoutControlItem1
});
this.layoutControlGroup2.Location = new System.Drawing.Point(0, 0);
this.layoutControlGroup2.Name = "layoutControlGroup2";
this.layoutControlGroup2.Padding = new DevExpress.XtraLayout.Utils.Padding(0, 0, 0, 0);
this.layoutControlGroup2.Size = new System.Drawing.Size(523, 247);
this.layoutControlGroup2.Text = "柱状图";
//
// layoutControlItem1
//
this.layoutControlItem1.Control = this.chartControl1;
this.layoutControlItem1.CustomizationFormText = "layoutControlItem1";
this.layoutControlItem1.Location = new System.Drawing.Point(0, 0);
this.layoutControlItem1.Name = "layoutControlItem1";
this.layoutControlItem1.Size = new System.Drawing.Size(517, 221);
this.layoutControlItem1.Text = "layoutControlItem1";
this.layoutControlItem1.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItem1.TextToControlDistance = 0;
this.layoutControlItem1.TextVisible = false;
//
// UCPipeNodeStatsChart
//
this.Controls.Add(this.layoutControl1);
this.Name = "UCPipeNodeStatsChart";
this.Size = new System.Drawing.Size(523, 435);
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).EndInit();
this.layoutControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(pieSeriesLabel1)).EndInit();
((System.ComponentModel.ISupportInitialize)(pieSeriesView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.chartControl2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.chartControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).EndInit();
this.ResumeLayout(false);
}
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 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 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(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 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 CreateChart(DevExpress.XtraCharts.ChartControl Chart, DataTable dt, string col)
{
try
{
Chart.Series.Clear();
//Chart.Titles.Clear();
Chart.AppearanceNameSerializable = "Chameleon";
Chart.AnimationStartMode = DevExpress.XtraCharts.ChartAnimationMode.OnDataChanged;
DevExpress.XtraCharts.LineSeriesView lineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView();
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView = new DevExpress.XtraCharts.SideBySideBarSeriesView();
lineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
lineSeriesView1.Color = System.Drawing.Color.LimeGreen;
lineSeriesView1.LineMarkerOptions.Color = System.Drawing.Color.FromArgb(((int)(((byte)(146)))), ((int)(((byte)(208)))), ((int)(((byte)(80)))));
lineSeriesView1.LineStyle.Thickness = 3;
sideBySideBarSeriesView.ColorEach = false;
sideBySideBarSeriesView.FillStyle.FillMode = DevExpress.XtraCharts.FillMode.Solid;
string[] value = null;
Chart.Series.Add("Target", ViewType.Line);
Chart.Series[0].View = lineSeriesView1;
if (dt != null && dt.Rows.Count > 0)
{
for (int i_col = 3; i_col < dt.Columns.Count; i_col++)
{
Chart.Series.Add(line.Substring(0, 3) == "TOT" ? "Lean " + dt.Columns[i_col].ColumnName.Replace("'", "") : "Line " + dt.Columns[i_col].ColumnName.Replace("'", ""), ViewType.Bar);
for (int i = 0; i < dt.Rows.Count; i++)
{
Chart.Series[i_col - 2].View.Color = System.Drawing.Color.ForestGreen;
Chart.Series[i_col - 2].View = sideBySideBarSeriesView;
if (dt.Rows[i][i_col].ToString() != "")
{
value = dt.Rows[i][i_col].ToString().Split('/');
//Chart.Series[i - 1].Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), value[0]));
if (Convert.ToDouble(value[0]) > 0)
{
Chart.Series[i_col - 2].Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), Convert.ToDouble(value[0])));
Chart.Series[0].Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), Convert.ToDouble(value[1])));
}
else
{
Chart.Series[i_col - 2].Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString()));
Chart.Series[0].Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), Convert.ToDouble(value[1])));
}
if (Convert.ToDouble(value[0]) < Convert.ToDouble(value[1]))
{
Chart.Series[i_col - 2].Points[i].Color = Color.Red;
}
else
{
Chart.Series[i_col - 2].Points[i].Color = System.Drawing.Color.ForestGreen;
}
}
else
{
Chart.Series[i_col - 2].Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString()));
Chart.Series[0].Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString()));
}
Chart.Series[i_col - 2].LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
Chart.Series[i_col - 2].Label.TextPattern = "{S}";
((SideBySideBarSeriesLabel)Chart.Series[i_col - 2].Label).Position = BarSeriesLabelPosition.Top;
Chart.Series[i_col - 2].Label.TextOrientation = TextOrientation.BottomToTop;
}
}
//Chart.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1 };
//Chart.Legend.Visibility = DevExpress.Utils.DefaultBoolean.True;
//((XYDiagram)Chart.Diagram).AxisX.Label.Font = new System.Drawing.Font("Calibri", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//((XYDiagram)Chart.Diagram).AxisX.Title.Font = new System.Drawing.Font("Calibri", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//((XYDiagram)Chart.Diagram).AxisY.Label.TextPattern = "{V:#,#}";
//((XYDiagram)Chart.Diagram).AxisY.Label.Font = new System.Drawing.Font("Tahoma", 14F);
//((XYDiagram)Chart.Diagram).AxisY.Title.Font = new System.Drawing.Font("Calibri", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//((XYDiagram)Chart.Diagram).AxisY.Title.Text = "Production (Prs)";
}
}
catch (Exception EX)
{
}
}
private void InitializeComponent()
{
DevExpress.XtraCharts.ChartTitle chartTitle1 = new DevExpress.XtraCharts.ChartTitle();
this.layoutControl1 = new DevExpress.XtraLayout.LayoutControl();
this.xtrTC = new DevExpress.XtraTab.XtraTabControl();
this.xtraTabPage1 = new DevExpress.XtraTab.XtraTabPage();
this.layoutControl2 = new DevExpress.XtraLayout.LayoutControl();
this.btnStatsOutput = new DevExpress.XtraEditors.SimpleButton();
this.chartControl1 = new DevExpress.XtraCharts.ChartControl();
this.comboBoxEdit1 = new DevExpress.XtraEditors.ComboBoxEdit();
this.layoutControlGroup2 = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlItem2 = new DevExpress.XtraLayout.LayoutControlItem();
this.layoutControlItem3 = new DevExpress.XtraLayout.LayoutControlItem();
this.emptySpaceItem1 = new DevExpress.XtraLayout.EmptySpaceItem();
this.emptySpaceItem2 = new DevExpress.XtraLayout.EmptySpaceItem();
this.layoutControlItem4 = new DevExpress.XtraLayout.LayoutControlItem();
this.layoutControlGroup1 = new DevExpress.XtraLayout.LayoutControlGroup();
this.layoutControlItem1 = new DevExpress.XtraLayout.LayoutControlItem();
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit();
this.layoutControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.xtrTC)).BeginInit();
this.xtrTC.SuspendLayout();
this.xtraTabPage1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.layoutControl2)).BeginInit();
this.layoutControl2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.chartControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.comboBoxEdit1.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).BeginInit();
this.SuspendLayout();
//
// layoutControl1
//
this.layoutControl1.Controls.Add(this.xtrTC);
this.layoutControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.layoutControl1.Location = new System.Drawing.Point(0, 0);
this.layoutControl1.Name = "layoutControl1";
this.layoutControl1.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(895, 161, 250, 350);
this.layoutControl1.Root = this.layoutControlGroup1;
this.layoutControl1.Size = new System.Drawing.Size(575, 413);
this.layoutControl1.TabIndex = 0;
this.layoutControl1.Text = "layoutControl1";
//
// xtrTC
//
this.xtrTC.Location = new System.Drawing.Point(2, 2);
this.xtrTC.Name = "xtrTC";
this.xtrTC.SelectedTabPage = this.xtraTabPage1;
this.xtrTC.Size = new System.Drawing.Size(571, 409);
this.xtrTC.TabIndex = 4;
this.xtrTC.TabPages.AddRange(new DevExpress.XtraTab.XtraTabPage[] {
this.xtraTabPage1
});
//
// xtraTabPage1
//
this.xtraTabPage1.Controls.Add(this.layoutControl2);
this.xtraTabPage1.Name = "xtraTabPage1";
this.xtraTabPage1.Size = new System.Drawing.Size(565, 380);
this.xtraTabPage1.Text = "统计图";
//
// layoutControl2
//
this.layoutControl2.Controls.Add(this.btnStatsOutput);
this.layoutControl2.Controls.Add(this.chartControl1);
this.layoutControl2.Controls.Add(this.comboBoxEdit1);
this.layoutControl2.Dock = System.Windows.Forms.DockStyle.Fill;
this.layoutControl2.Location = new System.Drawing.Point(0, 0);
this.layoutControl2.Name = "layoutControl2";
this.layoutControl2.Root = this.layoutControlGroup2;
this.layoutControl2.Size = new System.Drawing.Size(565, 380);
this.layoutControl2.TabIndex = 0;
this.layoutControl2.Text = "layoutControl2";
//
// btnStatsOutput
//
this.btnStatsOutput.Location = new System.Drawing.Point(452, 356);
this.btnStatsOutput.Name = "btnStatsOutput";
this.btnStatsOutput.Size = new System.Drawing.Size(111, 22);
this.btnStatsOutput.StyleController = this.layoutControl2;
this.btnStatsOutput.TabIndex = 6;
this.btnStatsOutput.Text = "输出统计";
this.btnStatsOutput.Click += new System.EventHandler(this.btnStatsOutput_Click);
//
// chartControl1
//
this.chartControl1.Location = new System.Drawing.Point(2, 28);
this.chartControl1.Name = "chartControl1";
this.chartControl1.SeriesSerializable = new DevExpress.XtraCharts.Series[0];
this.chartControl1.Size = new System.Drawing.Size(561, 324);
this.chartControl1.TabIndex = 5;
this.chartControl1.Titles.AddRange(new DevExpress.XtraCharts.ChartTitle[] {
chartTitle1
});
//
// comboBoxEdit1
//
this.comboBoxEdit1.Location = new System.Drawing.Point(440, 2);
this.comboBoxEdit1.Name = "comboBoxEdit1";
this.comboBoxEdit1.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
});
this.comboBoxEdit1.Size = new System.Drawing.Size(123, 22);
this.comboBoxEdit1.StyleController = this.layoutControl2;
this.comboBoxEdit1.TabIndex = 4;
this.comboBoxEdit1.SelectedIndexChanged += new System.EventHandler(this.comboBoxEdit1_SelectedIndexChanged);
//
// layoutControlGroup2
//
this.layoutControlGroup2.CustomizationFormText = "layoutControlGroup2";
this.layoutControlGroup2.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;
this.layoutControlGroup2.GroupBordersVisible = false;
this.layoutControlGroup2.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
this.layoutControlItem2,
this.layoutControlItem3,
this.emptySpaceItem1,
this.emptySpaceItem2,
this.layoutControlItem4
});
this.layoutControlGroup2.Location = new System.Drawing.Point(0, 0);
this.layoutControlGroup2.Name = "layoutControlGroup2";
this.layoutControlGroup2.Padding = new DevExpress.XtraLayout.Utils.Padding(0, 0, 0, 0);
this.layoutControlGroup2.Size = new System.Drawing.Size(565, 380);
this.layoutControlGroup2.Text = "layoutControlGroup2";
this.layoutControlGroup2.TextVisible = false;
//
// layoutControlItem2
//
this.layoutControlItem2.Control = this.comboBoxEdit1;
this.layoutControlItem2.CustomizationFormText = "统计图样式：";
this.layoutControlItem2.Location = new System.Drawing.Point(363, 0);
this.layoutControlItem2.Name = "layoutControlItem2";
this.layoutControlItem2.Size = new System.Drawing.Size(202, 26);
this.layoutControlItem2.Text = "统计图样式：";
this.layoutControlItem2.TextSize = new System.Drawing.Size(72, 14);
//
// layoutControlItem3
//
this.layoutControlItem3.Control = this.chartControl1;
this.layoutControlItem3.CustomizationFormText = "layoutControlItem3";
this.layoutControlItem3.Location = new System.Drawing.Point(0, 26);
this.layoutControlItem3.Name = "layoutControlItem3";
this.layoutControlItem3.Size = new System.Drawing.Size(565, 328);
this.layoutControlItem3.Text = "layoutControlItem3";
this.layoutControlItem3.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItem3.TextToControlDistance = 0;
this.layoutControlItem3.TextVisible = false;
//
// emptySpaceItem1
//
this.emptySpaceItem1.AllowHotTrack = false;
this.emptySpaceItem1.CustomizationFormText = "emptySpaceItem1";
this.emptySpaceItem1.Location = new System.Drawing.Point(0, 0);
this.emptySpaceItem1.Name = "emptySpaceItem1";
this.emptySpaceItem1.Size = new System.Drawing.Size(363, 26);
this.emptySpaceItem1.Text = "emptySpaceItem1";
this.emptySpaceItem1.TextSize = new System.Drawing.Size(0, 0);
//
// emptySpaceItem2
//
this.emptySpaceItem2.AllowHotTrack = false;
this.emptySpaceItem2.CustomizationFormText = "emptySpaceItem2";
this.emptySpaceItem2.Location = new System.Drawing.Point(0, 354);
this.emptySpaceItem2.Name = "emptySpaceItem2";
this.emptySpaceItem2.Size = new System.Drawing.Size(450, 26);
this.emptySpaceItem2.Text = "emptySpaceItem2";
this.emptySpaceItem2.TextSize = new System.Drawing.Size(0, 0);
//
// layoutControlItem4
//
this.layoutControlItem4.Control = this.btnStatsOutput;
this.layoutControlItem4.CustomizationFormText = "layoutControlItem4";
this.layoutControlItem4.Location = new System.Drawing.Point(450, 354);
this.layoutControlItem4.Name = "layoutControlItem4";
this.layoutControlItem4.Size = new System.Drawing.Size(115, 26);
this.layoutControlItem4.Text = "layoutControlItem4";
this.layoutControlItem4.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItem4.TextToControlDistance = 0;
this.layoutControlItem4.TextVisible = false;
//
// layoutControlGroup1
//
this.layoutControlGroup1.CustomizationFormText = "Root";
this.layoutControlGroup1.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;
this.layoutControlGroup1.GroupBordersVisible = false;
this.layoutControlGroup1.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
this.layoutControlItem1
});
this.layoutControlGroup1.Location = new System.Drawing.Point(0, 0);
this.layoutControlGroup1.Name = "Root";
this.layoutControlGroup1.Padding = new DevExpress.XtraLayout.Utils.Padding(0, 0, 0, 0);
this.layoutControlGroup1.Size = new System.Drawing.Size(575, 413);
this.layoutControlGroup1.Text = "Root";
this.layoutControlGroup1.TextVisible = false;
//
// layoutControlItem1
//
this.layoutControlItem1.Control = this.xtrTC;
this.layoutControlItem1.CustomizationFormText = "layoutControlItem1";
this.layoutControlItem1.Location = new System.Drawing.Point(0, 0);
this.layoutControlItem1.Name = "layoutControlItem1";
this.layoutControlItem1.Size = new System.Drawing.Size(575, 413);
this.layoutControlItem1.Text = "layoutControlItem1";
this.layoutControlItem1.TextSize = new System.Drawing.Size(0, 0);
this.layoutControlItem1.TextToControlDistance = 0;
this.layoutControlItem1.TextVisible = false;
//
// FrmPipeStatsChart2D
//
this.ClientSize = new System.Drawing.Size(575, 413);
this.Controls.Add(this.layoutControl1);
this.Name = "FrmPipeStatsChart2D";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
this.Text = "管线长度统计图表";
this.Load += new System.EventHandler(this.FrmPipeLineLengthStatsChart2D_Load);
((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).EndInit();
this.layoutControl1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.xtrTC)).EndInit();
this.xtrTC.ResumeLayout(false);
this.xtraTabPage1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.layoutControl2)).EndInit();
this.layoutControl2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.chartControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.comboBoxEdit1.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem4)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).EndInit();
this.ResumeLayout(false);
}
private void InitDataChart(string sChart, DataTable dt, DevExpress.XtraCharts.ChartControl chartControl)
{
try
{
chartControl.Series.Clear();
//var sTitle = new List<string>();
//int mLineStart = Convert.ToInt32(line.Equals("VJ2") ? mline : line);
//if (mLineStart == 3)
// mLineStart = 2;
//else if (mLineStart == 2)
// mLineStart = 3;
//if (!sChart.Equals("UPC"))
//{
// switch (line)
// {
// case "001":
// case "002":
// case "003":
// case "004":
// case "005":
// case "006":
// for (int i = 1; i <= 3; i++)
// sTitle.Add("Stitching " + ((mLineStart - 1) * 3 + i).ToString());
// break;
// default:
// for (int i = 1; i <= 2; i++)
// sTitle.Add("Stitching " + ((mLineStart) * 2 + i).ToString());
// break;
// }
//}
string Argname = "";
DevExpress.XtraCharts.ChartTitle chartTitle = new DevExpress.XtraCharts.ChartTitle();
switch (sChart)
{
case "UPC":
Argname = "CUTTING";
break;
case "UPS1":
Argname = "STITCHING 1";
break;
case "UPS2":
Argname = "STITCHING 2";
break;
case "UPS3":
Argname = "STITCHING 3";
break;
}
Series series1 = new Series("TARGET", ViewType.Line);
Series series2 = new Series(Argname, ViewType.Bar);
for (int i = 0; i < dt.Rows.Count; i++)
{
series1.Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), string.IsNullOrEmpty(dt.Rows[i][sChart + "_ACT"].ToString()) ? 0.0 : dt.Rows[i][sChart + "_TAR"]));
series2.Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), string.IsNullOrEmpty(dt.Rows[i][sChart + "_ACT"].ToString()) ? 0.0 : dt.Rows[i][sChart + "_ACT"]));
if (Convert.ToDouble(string.IsNullOrEmpty(dt.Rows[i][sChart + "_ACT"].ToString()) ? 0.0 : dt.Rows[i][sChart + "_ACT"]) >= Convert.ToDouble(string.IsNullOrEmpty(dt.Rows[i][sChart + "_TAR"].ToString()) ? 0.0 : dt.Rows[i][sChart + "_TAR"]))
{
series2.Points[i].Color = Color.Green;
}
else
{
series2.Points[i].Color = System.Drawing.Color.Red;
}
}
series1.LabelsVisibility = DefaultBoolean.True;
series2.LabelsVisibility = DefaultBoolean.True;
if (!sChart.Equals("UPC"))
{
// chartTitle.Text = sTitle[Convert.ToInt32(sChart.Substring(3, 1)) - 1];
// chartControl.Titles.Clear();
//chartControl.Titles.AddRange(new DevExpress.XtraCharts.ChartTitle[] { chartTitle });
}
chartControl.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1, series2 };
}
catch (Exception EX) { }
}
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)
{
}
}
public FormChart()
{
InitializeComponent();
ChartContrl = this.chartControl1;
chartcontrol3 = this.chartControl3;
}
private void CreateChart(DevExpress.XtraCharts.ChartControl Chart, DataTable dt, string col)
{
try
{
Chart.Series.Clear();
Chart.Titles.Clear();
string name = "";
switch (col)
{
case "UPC":
name = "Cutting";
break;
case "UPS1":
name = "Stitching 1";
break;
case "UPS2":
name = "Stitching 2";
break;
case "FSS":
name = "Stockfit";
break;
case "FGA":
name = "Assembly";
break;
}
Chart.AppearanceNameSerializable = "Chameleon";
//chartBTS.AppearanceNameSerializable = "Chameleon";
Series series1 = new Series(name, ViewType.Bar);
Chart.AnimationStartMode = DevExpress.XtraCharts.ChartAnimationMode.OnDataChanged;
DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView();
DevExpress.XtraCharts.RectangleGradientFillOptions rectangleGradientFillOptions1 = new DevExpress.XtraCharts.RectangleGradientFillOptions();
Series series2 = new Series("Target", ViewType.Line);
DevExpress.XtraCharts.LineSeriesView lineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView();
lineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.True;
//sideBySideBarSeriesView1.ColorEach = true;
sideBySideBarSeriesView1.FillStyle.FillMode = DevExpress.XtraCharts.FillMode.Solid;
//switch (col)
//{
//case "UPC":
// sideBySideBarSeriesView1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(112)))), ((int)(((byte)(192)))));
// break;
//case "UPS1":
// sideBySideBarSeriesView1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(49)))), ((int)(((byte)(133)))), ((int)(((byte)(155)))));
// break;
//case "UPS2":
// sideBySideBarSeriesView1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(176)))), ((int)(((byte)(240)))));
// break;
//case "FSS":
// sideBySideBarSeriesView1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(150)))), ((int)(((byte)(70)))));
// break;
//case "FGA":
// sideBySideBarSeriesView1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(146)))), ((int)(((byte)(208)))), ((int)(((byte)(80)))));
// break;
//}
sideBySideBarSeriesView1.Color = System.Drawing.Color.ForestGreen;
series1.View = sideBySideBarSeriesView1;
series1.Label.Font = new System.Drawing.Font("Tahoma", 14F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
series1.Label.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(255)))));
series1.View = sideBySideBarSeriesView1;
series1.Label.TextPattern = "{V:#,#}";
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
//series2.Label.Font = new System.Drawing.Font("Tahoma", 14F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
//series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
//series2.Label.TextPattern = "{V:#,#}";
lineSeriesView1.Color = System.Drawing.Color.LimeGreen;
lineSeriesView1.LineMarkerOptions.Color = System.Drawing.Color.FromArgb(((int)(((byte)(146)))), ((int)(((byte)(208)))), ((int)(((byte)(80)))));
lineSeriesView1.LineStyle.Thickness = 3;
series2.View = lineSeriesView1;
string [] value = null;
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
value = dt.Rows[i][col].ToString().Split('/');
series1.Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), value[0]));
if (Convert.ToDouble(value[1]) > 0)
{
series2.Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), value[1]));
}
else
{
series2.Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString()));
}
if (Convert.ToDouble(value[0]) < Convert.ToDouble(value[1]))
{
series1.Points[i].Color = Color.Red;
}
else
{
//switch (col)
//{
// case "UPC":
// series1.Points[i].Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(112)))), ((int)(((byte)(192)))));
// break;
// case "UPS1":
// series1.Points[i].Color = System.Drawing.Color.FromArgb(((int)(((byte)(49)))), ((int)(((byte)(133)))), ((int)(((byte)(155)))));
// break;
// case "UPS2":
// series1.Points[i].Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(176)))), ((int)(((byte)(240)))));
// break;
// case "FSS":
// series1.Points[i].Color = System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(150)))), ((int)(((byte)(70)))));
// break;
// case "FGA":
// series1.Points[i].Color = System.Drawing.Color.FromArgb(((int)(((byte)(146)))), ((int)(((byte)(208)))), ((int)(((byte)(80)))));
// break;
//}
series1.Points[i].Color = System.Drawing.Color.ForestGreen;
}
}
Chart.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1, series2 };
Chart.Legend.Visibility = DevExpress.Utils.DefaultBoolean.True;
((XYDiagram)Chart.Diagram).AxisX.Label.Font = new System.Drawing.Font("Calibri", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)Chart.Diagram).AxisX.Title.Font = new System.Drawing.Font("Calibri", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)Chart.Diagram).AxisY.Label.TextPattern = "{V:#,#}";
((XYDiagram)Chart.Diagram).AxisY.Label.Font = new System.Drawing.Font("Tahoma", 14F);
((XYDiagram)Chart.Diagram).AxisY.Title.Font = new System.Drawing.Font("Calibri", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
((XYDiagram)Chart.Diagram).AxisY.Title.Text = "Production (Prs)";
}
}
catch (Exception EX)
{
}
}
