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