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(); }