private void SetResultGrid()
{
this.IYMD = PageUtility.GetByValueDropDownList(ddlMonthInfo);
if (rdoGoalTong.SelectedIndex.Equals(0))
{
IGoalTong_YN = "N";
}
else
{
IGoalTong_YN = "Y";
}
Biz_Bsc_Kpi_Result objBSC = new Biz_Bsc_Kpi_Result(this.IEstTermRefID, this.IKpiRefID, this.IYMD);
DataSet rDs = objBSC.GetResultAnalysisList(this.IEstTermRefID, this.IKpiRefID, this.IYMD, this.IGoalTong_YN);
txtPlan_Month.Text = objBSC.Imeasure_text_ms;
txtPlan_Sum.Text = objBSC.Imeasure_text_ts;
txtReason_Month.Text = objBSC.Icause_text_ms;
txtReason_Sum.Text = objBSC.Icause_text_ts;
if (objBSC.Icause_file_id == "")
{
iBtnCauseFileID.Visible = false;
}
else
{
iBtnCauseFileID.Visible = true;
hdfCauseDocNo.Value = objBSC.Icause_file_id;
}
if (objBSC.Imeasure_file_id == "")
{
iBtnMeasureFileID.Visible = false;
}
else
{
iBtnMeasureFileID.Visible = false;
hdfMeasureDocNo.Value = objBSC.Imeasure_file_id;
}
ugrdKpiResultStatus.Clear();
ugrdKpiResultStatus.DataSource = rDs;
ugrdKpiResultStatus.DataBind();
try
{
this.SetResutlGraph(rDs);
}
catch (Exception e)
{
string msg = e.Message;
}
}
public void SetMonthlyResultGraph()
{
Biz_Bsc_Kpi_Info objKpi = new Biz_Bsc_Kpi_Info(this.IEstTermRefID, this.IKpiRefID);
lblKpiCode.Text = objKpi.Ikpi_code;
lblKpiName.Text = objKpi.Ikpi_name;
lblResultInputType.Text = objKpi.Iresult_input_type_name;
lblUnitName.Text = objKpi.Iunit_name;
Biz_Bsc_Kpi_Result objBSC = new Biz_Bsc_Kpi_Result(this.IEstTermRefID, this.IKpiRefID, this.IYMD);
DataSet rDs = objBSC.GetResultAnalysisList(this.IEstTermRefID, this.IKpiRefID, this.IYMD, this.IGoalTong_YN);
DataTable dtMs = new DataTable("TBL_MS");
DataTable dtTs = new DataTable("TBL_TS");
dtMs.Columns.Add("MM", typeof(string));
dtMs.Columns.Add("TARGET", typeof(double));
dtMs.Columns.Add("RESULT", typeof(double));
dtTs.Columns.Add("MM", typeof(string));
dtTs.Columns.Add("TARGET", typeof(double));
dtTs.Columns.Add("RESULT", typeof(double));
double dTargetMs = 0;
double dTargetTs = 0;
double dResultMs = 0;
double dResultTs = 0;
DataRow[] arrDr = null;
DataRow rDr = null;
if (rDs.Tables.Count > 0)
{
if (rDs.Tables[0].Rows.Count > 0)
{
string sFilter = "KPI_REF_ID=" + this.IKpiRefID.ToString() + " AND YMD='" + this.IYMD + "'";
arrDr = rDs.Tables[0].Select(sFilter);
if (arrDr.GetLength(0) > 0)
{
dTargetMs = double.Parse(arrDr[0]["TARGET_MS"].ToString());
dTargetTs = double.Parse(arrDr[0]["TARGET_TS"].ToString());
dResultMs = double.Parse(arrDr[0]["RESULT_MS"].ToString());
dResultTs = double.Parse(arrDr[0]["RESULT_TS"].ToString());
}
}
}
rDr = dtMs.NewRow();
rDr["MM"] = this.IYMD;
rDr["TARGET"] = dTargetMs;
rDr["RESULT"] = dResultMs;
dtMs.Rows.Add(rDr);
rDr = dtTs.NewRow();
rDr["MM"] = this.IYMD;
rDr["TARGET"] = dTargetTs;
rDr["RESULT"] = dResultTs;
dtTs.Rows.Add(rDr);
DundasCharts.DundasChartBase(chartMs, ChartImageType.Flash, 360, 200
, 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);
Series serTargetMs = DundasCharts.CreateSeries(chartMs, "Series1", "Default", "계획", null, SeriesChartType.Column, 1, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Series serResultMs = DundasCharts.CreateSeries(chartMs, "Series2", "Default", "실적", null, SeriesChartType.Column, 1, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
serTargetMs.ToolTip = "#VALY{N0}";
serResultMs.ToolTip = "#VALY{N0}";
chartMs.ChartAreas[chartMs.Series[serTargetMs.Name].ChartArea].AxisY.LabelStyle.Format = "N0";
chartMs.ChartAreas[chartMs.Series[serTargetMs.Name].ChartArea].Area3DStyle.Enable3D = true;
chartMs.ToolTip = "#VALY{N0}";
chartMs.DataSource = dtMs.DefaultView;
serTargetMs.ValueMemberX = "MM";
serTargetMs.ValueMembersY = "TARGET";
serResultMs.ValueMembersY = "RESULT";
chartMs.DataBind();
DundasCharts.DundasChartBase(chartTs, ChartImageType.Flash, 360, 200
, 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);
Series serTargetTs = DundasCharts.CreateSeries(chartTs, "Series1", "Default", "계획", null, SeriesChartType.Column, 1, GetChartColor(0), GetChartColor(0), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Series serResultTs = DundasCharts.CreateSeries(chartTs, "Series2", "Default", "실적", null, SeriesChartType.Column, 1, GetChartColor(1), GetChartColor(1), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
serTargetTs.ToolTip = "#VALY{N0}";
serResultTs.ToolTip = "#VALY{N0}";
chartTs.ChartAreas[chartTs.Series[serTargetTs.Name].ChartArea].AxisY.LabelStyle.Format = "N0";
chartTs.ChartAreas[chartTs.Series[serTargetTs.Name].ChartArea].Area3DStyle.Enable3D = true;
chartTs.ToolTip = "#VALY{N0}";
chartTs.DataSource = dtTs.DefaultView;
serTargetTs.ValueMemberX = "MM";
serTargetTs.ValueMembersY = "TARGET";
serResultTs.ValueMembersY = "RESULT";
chartTs.DataBind();
if (objKpi.Iresult_input_type == "KPI")
{
this.SetChildKpiGrid();
}
else
{
this.SetInterfaceGrid();
}
}
