/// <summary>
/// 직급,직군 보이기 여부
/// </summary>
/// <param name="columnCollection"></param>
public static void VisiblePosColumn(ColumnsCollection columnCollection)
{
Biz_PositionInfos positionInfo = new Biz_PositionInfos();
DataTable dtPosNotUse = positionInfo.GetPositionInfoByUseYN("N").Tables[0];
foreach (DataRow dataRowPosNotUse in dtPosNotUse.Rows)
{
string col_key_id = string.Format("TGT_POS_{0}_ID", dataRowPosNotUse["POS_ID"]);
string col_key_name = string.Format("TGT_POS_{0}_NAME", dataRowPosNotUse["POS_ID"]);
string col_key_id_1 = string.Format("POS_{0}_ID", dataRowPosNotUse["POS_ID"]);
string col_key_name_1 = string.Format("POS_{0}_NAME", dataRowPosNotUse["POS_ID"]);
if (columnCollection.Exists(col_key_id))
{
columnCollection.FromKey(col_key_id).Hidden = true;
}
if (columnCollection.Exists(col_key_name))
{
columnCollection.FromKey(col_key_name).Hidden = true;
}
if (columnCollection.Exists(col_key_id_1))
{
columnCollection.FromKey(col_key_id_1).Hidden = true;
}
if (columnCollection.Exists(col_key_name_1))
{
columnCollection.FromKey(col_key_name_1).Hidden = true;
}
}
}
private void InfoGridBinding()
{
Biz_PositionInfos positionInfo = new Biz_PositionInfos();
DataSet ds = positionInfo.GetPositionInfoByUseYN("");
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
}
public static void BindPositionInfo(DropDownList ddl)
{
Biz_PositionInfos positionInfo = new Biz_PositionInfos();
DataSet ds = positionInfo.GetPositionInfoByUseYN("Y");
ddl.DataValueField = "POS_ID";
ddl.DataTextField = "POS_NAME";
ddl.DataSource = ds;
ddl.DataBind();
}
/// <summary>
/// 평가 페이지에서 EST_ID에 따라서 컬럼을 동적으로 생성한다.
/// </summary>
/// <param name="ultraWebGrid"></param>
/// <param name="est_id"></param>
/// <param name="default_index_count"></param>
/// <param name="dataTable"></param>
public static void CreateColumns(UltraWebGrid ultraWebGrid
, int comp_id
, string est_id
, int default_index_count
, out DataTable dataTable
, string owner_type
, string[] est_job_ids
, string dept_column_no_use_yn)
{
Biz_ColumnInfos columnInfo = new Biz_ColumnInfos();
Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id);
dataTable = columnInfo.GetColumnInfo(comp_id, est_id).Tables[0];
DataRow dataRow = null;
UltraGridColumn ultraGridCol = null;
int i = 0;
owner_type = estInfo.Owner_Type;
Biz_JobColumnMaps jobColumnMap = new Biz_JobColumnMaps();
DataTable dtColumnMap = null;
Biz_PositionInfos positionInfo = new Biz_PositionInfos();
DataTable dtPosNotUse = positionInfo.GetPositionInfoByUseYN("N").Tables[0];
foreach (string est_job_id in est_job_ids)
{
if (dtColumnMap == null)
{
dtColumnMap = jobColumnMap.GetJobColumnMap(comp_id
, est_id
, est_job_id).Tables[0];
}
else
{
dtColumnMap.Merge(dtColumnMap);
}
}
for (int j = ultraWebGrid.Bands[0].Columns.Count; j > default_index_count; j--)
{
ultraWebGrid.Bands[0].Columns.RemoveAt(j - 1);
ultraWebGrid.DisplayLayout.Bands[0].HeaderLayout.RemoveAt(j - 1);
}
for (; i < dataTable.Rows.Count; i++)
{
dataRow = dataTable.Rows[i];
//--------------------- 일반 컬럼일 경우
if (dataRow["COL_STYLE_ID"].ToString().Equals("NML"))
{
ultraGridCol = new UltraGridColumn();
ultraWebGrid.Bands[0].Columns.Add(ultraGridCol);
ultraGridCol.Header.Caption = dataRow["CAPTION"].ToString();
ultraGridCol.Header.Column.Width = (dataRow["WIDTH"] == DBNull.Value) ? 100 : DataTypeUtility.GetToInt32(dataRow["WIDTH"]);
ultraGridCol.Header.Column.Key = dataRow["COL_KEY"].ToString();
if (DataTypeUtility.GetYNToBoolean(dataRow["DEFAULT_VALUE_YN"].ToString()) == false)
{
ultraGridCol.Header.Column.BaseColumnName = dataRow["COL_KEY"].ToString();
}
ultraGridCol.Header.RowLayoutColumnInfo.OriginX = i + default_index_count + -1;
ultraGridCol.CellStyle.HorizontalAlign = UltraGridUtility.GetHorizontalAlign(dataRow["HALIGN"]);
ultraGridCol.DataType = dataRow["DATA_TYPE"].ToString();
ultraGridCol.Hidden = !DataTypeUtility.GetYNToBoolean(dataRow["VISIBLE_YN"].ToString());
if (DataTypeUtility.GetYNToBoolean(dataRow["BACK_COLOR_YN"].ToString()))
{
if (dataRow["BACK_COLOR"] != DBNull.Value ||
dataRow["BACK_COLOR"].ToString().Trim().Equals(""))
{
ultraGridCol.CellStyle.BackColor = Color.FromName(dataRow["BACK_COLOR"].ToString());
}
}
if (DataTypeUtility.GetYNToBoolean(dataRow["FORMAT_YN"].ToString()))
{
if (dataRow["FORMAT"] != DBNull.Value ||
dataRow["FORMAT"].ToString().Trim().Equals(""))
{
ultraGridCol.Format = dataRow["FORMAT"].ToString();
}
}
if (DataTypeUtility.GetYNToBoolean(dataRow["FORMULA_YN"].ToString()))
{
if (dataRow["FORMULA_YN"] != DBNull.Value ||
dataRow["FORMULA_YN"].ToString().Trim().Equals(""))
{
ultraGridCol.Format = dataRow["FORMULA"].ToString();
}
}
if (DataTypeUtility.GetYNToBoolean(dataRow["DEFAULT_VALUE_YN"].ToString()))
{
if (dataRow["DEFAULT_VALUE_YN"] != DBNull.Value ||
dataRow["DEFAULT_VALUE_YN"].ToString().Trim().Equals(""))
{
ultraGridCol.NullText = WebUtility.GetHtmlEncodeChar(dataRow["DEFAULT_VALUE"].ToString());
}
}
// 평가 주체가 부서인경우 (사원컬럼이면 보이기를 숨김으로 한다)
if (owner_type.Equals("D") && dept_column_no_use_yn.Equals("N"))
{
if (dataRow["COL_EMP_VISIBLE_YN"].ToString().Equals("Y"))
{
ultraGridCol.Hidden = true;
}
}
else if (owner_type.Equals("P") && dept_column_no_use_yn.Equals("Y"))
{
if (dataRow["COL_EMP_VISIBLE_YN"].ToString().Equals("Y"))
{
ultraGridCol.Hidden = true;
}
}
VisiblePosColumn(dtPosNotUse, ultraGridCol, dataRow["COL_KEY"].ToString());
}
//--------------------- 존재하는 컬럼일 경우
else if (dataRow["COL_STYLE_ID"].ToString().Equals("BLK"))
{
try
{
ultraWebGrid.Bands[0].Columns.FromKey(dataRow["COL_KEY"].ToString()).Hidden = !DataTypeUtility.GetYNToBoolean(dataRow["VISIBLE_YN"].ToString());
}
catch
{
}
}
//--------------------- 업무관련 컬럼
else if (dataRow["COL_STYLE_ID"].ToString().Equals("BIZ"))
{
ultraGridCol = new UltraGridColumn();
ultraWebGrid.Bands[0].Columns.Add(ultraGridCol);
ultraGridCol.Header.Caption = dataRow["CAPTION"].ToString();
ultraGridCol.Header.Column.Width = (dataRow["WIDTH"] == DBNull.Value) ? 100 : DataTypeUtility.GetToInt32(dataRow["WIDTH"]);
ultraGridCol.Header.Column.Key = dataRow["COL_KEY"].ToString();
if (DataTypeUtility.GetYNToBoolean(dataRow["DEFAULT_VALUE_YN"].ToString()) == false)
{
ultraGridCol.Header.Column.BaseColumnName = dataRow["COL_KEY"].ToString();
}
ultraGridCol.Header.RowLayoutColumnInfo.OriginX = i + default_index_count + -1;
ultraGridCol.CellStyle.HorizontalAlign = UltraGridUtility.GetHorizontalAlign(dataRow["HALIGN"]);
ultraGridCol.DataType = dataRow["DATA_TYPE"].ToString();
// 미리 숨김을 함
ultraGridCol.Hidden = true;
if (DataTypeUtility.GetYNToBoolean(dataRow["BACK_COLOR_YN"].ToString()))
{
if (dataRow["BACK_COLOR"] != DBNull.Value ||
dataRow["BACK_COLOR"].ToString().Trim().Equals(""))
{
ultraGridCol.CellStyle.BackColor = Color.FromName(dataRow["BACK_COLOR"].ToString());
}
}
if (DataTypeUtility.GetYNToBoolean(dataRow["FORMAT_YN"].ToString()))
{
if (dataRow["FORMAT"] != DBNull.Value ||
dataRow["FORMAT"].ToString().Trim().Equals(""))
{
ultraGridCol.Format = dataRow["FORMAT"].ToString();
}
}
if (DataTypeUtility.GetYNToBoolean(dataRow["FORMULA_YN"].ToString()))
{
if (dataRow["FORMULA_YN"] != DBNull.Value ||
dataRow["FORMULA_YN"].ToString().Trim().Equals(""))
{
ultraGridCol.Format = dataRow["FORMULA_YN"].ToString();
}
}
if (DataTypeUtility.GetYNToBoolean(dataRow["DEFAULT_VALUE_YN"].ToString()))
{
if (dataRow["DEFAULT_VALUE_YN"] != DBNull.Value ||
dataRow["DEFAULT_VALUE_YN"].ToString().Trim().Equals(""))
{
ultraGridCol.NullText = WebUtility.GetHtmlEncodeChar(dataRow["DEFAULT_VALUE"].ToString());
}
}
// COL_KEY 와 EST_JOB_ID 간에 매핑에 따라 보여주기 여부 처리
foreach (DataRow drColMap in dtColumnMap.Rows)
{
if (ultraGridCol.Hidden == true)
{
if (drColMap["COL_KEY"].ToString() == dataRow["COL_KEY"].ToString())
{
ultraGridCol.Hidden = false;
break;
}
}
}
if (ultraGridCol.Hidden == false)
{
ultraGridCol.Hidden = !DataTypeUtility.GetYNToBoolean(dataRow["VISIBLE_YN"].ToString());
}
// 평가 주체가 부서인경우 (사원컬럼이면 보이기를 숨김으로 한다)
if (owner_type.Equals("D") && dept_column_no_use_yn.Equals("N"))
{
if (dataRow["COL_EMP_VISIBLE_YN"].ToString().Equals("Y"))
{
ultraGridCol.Hidden = true;
}
}
else if (owner_type.Equals("P") && dept_column_no_use_yn.Equals("Y"))
{
if (dataRow["COL_EMP_VISIBLE_YN"].ToString().Equals("Y"))
{
ultraGridCol.Hidden = true;
}
}
VisiblePosColumn(dtPosNotUse, ultraGridCol, dataRow["COL_KEY"].ToString());
}
}
}
