protected void SetFormData_Detail()
{
//Biz_Bsc_Kpi_Target objBSC = new Biz_Bsc_Kpi_Target();
//DataTable dtBsc = objBSC.GetAllList_Detail(intEstTermID, intKpiRefID, intTergetVersion).Tables[0];
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target objBSC = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target();
DataTable dtBsc = objBSC.GetAllList_Detail(intEstTermID, intKpiRefID, intTergetVersion).Tables[0];
UltraDetailList.DataSource = dtBsc;
UltraDetailList.DataBind();
}
protected void iBtnUpdate_Click(object sender, EventArgs e)
{
//DoUpating();
int iesttermRefId;
int ikpiRefId;
string iymd;
int itxrUser;
int itargetVersionId;
double icalcMs;
double icalcTs;
string targetYM;
TemplatedColumn template;
CellItem cellItemObject;
Infragistics.WebUI.WebDataInput.WebNumericEdit calcMsTxt;
Infragistics.WebUI.WebDataInput.WebNumericEdit calcTsTxt;
System.Web.UI.HtmlControls.HtmlInputText txtTargetMM;
DataTable dtKpiTarget = new DataTable();
dtKpiTarget.Columns.Add("ESTTERM_REF_ID");
dtKpiTarget.Columns.Add("KPI_REF_ID");
dtKpiTarget.Columns.Add("YMD");
dtKpiTarget.Columns.Add("UPDATE_USER");
dtKpiTarget.Columns.Add("TARGET_VERSION_ID");
dtKpiTarget.Columns.Add("TARGET_MS");
dtKpiTarget.Columns.Add("TARGET_TS");
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridRow row in this.ugridKpiTargetList.Rows)
{
string result_input_type = DataTypeUtility.GetValue(row.Cells.FromKey("resultInputType").Value);
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result();
iesttermRefId = DataTypeUtility.GetToInt32(row.Cells.FromKey("estTermRefId").Value);
ikpiRefId = DataTypeUtility.GetToInt32(row.Cells.FromKey("kpiRefId").Value);
iymd = DataTypeUtility.GetValue(row.Cells.FromKey("estYmd").Value);
itargetVersionId = DataTypeUtility.GetToInt32(row.Cells.FromKey("kpiTargetVersionId").Value);
itxrUser = this.gUserInfo.Emp_Ref_ID;
if (result_input_type.Equals("MAN"))
{
for (int i = 1; i < 13; i++)
{
string month = i.ToString().PadLeft(2, '0');
template = (TemplatedColumn)row.Cells.FromKey(string.Format("m{0}Target", month)).Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl(string.Format("txtM{0}Ms", month));
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl(string.Format("txtM{0}Ts", month));
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl(string.Format("txtTarget{0}", month));
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
DataRow rowKpiTarget = dtKpiTarget.NewRow();
rowKpiTarget["ESTTERM_REF_ID"] = iesttermRefId;
rowKpiTarget["KPI_REF_ID"] = ikpiRefId;
rowKpiTarget["YMD"] = targetYM;
rowKpiTarget["UPDATE_USER"] = targetYM;
rowKpiTarget["TARGET_VERSION_ID"] = itargetVersionId;
rowKpiTarget["TARGET_MS"] = icalcMs;
rowKpiTarget["TARGET_TS"] = icalcTs;
dtKpiTarget.Rows.Add(rowKpiTarget);
}
}
}
}
//MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result();
//objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target bizBscKpiTarget = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target();
int okCnt = bizBscKpiTarget.ModifyData(dtKpiTarget);
if (okCnt > 0)
{
ltrScript.Text = JSHelper.GetAlertScript("저장이 완료되었습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("오류가 발생하였습니다.");
}
}
private void DoCharting(int kpi_ref_id, string kpi_name)
{
chartMM.Visible = true;
chartDal.Visible = true;
int chartWidth = 500;
int chartHeight = 250;
lblKpiName1.Text = kpi_name;
lblKpiName2.Text = kpi_name;
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target bizBscKpiTarget = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target();
DataTable dtBscKpiTarget = bizBscKpiTarget.GetBscKpiTargetGoalTongMM_DB(IEstTermRefID
, kpi_ref_id
, "");
// 목표 실적 그래프
MSCharts.DundasChartBase(chartMM
, ChartImageType.Jpeg
, chartWidth
, chartHeight
, 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
, MsGradientType.TopBottom
, MsAntiAliasing.None);
chartMM.DataSource = dtBscKpiTarget;
Series series1 = MSCharts.CreateSeries(chartMM, "serTarget", "Default", "Target", null, SeriesChartType.Column, 1, GetChartColor(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Series series2 = MSCharts.CreateSeries(chartMM, "serGoal", "Default", "Goal", null, SeriesChartType.Column, 1, GetChartColor(1), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Series series3 = MSCharts.CreateSeries(chartMM, "serActl", "Default", "실적", null, SeriesChartType.Line, 1, GetChartColor(2), GetChartColor(2), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
//series3.YAxisType = AxisType.Secondary;
//series1.ValueMembersY = "TARGET_MS";
//series2.ValueMembersY = "RESULT_MS";
//series3.ValueMembersY = "GR_RATE_MS";
//series1.ValueMemberX = "MM";
string series2_col = "GOAL_MS";
string series1_col = "TARGET_MS";
string series3_col = "RESULT_MS";
if (rdoMethod.SelectedIndex.Equals(1))
{
series2_col = "GOAL_TS";
series1_col = "TARGET_TS";
series3_col = "RESULT_TS";
}
series1.YValueMembers = series1_col;
series2.YValueMembers = series2_col;
series3.YValueMembers = series3_col;
series1.XValueMember = "MM";
series1.ToolTip = "#VALY{N0}";
series2.ToolTip = "#VALY{N0}";
series3.ToolTip = "#VALY{N0}";
string sChartArea = chartMM.Series[series2.Name].ChartArea;
chartMM.ChartAreas[sChartArea].AxisY.LabelStyle.Format = "N0";
//chartMM.ChartAreas[sChartArea].AxisY2.LabelStyle.Format = "N0";
//DundasAnimations.DundasChartBase(chartMM, AnimationTheme.None, -1, -1, false, 1);
//DundasAnimations.GrowingAnimation(chartMM, series1, 1.0, 1.0, true);
//DundasAnimations.GrowingAnimation(chartMM, series2, 2.0, 2.0, true);
//DundasAnimations.GrowingAnimation(chartMM, series3, 2.0, 1.0, true);
chartMM.DataBind();
// 달성율 그래프
MSCharts.DundasChartBase(chartDal
, ChartImageType.Jpeg
, chartWidth
, chartHeight
, 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
, MsGradientType.TopBottom
, MsAntiAliasing.None);
chartDal.DataSource = dtBscKpiTarget;
Series series1D = MSCharts.CreateSeries(chartDal, "serTarget", "Default", "Target", null, SeriesChartType.Column, 1, GetChartColor(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Series series2D = MSCharts.CreateSeries(chartDal, "serGoal", "Default", "Goal", null, SeriesChartType.Column, 1, GetChartColor(1), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
//series3.YAxisType = AxisType.Secondary;
//series1.ValueMembersY = "TARGET_MS";
//series2.ValueMembersY = "RESULT_MS";
//series3.ValueMembersY = "GR_RATE_MS";
//series1.ValueMemberX = "MM";
string series2D_col = "GOAL_DAL_MS";
string series1D_col = "TARGET_DAL_MS";
if (rdoMethod.SelectedIndex.Equals(1))
{
series2D_col = "GOAL_DAL_TS";
series1D_col = "TARGET_DAL_TS";
}
series1D.YValueMembers = series1D_col;
series2D.YValueMembers = series2D_col;
series1D.XValueMember = "MM";
series1D.ToolTip = "#VALY{N0}";
series2D.ToolTip = "#VALY{N0}";
string sChartAreaD = chartDal.Series[series2D.Name].ChartArea;
chartDal.ChartAreas[sChartAreaD].AxisY.LabelStyle.Format = "N0";
//chartDal.ChartAreas[sChartAreaD].AxisY2.LabelStyle.Format = "N0";
//DundasAnimations.DundasChartBase(chartDal, AnimationTheme.None, -1, -1, false, 1);
//DundasAnimations.GrowingAnimation(chartDal, series1, 1.0, 1.0, true);
//DundasAnimations.GrowingAnimation(chartDal, series2, 2.0, 2.0, true);
//DundasAnimations.GrowingAnimation(chartDal, series3, 2.0, 1.0, true);
chartDal.DataBind();
}
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
string col_goal = "GOAL_MS";
string col_target = "TARGET_MS";
string col_result = "RESULT_MS";
string col_goal_dal = "GOAL_DAL_MS";
string col_target_dal = "TARGET_DAL_MS";
if (rdoMethod.SelectedIndex.Equals(1))
{
col_goal = "GOAL_TS";
col_target = "TARGET_TS";
col_result = "RESULT_TS";
col_goal_dal = "GOAL_DAL_TS";
col_target_dal = "TARGET_DAL_TS";
}
double goal_p = 0;
double target_p = 0;
double result = 0;
double goal_dal = 0;
double target_dal = 0;
DataRowView drw = (DataRowView)e.Data;
int kpi_ref_id = DataTypeUtility.GetToInt32(e.Row.Cells.FromKey("KPI_REF_ID").Value);
// 목표
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target_Goal bizBscKpiTargetGoal = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target_Goal();
DataTable dtBscKpiTargetGoal = bizBscKpiTargetGoal.GetBscKpiTargetGoalTong_DB(IEstTermRefID
, kpi_ref_id
, IYmd);
if (dtBscKpiTargetGoal.Rows.Count > 0)
{
goal_p = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTargetGoal.Rows[0][col_goal]).Replace("-", "0"));
goal_dal = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTargetGoal.Rows[0][col_goal_dal]).Replace("-", "0"));
}
// 실적
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result();
DataTable dtBscKpiResult = bizBscKpiResult.GetBscKpiTargetGoalTong_DB(IEstTermRefID
, kpi_ref_id
, IYmd);
if (dtBscKpiResult.Rows.Count > 0)
{
result = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiResult.Rows[0][col_result]).Replace("-", "0"));
}
// 달성율
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target bizBscKpiTarget = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target();
DataTable dtBscKpiTarget = bizBscKpiTarget.GetBscKpiTargetGoalTong_DB(IEstTermRefID
, kpi_ref_id
, IYmd);
if (dtBscKpiTarget.Rows.Count > 0)
{
target_p = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTarget.Rows[0][col_target]).Replace("-", "0"));
target_dal = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTarget.Rows[0][col_target_dal]).Replace("-", "0"));
}
e.Row.Cells.FromKey("GOAL_P").Value = goal_p;
e.Row.Cells.FromKey("TARGET_P").Value = target_p;
e.Row.Cells.FromKey("RESULT").Value = result;
e.Row.Cells.FromKey("GOAL_DAL").Value = goal_dal;
e.Row.Cells.FromKey("TARGET_DAL").Value = target_dal;
}