// 점수그래프 적용하기
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>";
}
}
