private void SetGauge()
{
//================================================================== 전체
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsTot = objBSC.GetEstDeptTotalScore(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID);
double dblMax = 0.00;
if (dsTot.Tables[0].Rows.Count > 0)
{
dblMax = Math.Round(double.Parse(dsTot.Tables[0].Rows[0][3].ToString()), 0);
this.gauTotal2.NumericIndicators["Default"].Value = (dsTot.Tables[0].Rows.Count > 0) ? double.Parse(dsTot.Tables[0].Rows[0]["POINT"].ToString()) : 0;
this.gauTotal2.NumericIndicators["Default"].Href = "./BSC0404S1.ASPX";
this.gauTotal2.NumericIndicators["Default"].BorderWidth = 0;
this.gauTotal2.Labels["Default"].Href = "./BSC0404S1.ASPX";
lblToatal.Text = Convert.ToString(Math.Round(this.gauTotal2.NumericIndicators["Default"].Value, 2));
this.SetStateIndicator(this.gauTotal2.StateIndicators);
foreach (Dundas.Gauges.WebControl.StateIndicator stateIndicator in this.gauTotal2.StateIndicators)
{
stateIndicator.Value = (dsTot.Tables[0].Rows.Count > 0) ? double.Parse(dsTot.Tables[0].Rows[0]["POINT"].ToString()) : 0;
stateIndicator.Location.Y = 0;
stateIndicator.Location.X = 30;
stateIndicator.Size.Height = 9;
stateIndicator.Size.Width = 7;
}
}
//================================================================== 관점별 달성율
DataSet dsViw = objBSC.GetEstDeptKpiViewTypeList(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID);
Dundas.Gauges.WebControl.GaugeContainer objGauge = null;
if (dsViw.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsViw.Tables[0].Rows.Count; i++)
{
switch (i)
{
case 0:
objGauge = gauKPI1;
break;
case 1:
objGauge = gauKPI2;
break;
case 2:
objGauge = gauKPI3;
break;
case 3:
objGauge = gauKPI4;
break;
default:
return;
}
dblMax = Math.Round(double.Parse(dsViw.Tables[0].Rows[i]["ACHV_RATE"].ToString()), 0);
objGauge.CircularGauges["Default"].Scales[0].Minimum = 0;
objGauge.CircularGauges["Default"].Scales[0].Maximum = (dblMax >= 100) ? dblMax : 100;
objGauge.CircularGauges["Default"].Scales[0].StartAngle = 89;
objGauge.CircularGauges["Default"].Scales[0].SweepAngle = 95;
//objGauge.CircularGauges["Default"].Scales[0].Width = 10;
//objGauge.CircularGauges["Default"].Scales[0].ShadowOffset = 0;
objGauge.CircularGauges["Default"].Scales[0].Radius = 57;
//objGauge.CircularGauges["Default"].Scales[0].FillColor = System.Drawing.Color.White;
// Flash based streaming
objGauge.ImageType = Dundas.Gauges.WebControl.ImageType.Png;
objGauge.RenderAsControl = Dundas.Gauges.WebControl.AutoBool.False;
objGauge.CircularGauges["Default"].Pointers["Default"].Value = (dsViw.Tables[0].Rows.Count > 0) ? double.Parse(dsViw.Tables[0].Rows[i]["ACHV_RATE"].ToString()) : 0;
objGauge.Labels[0].Text = dsViw.Tables[0].Rows[i]["VIEW_NAME"].ToString();
//objGauge.Labels[0].Href = "./BSC0404S1.ASPX";
objGauge.Labels[0].BorderWidth = 0;
this.SetStateIndicator(objGauge.StateIndicators);
foreach (Dundas.Gauges.WebControl.StateIndicator stateIndicator in this.gauTotal2.StateIndicators)
{
stateIndicator.Value = (dsViw.Tables[0].Rows.Count > 0) ? double.Parse(dsViw.Tables[0].Rows[i]["ACHV_RATE"].ToString()) : 0;
}
}
}
}
private void SetKpiStatusGraph2()
{
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsGraph = new DataSet();
List <string> listYMDs = new List <string>();
Chart objChart = this.chtPart;
//dsGraph = TempData3();
//관점별 1년치데이타
foreach (string str in GetBeforeMonth(listYMDs))
{
dsGraph.Merge(objBSC.GetEstDeptKpiViewTypeList(this.IEstTermRefID
, str
, this.ISumType
, this.IEstDeptID));
}
dsGraph.AcceptChanges();
dsGraph = this.ModifyData(dsGraph);
foreach (DataRow dr in dsGraph.Tables[0].Rows)
{
dr["YMD"] = string.Format("{0}년{1}월", dr["YMD"].ToString().Substring(0, 4), DataTypeUtility.GetToInt32(dr["YMD"].ToString().Substring(4, 2)));
}
if (dsGraph.Tables[0].Rows.Count > 0)
{
DundasCharts.DundasChartBase(objChart
, ChartImageType.Png
, 680
, 130
, 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);
objChart.DataSource = dsGraph;
objChart.Series.Clear();
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objViewInfo = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
DataSet rDs = objViewInfo.GetAllList();
if (rDs.Tables != null && rDs.Tables[0].Rows.Count == 4)
{
Series series4 = DundasCharts.CreateSeries(objChart, "sp1", "Default", rDs.Tables[0].Rows[0]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 224, 64, 10), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64));
Series series1 = DundasCharts.CreateSeries(objChart, "sp2", "Default", rDs.Tables[0].Rows[1]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 192, 192, 192), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64));
Series series3 = DundasCharts.CreateSeries(objChart, "sp3", "Default", rDs.Tables[0].Rows[2]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 65, 140, 240), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64));
Series series2 = DundasCharts.CreateSeries(objChart, "sp4", "Default", rDs.Tables[0].Rows[3]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 252, 180, 65), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64));
series1.ValueMembersY = "ACHV_RATE1";
series2.ValueMembersY = "ACHV_RATE2";
series3.ValueMembersY = "ACHV_RATE3";
series4.ValueMembersY = "ACHV_RATE4";
series1.ValueMemberX = "YMD";
foreach (Series series in objChart.Series)
{
objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisX.Margin = false;
objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY2.Enabled = AxisEnabled.False;
objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY.Interval = 30;
series.Href = HttpContext.Current.Request.Url.ToString().Substring(0
, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + "/BSC0404S1.ASPX";
}
objChart.DataBind();
}
}
}
private void SetGraph()
{
int charWidth = 300;
int charHeight = 170;
int cntRow = 0;
int cntCol = 0;
int intLP = 0;
string strSerNm = "";
//================================================================== 관점별 달성율
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsViw = objBSC.GetEstDeptKpiViewTypeList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID);
if (dsViw.Tables[0].Rows.Count > 0)
{
Chart chartMS = chartView;
MSCharts.DundasChartBase(chartMS, ChartImageType.Jpeg, charWidth, charHeight
, BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 1
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
, -1
, ChartHatchStyle.None, MsGradientType.TopBottom, MsAntiAliasing.None);
Series serARate = MSCharts.CreateSeries(chartMS, "serA", "AreaView", "달성율", null, SeriesChartType.Bar, 0, GetChartColor(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
chartMS.Legends[0].Enabled = false;
serARate.ToolTip = "#VALY{P}";
chartMS.ChartAreas["AreaView"].Area3DStyle.Enable3D = false;
chartMS.DataSource = dsViw;
serARate.YValueMembers = "ACHV_RATE";
serARate.XValueMember = "VIEW_NAME";
chartMS.DataBind();
}
//================================================================== 등급구간별별 점수현황
DataSet dsGrd = objBSC.GetKpiGradeStatusForMap
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID);
if (dsGrd.Tables[0].Rows.Count > 0)
{
Chart chartGD = chartGrade;
MSCharts.DundasChartBase(chartGD, ChartImageType.Jpeg, charWidth, charHeight
, BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 1
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
, -1
, ChartHatchStyle.None, MsGradientType.TopBottom, MsAntiAliasing.None);
Series serCRate = MSCharts.CreateSeries(chartGD, "serA", "AreaGrade", "달성율", null, SeriesChartType.Pie, 0, GetChartColor(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
chartGD.Legends[0].Enabled = false;
serCRate.ToolTip = "#VALY{P}";
chartGD.ChartAreas["AreaGrade"].Area3DStyle.Enable3D = true;
serCRate["PieLabelStyle"] = "Outside";
chartGD.DataSource = dsGrd;
serCRate.YValueMembers = "C_RATE";
serCRate.XValueMember = "THRESHOLD_KNAME";
chartGD.DataBind();
}
//================================================================== 지표군별 점수현황
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard objBOR = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard();
DataSet dsGroup = objBOR.GetDashBoardForKpiGroupScore(this.IEstTermRefID, this.IYmd, this.ISumType);
if (dsGroup.Tables[0].Rows.Count > 0)
{
MSCharts.DundasChartBase(chartGroup, ChartImageType.Jpeg, charWidth, charHeight
, BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 1
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
, -1
, ChartHatchStyle.None, MsGradientType.TopBottom, MsAntiAliasing.Graphics);
Series serGroup = MSCharts.CreateSeries(chartGroup, "serA", "AreaGroup", "점수", null, SeriesChartType.Bar, 0, GetChartColor(1), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
chartGroup.Legends[0].Enabled = false;
serGroup.ToolTip = "#VALY{P}";
chartGroup.ChartAreas["AreaGroup"].Area3DStyle.Enable3D = false;
chartGroup.DataSource = dsGroup;
serGroup.YValueMembers = "POINTS";
serGroup.XValueMember = "KPI_GROUP_NAME";
chartGroup.DataBind();
}
}
/// <summary>
/// 관점별 / 등급별 현황 그래프
/// </summary>
private void SetGraph()
{
int chartWidth = 310;
int chartHeight = 400;
double tempWidth = DataTypeUtility.GetToInt32(hdfScreenWidth.Value) * 0.31;
double tempHeight = DataTypeUtility.GetToInt32(hdfScreenHeight.Value) * 0.33;
chartWidth = DataTypeUtility.GetToInt32(Math.Round(tempWidth, 0));
chartHeight = DataTypeUtility.GetToInt32(Math.Round(tempHeight, 0));
chartView.Visible = false;
chartGrade.Visible = false;
this.SetParameter();
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsViw = new DataSet();
DataSet dsGrd = new DataSet();
if (rdoGoalTong.SelectedIndex.Equals(0))
{
dsViw = objBSC.GetEstDeptKpiViewTypeList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
dsGrd = objBSC.GetKpiGradeStatusForMap
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
}
else
{
dsViw = objBSC.GetEstDeptKpiViewTypeList_Goal
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
dsGrd = objBSC.GetKpiGradeStatusForMap_Goal
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
}
if (dsViw.Tables[0].Rows.Count > 0)
{
Chart chartMS = this.ugrdKpiStatusTab.FindControl("chartView") as Chart;
chartMS.Visible = true;
MSCharts.DundasChartBase(chartMS, ChartImageType.Jpeg, chartWidth, chartHeight
, BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 1
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
, -1
, ChartHatchStyle.None, MsGradientType.TopBottom, MsAntiAliasing.None);
Series serARate = MSCharts.CreateSeries(chartMS, "serA", "AreaView", "달성율", null, SeriesChartType.Column, 0, GetChartColor(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
chartMS.Legends[0].Enabled = false;
serARate.ToolTip = "#VALY{P}";
chartMS.ChartAreas["AreaView"].Area3DStyle.Enable3D = true;
chartMS.DataSource = dsViw;
serARate.YValueMembers = "ACHV_RATE";
serARate.XValueMember = "VIEW_NAME";
chartMS.DataBind();
}
if (dsGrd.Tables[0].Rows.Count > 0)
{
Chart chartGD = this.ugrdKpiStatusTab.FindControl("chartGrade") as Chart;
DataRow[] rows = dsGrd.Tables[0].Select(" C_RATE <> 0 ");
if (rows.Length > 0)
{
chartGD.Visible = true;
}
MSCharts.DundasChartBase(chartGD, ChartImageType.Jpeg, chartWidth, chartHeight
, BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 1
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
, -1
, ChartHatchStyle.None, MsGradientType.TopBottom, MsAntiAliasing.None);
Series serCRate = MSCharts.CreateSeries(chartGD, "serA", "AreaGrade", "달성율", null, SeriesChartType.Doughnut, 0, GetChartColor(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
chartGD.Legends[0].Enabled = false;
serCRate.ToolTip = "#VALY{P}";
chartGD.ChartAreas["AreaGrade"].Area3DStyle.Enable3D = true;
chartGD.DataSource = dsGrd;
serCRate.YValueMembers = "C_RATE";
serCRate.XValueMember = "THRESHOLD_ENAME";
chartGD.DataBind();
}
}
/// <summary>
/// 스코어카드 그리드 바인딩
/// 엑셀출력의 경우 숨겨진 그리드에 바인딩하고 출력한다(this.IPrintType == "XLS" || this.IPrintType == "PDF")
/// </summary>
public void SetDeptScoreCard()
{
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
//DataSet iDs = objBSC.GetEstDeptTotalScore( this.IEstTermRefID
// , this.IYmd
// , this.ISumType
// , this.IEstDeptID);
DataSet dsViw = new DataSet();
DataSet dsKpi = new DataSet();
DataSet dsTot = new DataSet();
if (rdoGoalTong.SelectedIndex.Equals(0))
{
dsViw = objBSC.GetEstDeptKpiViewTypeList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
dsKpi = objBSC.GetEstDeptKpiScoreList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
dsTot = objBSC.GetEstDeptTotalScore
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
}
else
{
dsViw = objBSC.GetEstDeptKpiViewTypeList_Goal
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
dsKpi = objBSC.GetEstDeptKpiScoreList_Goal
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
dsTot = objBSC.GetEstDeptTotalScore_Goal
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
}
DataSet dsTree = new DataSet();
if (ddlMapLevel.SelectedValue == "SP")
{
DataSet dsStg = new DataSet();
if (rdoGoalTong.SelectedIndex.Equals(0))
{
dsStg = objBSC.GetScorePerStrategy
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
}
else
{
dsStg = objBSC.GetScorePerStrategy_Goal
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
}
DataTable dtStg = dsStg.Tables[0].Copy();
DataTable dtKpi = dsKpi.Tables[0].Copy();
dsTree = dsViw.Copy();
dsTree.Tables.Add(dtStg);
dsTree.Tables.Add(dtKpi);
dsTree.Relations.Add("SCORE_CARD_STG", dsTree.Tables[0].Columns["VIEW_REF_ID"], dsTree.Tables[1].Columns["VIEW_REF_ID"]);
dsTree.Relations.Add("SCORE_CARD_KPI", dsTree.Tables[1].Columns["STG_REF_ID"], dsTree.Tables[2].Columns["STG_REF_ID"]);
}
else
{
DataTable dtKpi = dsKpi.Tables[0].Copy();
dsTree = dsViw.Copy();
dsTree.Tables.Add(dtKpi);
dsTree.Relations.Add("SCORE_CARD_KPI", dsTree.Tables[0].Columns["VIEW_REF_ID"], dsTree.Tables[1].Columns["VIEW_REF_ID"]);
}
if (this.IPrintType == "MONITOR")
{
ugrdScoreCard.Clear();
ugrdScoreCard.DataSource = dsTree.Tables[0].DefaultView;
ugrdScoreCard.DataBind();
}
else if (this.IPrintType == "XLS" || this.IPrintType == "PDF")
{
ugrdScoreCardForPrint.Clear();
ugrdScoreCardForPrint.DataSource = dsTree.Tables[0].DefaultView;
ugrdScoreCardForPrint.DataBind();
}
lblTotalScore.Style.Add("align", "right");
lblTotalScore.Text = (dsTot.Tables[0].Rows.Count > 0) ? double.Parse(dsTot.Tables[0].Rows[0]["POINT"].ToString()).ToString("#,##0.00") : "0";
}
private void SetKpiStatusGraph2()
{
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsGraph = new DataSet();
List <string> listYMDs = new List <string>();
Dundas.Charting.WebControl.Chart objChart = this.chtPart;
//dsGraph = TempData3();
//관점별 1년치데이타
foreach (string str in GetBeforeMonth(listYMDs))
{
dsGraph.Merge(objBSC.GetEstDeptKpiViewTypeList
(this.IEstTermRefID
, str
, this.ISumType
, this.IEstDeptID));
}
dsGraph.AcceptChanges();
dsGraph = this.ModifyData(dsGraph);
if (dsGraph.Tables[0].Rows.Count > 0)
{
DundasCharts.DundasChartBase(objChart
, Dundas.Charting.WebControl.ChartImageType.Flash
, 680, 180
, Dundas.Charting.WebControl.BorderSkinStyle.None
, Color.FromArgb(181, 64, 1)
, 1
, 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
, Dundas.Charting.WebControl.GradientType.TopBottom
, Dundas.Charting.WebControl.AntiAliasing.None);
objChart.DataSource = dsGraph;
objChart.Series.Clear();
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objViewInfo = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
DataSet rDs = objViewInfo.GetAllList();
if (rDs.Tables != null && rDs.Tables[0].Rows.Count == 4)
{
Dundas.Charting.WebControl.Series series1 = DundasCharts.CreateSeries(objChart, "sp1", "AreaView", rDs.Tables[0].Rows[0]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 224, 64, 10), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64));
Dundas.Charting.WebControl.Series series2 = DundasCharts.CreateSeries(objChart, "sp2", "AreaView", rDs.Tables[0].Rows[1]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 192, 192, 192), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64));
Dundas.Charting.WebControl.Series series3 = DundasCharts.CreateSeries(objChart, "sp3", "AreaView", rDs.Tables[0].Rows[2]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 65, 140, 240), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64));
Dundas.Charting.WebControl.Series series4 = DundasCharts.CreateSeries(objChart, "sp4", "AreaView", rDs.Tables[0].Rows[3]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 252, 180, 65), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64));
series1.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle;
series2.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle;
series3.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle;
series4.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle;
series1.MarkerBorderColor = Color.FromArgb(240, 224, 64, 10);
series1.MarkerColor = Color.FromArgb(240, 224, 64, 10);
series2.MarkerBorderColor = Color.FromArgb(240, 192, 192, 192);
series2.MarkerColor = Color.FromArgb(240, 192, 192, 192);
series3.MarkerBorderColor = Color.FromArgb(240, 65, 140, 240);
series3.MarkerColor = Color.FromArgb(240, 65, 140, 240);
series4.MarkerBorderColor = Color.FromArgb(240, 252, 180, 65);
series4.MarkerColor = Color.FromArgb(240, 252, 180, 65);
series1.ValueMembersY = "ACHV_RATE1";
series2.ValueMembersY = "ACHV_RATE2";
series3.ValueMembersY = "ACHV_RATE3";
series4.ValueMembersY = "ACHV_RATE4";
series1.ValueMemberX = "YMD";
foreach (Dundas.Charting.WebControl.Series series in objChart.Series)
{
//objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisX.Margin = false;
//objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY2.Enabled = AxisEnabled.False;
//objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY.Interval = 30;
//series.Url = HttpContext.Current.Request.Url.ToString().Substring(0, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + "/BSC0404S1.ASPX";
}
DundasAnimations.DundasChartBase(objChart, AnimationTheme.None, -1, -1, false, 1);
DundasAnimations.GrowingAnimation(objChart, series1, 0.5, 2.0, true);
DundasAnimations.GrowingAnimation(objChart, series2, 0.5, 2.0, true);
DundasAnimations.GrowingAnimation(objChart, series3, 0.5, 2.0, true);
DundasAnimations.GrowingAnimation(objChart, series4, 0.5, 2.0, true);
objChart.DataBind();
}
}
}
public void SetDeptScoreCard()
{
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet iDs = objBSC.GetEstDeptTotalScore(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataSet dsViw = objBSC.GetEstDeptKpiViewTypeList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataSet dsKpi = objBSC.GetEstDeptKpiScoreList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataSet dsTot = objBSC.GetEstDeptTotalScore
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataSet dsTree = new DataSet();
if (ddlMapLevel.SelectedValue == "SP")
{
DataSet dsStg = objBSC.GetScorePerStrategy
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataTable dtStg = dsStg.Tables[0].Copy();
DataTable dtKpi = dsKpi.Tables[0].Copy();
dsTree = dsViw.Copy();
dsTree.Tables.Add(dtStg);
dsTree.Tables.Add(dtKpi);
dsTree.Relations.Add("SCORE_CARD_STG", dsTree.Tables[0].Columns["VIEW_REF_ID"], dsTree.Tables[1].Columns["VIEW_REF_ID"]);
dsTree.Relations.Add("SCORE_CARD_KPI", dsTree.Tables[1].Columns["STG_REF_ID"], dsTree.Tables[2].Columns["STG_REF_ID"]);
}
else
{
DataTable dtKpi = dsKpi.Tables[0].Copy();
dsTree = dsViw.Copy();
dsTree.Tables.Add(dtKpi);
dsTree.Relations.Add("SCORE_CARD_KPI", dsTree.Tables[0].Columns["VIEW_REF_ID"], dsTree.Tables[1].Columns["VIEW_REF_ID"]);
}
ugrdScoreCard.Clear();
ugrdScoreCard.DataSource = dsTree.Tables[0].DefaultView;
ugrdScoreCard.DataBind();
lblTotalScore.Style.Add("align", "right");
lblTotalScore.Text = (dsTot.Tables[0].Rows.Count > 0) ? double.Parse(dsTot.Tables[0].Rows[0]["POINT"].ToString()).ToString("#,##0.00") : "0";
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objMap = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info(this.IEstTermRefID
, this.ISelDeptID
, this.IYmd);
lblDeptName.Text = objMap.Iest_dept_name;
lblDeptVision.Text = objMap.Idept_vision;
lblBSCChampion.Text = objMap.Ibscchampion_name;
}
