private void GridBinding(int comp_id) { if (CheckParam() == false) { ltrScript.Text = JSHelper.GetAlertScript("평가정보나 평가방법이 설정되지 않았습니다."); return; } Biz_ScaleInfos scaleInfo = new Biz_ScaleInfos(); DataTable dtScale = scaleInfo.GetScaleInfos(comp_id).Tables[0]; _dwScale = dtScale.DefaultView; _dwScale.Sort = "SCALE_ID"; Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); _dtEstScale = deptEstDetail.GetDeptEstDetail(comp_id, ESTTERM_REF_ID, 0, EST_ID).Tables[0]; UltraWebGrid1.Clear(); UltraWebGrid1.DataSource = BizUtility.GetDeptTree(" "); UltraWebGrid1.DataBind(); EstJobUtility.SetConfirmButtonVisible(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , EST_JOB_ID , ibnConfirm , ibnConfirmCancel); }
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e) { Biz_DeptEstDetails biz = new Biz_DeptEstDetails(); DS_DETAIL = biz.GetDeptEstDetail(COMP_ID , ESTTERM_REF_ID , DataTypeUtility.GetToInt32(TreeView1.SelectedNode.Value) , ""); BindMap(); }
private void GridBinding2(int comp_id, int estterm_ref_id, string est_id) { Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); _dtEstScale = deptEstDetail.GetDeptEstDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0]; Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales(); _dtPosScale = deptPosScale.GetDeptPosScale(comp_id, estterm_ref_id, 0, est_id).Tables[0]; UltraWebGrid2.Clear(); UltraWebGrid2.DataSource = BizUtility.GetDeptTree(" "); UltraWebGrid2.DataBind(); }
private void SaveScaleData(string scale_id) { Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); DropDownList ddlScaleID; UltraGridRow row; TemplatedColumn col; DataTable dtEstDeptScale = deptEstDetail.GetDataTableSchema(); DataRow drEstDeptScale = null; for (int i = 0; i < UltraWebGrid1.Rows.Count; i++) { row = UltraWebGrid1.Rows[i]; col = (TemplatedColumn)row.Band.Columns.FromKey("SCALE_ID"); ddlScaleID = (DropDownList)((CellItem)col.CellItems[row.BandIndex]).FindControl("ddlScaleID"); drEstDeptScale = dtEstDeptScale.NewRow(); drEstDeptScale["COMP_ID"] = COMP_ID; drEstDeptScale["ESTTERM_REF_ID"] = ESTTERM_REF_ID; drEstDeptScale["DEPT_REF_ID"] = row.Cells.FromKey("DEPT_REF_ID").Value; drEstDeptScale["EST_ID"] = EST_ID; drEstDeptScale["DATE"] = DateTime.Now; drEstDeptScale["USER"] = EMP_REF_ID; if (scale_id.Equals("")) { drEstDeptScale["SCALE_ID"] = WebUtility.GetByValueDropDownList(ddlScaleID); } else { drEstDeptScale["SCALE_ID"] = scale_id; } dtEstDeptScale.Rows.Add(drEstDeptScale); } bool isOK = deptEstDetail.SaveDeptEstWidthScale(dtEstDeptScale); if (isOK) { GridBinding(COMP_ID); ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("저장 중 오류가 발생하였습니다."); } }
private void SaveWeightData(string weight) { Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); TextBox txtWeight; UltraGridRow row; TemplatedColumn col; DataTable dtEstDept = deptEstDetail.GetDataTableSchema(); DataRow drEstDept = null; for (int i = 0; i < UltraWebGrid1.Rows.Count; i++) { row = UltraWebGrid1.Rows[i]; col = (TemplatedColumn)row.Band.Columns.FromKey("TXT_WEIGHT"); txtWeight = (TextBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("txtWeightDept"); drEstDept = dtEstDept.NewRow(); drEstDept["COMP_ID"] = COMP_ID; drEstDept["ESTTERM_REF_ID"] = ESTTERM_REF_ID; drEstDept["DEPT_REF_ID"] = row.Cells.FromKey("DEPT_REF_ID").Value; drEstDept["EST_ID"] = EST_ID; drEstDept["DATE"] = DateTime.Now; drEstDept["USER"] = EMP_REF_ID; if (weight.Length == 0) { drEstDept["WEIGHT"] = txtWeight.Text.Trim(); } else { drEstDept["WEIGHT"] = weight; } dtEstDept.Rows.Add(drEstDept); } bool isOK = deptEstDetail.SaveDeptEstWithWeight(dtEstDept); if (isOK) { GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID); ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("저장 중 오류가 발생하였습니다."); } }
protected void lbnSaveDPT_Click(object sender, EventArgs e) { Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); DataTable dtEstDeptScale = deptEstDetail.GetDataTableSchema(); DataRow drEstDeptScale = null; string[] dept_values = hdfDeptID.Value.Split(','); foreach (string dept_value in dept_values) { drEstDeptScale = dtEstDeptScale.NewRow(); drEstDeptScale["COMP_ID"] = COMP_ID; drEstDeptScale["ESTTERM_REF_ID"] = ESTTERM_REF_ID; drEstDeptScale["DEPT_REF_ID"] = DataTypeUtility.GetToInt32(dept_value); drEstDeptScale["EST_ID"] = EST_ID; drEstDeptScale["DATE"] = DateTime.Now; drEstDeptScale["USER"] = EMP_REF_ID; drEstDeptScale["SCALE_ID"] = WebUtility.GetByValueDropDownList(ddlScaleIDAll); dtEstDeptScale.Rows.Add(drEstDeptScale); } bool isOK = deptEstDetail.SaveDeptEstWidthScale(dtEstDeptScale); if (isOK) { GridBinding(COMP_ID); ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다."); hdfDeptID.Value = ""; } else { ltrScript.Text = JSHelper.GetAlertScript("저장 중 오류가 발생하였습니다."); } }
protected void lbnSaveDPT_Click(object sender, EventArgs e) { Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); DataTable dtEstDept = deptEstDetail.GetDataTableSchema(); DataRow drEstDept = null; string[] dept_values = hdfDeptID.Value.Split(','); foreach (string dept_value in dept_values) { drEstDept = dtEstDept.NewRow(); drEstDept["COMP_ID"] = COMP_ID; drEstDept["ESTTERM_REF_ID"] = ESTTERM_REF_ID; drEstDept["DEPT_REF_ID"] = DataTypeUtility.GetToInt32(dept_value); drEstDept["EST_ID"] = EST_ID; drEstDept["DATE"] = DateTime.Now; drEstDept["USER"] = EMP_REF_ID; drEstDept["WEIGHT"] = txtWeightAll.Text.Trim(); dtEstDept.Rows.Add(drEstDept); } bool isOK = deptEstDetail.SaveDeptEstWithWeight(dtEstDept); if (isOK) { GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID); ltrScript.Text = JSHelper.GetAlertScript("선택된 부서의 가중치를 일괄 적용하였습니다."); hdfDeptID.Value = ""; } else { ltrScript.Text = JSHelper.GetAlertScript("저장 중 오류가 발생하였습니다."); } }
/// <summary> /// 그리드 바인딩 메소드 /// </summary> /// <param name="comp_id"></param> /// <param name="est_id"></param> /// <param name="estterm_ref_id"></param> /// <param name="estterm_sub_id"></param> /// <param name="estterm_step_id"></param> private void GridBidingData(int comp_id , string est_id , int estterm_ref_id , int estterm_sub_id , int estterm_step_id) { Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id); if (!estInfo.IsExists(comp_id, est_id)) { return; } // 만약 주기가 년간일 경우 if (YEAR_YN.Equals("Y")) { ESTTERM_SUB_ID = BizUtility.GetEstTermSubIDByYearYN(COMP_ID); } // 만약 차수가 합산일 경우 if (MERGE_YN.Equals("Y")) { ESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID); } if (estInfo.Owner_Type != null && estInfo.Owner_Type.Equals("D")) { OwnerTypeMode = OwnerType.Dept; } else { OwnerTypeMode = OwnerType.Emp_User; } //if (estInfo.Owner_Type.Equals("D")) // OwnerTypeMode = OwnerType.Dept; //else // OwnerTypeMode = OwnerType.Emp_User; ScaleTypeMode = estInfo.Scale_Type; WeightTypeMode = estInfo.Weight_Type; if (estInfo.Bias_YN.Equals("Y")) { BiasYN = YesNo.Yes; } else { BiasYN = YesNo.No; } if (estInfo.Grade_Confirm_YN.Equals("Y")) { GradeConfirmYN = YesNo.Yes; } else { GradeConfirmYN = YesNo.No; } Biz_Datas est_data = new Biz_Datas(); int est_emp_id = 0;; int tgt_dept_id = 0; int tgt_emp_id = 0; if (OwnerTypeMode == OwnerType.Dept && DEPT_COLUMN_NO_USE_YN.Equals("Y")) { OwnerTypeMode = OwnerType.Emp_User; } else if (OwnerTypeMode == OwnerType.Emp_User && DEPT_COLUMN_NO_USE_YN.Equals("Y")) { OwnerTypeMode = OwnerType.Dept; } if (OwnerTypeMode == OwnerType.Dept) { if (EST_TGT_TYPE.Equals("EST")) { est_emp_id = 0; tgt_dept_id = TGT_DEPT_ID; tgt_emp_id = -1; } else if (EST_TGT_TYPE.Equals("TGT")) { est_emp_id = 0; tgt_dept_id = TGT_DEPT_ID; tgt_emp_id = -1; } } else if (OwnerTypeMode == OwnerType.Emp_User) { if (EST_TGT_TYPE.Equals("EST")) { est_emp_id = 0; tgt_dept_id = 0; tgt_emp_id = TGT_EMP_ID; } else if (EST_TGT_TYPE.Equals("TGT")) { est_emp_id = 0; tgt_dept_id = 0; tgt_emp_id = TGT_EMP_ID; } } DT_EST_DATA = est_data.GetEstData(comp_id , est_id , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , 0 , est_emp_id , tgt_dept_id , tgt_emp_id , YEAR_YN , MERGE_YN , OwnerTypeMode).Tables[0]; // 조회된 데이터가 존재할 경우 if (DT_EST_DATA != null) { // 만약 가중치 보이기 Y 일때 if (COL_WEIGHT_VISIBLE_YN.Equals("Y")) { //2012.01.16 박효동 : 하위평가를 가져오니 문제가 있어서 수정 // - MBO의 하위평가를 가져오도록 평가컬럼설정이 되있는데 현재는 현재평가의 하위차수를 가져오니 안나오더라 // - 해서 평가컬럼설정에 등록되어있는 POINT_평가아이디에 해당하는 평가아이디를 가져오도록 수정 휴~~ // 하위평가 정보를 가지고 온다. //DataTable _dtEstID = estInfo.GetEstInfoByUpEstID(comp_id, est_id).Tables[0]; DataTable _dtEstID = estInfo.GetEstInfoByUpEstID(comp_id, est_id).Tables[0]; _dtEstID.Rows.Clear(); Biz_ColumnInfos colInfo = new Biz_ColumnInfos(); DataTable dtEstID = colInfo.GetColumnInfo(COMP_ID, EST_ID).Tables[0]; foreach (DataRow dr in dtEstID.Rows) { string colnames = dr[6].ToString(); if (colnames.Length > 5) { if (colnames.Substring(0, 6) == "POINT_" && colnames.Length == 8) { DataRow insertDR = _dtEstID.NewRow(); insertDR["EST_ID"] = colnames.Remove(0, 6); _dtEstID.Rows.Add(insertDR); insertDR = null; } } } foreach (DataRow dataRow in _dtEstID.Rows) { DT_EST_DATA.Columns.Add(string.Format("WEIGHT_{0}", dataRow["EST_ID"]), typeof(double)); // 평가별 점수 보이기 여부에 따라 if (COL_POINT_VISIBLE_YN.Equals("Y")) { DT_EST_DATA.Columns.Add(string.Format("POINT_{0}", dataRow["EST_ID"]), typeof(double)); DataTable dtEstData = est_data.GetData(comp_id , dataRow["EST_ID"].ToString() , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , 0 , est_emp_id , tgt_dept_id , tgt_emp_id , YEAR_YN , MERGE_YN , OwnerTypeMode).Tables[0]; foreach (DataRow drEstData in dtEstData.Rows) { DataRow[] drArrEstData = DT_EST_DATA.Select(string.Format(@"ESTTERM_REF_ID = {0} AND ESTTERM_SUB_ID = {1} AND ESTTERM_STEP_ID = {2} AND TGT_DEPT_ID = {3} AND TGT_EMP_ID = {4}" , drEstData["ESTTERM_REF_ID"] , drEstData["ESTTERM_SUB_ID"] , drEstData["ESTTERM_STEP_ID"] , drEstData["TGT_DEPT_ID"] , drEstData["TGT_EMP_ID"])); if (drArrEstData.Length > 0) { drArrEstData[0][string.Format("POINT_{0}", dataRow["EST_ID"])] = drEstData["POINT"]; } } } } } // 등급 컬럼 보이기가 Y 일경우 (이건 DT_EST_DATA 과 관계 없음) if (COL_GRADE_VISIBLE_YN.Equals("Y") || COL_GRADE_TO_POINT_VISIBLE_YN.Equals("Y")) { Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); DT_DEPT_SCALE = deptEstDetail.GetDeptEstDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0]; Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales(); DT_POS_SCALE = deptPosScale.GetDeptPosScale(comp_id, estterm_ref_id, 0, est_id).Tables[0]; Biz_Scopes scope = new Biz_Scopes(); DT_SCOPE = scope.GetScope(comp_id, est_id).Tables[0]; DT_EST_DATA.Columns.Add("RANK", typeof(double)); DT_EST_DATA.Columns.Add("SCALE_ID", typeof(string)); DT_EST_DATA.Columns.Add("SCALE_NAME", typeof(string)); DT_EST_DATA.Columns.Add("GRADE_CALC_ID", typeof(string)); } if (COL_ESTTERM_SUB_AGG_VISIBLE_YN.Equals("Y")) { } if (COL_ESTTERM_STEP_AGG_VISIBLE_YN.Equals("Y")) { } if (COL_CTRL_POINT_VISIBLE_YN.Equals("Y") || COL_CTRL_GRADE_VISIBLE_YN.Equals("Y")) { Biz_CtrlEstMaps ctrlEstDeptMap = new Biz_CtrlEstMaps(); DT_CTRL_INFO = ctrlEstDeptMap.GetCtrlInfoByEstID(COMP_ID, EST_ID).Tables[0]; DT_CTRL_EST_DEPT_MAP = ctrlEstDeptMap.GetCtrlEstDeptByEstID(COMP_ID, EST_ID).Tables[0]; if (COL_CTRL_POINT_VISIBLE_YN.Equals("Y")) { Biz_CtrlPointDatas ctrlPointData = new Biz_CtrlPointDatas(); DT_CTRL_POINT_DATA = ctrlPointData.GetCtrlPointData(comp_id , est_id , estterm_ref_id , estterm_sub_id , estterm_step_id , 0 , 0 , 0 , 0).Tables[0]; } if (COL_CTRL_GRADE_VISIBLE_YN.Equals("Y")) { Biz_CtrlGradeDatas ctrlGradeData = new Biz_CtrlGradeDatas(); DT_CTRL_GRADE_DATA = ctrlGradeData.GetCtrlGradeData(comp_id , est_id , estterm_ref_id , estterm_sub_id , estterm_step_id , 0 , 0 , 0 , 0).Tables[0]; } } UltraWebGrid1.Clear(); UltraWebGrid1.DataSource = DT_EST_DATA; UltraWebGrid1.DataBind(); } }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { UltraGridUtility.CreateColumns((UltraWebGrid)sender , COMP_ID , EST_ID , DEFAULT_INDEX_COUNT , out DT_COLUMN_INFO , (OwnerTypeMode == OwnerType.Dept) ? "D" : "P" , EST_JOB_IDS.Split(',') , DEPT_COLUMN_NO_USE_YN); if (e.Layout.Bands[0].Columns.Exists("selchk")) { if (!e.Layout.Bands[0].Columns.FromKey("selchk").Hidden) { e.Layout.Bands[0].Columns.FromKey("selchk").Hidden = true; } } // 가중치 컬럼을 사용할 경우 if (COL_WEIGHT_VISIBLE_YN.Equals("Y") || COL_GRADE_VISIBLE_YN.Equals("Y")) { Biz_DeptEstDetails deptEstDetail = null; Biz_DeptPosDetails deptPosDetail = null; DataTable dtDeptDetail = null; DataRow[] drArrColumn = DT_COLUMN_INFO.Select(@"COL_STYLE_ID = 'BIZ' AND VISIBLE_YN = 'Y'"); foreach (DataRow drColumn in drArrColumn) { if (drColumn["COL_KEY"].ToString().IndexOf("WEIGHT_") < 0) { continue; } string est_id = drColumn["COL_KEY"].ToString().Replace("WEIGHT_", ""); Biz_EstInfos estSubInfo = new Biz_EstInfos(COMP_ID, est_id); if (estSubInfo.Weight_Type != null && estSubInfo.Weight_Type.Equals("DPT")) { deptEstDetail = new Biz_DeptEstDetails(); dtDeptDetail = deptEstDetail.GetDeptEstDetail(COMP_ID, ESTTERM_REF_ID, 0, est_id).Tables[0]; } else if (estSubInfo.Weight_Type != null && estSubInfo.Weight_Type.Equals("POS")) { deptPosDetail = new Biz_DeptPosDetails(); dtDeptDetail = deptPosDetail.GetDeptPosDetail(COMP_ID, ESTTERM_REF_ID, 0, est_id).Tables[0]; } if (DT_DEPT_EST_POS_DETAIL == null) { DT_DEPT_EST_POS_DETAIL = dtDeptDetail; } else { DT_DEPT_EST_POS_DETAIL.Merge(dtDeptDetail); } } } e.Layout.ClientSideEvents.MouseOverHandler = RPT_DTL_ID + e.Layout.ClientSideEvents.MouseOverHandler; e.Layout.ClientSideEvents.DblClickHandler = RPT_DTL_ID + e.Layout.ClientSideEvents.DblClickHandler; }
protected void ibnSave_Click(object sender, ImageClickEventArgs e) { if (ESTTERM_REF_ID_FROM == ESTTERM_REF_ID_TO && ESTTERM_SUB_ID_FROM == ESTTERM_SUB_ID_TO) { ltrScript.Text = JSHelper.GetAlertScript("기준대상과 피참조대상의 기간이 같습니다. 다시 설정하세요."); return; } bool isOK = false; if (TYPE.Equals("1")) { if (ESTTERM_REF_ID_FROM == ESTTERM_REF_ID_TO) { ltrScript.Text = JSHelper.GetAlertScript("기준대상과 피참조대상의 기간이 같습니다. 다시 설정하세요."); return; } Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales(); isOK = deptEstDetail.CopyDataFromTo(COMP_ID , ESTTERM_REF_ID_FROM , ESTTERM_REF_ID_TO , DateTime.Now , EMP_REF_ID); if (isOK) { deptPosScale.CopyDataFromTo(COMP_ID , ESTTERM_REF_ID_FROM , ESTTERM_REF_ID_TO , DateTime.Now , EMP_REF_ID); } } else if (TYPE.Equals("2")) { if (ESTTERM_REF_ID_FROM == ESTTERM_REF_ID_TO) { ltrScript.Text = JSHelper.GetAlertScript("기준대상과 피참조대상의 기간이 같습니다. 다시 설정하세요."); return; } Biz_DeptPosDetails deptPosScale = new Biz_DeptPosDetails(); isOK = deptPosScale.CopyDataFromTo(COMP_ID , ESTTERM_REF_ID_FROM , ESTTERM_REF_ID_TO , DateTime.Now , EMP_REF_ID); } else if (TYPE.Equals("3")) { if (ESTTERM_REF_ID_FROM == ESTTERM_REF_ID_TO) { ltrScript.Text = JSHelper.GetAlertScript("기준대상과 피참조대상의 기간이 같습니다. 다시 설정하세요."); return; } Biz_RelGroupInfos relGroupInfo = new Biz_RelGroupInfos(); isOK = relGroupInfo.CopyDataFromTo(COMP_ID , ESTTERM_REF_ID_FROM , ESTTERM_REF_ID_TO , DateTime.Now , EMP_REF_ID); } else if (TYPE.Equals("4")) { Biz_EmpEstTargetMaps empEstTgtMap = new Biz_EmpEstTargetMaps(); isOK = empEstTgtMap.CopyDataFromTo(COMP_ID , "" , ESTTERM_REF_ID_FROM , ESTTERM_SUB_ID_FROM , ESTTERM_STEP_ID_FROM , ESTTERM_REF_ID_TO , ESTTERM_SUB_ID_TO , ESTTERM_STEP_ID_TO , DateTime.Now , EMP_REF_ID); } else if (TYPE.Equals("5")) { if (ESTTERM_REF_ID_FROM == ESTTERM_REF_ID_TO && ESTTERM_SUB_ID_FROM == ESTTERM_SUB_ID_TO) { ltrScript.Text = JSHelper.GetAlertScript("기준대상과 피참조대상의 기간이 같습니다. 다시 설정하세요."); return; } Biz_QuestionDeptEmpMaps questionDeptEmp = new Biz_QuestionDeptEmpMaps(); isOK = questionDeptEmp.CopyEstDataFromTo(COMP_ID , ESTTERM_REF_ID_FROM , ESTTERM_SUB_ID_FROM , ESTTERM_REF_ID_TO , ESTTERM_SUB_ID_TO , DateTime.Now , EMP_REF_ID); } if (isOK) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 데이터가 참조되었습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("참조 중 오류가 발생하였습니다."); } }