private void GridBinding()
{
DataSet ds = null;
if (POINT_GRADE_TYPE.Equals("PNT"))
{
Biz_CtrlPointDatas ctrlPointData = new Biz_CtrlPointDatas();
ds = ctrlPointData.GetCtrlPointData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, CTRL_EMP_ID
, TGT_DEPT_ID
, TGT_EMP_ID
, 0);
}
else if (POINT_GRADE_TYPE.Equals("GRD"))
{
Biz_CtrlGradeDatas ctrlGradeData = new Biz_CtrlGradeDatas();
ds = ctrlGradeData.GetCtrlGradeData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, CTRL_EMP_ID
, TGT_DEPT_ID
, TGT_EMP_ID
, 0);
}
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
// 자신이 조정한 정보가 존재한다면 신규버튼을 숨김
if (ds.Tables[0].Select(string.Format("CTRL_EMP_ID = {0}", CTRL_EMP_ID)).Length > 0)
{
ibnNew.Visible = false;
}
else
{
// 평가별 평가 차수와 현재 등록된 차수가 같거나 클 경우 신규버튼을 숨김
if (ds.Tables[0].Rows.Count >= DataTypeUtility.GetToInt32(hdfCtrlStep.Value))
{
ibnNew.Visible = false;
}
}
}
private void SelectCtrlData(int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, int ctrl_emp_id
, int tgt_dept_id
, int tgt_emp_id
, int ctrl_seq)
{
if (POINT_GRADE_TYPE.Equals("PNT"))
{
Biz_CtrlPointDatas ctrlPointData = new Biz_CtrlPointDatas(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, ctrl_emp_id
, tgt_dept_id
, tgt_emp_id
, ctrl_seq);
txtCtrlPoint.Text = ctrlPointData.Ctrl_Point.ToString();
txtCtrlOpinion.Text = ctrlPointData.Ctrl_Opinion;
}
else if (POINT_GRADE_TYPE.Equals("GRD"))
{
Biz_CtrlGradeDatas ctrlGradeData = new Biz_CtrlGradeDatas(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, ctrl_emp_id
, tgt_dept_id
, tgt_emp_id
, ctrl_seq);
WebUtility.FindByValueDropDownList(ddlCtrlGradeID, ctrlGradeData.Ctrl_Grade_ID);
txtCtrlOpinion.Text = ctrlGradeData.Ctrl_Opinion;
}
}
/// <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 ibnCtrlConfirm_Click(object sender, ImageClickEventArgs e)
{
DataTable dataTable = null;
bool isOK = false;
Biz_Datas data = new Biz_Datas(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_DEPT_ID
, EST_EMP_ID
, TGT_DEPT_ID
, TGT_EMP_ID);
if (POINT_GRADE_TYPE.Equals("PNT"))
{
Biz_CtrlPointDatas ctrlPointData = new Biz_CtrlPointDatas();
dataTable = ctrlPointData.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
, "ckbCtrlConfirm"
, "CTRL_CONFIRM"
, new string[] { "CTRL_SEQ", "CTRL_POINT" }
, dataTable);
if (dataTable.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("점수 조정확정 체크박스에 선택된 항목이 없습니다.");
return;
}
else if (dataTable.Rows.Count > 1)
{
ltrScript.Text = JSHelper.GetAlertScript("두개 이상 항목이 체크될 수 없습니다.");
return;
}
isOK = data.CtrlPoint(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_DEPT_ID
, EST_EMP_ID
, TGT_DEPT_ID
, TGT_EMP_ID
, CTRL_EMP_ID
, DataTypeUtility.GetToInt32(dataTable.Rows[0]["CTRL_SEQ"])
, data.Point
, DataTypeUtility.GetToFloat(dataTable.Rows[0]["CTRL_POINT"])
, DateTime.Now
, DateTime.Now
, EMP_REF_ID);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 점수조정이 확정되었습니다.", "lbnReload", true);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("점수조정 확정 중 오류가 발생하였습니다.");
}
}
else if (POINT_GRADE_TYPE.Equals("GRD"))
{
Biz_CtrlGradeDatas ctrlGradeData = new Biz_CtrlGradeDatas();
dataTable = ctrlGradeData.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
, "ckbCtrlConfirm"
, "CTRL_CONFIRM"
, new string[] { "CTRL_SEQ", "CTRL_GRADE_ID" }
, dataTable);
if (dataTable.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("등급 조정확정 체크박스에 선택된 항목이 없습니다.");
return;
}
else if (dataTable.Rows.Count > 1)
{
ltrScript.Text = JSHelper.GetAlertScript("두개 이상 항목이 체크될 수 없습니다.");
return;
}
isOK = data.CtrlGrade(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_DEPT_ID
, EST_EMP_ID
, TGT_DEPT_ID
, TGT_EMP_ID
, CTRL_EMP_ID
, DataTypeUtility.GetToInt32(dataTable.Rows[0]["CTRL_SEQ"])
, data.Grade_ID
, DataTypeUtility.GetValue(dataTable.Rows[0]["CTRL_GRADE_ID"])
, DateTime.Now
, DateTime.Now
, EMP_REF_ID);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 등급조정이 확정되었습니다.", "lbnReload", true);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("등급조정 확정 중 오류가 발생하였습니다.");
}
}
}
protected void ibnSave_Click(object sender, ImageClickEventArgs e)
{
Biz_CtrlPointDatas ctrlPointData = new Biz_CtrlPointDatas();
Biz_CtrlGradeDatas ctrlGradeData = new Biz_CtrlGradeDatas();
bool isOK = false;
if (PageWriteMode == WriteMode.New)
{
if (POINT_GRADE_TYPE.Equals("PNT"))
{
if (txtCtrlPoint.Text.Equals(""))
{
ltrScript.Text = JSHelper.GetAlertScript("조정점수를 입력하세요.");
return;
}
isOK = ctrlPointData.AddCtrlPointData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, CTRL_EMP_ID
, TGT_DEPT_ID
, TGT_EMP_ID
, DataTypeUtility.GetToFloat(txtCtrlPoint.Text)
, txtCtrlOpinion.Text
, DateTime.Now
, EMP_REF_ID);
}
else if (POINT_GRADE_TYPE.Equals("GRD"))
{
isOK = ctrlGradeData.AddCtrlGradeData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, CTRL_EMP_ID
, TGT_DEPT_ID
, TGT_EMP_ID
, WebUtility.GetByValueDropDownList(ddlCtrlGradeID)
, txtCtrlOpinion.Text
, DateTime.Now
, EMP_REF_ID);
}
if (isOK)
{
GridBinding();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 등록되지 않았습니다.");
return;
}
}
else if (PageWriteMode == WriteMode.Modify)
{
if (POINT_GRADE_TYPE.Equals("PNT"))
{
if (txtCtrlPoint.Text.Equals(""))
{
ltrScript.Text = JSHelper.GetAlertScript("조정점수를 입력하세요.");
return;
}
isOK = ctrlPointData.ModifyCtrlPointData(DataTypeUtility.GetToInt32(hdfCompID.Value)
, hdfEstID.Value
, DataTypeUtility.GetToInt32(hdfEstTermRefID.Value)
, DataTypeUtility.GetToInt32(hdfEstTermSubID.Value)
, DataTypeUtility.GetToInt32(hdfEstTermStepID.Value)
, DataTypeUtility.GetToInt32(hdfCtrlEmpID.Value)
, DataTypeUtility.GetToInt32(hdfTgtDeptID.Value)
, DataTypeUtility.GetToInt32(hdfTgtEmpID.Value)
, DataTypeUtility.GetToInt32(hdfCtrlSeq.Value)
, DataTypeUtility.GetToFloat(txtCtrlPoint.Text)
, txtCtrlOpinion.Text
, DateTime.Now
, EMP_REF_ID);
}
else if (POINT_GRADE_TYPE.Equals("GRD"))
{
isOK = ctrlGradeData.ModifyCtrlGradeData(DataTypeUtility.GetToInt32(hdfCompID.Value)
, hdfEstID.Value
, DataTypeUtility.GetToInt32(hdfEstTermRefID.Value)
, DataTypeUtility.GetToInt32(hdfEstTermSubID.Value)
, DataTypeUtility.GetToInt32(hdfEstTermStepID.Value)
, DataTypeUtility.GetToInt32(hdfCtrlEmpID.Value)
, DataTypeUtility.GetToInt32(hdfTgtDeptID.Value)
, DataTypeUtility.GetToInt32(hdfTgtEmpID.Value)
, DataTypeUtility.GetToInt32(hdfCtrlSeq.Value)
, WebUtility.GetByValueDropDownList(ddlCtrlGradeID)
, txtCtrlOpinion.Text
, DateTime.Now
, EMP_REF_ID);
}
if (isOK)
{
GridBinding();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 수정되지 않았습니다.");
return;
}
}
ButtonStatusByInit();
}
