public void SetWeight()
{
int itxr_user = gUserInfo.Emp_Ref_ID;
UltraGridRow row;
Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight();
DataTable dt = new DataTable();
dt.Columns.Add("ESTTERM_REF_ID", typeof(int));
dt.Columns.Add("KPI_REF_ID", typeof(int));
dt.Columns.Add("WEIGHT", typeof(decimal));
dt.Columns.Add("KPI_CLASS_REF_ID", typeof(string));
for (int i = 0; i < ugrdMBO.Rows.Count; i++)
{
row = ugrdMBO.Rows[i];
DataRow dr = dt.NewRow();
dr["ESTTERM_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value);
dr["KPI_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_REF_ID").Value);
dr["WEIGHT"] = DataTypeUtility.GetToDouble(row.Cells.FromKey("WEIGHT").Value);
try
{
dr["KPI_CLASS_REF_ID"] = (row.Cells.FromKey("IS_TEAM_KPI").Value.ToString() == "Y" ? "SCO" : "PCO");
}
catch { }
dt.Rows.Add(dr);
}
if (objBSC.UpdateMBOWeight(gUserInfo.Emp_Ref_ID, dt))
{
PageUtility.AlertMessage("처리하였습니다.");
}
else
{
PageUtility.AlertMessage("실패하였습니다.");
}
DoBinding();
}
public void SetMBOKpi(string iType)
{
int itxr_user = gUserInfo.Emp_Ref_ID;
CheckBox chk;
UltraGridRow row;
TemplatedColumn col;
UltraWebGrid ugrdKpi = (iType == "ADD") ? ugrdKpiList : ugrdChildKpi;
int cntRow = 0;
Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight();
if (iType == "DEL")
{
DataTable dt = new DataTable();
dt.Columns.Add("ESTTERM_REF_ID", typeof(int));
dt.Columns.Add("EMP_REF_ID", typeof(int));
dt.Columns.Add("KPI_REF_ID", typeof(int));
for (int i = 0; i < ugrdKpi.Rows.Count; i++)
{
row = ugrdKpi.Rows[i];
col = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox");
if (chk.Checked)
{
DataRow dr = dt.NewRow();
dr["ESTTERM_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value);
dr["EMP_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
dr["KPI_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_REF_ID").Value);
dt.Rows.Add(dr);
}
}
if (dt.Rows.Count > 0)
{
if (objBSC.DeleteMBOWeight(dt, gUserInfo.Emp_Ref_ID))
{
this.SetMyKpiList();
this.SetKpiListExceptMine();
PageUtility.AlertMessage("삭제하였습니다.");
}
else
{
PageUtility.AlertMessage("실패하였습니다.");
}
return;
}
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("ESTTERM_REF_ID", typeof(int));
dt.Columns.Add("KPI_REF_ID", typeof(int));
dt.Columns.Add("WEIGHT", typeof(decimal));
dt.Columns.Add("KPI_CLASS_REF_ID", typeof(string));
for (int i = 0; i < ugrdKpi.Rows.Count; i++)
{
row = ugrdKpi.Rows[i];
col = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox");
if (chk.Checked)
{
DataRow dr = dt.NewRow();
dr["ESTTERM_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value);
dr["KPI_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_REF_ID").Value);
if (iType == "ADD")
{
dr["WEIGHT"] = 0;
}
else if (iType == "SET")
{
dr["WEIGHT"] = DataTypeUtility.GetToDecimal(row.Cells.FromKey("WEIGHT").Value);
}
try
{
dr["KPI_CLASS_REF_ID"] = (row.Cells.FromKey("IS_TEAM_KPI").Value.ToString() == "Y" ? "SCO" : "PCO");
}
catch { }
dt.Rows.Add(dr);
}
}
if (dt.Rows.Count > 0)
{
if (objBSC.UpdateMBOWeight(gUserInfo.Emp_Ref_ID
, dt))
{
this.SetMyKpiList();
this.SetKpiListExceptMine();
PageUtility.AlertMessage("처리하였습니다.");
}
else
{
PageUtility.AlertMessage("실패하였습니다.");
}
return;
}
}
if (cntRow < 1)
{
PageUtility.AlertMessage("항목을 선택하세요.");
}
else
{
this.SetMyKpiList();
this.SetKpiListExceptMine();
PageUtility.AlertMessage("삭제하였습니다.");
}
}