//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 ChartBinding() { DataTable dtBond = GetDTBond(false); DataTable dtChart = GetDTChart(); //Chart1.DataSource = GetDTChart(); #region 챠트 초기화 DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 240 , 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[] srArray = new Series[dtBond.Rows.Count]; for (int i = 0; i < dtBond.Rows.Count; i++) { srArray[i] = DundasCharts.CreateSeries(Chart1, "", "Default", dtBond.Rows[i]["v_Name"].ToString(), null, SeriesChartType.StackedColumn, 3, GetChartColor(i), GetChartColor(i), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); //srArray[i].ValueMembersY = dtBond.Rows[i]["v_Code"].ToString(); DatabaseBindingXY(srArray[i], "YYYYMM", dtBond.Rows[i]["v_Code"].ToString(), dtChart); DundasAnimations.GrowingAnimation(Chart1, srArray[i], i, i + 1, true); srArray[i].MarkerStyle = GetMarkerStyle(i); srArray[i].ToolTip = "#VALY{N0}"; //srArray[i].ShowLabelAsValue = true; //SetZeroPoint(Chart1, int.Parse(PageUtility.GetByValueDropDownList(ddlYear))); } SetVisibleZeroPoint(Chart1, Convert.ToInt32(PageUtility.GetByValueDropDownList(ddlYear))); //srArray[0].ValueMemberX = "YYYYMM"; string sChartArea = Chart1.Series[srArray[0].Name].ChartArea; Chart1.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0"; 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); }
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 dtItem , DataTable dtStock , DataTable dtData , string titleName) { DundasCharts.DundasChartBase(chart , ChartImageType.Flash , 480 , 310 , 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 < dtStock.Rows.Count; k++) { DataRow drS = dtStock.Rows[k]; series1 = DundasCharts.CreateSeries(chart , "Series" + k.ToString() , "Default" , drS["S_NAME"].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); //for(int i = 0; i < dt.Rows.Count; i++) //{ // series1.Points.AddXY(dt.Rows[i]["ALIAS"].ToString(), dt.Rows[i]["TARGET_TS"]); //} //for(int i = 0; i < dt.Rows.Count; i++) //{ // series2.Points.AddY(dt.Rows[i]["RESULT_TS"]); //} DataTable dtData_1 = DataTypeUtility.FilterSortDataTable(dtData, string.Format("KPI_REF_ID > 0 AND STOCK_CODE = '{0}'", drS["S_ID"])); foreach (DataRow dr in dtData_1.Rows) { if (k == 0) { series1.Points.AddXY(dr["I_NAME"].ToString(), dr["RESULT_TS"]); } else { series1.Points.AddY(dr["RESULT_TS"]); } } //else //{ // series1.Points.AddY(dtData.Rows[k]["RESULT_TS"]); // //series1.Points.AddY(dtData.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); }
private void BindChart(Chart chart , DataTable dt , string titleName) { DundasCharts.DundasChartBase(chart , ChartImageType.Flash , 480 , 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.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); series1.Font = new Font("굴림", 7, FontStyle.Regular); series2.Font = new Font("굴림", 7, FontStyle.Regular); for (int i = 0; i < dt.Rows.Count; i++) { series1.Points.AddXY(" ", dt.Rows[i]["TARGET_MS"]); } for (int i = 0; i < dt.Rows.Count; i++) { series2.Points.AddY(dt.Rows[i]["RESULT_MS"]); } //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", 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); //DataRow[] drCol = dt.Select(string.Format("KPI_REF_ID < 0")); //DundasCharts.SetChartArea(chart.ChartAreas["Default"], false); //if(drCol.Length > 0) //{ // lbl.Text = DataTypeUtility.GetToDouble(drCol[0]["RNF_RATE"]).ToString("#,##0.00") + "%"; //} //else //{ // lbl.Text = "0" + "%"; //} }
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 BindingPieChart(string yearStr) { DataRow drNew = null; DataTable dataTable = new DataTable(); DataTable dtTable = GetDTChart("전체"); DataRow[] draDefault = null; DataTable dtItems = GetDTItems(""); draDefault = dtTable.Select( "YMD='" + GetLastDay() + "'" ); if (draDefault.Length == 0) { dataTable.Columns.Add("Gubun", typeof(string)); dataTable.Columns.Add("카프로락탐", typeof(double)); dataTable.Columns.Add("박편락탐", typeof(double)); dataTable.Columns.Add("유안벌크", typeof(double)); dataTable.Columns.Add("싸이크로헥산", typeof(double)); dataTable.Columns.Add("아논", typeof(double)); drNew = dataTable.NewRow(); drNew["Gubun"] = ddlGong.SelectedItem.Text; drNew["카프로락탐"] = 0; drNew["박편락탐"] = 0; drNew["유안벌크"] = 0; drNew["싸이크로헥산"] = 0; drNew["아논"] = 0; dataTable.Rows.Add(drNew); Chart5.DataSource = dataTable; DundasCharts.DundasChartBase(Chart5, ChartImageType.Flash, 800, 235 , 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 srSeries1 = DundasCharts.CreateSeries(Chart5, "", "Default", "카프로락탐", null, SeriesChartType.Column, 1, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries1.ValueMembersY = "카프로락탐"; DundasAnimations.GrowingAnimation(Chart5, srSeries1, 0, 0 + 1, true); srSeries1.ShowLabelAsValue = true; srSeries1.ToolTip = "#VALY{N0}"; srSeries1.LabelFormat = "N0"; Series srSeries2 = DundasCharts.CreateSeries(Chart5, "", "Default", "박편락탐", null, SeriesChartType.Column, 1, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries2.ValueMembersY = "박편락탐"; DundasAnimations.GrowingAnimation(Chart5, srSeries2, 1, 1 + 1, true); srSeries2.ShowLabelAsValue = true; srSeries2.ToolTip = "#VALY{N0}"; srSeries2.LabelFormat = "N0"; Series srSeries3 = DundasCharts.CreateSeries(Chart5, "", "Default", "유안벌크", null, SeriesChartType.Column, 1, GetChartColor(2), GetChartColor(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries3.ValueMembersY = "유안벌크"; DundasAnimations.GrowingAnimation(Chart5, srSeries3, 2, 2 + 1, true); srSeries3.ShowLabelAsValue = true; srSeries3.ToolTip = "#VALY{N0}"; srSeries3.LabelFormat = "N0"; Series srSeries4 = DundasCharts.CreateSeries(Chart5, "", "Default", "싸이크로헥산", null, SeriesChartType.Column, 1, GetChartColor(3), GetChartColor(3), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries4.ValueMembersY = "싸이크로헥산"; DundasAnimations.GrowingAnimation(Chart5, srSeries4, 3, 3 + 1, true); srSeries4.ShowLabelAsValue = true; srSeries4.ToolTip = "#VALY{N0}"; srSeries4.LabelFormat = "N0"; Series srSeries5 = DundasCharts.CreateSeries(Chart5, "", "Default", "아논", null, SeriesChartType.Column, 1, GetChartColor(4), GetChartColor(4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries5.ValueMembersY = "아논"; DundasAnimations.GrowingAnimation(Chart5, srSeries5, 4, 4 + 1, true); srSeries5.ShowLabelAsValue = true; srSeries5.ToolTip = "#VALY{N0}"; srSeries5.LabelFormat = "N0"; srSeries3.ValueMemberX = "Gubun"; srSeries3.YAxisType = AxisType.Secondary; Chart5.Legends[0].Position.Auto = true; string sChartArea = Chart5.Series[srSeries1.Name].ChartArea; Chart5.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0"; Chart5.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "N0"; Font font1 = new Font("Gulim", 9, FontStyle.Regular); Legend legend = DundasCharts.CreateLegend(Chart5, "Default", Color.Transparent, Color.Empty, Color.Empty, font1, true, -1, -1, -1, -1); SetVisibleZeroPoint(Chart5, Convert.ToInt32(PageUtility.GetByValueDropDownList(ddlYear))); return; } if (dtTable.Columns.Count != 2) { dataTable.Columns.Add("Gubun", typeof(string)); for (int i = 1; i < dtTable.Columns.Count; i++) { dataTable.Columns.Add(dtTable.Columns[i].ColumnName, typeof(double)); } drNew = dataTable.NewRow(); drNew["Gubun"] = ddlGong.SelectedItem.Text; for (int i = 1; i < dtTable.Columns.Count; i++) { drNew[i] = Math.Round(Convert.ToDouble(draDefault[0][i]), 0); } dataTable.Rows.Add(drNew); Chart5.DataSource = dataTable; DundasCharts.DundasChartBase(Chart5, ChartImageType.Flash, 800, 235 , 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 srSeries1 = DundasCharts.CreateSeries(Chart5, "", "Default", "카프로락탐", null, SeriesChartType.Column, 1, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries1.ValueMembersY = "카프로락탐"; DundasAnimations.GrowingAnimation(Chart5, srSeries1, 0, 0 + 1, true); srSeries1.ShowLabelAsValue = true; srSeries1.ToolTip = "#VALY{N0}"; srSeries1.LabelFormat = "N0"; Series srSeries2 = DundasCharts.CreateSeries(Chart5, "", "Default", "박편락탐", null, SeriesChartType.Column, 1, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries2.ValueMembersY = "박편락탐"; DundasAnimations.GrowingAnimation(Chart5, srSeries2, 1, 1 + 1, true); srSeries2.ShowLabelAsValue = true; srSeries2.ToolTip = "#VALY{N0}"; srSeries2.LabelFormat = "N0"; Series srSeries3 = DundasCharts.CreateSeries(Chart5, "", "Default", "유안벌크", null, SeriesChartType.Column, 1, GetChartColor(2), GetChartColor(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries3.ValueMembersY = "유안벌크"; DundasAnimations.GrowingAnimation(Chart5, srSeries3, 2, 2 + 1, true); srSeries3.ShowLabelAsValue = true; srSeries3.ToolTip = "#VALY{N0}"; srSeries3.LabelFormat = "N0"; Series srSeries4 = DundasCharts.CreateSeries(Chart5, "", "Default", "싸이크로헥산", null, SeriesChartType.Column, 1, GetChartColor(3), GetChartColor(3), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries4.ValueMembersY = "싸이크로헥산"; DundasAnimations.GrowingAnimation(Chart5, srSeries4, 3, 3 + 1, true); srSeries4.ShowLabelAsValue = true; srSeries4.ToolTip = "#VALY{N0}"; srSeries4.LabelFormat = "N0"; Series srSeries5 = DundasCharts.CreateSeries(Chart5, "", "Default", "아논", null, SeriesChartType.Column, 1, GetChartColor(4), GetChartColor(4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries5.ValueMembersY = "아논"; DundasAnimations.GrowingAnimation(Chart5, srSeries5, 4, 4 + 1, true); srSeries5.ShowLabelAsValue = true; srSeries5.ToolTip = "#VALY{N0}"; srSeries5.LabelFormat = "N0"; srSeries3.ValueMemberX = "Gubun"; srSeries3.YAxisType = AxisType.Secondary; Chart5.Legends[0].Position.Auto = true; string sChartArea = Chart5.Series[srSeries1.Name].ChartArea; Chart5.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0"; Chart5.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "N0"; Font font1 = new Font("Gulim", 9, FontStyle.Regular); Legend legend = DundasCharts.CreateLegend(Chart5, "Default", Color.Transparent, Color.Empty, Color.Empty, font1, true, -1, -1, -1, -1); } else { dataTable.Columns.Add("Gubun", typeof(string)); for (int i = 1; i < dtTable.Columns.Count; i++) { dataTable.Columns.Add(dtTable.Columns[i].ColumnName, typeof(double)); } drNew = dataTable.NewRow(); drNew["Gubun"] = ddlGong.SelectedItem.Text; for (int i = 1; i < dtTable.Columns.Count; i++) { drNew[i] = Math.Round(Convert.ToDouble(draDefault[0][i]), 0); } dataTable.Rows.Add(drNew); Chart5.DataSource = dataTable; DundasCharts.DundasChartBase(Chart5, ChartImageType.Flash, 800, 235 , 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 srSeries5 = DundasCharts.CreateSeries(Chart5, "", "Default", dtTable.Columns[1].ColumnName, null, SeriesChartType.Column, 1, GetChartColor(GetChartInfo(dtTable.Columns[1].ColumnName)), GetChartColor(GetChartInfo(dtTable.Columns[1].ColumnName)), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); srSeries5.ValueMembersY = dtTable.Columns[1].ColumnName; DundasAnimations.GrowingAnimation(Chart5, srSeries5, 2, 2 + 1, true); srSeries5.ShowLabelAsValue = true; srSeries5.ToolTip = "#VALY{N0}"; srSeries5.LabelFormat = "N0"; srSeries5.ValueMemberX = "Gubun"; if (dtTable.Columns[1].ColumnName == "유안벌크") { srSeries5.YAxisType = AxisType.Secondary; } Chart5.Legends[0].Position.Auto = true; string sChartArea = Chart5.Series[srSeries5.Name].ChartArea; Chart5.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0"; Chart5.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "N0"; Font font1 = new Font("Gulim", 9, FontStyle.Regular); Legend legend = DundasCharts.CreateLegend(Chart5, "Default", Color.Transparent, Color.Empty, Color.Empty, font1, true, -1, -1, -1, -1); } SetVisibleZeroPoint(Chart5, Convert.ToInt32(PageUtility.GetByValueDropDownList(ddlYear))); }
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" + ""; } }