private void SetKpiStatusGraph()
{
this.SetParameter();
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard();
DataSet rDs = objBSC.GetAllList(this.IEstTermRefID);
int cntRow = 0;
int cntCol = 0;
int intEsttermRefID = 0;
int intKpiRefID = 0;
string strTrendType = "";
string strKpiName = "";
string strTypeName = "";
cntRow = rDs.Tables[0].Rows.Count;
cntCol = rDs.Tables[0].Columns.Count;
Chart objChart = null;
for (int i = 0; i < cntRow; i++)
{
intEsttermRefID = Convert.ToInt32(rDs.Tables[0].Rows[i]["ESTTERM_REF_ID"].ToString());
intKpiRefID = Convert.ToInt32(rDs.Tables[0].Rows[i]["KPI_REF_ID"].ToString());
strTrendType = Convert.ToString(rDs.Tables[0].Rows[i]["SELECT_TYPE"].ToString());
strKpiName = Convert.ToString(rDs.Tables[0].Rows[i]["KPI_NAME"].ToString());
strTypeName = Convert.ToString(rDs.Tables[0].Rows[i]["SELECT_TYPE_NAME"].ToString());
DataSet dsGraph = objBSC.GetDashBoardForKpiAnalysis(intEsttermRefID, intKpiRefID, "00000000", this.IYmd, this.ISumType);
//DataSet dsGraph = objBSC.GetDashBoardForKpiAnalysis(intEsttermRefID, intKpiRefID, this.IYmd, "99999999", this.ISumType);
switch (i)
{
case 0:
objChart = chtKPI1;
objChart.Visible = true;
break;
case 1:
objChart = chtKPI2;
objChart.Visible = true;
break;
case 2:
objChart = chtKPI3;
objChart.Visible = true;
break;
case 3:
objChart = chtKPI4;
objChart.Visible = true;
break;
case 4:
objChart = chtKPI5;
objChart.Visible = true;
break;
case 5:
objChart = chtKPI6;
objChart.Visible = true;
break;
default:
return;
}
MSCharts.DundasChartBase(objChart, ChartImageType.Jpeg, 300, 100
, BorderSkinStyle.Emboss, Color.FromArgb(26, 59, 105), 2
, Color.FromArgb(211, 223, 240)
, Color.FromArgb(255, 255, 255), Color.FromArgb(37, 58, 118), ChartDashStyle.Solid
, -1
, ChartHatchStyle.None, MsGradientType.TopBottom, MsAntiAliasing.None);
Series serKpi = MSCharts.CreateSeries
(objChart, strTypeName, objChart.ChartAreas[0].Name,
strTypeName, null, WebCommon.GetMSChartType(rDs.Tables[0].Rows[i]["GRAPH_TYPE"].ToString()), 2,
GetSignalColor(i), GetChartColor(i),
Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
objChart.ChartAreas[objChart.Series[serKpi.Name].ChartArea].AxisX.Interval = 4;
objChart.ChartAreas[objChart.Series[serKpi.Name].ChartArea].Area3DStyle.Enable3D = false;
objChart.ChartAreas[objChart.Series[serKpi.Name].ChartArea].AxisY2.Enabled = AxisEnabled.False;
objChart.ChartAreas[objChart.Series[serKpi.Name].ChartArea].AxisY.LabelStyle.Format = "#,##0";
//string strHerf = HttpContext.Current.Request.Url.ToString().Substring(0, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + "/BSC0304S2.aspx?ESTTERM_REF_ID=" + intEsttermRefID.ToString() + "&KPI_REF_ID=" + intKpiRefID.ToString() + "&YMD=" + this.IYmd;
string strHerf = HttpContext.Current.Request.Url.ToString().Substring(0, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + "/BSC0304S2.aspx?ITYPE=POP&ESTTERM_REF_ID=" + intEsttermRefID.ToString() + "&KPI_REF_ID=" + intKpiRefID.ToString() + "&YMD=" + this.IYmd;
string strURL = "javascript:gfOpenWindow('" + strHerf + "',840,600,'no','no');";
objChart.DataSource = dsGraph;
serKpi.YValueMembers = "RESULT_VALUE";
serKpi.XValueMember = "YMD";
objChart.DataBind();
objChart.Legends[0].Enabled = false;
objChart.Titles[0].Text = strKpiName;
objChart.Titles[0].Url = strURL;
dsGraph = null;
serKpi = null;
objChart = null;
}
}