private void ViewOne(int comp_id, string est_id, string col_key)
{
Biz_ColumnInfos columnInfos = new Biz_ColumnInfos(comp_id, est_id, col_key);
Biz_ColumnStyles columnStyles = new Biz_ColumnStyles(columnInfos.Col_Style_ID);
txtSeq.Text = columnInfos.Seq.ToString();
txtColName.Text = columnInfos.Col_Name;
WebUtility.FindByValueDropDownList(ddlColStyleID, columnInfos.Col_Style_ID);
txtColKey.Text = columnInfos.Col_Key;
txtCaption.Text = columnInfos.Caption;
txtWidth.Text = columnInfos.Width.ToString();
WebUtility.FindByValueDropDownList(ddlDataType, columnInfos.Data_Type);
WebUtility.FindByValueDropDownList(ddlHAlign, columnInfos.Halign);
txtBackColor.Text = columnInfos.Back_Color;
txtFormat.Text = columnInfos.Format;
txtFormula.Text = columnInfos.Formula;
txtDefaultValue.Text = columnInfos.Default_Value;
txtColDesc.Text = columnInfos.Col_Desc;
ckbBackColorYN.Checked = DataTypeUtility.GetYNToBoolean(columnInfos.Back_color_YN);
ckbFormatYN.Checked = DataTypeUtility.GetYNToBoolean(columnInfos.Format_YN);
ckbFormularYN.Checked = DataTypeUtility.GetYNToBoolean(columnInfos.Formula_YN);
ckbDefaultValueYN.Checked = DataTypeUtility.GetYNToBoolean(columnInfos.Default_Value_YN);
WebUtility.FindByValueRadioButtonList(rbnVisibleYN, columnInfos.Visible_YN);
WebUtility.FindByValueRadioButtonList(rbnColEmpVisibleYN, columnInfos.Col_Emp_Visible_YN);
//WebUtility.FindByValueRadioButtonList(rbnGradeToPointVisibleYN, columnInfos.Col_Grade_To_Point_Visible_YN);
BindEstJob(COMP_ID, EST_ID, col_key);
ddlColStyleID_SelectedIndexChanged(null, null);
}
/// <summary>
/// 평가차수의 총가중치 합 반환
/// </summary>
/// <param name="est_id"></param>
/// <returns></returns>
public static double GetTotalWeightEstTermStep(int comp_id, string est_id)
{
Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id);
Biz_TermStepEstMaps estterm = new Biz_TermStepEstMaps();
DataTable dataTable = estterm.GetTermStepEstMap(comp_id, est_id).Tables[0];
double total = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
// 상향평가가 아닌 가중치만 더한다.
if (!DataTypeUtility.GetYNToBoolean(DataTypeUtility.GetValue(dataRow["FIXED_WEIGHT_YN"])))
{
total += DataTypeUtility.GetToDouble(dataRow["WEIGHT"]);
}
}
// 만약 상향평가일 경우 고정가중치를 더해준다.
if (DataTypeUtility.GetYNToBoolean(estInfo.Fixed_Weight_Use_YN))
{
total += DataTypeUtility.GetToDouble(estInfo.Fixed_Weight);
}
if (total == 0)
{
return(100);
}
return(total);
}
private void SelectScaleInfo(int comp_id, string scale_id)
{
Biz_ScaleInfos scaleInfo = new Biz_ScaleInfos(comp_id, scale_id);
hdfScaleInfo.Value = scale_id;
txtScaleID.Text = scaleInfo.Scale_ID;
txtScaleName.Text = scaleInfo.Scale_Name;
cbUseYN.Checked = DataTypeUtility.GetYNToBoolean(scaleInfo.Use_YN);
}
private void SelectCtrlInfo(string ctrl_id)
{
Biz_CtrlInfos ctrlInfo = new Biz_CtrlInfos(ctrl_id);
Biz_EmpInfos empInfo = new Biz_EmpInfos(ctrlInfo.Ctrl_Emp_ID);
hdfEmpRefID.Value = DataTypeUtility.GetValue(ctrlInfo.Ctrl_Emp_ID);
txtEmpName.Text = empInfo.Emp_Name;
txtScope.Text = DataTypeUtility.GetValue(ctrlInfo.Scope);
WebUtility.FindByValueDropDownList(ddlScopeUnitID, ctrlInfo.Scope);
ckbAllEstYN.Checked = DataTypeUtility.GetYNToBoolean(ctrlInfo.All_Est_YN);
ckbAllEstDeptYN.Checked = DataTypeUtility.GetYNToBoolean(ctrlInfo.All_Est_Dept_YN);
ckbConfirmEmpYN.Checked = DataTypeUtility.GetYNToBoolean(ctrlInfo.Confirm_Emp_YN);
}
private void SelectBoardInfo(string board_id)
{
Biz_Boards boardInfo = new Biz_Boards(board_id, BOARD_CATEGORY_ID);
hdfBoardID.Value = board_id;
txtSubjectText.Text = boardInfo.Subject_Text;
txtContentText.Value = boardInfo.Content_Text;
cbPopupYN.Checked = DataTypeUtility.GetYNToBoolean(boardInfo.Pop_Up_YN);
wdcStartDate.Value = boardInfo.Start_Date;
wdcEndDate.Value = boardInfo.End_Date;
WebUtility.FindByValueDropDownList(ddlMenuRefID, boardInfo.Menu_Ref_ID);
lblWriteEmpName.Text = boardInfo.Write_Emp_Name + "( " + boardInfo.Write_Emp_ID.ToString() + " )";
SetPopupYN(cbPopupYN.Checked);
}
private void ViewOne(int comp_id, int estterm_sub_id)
{
Biz_TermSubs termSub = new Biz_TermSubs(comp_id, estterm_sub_id);
txtEstTermSubID.Text = termSub.EstTerm_Sub_ID.ToString();
txtEstTermSubName.Text = termSub.EstTerm_Sub_Name;
txtWeight.Text = DataTypeUtility.GetValue(termSub.Weight);
ckbYearYN.Checked = DataTypeUtility.GetYNToBoolean(termSub.Year_YN);
txtSortOrder.Text = DataTypeUtility.GetValue(termSub.Sort_Order);
ckbUseYN.Checked = DataTypeUtility.GetYNToBoolean(termSub.Use_YN);
txtStartMonth.Text = DataTypeUtility.GetValue(termSub.Start_Month);
txtEndMonth.Text = DataTypeUtility.GetValue(termSub.End_Month);
hdfEstTermSubID.Value = estterm_sub_id.ToString();
}
private void ViewOne(int comp_id, int estterm_step_id)
{
MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data();
string reVal = bizEstData.RemoveEstDataWithJoin_DB();
Biz_TermSteps termStep = new Biz_TermSteps(comp_id, estterm_step_id);
txtEstTermStepID.Text = termStep.EstTerm_Step_ID.ToString();
txtEstTermStepName.Text = termStep.EstTerm_Step_Name;
txtWeight.Text = DataTypeUtility.GetValue(termStep.Weight);
txtSortOrder.Text = DataTypeUtility.GetValue(termStep.Sort_Order);
ckbMergeYN.Checked = DataTypeUtility.GetYNToBoolean(termStep.Merge_YN);
ckbUseYN.Checked = DataTypeUtility.GetYNToBoolean(termStep.Use_YN);
hdfEstTermStepID.Value = estterm_step_id.ToString();
}
public string ModifyKpiResultDataBulker_DB(DataTable dt
, string title
, int create_user
, string create_date)
{
string returnVal = string.Empty;
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
object estterm_ref_id = row["ESTTERM_REF_ID"];
object kpi_ref_id = row["KPI_REF_ID"];
object ymd = row["YMD"];
object result_ms = row["RESULT_MS"];
object result_ts = row["RESULT_TS"];
object checkstatus = "Y";
bool check_Apping_yn = DataTypeUtility.GetYNToBoolean(DataTypeUtility.GetValue(row["CHECK_APPING_YN"]));
int app_ref_id = DataTypeUtility.GetToInt32(row["APP_REF_ID"]);
if (check_Apping_yn)
{
MicroBSC.Integration.COM.Dac.Dac_Com_Approval_Info dacApprovalInfo = new MicroBSC.Integration.COM.Dac.Dac_Com_Approval_Info();
app_ref_id = dacApprovalInfo.SelectMaxAppRefID(conn, trx);
int app_version_id = 1;
string biz_type = "KRA";
string app_code = string.Format("{0}-{1}-{2}", biz_type, app_ref_id, app_version_id);
string active_yn = "Y";
string app_status = "CFT";
string draft_status = "FD";
affectedRow = dacApprovalInfo.InsertApprovalinfo_DB(conn
, trx
, app_ref_id
, app_version_id
, app_code
, active_yn
, DBNull.Value
, title
, biz_type
, app_status
, draft_status
, create_user
, create_date);
MicroBSC.Integration.COM.Dac.Dac_Com_Approval_Prc dacApprovalPrc = new MicroBSC.Integration.COM.Dac.Dac_Com_Approval_Prc();
affectedRow = dacApprovalPrc.InsertApprovalPrc_DB(conn
, trx
, app_ref_id
, app_version_id
, 1
, create_user
, "Y"
, title
, DBNull.Value
, "D"
, "NAME"
, create_user
, create_date);
}
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result dacBscKpiResult = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result();
affectedRow = dacBscKpiResult.UpdataData_DB(conn
, trx
, estterm_ref_id
, kpi_ref_id
, ymd
, result_ms
, result_ts
, app_ref_id
, checkstatus
, create_user
, create_date);
}
//trx.Rollback();
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
returnVal = ex.Message;
return(returnVal);
}
finally
{
conn.Close();
}
return(returnVal);
}
/// <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());
}
}
}
// 등급 조정 적용하기
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>";
}
}
