protected void AllSave_Eqt_Eql_Ratio()
{
int eqtValue = DataTypeUtility.GetToInt32(this.txtEqtValue.Text);
int eqlValue = DataTypeUtility.GetToInt32(this.txtEqlValue.Text);
DataTable dt = new DataTable();
dt.Columns.Add("KPI_REF_ID");
dt = UltraGridUtility.GetDataTableByCheckValue(this.ugrdKpiList, "cBox", "selchk", new string[] { "KPI_REF_ID" }, dt);
bool result = bizBscKpiEqtEql.Set_Kpi_Eqt_Eql_Ratio(ESTTERM_REF_ID
, dt
, eqtValue
, eqlValue
, gUserInfo.Emp_Ref_ID);
if (result)
{
this.ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저리되었습니다.");
doBind_Kpi_Eqt_Eql_List();
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript("오류가 발생했습니다.");
}
}
protected void iBtnConfirm_Click(object sender, ImageClickEventArgs e)
{
Biz_QuestionDeptEmpMaps questionDeptEmpMaps = new Biz_QuestionDeptEmpMaps();
DataTable dataTable = questionDeptEmpMaps.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid2
, new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dataRow["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["Q_OBJ_ID"] = Q_OBJ_ID;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = questionDeptEmpMaps.AddQuestionDeptEmpMap(dataTable);
if (isOK)
{
ltrScript.Text = JSHelper.GetOpenerControlCallBackScript("lbnEmpReload", true);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("추가하실 사원을 선택하세요.");
}
}
protected void iBtnRemoveGroupPosition_Click(object sender, ImageClickEventArgs e)
{
Biz_RelGroupPositionInfos relGroupPosInfo = new Biz_RelGroupPositionInfos();
DataTable dataTable = relGroupPosInfo.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(uwgRelGrpPosInfo
, "cBox"
, "selchk"
, new string[] { "REL_GRP_POS_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["REL_GRP_ID"] = REL_GRP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
}
bool isOK = relGroupPosInfo.RemoveRelGroupPosInfo(dataTable);
if (isOK)
{
BindingRelGroupPosInfo(COMP_ID, REL_GRP_ID, EST_ID, ESTTERM_REF_ID);
ButtonStatusByInit_RelGrpPos();
uwgRelGrpPosData.Clear();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 삭제가 처리되지 않았습니다.");
return;
}
}
protected void Save_Custom_Col_Value()
{
DataTable DT = new DataTable();
string[] Cols = new string[] { "PRJ_COL_ID", "PRJ_COL_NAME", "PRJ_COL_VALUE" };
for (int i = 0; i < Cols.Length; i++)
{
DT.Columns.Add(Cols[i]);
}
DT = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid3, Cols, DT);
bool Result;
Result = bizPmsColInfo.Modify_Custom_Col_Value(DT, PRJ_ID, gUserInfo.Emp_Ref_ID.ToString());
if (Result)
{
this.ltrScript.Text = JSHelper.GetAlertScript("저장되었습니다.");
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript("저장에 실패하였습니다.");
}
}
private bool SaveEstJobColumnMap(bool isBlank)
{
Biz_JobColumnMaps jobColumnMap = new Biz_JobColumnMaps();
DataTable dataTable = jobColumnMap.GetDataTableSchema();
if (!isBlank)
{
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid2
, "cBox"
, "selchk"
, new string[] { "EST_JOB_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["COL_KEY"] = txtColKey.Text;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
}
return(jobColumnMap.SaveJobColumnMap(dataTable, COMP_ID, EST_ID, txtColKey.Text));
}
protected void iBtnRemove_Click(object sender, ImageClickEventArgs e)
{
Biz_RoleInfos objRoleInfo = new Biz_RoleInfos();
DataTable dataTable = objRoleInfo.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(this.UltraWebGrid2
, "cBox"
, "selchk"
, new string[] { "ROLE_REF_ID", "ROLE_NAME", "ROLE_DESC", "SORT_ORDER", "DELETE_ENABLED_YN" }
, dataTable
, true);
bool isOK = objRoleInfo.RemoveRoleInfo(dataTable);
if (!isOK)
{
lblScript.Text = JSHelper.GetAlertScript("삭제한 권한을 체크해주세요.", false);
}
else
{
lblScript.Text = JSHelper.GetAlertScript("권한을 삭제하였습니다.", false);
DataBindingRole();
GridBindginMenu();
}
}
protected void ibtnDelete_Click(object sender, ImageClickEventArgs e)
{
string[] strCode = new string[] { "SCORE_CODE" };
DataTable dtTemp = new DataTable();
dtTemp.Columns.Add("SCORE_CODE", typeof(string));
dtTemp = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1, "cBox", "selchk", strCode, dtTemp);
if (dtTemp.Rows.Count > 0)
{
Biz_EstDeptOrgScoreInfos bizEDOS = new Biz_EstDeptOrgScoreInfos();
if (bizEDOS.DeleteEDOS(WebUtility.GetIntByValueDropDownList(ddlEstTermInfo), dtTemp))
{
DoBinding();
ltrScript.Text = JSHelper.GetAlertScript("삭제하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("삭제실패!");
}
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("선택하세요!");
}
}
protected void iBtnSave_Click(object sender, ImageClickEventArgs e)
{
Biz_RoleMenuRels objRoleMenuRel = new Biz_RoleMenuRels();
DataTable dataTable = objRoleMenuRel.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(this.UltraWebGrid1
, "cBox"
, "selchk"
, new string[] { "MENU_REF_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["ROLE_REF_ID"] = this.hdfRoleRefID.Value;
}
bool isOK = objRoleMenuRel.SaveRoleMenuRel(dataTable);
if (!isOK)
{
lblScript.Text = JSHelper.GetAlertScript("권한/메뉴 매핑할 메뉴를 체크해주세요.", false);
}
else
{
lblScript.Text = JSHelper.GetAlertScript("권한/메뉴 매핑을 성공하였습니다.", false);
DataBindingRole();
GridBindginMenu();
}
}
protected void ibtnAddEmp_Click(object sender, ImageClickEventArgs e)
{
int cntRow = 0;
CheckBox chk;
UltraGridRow row;
TemplatedColumn col;
for (int i = 0; i < this.UltraWebGrid1.Rows.Count; i++)
{
row = UltraWebGrid1.Rows[i];
col = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox");
if (chk.Checked && UltraGridUtility.IsColumnValueContains(UltraWebGrid2, row, "EMP_REF_ID", "TGT_EMP_ID") == false)
{
UltraWebGrid2.Rows.Add();
cntRow = UltraWebGrid2.Rows.Count - 1;
UltraWebGrid2.Rows[cntRow].Cells.FromKey("TGT_DEPT_ID").Value = row.Cells.FromKey("DEPT_REF_ID").Value;
UltraWebGrid2.Rows[cntRow].Cells.FromKey("TGT_EMP_ID").Value = row.Cells.FromKey("EMP_REF_ID").Value;
UltraWebGrid2.Rows[cntRow].Cells.FromKey("LOGINID").Value = row.Cells.FromKey("LOGINID").Value;
UltraWebGrid2.Rows[cntRow].Cells.FromKey("DEPT_NAME").Value = row.Cells.FromKey("DEPT_NAME").Value;
UltraWebGrid2.Rows[cntRow].Cells.FromKey("EMP_NAME").Value = row.Cells.FromKey("EMP_NAME").Value;
UltraWebGrid2.Rows[cntRow].Cells.FromKey("Q_OBJ_NAME").Value = row.Cells.FromKey("Q_OBJ_NAME").Value;
UltraWebGrid2.Rows[cntRow].Cells.FromKey("POS_CLS_NAME").Value = row.Cells.FromKey("POS_CLS_NAME").Value;
UltraWebGrid2.Rows[cntRow].Cells.FromKey("Q_OBJ_ID").Value = row.Cells.FromKey("Q_OBJ_ID").Value;
}
}
lblSelect.Text = UltraWebGrid2.Rows.Count.ToString();
}
protected void iBtnDelete_Click(object sender, ImageClickEventArgs e)
{
Biz_MenuInfo objMenuInfo = new Biz_MenuInfo();
DataTable dataTable = objMenuInfo.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(this.UltraWebGrid1
, "cBox"
, "selchk"
, new string[] { "MENU_REF_ID", "UP_MENU_ID", "MENU_NAME", "MENU_DIR", "MENU_PAGE_NAME", "MENU_PARAM", "MENU_FULL_PATH"
, "MENU_DESC", "MENU_PRIORITY", "MENU_AUTH_TYPE", "MENU_TYPE", "MENU_NAME_IMAGE_PATH", "MENU_NAME_IMAGE_PATH_U"
, "MENU_PREV_ICON_PATH", "MENU_CREATE_DATE", "SHOW_LEFT_MENU" }
, dataTable);
bool isOK = objMenuInfo.RemoveMenuinfo(dataTable);
if (!isOK)
{
lblScript.Text = JSHelper.GetAlertScript("삭제할 메뉴를 체크해주세요.", false);
}
else
{
lblScript.Text = JSHelper.GetAlertScript("메뉴를 삭제하였습니다.", false);
GridBindginMenu();
}
}
protected void iBtnConfirm_Click(object sender, ImageClickEventArgs e)
{
int effrctRow = 0;
Biz_QuestionDeptEmpMaps questionDeptEmpMaps = new Biz_QuestionDeptEmpMaps();
DataTable dataTable = questionDeptEmpMaps.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid2
, new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
effrctRow += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiAutoInsert(ESTTERM_REF_ID, view_ref_id, stg_ref_id, poo_ref_id,
int.Parse(dataRow["TGT_DEPT_ID"].ToString()), int.Parse(dataRow["TGT_EMP_ID"].ToString()));
}
if (effrctRow > 0)
{
ltrScript.Text = JSHelper.GetOpenerControlCallBackScript(POSTBACK_CTRL_NAME, true);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("추가하실 사원을 선택하세요.");
}
}
private void DeleteEmpEstProjectMapGrid()
{
Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap();
DataTable dataTable = objPrjEmpEstPrjMap.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(ugrdPrjList
, "cBox"
, "selchk"
, new string[] { "PRJ_REF_ID", "EST_DEPT_ID", "EST_EMP_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dataRow["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID;
}
bool isOK = objPrjEmpEstPrjMap.RemovePrjEmpEstPrjMap(dataTable);
if (!isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("삭제할 항목을 선택주세요.", false);
}
else
{
BindingProjectMap();
}
}
protected void ibnDeleteRelGrpDept_Click(object sender, ImageClickEventArgs e)
{
Biz_RelGroupDepts relGrpDept = new Biz_RelGroupDepts();
DataTable dataTable = relGrpDept.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(uwgRelGroupDept
, "cBox"
, "selchk"
, new string[] { "DEPT_REF_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["REL_GRP_ID"] = REL_GRP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = relGrpDept.RemoveRelGroupDept(dataTable);
if (isOK)
{
BindingRelGroupDept(COMP_ID, REL_GRP_ID, EST_ID, ESTTERM_REF_ID);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("부서 저장 중 오류가 발생하였습니다.");
}
}
private void DeleteQuestionDeptEmpMapGrid()
{
Biz_QuestionDeptEmpMaps questionDeptEmpMaps = new Biz_QuestionDeptEmpMaps();
DataTable dataTable = questionDeptEmpMaps.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid2
, "cBox"
, "selchk"
, new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["Q_OBJ_ID"] = hdfQObjID.Value;
}
bool isOK = questionDeptEmpMaps.RemoveQuestionDeptEmpMap(dataTable);
if (!isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("삭제할 항목을 선택주세요.", false);
}
else
{
BindQuestionDeptEmpMapGrid();
}
}
protected void ibnSave_Click(object sender, ImageClickEventArgs e)
{
Biz_ButtonCommandRoleMaps btnCmdRoleMap = new Biz_ButtonCommandRoleMaps();
DataTable dataTable = btnCmdRoleMap.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid2
, "cBox"
, "selchk"
, new string[] { "COMMAND_NAME" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["ROLE_REF_ID"] = hdfRoleRefID.Value;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = btnCmdRoleMap.SaveButtonCommandRoleMap(dataTable, DataTypeUtility.GetToInt32(hdfRoleRefID.Value));
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다.", false);
//if (isOK)
//{
// ltrScript.Text = JSHelper.GetAlertScript("삭제할 항목을 선택주세요.", false);
// return;
//}
//else
//{
// //ltrScript.Text = JSHelper.GetAlertScript("삭제할 항목을 선택주세요.", false);
//}
}
private void Binding(int comp_id, string est_id)
{
Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id);
if (!estInfo.IsExists(comp_id, est_id))
{
ltrScript.Text = JSHelper.GetAlertScript("선택된 회사의 평가정보가 없습니다.");
ClearValueControls();
return;
}
if (estInfo.Owner_Type.Equals("D"))
{
OwnerTypeMode = OwnerType.Dept;
lblTitle1.Text = "질의 응답 부서 리스트";
// 질의 응답 부서 리스트
//imgTitle.ImageUrl = "../images/title/ta_t16.gif";
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("DEPT_NAME").Width = Unit.Pixel(300);
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("DEPT_NAME").Hidden = false;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("EMP_NAME").Hidden = true;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("POS_CLS_NAME").Hidden = true;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("POS_RNK_NAME").Hidden = true;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("POS_DUT_NAME").Hidden = true;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("POS_GRP_NAME").Hidden = true;
}
else
{
OwnerTypeMode = OwnerType.Emp_User;
lblTitle1.Text = "질의 응답 사원 리스트";
// 질의 응답 사원 리스트
//imgTitle.ImageUrl = "../images/title/ta_t17.gif";
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("DEPT_NAME").Width = Unit.Pixel(200);
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("DEPT_NAME").Hidden = false;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("EMP_NAME").Hidden = false;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("POS_CLS_NAME").Hidden = false;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("POS_RNK_NAME").Hidden = false;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("POS_DUT_NAME").Hidden = false;
UltraWebGrid2.DisplayLayout.Bands[0].Columns.FromKey("POS_GRP_NAME").Hidden = false;
}
UltraGridUtility.VisiblePosColumn(UltraWebGrid2.DisplayLayout.Bands[0].Columns);
DropDownListCommom.BindEstTermSub(ddlEstTermSubID, comp_id, est_id, "");
DropDownListCommom.BindEstTermStep(ddlEstTermStepID, comp_id, est_id);
BindQuestionGrid();
EstJobUtility.SetConfirmButtonVisible(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_JOB_ID
, ibnConfirm
, ibnConfirmCancel);
//imgQDeptEmpMap.Visible = true;
}
protected void ibtnDelEmp_Click(object sender, ImageClickEventArgs e)
{
UltraGridUtility.SetRemoveRow(UltraWebGrid2
, "cBox"
, "selchk");
lblSelect.Text = UltraWebGrid2.Rows.Count.ToString();
}
protected bool doDelete_Est_Target_Pool()
{
DataTable DT = UltraGridUtility.GetDataSetByCheckedBox(UltraWebGrid1
, new string[] { "DEPT_ID" }
, "selchk"
, "cBox").Tables[0];
int affectedRow = bizMulEstTargetPool.Remove_Tgt_Emp_Pool(DT, COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID);
return(affectedRow > 0 ? true : false);
}
protected void ibnCancelEstQ_Click(object sender, ImageClickEventArgs e)
{
Biz_Prj_Data objPrjData = new Biz_Prj_Data();
DataTable dataTable = objPrjData.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
, "cBox"
, "selchk"
, new string[] { "EST_DEPT_ID", "EST_EMP_ID", "PRJ_REF_ID", "STATUS_ID" }
, dataTable);
if (dataTable.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("상태가 평가완료가 아니거나 선택된 항목이 없습니다.");
return;
}
else
{
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "STATUS_ID = 'E'");
}
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dataRow["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID;
dataRow["STATUS_ID"] = "P";
}
bool isOK = objPrjData.SaveStatus(dataTable);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 질의평가를 취소하였습니다.");
GridBidingData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EMP_REF_ID
, SEARCH_ALL);
SetConfirmStatusHtml(EST_JOB_IDS);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 취소되지 않았습니다.");
}
}
protected void ibnSave_Click(object sender, ImageClickEventArgs e)
{
UltraGridRow row;
Biz_DeptOpinionTgtEmps deptOpinionTgtEmp = new Biz_DeptOpinionTgtEmps();
DataTable dataTable = deptOpinionTgtEmp.GetDataTableSchema();
for (int i = 0; i < UltraWebGrid1.Rows.Count; i++)
{
row = UltraWebGrid1.Rows[i];
TemplatedColumn hdf_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP");
HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[row.BandIndex]).FindControl("hdfTgtEmpID");
TemplatedColumn txt_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP");
TextBox txtTgtEmpName = (TextBox)((CellItem)txt_col.CellItems[row.BandIndex]).FindControl("txtTgtEmpName");
if (hdfTgtEmpID.Value.Equals(""))
{
row.Cells.FromKey("TGT_EMP_ID").Value = DBNull.Value;
}
else
{
row.Cells.FromKey("TGT_EMP_ID").Value = DataTypeUtility.GetToDouble(hdfTgtEmpID.Value);
}
}
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid1
, new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" }
, dataTable);
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "TGT_EMP_ID IS NOT NULL");
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["TGT_OPINION_YN"] = "Y";
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = deptOpinionTgtEmp.SaveDeptOpinionTgtEmp(dataTable, COMP_ID, EST_ID);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 의견상신 담당자를 설정하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.");
}
}
protected void lbnSavePOS_Click(object sender, EventArgs e)
{
Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales();
Biz_DeptInfos deptInfo = new Biz_DeptInfos();
DataTable dataTable = deptPosScale.GetDataTableSchema();
DataTable dtDept = deptInfo.GetDataTableSchema();
DataRow drRow = null;
string[] dept_values = hdfDeptID.Value.Split(',');
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid3
, new string[] { "SEQ", "POS_ID", "POS_VALUE", "SCALE_ID" }
, dataTable);
foreach (string dept_value in dept_values)
{
drRow = dtDept.NewRow();
drRow["DEPT_REF_ID"] = DataTypeUtility.GetToInt32(dept_value);
dtDept.Rows.Add(drRow);
}
if (dataTable.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("적용하려는 부서별 평가방법이 없습니다.");
return;
}
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = deptPosScale.SaveDeptPosScaleAll(dtDept, dataTable);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("선택부서의 평가방법을 일괄 적용하였습니다.");
GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID);
UltraWebGrid3.Clear();
hdfDeptID.Value = "";
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리 않았습니다.");
}
}
protected void ibnUpdate_Click(object sender, ImageClickEventArgs e)
{
Biz_EmpInfos empInfo = new Biz_EmpInfos();
DataTable dataTable = empInfo.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
, "cBox"
, "selchk"
, new string[] { "EMP_REF_ID" }
, dataTable);
if (dataTable.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("평가데이터에 직급,직책을 반영하려는 사원이 선택되지 않았습니다.");
return;
}
string emp_ref_ids = "";
bool isFirst = true;
foreach (DataRow dataRow in dataTable.Rows)
{
if (isFirst)
{
isFirst = false;
emp_ref_ids += DataTypeUtility.GetValue(dataRow["EMP_REF_ID"]);
}
else
{
emp_ref_ids += "," + DataTypeUtility.GetValue(dataRow["EMP_REF_ID"]);
}
}
string ctrlID = (sender as ImageButton).ID;
string type = "";
if (ctrlID.Equals("ibnUpdatePos"))
{
type = "POS";
}
else if (ctrlID.Equals("ibnUpdateDpt"))
{
type = "DPT";
}
WebUtility.PopupPage(ltrScript
, "../EST/EST060602.aspx?EMP_REF_IDS=" + emp_ref_ids + "&TYPE=" + type
, 400
, 120
, "popup_pos");
}
protected bool Confirm_SelfEst()
{
int new_status_seq = 3;//자기평가 완료
int increment_seq = 1;
//데이터 수집
DataTable dt = new DataTable();
string[] cols = new string[this.UltraWebGrid1.Columns.Count - 1];
for (int i = 1; i < this.UltraWebGrid1.Columns.Count; i++)
{
cols[i - 1] = this.UltraWebGrid1.Columns[i].Key;
dt.Columns.Add(cols[i - 1]);
}
dt = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1, "cBox", "selchk", cols, dt);
//데이터 가공 및 검증
for (int i = 0; i < dt.Rows.Count; i++)
{
string status_id = DataTypeUtility.GetString(dt.Rows[i]["STATUS_ID"]);
Biz_Est_Data bizEstData = new Biz_Est_Data();
Biz_Status new_status = bizEstData.Get_New_Est_Status(COMP_ID, EST_ID, status_id, new_status_seq, increment_seq);
if (new_status.Status_ID != null && new_status.Status_ID.Trim().Length > 0)
{
dt.Rows[i]["STATUS_ID"] = new_status.Status_ID;
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 단계로 진행할 수 없는 데이터가 있습니다.", new_status.Status_Name));
return(false);
}
}
dt = Add_Date_User(dt);
//데이터 저장
Biz_Datas datas = new Biz_Datas();
return(datas.SaveStatus(dt));
}
protected void ibnUpdateEmpRole_Click(object sender, ImageClickEventArgs e)
{
UltraGridRow row;
Biz_EmpRoleRels empRoleRel = new Biz_EmpRoleRels();
Biz_DeptOpinionTgtEmps deptOpinionTgtEmp = new Biz_DeptOpinionTgtEmps();
DataTable dataTable = deptOpinionTgtEmp.GetDataTableSchema();
dataTable.Columns.Add("EMP_REF_ID", typeof(int));
dataTable.Columns.Add("ROLE_REF_ID", typeof(int));
for (int i = 0; i < UltraWebGrid1.Rows.Count; i++)
{
row = UltraWebGrid1.Rows[i];
TemplatedColumn hdf_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP");
HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[row.BandIndex]).FindControl("hdfTgtEmpID");
if (hdfTgtEmpID.Value.Equals(""))
{
row.Cells.FromKey("TGT_EMP_ID").Value = DBNull.Value;
}
else
{
row.Cells.FromKey("TGT_EMP_ID").Value = DataTypeUtility.GetToDouble(hdfTgtEmpID.Value);
}
}
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid1
, new string[] { "TGT_EMP_ID" }
, dataTable);
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "TGT_EMP_ID IS NOT NULL");
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["EMP_REF_ID"] = dataRow["TGT_EMP_ID"];
dataRow["ROLE_REF_ID"] = ROLE_REF_ID;
}
bool isOK = empRoleRel.SaveEmpRoleRel(dataTable, ROLE_REF_ID);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 의견상신 담당자 권한을 부여하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("부여된 권한이 없습니다.");
}
}
protected DataTable Collect_CheckedData()
{
DataTable dt = new DataTable();
string[] cols = new string[this.UltraWebGrid1.Columns.Count - 1];
for (int i = 1; i < this.UltraWebGrid1.Columns.Count; i++)
{
cols[i - 1] = this.UltraWebGrid1.Columns[i].Key;
dt.Columns.Add(cols[i - 1]);
}
dt = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1, "cBox", "selchk", cols, dt);
return(dt);
}
protected void ibnSavePosAll_Click(object sender, ImageClickEventArgs e)
{
Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales();
Biz_DeptInfos deptInfo = new Biz_DeptInfos();
DataTable dataTable = deptPosScale.GetDataTableSchema();
DataTable dtDept = deptInfo.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid3
, new string[] { "SEQ", "POS_ID", "POS_VALUE", "SCALE_ID" }
, dataTable);
dtDept = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid2
, new string[] { "DEPT_REF_ID" }
, dtDept);
if (dataTable.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("적용하려는 부서별 평가방법이 없습니다.");
return;
}
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = deptPosScale.SaveDeptPosScaleAll(dtDept, dataTable);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("모든 부서의 평가방법을 일괄 적용하였습니다.");
GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID);
UltraWebGrid3.Clear();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리 않았습니다.");
}
}
protected void ibnInit2_Click(object sender, ImageClickEventArgs e)
{
Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales();
Biz_DeptInfos deptInfo = new Biz_DeptInfos();
DataTable dataTable = deptPosScale.GetDataTableSchema();
DataTable dtDept = deptInfo.GetDataTableSchema();
dtDept.Columns.Add("COMP_ID", typeof(int));
dtDept.Columns.Add("EST_ID", typeof(string));
dtDept.Columns.Add("ESTTERM_REF_ID", typeof(int));
dtDept = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid2
, "cBox"
, "selchk"
, new string[] { "DEPT_REF_ID" }
, dtDept);
if (dtDept.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("초기화하려는 부서를 선택하세요.");
return;
}
foreach (DataRow dataRow in dtDept.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
}
bool isOK = deptPosScale.InitDept(dtDept);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 선택부서를 초기화 하였습니다.");
GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID);
UltraWebGrid3.Clear();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리되지 않았습니다.");
}
}
protected void ibtnDelete_Click(object sender, ImageClickEventArgs e)
{
DataTable dtDelete = new DataTable();
dtDelete.Columns.Add("KPI_REF_ID", typeof(string));
dtDelete = UltraGridUtility.GetDataTableByCheckValue(ugrdGroupList, "cBox", "selchk", new string[] { "KPI_REF_ID" }, dtDelete);
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Group bizBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Group();
if (bizBSC.DeleteIssueGroupMap(this.IESTTERM_REF_ID, PageUtility.GetIntByValueDropDownList(ddlGroup), dtDelete))
{
DoBinding();
DoBindingList();
ltrScript.Text = JSHelper.GetAlertScript("삭제하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("삭제 실패!");
}
}
protected void ibnAssingEstData_Click(object sender, ImageClickEventArgs e)
{
MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data();
Biz_Datas biz_data = new Biz_Datas();
DataTable dataTable = biz_data.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
, "cBox"
, "selchk"
, new string[] { "ESTTERM_STEP_ID", "EST_DEPT_ID", "EST_EMP_ID", "TGT_DEPT_ID", "TGT_EMP_ID", "TGT_POS_CLS_ID", "TGT_POS_CLS_NAME", "TGT_POS_DUT_ID", "TGT_POS_DUT_NAME", "TGT_POS_GRP_ID", "TGT_POS_GRP_NAME", "TGT_POS_RNK_ID", "TGT_POS_RNK_NAME", "TGT_POS_KND_ID", "TGT_POS_KND_NAME", "DIRECTION_TYPE" }
, dataTable);
if (dataTable.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("평가를 반영하려는 항목이 선택되지 않았습니다.");
return;
}
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = bizEstData.CopyTgtMapDataToEstDataBySelectedItem(dataTable, OwnerTypeMode);
//bool isOK = biz_data.CopyTgtMapDataToEstDataBySelectedItem(dataTable, OwnerTypeMode);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 평가데이터로 확정하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.");
}
}
protected void ibnSave_Click(object sender, ImageClickEventArgs e)
{
if (TGT_EMP_ID.Equals(""))
{
ltrScript.Text = JSHelper.GetAlertScript("선택된 피평가자가 없습니다.");
return;
}
Biz_EmpPositionBizMaps empPosBizMap = new Biz_EmpPositionBizMaps();
DataTable dataTable = empPosBizMap.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid2
, "cBox"
, "selchk"
, new string[] { "POS_BIZ_ID" }
, dataTable);
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["EMP_REF_ID"] = TGT_EMP_ID;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = empPosBizMap.SavePosBizMap(dataTable, TGT_EMP_ID);
if (isOK)
{
BindingPosBizByTgt();
BindingEmp();
hdfTgtEmpID.Value = "";
hdfTgtPosKndID.Value = "";
UltraWebGrid2.Clear();
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 직무설정 되었습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.");
}
}
