private void load_data() { System.Data.DataSet ds = LOAD_DATA_v2(_wh_cd, _mline_cd, UC_MONTH.GetValue()); axGrid.Hide(); load_data_grid(ds.Tables[0]); AnimateWindow(axGrid.Handle, 300, AW_SLIDE | 0X4); axGrid.Show(); //pn_body.Visible = true; switch (Lang) { case "Vn": CreateChartLine(Chart1, ds.Tables[1], "Cắt"); CreateChartLine(Chart2, ds.Tables[3], "May 1"); CreateChartLine(Chart3, ds.Tables[5], "May 2"); CreateChartLine(Chart4, ds.Tables[2], "Chuẩn bị"); CreateChartLine(Chart5, ds.Tables[4], "Lắp ráp"); break; case "En": CreateChartLine(Chart1, ds.Tables[1], "Cutting"); CreateChartLine(Chart2, ds.Tables[3], "Stitching 1"); CreateChartLine(Chart3, ds.Tables[5], "Stitching 2"); CreateChartLine(Chart4, ds.Tables[2], "Stockfit"); CreateChartLine(Chart5, ds.Tables[4], "Assembly"); break; } BindingPOD(ds.Tables[6]); }
private void InitGridHeader() { for (int i = 5; i <= 31; i++) { this.axfpSpread.SetText(i, 1, "DATE_" + (i - 4).ToString()); } DataTable dt = null; dt = select_work_date(UC_MONTH.GetValue()); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { this.axfpSpread.SetText(i + 5, 1, dt.Rows[i]["THEDATE"].ToString()); } axfpSpread.LeftCol = dt.Rows.Count - 1; } for (int i = 5; i <= 31; i++) { string sHeader = ""; axfpSpread.Col = i; axfpSpread.Row = 1; sHeader = axfpSpread.Value.ToString(); if (sHeader.Contains("DATE_")) { axfpSpread.set_ColWidth(i, 0); } else { axfpSpread.set_ColWidth(i, 10.37); } } }
private void load_data() { try { load_head(); DataTable dt = SEL_SMT_BTS("Q", line, mline, opcd, UC_MONTH.GetValue()); if (dt != null && dt.Rows.Count > 0) { axfpSpread.MaxRows = dt.Rows.Count + 2; ClearGrid(axfpSpread); for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 1; j < dt.Columns.Count; j++) { axfpSpread.SetText(j + 1, i + 3, dt.Rows[i][j].ToString() == "" ? "" : dt.Rows[i][j].ToString()); //axfpSpread.SetText(j, i + 3, "2,999"); } } } CreateChart(); } catch { } }
private void gvwBase_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e) { try { if (e.Column.ColumnHandle < 2 || e.Clicks <= 1) { return; } DataTable dtF = new DataTable(); string DateF = string.Concat(UC_MONTH.GetValue(), dtf.Columns[e.Column.ColumnHandle].ColumnName.ToString().Replace("'", "")); string DateT = string.Concat(UC_MONTH.GetValue(), dtf.Columns[e.Column.ColumnHandle].ColumnName.ToString().Replace("'", "")); if (e.RowHandle == gvwBase.RowCount - 2 && e.Column.ColumnHandle != 2) { dtF = MGL_I_QSD_DATA_SELECT("POPUP1", DateF, DateT); Popup.FRM_SMT_INTERNAL_POPUP_1 POPUP_1 = new Popup.FRM_SMT_INTERNAL_POPUP_1(dtF); POPUP_1.ShowDialog(); } if (e.RowHandle == gvwBase.RowCount - 1 && e.Column.ColumnHandle != 2) { dtF = MGL_I_QSD_DATA_SELECT("POPUP2", DateF, DateT); Popup.FRM_SMT_INTERNAL_POPUP_2 POPUP_2 = new Popup.FRM_SMT_INTERNAL_POPUP_2(dtF); POPUP_2.ShowDialog(); } } catch { } }
private void BindingDataChart() { string DATE_FROM = UC_MONTH.GetValue() + "01", DATE_TO = UC_MONTH.GetValue() + DateTime.DaysInMonth(Convert.ToInt32(UC_MONTH.GetValue().Substring(0, 4)), Convert.ToInt32(UC_MONTH.GetValue().Substring(4, 2))).ToString(); loadTopLeft(MGL_E_QSD_DATA_SELECT("CHART1", DATE_FROM, DATE_TO)); bindingDataGrid(DATE_FROM, DATE_TO); }
private void UC_MONTH_ValueChangeEvent(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; string DATE_FROM = UC_MONTH.GetValue() + "01", DATE_TO = UC_MONTH.GetValue() + DateTime.DaysInMonth(Convert.ToInt32(UC_MONTH.GetValue().Substring(0, 4)), Convert.ToInt32(UC_MONTH.GetValue().Substring(4, 2))).ToString(); loadTopLeft(SEL_DATA_OSD("CHART1", DATE_FROM, DATE_TO)); bindingDataGrid(DATE_FROM, DATE_TO); this.Cursor = Cursors.Default; } catch { this.Cursor = Cursors.Default; } }
private void axfpOSD_ClickEvent(object sender, AxFPSpreadADO._DSpreadEvents_ClickEvent e) { string sCellValue = ""; axfpOSD.Row = 1; axfpOSD.Col = e.col; sCellValue = axfpOSD.Value.ToString(); string date = UC_MONTH.GetValue() + sCellValue; //MessageBox.Show(date); this.TopMost = false; FRM_EXTERNAL_OSND_POP frm_pop = new FRM_EXTERNAL_OSND_POP(line, Mline, date, date); frm_pop.ShowDialog(); frm_pop.TopMost = true; }
private void axfpOSD_ClickEvent(object sender, AxFPSpreadADO._DSpreadEvents_ClickEvent e) { string sCellValue = ""; axfpOSD.Row = 1; axfpOSD.Col = e.col; sCellValue = axfpOSD.Value.ToString(); string date = UC_MONTH.GetValue() + sCellValue; //MessageBox.Show(date); //this.TopMost = false; DataTable dt = SP_SMT_OSD_DETAIL(line, Mline, date, date, "", "Y"); Popup.FRM_SMT_EXTERNAL_POPUP_1 frm_pop = new Popup.FRM_SMT_EXTERNAL_POPUP_1(dt); // FRM_EXTERNAL_OSND_POP frm_pop = new FRM_EXTERNAL_OSND_POP(line, Mline, date, date); frm_pop.ShowDialog(); // frm_pop.TopMost = true; }
private void BindingOSDDaily() { try { DataTable dt = SP_SMT_OSD_DAILY("DAILY", line, Mline, UC_MONTH.GetValue()); chartOSDDaily.DataSource = dt; Animation(axfpOSD, dt); //BindingGrid(dt); chartOSDDaily.Series[0].ArgumentDataMember = "OSD_YMD"; chartOSDDaily.Series[0].ValueDataMembers.AddRange(new string[] { "OS" }); chartOSDDaily.Series[0].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; } catch (Exception ex) { } }
private void timer1_Tick(object sender, EventArgs e) { cCount++; lblDate.Text = string.Format(DateTime.Now.ToString("yyyy-MM-dd\nHH:mm:ss")); if (cCount >= 40) { try { this.Cursor = Cursors.WaitCursor; string DATE_FROM = UC_MONTH.GetValue() + "01", DATE_TO = UC_MONTH.GetValue() + DateTime.DaysInMonth(Convert.ToInt32(UC_MONTH.GetValue().Substring(0, 4)), Convert.ToInt32(UC_MONTH.GetValue().Substring(4, 2))).ToString(); loadTopLeft(SEL_DATA_OSD("CHART1", DATE_FROM, DATE_TO)); bindingDataGrid(DATE_FROM, DATE_TO); BindingChart(); this.Cursor = Cursors.Default; cCount = 0; } catch { this.Cursor = Cursors.Default; cCount = 0; } } }
private void load_head() { try { DataTable dt = SEL_SMT_MON_PROD_STATUS("H", line, mline, UC_MONTH.GetValue()); int i; if (dt != null && dt.Rows.Count > 0) { axfpSpread.SetText(1, 1, dt.Rows[0]["MON"].ToString()); axfpSpread.set_ColWidth(1, 16.5); // axfpSpread.set_ColWidth(2, 226); for (i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["CUR"].ToString() == "1") { axfpSpread.Row = 1; axfpSpread.Col = i + 2; axfpSpread.BackColor = Color.Salmon; axfpSpread.Row = 2; axfpSpread.Col = i + 2; axfpSpread.BackColor = Color.Salmon; } axfpSpread.AddCellSpan(i + 2, 1, 1, 1); axfpSpread.SetText(i + 2, 1, dt.Rows[i]["DAY"].ToString()); axfpSpread.SetText(i + 2, 2, dt.Rows[i]["DAY1"].ToString()); axfpSpread.set_ColWidth(i + 2, (double)221 / (double)(dt.Rows.Count)); //axfpSpread.set_ColWidth(i + 2, 240 / 27 + 0.3); //axfpSpread.set_ColWidth(i + 2, (axfpSpread.Width-axfpSpread.get_ColWidth(1))/dt.Rows.Count); } axfpSpread.set_ColWidth(1, 16.3 + 220 - axfpSpread.get_ColWidth(i + 1) * dt.Rows.Count); axfpSpread.AddCellSpan(dt.Rows.Count + 1, 1, 1, 2); axfpSpread.AddCellSpan(dt.Rows.Count, 1, 1, 2); axfpSpread.AddCellSpan(dt.Rows.Count - 1, 1, 1, 2); //axfpSpread.set_ColWidth(1, 16.4 + 0.1 * 25 / dt.Rows.Count ); for (int j = i + 2; j <= axfpSpread.MaxCols; j++) { axfpSpread.set_ColWidth(j, 0); } } } catch { } }
private void BindingChart() { try { string DATE_FROM = UC_MONTH.GetValue(); DataTable dt = MGL_I_QSD_DATA_SELECT("CHART2", DATE_FROM, DATE_FROM); chartNosew.DataSource = null; chartHF.DataSource = null; chartPrinting.DataSource = null; chartCutting.DataSource = null; chartEmbroi.DataSource = null; chartTotal.DataSource = null; InitDataChart("UPN", chartNosew, dt); InitDataChart("UPF", chartHF, dt); InitDataChart("UPP", chartPrinting, dt); InitDataChart("UPC", chartCutting, dt); InitDataChart("UPE", chartEmbroi, dt); InitDataChart("TOT", chartTotal, dt); } catch { } }
private void BindingChart() { try { string DATE_FROM = UC_MONTH.GetValue(); DataTable dt = SEL_DATA_OSD("CHART2", DATE_FROM, DATE_FROM); chartCutting.DataSource = null; chartNosew.DataSource = null; chartHF.DataSource = null; chartStit.DataSource = null; chartStock.DataSource = null; chartTotal.DataSource = null; InitDataChart("UPC", chartCutting, dt); InitDataChart("UPN", chartNosew, dt); InitDataChart("UPF", chartHF, dt); InitDataChart("UPS", chartStit, dt); InitDataChart("FSS", chartStock, dt); InitDataChart("TOT", chartTotal, dt); } catch { } }
private void BindingChart() { try { string DATE_FROM = UC_MONTH.GetValue(); DataTable dt = SEL_DATA_OSD(Mline + "M", DATE_FROM, DATE_FROM); chartNosew.DataSource = null; chartHF.DataSource = null; chartPrinting.DataSource = null; chartLaser.DataSource = null; chartEmbroi.DataSource = null; chartTotal.DataSource = null; InitDataChart("UPN", chartNosew, dt); InitDataChart("UPF", chartHF, dt); InitDataChart("UPP", chartPrinting, dt); InitDataChart("UPR", chartLaser, dt); InitDataChart("UPE", chartEmbroi, dt); InitDataChart("TOT", chartTotal, dt); } catch { } }
private void load_head() { try { DataTable dt = SEL_SMT_BTS("H", line, mline, opcd, UC_MONTH.GetValue()); int i; if (dt != null && dt.Rows.Count > 0) { axfpSpread.SetText(1, 1, dt.Rows[0]["MON"].ToString()); axfpSpread.set_ColWidth(1, 16.7); for (i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["CUR"].ToString() == "1") { axfpSpread.Row = 1; axfpSpread.Col = i + 2; axfpSpread.BackColor = Color.Salmon; axfpSpread.Row = 2; axfpSpread.Col = i + 2; axfpSpread.BackColor = Color.Salmon; } axfpSpread.SetText(i + 2, 1, dt.Rows[i]["DAY"].ToString()); axfpSpread.SetText(i + 2, 2, dt.Rows[i]["DAY1"].ToString()); axfpSpread.set_ColWidth(i + 2, (double)221 / (double)(dt.Rows.Count)); } axfpSpread.set_ColWidth(1, 16.6 + 220 - axfpSpread.get_ColWidth(i + 1) * dt.Rows.Count); for (int j = i + 2; j <= axfpSpread.MaxCols; j++) { axfpSpread.set_ColWidth(j, 0); } } } catch { } }
private void CreateChart() { try { chartBTS.Legends.Clear(); //chartBTS.AppearanceNameSerializable = "Chameleon"; Series series1 = new Series("BTS", ViewType.Bar); chartBTS.AnimationStartMode = DevExpress.XtraCharts.ChartAnimationMode.OnDataChanged; DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView(); DevExpress.XtraCharts.SideBySideBarSeriesLabel sideBySideBarSeriesLabel1 = new DevExpress.XtraCharts.SideBySideBarSeriesLabel(); Series series2 = new Series("Target", ViewType.Line); DevExpress.XtraCharts.LineSeriesView lineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView(); lineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.False; sideBySideBarSeriesView1.ColorEach = false; sideBySideBarSeriesView1.Color = System.Drawing.Color.LimeGreen; sideBySideBarSeriesView1.FillStyle.FillMode = DevExpress.XtraCharts.FillMode.Solid; series1.Label.Font = new System.Drawing.Font("Tahoma", 12F, 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.Label.TextPattern = "{V:#,#.0}" + "%"; series1.View = sideBySideBarSeriesView1; series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; series2.Label.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False; series2.Label.TextPattern = "{V:#,#.0}" + "%"; 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 = 4; series2.View = lineSeriesView1; DataTable dt = SEL_SMT_BTS("C", line, mline, opcd, UC_MONTH.GetValue()); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { series1.Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), dt.Rows[i]["BTS"])); series2.Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), dt.Rows[i]["TARGET"])); if (Convert.ToDouble(dt.Rows[i]["BTS"]) < Convert.ToDouble(dt.Rows[i]["TARGET"]) && Convert.ToDouble(dt.Rows[i]["BTS"]) >= Convert.ToDouble(dt.Rows[i]["TARGET"]) - 5) { series1.Points[i].Color = Color.Yellow; } else if (Convert.ToDouble(dt.Rows[i]["BTS"]) < Convert.ToDouble(dt.Rows[i]["TARGET"]) - 5) { series1.Points[i].Color = Color.Red; } else { series1.Points[i].Color = System.Drawing.Color.LimeGreen; } } chartBTS.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1, series2 }; ((XYDiagram)chartBTS.Diagram).AxisX.Label.Font = new System.Drawing.Font("Tahoma", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); ((XYDiagram)chartBTS.Diagram).AxisX.Title.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0))))); ((XYDiagram)chartBTS.Diagram).AxisY.Label.TextPattern = "{V:#,#}"; ((XYDiagram)chartBTS.Diagram).AxisY.Label.Font = new System.Drawing.Font("Tahoma", 13F); ((XYDiagram)chartBTS.Diagram).AxisY.Title.Font = new System.Drawing.Font("Calibri", 22F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); ((XYDiagram)chartBTS.Diagram).AxisY.Title.Text = "BTS (%)"; ((XYDiagram)chartBTS.Diagram).AxisY.Title.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0))))); DevExpress.XtraCharts.Legend legend1 = new DevExpress.XtraCharts.Legend(); DevExpress.XtraCharts.CustomLegendItem customLegendItem1 = new DevExpress.XtraCharts.CustomLegendItem(); DevExpress.XtraCharts.CustomLegendItem customLegendItem2 = new DevExpress.XtraCharts.CustomLegendItem(); DevExpress.XtraCharts.CustomLegendItem customLegendItem3 = new DevExpress.XtraCharts.CustomLegendItem(); customLegendItem1.MarkerColor = System.Drawing.Color.LimeGreen; customLegendItem1.Name = "GREEN"; customLegendItem1.Text = ">=" + dt.Rows[0]["TARGET"].ToString() + "%"; customLegendItem2.MarkerColor = System.Drawing.Color.Yellow; customLegendItem2.Name = "YELLOW"; customLegendItem2.Text = ">=" + (Convert.ToDouble(dt.Rows[0]["TARGET"].ToString()) - 5).ToString() + "% and <" + dt.Rows[0]["TARGET"].ToString() + "%"; customLegendItem3.MarkerColor = System.Drawing.Color.Red; customLegendItem3.Name = "RED"; customLegendItem3.Text = "<" + (Convert.ToDouble(dt.Rows[0]["TARGET"].ToString()) - 5).ToString() + "%"; legend1.CustomItems.AddRange(new DevExpress.XtraCharts.CustomLegendItem[] { customLegendItem1, customLegendItem2, customLegendItem3 }); legend1.AlignmentHorizontal = DevExpress.XtraCharts.LegendAlignmentHorizontal.Right; legend1.AlignmentVertical = DevExpress.XtraCharts.LegendAlignmentVertical.TopOutside; legend1.Direction = DevExpress.XtraCharts.LegendDirection.LeftToRight; legend1.Font = new System.Drawing.Font("Tahoma", 12F); legend1.Name = "Legend1"; this.chartBTS.Legends.AddRange(new DevExpress.XtraCharts.Legend[] { legend1 }); } } catch (Exception EX) { } }
private void BindingOSDWeekly(string Comp_Name) { try { switch (Comp_Name) { case "IN": chartIN.DataSource = SP_SMT_OSD_DAILY(Comp_Name, line, Mline, UC_MONTH.GetValue()); chartIN.Series[0].ArgumentDataMember = "STYLE_NAME"; chartIN.Series[0].ValueDataMembers.AddRange(new string[] { "QTY" }); chartIN.Series[0].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; chartIN.Series[1].ArgumentDataMember = "STYLE_NAME"; chartIN.Series[1].ValueDataMembers.AddRange(new string[] { "PER" }); chartIN.Series[1].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; ((XYDiagram)chartIN.Diagram).AxisX.Label.Angle = -35; break; case "IP": chartIPPH.DataSource = SP_SMT_OSD_DAILY(Comp_Name, line, Mline, UC_MONTH.GetValue()); chartIPPH.Series[0].ArgumentDataMember = "STYLE_NAME"; chartIPPH.Series[0].ValueDataMembers.AddRange(new string[] { "QTY" }); chartIPPH.Series[0].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; chartIPPH.Series[1].ArgumentDataMember = "STYLE_NAME"; chartIPPH.Series[1].ValueDataMembers.AddRange(new string[] { "PER" }); chartIPPH.Series[1].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; ((XYDiagram)chartIPPH.Diagram).AxisX.Label.Angle = -35; break; case "PH": chartPH.DataSource = SP_SMT_OSD_DAILY(Comp_Name, line, Mline, UC_MONTH.GetValue()); chartPH.Series[0].ArgumentDataMember = "STYLE_NAME"; chartPH.Series[0].ValueDataMembers.AddRange(new string[] { "QTY" }); chartPH.Series[0].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; chartPH.Series[1].ArgumentDataMember = "STYLE_NAME"; chartPH.Series[1].ValueDataMembers.AddRange(new string[] { "PER" }); chartPH.Series[1].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; ((XYDiagram)chartPH.Diagram).AxisX.Label.Angle = -35; break; case "DMP": chartDMPPU.DataSource = SP_SMT_OSD_DAILY(Comp_Name, line, Mline, UC_MONTH.GetValue()); chartDMPPU.Series[0].ArgumentDataMember = "STYLE_NAME"; chartDMPPU.Series[0].ValueDataMembers.AddRange(new string[] { "QTY" }); chartDMPPU.Series[0].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; chartDMPPU.Series[1].ArgumentDataMember = "STYLE_NAME"; chartDMPPU.Series[1].ValueDataMembers.AddRange(new string[] { "PER" }); chartDMPPU.Series[1].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; ((XYDiagram)chartDMPPU.Diagram).AxisX.Label.Angle = -35; break; case "PU": chartPU.DataSource = SP_SMT_OSD_DAILY(Comp_Name, line, Mline, UC_MONTH.GetValue()); chartPU.Series[0].ArgumentDataMember = "STYLE_NAME"; chartPU.Series[0].ValueDataMembers.AddRange(new string[] { "QTY" }); chartPU.Series[0].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; chartPU.Series[1].ArgumentDataMember = "STYLE_NAME"; chartPU.Series[1].ValueDataMembers.AddRange(new string[] { "PER" }); chartPU.Series[1].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; ((XYDiagram)chartPU.Diagram).AxisX.Label.Angle = -35; break; case "OS": chartOS.DataSource = SP_SMT_OSD_DAILY(Comp_Name, line, Mline, UC_MONTH.GetValue()); chartOS.Series[0].ArgumentDataMember = "STYLE_NAME"; chartOS.Series[0].ValueDataMembers.AddRange(new string[] { "QTY" }); chartOS.Series[0].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; chartOS.Series[1].ArgumentDataMember = "STYLE_NAME"; chartOS.Series[1].ValueDataMembers.AddRange(new string[] { "PER" }); chartOS.Series[1].ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; ((XYDiagram)chartOS.Diagram).AxisX.Label.Angle = -35; break; } } catch { } }
private void load_data() { try { //axfpSpread.Hide(); load_head(); DataTable dt = SEL_SMT_MON_PROD_STATUS("Q", line, mline, UC_MONTH.GetValue()); DataTable dt_chart = SEL_SMT_MON_PROD_STATUS("C", line, mline, UC_MONTH.GetValue()); DataTable dt1 = SEL_SMT_MON_PROD_STATUS("C1", line, mline, UC_MONTH.GetValue()); if (dt != null && dt.Rows.Count > 0) { axfpSpread.MaxRows = dt.Rows.Count + 2; ClearGrid(axfpSpread); //axfpSpread.SetCellBorder(1, 1, axfpSpread.MaxCols, axfpSpread.MaxRows, FPSpreadADO.CellBorderIndexConstants.CellBorderIndexBottom, 0, FPSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid); //axfpSpread.SetCellBorder(1, 1, axfpSpread.MaxCols, axfpSpread.MaxRows, FPSpreadADO.CellBorderIndexConstants.CellBorderIndexTop, 0, FPSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid); //axfpSpread.SetCellBorder(1, 1, axfpSpread.MaxCols, axfpSpread.MaxRows, FPSpreadADO.CellBorderIndexConstants.CellBorderIndexLeft, 0, FPSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid); //axfpSpread.SetCellBorder(1, 1, axfpSpread.MaxCols, axfpSpread.MaxRows, FPSpreadADO.CellBorderIndexConstants.CellBorderIndexRight, 0, FPSpreadADO.CellBorderStyleConstants.CellBorderStyleSolid); for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 2; j < dt.Columns.Count; j++) { if (dt.Columns[j].ColumnName.Replace("'", "") == "RATE") { axfpSpread.SetText(j, i + 3, dt.Rows[i][j].ToString().Trim() == "" ? "" : Convert.ToDouble(dt.Rows[i][j].ToString()).ToString() + "%"); } else { axfpSpread.SetText(j, i + 3, dt.Rows[i][j].ToString().Trim() == "" ? "" : Convert.ToDouble(dt.Rows[i][j].ToString()).ToString("###,###,###")); } //axfpSpread.SetText(j, i + 3, "2,999"); if (j == dt.Columns.Count - 1) { axfpSpread.Row = i + 3; axfpSpread.Col = j; if (GetText(axfpSpread, j, i + 3) != "") { if (Convert.ToDouble(GetText(axfpSpread, j, i + 3).Replace("%", "").Trim()) < 95) { axfpSpread.BackColor = Color.Red; axfpSpread.ForeColor = Color.White; } else if (Convert.ToDouble(GetText(axfpSpread, j, i + 3).Replace("%", "").Trim()) > 98) { axfpSpread.BackColor = Color.Green; axfpSpread.ForeColor = Color.White; } else { axfpSpread.BackColor = Color.Yellow; axfpSpread.ForeColor = Color.Black; } } } } } } bindingdatachart(chartControl1, dt_chart, "UPC_QTY", "UPC_TAR"); bindingdatachart(chartControl2, dt_chart, "UPS1_QTY", "UPS1_TAR"); bindingdatachart(chartControl3, dt_chart, "UPS2_QTY", "UPS2_TAR"); bindingdatachart(chartControl4, dt_chart, "FSS_QTY", "FSS_TAR"); bindingdatachart(chartControl5, dt_chart, "FGA_QTY", "FGA_TAR"); //if (dt1 != null && dt1.Rows.Count > 0) //{ // BindingGauges(circularGauge, Convert.ToDouble(dt1.Rows[0]["RATE"]), Convert.ToInt32(dt1.Rows[0]["V_MIN"]), Convert.ToInt32(dt1.Rows[0]["V_MAX"]), Convert.ToInt32(dt1.Rows[0]["R_MIN"]), Convert.ToInt32(dt1.Rows[0]["R_MAX"])); // lblR.Text = "<" + dt1.Rows[0]["R_MIN"].ToString() + "%"; // lblY.Text = ">=" + dt1.Rows[0]["R_MIN"].ToString() + "% && <=" + dt1.Rows[0]["R_MAX"].ToString() + "%"; // lblG.Text = ">" + dt1.Rows[0]["R_MAX"].ToString() + "%"; // lblRPlan.Text = "R.Plan: " + Convert.ToDouble(dt1.Rows[0]["RPLAN"]).ToString("#,#") + "Prs"; // lblProd.Text = "Prod: " + Convert.ToDouble(dt1.Rows[0]["PROD"]).ToString("#,#") + "Prs"; // lblRate.Text = "Rate: " + Convert.ToDouble(dt1.Rows[0]["RATE"]).ToString("#,#.0") + "%"; // labelRate.Text = Convert.ToDouble(dt1.Rows[0]["RATE"]).ToString("#,0.0") + "%"; //} int i_min = 0, i_max = 100; if (dt != null && dt.Rows.Count > 0) { if (GetText(axfpSpread, dt.Columns.Count - 1, axfpSpread.MaxRows).Replace("%", "").Trim() != "") { if (Convert.ToDouble(GetText(axfpSpread, dt.Columns.Count - 1, axfpSpread.MaxRows).Replace("%", "").Trim()) > 90 && Convert.ToDouble(GetText(axfpSpread, dt.Columns.Count - 1, axfpSpread.MaxRows).Replace("%", "").Trim()) < 100) { i_min = 90; i_max = 100; } else if (Convert.ToDouble(GetText(axfpSpread, dt.Columns.Count - 1, axfpSpread.MaxRows).Replace("%", "").Trim()) < 90) { i_min = 90 - 3; i_max = 100; } else if (Convert.ToDouble(GetText(axfpSpread, dt.Columns.Count - 1, axfpSpread.MaxRows).Replace("%", "").Trim()) > 100) { i_min = 90; i_max = 100 + 3; } else if (Convert.ToDouble(GetText(axfpSpread, dt.Columns.Count - 1, axfpSpread.MaxRows).Replace("%", "").Trim()) == 0) { i_min = 0; i_max = 100; } BindingGauges(circularGauge, Convert.ToDouble(GetText(axfpSpread, dt.Columns.Count - 1, axfpSpread.MaxRows).Replace("%", "").Trim()), i_min, i_max, 95, 98); labelRate.Text = Convert.ToDouble(GetText(axfpSpread, dt.Columns.Count - 1, axfpSpread.MaxRows).Replace("%", "").Trim()) + "%"; } } else { BindingGauges(circularGauge, 0, 0, 100, 95, 98); labelRate.Text = "0%"; } //axfpSpread.Show(); } catch (Exception ex) { } }
private void Search_Daily_Report() { try { double[] total = { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 }; // DataTable dt = null; // dt = null; InitGridHeader(); DataTable dt = select_deffect_monitor(UC_MONTH.GetValue()); if (dt != null && dt.Rows.Count > 1) { iNumRow = dt.Rows.Count; dt_Daily_Report = dt; axfpSpread.ClearRange(1, 2, axfpSpread.MaxCols, axfpSpread.MaxRows, true); // axfDailyReport_Header.Visible = false; axfpSpread.Row = dt.Rows.Count + 2; axfpSpread.BackColor = Color.Lime; if (dt_Daily_Report != null && dt_Daily_Report.Rows.Count > 1) { for (int i = 0; i < dt_Daily_Report.Rows.Count; i++) { // string sFormat = "#,###,##0.##"; if (dt_Daily_Report.Rows[i]["remark"].ToString() == "10" || dt_Daily_Report.Rows[i]["remark"].ToString() == "20" || dt_Daily_Report.Rows[i]["remark"].ToString() == "30") { axfpSpread.Row = i + 2; axfpSpread.Col = 4; axfpSpread.TypeHAlign = TypeHAlignConstants.TypeHAlignLeft; } axfpSpread.set_RowHeight(i + 2, 20.5); this.axfpSpread.SetText(1, i + 2, dt_Daily_Report.Rows[i]["LEV"].ToString()); this.axfpSpread.SetText(2, i + 2, dt_Daily_Report.Rows[i]["PROCESS_NM"].ToString().Replace(" ", "\n")); this.axfpSpread.SetText(3, i + 2, dt_Daily_Report.Rows[i]["REASON_HEAD_NM"].ToString()); this.axfpSpread.SetText(4, i + 2, dt_Daily_Report.Rows[i]["REASON_TAIL_NM"].ToString()); this.axfpSpread.SetText(5, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_1"])); this.axfpSpread.SetText(6, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_2"])); this.axfpSpread.SetText(7, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_3"])); this.axfpSpread.SetText(8, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_4"])); this.axfpSpread.SetText(9, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_5"])); this.axfpSpread.SetText(10, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_6"])); this.axfpSpread.SetText(11, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_7"])); this.axfpSpread.SetText(12, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_8"])); this.axfpSpread.SetText(13, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_9"])); this.axfpSpread.SetText(14, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_10"])); this.axfpSpread.SetText(15, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_11"])); this.axfpSpread.SetText(16, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_12"])); this.axfpSpread.SetText(17, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_13"])); this.axfpSpread.SetText(18, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_14"])); this.axfpSpread.SetText(19, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_15"])); this.axfpSpread.SetText(20, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_16"])); this.axfpSpread.SetText(21, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_17"])); this.axfpSpread.SetText(22, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_18"])); this.axfpSpread.SetText(23, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_19"])); this.axfpSpread.SetText(24, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_20"])); this.axfpSpread.SetText(25, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_21"])); this.axfpSpread.SetText(26, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_22"])); this.axfpSpread.SetText(27, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_23"])); this.axfpSpread.SetText(28, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_24"])); this.axfpSpread.SetText(29, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_25"])); this.axfpSpread.SetText(30, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_26"])); this.axfpSpread.SetText(31, i + 2, FormatData(dt_Daily_Report.Rows[i]["DATE_27"])); this.axfpSpread.SetText(32, i + 2, FormatData(dt_Daily_Report.Rows[i]["TOT"])); if (dt_Daily_Report.Rows[i]["REASON_TAIL_CD"].ToString().Substring(0, 3) == "RAT") { for (int j = 3; j < dt_Daily_Report.Columns.Count; j++) { axfpSpread.Col = j; axfpSpread.Row = i + 2; axfpSpread.BackColor = Color.DodgerBlue; } } else if (dt_Daily_Report.Rows[i]["REASON_TAIL_CD"].ToString().Substring(0, 3) == "TOT") { for (int j = 4; j < dt_Daily_Report.Columns.Count; j++) { axfpSpread.Col = j; axfpSpread.Row = i + 2; axfpSpread.BackColor = Color.Yellow; if (j >= 5 && j <= 35) { total[j - 5] += axfpSpread.Text == "" ? 0 : Convert.ToDouble(axfpSpread.Text); } } } else { for (int j = 1; j < dt_Daily_Report.Columns.Count; j++) { axfpSpread.Col = j; axfpSpread.Row = i + 2; axfpSpread.BackColor = Color.White; } } } // axfpSpread.AddCellSpan(1, dt.Rows.Count + 2, 4, 1); axfpSpread.SetText(2, dt.Rows.Count + 2, "Total"); axfpSpread.SetText(4, dt.Rows.Count + 2, "%"); axfpSpread.SetText(5, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_1"].ToString()) == 0 ? "0" : (total[0] / Convert.ToDouble(dt.Rows[0]["DATE_1"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(6, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_2"].ToString()) == 0 ? "0" : (total[1] / Convert.ToDouble(dt.Rows[0]["DATE_2"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(7, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_3"].ToString()) == 0 ? "0" : (total[2] / Convert.ToDouble(dt.Rows[0]["DATE_3"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(8, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_4"].ToString()) == 0 ? "0" : (total[3] / Convert.ToDouble(dt.Rows[0]["DATE_4"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(9, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_5"].ToString()) == 0 ? "0" : (total[4] / Convert.ToDouble(dt.Rows[0]["DATE_5"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(10, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_6"].ToString()) == 0 ? "0" : (total[5] / Convert.ToDouble(dt.Rows[0]["DATE_6"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(11, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_7"].ToString()) == 0 ? "0" : (total[6] / Convert.ToDouble(dt.Rows[0]["DATE_7"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(12, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_8"].ToString()) == 0 ? "0" : (total[7] / Convert.ToDouble(dt.Rows[0]["DATE_8"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(13, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_9"].ToString()) == 0 ? "0" : (total[8] / Convert.ToDouble(dt.Rows[0]["DATE_9"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(14, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_10"].ToString()) == 0 ? "0" : (total[9] / Convert.ToDouble(dt.Rows[0]["DATE_10"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(15, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_11"].ToString()) == 0 ? "0" : (total[10] / Convert.ToDouble(dt.Rows[0]["DATE_11"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(16, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_12"].ToString()) == 0 ? "0" : (total[11] / Convert.ToDouble(dt.Rows[0]["DATE_12"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(17, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_13"].ToString()) == 0 ? "0" : (total[12] / Convert.ToDouble(dt.Rows[0]["DATE_13"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(18, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_14"].ToString()) == 0 ? "0" : (total[13] / Convert.ToDouble(dt.Rows[0]["DATE_14"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(19, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_15"].ToString()) == 0 ? "0" : (total[14] / Convert.ToDouble(dt.Rows[0]["DATE_15"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(20, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_16"].ToString()) == 0 ? "0" : (total[15] / Convert.ToDouble(dt.Rows[0]["DATE_16"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(21, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_17"].ToString()) == 0 ? "0" : (total[16] / Convert.ToDouble(dt.Rows[0]["DATE_17"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(22, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_18"].ToString()) == 0 ? "0" : (total[17] / Convert.ToDouble(dt.Rows[0]["DATE_18"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(23, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_19"].ToString()) == 0 ? "0" : (total[18] / Convert.ToDouble(dt.Rows[0]["DATE_19"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(24, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_20"].ToString()) == 0 ? "0" : (total[19] / Convert.ToDouble(dt.Rows[0]["DATE_20"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(25, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_21"].ToString()) == 0 ? "0" : (total[20] / Convert.ToDouble(dt.Rows[0]["DATE_21"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(26, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_22"].ToString()) == 0 ? "0" : (total[21] / Convert.ToDouble(dt.Rows[0]["DATE_22"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(27, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_23"].ToString()) == 0 ? "0" : (total[22] / Convert.ToDouble(dt.Rows[0]["DATE_23"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(28, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_24"].ToString()) == 0 ? "0" : (total[23] / Convert.ToDouble(dt.Rows[0]["DATE_24"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(29, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_25"].ToString()) == 0 ? "0" : (total[24] / Convert.ToDouble(dt.Rows[0]["DATE_25"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(30, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_26"].ToString()) == 0 ? "0" : (total[25] / Convert.ToDouble(dt.Rows[0]["DATE_26"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(31, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["DATE_27"].ToString()) == 0 ? "0" : (total[26] / Convert.ToDouble(dt.Rows[0]["DATE_27"].ToString()) * 100).ToString("###,##0.00")); axfpSpread.SetText(32, dt.Rows.Count + 2, Convert.ToDouble(dt.Rows[0]["TOT"].ToString()) == 0 ? "0" : (total[27] / Convert.ToDouble(dt.Rows[0]["TOT"].ToString()) * 100).ToString("###,##0.00")); for (int j = 1; j < dt_Daily_Report.Columns.Count; j++) { axfpSpread.Col = j; axfpSpread.Row = dt.Rows.Count + 2; axfpSpread.BackColor = Color.Lime; } int iTmp = dt.Rows.Count + 3; for (int i = 2; i < iTmp; i++) { axfpSpread.set_RowHeight(i, 20.5); } for (int i = dt.Rows.Count + 3; i < axfpSpread.MaxRows + 1; i++) { axfpSpread.set_RowHeight(i, 0); } MergeCol(axfpSpread, 2, 1); MergeCol(axfpSpread, 2, 2); MergeCol(axfpSpread, 2, 3); // axfpSpread.TopRow = dt.Rows.Count - 15; dt = null; dt = select_chart_1(UC_MONTH.GetValue()); if (dt != null & dt.Rows.Count > 0) { createChart(chart1, dt, dt.Rows[0]["title"].ToString()); } dt = null; dt = select_chart_2(UC_MONTH.GetValue()); if (dt != null & dt.Rows.Count > 0) { createChart(chart2, dt, dt.Rows[0]["title"].ToString()); } dt = select_chart_3(UC_MONTH.GetValue()); if (dt != null & dt.Rows.Count > 0) { createChart(chart3, dt, dt.Rows[0]["title"].ToString()); } // showAnimation(axfpSpread); } else { } } else { // axfDailyReport_Header.Visible = true; iNumRow = 0; } } catch (Exception) { } }
private void InitGridHeader() { axfpSpread.MaxRows = 1; axfpSpread.MaxRows = 50; axfpSpread.Font = new System.Drawing.Font("Calibri", 16.00F, System.Drawing.FontStyle.Bold); for (int i = 5; i <= 31; i++) { axfpSpread.Row = -1; axfpSpread.Col = i; axfpSpread.TypeHAlign = TypeHAlignConstants.TypeHAlignRight; axfpSpread.Row = 1; axfpSpread.TypeHAlign = TypeHAlignConstants.TypeHAlignCenter; axfpSpread.TypeVAlign = TypeVAlignConstants.TypeVAlignCenter; this.axfpSpread.SetText(i, 1, "DATE_" + (i - 4).ToString()); } DataTable dt = null; dt = select_work_date(UC_MONTH.GetValue()); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { this.axfpSpread.SetText(i + 5, 1, dt.Rows[i]["THEDATE"].ToString()); } axfpSpread.LeftCol = dt.Rows.Count - 1; } for (int i = 5; i <= 31; i++) { string sHeader = ""; axfpSpread.Col = i; axfpSpread.Row = 1; sHeader = axfpSpread.Value.ToString(); if (sHeader.Contains("DATE_")) { axfpSpread.set_ColWidth(i, 0); } else { axfpSpread.set_ColWidth(i, 10.37); } } axfpSpread.Row = -1; axfpSpread.Col = axfpSpread.MaxCols; axfpSpread.TypeHAlign = TypeHAlignConstants.TypeHAlignRight; axfpSpread.Row = 1; axfpSpread.TypeHAlign = TypeHAlignConstants.TypeHAlignCenter; axfpSpread.TypeVAlign = TypeVAlignConstants.TypeVAlignCenter; axfpSpread.TypeHAlign = TypeHAlignConstants.TypeHAlignRight; //for (int i = 2; i < axfpSpread.MaxRows; i++) //{ // axfpSpread.set_RowHeight(i, 20.5); // axfpSpread.Row = i; // axfpSpread.BackColor = Color.White; //} }
private void CreateChart() { try { //chartBTS.AppearanceNameSerializable = "Chameleon"; Series series1 = new Series("BTS", ViewType.Bar); chartBTS.AnimationStartMode = DevExpress.XtraCharts.ChartAnimationMode.OnDataChanged; DevExpress.XtraCharts.SideBySideBarSeriesView sideBySideBarSeriesView1 = new DevExpress.XtraCharts.SideBySideBarSeriesView(); DevExpress.XtraCharts.SideBySideBarSeriesLabel sideBySideBarSeriesLabel1 = new DevExpress.XtraCharts.SideBySideBarSeriesLabel(); Series series2 = new Series("Target", ViewType.Line); DevExpress.XtraCharts.LineSeriesView lineSeriesView1 = new DevExpress.XtraCharts.LineSeriesView(); lineSeriesView1.MarkerVisibility = DevExpress.Utils.DefaultBoolean.False; sideBySideBarSeriesView1.ColorEach = false; sideBySideBarSeriesView1.Color = System.Drawing.Color.LimeGreen; sideBySideBarSeriesView1.FillStyle.FillMode = DevExpress.XtraCharts.FillMode.Solid; series1.Label.Font = new System.Drawing.Font("Tahoma", 12F, 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.Label.TextPattern = "{V:#,#.0}" + "%"; series1.View = sideBySideBarSeriesView1; series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; series2.Label.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); series2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False; series2.Label.TextPattern = "{V:#,#.0}" + "%"; 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 = 4; series2.View = lineSeriesView1; DataTable dt = SEL_SMT_BTS("C", line, mline, UC_MONTH.GetValue()); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { series1.Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), dt.Rows[i]["BTS"])); series2.Points.Add(new SeriesPoint(dt.Rows[i]["DAY"].ToString(), dt.Rows[i]["TARGET"])); if (Convert.ToDouble(dt.Rows[i]["BTS"]) < Convert.ToDouble(dt.Rows[i]["TARGET"]) && Convert.ToDouble(dt.Rows[i]["BTS"]) >= Convert.ToDouble(dt.Rows[i]["TARGET"]) - 5) { series1.Points[i].Color = Color.Yellow; } else if (Convert.ToDouble(dt.Rows[i]["BTS"]) < Convert.ToDouble(dt.Rows[i]["TARGET"]) - 5) { series1.Points[i].Color = Color.Red; } else { series1.Points[i].Color = System.Drawing.Color.LimeGreen; } } chartBTS.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1, series2 }; ((XYDiagram)chartBTS.Diagram).AxisX.Label.Font = new System.Drawing.Font("Tahoma", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); ((XYDiagram)chartBTS.Diagram).AxisX.Title.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0))))); ((XYDiagram)chartBTS.Diagram).AxisY.Label.TextPattern = "{V:#,#}"; ((XYDiagram)chartBTS.Diagram).AxisY.Label.Font = new System.Drawing.Font("Tahoma", 13F); ((XYDiagram)chartBTS.Diagram).AxisY.Title.Font = new System.Drawing.Font("Calibri", 22F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); ((XYDiagram)chartBTS.Diagram).AxisY.Title.Text = "BTS (%)"; ((XYDiagram)chartBTS.Diagram).AxisY.Title.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0))))); } } catch (Exception) { } }