/// <summary>
/// 전략별 KPI 리스트 조회/ KPI 총가중치 조회
/// </summary>
/// <param name="isSelectAll"></param>
private void SetKpi(bool isSelectAll)
{
int intFindKpiID = (TtxtFindKpiID.Text == "") ? 0 : int.Parse(TtxtFindKpiID.Text);
string strFindKpiNM = TtxtFindKpiNM.Text;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi objKPI = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi();
DataSet dsKPI = objKPI.GetKpiListPerStg(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, int.Parse(this.ITreeSelValue));
TugrdKPIPerStg.Clear();
TugrdKPIPerStg.DataSource = dsKPI;
TugrdKPIPerStg.DataBind();
TugrdKPIAll.Clear();
if (isSelectAll)
{
DataSet dsKPIAll = objKPI.GetAllKpiExceptDept(this.IEstTermRefID
, this.IEstDeptRefID
, this.IMapVersionID
, intFindKpiID
, strFindKpiNM
, txtChampion.Text
, txtMgmDept.Text);
TugrdKPIAll.DataSource = dsKPIAll;
TugrdKPIAll.DataBind();
}
DataSet dsWeight = objKPI.GetWeightPerDept(this.IEstTermRefID, this.IEstDeptRefID, this.IYmd);
if (dsWeight.Tables[0].Rows.Count > 0)
{
double dblWeight = double.Parse(dsWeight.Tables[0].Rows[0]["WEIGHT"].ToString());
TlblWeightTotal.ForeColor = (dblWeight != 100) ? Color.Red : Color.Blue;
TlblWeightTotal.Text = Convert.ToString(Math.Round(dblWeight, 2, MidpointRounding.ToEven));
}
}
protected void initEnvironment()
{
exMsg.Text = "";
lblRowCount.Text = "0";
UltraWebGrid.Clear();
ltrScript.Text = "";
ibtnDownExcel.Visible = false;
}
private void GetKpiPoolQuestionList()
{
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool_Question objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool_Question();
DataSet rDs = objBSC.GetAllList(this.IKpiPoolRefID);
TugrdQuestionItem.Clear();
TugrdQuestionItem.DataSource = rDs;
TugrdQuestionItem.DataBind();
}
/// <summary>
/// 상위전략 리스트
/// </summary>
private void SetParentStg()
{
MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent();
DataSet dsStg = objBSC.GetParentStgList(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, int.Parse(this.ITreeSelValue));
TugrdUpStgList.Clear();
TugrdUpStgList.DataSource = dsStg;
TugrdUpStgList.DataBind();
DataSet dsAllStg = objBSC.GetDeptStgListExceptParentStg(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, int.Parse(this.ITreeSelValue));
TugrdStgPerDept.Clear();
TugrdStgPerDept.DataSource = dsAllStg;
TugrdStgPerDept.DataBind();
}
private void SetPointsForGraph()
{
Biz_Bsc_Kpi_Qlt_Score_Had objBSC = new Biz_Bsc_Kpi_Qlt_Score_Had();
DataSet rDs = objBSC.GetKpiEstAdjustList
(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)
, PageUtility.GetByValueDropDownList(ddlMonthInfo)
, 1
, PageUtility.GetIntByValueDropDownList(TddlEstGroup));
TugrdBias.Clear();
TugrdBias.DataSource = rDs;
TugrdBias.DataBind();
if (rDs.Tables[0].Rows.Count > 0)
{
dblAvg = Convert.ToDouble(rDs.Tables[0].Rows[0]["ALL_AVG"].ToString());
dblStd = Convert.ToDouble(rDs.Tables[0].Rows[0]["ALL_STD"].ToString());
}
DataSet rDsGraph = objBSC.GetEstEmpBiasGraphList
(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)
, PageUtility.GetByValueDropDownList(ddlMonthInfo)
, 1
, PageUtility.GetIntByValueDropDownList(TddlEstGroup));
DundasCharts.DundasChartBase(TchartBias, ChartImageType.Flash, 800, 305
, BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
, -1
, ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None);
//TchartBias.ChartAreas["Default"].AxisY.Minimum = 40;
Series serOriRng = DundasCharts.CreateSeries(TchartBias, "serOriRng", "Default", "원시점수구간", null, SeriesChartType.RangeColumn, 0, GetChartColor(0), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Series serAvgRng = DundasCharts.CreateSeries(TchartBias, "serAvgRng", "Default", "평균점수구간", null, SeriesChartType.RangeColumn, 0, GetChartColor(1), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Series serStdRng = DundasCharts.CreateSeries(TchartBias, "serStdRng", "Default", "평균.표준편차점수구간", null, SeriesChartType.RangeColumn, 0, GetChartColor(2), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Series serEmpAvg = DundasCharts.CreateSeries(TchartBias, "serEmpAvg", "Default", "평가자별평균점수", null, SeriesChartType.Line, 3, GetChartColor(3), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 0, 7, Color.FromArgb(64, 64, 64));
Series serAllAvg = DundasCharts.CreateSeries(TchartBias, "serAllAvg", "Default", "전체평균점수", null, SeriesChartType.Point, 1, GetChartColor(4), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 0, 7, Color.FromArgb(64, 64, 64));
string strEstEmp = "";
double dblEmpAvg = 0;
double dblAllAvg = 0;
double dblOriMin = 0;
double dblOriMax = 0;
double dblAvgMin = 0;
double dblAvgMax = 0;
double dblStdMin = 0;
double dblStdMax = 0;
int cntRow = rDsGraph.Tables[0].Rows.Count;
for (int i = 0; i < cntRow; i++)
{
strEstEmp = rDsGraph.Tables[0].Rows[i]["EMP_NAME"].ToString();
dblEmpAvg = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["ORI_AVG_SCORE"].ToString());
dblAllAvg = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["ALL_AVG_SCORE"].ToString());
dblOriMin = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["ORI_MIN_SCORE"].ToString());
dblOriMax = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["ORI_MAX_SCORE"].ToString());
dblAvgMin = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["AVG_MIN_SCORE"].ToString());
dblAvgMax = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["AVG_MAX_SCORE"].ToString());
dblStdMin = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["STD_MIN_SCORE"].ToString());
dblStdMax = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["STD_MAX_SCORE"].ToString());
object[] objOri = new object[] { dblOriMax, dblOriMin };
object[] objAvg = new object[] { dblAvgMax, dblAvgMin };
object[] objStd = new object[] { dblStdMax, dblStdMin };
serEmpAvg.Points.AddXY(strEstEmp, dblEmpAvg);
serAllAvg.Points.AddXY(strEstEmp, dblAllAvg);
serOriRng.Points.AddXY(strEstEmp, objOri);
serAvgRng.Points.AddXY(strEstEmp, objAvg);
serStdRng.Points.AddXY(strEstEmp, objStd);
}
serEmpAvg.MarkerStyle = MarkerStyle.Diamond;
serAllAvg.MarkerStyle = MarkerStyle.Triangle;
serEmpAvg.ToolTip = "#VALY{N0}";
serAllAvg.ToolTip = "#VALY{N0}";
serOriRng.ToolTip = "#VALY{N0}";
serAvgRng.ToolTip = "#VALY{N0}";
serStdRng.ToolTip = "#VALY{N0}";
}