public void SetKpiListExceptMine() { int iTxrUser = gUserInfo.Emp_Ref_ID; int iComDeptId = 0; Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight(); // 나의지표 : 구분 -> N 부서코드 -> 0 // 팀 지표 : 구분 -> Y 부서코드 -> 로그인사용자 부서 // 전체 : 구분 -> '' 부서코드 -> 0 if (PageUtility.GetByValueDropDownList(ddlGubun) == "Y" || PageUtility.GetByValueDropDownList(ddlGubun) == "" || PageUtility.GetByValueDropDownList(ddlGubun) == "P") { iComDeptId = BizUtility.GetDeptID(gUserInfo.Emp_Ref_ID); } DataSet rDS = objBSC.GetMboListForWeight(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo) , PageUtility.GetByValueDropDownList(ddlGubun) , txtKpiCode.Text.Trim() , txtKpiName.Text.Trim() , gUserInfo.Emp_Ref_ID , iComDeptId); ugrdKpiList.Clear(); ugrdKpiList.DataSource = rDS; ugrdKpiList.DataBind(); }
public void setKpiData() { if (ddlEstTermInfo.Items.Count < 1) { PageUtility.AlertMessage("등록된 평가기간이 없습니다."); return; } Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight(); objBSC.IEmp_Ref_Id = (User.IsInRole(ROLE_ADMIN)) ? 0 : EMP_REF_ID; DataSet ds = objBSC.GetMyKpiList (PageUtility.GetIntByValueDropDownList(ddlEstTermInfo) , objBSC.IEmp_Ref_Id , "" , txtKPICode.Text , txtKPIName.Text , "Y" , txtChamName.Text , PageUtility.GetByValueDropDownList(ddlKpiGroupRefID) , PageUtility.GetIntByValueDropDownList(ddlEstDept)); ugrdKpiList.Clear(); ugrdKpiList.DataSource = ds; ugrdKpiList.DataBind(); lblCountRow.Text = "Total Rows : " + ds.Tables[0].Rows.Count.ToString(); }
public void SetMyKpiList() { Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight(); DataSet rDs = objBSC.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), gUserInfo.Emp_Ref_ID); ugrdChildKpi.Clear(); ugrdChildKpi.DataSource = rDs; ugrdChildKpi.DataBind(); }
public void SetMyKpiList() { Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight(); DataSet rDs = objBSC.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), gUserInfo.Emp_Ref_ID); ugrdChildKpi.Clear(); ugrdChildKpi.DataSource = rDs; ugrdChildKpi.DataBind(); object[,] objRtn = objBSC.GetMboApprovalState(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), gUserInfo.Emp_Ref_ID); if (objRtn != null) { switch (objRtn[0, 0].ToString()) { case "": // 결재상태 없음 addKpi.Visible = remKpi.Visible = udtKpi.Visible = true; break; case Biz_Type.app_status_nodraft: // 결재상태 없음 addKpi.Visible = remKpi.Visible = udtKpi.Visible = true; break; case Biz_Type.app_status_draft: // 상신 addKpi.Visible = remKpi.Visible = udtKpi.Visible = false; break; case Biz_Type.app_status_ondraft: // 결재중 addKpi.Visible = remKpi.Visible = udtKpi.Visible = false; break; case Biz_Type.app_status_return: // 반려 addKpi.Visible = remKpi.Visible = udtKpi.Visible = true; break; case Biz_Type.app_status_recall: // 결재회수 addKpi.Visible = remKpi.Visible = udtKpi.Visible = true; break; case Biz_Type.app_status_onmodify: // 수정결재 addKpi.Visible = remKpi.Visible = udtKpi.Visible = true; break; case Biz_Type.app_status_complete: // 결재완료 addKpi.Visible = remKpi.Visible = udtKpi.Visible = false; break; default: addKpi.Visible = remKpi.Visible = udtKpi.Visible = false; break; } } lblRowCount.Text = " " + ugrdChildKpi.Rows.Count.ToString() + " "; }
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 SetKpiListExceptMine() { int iTxrUser = gUserInfo.Emp_Ref_ID; int iComDeptId = 0; Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight(); // 팀원이 속한 MBO지표 : 구분 -> N 부서코드 -> 로그인사용자 부서 // 나의지표 : 구분 -> N 부서코드 -> 0 // 팀 지표 : 구분 -> Y 부서코드 -> 로그인사용자 부서 // 전체 : 구분 -> '' 부서코드 -> 0 if (PageUtility.GetByValueDropDownList(ddlGubun) == "Y" || PageUtility.GetByValueDropDownList(ddlGubun) == "H") { iComDeptId = BizUtility.GetDeptID(gUserInfo.Emp_Ref_ID); } string gubun = PageUtility.GetByValueDropDownList(ddlGubun); if (gubun.Equals("H")) { gubun = "N"; } DataSet rDs = objBSC.GetKpiListExceptMyKpi (PageUtility.GetIntByValueDropDownList(ddlEstTermInfo) , iTxrUser , "" , txtKpiCode.Text , txtKpiName.Text , "Y" , "" , iComDeptId , "" , gubun , iTxrUser); ugrdKpiList.Clear(); ugrdKpiList.DataSource = rDs; ugrdKpiList.DataBind(); }
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 intRtn = 0; int cntRow = 0; Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight(); 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) { try { if (iType == "ADD") { intRtn += objBSC.UpdateData (int.Parse(row.Cells.FromKey("ESTTERM_REF_ID").Value.ToString()) , itxr_user , int.Parse(row.Cells.FromKey("KPI_REF_ID").Value.ToString()) , 0 , "Y" , itxr_user); } else if (iType == "SET") { intRtn += objBSC.UpdateData (int.Parse(row.Cells.FromKey("ESTTERM_REF_ID").Value.ToString()) , itxr_user , int.Parse(row.Cells.FromKey("KPI_REF_ID").Value.ToString()) , decimal.Parse(row.Cells.FromKey("WEIGHT").Value.ToString()) , "Y" , itxr_user); } else if (iType == "DEL") { intRtn += objBSC.DeleteData (int.Parse(row.Cells.FromKey("ESTTERM_REF_ID").Value.ToString()) , int.Parse(row.Cells.FromKey("EMP_REF_ID").Value.ToString()) , int.Parse(row.Cells.FromKey("KPI_REF_ID").Value.ToString()) , itxr_user); } } catch (Exception ex) { PageUtility.AlertMessage(ex.Message); return; } cntRow += 1; } } if (cntRow < 1) { PageUtility.AlertMessage("항목을 선택하세요."); } else { this.SetMyKpiList(); this.SetKpiListExceptMine(); } }
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("삭제하였습니다."); } }
private void DoBinding() { if (ddlEstTerm.Items.Count < 1) { ltrScript.Text = JSHelper.GetAlertScript("등록된 평가기간이 없습니다."); return; } //가중치 Biz_Bsc_Mbo_Kpi_Weight objBSC_weight = new Biz_Bsc_Mbo_Kpi_Weight(); DT_KPI_WEIGHT = objBSC_weight.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTerm), gUserInfo.Emp_Ref_ID).Tables[0]; //월별 실적 Biz_Bsc_Kpi_Info objBSC = new Biz_Bsc_Kpi_Info(); DataSet dsMonthlyTarget = objBSC.GetMBOForWeight(PageUtility.GetIntByValueDropDownList(ddlEstTerm) , txtKpiCodeRight.Text.Trim() , txtKpiNameRight.Text.Trim() , txtChampionNameRight.Text.Trim() , (ddlComDeptRight.SelectedItem.Value == "" ? 0 : PageUtility.GetIntByValueDropDownList(ddlComDeptRight)) , PageUtility.GetByValueDropDownList(ddlKpiGroup) , ""//MBO_TYPE , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryTop) , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryMid) , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryLow) , gUserInfo.Emp_Ref_ID , User.IsInRole(ROLE_ADMIN)); //KPI목록 DataSet ds = objBSC.GetMBOForDeptKpi(PageUtility.GetIntByValueDropDownList(ddlEstTerm) , txtKpiCodeRight.Text.Trim() , txtKpiNameRight.Text.Trim() , txtChampionNameRight.Text.Trim() , PageUtility.GetByValueDropDownList(ddlKpiGroup) , (ddlComDeptRight.SelectedItem.Value == "" ? 0 : PageUtility.GetIntByValueDropDownList(ddlComDeptRight)) , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryTop) , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryMid) , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryLow) , gUserInfo.Emp_Ref_ID , (User.IsInRole(ROLE_ADMIN) == true ? 1 : 0) , this.IDEPT_ID); DataTable dt = addMonthlyTarget(dsMonthlyTarget.Tables[0], ds.Tables[0]); ugrdMBO.Clear(); ugrdMBO.DataSource = dt; ugrdMBO.DataBind(); int cntApprovalStatus = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["USE_YN"].ToString().Equals("Y")) { if (ds.Tables[0].Rows[i]["APPROVAL_STATUS"].ToString().Equals("N")) { cntApprovalStatus++; } } } if (cntApprovalStatus == 0) { DRAFT_BTN_VISIBLE = true; } else { DRAFT_BTN_VISIBLE = false; } double weight = 0; double tmp; for (int i = 0; i < ugrdMBO.Rows.Count; i++) { tmp = DataTypeUtility.GetToDouble(ugrdMBO.Rows[i].Cells.FromKey("WEIGHT").Value); if (DataTypeUtility.GetString(ugrdMBO.Rows[i].Cells.FromKey("USE_YN").Value).Equals("N")) { continue; } if (tmp == (double)0) { weight = 0; break; } weight += DataTypeUtility.GetToDouble(ugrdMBO.Rows[i].Cells.FromKey("WEIGHT").Value); } if (weight != (double)100) { DRAFT_BTN_VISIBLE = false; } if (ds.Tables[0].Rows.Count == 0) { iBtnDraft.Visible = iBtnMoDraft.Visible = iBtnReDraft.Visible = iBtnReWrite.Visible = iBtnReqModify.Visible = false; } this.lblRowCnt.Text = ugrdMBO.Rows.Count.ToString(); DataTable dtWeightApproval = objBSC.GetMBOForWeight_Approval(PageUtility.GetIntByValueDropDownList(ddlEstTerm) , gUserInfo.Emp_Ref_ID).Tables[0]; if (dtWeightApproval.Rows.Count == 0) { this.IAPP_STATUS = ""; this.IAPP_REF_ID = "0"; } else { this.IAPP_STATUS = dtWeightApproval.Rows[0]["APP_STATUS"].ToString(); this.IAPP_REF_ID = dtWeightApproval.Rows[0]["APP_REF_ID"].ToString(); } string strImg = (this.IAPP_STATUS == "") ? "" : this.IAPP_STATUS; imgApprovalStatus.Src = Biz_Com_Approval_Info.GetAppImageUrl(strImg); imgApprovalStatus.Alt = Biz_Com_Approval_Info.GetAppImageText(strImg); if (IAPP_STATUS.Length > 0) { this.strApprovalStatus.Text = DataTypeUtility.GetString(dtWeightApproval.Rows[0]["APP_STATUS_NAME"]); } switch (this.IAPP_STATUS) { case "": // 결재상태 없음 iBtnDraft.Visible = DRAFT_BTN_VISIBLE; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReWrite.Visible = false; iBtnReqModify.Visible = false; break; case Biz_Type.app_status_nodraft: // 결재상태 없음 iBtnDraft.Visible = DRAFT_BTN_VISIBLE; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReWrite.Visible = false; iBtnReqModify.Visible = false; break; case Biz_Type.app_status_draft: // 상신 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReWrite.Visible = false; iBtnReqModify.Visible = false; imgApprovalStatus.Src = "../images/draft/sta_dft.gif"; setVisibleForDraft(false); break; case Biz_Type.app_status_ondraft: // 결재중 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReWrite.Visible = false; iBtnReqModify.Visible = false; imgApprovalStatus.Src = "../images/draft/sta_oft.gif"; setVisibleForDraft(false); break; case Biz_Type.app_status_return: // 반려 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = DRAFT_BTN_VISIBLE; iBtnReWrite.Visible = false; iBtnReqModify.Visible = false; imgApprovalStatus.Src = "../images/draft/sta_rft.gif"; setVisibleForDraft(true); break; case Biz_Type.app_status_recall: // 결재회수 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReWrite.Visible = DRAFT_BTN_VISIBLE; iBtnReqModify.Visible = false; imgApprovalStatus.Src = "../images/draft/sta_aft.gif"; setVisibleForDraft(true); break; case Biz_Type.app_status_onmodify: // 수정결재 iBtnDraft.Visible = false; iBtnMoDraft.Visible = DRAFT_BTN_VISIBLE; iBtnReDraft.Visible = false; iBtnReWrite.Visible = false; iBtnReqModify.Visible = false; imgApprovalStatus.Src = "../images/draft/sta_mft.gif"; setVisibleForDraft(true); break; case Biz_Type.app_status_complete: // 결재완료 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReWrite.Visible = false; iBtnReqModify.Visible = DRAFT_BTN_VISIBLE; iBtnReqModify.Visible = true; imgApprovalStatus.Src = "../images/draft/sta_cft.gif"; setVisibleForDraft(false); break; default: iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReqModify.Visible = false; iBtnReWrite.Visible = false; break; } }