private void SetKpiStatusGrid()
{
this.SetMapinfo();
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsScore = objBSC.GetEstDeptTotalScore
(
this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, chkApplyExtScore.Checked
);
if (dsScore.Tables[0].Rows.Count > 0)
{
string strs = dsScore.Tables[0].Rows[0]["POINT"].ToString();
}
DataSet dsKpi = objBSC.GetEstDeptKpiScoreList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, chkApplyExtScore.Checked);
ugrdKpiStatus.Clear();
ugrdKpiStatus.DataSource = dsKpi;
ugrdKpiStatus.DataBind();
}
private void PrintFormGrid()
{
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsKpi = objBSC.GetEstDeptKpiScoreList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.IEstDeptID
, this.IExtKpiYN);
ugrdScoreCardPrint.Clear();
ugrdScoreCardPrint.DataSource = dsKpi;
ugrdScoreCardPrint.DataBind();
string strCurDate = DateTime.Now.Year.ToString() + "_" + DateTime.Now.Month.ToString().PadRight(2, '0') + DateTime.Now.Minute.ToString().PadRight(2, '0') + DateTime.Now.Second.ToString().PadRight(2, '0');
ugrdEEP.ExcelStartRow = 10;
ugrdEEP.ExportMode = ExportMode.Download;
ugrdEEP.DownloadName = "ScoreCard" + strCurDate + ".xls";
ugrdEEP.WorksheetName = "ScoreCardFor" + lblDeptName.Text;
ugrdEEP.Export(ugrdScoreCardPrint);
ugrdScoreCardPrint.Clear();
}
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();
}
/// <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";
}
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;
}
