public bool AddScope(DataTable dtInsert
, DateTime create_date
, int create_user)
{
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
int affectedRow = 0;
try
{
for (int i = 0; i < dtInsert.Rows.Count; i++)
{
// 최초 한번만 삭제
if (i == 0)
{
affectedRow = _scope.Delete(conn
, trx
, DataTypeUtility.GetToInt32(dtInsert.Rows[i]["COMP_ID"])
, dtInsert.Rows[i]["EST_ID"].ToString()
, string.Empty
, dtInsert.Rows[i]["SCALE_ID"].ToString());
}
affectedRow = _scope.Insert(conn
, trx
, DataTypeUtility.GetToInt32(dtInsert.Rows[i]["COMP_ID"])
, dtInsert.Rows[i]["EST_ID"].ToString()
, dtInsert.Rows[i]["GRADE_ID"].ToString()
, dtInsert.Rows[i]["SCALE_ID"].ToString()
, DataTypeUtility.GetToFloat(dtInsert.Rows[i]["START_SCOPE"])
, DataTypeUtility.GetToFloat(dtInsert.Rows[i]["END_SCOPE"])
, dtInsert.Rows[i]["SCOPE_UNIT_ID"].ToString()
, DataTypeUtility.GetToFloat(dtInsert.Rows[i]["GRADE_TO_POINT"])
, create_date
, create_user);
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
if (affectedRow > 0)
{
return(true);
}
return(false);
}
public bool SaveDeptPosDetailAll(DataTable dtDept, DataTable dtDetailData)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
if (dtDetailData.Rows.Count > 0)
{
foreach (DataRow dataRowDept in dtDept.Rows)
{
affectedRow += _deptPosDetail.Delete(conn
, trx
, DataTypeUtility.GetToInt32(dtDetailData.Rows[0]["COMP_ID"])
, DataTypeUtility.GetToInt32(dtDetailData.Rows[0]["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRowDept["DEPT_REF_ID"])
, DataTypeUtility.GetValue(dtDetailData.Rows[0]["EST_ID"])
, 0);
}
}
foreach (DataRow dataRowDept in dtDept.Rows)
{
foreach (DataRow dataRowDetailData in dtDetailData.Rows)
{
affectedRow = _deptPosDetail.Insert(conn
, trx
, DataTypeUtility.GetToInt32(dataRowDetailData["COMP_ID"])
, DataTypeUtility.GetToInt32(dataRowDetailData["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRowDept["DEPT_REF_ID"])
, DataTypeUtility.GetValue(dataRowDetailData["EST_ID"])
, DataTypeUtility.GetToInt32(dataRowDetailData["SEQ"])
, DataTypeUtility.GetValue(dataRowDetailData["POS_ID"])
, DataTypeUtility.GetValue(dataRowDetailData["POS_VALUE"])
, DataTypeUtility.GetToFloat(dataRowDetailData["WEIGHT"])
, DataTypeUtility.GetToDateTime(dataRowDetailData["DATE"])
, DataTypeUtility.GetToInt32(dataRowDetailData["USER"]));
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public Biz_Prj_QuestionData(int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, int est_dept_id
, int est_emp_id
, int tgt_emp_id
, int prj_ref_id
, string q_sbj_id)
{
DataSet ds = _questiondata.Select(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, est_dept_id
, est_emp_id
, tgt_emp_id
, prj_ref_id
, q_sbj_id);
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_comp_id = DataTypeUtility.GetToInt32(dr["COMP_ID"]);
_est_id = DataTypeUtility.GetValue(dr["EST_ID"]);
_estterm_ref_id = DataTypeUtility.GetToInt32(dr["ESTTERM_REF_ID"]);
_estterm_sub_id = DataTypeUtility.GetToInt32(dr["ESTTERM_SUB_ID"]);
_estterm_step_id = DataTypeUtility.GetToInt32(dr["ESTTERM_STEP_ID"]);
_est_dept_id = DataTypeUtility.GetToInt32(dr["EST_DEPT_ID"]);
_est_emp_id = DataTypeUtility.GetToInt32(dr["EST_EMP_ID"]);
_prj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_q_obj_id = DataTypeUtility.GetValue(dr["Q_OBJ_ID"]);
_q_sbj_id = DataTypeUtility.GetValue(dr["Q_SBJ_ID"]);
_q_itm_id = DataTypeUtility.GetValue(dr["Q_ITM_ID"]);
_point = DataTypeUtility.GetToFloat(dr["POINT"]);
_grade_id = DataTypeUtility.GetValue(dr["GRADE_ID"]);
_text_value = DataTypeUtility.GetValue(dr["TEXT_VALUE"]);
_opinion = DataTypeUtility.GetValue(dr["OPINION"]);
_attach_no = DataTypeUtility.GetValue(dr["ATTACH_NO"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public Biz_Prj_Data(int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, int est_dept_id
, int est_emp_id
, int prj_ref_id)
{
DataSet ds = GetPrjData(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, est_dept_id
, est_emp_id
, prj_ref_id
, ""
, "");
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_comp_id = DataTypeUtility.GetToInt32(dr["COMP_ID"]);
_est_id = DataTypeUtility.GetValue(dr["EST_ID"]);
_estterm_ref_id = DataTypeUtility.GetToInt32(dr["ESTTERM_REF_ID"]);
_estterm_sub_id = DataTypeUtility.GetToInt32(dr["ESTTERM_SUB_ID"]);
_estterm_step_id = DataTypeUtility.GetToInt32(dr["ESTTERM_STEP_ID"]);
_est_dept_id = DataTypeUtility.GetToInt32(dr["EST_DEPT_ID"]);
_est_emp_id = DataTypeUtility.GetToInt32(dr["EST_EMP_ID"]);
_prj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_point = DataTypeUtility.GetToFloat(dr["POINT"]);
_point_date = DataTypeUtility.GetToDateTime(dr["POINT_DATE"]);
_status_id = DataTypeUtility.GetValue(dr["STATUS_ID"]);
_status_date = DataTypeUtility.GetToDateTime(dr["STATUS_DATE"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public bool SaveDeptEstWithWeight(DataTable dtWeight)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
object weight;
try
{
foreach (DataRow drItem in dtWeight.Rows)
{
_comp_id = DataTypeUtility.GetToInt32(drItem["COMP_ID"]);
_estterm_ref_id = DataTypeUtility.GetToInt32(drItem["ESTTERM_REF_ID"]);
_dept_ref_id = DataTypeUtility.GetToInt32(drItem["DEPT_REF_ID"]);
_est_id = drItem["EST_ID"].ToString();
if (drItem["WEIGHT"].ToString().Length == 0)
{
weight = DBNull.Value;
}
else
{
weight = DataTypeUtility.GetToFloat(drItem["WEIGHT"]);
}
_update_date = DataTypeUtility.GetToDateTime(drItem["DATE"]);
_update_user = DataTypeUtility.GetToInt32(drItem["USER"]);
if (IsExist(_comp_id, _estterm_ref_id, _dept_ref_id, _est_id, ""))
{
affectedRow += _deptEstDetail.Update(null
, null
, _comp_id
, _estterm_ref_id
, _dept_ref_id
, _est_id
, DBNull.Value
, DBNull.Value
, weight
, DBNull.Value
, _update_date
, _update_user);
}
else
{
affectedRow += _deptEstDetail.Insert(null
, null
, _comp_id
, _estterm_ref_id
, _dept_ref_id
, _est_id
, DBNull.Value
, DBNull.Value
, weight
, DBNull.Value
, _update_date
, _update_user);
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public bool SaveQuestionData_TGT_ID(DataTable dtQData, DataTable dtPrjData)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
Dac_Prj_Data datas = new Dac_Prj_Data();
try
{
foreach (DataRow dataRow in dtQData.Rows)
{
if (IsExist(DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, dataRow["EST_ID"].ToString()
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_SUB_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_STEP_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_DEPT_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_EMP_ID"])
, DataTypeUtility.GetToInt32(dataRow["USER"])
, DataTypeUtility.GetToInt32(dataRow["PRJ_REF_ID"])
, dataRow["Q_SBJ_ID"].ToString()))
{
affectedRow += _questiondata.Update(null
, null
, DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, dataRow["EST_ID"].ToString()
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_SUB_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_STEP_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_DEPT_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_EMP_ID"])
, DataTypeUtility.GetToInt32(dataRow["PRJ_REF_ID"])
, dataRow["Q_OBJ_ID"].ToString()
, dataRow["Q_SBJ_ID"].ToString()
, dataRow["Q_ITM_ID"].ToString()
, DataTypeUtility.GetToFloat(dataRow["POINT"])
, dataRow["GRADE_ID"].ToString()
, dataRow["TEXT_VALUE"].ToString()
, dataRow["OPINION"].ToString()
, dataRow["ATTACH_NO"].ToString()
, DateTime.Now
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
else
{
affectedRow += _questiondata.Insert(null
, null
, DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, dataRow["EST_ID"].ToString()
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_SUB_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_STEP_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_DEPT_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_EMP_ID"])
, DataTypeUtility.GetToInt32(dataRow["PRJ_REF_ID"])
, dataRow["Q_OBJ_ID"].ToString()
, dataRow["Q_SBJ_ID"].ToString()
, dataRow["Q_ITM_ID"].ToString()
, DataTypeUtility.GetToFloat(dataRow["POINT"])
, dataRow["GRADE_ID"].ToString()
, dataRow["TEXT_VALUE"].ToString()
, dataRow["OPINION"].ToString()
, dataRow["ATTACH_NO"].ToString()
, DateTime.Now
, DataTypeUtility.GetToInt32(dataRow["USER"]));
}
}
// PRJ_DATA 저장
foreach (DataRow dataRow in dtPrjData.Rows)
{
if (datas.Count(DataTypeUtility.GetToInt32(dataRow["COMP_ID"])
, dataRow["EST_ID"].ToString()
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_SUB_ID"])
, DataTypeUtility.GetToInt32(dataRow["ESTTERM_STEP_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_DEPT_ID"])
, DataTypeUtility.GetToInt32(dataRow["EST_EMP_ID"])
, DataTypeUtility.GetToInt32(dataRow["PRJ_REF_ID"])) > 0)
{
affectedRow += datas.Update(null
, null
, dataRow["COMP_ID"]
, dataRow["EST_ID"]
, dataRow["ESTTERM_REF_ID"]
, dataRow["ESTTERM_SUB_ID"]
, dataRow["ESTTERM_STEP_ID"]
, dataRow["EST_DEPT_ID"]
, dataRow["EST_EMP_ID"]
, dataRow["TGT_DEPT_ID"]
, dataRow["TGT_EMP_ID"]
, dataRow["PRJ_REF_ID"]
, dataRow["POINT"]
, Convert.ToDateTime(dataRow["POINT_DATE"])
, dataRow["STATUS_ID"]
, Convert.ToDateTime(dataRow["STATUS_DATE"])
, Convert.ToDateTime(dataRow["DATE"])
, dataRow["USER"]);
}
else
{
affectedRow += datas.Insert(null
, null
, dataRow["COMP_ID"]
, dataRow["EST_ID"]
, dataRow["ESTTERM_REF_ID"]
, dataRow["ESTTERM_SUB_ID"]
, dataRow["ESTTERM_STEP_ID"]
, dataRow["EST_DEPT_ID"]
, dataRow["EST_EMP_ID"]
, dataRow["TGT_DEPT_ID"]
, dataRow["TGT_EMP_ID"]
, dataRow["PRJ_REF_ID"]
, dataRow["POINT"]
, dataRow["POINT_DATE"]
, dataRow["STATUS_ID"]
, dataRow["STATUS_DATE"]
, dataRow["DATE"]
, dataRow["USER"]);
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
protected void ibnSave3_Click(object sender, ImageClickEventArgs e)
{
if (CheckInsertWeightPos())
{
Biz_DeptPosDetails deptPosDetail = new Biz_DeptPosDetails();
int estterm_ref_id = ESTTERM_REF_ID;
int dept_ref_id = DataTypeUtility.GetToInt32(hdfDeptRefID.Value);
string est_id = EST_ID;
string pos_id = WebUtility.GetByValueDropDownList(ddlPositionType);
string pos_value = WebUtility.GetByValueDropDownList(ddlPositionValue);
float weight = DataTypeUtility.GetToFloat(txtWeightPos.Text.Trim());
bool isOK = false;
try
{
bool isDuplicate = deptPosDetail.IsExist(COMP_ID
, estterm_ref_id
, dept_ref_id
, est_id
, 0
, pos_id
, pos_value);
if (isDuplicate)
{
if (hdfEstPosSeq.Value.Equals(""))
{
ltrScript.Text = JSHelper.GetAlertScript("변경하실 직급 구분을 선택하세요.");
return;
}
isOK = deptPosDetail.ModifyDeptPosDetail(COMP_ID
, estterm_ref_id
, dept_ref_id
, est_id
, DataTypeUtility.GetToInt32(hdfEstPosSeq.Value)
, pos_id
, pos_value
, weight
, DateTime.Now
, EMP_REF_ID);
}
else
{
isOK = deptPosDetail.AddDeptPosDetail(COMP_ID
, estterm_ref_id
, dept_ref_id
, est_id
, deptPosDetail.NewIdx(COMP_ID, estterm_ref_id, dept_ref_id, est_id)
, pos_id
, pos_value
, weight
, DateTime.Now
, EMP_REF_ID);
}
if (isOK)
{
GridBinding3(COMP_ID, ESTTERM_REF_ID, dept_ref_id, EST_ID);
ClearControlValues();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("저장 중 오류가 발생하였습니다.");
}
}
catch (Exception ex)
{
ltrScript.Text = JSHelper.GetAlertScript("저장 중 오류가 발생하였습니다.");
}
}
}
protected void ibnSave_Click(object sender, ImageClickEventArgs e)
{
Biz_CtrlInfos ctrlInfo = new Biz_CtrlInfos();
if (PageWriteMode == WriteMode.New)
{
bool isOK = ctrlInfo.AddCtrlInfo(COMP_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, DataTypeUtility.GetToInt32(hdfEmpRefID.Value)
, DataTypeUtility.GetToFloat(txtScope.Text)
, POINT_GRADE_TYPE
, WebUtility.GetByValueDropDownList(ddlScopeUnitID)
, DataTypeUtility.GetBooleanToYN(ckbAllEstYN.Checked)
, DataTypeUtility.GetBooleanToYN(ckbAllEstDeptYN.Checked)
, DataTypeUtility.GetBooleanToYN(ckbConfirmEmpYN.Checked)
, 0
, DateTime.Now
, EMP_REF_ID);
if (isOK)
{
BindCtrlInfo(COMP_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, POINT_GRADE_TYPE);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 등록되지 않았습니다.");
return;
}
}
else if (PageWriteMode == WriteMode.Modify)
{
bool isOK = ctrlInfo.ModifyCtrlInfo(CTRL_ID
, COMP_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, DataTypeUtility.GetToInt32(hdfEmpRefID.Value)
, DataTypeUtility.GetToFloat(txtScope.Text)
, POINT_GRADE_TYPE
, WebUtility.GetByValueDropDownList(ddlScopeUnitID)
, DataTypeUtility.GetBooleanToYN(ckbAllEstYN.Checked)
, DataTypeUtility.GetBooleanToYN(ckbAllEstDeptYN.Checked)
, DataTypeUtility.GetBooleanToYN(ckbConfirmEmpYN.Checked)
, 0
, DateTime.Now
, EMP_REF_ID);
if (isOK)
{
BindCtrlInfo(COMP_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, POINT_GRADE_TYPE);
ClearValueControls();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 수정되지 않았습니다.");
return;
}
}
ButtonStatusInit();
}
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();
}
