public void SetOpinionGrid()
{
Biz_Bsc_Kpi_Qlt_Score_Had objOpn = new Biz_Bsc_Kpi_Qlt_Score_Had();
DataSet oDs = objOpn.GetAllList(this.IEstTermRefID
, this.IYMD
, 0
, this.IKpiRefID //PageUtility.GetIntByValueDropDownList(ddlEstLevel)
, 0);
ugrdEstOpinion.Clear();
ugrdEstOpinion.DataSource = oDs.Tables[0].DefaultView;
ugrdEstOpinion.DataBind();
}
private void SetOpinionListPerKpi()
{
Biz_Bsc_Kpi_Qlt_Score_Had objBSC = new Biz_Bsc_Kpi_Qlt_Score_Had();
DataSet rDs = objBSC.GetAllList
(this.IEsttermRefID
, PageUtility.GetByValueDropDownList(ddlEstTermMonth)
, this.IGroupRefID
, this.IKpiRefID
, 0);
ugrdOpinionList.Clear();
ugrdOpinionList.DataSource = rDs;
ugrdOpinionList.DataBind();
}
private void SetKpiOpinionList()
{
//Biz_Bsc_Validation_Group_Kpi objBSC = new Biz_Bsc_Validation_Group_Kpi();
//DataSet rDs = objBSC.GetOpinionListPerKpi(this.IEsttermRefID, this.IGroupRefID, this.IEstLevel, this.IKpiRefID);
Biz_Bsc_Kpi_Qlt_Score_Had objBSC = new Biz_Bsc_Kpi_Qlt_Score_Had();
DataSet rDs = objBSC.GetKpiEstCompleteList
(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, PageUtility.GetByValueDropDownList(ddlEstTermMonth)
, PageUtility.GetIntByValueDropDownList(ddlEstGroup)
, (ddlEstDept.SelectedValue == "") ? 0 : PageUtility.GetIntByValueDropDownList(ddlEstDept)
);
ugrdKpiList.Clear();
ugrdKpiList.DataSource = rDs;
ugrdKpiList.DataBind();
}
private void SetKpiEstOpinion()
{
//Biz_Bsc_Validation_Group_Kpi objBSC = new Biz_Bsc_Validation_Group_Kpi
// (PageUtility.GetIntByValueDropDownList(ddlEstTerm)
// , PageUtility.GetIntByValueDropDownList(ddlEstGroup)
// , PageUtility.GetIntByValueDropDownList(ddlEstLevel)
// , this.IValidationUserID
// , this.IKpiRefID
// );
//txtEstOpinion.Text = objBSC.Iopinion;
Biz_Bsc_Kpi_Qlt_Score_Had objBSC = new Biz_Bsc_Kpi_Qlt_Score_Had();
DataSet rDs = objBSC.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, ""
, PageUtility.GetIntByValueDropDownList(ddlEstGroup)
, this.IKpiRefID //PageUtility.GetIntByValueDropDownList(ddlEstLevel)
, this.IValidationUserID);
ugrdOpinion.Clear();
ugrdOpinion.DataSource = rDs;
ugrdOpinion.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}";
}
