// 점수그래프 적용하기 public static void SetPointBar(DataRowView drw , CellsCollection cells) { string column = "POINT_BAR"; if (!cells.Exists(column)) { return; } if (drw["POINT"] != DBNull.Value) { cells.FromKey(column).Value = string.Format("<img src='{0}' width='{1}%' height='8px'>" , "../images/bg/point_bar.gif" , drw["POINT"]); } }
// 상태값 이미지 적용하기 public static void SetStatusImage(DataRowView drw , CellsCollection cells) { string column = "STATUS_IMG_PATH"; if (!cells.Exists(column)) { return; } if (drw.DataView.Table.Columns.Contains(column)) { if (drw[column] == DBNull.Value) { cells.FromKey(column).Value = string.Format("<img src='{0}'>", "../images/icon/color/red.gif"); } else { cells.FromKey(column).Value = string.Format("<img src='{0}'>", drw[column]); } } }
// 등급 조정 적용하기 public static void SetCtrlGrade(DataRowView drw , CellsCollection cells , DataTable dtColumnInfo , DataTable dtCtrlInfo , DataTable dtCtrlEstDeptMap , DataTable dtCtrlGradeData , int cur_emp_id) { // 등급조정 컬럼 string column = "CTRL_GRADE"; if (!cells.Exists(column)) { return; } DataRow[] drArr = dtColumnInfo.Select(string.Format(@"COL_STYLE_ID = 'BIZ' AND VISIBLE_YN = 'Y' AND COL_KEY = '{0}'" , column)); if (drArr.Length > 0) { DataRow[] drArrCtrlGradeData = dtCtrlGradeData.Select(string.Format(@"TGT_DEPT_ID = {0} AND TGT_EMP_ID = {1}" , drw["TGT_DEPT_ID"] , drw["TGT_EMP_ID"]), "CTRL_SEQ DESC"); foreach (DataRow drData in drArrCtrlGradeData) { if (DataTypeUtility.GetValue(drData["CTRL_YN"]).Equals("Y")) { cells.FromKey(column).Value = "<b><font color='#929292'>조정확정 완료</font></b>"; return; } } DataRow[] drArrCtrlInfo = dtCtrlInfo.Select(string.Format(@"CTRL_EMP_ID = {0} AND POINT_GRADE_TYPE = 'GRD'", cur_emp_id)); // 조정정보가 존재하는지 체크 if (drArrCtrlInfo.Length > 0) { DataRow[] drArrCtrlEstDeptMap = dtCtrlEstDeptMap.Select(string.Format(@"CTRL_ID = '{0}' AND DEPT_REF_ID = {1}" , drArrCtrlInfo[0]["CTRL_ID"] , drw["TGT_DEPT_ID"])); // 조정정보에 따른 부서정보가 존재하는지 체크 if (drArrCtrlEstDeptMap.Length > 0 || DataTypeUtility.GetYNToBoolean(drArrCtrlInfo[0]["ALL_EST_DEPT_YN"].ToString()) == true) { cells.FromKey(column).Value = string.Format("<a href='#null' onclick=\"ViewCtrlPage('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}');\"><font color='#2080D0'>등급조정 가능</font></a>" , drArrCtrlInfo[0]["CTRL_ID"] , drw["COMP_ID"] , drw["EST_ID"] , drw["ESTTERM_REF_ID"] , drw["ESTTERM_SUB_ID"] , drw["ESTTERM_STEP_ID"] , drw["EST_DEPT_ID"] , drw["EST_EMP_ID"] , cur_emp_id , drw["TGT_DEPT_ID"] , drw["TGT_EMP_ID"] , "GRD"); } else { cells.FromKey(column).Value = "<font color='red'>권한부서 없음</font>"; } } else { cells.FromKey(column).Value = " ";//"<font color='red'>조정권한 없음</font>"; } } else { cells.FromKey(column).Value = "<font color='red'>컬럼정보 없음</font>"; } }