public void SetResultListGrid()
{
DataSet ds;
_iestterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo);
_iymd = PageUtility.GetByValueDropDownList(ddlEstTermMonth, "");
if (txtDeptCode.Value == string.Empty)
{
_iest_dept_id = 0;
}
else
{
_iest_dept_id = int.Parse(txtDeptCode.Value);
}
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result();
if (((SitePrincipal)this.User).Roles.Contains("1") == true || ((SitePrincipal)this.User).Roles.Contains("8") == true)
{
ds = objBSC.SelectKpiList(_iestterm_ref_id, _iest_dept_id, _iymd, 0);
}
else
{
ds = objBSC.SelectKpiList(_iestterm_ref_id, _iest_dept_id, _iymd, this.gUserInfo.Emp_Ref_ID);
}
this.ugridKpiTargetList.DataSource = ds;
this.ugridKpiTargetList.DataBind();
lblRowCount.Text = ugridKpiTargetList.Rows.Count.ToString();
}
private void SetPaReportGrid()
{
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result();
DataSet rDs = objBSC.GetResultPaReportList(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)
, PageUtility.GetByValueDropDownList(ddlMonthInfo));
ugrdPaReport.Clear();
ugrdPaReport.DataSource = rDs;
ugrdPaReport.DataBind();
if (rDs.Tables[0].Rows.Count > 0)
{
float cnt = rDs.Tables[0].Select("PA_YN = 'Y'").Length;
float total = rDs.Tables[0].Rows.Count;
float rate = cnt / total * 100.0f;
lblRowCount.Text = string.Format("{0} / {1} ({2} %)", cnt, total, rate.ToString("N2"));
}
}
private void setUpdate()
{
int iesttermRefId;
int ikpiRefId;
string iymd;
int itxrUser;
double iresultMs;
double iresultTs;
TemplatedColumn template;
CellItem cellItemObject;
Infragistics.WebUI.WebDataInput.WebNumericEdit inputTxt;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridRow row in this.ugridKpiTargetList.Rows)
{
iesttermRefId = DataTypeUtility.GetToInt32(row.Cells.FromKey("estTermRefId").Value);
ikpiRefId = DataTypeUtility.GetToInt32(row.Cells.FromKey("kpiRefId").Value);
iymd = DataTypeUtility.GetValue(row.Cells.FromKey("estYmd").Value);
itxrUser = DataTypeUtility.GetToInt32(this.USERID);
template = (TemplatedColumn)row.Cells.FromKey("resultMs").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
inputTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtResultMs");
iresultMs = inputTxt.ValueDouble;
template = (TemplatedColumn)row.Cells.FromKey("resultTs").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
inputTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtResultTs");
iresultTs = inputTxt.ValueDouble;
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result();
int result = objBSC.UpdateKpiResult(null, null, iesttermRefId, ikpiRefId, iymd, itxrUser, iresultMs, iresultTs);
}
ltrScript.Text = JSHelper.GetAlertScript("저장이 완료되었습니다.");
}
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 DoUpating()
{
int iesttermRefId;
int ikpiRefId;
string iymd;
int itxrUser;
int itargetVersionId;
double icalcMs;
double icalcTs;
string targetMonth;
string targetYM;
TemplatedColumn template;
CellItem cellItemObject;
Infragistics.WebUI.WebDataInput.WebNumericEdit calcMsTxt;
Infragistics.WebUI.WebDataInput.WebNumericEdit calcTsTxt;
System.Web.UI.HtmlControls.HtmlInputText txtTargetMM;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridRow row in this.ugridKpiTargetList.Rows)
{
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;
/* 1월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m01Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM01Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM01Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget01");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 2월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m02Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM02Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM02Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget02");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 3월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m03Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM03Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM03Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget03");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 4월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m04Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM04Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM04Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget04");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 5월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m05Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM05Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM05Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget05");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 6월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m06Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM06Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM06Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget06");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 7월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m07Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM07Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM07Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget07");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 8월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m08Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM08Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM08Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget08");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 9월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m09Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM09Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM09Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget09");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 10월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m10Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM10Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM10Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget10");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 11월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m11Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM11Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM11Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget11");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
/* 12월 목표 설정 */
template = (TemplatedColumn)row.Cells.FromKey("m12Target").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
calcMsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM12Ms");
calcTsTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtM12Ts");
txtTargetMM = (System.Web.UI.HtmlControls.HtmlInputText)cellItemObject.FindControl("txtTarget12");
icalcMs = calcMsTxt.ValueDouble;
icalcTs = calcTsTxt.ValueDouble;
if (string.IsNullOrEmpty(txtTargetMM.Value) == false)
{
targetYM = row.Cells.FromKey("perYear").Value.ToString() + txtTargetMM.Value;
objBSC.UpdateKpiTarget(null, null, iesttermRefId, ikpiRefId, targetYM, itxrUser, itargetVersionId, icalcMs, icalcTs);
}
}
}
