protected void BindChart()
{
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Score_Goal bizKpiScoreGoal = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Score_Goal();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Score bizKpiScore = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Score();
if (rdoGoalTong.SelectedValue.Equals("GOAL"))
{
DT_SCORE = bizKpiScoreGoal.Get_Kpi_Monthly_Score(ESTTERM_REF_ID, DEPT_REF_ID, SUM_TYPE);
}
else
{
DT_SCORE = bizKpiScore.Get_Kpi_Monthly_Score(ESTTERM_REF_ID, DEPT_REF_ID, SUM_TYPE);
}
DrawChart(DT_SCORE);
}
protected void BindGrid()
{
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card bizScoreCard = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Score_Goal bizKpiScoreGoal = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Score_Goal();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Score bizKpiScore = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Score();
DataTable dt_kpiScore = new DataTable();
DataTable dt_kpiScore_monthly_TS = new DataTable();
if (rdoGoalTong.SelectedValue.Equals("GOAL"))
{
dt_kpiScore = bizScoreCard.GetEstDeptKpiScoreList(ESTTERM_REF_ID, YMD, "TS", DEPT_REF_ID, false).Tables[0];
dt_kpiScore_monthly_TS = bizKpiScoreGoal.Get_Kpi_Monthly_Total_Sum(ESTTERM_REF_ID, DEPT_REF_ID);
}
else
{
dt_kpiScore = bizScoreCard.GetEstDeptKpiScoreList_Goal(ESTTERM_REF_ID, YMD, "TS", DEPT_REF_ID, false).Tables[0];
dt_kpiScore_monthly_TS = bizKpiScore.Get_Kpi_Monthly_Total_Sum(ESTTERM_REF_ID, DEPT_REF_ID);
}
//월별 컬럼 생성
string year = YMD.Substring(0, 4);
for (int j = 1; j <= 12; j++)
{
string month = j.ToString().PadLeft(2, '0');
dt_kpiScore.Columns.Add(year + month);
}
//월별 컬럼에 값 추가
for (int i = 0; i < dt_kpiScore.Rows.Count; i++)
{
string kpi_ref_id = DataTypeUtility.GetString(dt_kpiScore.Rows[i]["KPI_REF_ID"]);
for (int j = 1; j <= 12; j++)
{
string month = j.ToString().PadLeft(2, '0');
string filter = string.Format("KPI_REF_ID='{0}' AND YMD='{1}'", kpi_ref_id, year + month);
DataTable dt_tmp_monthly_score = DataTypeUtility.FilterSortDataTable(dt_kpiScore_monthly_TS, filter);
if (dt_tmp_monthly_score.Rows.Count > 0)
{
dt_kpiScore.Rows[i][year + month] = DataTypeUtility.GetString(dt_tmp_monthly_score.Rows[0]["SCORE_TS"]);
}
}
}
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = dt_kpiScore;
UltraWebGrid1.DataBind();
}
