protected void doBind_prjEmp() { UltraWebGrid2.Clear(); MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data(); DT_EMP_EST_DATA = bizEstData.GetEstData(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, DIRECTION_TYPE, EST_EMP_ID, 0); MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data(); string est_id = "3Q";//프로젝트 기여도 평가 EST_ID DT_PRJ_DATA = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID , COMP_ID , est_id , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID); DataTable dtPrj_PM_Data = DataTypeUtility.FilterSortDataTable(DT_PRJ_DATA, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1"); object point = dtPrj_PM_Data.Rows[0]["POINT"]; PRJ_POINT = DataTypeUtility.GetString(point); UltraWebGrid2.DataSource = DT_PRJ_DATA; UltraWebGrid2.DataBind(); }
protected void ibnCalcEmpEstPoint_Click(object sender, EventArgs e) { if (DT_ENDED_PRJ == null) { string est_id = "3Q"; MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data(); DT_ENDED_PRJ = bizPrjData.Get_Ended_Prj_Est(COMP_ID, est_id, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID); } DT_FINAL_POINT = new DataTable(); DT_FINAL_POINT.Columns.Add("TGT_DEPT_ID"); DT_FINAL_POINT.Columns.Add("TGT_EMP_ID"); DT_FINAL_POINT.Columns.Add("TGT_POS_CLS_ID"); DT_FINAL_POINT.Columns.Add("TGT_POS_CLS_NAME"); DT_FINAL_POINT.Columns.Add("TGT_POS_DUT_ID"); DT_FINAL_POINT.Columns.Add("TGT_POS_DUT_NAME"); DT_FINAL_POINT.Columns.Add("TGT_POS_GRP_ID"); DT_FINAL_POINT.Columns.Add("TGT_POS_GRP_NAME"); DT_FINAL_POINT.Columns.Add("TGT_POS_RNK_ID"); DT_FINAL_POINT.Columns.Add("TGT_POS_RNK_NAME"); DT_FINAL_POINT.Columns.Add("TGT_POS_KND_ID"); DT_FINAL_POINT.Columns.Add("TGT_POS_KND_NAME"); DT_FINAL_POINT.Columns.Add("POINT_ORG"); DT_FINAL_POINT.Columns.Add("POINT"); Calculate_Emp_Prj_Point(); }
protected void Page_Load(object sender, EventArgs e) { bizPmsColInfo = new Biz_Pms_Col_Info(); bizPrjData = new Biz_Prj_Data(); PRJ_REF_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("PRJ_REF_ID")); PRJ_CODE = WebUtility.GetRequest("PRJ_CODE"); COMP_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("COMP_ID")); EST_ID = WebUtility.GetRequest("EST_ID"); ESTTERM_REF_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("ESTTERM_REF_ID")); ESTTERM_SUB_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("ESTTERM_SUB_ID")); ESTTERM_STEP_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("ESTTERM_STEP_ID")); EST_DEPT_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("EST_DEPT_ID")); EST_EMP_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("EST_EMP_ID")); ltrScript.Text = ""; if (!IsPostBack && PRJ_REF_ID > 0 && PRJ_CODE.Length > 0) { Weight_Col_Bind(); Difficulty_Col_Bind(); Common_Soosik_Bind(); Prj_Est_Point_Bind(); SetBottons(); } Prj_Data_Bind(); }
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 ibnConfirm_Click(object sender, ImageClickEventArgs e) { //bool isJobOK = EstJobUtility.SetConfirmButtonVisible(COMP_ID // , EST_ID // , ESTTERM_REF_ID // , ESTTERM_SUB_ID // , ESTTERM_STEP_ID // , EST_JOB_ID // , ibnConfirm // , ibnConfirmCancel // , "Y" // , DateTime.Now // , EMP_REF_ID // , ltrScript); //// 만약 이전에 처리하지 않은 작업이 있다면 아래의 내용을 처리하지 못함 //if (!isJobOK) // return; Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap(); DataTable dataTable = objPrjEmpEstPrjMap.GetPrjEmpEstPrjMap(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , 0 , 0 , 0).Tables[0]; dataTable.Columns.Add("DATE", typeof(DateTime)); dataTable.Columns.Add("USER", typeof(int)); foreach (DataRow dataRow in dataTable.Rows) { dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; } Biz_Prj_Data objPrjData = new Biz_Prj_Data(); bool isOK = objPrjData.CopyTgtMapDataToEstData(dataTable); if (isOK) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 평가자/사업관리 매핑정보를 평가리스트로 설정 및 확정하였습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("설정 중 오류가 발생하였습니다."); } }
protected void doBind_project() { UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); string est_id = "3Q"; MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data(); DT_ENDED_PRJ = bizPrjData.Get_Ended_Prj_Est(COMP_ID, est_id, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID); this.lblRowCount.Text = DT_ENDED_PRJ.Rows.Count.ToString(); UltraWebGrid1.DataSource = DT_ENDED_PRJ; UltraWebGrid1.DataBind(); }
private void SaveQuestionData_TGT_ID() { Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(); Biz_Prj_Data datas = new Biz_Prj_Data(); DataTable dtQData = questionDatas.GetDataTableSchema(); dtQData = GetQuestionDataTable(dtQData, DataList1); dtQData = GetQuestionSubDataTable(dtQData, DataList2); DataTable dtPrjData = AddNewPrjDataRow(datas.GetDataTableSchema(), dtQData); bool isSuccessed = questionDatas.SaveQuestionData_TGT_ID(dtQData, dtPrjData); if (!isSuccessed) { ltrScript.Text = JSHelper.GetAlertScript("데이터 저장 중 실패하였습니다.", false); return; } ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 저장되었습니다.", "lbnReload", true); }
protected void Page_Load(object sender, EventArgs e) { bizPrjInfo = new Biz_Prj_Info(); bizPrjData = new Biz_Prj_Data(); if (!IsPostBack) { DropDownListCommom.BindComp(ddlCompID, lblCompTitle); DropDownListCommom.BindEstTerm(ddlEstTermRefID); DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID, WebUtility.GetIntByValueDropDownList(ddlCompID), "N"); } COMP_ID = WebUtility.GetIntByValueDropDownList(ddlCompID); ESTTERM_REF_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermRefID); ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID); ESTTERM_STEP_ID = 2; EST_ID = "3P"; //프로젝트 평가 DIRECTION_TYPE = "DN"; //하향식평가 STATUS_ID = "E"; //점수 산정 완료 ltrScript.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { quizWeight = new DataTable(); } COMP_ID = WebUtility.GetRequestByInt("COMP_ID"); EST_ID = WebUtility.GetRequest("EST_ID"); ESTTERM_REF_ID = WebUtility.GetRequestByInt("ESTTERM_REF_ID"); ESTTERM_SUB_ID = WebUtility.GetRequestByInt("ESTTERM_SUB_ID"); ESTTERM_STEP_ID = WebUtility.GetRequestByInt("ESTTERM_STEP_ID"); EST_DEPT_ID = WebUtility.GetRequestByInt("EST_DEPT_ID"); EST_EMP_ID = WebUtility.GetRequestByInt("EST_EMP_ID"); PRJ_REF_ID = WebUtility.GetRequestByInt("PRJ_REF_ID"); EST_TGT_TYPE = WebUtility.GetRequest("EST_TGT_TYPE", "EST"); TGT_DEPT_ID = WebUtility.GetRequestByInt("TGT_DEPT_ID", 0); TGT_EMP_ID = WebUtility.GetRequestByInt("TGT_EMP_ID", 0); READ_ONLY_YN = WebUtility.GetRequest("READ_ONLY_YN", "N"); _estInfos = new Biz_EstInfos(COMP_ID, EST_ID); _q_item_desc_use_yn = _estInfos.Q_Item_Desc_Use_YN; //PRJ_TYPE Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(PRJ_REF_ID); PRJ_TYPE = objPrjInfo.IPrj_Type; if (READ_ONLY_YN.Equals("N")) { Biz_TermInfos termInfos = new Biz_TermInfos(ESTTERM_REF_ID); Biz_TermSubs termSubs = new Biz_TermSubs(COMP_ID, ESTTERM_SUB_ID); Biz_TermSteps termSteps = new Biz_TermSteps(COMP_ID, ESTTERM_STEP_ID); Biz_EmpInfos estEmpInfos = new Biz_EmpInfos(EST_EMP_ID); Biz_EmpInfos tgtEmpInfos = new Biz_EmpInfos(TGT_EMP_ID); //Biz_DeptInfos estDeptInfo = new Biz_DeptInfos(EST_DEPT_ID); MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info bizComDeptInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info(EST_DEPT_ID); MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info tgtDeptInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info(TGT_DEPT_ID); //Biz_Prj_Data data = new Biz_Prj_Data(COMP_ID // , EST_ID // , ESTTERM_REF_ID // , ESTTERM_SUB_ID // , ESTTERM_STEP_ID // , EST_DEPT_ID // , EST_EMP_ID // , PRJ_REF_ID); _status_style_id = _estInfos.Status_Style_ID; Biz_Prj_QuestionPrjMap objQuestionPrjMap = new Biz_Prj_QuestionPrjMap(COMP_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , 0 , EST_ID , "" , PRJ_REF_ID); if (objQuestionPrjMap.Q_Obj_ID == null) { ltrScript.Text = JSHelper.GetAlertScript("프로젝트사업명에 대한 평가질의서가 매핑되지 않았습니다.", true); return; } // 창을 띄은 사람이 평가자 인지 체크 if (EST_EMP_ID == EMP_REF_ID) { _status_id = "P"; ibnSaveEst.Visible = true; } //else //{ // ibnSaveEst.Visible = false; // // 롤에 따른 버튼 권한이 있는지 확인 // //BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, ibnSaveEst); //} Q_OBJ_ID = objQuestionPrjMap.Q_Obj_ID; EST_NAME = _estInfos.Est_Name; ESTTERM_REF_NAME = termInfos.EstTerm_Name; ESTTERM_SUB_NAME = termSubs.EstTerm_Sub_Name; ESTTERM_STEP_NAME = termSteps.EstTerm_Step_Name; EST_EMP_NAME = estEmpInfos.Emp_Name; EST_DEPT_NAME = bizComDeptInfo.DEPT_NAME; //estDeptInfo.Dept_Name; TGT_EMP_NAME = tgtEmpInfos.Emp_Name; TGT_DEPT_NAME = tgtDeptInfo.DEPT_NAME; //tgtDeptInfo.Dept_Name; PRJ_NAME = objPrjInfo.IPrj_Name; PRJ_CODE = objPrjInfo.IPrj_Code; } else { Q_OBJ_ID = WebUtility.GetRequest("Q_OBJ_ID"); ibnSaveEst.Visible = false; } if (!Page.IsPostBack) { SetLabelText(); //임의수정 Biz_Prj_Data bizPrjData = new Biz_Prj_Data(); DataTable dt = bizPrjData.GetPrjData(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, PRJ_REF_ID, "", "").Tables[0]; string Status_ID = ""; if (dt != null && dt.Rows.Count > 0) { Status_ID = dt.Rows[0]["STATUS_ID"].ToString(); } if (Status_ID.Equals("E")) { ibnSaveEst.Visible = false; } DataListBinding(dt); ibnSaveEst.Attributes.Add("onclick", "if(confirm('평가내용을 저장하시겠습니까?')) return ConfirmQuesiton();else return false;"); } ltrScript.Text = ""; }
/// <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 , int est_emp_id , bool isAll) { Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id); if (!estInfo.IsExists(comp_id, est_id)) { ltrScript.Text = JSHelper.GetAlertScript("선택된 회사의 평가정보가 없습니다."); return; } DropDownListCommom.BindEstTermSub(ddlEstTermSubID, comp_id, est_id, ""); DropDownListCommom.BindEstTermStep(ddlEstTermStepID, comp_id, est_id); // 처음 실행될때 if (estterm_sub_id.Equals(0)) { ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID); } // 만약 주기가 년간일 경우 if (YEAR_YN.Equals("Y")) { ESTTERM_SUB_ID = BizUtility.GetEstTermSubIDByYearYN(COMP_ID); } // 만약 차수가 합산일 경우 if (MERGE_YN.Equals("Y")) { ESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID); } else { // 만약 모든 차수를 보여 줘야하는 경우 if (ESTTERM_STEP_ALL_USE_YN.Equals("Y")) { ESTTERM_STEP_ID = 0; ddlEstTermStepID.Visible = false; } } WebUtility.FindByValueDropDownList(ddlEstTermRefID, estterm_ref_id); if (ddlEstTermSubID.Visible) { WebUtility.FindByValueDropDownList(ddlEstTermSubID, estterm_sub_id); } if (ddlEstTermStepID.Visible) { WebUtility.FindByValueDropDownList(ddlEstTermStepID, estterm_step_id); } // 상태 html HtmlScriptCommon.CreateStatusHtmlTable(tblViewStatus, est_id); Biz_Prj_Data objPrjData = new Biz_Prj_Data(); if (isAll) { est_emp_id = 0; } DataTable dt = objPrjData.GetPrjData(comp_id , est_id , estterm_ref_id , estterm_sub_id , estterm_step_id , 0 , est_emp_id , 0 , YEAR_YN , MERGE_YN).Tables[0]; UltraWebGrid1.Clear(); UltraWebGrid1.DataSource = dt; UltraWebGrid1.DataBind(); lblRowCount.Text = dt.Rows.Count.ToString(); }
protected void ibnProjectToEmpData_Click(object sender, ImageClickEventArgs e) { ImageButton ibn = ((ImageButton)sender); string est_job_id = ibn.CommandArgument; //bool isJobOK = EstJobUtility.SetConfirmButtonVisible(COMP_ID // , EST_ID // , ESTTERM_REF_ID // , ESTTERM_SUB_ID // , ESTTERM_STEP_ID // , est_job_id // ibnDownExcel , ibn // , null // , "Y" // , DateTime.Now // , EMP_REF_ID // , ltrScript); //if (!isJobOK) // return; Biz_Prj_Data data = new Biz_Prj_Data(); bool isOK = data.CopyProjectToEmpData(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , YEAR_YN , MERGE_YN , DateTime.Now , EMP_REF_ID); 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 { //EstJobUtility.SetConfirmButtonVisible(COMP_ID // , EST_ID // , ESTTERM_REF_ID // , ESTTERM_SUB_ID // , ESTTERM_STEP_ID // , est_job_id // , ibn // , null // , "N" // , DateTime.Now // , EMP_REF_ID // , ltrScript); ltrScript.Text = JSHelper.GetAlertScript("프로젝트 평가 정보를 사원 평가 정보로 변환 중 오류가 발생하였습니다."); } }
protected void ibnAggEstTermStep_Click(object sender, ImageClickEventArgs e) { ImageButton ibn = ((ImageButton)sender); string est_job_id = ibn.CommandArgument; bool isJobOK = EstJobUtility.SetConfirmButtonVisible(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , est_job_id , ibnAggEstTermStep , null , "Y" , DateTime.Now , EMP_REF_ID , ltrScript); if (!isJobOK) { return; } Biz_Prj_Data objPrjData = new Biz_Prj_Data(); DataTable dtStatusCheck = objPrjData.GetDataByMergeYN(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , MERGE_YN).Tables[0]; if (dtStatusCheck.Rows.Count != dtStatusCheck.Select("STATUS_ID = 'E'").Length) { ltrScript.Text = JSHelper.GetAlertScript("확정되지 않은 평가정보가 있습니다. 모두 확정된 상태에서 차수별 합산이 가능합니다."); return; } //, BizUtility.GetTotalWeightEstTermStep(COMP_ID, EST_ID) // MERGE_YN 이 N 인 이유는 N인 것만 데이터를 수집해서 집계하기 때문 bool isOK = objPrjData.AggregateEstTermStepEstData(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , BizUtility.GetTotalWeightEstTermStep(COMP_ID, EST_ID) , YEAR_YN , "N"); 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 { //EstJobUtility.SetConfirmButtonVisible(COMP_ID // , EST_ID // , ESTTERM_REF_ID // , ESTTERM_SUB_ID // , ESTTERM_STEP_ID // , est_job_id // , ibn // , null // , "N" // , DateTime.Now // , EMP_REF_ID // , ltrScript); ltrScript.Text = JSHelper.GetAlertScript("가중치 집계 처리 중 오류가 발생하였습니다."); } }