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 BindingChart(Dundas.Charting.WebControl.Chart chart, DataTable dtData)
{
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);
DataTable dt = this.CODE_TABLE;
int iRow = dt.Rows.Count;
for (int i = 0; i < iRow; i++)
{
Series ser = DundasCharts.CreateSeries(chart, "ser" + i.ToString(), "Default", dt.Rows[i][1].ToString(), null, SeriesChartType.Line, 3
, GetChartColor(i), GetChartColor(i), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)
);
ser.MarkerStyle = GetMarkerStyle(i);
ser.MarkerColor = GetMarkerColor(i);
ser.MarkerBorderColor = GetMarkerBorderColor(i);
ser.ValueMembersY = dt.Rows[i][0].ToString();
if (i == 0)
{
ser.ValueMemberX = "YY";
}
}
chart.DataSource = dtData;
chart.DataBind();
}
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 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 _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 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 setGrph(DataTable idtSet)
{
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));
Series series2 = DundasCharts.CreateSeries(Chart2, "Series2", "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));
series1.FontColor = Color.White;
Chart1.DataSource = idtSet.DefaultView;
Chart1.Series[series1.Name].ValueMemberX = "COL_RNAME";
Chart1.Series[series1.Name].ValueMembersY = "COL_RATE";
Chart1.DataBind();
Chart2.DataSource = idtSet.DefaultView;
Chart2.Series[series2.Name].ValueMemberX = "COL_CNAME";
Chart2.Series[series2.Name].ValueMembersY = "COL_COUNT";
Chart2.DataBind();
}
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 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 ChartBinding()
{
string sItem = PageUtility.GetByValueDropDownList(ddlItem);
DataTable dtItems = GetDTItems(sItem); // 선택된 아이템
Chart1.DataSource = GetDTChart();
#region 챠트 초기화
DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 400
, 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[dtItems.Rows.Count];
for (int i = 0; i < dtItems.Rows.Count; i++)
{
srArray[i] = DundasCharts.CreateSeries(Chart1, "", "Default", dtItems.Rows[i]["ITMJ_NAME"].ToString(), null, SeriesChartType.Line, 3, GetChartColor(i), GetChartColor(i), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
srArray[i].ValueMembersY = dtItems.Rows[i]["ITMJ_CD"] + "_QTY";
DundasAnimations.GrowingAnimation(Chart1, srArray[i], i, i + 1, true);
srArray[i].MarkerStyle = GetMarkerStyle(i);
srArray[i].ToolTip = "#VALY{N0}";
}
srArray[0].ValueMemberX = "YMD";
string sChartArea = Chart1.Series[srArray[0].Name].ChartArea;
Chart1.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0";
}
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 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 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 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 _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 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 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 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 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 ChartBinding2()
{
Chart2.DataSource = GetDTChart2();
#region 챠트 초기화
DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 800, 430
, 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 srPlan = DundasCharts.CreateSeries(Chart2, "", "Default", "계획량", null, SeriesChartType.Column, 1, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
srPlan.ValueMembersY = "Plan";
DundasAnimations.GrowingAnimation(Chart2, srPlan, 0, 0 + 1, true);
Series srProd = DundasCharts.CreateSeries(Chart2, "", "Default", "생산량", null, SeriesChartType.Column, 1, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
srProd.ValueMembersY = "Prod";
DundasAnimations.GrowingAnimation(Chart2, srProd, 1, 1 + 1, true);
Series srPrevYear = DundasCharts.CreateSeries(Chart2, "", "Default", "전년동기차액", null, SeriesChartType.Column, 1, GetChartColor(2), GetChartColor(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
srPrevYear.ValueMembersY = "PrevYear";
DundasAnimations.GrowingAnimation(Chart2, srPrevYear, 2, 2 + 1, true);
Series srSum = DundasCharts.CreateSeries(Chart2, "", "Default", "계획/생산차이 누계", null, SeriesChartType.Column, 1, GetChartColor(4), GetChartColor(4), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
srSum.ValueMembersY = "Sum";
DundasAnimations.GrowingAnimation(Chart2, srSum, 4, 4 + 1, true);
Series srBuha = DundasCharts.CreateSeries(Chart2, "", "Default", "부하율", null, SeriesChartType.Line, 3, GetChartColor(3), GetChartColor(3), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
srBuha.ValueMembersY = "Rate";
DundasAnimations.GrowingAnimation(Chart2, srBuha, 3, 3 + 1, true);
srBuha.MarkerStyle = GetMarkerStyle(3);
srPlan.ShowLabelAsValue = true;
srProd.ShowLabelAsValue = true;
srPrevYear.ShowLabelAsValue = true;
srSum.ShowLabelAsValue = true;
srPlan.ValueMemberX = "GongJang";
string sChartArea = Chart2.Series[srPlan.Name].ChartArea;
Chart2.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0";
srBuha.YAxisType = AxisType.Secondary;
sChartArea = Chart2.Series[srBuha.Name].ChartArea;
Chart2.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "P0";
}
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 ChartBinding()
{
string sGongName = PageUtility.GetByTextDropDownList(ddlGong);
Chart1.DataSource = GetDTChart();
#region 챠트 초기화
DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 800, 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);
#endregion
//series1.ToolTip = "#VALY{N}";
//series2.ToolTip = "#VALY{N}";
// 시리즈 생성
Series srProd = DundasCharts.CreateSeries(Chart1, "", "Default", "생산량", null, SeriesChartType.Line, 3, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
srProd.ValueMembersY = "ProdQty";
DundasAnimations.GrowingAnimation(Chart1, srProd, 0, 0 + 1, true);
srProd.MarkerStyle = GetMarkerStyle(0);
srProd.ToolTip = "#VALY{N0}";
Series srRate = DundasCharts.CreateSeries(Chart1, "", "Default", "계획대비일간실적", null, SeriesChartType.Line, 3, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
srRate.ValueMembersY = "Rate";
DundasAnimations.GrowingAnimation(Chart1, srRate, 1, 1 + 1, true);
srRate.MarkerStyle = GetMarkerStyle(1);
srRate.ToolTip = "#VALY{P0}";
Series srBuha = DundasCharts.CreateSeries(Chart1, "", "Default", "부하율", null, SeriesChartType.Line, 3, GetChartColor(2), GetChartColor(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
srBuha.ValueMembersY = "Buha";
DundasAnimations.GrowingAnimation(Chart1, srBuha, 2, 2 + 1, true);
srBuha.MarkerStyle = GetMarkerStyle(2);
srBuha.ToolTip = "#VALY{P0}";
srProd.ValueMemberX = "YMD";
string sChartArea = Chart1.Series[srProd.Name].ChartArea;
Chart1.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0";
sChartArea = Chart1.Series[srRate.Name].ChartArea;
srRate.YAxisType = AxisType.Secondary;
srBuha.YAxisType = AxisType.Secondary;
Chart1.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "P0";
}
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 _setGraphFual(DataSet iDsSet)
{
DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 300, 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);
Series series1 = DundasCharts.CreateSeries(Chart2, "Series1", "Default", "", null, SeriesChartType.Funnel, 0, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Chart2.Series["Series1"].Type = SeriesChartType.Funnel;
// Set funnel Y values style
Chart2.Series["Series1"]["FunnelStyle"] = "YIsHeight";
// Set funnel data point labels style
Chart2.Series["Series1"]["FunnelLabelStyle"] = "Outside";
// Place labels on the left side
Chart2.Series["Series1"]["FunnelOutsideLabelPlacement"] = "Left";
// Set gap between points
Chart2.Series["Series1"]["FunnelPointGap"] = "2";
// Set minimum point height
Chart2.Series["Series1"]["FunnelMinPointHeight"] = "1";
// Set 3D mode
Chart2.ChartAreas["Default"].Area3DStyle.Enable3D = true;
// Set 3D angle
Chart2.Series["Series1"]["Funnel3DRotationAngle"] = "7";
// Set 3D drawing style
Chart2.Series["Series1"]["Funnel3DDrawingStyle"] = "CircularBase";
Chart2.DataSource = iDsSet;
Chart2.Series[series1.Name].ValueMembersY = "PRICE";
Chart2.Series[series1.Name].ValueMemberX = "CODE";
Chart2.DataBind();
}
