//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 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 BindChart(Chart chart , DataTable dt , string titleName , System.Web.UI.WebControls.Label lbl) { DundasCharts.DundasChartBase(chart , ChartImageType.Flash , 480 , 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 , null , SeriesChartType.Doughnut , 1 , GetChartColor(0) , Color.FromArgb(0x4A, 0x58, 0x7E) , Color.FromArgb(64, 0, 0, 0) , 1 , 9 , Color.FromArgb(64, 64, 64)); //series1.Label = "#VALY{N0}"; series1.ToolTip = "#VALY{N0}"; //series1.ShowLabelAsValue = true; //series1.ShowInLegend = true; chart.ChartAreas["Default"].AxisY.LabelStyle.Format = "N0"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.5, 1.5, true); //for (int i = 0; i < dt.Rows.Count; i++) //{ // series1.Points[i].AxisLabel = dt.Rows[i]["ALIAS"].ToString(); //} //for (int i = 0; i < dt.Rows.Count; i++) //{ // series1.Points.AddY(dt.Rows[i]["RESULT_TS"]); //} DataTable dtData = DataTypeUtility.FilterSortDataTable(dt, "KPI_REF_ID > 0"); for (int i = 0; i < dtData.Rows.Count; i++) { series1.Points.AddXY(dt.Rows[i]["TEXT"].ToString(), dt.Rows[i]["RESULT_TS"]); } if (series1.Type == SeriesChartType.Pie || series1.Type == SeriesChartType.Doughnut) { for (int p = 0; p < series1.Points.Count; p++) { DataPoint point = series1.Points[p]; point.Color = GetChartColor(p); } } //series1.ToolTip = "#VALY{#,##0,00}"; //series2.ToolTip = "#VALY{#,##0}"; //series2.MarkerStyle = MarkerStyle.Circle; //series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); //series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); Font font = new Font("Gulim", 11, FontStyle.Regular); Dundas.Charting.WebControl.Title title = DundasCharts.CreateTitle(chart , "Title1" , titleName , font , Color.FromArgb(26, 59, 105) , Color.Empty , Color.Empty , ContentAlignment.TopCenter , null , Color.FromArgb(32, 0, 0, 0) , 3 , false , 5 , 7 , 91 , 6); Legend legend = DundasCharts.CreateLegend(chart , "Default" , Color.Transparent , Color.Empty , Color.Empty); series1.Font = new Font("굴림", 8, FontStyle.Regular); series1["PieLabelStyle"] = "Outside"; legend.LegendStyle = LegendStyle.Table; legend.AutoFitText = false; legend.Docking = LegendDocking.Bottom; //legend.Alignment = StringAlignment.Near; //legend.Position = new ElementPosition(60, 7, 50, 24); //legend.Enabled = false; //legend.DockInsideChartArea = true; //chart.ChartAreas["Default"].AlignOrientation = AreaAlignOrientation.Horizontal; DundasCharts.SetChartArea(chart.ChartAreas["Default"], true); DataRow[] drCol = dt.Select(string.Format("KPI_REF_ID < 0")); if (drCol.Length > 0) { lbl.Text = DataTypeUtility.GetToDouble(drCol[0]["RESULT_TS"]).ToString("#,##0"); } else { lbl.Text = "0"; } }
private void BindChart_ts(Chart chart , DataTable dt , DataTable dt1 , DataTable dt2 , DataTable dt3 , string titleName) { DundasCharts.DundasChartBase(chart , ChartImageType.Flash , 240 , 160 , 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.RangeColumn , 1 , GetChartColor(0) , 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.RangeColumn , 1 , GetChartColor(1) , 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.RangeColumn , 1 , GetChartColor(2) , Color.FromArgb(107, 148, 49) , Color.FromArgb(64, 0, 0, 0) , 1 , 9 , Color.FromArgb(64, 64, 64)); //series1.Label = "#VALY{N0}"; //series2.Label = "#VALY{N0}"; //series3.Label = "#VALY{N0}"; series1.ToolTip = "#VALY{N0}"; series2.ToolTip = "#VALY{N0}"; series3.ToolTip = "#VALY{N0}"; chart.ChartAreas["Default"].AxisY.LabelStyle.Format = "N0"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.5, 1.5, true); DundasAnimations.GrowingAnimation(chart, series2, 0.5, 1.5, true); DundasAnimations.GrowingAnimation(chart, series3, 0.5, 1.5, true); for (int i = 0; i < dt1.Rows.Count; i++) { series1.Points.AddXY(" ", dt1.Rows[i]["VAL"]); } for (int i = 0; i < dt2.Rows.Count; i++) { series2.Points.AddXY(" ", dt2.Rows[i]["VAL"]); } for (int i = 0; i < dt3.Rows.Count; i++) { series3.Points.AddXY(" ", dt3.Rows[i]["VAL"]); } //series1.ValueMemberX = "NAME"; //series1.ValueMembersY = "VAL"; //series2.ValueMemberX = "NAME"; //series2.ValueMembersY = "VAL"; //chart.DataSource = dt1; //chart.DataBind(); //series1.ToolTip = "#VALY{#,##0,00}"; //series2.ToolTip = "#VALY{#,##0}"; //for (int i = 0; i < dt.Rows.Count; i++) //{ // series1.Points[i].AxisLabel = xValues[i].ToString(); //} //series2.MarkerStyle = MarkerStyle.Circle; //series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); //series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); Font font = new Font("Gulim", 11, FontStyle.Regular); Font font1 = new Font("Gulim", 10, FontStyle.Regular); Dundas.Charting.WebControl.Title title = DundasCharts.CreateTitle(chart , "Title1" , titleName , font , Color.FromArgb(26, 59, 105) , Color.Empty , Color.Empty , ContentAlignment.TopCenter , null , Color.FromArgb(32, 0, 0, 0) , 3 , false , 5 , 7 , 91 , 6); Legend legend = DundasCharts.CreateLegend(chart , "Default" , Color.Transparent , Color.Empty , Color.Empty); //legend.AutoFitText = true; //legend.Position = new ElementPosition(60, 7, 50, 24); legend.AutoFitText = false; legend.Position = new ElementPosition(70, 2, 50, 25); legend.Font = new Font("굴림", 7, FontStyle.Regular); DundasCharts.SetChartArea(chart.ChartAreas["Default"], false); }
private void BindColumnChart(Chart chart , DataSet ds , string titleName , string name , string value) { DundasCharts.DundasChartBase(chart , ChartImageType.Flash , 240 , 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 series = null; for (int k = 0; k < ds.Tables.Count; k++) { DataTable dt = ds.Tables[k]; series = DundasCharts.CreateSeries(chart , "Series" + k.ToString() , "Default" , dt.TableName.Replace("사업부", "").Replace("법인", "") , dt.TableName.Replace("사업부", "").Replace("법인", "") , SeriesChartType.Column , 1 , GetChartColor(k) , Color.FromArgb(0x4A, 0x58, 0x7E) , Color.FromArgb(64, 0, 0, 0) , 1 , 9 , Color.FromArgb(64, 64, 64)); //series1.Label = "#VALY{N0}"; series.ToolTip = "#VALY{N0}"; chart.ChartAreas["Default"].AxisY.LabelStyle.Format = "N0"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series, 0.5, 1.5, true); //for (int i = 0; i < dt.Rows.Count; i++) //{ // series1.Points[i].AxisLabel = dt.Rows[i]["ALIAS"].ToString(); //} //for (int i = 0; i < dt.Rows.Count; i++) //{ // series1.Points.AddY(dt.Rows[i]["RESULT_TS"]); //} series.Font = new Font("굴림", 7, FontStyle.Regular); if (k == 0) { //series.Points.AddXY("매출액", dt.Rows[0]["MS_SALES"]); //series.Points.AddXY("영업이익", dt.Rows[0]["MS_PROFIT"]); series.Points.AddXY(name, dt.Rows[0][value]); } else { //series.Points.AddY(dt.Rows[0]["MS_SALES"]); //series.Points.AddY(dt.Rows[0]["MS_PROFIT"]); series.Points.AddY(dt.Rows[0][value]); } } //series1.ToolTip = "#VALY{#,##0,00}"; //series2.ToolTip = "#VALY{#,##0}"; //series2.MarkerStyle = MarkerStyle.Circle; //series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); //series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); Font font = new Font("Gulim", 11, FontStyle.Regular); Dundas.Charting.WebControl.Title title = DundasCharts.CreateTitle(chart , "Title1" , titleName , font , Color.FromArgb(26, 59, 105) , Color.Empty , Color.Empty , ContentAlignment.TopCenter , null , Color.FromArgb(32, 0, 0, 0) , 3 , false , 5 , 7 , 91 , 6); Legend legend = DundasCharts.CreateLegend(chart , "Default" , Color.Transparent , Color.Empty , Color.Empty); legend.AutoFitText = false; legend.Position = new ElementPosition(73, 7, 50, 40); legend.Font = new Font("굴림", 7, FontStyle.Regular); //legend.LegendStyle = LegendStyle.Table; //legend.AutoFitText = true; //legend.Docking = LegendDocking.Bottom; //legend.LegendStyle = LegendStyle.Table; //legend.AutoFitText = false; ////legend.Position = new ElementPosition(20, 100, 200, 40); //legend.Font = new Font("굴림", 7, FontStyle.Regular); //legend.Docking = LegendDocking.Bottom; DundasCharts.SetChartArea(chart.ChartAreas["Default"], false); }
private void BindChart(Chart chart , DataTable dt , string titleName) { DundasCharts.DundasChartBase(chart , ChartImageType.Flash , 480 , 150 , 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) , 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 , GetChartColor(1) , Color.FromArgb(0x4A, 0x58, 0x7E) , Color.FromArgb(64, 0, 0, 0) , 1 , 9 , Color.FromArgb(64, 64, 64)); //series1.Label = "#VALY{N0}"; series1.ToolTip = "#VALY{N0}"; series2.ToolTip = "#VALY{N0}"; //series1.ShowLabelAsValue = true; //series1.ShowInLegend = true; chart.ChartAreas["Default"].AxisY.LabelStyle.Format = "N0"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.5, 1.5, true); DundasAnimations.GrowingAnimation(chart, series2, 0.5, 1.5, true); //for (int i = 0; i < dt.Rows.Count; i++) //{ // series1.Points[i].AxisLabel = dt.Rows[i]["ALIAS"].ToString(); //} //for (int i = 0; i < dt.Rows.Count; i++) //{ // series1.Points.AddY(dt.Rows[i]["RESULT_TS"]); //} series1.Font = new Font("굴림", 7, FontStyle.Regular); series2.Font = new Font("굴림", 7, FontStyle.Regular); if (dt.Rows.Count > 0) { series1.Points.AddXY("당월", dt.Rows[0]["RESULT_MS"]); series1.Points.AddXY("누계", dt.Rows[0]["RESULT_TS"]); series1.Points.AddXY("전년동기실적", dt.Rows[0]["BF_RESULT_TS"]); series2.Points.AddY(dt.Rows[1]["RESULT_MS"]); series2.Points.AddY(dt.Rows[1]["RESULT_TS"]); series2.Points.AddY(dt.Rows[1]["BF_RESULT_TS"]); } //series1.ToolTip = "#VALY{#,##0,00}"; //series2.ToolTip = "#VALY{#,##0}"; //series2.MarkerStyle = MarkerStyle.Circle; //series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); //series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); Font font = new Font("Gulim", 11, FontStyle.Regular); Dundas.Charting.WebControl.Title title = DundasCharts.CreateTitle(chart , "Title1" , titleName , font , Color.FromArgb(26, 59, 105) , Color.Empty , Color.Empty , ContentAlignment.TopCenter , null , Color.FromArgb(32, 0, 0, 0) , 3 , false , 5 , 7 , 91 , 6); Legend legend = DundasCharts.CreateLegend(chart , "Default" , Color.Transparent , Color.Empty , Color.Empty); DundasCharts.SetChartArea(chart.ChartAreas["Default"], false); }
private void BindChart(Chart chart , DataTable dt , string titleName , System.Web.UI.WebControls.Label lbl1 , System.Web.UI.WebControls.Label lbl2 , System.Web.UI.WebControls.Label lbl3) { DundasCharts.DundasChartBase(chart , ChartImageType.Flash , 480 , 220 , 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 = null; for (int k = 0; k < dt.Rows.Count; k++) { if (DataTypeUtility.GetToInt32(dt.Rows[k]["KPI_REF_ID"]) < 0) { continue; } series1 = DundasCharts.CreateSeries(chart , "Series" + k.ToString() , "Default" , dt.Rows[k]["ALIAS"].ToString() , null , SeriesChartType.StackedColumn , 1 , GetChartColor(k) , Color.FromArgb(0x4A, 0x58, 0x7E) , Color.FromArgb(64, 0, 0, 0) , 1 , 9 , Color.FromArgb(64, 64, 64)); series1.Label = "#VALY{N0}"; series1.ToolTip = "#VALY{N0}"; //series1.ShowLabelAsValue = true; //series1.ShowInLegend = true; chart.ChartAreas["Default"].AxisY.LabelStyle.Format = "N0"; DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(chart, series1, 0.5, 1.5, true); series1.Font = new Font("굴림", 7, FontStyle.Regular); DataTable dtData = DataTypeUtility.FilterSortDataTable(dt, "KPI_REF_ID > 0"); if (k == 0) { series1.Points.AddXY("계획", dt.Rows[k]["TARGET_TS"]); series1.Points.AddXY("실적", dt.Rows[k]["RESULT_TS"]); } else { series1.Points.AddY(dt.Rows[k]["TARGET_TS"]); series1.Points.AddY(dt.Rows[k]["RESULT_TS"]); } //series1.ToolTip = "#VALY{#,##0,00}"; //series2.ToolTip = "#VALY{#,##0}"; } //series2.MarkerStyle = MarkerStyle.Circle; //series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20); //series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01); Font font = new Font("Gulim", 11, FontStyle.Regular); Dundas.Charting.WebControl.Title title = DundasCharts.CreateTitle(chart , "Title1" , titleName , font , Color.FromArgb(26, 59, 105) , Color.Empty , Color.Empty , ContentAlignment.TopCenter , null , Color.FromArgb(32, 0, 0, 0) , 3 , false , 5 , 7 , 91 , 6); Legend legend = DundasCharts.CreateLegend(chart , "Default" , Color.Transparent , Color.Empty , Color.Empty); legend.AutoFitText = false; legend.Position = new ElementPosition(80, 7, 50, 20); legend.Font = new Font("굴림", 7, FontStyle.Regular); DataRow[] drCol = dt.Select(string.Format("KPI_REF_ID < 0")); DundasCharts.SetChartArea(chart.ChartAreas["Default"], false); if (drCol.Length > 0) { lbl1.Text = DataTypeUtility.GetToDouble(drCol[0]["RNF_RATE"]).ToString("#,##0.00") + "%"; } else { lbl1.Text = "0" + "%"; } drCol = dt.Select(string.Format("KPI_REF_ID < 0")); DundasCharts.SetChartArea(chart.ChartAreas["Default"], false); if (drCol.Length > 0) { lbl2.Text = DataTypeUtility.GetToDouble(drCol[0]["TARGET_TS"]).ToString("#,##0") + ""; lbl3.Text = DataTypeUtility.GetToDouble(drCol[0]["RESULT_TS"]).ToString("#,##0") + ""; } else { lbl2.Text = "0" + ""; lbl3.Text = "0" + ""; } }
protected void Page_Load(object sender, EventArgs e) { type = (Request["type"] != null && !Request["type"].Equals("")) ? int.Parse(Request["type"].ToString()) : 2; string query = "SELECT splyy as tmcode , sum(splddqty) as target , sum(sumddqty) as result FROM uz5plan WHERE saupjang=21 group by splyy"; DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 400, 250, BorderSkinStyle.None, Color.FromArgb(181, 64, 1), 5 , Color.FromArgb(0xE0, 0xF0, 0xFF), Color.FromArgb(0xF0, 0xC0, 0xFF), Color.FromArgb(210, 210, 210), ChartDashStyle.Solid, 2 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 400, 250, BorderSkinStyle.None, Color.FromArgb(181, 64, 1), 5 , Color.FromArgb(0xE0, 0xF0, 0xFF), Color.FromArgb(0xF0, 0xC0, 0xFF), Color.FromArgb(210, 210, 210), ChartDashStyle.Solid, 2 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); string ctTitle = "Line Chart"; SeriesChartType DataCT; switch (type) { case 1: DataCT = SeriesChartType.Bar; ctTitle = "Bar Chart"; break; case 2: DataCT = SeriesChartType.Line; ctTitle = "Line Chart"; break; case 3: DataCT = SeriesChartType.CandleStick; ctTitle = "CandleStick Chart"; break; case 4: DataCT = SeriesChartType.StackedBar; ctTitle = "StackedBar Chart"; break; case 5: DataCT = SeriesChartType.Spline; ctTitle = "Spline Chart"; break; case 6: DataCT = SeriesChartType.SplineArea; ctTitle = "SplineArea Chart"; break; case 7: DataCT = SeriesChartType.Range; ctTitle = "Range Chart"; break; case 8: DataCT = SeriesChartType.RangeColumn; ctTitle = "RangeColumn Chart"; break; case 9: DataCT = SeriesChartType.Point; ctTitle = "Point Chart"; break; case 10: DataCT = SeriesChartType.Gantt; ctTitle = "Gantt Chart"; break; case 11: DataCT = SeriesChartType.StepLine; ctTitle = "StepLine Chart"; break; default: DataCT = SeriesChartType.Radar; ctTitle = "Radar Chart"; break; } Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "계획", null, DataCT, 2, Color.FromArgb(220, 65, 140, 240), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(Chart1, "Series2", "Default", "실적", null, DataCT, 2, Color.FromArgb(220, 252, 180, 65), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(Chart2, "Series1", "Default", "계획", null, DataCT, 2, Color.FromArgb(220, 65, 140, 240), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series4 = DundasCharts.CreateSeries(Chart2, "Series2", "Default", "실적", null, DataCT, 2, Color.FromArgb(220, 252, 180, 65), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); ArrayList yValues1; ArrayList yValues2; ArrayList xValues; DundasCharts.SetDataFieldsX1(query, "tmcode", out xValues, "target", out yValues1, "result", out yValues2); series1.Points.DataBindXY(xValues, yValues1); series2.Points.DataBindXY(xValues, yValues2); //DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, true, 1); //DundasAnimations.GrowingAnimation(Chart1, series1, 0.0, 3.0, false); //DundasAnimations.GrowingAnimation(Chart1, series2, 3.0, 4.0, true); DataPoint point = series1.Points.FindMaxValue(); point.Color = Color.Fuchsia; for (int i = 0; i < series2.Points.Count; i++) { //series2.Points[i].ShowLabelAsValue = true; if (yValues2[i].ToString() == "0") { series2.Points[i].Color = Color.Transparent; } } DundasAnimations.FadingAnimation(Chart1, point, Color.BlueViolet, Color.FromArgb(64, 64, 64), Color.Empty, Color.Empty, Color.Empty, 7.0, 1.0, true, true, -1); DundasAnimations.FadingAnimation(Chart2, point, Color.BlueViolet, Color.FromArgb(64, 64, 64), Color.Empty, Color.Empty, Color.Empty, 7.0, 1.0, true, true, -1); // Set radar chart style Line, Area, Marker series1["RadarDrawingStyle"] = "Line"; series2["RadarDrawingStyle"] = "Line"; // Set circular area drawing style //Circle, Polygon series1["AreaDrawingStyle"] = "Polygon"; series2["AreaDrawingStyle"] = "Polygon"; // Set labels style //Horizontal, Circular, Radial series1["CircularLabelsStyle"] = "Horizontal"; series2["CircularLabelsStyle"] = "Horizontal"; Font font = new Font("Tahoma", 14, FontStyle.Regular); Font font1 = new Font("Gulim", 9, FontStyle.Regular); /* * Dundas.Charting.WebControl.Title title = DundasCharts.CreateTitle(Chart1, "Title1", ctTitle, font, Color.FromArgb(26, 59, 105), Color.Empty, Color.Empty * , ContentAlignment.TopCenter, null, Color.FromArgb(32, 0, 0, 0), 3, false, 5, 5, 91, 6); * * Dundas.Charting.WebControl.Title title2 = DundasCharts.CreateTitle(Chart2, "Title1", ctTitle, font, Color.FromArgb(26, 59, 105), Color.Empty, Color.Empty * , ContentAlignment.TopCenter, null, Color.FromArgb(32, 0, 0, 0), 3, false, 5, 5, 91, 6); */ //Legend legend = DundasCharts.CreateLegend(Chart1, "Default", Color.Transparent, Color.Empty, Color.Empty, font1, true, 75, 75, 20, 15); DundasCharts.SetChartArea(Chart1.ChartAreas["Default"], true); DundasCharts.SetChartArea(Chart2.ChartAreas["Default"], true); query = " SELECT a.saupjang, a.splyy, a.splmm, a.spldd, a.splddqty, a.splmmqty,"; query += " a.splyyqty, a.sumddqty, a.summmqty, a.sumyyqty, a.modempno, a.modymdt"; query += " FROM uz5plan a"; query += " where a.splyy = 2006 order by saupjang, splyy, splmm"; DataSet ds = new DataSet(); OracleConnection _connection = new OracleConnection(); _connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MainDB_Oracle"].ConnectionString; OracleDataAdapter ad = new OracleDataAdapter(query, _connection); ad.Fill(ds); UltraWebGrid1.DataSource = ds; UltraWebGrid1.DataBind(); }