protected void btnSave_Click(object sender, EventArgs e)
{
if (hdfChampionEmpId.Value != "")
{
int row_effect = 0;
for (int i = 0; i < ugrdKpiList.Rows.Count; i++)
{
UltraGridRow row = ugrdKpiList.Rows[i];
TemplatedColumn col = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
CheckBox chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox");
if (chk.Checked)
{
int estterm_ref_id = int.Parse(row.Cells.FromKey("ESTTERM_REF_ID").Value.ToString());
int kpi_ref_id = int.Parse(row.Cells.FromKey("KPI_REF_ID").Value.ToString());
row_effect += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiInfoChampionChange(kpi_ref_id, int.Parse(hdfChampionEmpId.Value), estterm_ref_id);
}
}
if (row_effect > 0)
{
ltrScript.Text = JSHelper.GetAlertScript("수정되었습니다.");
setKpiData();
}
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("사원을 선택해 주세요.");
return;
}
}
protected void btnSumAdd_Click(object sender, EventArgs e)
{
int row = 0;
int cnt = ugrdKpiList.Rows.Count;
double sum = 0;
if (cnt > 0)
{
for (int i = 0; i < cnt; i++)
{
sum += DataTypeUtility.GetToDouble(ugrdKpiList.Rows[i].Cells.FromKey("WEIGHT").Value);
}
if (sum > 100)
{
Response.Write("<script>alert('합계는 100이하여야 합니다.');</script>");
}
else
{
for (int i = 0; i < cnt; i++)
{
double weight = DataTypeUtility.GetToDouble(ugrdKpiList.Rows[i].Cells.FromKey("WEIGHT").Value);
int STG_REF_ID = int.Parse(ugrdKpiList.Rows[i].Cells.FromKey("STG_REF_ID").Value.ToString());
int EST_DEPT_REF_ID = int.Parse(ugrdKpiList.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value.ToString());
int ESTTERM_REF_ID = int.Parse(ugrdKpiList.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value.ToString());
int KPI_REF_ID = int.Parse(ugrdKpiList.Rows[i].Cells.FromKey("KPI_REF_ID").Value.ToString());
row += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiWeightUpdate(weight, ESTTERM_REF_ID, EST_DEPT_REF_ID
, 1, STG_REF_ID, KPI_REF_ID);
}
setKpiData();
}
}
}
private void DoBinding(int estTermRefID, int deptID)
{
UltraWebGrid1.Clear();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();
DataTable dtBscKpiInfo = bizBscKpiInfo.Get_GoalTongDashboard(estTermRefID, deptID);
if (dtBscKpiInfo.Rows.Count > 0)
{
this.ChartView.Visible = true;
UltraWebGrid1.DataSource = dtBscKpiInfo;
UltraWebGrid1.DataBind();
UltraWebGrid1.Rows[0].Activated = true;
int kpi_ref_id = DataTypeUtility.GetToInt32(dtBscKpiInfo.Rows[0]["KPI_REF_ID"]);
string kpi_name = DataTypeUtility.GetValue(dtBscKpiInfo.Rows[0]["KPI_NAME"]);
DoCharting(kpi_ref_id, kpi_name);
}
else
{
this.ChartView.Visible = false;
//chartMM.Visible = false;
//chartDal.Visible = false;
}
}
protected void iBtnConfirm_Click(object sender, ImageClickEventArgs e)
{
int effrctRow = 0;
Biz_QuestionDeptEmpMaps questionDeptEmpMaps = new Biz_QuestionDeptEmpMaps();
DataTable dataTable = questionDeptEmpMaps.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid2
, new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
effrctRow += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiAutoInsert(ESTTERM_REF_ID, view_ref_id, stg_ref_id, poo_ref_id,
int.Parse(dataRow["TGT_DEPT_ID"].ToString()), int.Parse(dataRow["TGT_EMP_ID"].ToString()));
}
if (effrctRow > 0)
{
ltrScript.Text = JSHelper.GetOpenerControlCallBackScript(POSTBACK_CTRL_NAME, true);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("추가하실 사원을 선택하세요.");
}
}
protected void iBtnSave_Click(object sender, ImageClickEventArgs e)
{
object[] objList = GetSelectKpiList();
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
DataSet dsYear = objTerm.GetTermDetail(ESTTERM_REF_ID);
if (dsYear.Tables[0].Rows.Count < 1)
{
ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요.");
return;
}
Biz_Bsc_Kpi_Info objMBO = new Biz_Bsc_Kpi_Info();
//if (objMBO.CopyKpiToMbo(ESTTERM_REF_ID
// , objList
// , gUserInfo.Emp_Ref_ID
// , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
// , "STG"))
//{
// DoBindingDept();
// DoBinding();
// ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다.");
//}
//else
//{
// ltrScript.Text = JSHelper.GetAlertScript("복사가 실패하였습니다.");
//}
int checkCount = 0;
for (int i = 0; i < objList.Length; i++)
{
checkCount += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiInfoExsistCheckPerson(int.Parse(objList[i].ToString()), gUserInfo.Emp_Ref_ID, ESTTERM_REF_ID);
}
if (checkCount > 0)
{
Response.Write("<script>alert('중복되는 KPI 풀입니다.');</script>");
}
else
{
string returnStr = objMBO.CopyKpiToMbo_NW(ESTTERM_REF_ID
, objList
, gUserInfo.Emp_Ref_ID
, dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
, "STG");
if (returnStr.Equals(string.Empty))
{
DoBindingDept();
ltrScript.Text = JSHelper.GetAlertOpenerReflashScript("복사를 완료하였습니다.", true);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(returnStr);
}
}
}
protected void ibtnInsert2_Click(object sender, ImageClickEventArgs e)
{
object[] objList = GetSelectTeamMboList();
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
DataSet dsYear = objTerm.GetTermDetail(PageUtility.GetIntByValueDropDownList(ddlEstTerm));
if (dsYear.Tables[0].Rows.Count < 1)
{
ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요.");
return;
}
Biz_Bsc_Kpi_Info objMBO = new Biz_Bsc_Kpi_Info();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();
bool Result = bizBscKpiInfo.CopyKpiToMbo(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, objList
, gUserInfo.Emp_Ref_ID
, dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
, "PRS");
/*
* bool Result = objMBO.CopyKpiToMbo(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
* , objList
* , gUserInfo.Emp_Ref_ID
* , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
* , "PRS");
*/
if (Result)
{
DoBindingDeptMBO();
DoBinding();
ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다.");
}
else
{
Response.Write(objMBO.Transaction_Message);
ltrScript.Text = JSHelper.GetAlertScript("복사가 실패하였습니다.");
}
}
protected void iBtnInsert_Click(object sender, EventArgs e)
{
int effectrows = 0;
int cnt = ugrdStgList.Rows.Count;
if (cnt > 0)
{
for (int i = 0; i < cnt; i++)
{
UltraGridRow row = ugrdStgList.Rows[i];
TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox");
if (cBox.Checked)
{
int KPI_POOL_REF_ID = DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_POOL_REF_ID").Value);
int STG_REF_ID = DataTypeUtility.GetToInt32(row.Cells.FromKey("STG_REF_ID").Value);
int VIEW_REF_ID = DataTypeUtility.GetToInt32(row.Cells.FromKey("VIEW_REF_ID").Value);
if (new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiInfoExsistCheck(KPI_POOL_REF_ID, gUserInfo.Emp_Ref_ID, ESTTERM_REF_ID) > 0)
{
Response.Write("<script>alert('중복되는 KPI 입니다.');</script>");
}
else
{
effectrows += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiAutoInsert(ESTTERM_REF_ID
, VIEW_REF_ID, STG_REF_ID, KPI_POOL_REF_ID, gUserInfo.Dept_Ref_ID, gUserInfo.Emp_Ref_ID);
}
}
}
if (effectrows > 0)
{
Response.Write("<script>alert('저장 되었습니다.');window.opener.location.reload();window.close();</script>");
}
}
else
{
Response.Write("<script>alert('한개이상은 체크하셔야 합니다.');</script>");
}
}
protected void ibtnDelete2_Click(object sender, ImageClickEventArgs e)
{
//object[] objList = GetSelectMboList();
//Biz_Bsc_Kpi_Info objMBO = new Biz_Bsc_Kpi_Info();
//if (objMBO.DeleteMboToKpi(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
// , objList
// , gUserInfo.Emp_Ref_ID))
//{
// DoBindingDept();
// DoBindingDeptMBO();
// DoBinding();
// ltrScript.Text = JSHelper.GetAlertScript("삭제를 완료하였습니다.");
//}
//else
// ltrScript.Text = JSHelper.GetAlertScript("삭제가 실패하였습니다.");
string kpi_ref_id_list = string.Empty;
for (int i = 0; i < ugrdMBO.Rows.Count; i++)
{
UltraGridRow row = ugrdMBO.Rows[i];
//CheckBox chkCheck;
TemplatedColumn Col_Check = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
CheckBox chkCheck = (CheckBox)((CellItem)Col_Check.CellItems[row.BandIndex]).FindControl("cBox");
string app_status = DataTypeUtility.GetValue(row.Cells.FromKey("APPROVAL_STATUS").Value);
if (chkCheck.Checked)
{
if (!app_status.Equals("Y"))
{
kpi_ref_id_list += ";" + DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_REF_ID").Value);
}
}
}
if (kpi_ref_id_list.Length > 0)
{
kpi_ref_id_list = kpi_ref_id_list.Remove(0, 1);
}
string[] kpiRefIdList = kpi_ref_id_list.Split(';');
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();
string okMsg = bizBscKpiInfo.RemoveMboToKpi_DB(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, kpiRefIdList);
if (okMsg.Equals(""))
{
DoBindingDept();
DoBindingDeptMBO();
DoBinding();
ltrScript.Text = JSHelper.GetAlertScript("삭제를 완료하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("삭제가 실패하였습니다.");
}
}
protected void iBtnSave_Click(object sender, ImageClickEventArgs e)
{
object[] objList = GetSelectKpiList(UltraWebGrid2);
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
DataSet dsYear = objTerm.GetTermDetail(ESTTERM_REF_ID);
if (dsYear.Tables[0].Rows.Count < 1)
{
ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요.");
return;
}
string result_measurement_step = "LV5";
MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info bizComCodeInfo = new MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info();
DataTable dtComCodeInfo = bizComCodeInfo.getCheckStep(0).Tables[0];
DataRow[] rows = dtComCodeInfo.Select(" USE_YN = 'Y' ", "SORT_ORDER DESC");
if (rows.Length > 0)
{
result_measurement_step = DataTypeUtility.GetValue(rows[0]["ETC_CODE"]);
}
int unit_type_ref_id = 1;
MicroBSC.Biz.Common.Biz.Biz_Com_Unit_Type_Info bizComUnitTypeInfo = new MicroBSC.Biz.Common.Biz.Biz_Com_Unit_Type_Info();
DataTable dtComUnitTypeInfo = bizComUnitTypeInfo.GetAllList().Tables[0];
if (dtComUnitTypeInfo.Rows.Count > 0)
{
unit_type_ref_id = DataTypeUtility.GetToInt32(dtComUnitTypeInfo.Rows[0]["UNIT_TYPE_REF_ID"]);
}
Biz_Bsc_Threshold_Step bizBscThresholdStep = new Biz_Bsc_Threshold_Step();
DataTable dtBscThresholdStep = bizBscThresholdStep.GetThresholdLevelList(result_measurement_step).Tables[0];
int checkCount = 0;
for (int i = 0; i < objList.Length; i++)
{
checkCount += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiInfoExsistCheckPerson(int.Parse(objList[i].ToString()), gUserInfo.Emp_Ref_ID, ESTTERM_REF_ID);
}
if (checkCount > 0)
{
Response.Write("<script>alert('중복되는 KPI 풀입니다.');</script>");
}
else
{
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();
string returnStr = bizBscKpiInfo.CopyKpiToMboUsingTemplete(ESTTERM_REF_ID
, objList
, TEMPLETE_ID
, TEMPLETE_NAME
, gUserInfo.Emp_Ref_ID
, DateTime.Now.ToString("yyyy-MM-dd")
, result_measurement_step
, unit_type_ref_id
, "PRS"
, dtBscThresholdStep);
if (returnStr.Equals(string.Empty))
{
DoBindingTemplete();
ltrScript.Text = JSHelper.GetAlertOpenerReflashScript("복사를 완료하였습니다.", true);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(returnStr);
}
}
}
