private void BindingColumChart_2(Dundas.Charting.WebControl.Chart chart, string dateStr) { chart.DataSource = GetChartDataTable_2(dateStr).DefaultView; DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 400, 180 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(chart, "Series4", "Default", "판매실적", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //Series series2 = DundasCharts.CreateSeries(chart, "Series2", "Default", "생산량", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //Series series3 = DundasCharts.CreateSeries(chart, "Series3", "Default", "부하율", null, SeriesChartType.Column, 1, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //Series series4 = DundasCharts.CreateSeries(chart, "Series4", "Default", "협력업체", null, SeriesChartType.Line, 1, Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.ValueMemberX = "PAN_ITMNM"; series1.ValueMembersY = "PAN_QTY"; series1.ToolTip = "#VALY{N0}"; //series2.ValueMembersY = "PROD_QTY"; //series3.ValueMembersY = "BUHA"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.0, 3.0, false); //DundasAnimations.GrowingAnimation(chart, series2, 3.0, 4.0, true); //DundasAnimations.GrowingAnimation(chart, series3, 4.0, 6.0, true); series1.ShowLabelAsValue = true; series1.LabelFormat = "N0"; }
private void BindingChartOneYear(Dundas.Charting.WebControl.Chart chart, string yearStr, string monthStr, string type, string gubn) { chart.DataSource = GetChartDataTableOneYear(yearStr, monthStr, type, gubn).DefaultView; DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 400, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(chart, "Series1", "Default", "차이량", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(chart, "Series2", "Default", "차이비율", null, SeriesChartType.Line, 3, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.ValueMemberX = "MONTH"; series1.ValueMembersY = "DIFF_ADJUST_QNT"; series2.ValueMembersY = "RATE_ADJUST"; series2.YAxisType = AxisType.Secondary; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.0, 5.0, false); DundasAnimations.GrowingAnimation(chart, series2, 1.0, 2.0, true); series2.MarkerStyle = MarkerStyle.Diamond; series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); }
private void _setGraph(DataSet dsGrph) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 290 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "계획", null, SeriesChartType.Column, 1, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(Chart1, "Series2", "Default", "실적", null, SeriesChartType.Column, 1, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(Chart1, "Series3", "Default", "달성율", null, SeriesChartType.Line, 1, GetChartColor(2), GetChartColor(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); dsGrph.Tables[0].DefaultView.Sort = "MM"; Chart1.DataSource = dsGrph.Tables[0].DefaultView; series1.ValueMembersY = "A_PLAN"; series2.ValueMembersY = "A_ACTL"; series3.ValueMembersY = "A_RATE"; series1.ValueMemberX = "MM"; string strChartArea = Chart1.Series[series3.Name].ChartArea; series3.YAxisType = AxisType.Secondary; Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; Chart1.ChartAreas[strChartArea].AxisY2.LabelStyle.Format = "P0"; Chart1.DataBind(); DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, series1, 0.0, 1.0, true); DundasAnimations.GrowingAnimation(Chart1, series2, 1.0, 2.0, true); DundasAnimations.GrowingAnimation(Chart1, series3, 1.0, 2.0, true); }
private void BindingPieChart_4(string yearStr) { Chart4.DataSource = GetChartDataTable_4(yearStr).DefaultView; DundasCharts.DundasChartBase(Chart4, ChartImageType.Flash, 400, 180 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(Chart4, "Series10", "Default", "채권현황", null, SeriesChartType.Pie, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.ValueMemberX = "AC_ACNT_NM"; series1.ValueMembersY = "JAN_AMT"; series1.ToolTip = "#VALY{N0}"; DundasAnimations.DundasChartBase(Chart4, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart4, series1, 0.0, 3.0, false); series1["PieLabelStyle"] = "Outside"; Chart4.Legends[0].Position.Auto = false; Chart4.Legends[0].Position.Height = 0; Chart4.Legends[0].Position.Width = 0; //series1.ShowInLegend = true; }
private void _setGraph(DataSet dsGrid) { // 년도별 매출량 그래프 DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 280 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "예산", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(Chart1, "Series2", "Default", "실적", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(Chart1, "Series3", "Default", "집행율(%)", null, SeriesChartType.Line, 3, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Chart1.DataSource = dsGrid; series1.ValueMemberX = "MM"; series1.ValueMembersY = "예산"; series2.ValueMembersY = "실적"; series3.ValueMembersY = "집행율"; Chart1.DataBind(); Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; Chart1.ChartAreas[Chart1.Series[series3.Name].ChartArea].AxisY2.LabelStyle.Format = "P0"; series3.YAxisType = AxisType.Secondary; DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, series1, 0.5, 1.0, true); DundasAnimations.GrowingAnimation(Chart1, series2, 1.0, 2.0, true); DundasAnimations.GrowingAnimation(Chart1, series3, 1.0, 2.0, true); }
private void _setGraph(DataSet iDsSet) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "계획", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(Chart1, "Series2", "Default", "실적", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(Chart1, "Series3", "Default", "달성율", null, SeriesChartType.Line, 1, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //------------------------------------------------------Chart2 Chart1.DataSource = iDsSet.Tables[0].DefaultView; series1.ValueMembersY = "PLAN_QNT"; series2.ValueMembersY = "ACTL_QNT"; series3.ValueMembersY = "ACHV_RATE"; series1.ValueMemberX = "MM"; string strChartArea = Chart1.Series[series3.Name].ChartArea; series3.YAxisType = AxisType.Secondary; Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; Chart1.ChartAreas[strChartArea].AxisY2.LabelStyle.Format = "P0"; DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, series1, 0.0, 1.0, true); DundasAnimations.GrowingAnimation(Chart1, series2, 1.0, 2.0, true); DundasAnimations.GrowingAnimation(Chart1, series3, 1.0, 2.0, true); }
private void BindingChart(Dundas.Charting.WebControl.Chart chart, string areaStr) { string query_jikgub = GetJikGubQuery(); dbAgent = new DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["EISDB"].ConnectionString); DataSet ds_jikgub = dbAgent.FillDataSet(query_jikgub, "Data"); //chart.DataSource = GetChartDataTable(areaStr).DefaultView; DataTable dt = GetChartDataTable(areaStr); DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 800, 390 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series = null; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); for (int i = 0; i < ds_jikgub.Tables[0].Rows.Count; i++) { series = DundasCharts.CreateSeries(chart, "Series" + i.ToString(), "Default", ds_jikgub.Tables[0].Rows[i]["JIKGUB_NM"].ToString(), null, SeriesChartType.StackedColumn, 1, GetChartColor(i), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //series.ValueMembersY = "C_" + ds_jikgub.Tables[0].Rows[i]["JIKGUB_NM"].ToString(); DatabaseBindingXY(series, "TEAM_NM", "C_" + ds_jikgub.Tables[0].Rows[i]["JIKGUB_NM"].ToString(), dt); series["DrawingStyle"] = "Cylinder"; DundasAnimations.FadingAnimation(chart, series, 0.5 * i, 0.5 * (i + 1), false, false); series.ShowLabelAsValue = true; series.ToolTip = "#VALY{N0}"; SetVisibleZeroLabelText(chart); } }
private void SetResutlGraph(DataSet iDs) { DataSet dsGrph = iDs.Copy(); dsGrph.Tables[0].Columns.Add("GR_RATE_MS", typeof(double)); dsGrph.Tables[0].Columns.Add("GR_RATE_TS", typeof(double)); for (int i = 0; i < dsGrph.Tables[0].Rows.Count; i++) { if (dsGrph.Tables[0].Rows[i]["AC_RATE_MS"].ToString() == "-") { dsGrph.Tables[0].Rows[i]["AC_RATE_MS"] = "0"; } dsGrph.Tables[0].Rows[i]["GR_RATE_MS"] = Convert.ToDouble(dsGrph.Tables[0].Rows[i]["AC_RATE_MS"].ToString()); if (dsGrph.Tables[0].Rows[i]["AC_RATE_TS"].ToString() == "-") { dsGrph.Tables[0].Rows[i]["AC_RATE_TS"] = "0"; } dsGrph.Tables[0].Rows[i]["GR_RATE_TS"] = Convert.ToDouble(dsGrph.Tables[0].Rows[i]["AC_RATE_TS"].ToString()); } // 당월그래프 DundasCharts.DundasChartBase(chartMM, ChartImageType.Flash, 385, 230 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); chartMM.DataSource = dsGrph; Series series1 = DundasCharts.CreateSeries(chartMM, "serPlan", "Default", "계획", null, SeriesChartType.Column, 1, GetChartColor2(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(chartMM, "serActl", "Default", "실적", null, SeriesChartType.Column, 1, GetChartColor2(1), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(chartMM, "serRate", "Default", (kpiType == "BTY" ? "한계초과율" : "달성율"), null, SeriesChartType.Line, 1, GetChartColor2(2), GetChartColor2(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series3.YAxisType = AxisType.Secondary; series1.ValueMembersY = "TARGET_MS"; series2.ValueMembersY = "RESULT_MS"; series3.ValueMembersY = "GR_RATE_MS"; series1.ValueMemberX = "MM"; series1.ToolTip = "#VALY{N0}"; series2.ToolTip = "#VALY{N0}"; series3.ToolTip = "#VALY{P0}"; string sChartArea = chartMM.Series[series2.Name].ChartArea; chartMM.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0"; chartMM.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "P0"; DundasAnimations.DundasChartBase(chartMM, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chartMM, series1, 1.0, 1.0, true); DundasAnimations.GrowingAnimation(chartMM, series2, 2.0, 2.0, true); DundasAnimations.GrowingAnimation(chartMM, series3, 2.0, 1.0, true); chartMM.DataBind(); }
private void BindingChart(Dundas.Charting.WebControl.Chart chart, string yearStr, string monthStr, string type) { string typeStr = ""; chart.DataSource = GetChartDataTable(yearStr, monthStr, type).DefaultView; DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(chart, "Series1", "Default", "계획", null, SeriesChartType.Column, 1, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(chart, "Series2", "Default", "실적", null, SeriesChartType.Column, 1, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(chart, "Series3", "Default", "집행율", null, SeriesChartType.Line, 3, GetChartColor(2), GetChartColor(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //Series series4 = DundasCharts.CreateSeries(chart, "Series4", "Default", "협력업체", null, SeriesChartType.Line, 1, Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); if (type.Equals("1")) { typeStr = ""; } else { typeStr = "SUM_"; } series1.ValueMemberX = "MONTH"; series1.ValueMembersY = "EMP_" + typeStr + "PLAN"; series2.ValueMembersY = "EMP_" + typeStr + "ACTUAL"; series3.ValueMembersY = "EMP_" + typeStr + "ACHIVE"; series3.YAxisType = AxisType.Secondary; //series3.ValueMembersY = "T_" + Convert.ToString(int.Parse(yearStr) - 1); //series4.ValueMembersY = "T_40000"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.0, 2.0, false); DundasAnimations.GrowingAnimation(chart, series2, 1.0, 3.0, true); DundasAnimations.GrowingAnimation(chart, series3, 0.5, 1.0, true); //DundasAnimations.GrowingAnimation(chart, series4, 6.0, 8.0, true); //series1.MarkerStyle = MarkerStyle.Circle; //series2.MarkerStyle = MarkerStyle.Diamond; //series3.MarkerStyle = MarkerStyle.Triangle; //series4.MarkerStyle = MarkerStyle.Square; //series1.MarkerColor = Color.FromArgb(0x7A, 0x9D, 0xFE); //series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); //series3.MarkerColor = Color.FromArgb(0x20, 0xE4, 0xEB); //series4.MarkerColor = Color.FromArgb(0xE4, 0xE4, 0xE4); //series1.MarkerBorderColor = Color.FromArgb(0x4A, 0x58, 0x7E); //series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); //series3.MarkerBorderColor = Color.FromArgb(0x00, 0xC4, 0xCB); //series4.MarkerBorderColor = Color.FromArgb(0xE4, 0xE4, 0xE4); chart.ChartAreas["Default"].AxisY2.LabelStyle.Format = "P0"; }
private void _setGraph(DataSet dsGrph1, DataSet dsGrph2) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 400, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 400, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "계획", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(Chart1, "Series2", "Default", "실적", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(Chart1, "Series3", "Default", "달성율", null, SeriesChartType.Line, 3, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series4 = DundasCharts.CreateSeries(Chart2, "Series4", "Default", "계획", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series5 = DundasCharts.CreateSeries(Chart2, "Series5", "Default", "실적", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series6 = DundasCharts.CreateSeries(Chart2, "Series6", "Default", "달성율", null, SeriesChartType.Line, 3, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Chart1.DataSource = dsGrph1; Chart1.Series[series1.Name].ValueMembersY = "A_PLAN"; Chart1.Series[series2.Name].ValueMembersY = "A_ACTL"; Chart1.Series[series3.Name].ValueMembersY = "A_RATE"; Chart1.Series[series1.Name].ValueMemberX = "MM"; string strChartArea = Chart1.Series[series3.Name].ChartArea; series3.YAxisType = AxisType.Secondary; //Chart1.ChartAreas[series3.Name].AxisY.LabelStyle.Format = "P0"; Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, series1, 0.0, 1.0, true); DundasAnimations.GrowingAnimation(Chart1, series2, 1.0, 2.0, true); DundasAnimations.GrowingAnimation(Chart1, series3, 1.0, 2.0, true); //------------------------------------------------------Chart - METAN Chart2.DataSource = dsGrph2; Chart2.Series[series4.Name].ValueMembersY = "A_PLAN"; Chart2.Series[series5.Name].ValueMembersY = "A_ACTL"; Chart2.Series[series6.Name].ValueMembersY = "A_RATE"; Chart2.Series[series4.Name].ValueMemberX = "MM"; strChartArea = Chart2.Series[series6.Name].ChartArea; series6.YAxisType = AxisType.Secondary; //Chart2.ChartAreas[series3.Name].AxisY.LabelStyle.Format = "P0"; Chart2.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; DundasAnimations.DundasChartBase(Chart2, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart2, series4, 0.0, 1.0, true); DundasAnimations.GrowingAnimation(Chart2, series5, 1.0, 2.0, true); DundasAnimations.GrowingAnimation(Chart2, series6, 1.0, 2.0, true); }
private void setGrph(DataSet dsGrid) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series[] oasrType = new Series[dsGrid.Tables[0].Rows.Count]; int intLP = 0; foreach (DataRow row in dsGrid.Tables[0].Rows) { if (row["내역"].ToString() == "달성율") { oasrType[intLP] = DundasCharts.CreateSeries(Chart1, "Series" + intLP.ToString(), Chart1.ChartAreas[0].Name, row["내역"].ToString(), null, SeriesChartType.Line, 3, GetChartColor(intLP), GetChartColor(intLP), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); string strChartArea = Chart1.Series[oasrType[intLP].Name].ChartArea; oasrType[intLP].YAxisType = AxisType.Secondary; Chart1.ChartAreas[strChartArea].AxisY2.LabelStyle.Format = "P0"; } else { oasrType[intLP] = DundasCharts.CreateSeries(Chart1, "Series" + intLP.ToString(), Chart1.ChartAreas[0].Name, row["내역"].ToString(), null, SeriesChartType.Column, 0, GetChartColor(intLP), GetChartColor(intLP), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); } for (int colIndex = 3; colIndex < dsGrid.Tables[0].Columns.Count; colIndex++) { // For each column (column 1 and onward) add the value as a point string columnName = dsGrid.Tables[0].Columns[colIndex].ColumnName; double YVal = double.Parse(row[columnName].ToString()); Chart1.Series[oasrType[intLP].Name].Points.AddXY(columnName, YVal); } intLP += 1; } DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); for (int i = 0; i < oasrType.Length; i++) { if (i == 0) { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], 0.5, 1.0, false); } else { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], i + 0.1, 1.0, true); } } Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,##0"; Chart1.DataSource = dsGrid.Tables[0].DefaultView; Chart1.DataBind(); }
private void _setGraph(DataSet dsLine) { string strCYY = "2006"; string strFYY = (int.Parse(strCYY) - 2).ToString(); string strPYY = (int.Parse(strCYY) - 1).ToString(); string strCMM = "06"; //strCYY = strCYY + "년"; // 년도별 매출량 그래프 DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 270 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); //================================================================== LINE GRAPH Series[] oasrType = new Series[dsLine.Tables[0].Rows.Count]; int intLP = 0; foreach (DataRow row in dsLine.Tables[0].Rows) { oasrType[intLP] = DundasCharts.CreateSeries(Chart1, "Series" + intLP.ToString(), Chart1.ChartAreas[0].Name, row["AREA_NM"].ToString(), null, SeriesChartType.Line, 3, GetChartColor(intLP), GetChartColor(intLP), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); for (int colIndex = 1; colIndex < dsLine.Tables[0].Columns.Count; colIndex++) { // For each column (column 1 and onward) add the value as a point string columnName = dsLine.Tables[0].Columns[colIndex].ColumnName; double YVal = double.Parse(row[columnName].ToString()); Chart1.Series[oasrType[intLP].Name].Points.AddXY(columnName, YVal); } intLP += 1; } DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); for (int i = 0; i < oasrType.Length; i++) { //oasrType[i].MarkerStyle = GetMarkerStyle(i); //oasrType[i].MarkerColor = GetChartColor(i); //oasrType[i].MarkerBorderColor = GetMarkerBorderColor(i); if (i == 0) { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], 0.5, 1.0, false); } else { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], i + 0.1, 1.0, true); } } Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; Chart1.DataSource = dsLine.Tables[0].DefaultView; Chart1.DataBind(); }
//private void SetDropDownListItem(System.Web.UI.WebControls.DropDownList ddlItem) //{ // string query = @"SELECT DISTINCT ITMU_IDX, ITMU_NAME FROM D_ITEM_UTIL"; // dbAgent = new DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["EISDB"].ConnectionString); // DataSet ds = dbAgent.FillDataSet(query, "Data"); // ddlItem.DataSource = ds; // ddlItem.DataValueField = "ITMU_IDX"; // ddlItem.DataTextField = "ITMU_NAME"; // ddlItem.DataBind(); //} private void BindingChart_1(Dundas.Charting.WebControl.Chart chart, string yearStr) { string query_item = @"SELECT PAN_ITMNM from D_ITEM_PANMAE WHERE PAN_ITMNM LIKE '%락탐%' GROUP BY PAN_ITMNM"; dbAgent = new DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["EISDB"].ConnectionString); DataSet ds_item = dbAgent.FillDataSet(query_item, "Data"); //chart.DataSource = GetChartDataTable_1(yearStr).DefaultView; //DataGrid1.DataSource = GetChartDataTable(yearStr).DefaultView; //DataGrid1.DataBind(); DataTable dt = GetChartDataTable_1(yearStr); DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 800, 182 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series = null; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); for (int i = 0; i < ds_item.Tables[0].Rows.Count; i++) { series = DundasCharts.CreateSeries(chart, "Series" + i.ToString(), "Default", ds_item.Tables[0].Rows[i]["PAN_ITMNM"].ToString(), null, SeriesChartType.Line, 3, GetChartColor(i), GetChartColor(i), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //series.ValueMembersY = "C_" + ds_item.Tables[0].Rows[i]["PAN_IDX"].ToString(); DatabaseBindingXY(series, "MONTH", "C_" + ds_item.Tables[0].Rows[i]["PAN_ITMNM"].ToString(), dt); DundasAnimations.GrowingAnimation(chart, series, i, (i + 1), false); if (ds_item.Tables[0].Rows[i]["PAN_ITMNM"].ToString() == "용융락탐") { series.YAxisType = AxisType.Secondary; } series.MarkerStyle = GetMarkerStyle(i); series.MarkerColor = GetChartColor(i); series.MarkerBorderColor = GetChartColor(i); series.ToolTip = "#VALY{N0}"; //if (ds_item.Tables[0].Rows[i]["PAN_ITMNM"].ToString().IndexOf("공업용유안25Kg(Pk)") < 0) // series.YAxisType = AxisType.Secondary; string sChartArea = chart.Series[series.Name].ChartArea; chart.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0"; chart.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "N0"; //SetZeroPoint(chart, int.Parse(ddlYear.SelectedValue)); } SetVisibleZeroPoint(chart, Convert.ToInt32(PageUtility.GetByValueDropDownList(ddlYear))); Font font1 = new Font("Gulim", 9, FontStyle.Regular); Legend legend = DundasCharts.CreateLegend(chart, "Default", Color.Transparent, Color.Empty, Color.Empty, font1, true, -1, -1, -1, -1); DundasCharts.SetChartArea(chart.ChartAreas["Default"], false); }
private void DrawChart(DataTable dt) { DataTable dtGrph = dt.Copy(); dtGrph.Columns.Add("YMD_NAME"); for (int i = 0; i < dtGrph.Rows.Count; i++) { string ymd = DataTypeUtility.GetString(dtGrph.Rows[i]["YMD"]); string year = ymd.Substring(0, 4); string month = ymd.Replace(year, ""); dtGrph.Rows[i]["YMD_NAME"] = DataTypeUtility.GetToInt32(month).ToString() + "월"; } DundasCharts.DundasChartBase(chart_score , Dundas.Charting.WebControl.ChartImageType.Flash , DataTypeUtility.GetToInt32(Math.Ceiling(chart_score.Width.Value)) , DataTypeUtility.GetToInt32(Math.Ceiling(chart_score.Height.Value)) , Dundas.Charting.WebControl.BorderSkinStyle.None , Color.FromArgb(181, 64, 1) , 0 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0x20, 0x80, 0xD0) , Dundas.Charting.WebControl.ChartDashStyle.Solid , -1 , Dundas.Charting.WebControl.ChartHatchStyle.None , GradientType.TopBottom , AntiAliasing.None); chart_score.DataSource = dtGrph; string y_value_col_name = "SCORE"; Dundas.Charting.WebControl.Series series1 = DundasCharts.CreateSeries(chart_score, y_value_col_name, "Default", "점수", null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, GetChartColor2(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle; series1.ValueMemberX = "YMD_NAME"; series1.ValueMembersY = y_value_col_name; series1.ToolTip = "#VALY{N0}"; series1.Label = "#VALY{N0}"; DundasAnimations.DundasChartBase(chart_score, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart_score, series1, 0.5, 2.0, true); chart_score.DataBind(); }
private void drawGraph(DataSet dsGrid) { string strCYY = cboYY.SelectedValue; string strPYY = Convert.ToString(int.Parse(cboYY.SelectedValue.ToString()) - 1); DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series[] oasrType = new Series[dsGrid.Tables[0].Rows.Count]; int intLP = 0; foreach (DataRow row in dsGrid.Tables[0].Rows) { // For each Row add a new series oasrType[intLP] = DundasCharts.CreateSeries(Chart1, "Series" + intLP.ToString(), Chart1.ChartAreas[0].Name, row["년도"].ToString(), null, SeriesChartType.Line, 3, GetChartColor(intLP), GetChartColor(intLP), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); for (int colIndex = 1; colIndex < dsGrid.Tables[0].Columns.Count; colIndex++) { // For each column (column 1 and onward) add the value as a point string columnName = dsGrid.Tables[0].Columns[colIndex].ColumnName; double YVal = double.Parse(row[columnName].ToString()); Chart1.Series[oasrType[intLP].Name].Points.AddXY(columnName, YVal); } intLP += 1; } DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); for (int i = 0; i < oasrType.Length; i++) { if (i == 0) { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], 0.5, 1.0, true); } else { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], i + 0.1, 1.0, true); } oasrType[i].MarkerStyle = GetMarkerStyle(i); oasrType[i].MarkerColor = GetChartColor(i); oasrType[i].MarkerBorderColor = GetChartColor(i); } Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,###.#0"; Chart1.DataSource = dsGrid.Tables[0].DefaultView.Sort = "년도 DESC"; Chart1.DataBind(); }
private void ChartBinding() { Chart1.DataSource = GetDTChart(); #region 챠트 초기화 DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); #endregion // 시리즈 생성 Series ddcSer_Col_1 = DundasCharts.CreateSeries(Chart1, "ddcSer_Col_1", "Default", "매출계획", null, SeriesChartType.Column, 1, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series ddcSer_Col_2 = DundasCharts.CreateSeries(Chart1, "ddcSer_Col_2", "Default", "매출실적", null, SeriesChartType.Column, 1, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series ddcSer_Line_1 = DundasCharts.CreateSeries(Chart1, "ddcSer_Line_1", "Default", "매출총이익률", null, SeriesChartType.Line, 3, GetChartColor(2), GetChartColor(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series ddcSer_Line_2 = DundasCharts.CreateSeries(Chart1, "ddcSer_Line_2", "Default", "영업이익률", null, SeriesChartType.Line, 3, GetChartColor(3), GetChartColor(3), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series ddcSer_Line_3 = DundasCharts.CreateSeries(Chart1, "ddcSer_Line_3", "Default", "OI/GI Ratio", null, SeriesChartType.Line, 3, GetChartColor(4), GetChartColor(4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); ddcSer_Col_1.ValueMembersY = "v_Plan"; ddcSer_Col_2.ValueMembersY = "v_SALE"; ddcSer_Line_1.ValueMembersY = "V_TotSaleRate"; ddcSer_Line_2.ValueMembersY = "v_BizProfitRate"; ddcSer_Line_3.ValueMembersY = "v_OGRatio"; ddcSer_Col_1.ValueMemberX = "V_MONTH"; string sChartArea = Chart1.Series[ddcSer_Line_1.Name].ChartArea; ddcSer_Line_1.YAxisType = AxisType.Secondary; ddcSer_Line_2.YAxisType = AxisType.Secondary; ddcSer_Line_3.YAxisType = AxisType.Secondary; Chart1.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "P0"; DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, ddcSer_Line_1, 0.0, 1.0, true); DundasAnimations.GrowingAnimation(Chart1, ddcSer_Line_2, 0.5, 1.0, true); DundasAnimations.GrowingAnimation(Chart1, ddcSer_Line_3, 1.0, 1.0, true); ddcSer_Line_1.MarkerStyle = GetMarkerStyle(2); ddcSer_Line_1.MarkerColor = GetChartColor(2); ddcSer_Line_1.MarkerBorderColor = GetChartColor(2); ddcSer_Line_2.MarkerStyle = GetMarkerStyle(3); ddcSer_Line_2.MarkerColor = GetChartColor(3); ddcSer_Line_2.MarkerBorderColor = GetChartColor(3); ddcSer_Line_3.MarkerStyle = GetMarkerStyle(4); ddcSer_Line_3.MarkerColor = GetChartColor(4); ddcSer_Line_3.MarkerBorderColor = GetChartColor(4); }
//private void SetDropDownListItem(System.Web.UI.WebControls.DropDownList ddlItem) //{ // string query = @"SELECT DISTINCT ITMU_IDX, ITMU_NAME FROM D_ITEM_UTIL"; // dbAgent = new DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["EISDB"].ConnectionString); // DataSet ds = dbAgent.FillDataSet(query, "Data"); // ddlItem.DataSource = ds; // ddlItem.DataValueField = "ITMU_IDX"; // ddlItem.DataTextField = "ITMU_NAME"; // ddlItem.DataBind(); //} private void BindingChart(Dundas.Charting.WebControl.Chart chart, string yearStr) { string query_item = @"SELECT PAN_IDX, PAN_ITMNM from D_ITEM_PANMAE WHERE PAN_ITMNM LIKE '%유안%'"; dbAgent = new DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["EISDB"].ConnectionString); DataSet ds_item = dbAgent.FillDataSet(query_item, "Data"); chart.DataSource = GetChartDataTable(yearStr).DefaultView; //DataGrid1.DataSource = GetChartDataTable(yearStr).DefaultView; //DataGrid1.DataBind(); DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 800, 450 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series = null; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); for (int i = 0; i < ds_item.Tables[0].Rows.Count; i++) { series = DundasCharts.CreateSeries(chart, "Series" + i.ToString(), "Default", ds_item.Tables[0].Rows[i]["PAN_ITMNM"].ToString(), null, SeriesChartType.Line, 3, GetChartColor(i), GetChartColor(i), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series.ValueMembersY = "C_" + ds_item.Tables[0].Rows[i]["PAN_IDX"].ToString(); DundasAnimations.GrowingAnimation(chart, series, 2 * i, 2 * (i + 1), false); series.MarkerStyle = GetMarkerStyle(i); series.MarkerColor = GetChartColor(i); series.MarkerBorderColor = GetChartColor(i); //if (ds_item.Tables[0].Rows[i]["PAN_ITMNM"].ToString().IndexOf("공업용유안25Kg(Pk)") < 0) // series.YAxisType = AxisType.Secondary; if (i == 0) { series.ValueMemberX = "MONTH"; } } chart.Legends.Add(new Legend("test")); Chart1.Legends["test"].Alignment = StringAlignment.Center; Chart1.Legends["test"].Docking = LegendDocking.Top; Chart1.Legends["test"].ShadowOffset = 0; Chart1.Legends["test"].LegendStyle = LegendStyle.Row; Chart1.Legends["test"].Font = new Font(Chart1.Legends["Default"].Font.FontFamily, 9); Font font1 = new Font("Gulim", 9, FontStyle.Regular); Legend legend = DundasCharts.CreateLegend(Chart1, "Default", Color.Transparent, Color.Empty, Color.Empty, font1, true, -1, -1, -1, -1); DundasCharts.SetChartArea(Chart1.ChartAreas["Default"], false); }
private void _setGraph(DataSet dsGrph) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 500, 300 , BorderSkinStyle.None, Color.FromArgb(181, 64, 1), 0 , Color.FromArgb(247, 243, 247) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , Dundas.Charting.WebControl.ChartHatchStyle.None, Dundas.Charting.WebControl.GradientType.None, Dundas.Charting.WebControl.AntiAliasing.Graphics); DataTable dtSply = dsGrph.Tables[0].Clone(); DataRow drSply; string strMM = ""; double dblCQtn = 0.00; double dblPQtn = 0.00; for (int i = 0; i < dsGrph.Tables[0].Rows.Count; i++) { drSply = dtSply.NewRow(); strMM = dsGrph.Tables[0].Rows[i][0].ToString(); dblCQtn += Convert.ToDouble(dsGrph.Tables[0].Rows[i]["CD_QTN"].ToString()); dblPQtn += Convert.ToDouble(dsGrph.Tables[0].Rows[i]["PD_QTN"].ToString()); drSply[0] = strMM; drSply[1] = dblCQtn; drSply[2] = dblPQtn; dtSply.Rows.Add(drSply); } Chart1.DataSource = dtSply.DefaultView; Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "금일", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(Chart1, "Series2", "Default", "전일", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.ValueMembersY = "CD_QTN"; series2.ValueMembersY = "PD_QTN"; series1.ValueMemberX = "HH"; Chart1.ChartAreas[Chart1.Series[series1.Name].ChartArea].AxisX.Interval = 1; Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; Chart1.ChartAreas[0].AxisY2.Enabled = AxisEnabled.False; //Chart1.Series[series1.Name].ToolTip = "X value \t= #VALX{d}\nY value \t= #VALY{C}\nRadius \t= #VALY2{P}"; Chart1.Series[series1.Name].ToolTip = "Hour \t= #VALX{d}\n Supply Qnt \t= #VALY{C}"; Chart1.Series[series2.Name].ToolTip = "X value \t= #VALX{d}\nY value \t= #VALY{C}\nRadius \t= #VALY2{P}"; DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, series1, 0.0, 3.0, true); DundasAnimations.GrowingAnimation(Chart1, series2, 3.0, 4.0, true); Chart1.DataBind(); }
private void _setGraph(DataSet dsLine) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series[] oasrType = new Series[dsLine.Tables[0].Columns.Count - 1]; int intLP = 0; string strColNm = ""; for (intLP = 1; intLP < dsLine.Tables[0].Columns.Count; intLP++) { strColNm = dsLine.Tables[0].Columns[intLP].ColumnName; oasrType[intLP - 1] = DundasCharts.CreateSeries(Chart1, "Series" + intLP.ToString(), Chart1.ChartAreas[0].Name, strColNm, null, SeriesChartType.Line, 3, GetChartColor(intLP - 1), GetChartColor(intLP - 1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Chart1.Series[oasrType[intLP - 1].Name].ValueMemberX = "월"; Chart1.Series[oasrType[intLP - 1].Name].ValueMembersY = strColNm; } Chart1.DataSource = dsLine; Chart1.DataBind(); DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); for (int i = 0; i < oasrType.Length; i++) { if (i == 0) { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], 0.5, 1.0, true); } else { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], i + 0.1, 1.0, true); } oasrType[i].MarkerStyle = GetMarkerStyle(i); oasrType[i].MarkerColor = GetChartColor(i); oasrType[i].MarkerBorderColor = GetChartColor(i); } Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,##0.0"; Chart1.DataSource = dsLine.Tables[0].DefaultView; Chart1.DataBind(); }
private void _setGraph(DataSet dsGrid) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series[] oasrType = new Series[dsGrid.Tables[0].Rows.Count]; int intLP = 0; foreach (DataRow row in dsGrid.Tables[0].Rows) { // For each Row add a new series if (dsGrid.Tables[0].Rows[0]["년도"].Equals(cboYY.SelectedValue.ToString()) && intLP < 2) { oasrType[intLP] = DundasCharts.CreateSeries(Chart1, "Series" + intLP.ToString(), Chart1.ChartAreas[0].Name, row["구분"].ToString(), null, SeriesChartType.Column, 1, GetChartColor(intLP), GetChartColor(intLP), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); for (int colIndex = 2; colIndex < dsGrid.Tables[0].Columns.Count; colIndex++) { // For each column (column 1 and onward) add the value as a point string columnName = dsGrid.Tables[0].Columns[colIndex].ColumnName; double YVal = double.Parse(row[columnName].ToString()); Chart1.Series[oasrType[intLP].Name].Points.AddXY(columnName, YVal); } } intLP += 1; } DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); for (int i = 0; i < oasrType.Length; i++) { if (i == 0) { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], i, i + 2, true); } else { DundasAnimations.GrowingAnimation(Chart1, oasrType[i], i + 1, i + 3, true); } } Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; Chart1.DataSource = dsGrid.Tables[0].DefaultView; Chart1.DataBind(); }
private void GraphAvailablePointBinding(DataTable dataTable) { DundasCharts.DundasChartBase(chartMM , ChartImageType.Flash , 500 , 250 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0x20, 0x80, 0xD0) , ChartDashStyle.Solid , -1 , ChartHatchStyle.None , GradientType.TopBottom , AntiAliasing.None); chartMM.DataSource = dataTable; Series series1 = DundasCharts.CreateSeries(chartMM , "serPlan" , "Default" , "가중치" , null , SeriesChartType.Column , 1 , GetChartColor2(0) , Color.FromArgb(180, 26, 59, 105) , Color.FromArgb(64, 0, 0, 0) , 1 , 9 , Color.FromArgb(64, 64, 64)); series1.Label = "#VALY{P0}"; series1.ValueMembersY = "WEIGHT"; series1.ValueMemberX = "STG_NAME"; series1.ToolTip = "#VALY{P0}"; chartMM.ChartAreas["Default"].AxisY.LabelStyle.Format = "P0"; DundasAnimations.DundasChartBase(chartMM, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chartMM, series1, 0.5, 1.5, true); chartMM.DataBind(); }
private void BindingChart(Dundas.Charting.WebControl.Chart chart, string yearStr) { //DataSet ds = GetDataSet(GetChartQuery(yearStr)); chart.DataSource = GetDataTable(yearStr).DefaultView; int cYear = int.Parse(yearStr.Substring(0, 4)); int pYear = cYear - 1; DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(chart, "Series1", "Default", pYear.ToString() + "상반기", null, SeriesChartType.Line, 3, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(chart, "Series2", "Default", pYear.ToString() + "하반기", null, SeriesChartType.Line, 3, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(chart, "Series3", "Default", cYear.ToString() + "상반기", null, SeriesChartType.Line, 3, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series4 = DundasCharts.CreateSeries(chart, "Series4", "Default", cYear.ToString() + "하반기", null, SeriesChartType.Line, 3, Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.ValueMemberX = "SEM_CODE2_NAME"; series1.ValueMembersY = "T_" + pYear + "_1"; series2.ValueMembersY = "T_" + pYear + "_2"; series3.ValueMembersY = "T_" + cYear + "_3"; series4.ValueMembersY = "T_" + cYear + "_4"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.0, 2.0, false); DundasAnimations.GrowingAnimation(chart, series2, 2.0, 3.0, true); DundasAnimations.GrowingAnimation(chart, series3, 3.0, 5.0, true); DundasAnimations.GrowingAnimation(chart, series4, 5.0, 6.0, true); series1.MarkerStyle = MarkerStyle.Circle; series2.MarkerStyle = MarkerStyle.Diamond; series3.MarkerStyle = MarkerStyle.Triangle; series4.MarkerStyle = MarkerStyle.Square; series1.MarkerColor = Color.FromArgb(0x7A, 0x9D, 0xFE); series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); series3.MarkerColor = Color.FromArgb(0x20, 0xE4, 0xEB); series4.MarkerColor = Color.FromArgb(0xE4, 0xE4, 0xE4); series1.MarkerBorderColor = Color.FromArgb(0x4A, 0x58, 0x7E); series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); series3.MarkerBorderColor = Color.FromArgb(0x00, 0xC4, 0xCB); series4.MarkerBorderColor = Color.FromArgb(0xE4, 0xE4, 0xE4); }
private void BindingChart(Dundas.Charting.WebControl.Chart chart, string yearStr, string monthStr) { //DataGrid1.DataSource = GetChartDataTable(yearStr, monthStr); //DataGrid1.DataBind(); chart.DataSource = GetChartDataTable(yearStr, monthStr).DefaultView; DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(chart, "Series1", "Default", "당년 실적", null, SeriesChartType.Line, 3, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(chart, "Series2", "Default", "전년 실적", null, SeriesChartType.Line, 3, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //Series series4 = DundasCharts.CreateSeries(chart, "Series4", "Default", "협력업체", null, SeriesChartType.Line, 1, Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.ValueMemberX = "Month"; series1.ValueMembersY = "T_1"; series2.ValueMembersY = "T_2"; //series3.ValueMembersY = "T_" + Convert.ToString(int.Parse(yearStr) - 1); //series4.ValueMembersY = "T_40000"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.0, 1.0, false); DundasAnimations.GrowingAnimation(chart, series2, 0.5, 1.0, true); //DundasAnimations.GrowingAnimation(chart, series3, 4.0, 6.0, true); //DundasAnimations.GrowingAnimation(chart, series4, 6.0, 8.0, true); series1.MarkerStyle = MarkerStyle.Circle; series2.MarkerStyle = MarkerStyle.Diamond; //series3.MarkerStyle = MarkerStyle.Triangle; //series4.MarkerStyle = MarkerStyle.Square; series1.MarkerColor = Color.FromArgb(0x7A, 0x9D, 0xFE); series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); //series3.MarkerColor = Color.FromArgb(0x20, 0xE4, 0xEB); //series4.MarkerColor = Color.FromArgb(0xE4, 0xE4, 0xE4); series1.MarkerBorderColor = Color.FromArgb(0x4A, 0x58, 0x7E); series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); //series3.MarkerBorderColor = Color.FromArgb(0x00, 0xC4, 0xCB); //series4.MarkerBorderColor = Color.FromArgb(0xE4, 0xE4, 0xE4); }
private void ChartBinding() { #region 챠트 초기화 DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); #endregion #region Chart1 셋팅 START // 시리즈 생성 Series ddcSer_C1_1 = DundasCharts.CreateSeries(Chart1, "ddcSer_C1_1", "Default", "예산", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series ddcSer_C1_2 = DundasCharts.CreateSeries(Chart1, "ddcSer_C1_2", "Default", "실적", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series ddcSer_C1_3 = DundasCharts.CreateSeries(Chart1, "ddcSer_C1_3", "Default", "집행율", null, SeriesChartType.Line, 3, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); double Rate = 0; Chart1.DataSource = GetDTChart(); ddcSer_C1_1.ValueMemberX = "capt_date_t"; ddcSer_C1_1.ValueMembersY = "v_SumPlan"; ddcSer_C1_2.ValueMembersY = "v_SumActual"; ddcSer_C1_3.ValueMembersY = "v_Rate"; string sChartArea = Chart1.Series[ddcSer_C1_3.Name].ChartArea; ddcSer_C1_3.YAxisType = AxisType.Secondary; Chart1.ChartAreas[sChartArea].AxisY2.Minimum = 0; //Chart1.ChartAreas[sChartArea].AxisY2.Maximum = dAxis2MaxRate + 10; Chart1.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "P0"; DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, ddcSer_C1_1, 0.0, 1.0, true); DundasAnimations.GrowingAnimation(Chart1, ddcSer_C1_2, 1.0, 2.0, true); DundasAnimations.GrowingAnimation(Chart1, ddcSer_C1_3, 0.5, 1.0, true); ddcSer_C1_3.MarkerStyle = GetMarkerStyle(2); ddcSer_C1_3.MarkerColor = GetChartColor(2); ddcSer_C1_3.MarkerBorderColor = GetChartColor(2); #endregion Chart1 셋팅 END }
private void BindingChart(Dundas.Charting.WebControl.Chart chart, string yearStr, string monthStr, string areaStr, string type) { chart.DataSource = GetChartDataTable(yearStr, monthStr, areaStr, type).DefaultView; DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(chart, "Series1", "Default", "예산", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(chart, "Series2", "Default", "실적", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(chart, "Series3", "Default", "집행률", null, SeriesChartType.Line, 3, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //Series series4 = DundasCharts.CreateSeries(chart, "Series4", "Default", "협력업체", null, SeriesChartType.Line, 1, Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.ValueMemberX = "MONTH_NAME"; series1.ValueMembersY = "BUDGET"; series2.ValueMembersY = "ACTUAL"; series3.ValueMembersY = "RATE"; //series4.ValueMembersY = "T_40000"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.5, 1.0, false); DundasAnimations.GrowingAnimation(chart, series2, 1.0, 2.0, true); DundasAnimations.GrowingAnimation(chart, series3, 1.0, 2.0, true); //DundasAnimations.GrowingAnimation(chart, series4, 6.0, 8.0, true); //series1.MarkerStyle = MarkerStyle.Circle; //series2.MarkerStyle = MarkerStyle.Diamond; //series3.MarkerStyle = MarkerStyle.Triangle; //series4.MarkerStyle = MarkerStyle.Square; //series1.MarkerColor = Color.FromArgb(0x7A, 0x9D, 0xFE); //series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); //series3.MarkerColor = Color.FromArgb(0x20, 0xE4, 0xEB); //series4.MarkerColor = Color.FromArgb(0xE4, 0xE4, 0xE4); //series1.MarkerBorderColor = Color.FromArgb(0x4A, 0x58, 0x7E); //series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); //series3.MarkerBorderColor = Color.FromArgb(0x00, 0xC4, 0xCB); //series4.MarkerBorderColor = Color.FromArgb(0xE4, 0xE4, 0xE4); }
private void setGraph(DataTable dtGrph) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); string strLgdText = rBtnType.SelectedItem.Text + "평균학점" + " (" + ddlTerm.SelectedItem.Text + ")"; Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", strLgdText, null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Chart1.DataSource = dtGrph.DefaultView; series1.ValueMembersY = (ddlTerm.SelectedValue.Equals("MS")) ? "평균학점" : "평균 학점"; series1.ValueMemberX = (rBtnType.SelectedValue.Equals("1")) ? "부문명" : "팀명"; Chart1.DataBind(); DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, series1, 0.0, 3.0, false); }
private void BindingChartThreeYear(Dundas.Charting.WebControl.Chart chart, string yearStr, string monthStr, string type, string gubn) { chart.DataSource = GetChartDataTableThreeYear(yearStr, monthStr, type, gubn).DefaultView; DundasCharts.DundasChartBase(chart, ChartImageType.Flash, 400, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(chart, "Series4", "Default", Convert.ToString(int.Parse(yearStr) - 0) + "년", null, SeriesChartType.Line, 3, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(chart, "Series5", "Default", Convert.ToString(int.Parse(yearStr) - 1) + "년", null, SeriesChartType.Line, 3, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(chart, "Series6", "Default", Convert.ToString(int.Parse(yearStr) - 2) + "년", null, SeriesChartType.Line, 3, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //Series series4 = DundasCharts.CreateSeries(chart, "Series4", "Default", "협력업체", null, SeriesChartType.Line, 1, Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.ValueMemberX = "MONTH"; series1.ValueMembersY = "RATE_ADJUST" + Convert.ToString(int.Parse(yearStr) - 0); series2.ValueMembersY = "RATE_ADJUST" + Convert.ToString(int.Parse(yearStr) - 1); series3.ValueMembersY = "RATE_ADJUST" + Convert.ToString(int.Parse(yearStr) - 2); DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.0, 1.0, false); DundasAnimations.GrowingAnimation(chart, series2, 1.0, 1.5, true); DundasAnimations.GrowingAnimation(chart, series3, 1.0, 2.0, true); series1.MarkerStyle = MarkerStyle.Circle; series2.MarkerStyle = MarkerStyle.Diamond; series3.MarkerStyle = MarkerStyle.Triangle; series1.MarkerColor = Color.FromArgb(0x7A, 0x9D, 0xFE); series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); series3.MarkerColor = Color.FromArgb(0x20, 0xE4, 0xEB); series1.MarkerBorderColor = Color.FromArgb(0x4A, 0x58, 0x7E); series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); series3.MarkerBorderColor = Color.FromArgb(0x00, 0xC4, 0xCB); }
private void ChartBinding() { Chart1.DataSource = GetDTChart(); #region 챠트 초기화 DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); #endregion // 시리즈 생성 Series ddcSer_Col_1 = DundasCharts.CreateSeries(Chart1, "ddcSer_Col_1", "Default", "계획", null, SeriesChartType.Column, 1, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series ddcSer_Col_2 = DundasCharts.CreateSeries(Chart1, "ddcSer_Col_2", "Default", "실적", null, SeriesChartType.Column, 1, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series ddcSer_Line_1 = DundasCharts.CreateSeries(Chart1, "ddcSer_Line_1", "Default", "집행율", null, SeriesChartType.Line, 3, GetChartColor(2), GetChartColor(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series ddcSer_Line_2 = DundasCharts.CreateSeries(Chart1, "ddcSer_Line_2", "Default", "차이량", null, SeriesChartType.Column, 3, GetChartColor(6), GetChartColor(6), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); ddcSer_Col_1.ValueMembersY = "PLAN"; ddcSer_Col_2.ValueMembersY = "ACTUAL"; ddcSer_Line_1.ValueMembersY = "RATE"; ddcSer_Line_2.ValueMembersY = "DIFF"; ddcSer_Col_1.ValueMemberX = "YYYYMM"; string sChartArea = Chart1.Series[ddcSer_Line_1.Name].ChartArea; ddcSer_Line_1.YAxisType = AxisType.Secondary; Chart1.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "P0"; DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, ddcSer_Col_1, 0.0, 1.0, true); DundasAnimations.GrowingAnimation(Chart1, ddcSer_Col_2, 1.0, 2.0, true); DundasAnimations.GrowingAnimation(Chart1, ddcSer_Line_1, 0.5, 1.0, true); DundasAnimations.GrowingAnimation(Chart1, ddcSer_Line_2, 1.0, 1.0, true); //ddcSer_Line_1.MarkerStyle = GetMarkerStyle(0); //ddcSer_Line_1.MarkerColor = GetChartColor(2); //ddcSer_Line_1.MarkerBorderColor = GetChartColor(2); }
private void drawGraph(DataSet dsGrph) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "1차", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(Chart1, "Series2", "Default", "2차", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Chart1.DataSource = dsGrph.Tables[0].DefaultView; series1.ValueMembersY = "1차"; series2.ValueMembersY = "2차"; series1.ValueMemberX = "SEC_NM"; Chart1.DataBind(); Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "#,##0.#0"; DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, series1, 0.0, 2.0, true); DundasAnimations.GrowingAnimation(Chart1, series2, 2.0, 3.0, true); }
private void _setGraph(DataSet dsGrid, DataSet dsGrph) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 300, 290 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 500, 290 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "매출비중", null, SeriesChartType.Pie, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.FontColor = Color.White; Series series5 = DundasCharts.CreateSeries(Chart2, "Series5", "Default", "계획", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series6 = DundasCharts.CreateSeries(Chart2, "Series6", "Default", "실적", null, SeriesChartType.Column, 1, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series7 = DundasCharts.CreateSeries(Chart2, "Series7", "Default", "달성율", null, SeriesChartType.Line, 1, Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(0x00, 0xC4, 0xCB), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //Series series8 = DundasCharts.CreateSeries(Chart2, "Series8", "Default", "실적율", null, SeriesChartType.Point, 1, Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(0xE4, 0xE4, 0xE4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //------------------------------------------------------Chart1 double dblTRAmt = 0.00; DataTableReader drSum = dsGrid.CreateDataReader(); if (drSum.HasRows) { while (drSum.Read()) { dblTRAmt += Convert.ToDouble(drSum["S_RSLT"].ToString()); } } DataTable dtTmp = Tbl_Change_Rate(); DataRow drTmp = null; DataRowCollection drcTmp = dsGrid.Tables[0].Rows; DataRow[] drPie = dsGrid.Tables[0].Select("", "S_RSLT DESC"); double dblRAmt = 0.00; double dblRSum = 0.00; double dblRate = 0.00; for (int i = 0; i < drPie.Length; i++) { dblRAmt = Convert.ToDouble(drPie[i]["S_RSLT"].ToString()); if (dblTRAmt == 0) { dblRate = 0; } else { dblRate = (dblRAmt / dblTRAmt) * 100; } if (i < 3) { drTmp = dtTmp.NewRow(); drTmp["SGubun"] = drPie[i]["SGBUN_NM"].ToString() + "(" + Convert.ToDouble(dblRate.ToString()).ToString("#,##0.#") + "%)"; drTmp["Sale_Rate"] = dblRate; dtTmp.Rows.Add(drTmp); } else { dblRSum += dblRate; } } drTmp = dtTmp.NewRow(); drTmp["SGubun"] = "기타" + "(" + Convert.ToDouble(dblRSum.ToString()).ToString("#,##0.#") + "%)"; drTmp["Sale_Rate"] = dblRSum; dtTmp.Rows.Add(drTmp); Chart1.DataSource = dtTmp.DefaultView; //Chart1.Series[series1.Name]["PieLabelStyle"] = "Outside"; series1.ValueMembersY = "Sale_Rate"; series1.ValueMemberX = "SGubun"; DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart1, series1, 0.0, 3.0, false); //------------------------------------------------------Chart2 Chart2.DataSource = dsGrph.Tables[0].DefaultView; series5.ValueMembersY = "AMT_PLAN"; series6.ValueMembersY = "AMT_ACTL"; series7.ValueMembersY = "ACHV_RATE"; series5.ValueMemberX = "V_MM"; //Chart1.Series["My series"].ToolTip = "X value \t= #VALX{d}\nY value \t= #VALY{C}\nRadius \t= #VALY2{P}"; //Chart2.Series[series5.Name].ToolTip = "MONTH \t= #VALX{d}\nY PLAN \t= #VALY{C}\nRadius \t= #VALY2{P}"; //Chart2.Series[series6.Name].ToolTip = "MONTH \t= #VALX{d}\nY value \t= #VALY{C}\nRadius \t= #VALY2{P}"; //Chart2.Series[series7.Name].ToolTip = "MONTH \t= #VALX{d}\nY value \t= #VALY{C}\nRadius \t= #VALY2{P}"; string strChartArea = Chart2.Series[series7.Name].ChartArea; series7.YAxisType = AxisType.Secondary; double mxRate = 0; double bfRate = 0; double afRate = 0; int intLP = 0; for (intLP = 0; intLP < dsGrph.Tables[0].Rows.Count; intLP++) { bfRate = afRate; afRate = Convert.ToDouble(dsGrph.Tables[0].Rows[intLP]["ACHV_RATE"].ToString()); if (bfRate > afRate && bfRate > mxRate) { mxRate = bfRate; } else if (afRate > bfRate && afRate > mxRate) { mxRate = afRate; } intLP = intLP + 1; } Chart2.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; Chart2.ChartAreas[strChartArea].AxisY2.LabelStyle.Format = "P0"; DundasAnimations.DundasChartBase(Chart2, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(Chart2, series5, 0.0, 1.0, true); DundasAnimations.GrowingAnimation(Chart2, series6, 1.0, 2.0, true); DundasAnimations.GrowingAnimation(Chart2, series7, 1.0, 2.0, true); //DundasAnimations.GrowingAnimation(Chart2, series8, 4.0, 6.0, true); }