private void BindingTgtEmp(int est_emp_id) { Biz_Datas data = new Biz_Datas(); DataTable dataTable = data.GetEstData(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , 0 , est_emp_id , 0 , 0 , YEAR_YN , MERGE_YN , OwnerType.Emp_User).Tables[0]; dataTable = DataTypeUtility.GetGroupByDataTable(dataTable , new string[] { "TGT_EMP_ID", "TGT_EMP_NAME", "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" }); dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "", "TGT_EMP_NAME"); UltraWebGrid1.DataSource = dataTable; UltraWebGrid1.DataBind(); lblRowCount.Text = dataTable.Rows.Count.ToString("#,##0"); }
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(); }
private void DoBinding_Emp(int dept_ref_id) { DataTable dtDeptEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID = {0} ", dept_ref_id), " EMP_NAME "); UltraWebGrid2.DataSource = dtDeptEmp; UltraWebGrid2.DataBind(); //if (rdoEstTypeList.SelectedIndex.Equals(0)) //{ // MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp bizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp(); //} //else //{ //} if (dtDeptEmp.Rows.Count > 0) { ibnEmp.Enabled = true; } else { ibnEmp.Enabled = false; } }
protected void UltraWebGrid2_InitializeRow(object sender, RowEventArgs e) { //프로젝트 평가점수 바인딩 e.Row.Cells.FromKey("PRJ_POINT").Value = PRJ_POINT; //개인종합평가 평가점수 바인딩 string tgt_dept_id = e.Row.Cells.FromKey("TGT_DEPT_ID").Value.ToString(); string tgt_emp_id = e.Row.Cells.FromKey("TGT_EMP_ID").Value.ToString(); string filter = string.Format("TGT_DEPT_ID={0} AND TGT_EMP_ID={1}", tgt_dept_id, tgt_emp_id); DataTable empEstInfo = DataTypeUtility.FilterSortDataTable(DT_EMP_EST_DATA, filter); string point = ""; if (empEstInfo.Rows.Count > 0) { point = DataTypeUtility.GetString(empEstInfo.Rows[0]["POINT"]); } if (point.Trim().Length == 0) { point = "-"; } e.Row.Cells.FromKey("EST_POINT").Value = point; //PM일 경우 처리 if (tgt_dept_id.Equals("-1") && tgt_emp_id.Equals("-1")) { e.Row.Cells.FromKey("POINT").Value = "-"; e.Row.Cells.FromKey("TGT_DEPT_NAME").Value = DT_PRJ_DATA.Rows[0]["EST_DEPT_NAME"]; e.Row.Cells.FromKey("TGT_EMP_NAME").Value = DT_PRJ_DATA.Rows[0]["EST_EMP_NAME"]; } }
private void DoBinding_EST(int est_emp_id) { DataTable dtEST = DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, string.Format(" TGT_EMP_ID = {0} ", est_emp_id), " EST_DEPT_NAME, EST_EMP_NAME "); UltraWebGrid3.DataSource = dtEST; UltraWebGrid3.DataBind(); }
private void DataBinding() { DataTable dt = null; if (BU.Equals("DD")) { dt = DS_DATA.Tables[0]; } else if (BU.Equals("DO")) { dt = DS_DATA.Tables[1]; } else if (BU.Equals("CJ")) { dt = DS_DATA.Tables[2]; } else { return; } DataTable dtChart = DataTypeUtility.FilterSortDataTable(dt, "CHART_USE = 'Y'"); DataTable dtGrid = DataTypeUtility.FilterSortDataTable(dt, "GRID_USE = 'Y'"); uGrid.DataSource = dtGrid; uGrid.DataBind(); BindChart(Chart1 , dtChart , "계획대비 실적"); }
protected void ibnAddEstData_Click(object sender, ImageClickEventArgs e) { int cnt = UltraWebGrid1.Rows.Count; string dept_ref_id_list = string.Empty; for (int i = 0; i < cnt; i++) { UltraGridRow row = UltraWebGrid1.Rows[i]; TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox"); if (cBox.Checked) { dept_ref_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("DEPT_REF_ID").Value); } } if (dept_ref_id_list.Length > 0) { dept_ref_id_list = dept_ref_id_list.Remove(0, 1); } else { dept_ref_id_list = "-1"; } DataTable dtEmp = DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, string.Format(" TGT_DEPT_ID IN ({0}) AND DIRECTION_TYPE = '{1}' ", dept_ref_id_list, ConDIRECTION_TYPE)); DataTable dtDel = DataTypeUtility.GetGroupByDataTable(dtEmp.Copy(), new string[] { "TGT_EMP_ID" }); MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data(); string okMsg = bizEstData.AddData(dtDel , dtEmp , COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ConESTTERM_STEP_ID , ConDIRECTION_TYPE , "N" , DateTime.Now , DateTime.Now , this.gUserInfo.Emp_Ref_ID); if (okMsg.Length == 0) { ltrScript.Text = JSHelper.GetAlertScript("정상 처리 되었습니다.", false); DoBinding_Dept(); DEPT_REF_ID = -1; } else { ltrScript.Text = JSHelper.GetAlertScript(okMsg); } }
private void SetData(int estterm_ref_id, string ymd) { Dac_EISDatas objEIS = new Dac_EISDatas(); DT_DATA = objEIS.GetData_M_4_S_1(estterm_ref_id, ymd); DT_DATA = DataTypeUtility.FilterSortDataTable(DT_DATA, "", "SORT_ORDER"); }
private void GetTermInfos() { TermInfos termInfo = new TermInfos(); DataTable dt = termInfo.GetAllList().Tables[0]; dt = DataTypeUtility.FilterSortDataTable(dt, "", "EST_STARTDATE"); UltraWebGrid1.DataSource = dt; UltraWebGrid1.DataBind(); }
protected void doBindConsult() { DataTable dt = DataTypeUtility.FilterSortDataTable(DT_EST_SELF_DATA, "SELF_COMMENT IS NOT NULL"); if (dt.Rows.Count > 0) { // txtConsult.Text = DataTypeUtility.GetString(dt.Rows[0]["SELF_COMMENT"]); txtConsult.Value = DataTypeUtility.GetString(dt.Rows[0]["SELF_COMMENT"]); } }
protected void ibnEmp_Click(object sender, ImageClickEventArgs e) { int cnt = UltraWebGrid2.Rows.Count; string emp_ref_id_list = string.Empty; for (int i = 0; i < cnt; i++) { UltraGridRow row = UltraWebGrid2.Rows[i]; TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox"); if (cBox.Checked) { emp_ref_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("EMP_REF_ID").Value); } } DataTable dtEmp = new DataTable(); if (emp_ref_id_list.Length > 0) { emp_ref_id_list = emp_ref_id_list.Remove(0, 1); dtEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" EMP_REF_ID IN ({0}) ", emp_ref_id_list)); } DataTable dtDelEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID IN ({0}) ", DEPT_REF_ID)); MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp BizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp(); string okMsg = BizMulEstEmp.AddEstEmp(dtDelEmp , dtEmp , COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , rdoEstTypeList.SelectedValue , DateTime.Now , this.gUserInfo.Emp_Ref_ID); if (okMsg.Length == 0) { ltrScript.Text = JSHelper.GetAlertScript("정상 처리 되었습니다.", false); DoBinding_Dept(); DEPT_REF_ID = -1; UltraWebGrid2.Clear(); } else { ltrScript.Text = JSHelper.GetAlertScript(okMsg); } }
private void SetData(int estterm_ref_id, string ymd) { Dac_EISDatas objEIS = new Dac_EISDatas(); //DT_DATA = objEIS.GetData_M_1_S_2(estterm_ref_id, ymd); DataSet ds = objEIS.GetData_M_0_S_Factory(estterm_ref_id, ymd); DT_DATA = ds.Tables[0]; DT_DATA = DataTypeUtility.FilterSortDataTable(DT_DATA, "", "SORT_ORDER"); }
private void BindSub(int m_id) { Dac_EISDatas obj = new Dac_EISDatas(); DataTable dt = obj.GetEISSub(m_id, 0); dt = DataTypeUtility.FilterSortDataTable(dt, "", "SORT_ORDER"); ddlSub.DataValueField = "S_ID"; ddlSub.DataTextField = "S_NAME"; ddlSub.DataSource = dt; ddlSub.DataBind(); }
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 Prj_Est_Point_Bind() { DataTable dt = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID, COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID); DataTable dtPrjInfo = DataTypeUtility.FilterSortDataTable(dt, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1"); object point = dtPrjInfo.Rows[0]["POINT"]; string Result = Math.Round(DataTypeUtility.GetToDouble(point), 1).ToString(); this.lblPrjEstPoint.Text = Result; }
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 Prj_Data_Bind() { DataTable DT = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID , COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID); uwgrid_TGT_EMP_LIST.Clear(); uwgrid_TGT_EMP_LIST.DataSource = DataTypeUtility.FilterSortDataTable(DT, "TGT_DEPT_ID > -1 AND TGT_EMP_ID > -1"); uwgrid_TGT_EMP_LIST.DataBind(); }
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 bool setAverage_Point() { //데이터 수집 DataTable dt = getConfirmed_EstData(); int result = 0; if (dt.Rows.Count > 0) { Biz_Est_Data bizEstData = new Biz_Est_Data(); DataTable dt_Bias_ratio = bizEstData.Get_Bias_AVG_Ratio_STD(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID); //데이터 가공 for (int i = 0; i < dt.Rows.Count; i++) { string est_emp_id = DataTypeUtility.GetString(dt.Rows[i]["EST_EMP_ID"]); string filter = string.Format("EST_EMP_ID={0}", est_emp_id); DataTable dt_filtered_ratio = DataTypeUtility.FilterSortDataTable(dt_Bias_ratio, filter); if (dt_filtered_ratio.Rows.Count > 0) { double avg_ratio = DataTypeUtility.GetToDouble(dt_filtered_ratio.Rows[0]["AVG_RATIO"]); double point_org = DataTypeUtility.GetToDouble(dt.Rows[i]["POINT_ORG"]); double point_avg = point_org * avg_ratio; double point_ctrl_org = point_avg; //환산점수 계산용 점수 double point = point_ctrl_org * 100 / 5; //환산점수 dt.Rows[i]["POINT"] = Math.Round(point, 1); dt.Rows[i]["POINT_AVG"] = Math.Round(point_avg, 1); dt.Rows[i]["POINT_STD"] = -1; dt.Rows[i]["POINT_CTRL_ORG"] = Math.Round(point_avg, 1); dt.Rows[i]["STATUS_ID"] = "E";//확정 } } dt = Add_Date_User(dt); result = bizEstData.ModifyEstData_Point(dt, gUserInfo.Emp_Ref_ID); } return(result > 0 ? true : false); }
/// <summary> /// 프로젝트 평가 질의에 매핑되지 않은 프로젝트 목록 /// </summary> public DataTable Get_Prj_Info_Not_In_Question_Map(int comp_id , string est_id , int estterm_ref_id , int estterm_sub_id , int estterm_step_id) { DataTable dt = _data.Select_Prj_Info_Join_Question_Map(comp_id , est_id , estterm_ref_id , estterm_sub_id , estterm_step_id , 0 , ""); return(DataTypeUtility.FilterSortDataTable(dt, "MAP_PRJ_REF_ID IS NULL")); }
protected void doBindKpiPool() { MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool(); DataSet ds = objBSC.GetDetailAllList(txtKpiName.Text.Trim() , "" , "" , 0 , 0 , 0 , ""); DataTable dt_filtered = DataTypeUtility.FilterSortDataTable(ds.Tables[0], "KPI_EXTERNAL_TYPE='EXT'"); UltraWebGrid1.Clear(); UltraWebGrid1.DataSource = dt_filtered; UltraWebGrid1.DataBind(); }
private void DataBinding() { DataTable dt = null; if (BU.Equals("DD")) { dt = DS_DATA.Tables[0]; } else if (BU.Equals("DO")) { dt = DS_DATA.Tables[1]; } else if (BU.Equals("CJ")) { dt = DS_DATA.Tables[2]; dt = DataTypeUtility.FilterSortDataTable(dt, "", "SORT_ORDER, SORT_ORDER2 DESC"); } else { return; } uGrid.DataSource = dt; uGrid.DataBind(); dt.Columns.Add("TEXT", typeof(string)); foreach (DataRow dr in dt.Rows) { dr["TEXT"] = string.Format("{0}({2}%)" , dr["ALIAS"] , DataTypeUtility.GetToDouble(dr["RESULT_TS"]).ToString("#,##0.00") , DataTypeUtility.GetToDouble(dr["RESULT_RATIO"]).ToString("#,##0.00")); } BindChart(Chart1 , DataTypeUtility.FilterSortDataTable(dt, "SORT_ORDER2 = 2", "SORT_ORDER") , "Item별 점유비 - 총매출" , lbl1); BindChart(Chart2 , DataTypeUtility.FilterSortDataTable(dt, "SORT_ORDER2 = 1", "SORT_ORDER") , "Item별 점유비 - 내수매출" , lbl2); }
protected void ibnValidCheck_Click(object sender, ImageClickEventArgs e) { DataTable dtRelGrpData = GetRelGroupData(COMP_ID, EST_ID, ESTTERM_REF_ID); DataTable dtValid = null; if (dtRelGrpData.Rows.Count == 0) { ltrScript.Text = JSHelper.GetAlertScript("상대그룹에 포함된 사원정보가 없습니다."); return; } dtValid = DataTypeUtility.GetGroupByDataTable(dtRelGrpData , "TGT_EMP_ID" , new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" } , "TGT_EMP_ID"); dtValid = DataTypeUtility.FilterSortDataTable(dtValid, "CNT_TGT_EMP_ID > 1"); int duplicate_emp_id_cnt = dtValid.Rows.Count; if (duplicate_emp_id_cnt > 0) { string temp = "\\r\\n"; foreach (DataRow drRow in dtValid.Rows) { DataRow[] drArrTgt = dtRelGrpData.Select(string.Format("TGT_EMP_ID = {0}", drRow["TGT_EMP_ID"])); foreach (DataRow drRowTgt in drArrTgt) { Biz_RelGroupInfos relGroupInfo = new Biz_RelGroupInfos(COMP_ID, DataTypeUtility.GetValue(drRowTgt["REL_GRP_ID"])); Biz_EmpInfos empInfo = new Biz_EmpInfos(DataTypeUtility.GetToInt32(drRowTgt["TGT_EMP_ID"])); temp += relGroupInfo.Rel_Grp_Name + " - " + empInfo.Emp_Name + "\\r\\n"; } } ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0}명의 사원이 상대그룹에 중복되어 있습니다.{1}", duplicate_emp_id_cnt, temp)); return; } else { ltrScript.Text = JSHelper.GetAlertScript("상대그룹 설정에 오류가 없습니다."); return; } }
protected bool CheckModifyPossiblity(int dept_ref_id) { MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map bizTargetMap = new MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map(); bool allowModify; //현재 부서의 피평가자 목록 데이터테이블 DataTable c_DT_tgt_emp_id = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" EST_TYPE_TGT = 'TGT' AND DEPT_REF_ID={0}", dept_ref_id)); //현재 부서의 피평가자 목록 스트링 StringBuilder tgt_emp_id_list = new StringBuilder(); for (int i = 0; i < c_DT_tgt_emp_id.Rows.Count; i++) { if (tgt_emp_id_list.Length > 0) { tgt_emp_id_list.Append(", "); } tgt_emp_id_list.Append(c_DT_tgt_emp_id.Rows[i]["EMP_REF_ID"].ToString()); } if (tgt_emp_id_list.Length == 0) { tgt_emp_id_list.Append("''"); } //현재 부서의 피평가자에 대한 평가자 매핑 정보 DataTable dtConfirmed = DataTypeUtility.FilterSortDataTable(DT_EST_DATA, string.Format("TGT_EMP_ID IN ({0})", tgt_emp_id_list.ToString())); if (dtConfirmed.Rows.Count > 0) { allowModify = false; } else { allowModify = true; } return(allowModify); }
protected void BindScore() { if (DT_SCORE != null && DT_SCORE.Rows.Count > 0) { DataTable dt_current_score = DataTypeUtility.FilterSortDataTable(DT_SCORE, string.Format("YMD='{0}'", YMD)); if (dt_current_score.Rows.Count > 0) { string score_col_name = "SCORE"; SCORE = DataTypeUtility.GetToDouble(dt_current_score.Rows[0][score_col_name]); lblScore.Text = Math.Round(SCORE, 1).ToString(); } else { lblScore.Text = "-"; } } }
protected void Page_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); if (!Page.IsPostBack) { if (type == "T") { dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().CoporationKpiTempleteList(); this.lblPopUpTitle.Text = "전략템플릿 조직 KPI"; } else { dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().CoporationKpiList(); dt = DataTypeUtility.FilterSortDataTable(dt, "KPI_EXTERNAL_TYPE='INR'"); this.lblPopUpTitle.Text = "조직KPI 풀"; } ugrdStgList.DataSource = dt; ugrdStgList.DataBind(); } }
/* 실적 입력 결재 여부 확인 * protected bool KpiResult_DraftState(string kpi_ref_id) * { * bool isAdmin = false; * bool isTeamManager = false; * if (User.IsInRole(ROLE_ADMIN)) * isAdmin = true; * if (User.IsInRole(ROLE_TEAM_MANAGER)) * isTeamManager = true; * * MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info(); * DataSet dsResult = objBSC.GetMboListForResultInput(PageUtility.GetIntByValueDropDownList(ddlEstTerm) * , PageUtility.GetByValueDropDownList(ddlEstTermMonth) * , "" * , "" * , "" * , PageUtility.GetIntByValueDropDownList(ddlEstDeptRight) * , PageUtility.GetByValueDropDownList(ddlKpiGroupRefID) * , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryTop) * , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryMid) * , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryLow) * , gUserInfo.Emp_Ref_ID * , isAdmin * , isTeamManager * , BizUtility.GetDeptID(gUserInfo.Emp_Ref_ID)); * * return false; * } */ protected DataTable addMonthlyTarget(DataTable srcTbl, DataTable tgtTbl) { for (int j = 1; j < 13; j++) { tgtTbl.Columns.Add("MONTH" + j.ToString().PadLeft(2, '0')); } for (int i = 0; i < tgtTbl.Rows.Count; i++) { DataTable dtTmp = DataTypeUtility.FilterSortDataTable(srcTbl, string.Format("KPI_REF_ID='{0}'", DataTypeUtility.GetString(tgtTbl.Rows[i]["KPI_REF_ID"]))); if (dtTmp.Rows.Count > 0) { for (int j = 1; j < 13; j++) { string thisMonth = "MONTH" + j.ToString().PadLeft(2, '0'); tgtTbl.Rows[i][thisMonth] = dtTmp.Rows[0][thisMonth]; } } } return(tgtTbl); }
/// <summary> /// BSC 부서 정보와 기간계 부서정보 비교 리스트 /// </summary> public DataTable Get_Diff_Dept_IF(GUBUN gubun) { Dac_Com_IF dacComIF = new Dac_Com_IF(); DataSet DS = dacComIF.Select_Diff_DeptInfo_IF(); string expression = ""; if (gubun == GUBUN.MATCH) { expression = "GUBUN='Y'"; } else if (gubun == GUBUN.NOTMATCH) { expression = "GUBUN='N'"; } DataTable DT = DataTypeUtility.FilterSortDataTable(DS.Tables[0], expression); //DT = AddStatusCol(DT, GUBUN2.DEPT); return(DT); }
protected void ugrdEstComment_InitializeRow(object sender, RowEventArgs e) { string self_top_id = DataTypeUtility.GetString(e.Row.Cells.FromKey("SELF_TOP_ID")); DataTable dt_question = DataTypeUtility.FilterSortDataTable(DT_EST_SELF_DATA, string.Format("SELF_TOP_ID={0}", self_top_id)); TemplatedColumn tc = (TemplatedColumn)e.Row.Band.Columns.FromKey("EST_COMMENT"); RadioButtonList rdoEstComment = (RadioButtonList)((CellItem)tc.CellItems[e.Row.Index]).FindControl("rdoEstComment"); rdoEstComment.RepeatDirection = RepeatDirection.Horizontal; rdoEstComment.RepeatLayout = RepeatLayout.Table; rdoEstComment.Width = Unit.Percentage(99); rdoEstComment.DataSource = dt_question; rdoEstComment.DataBind(); DataTable dt_q_selected = DataTypeUtility.FilterSortDataTable(dt_question, string.Format("SELECTED > 0")); if (dt_q_selected.Rows.Count > 0) { WebUtility.FindByValueRadioButtonList(rdoEstComment, DataTypeUtility.GetString(dt_q_selected.Rows[0]["SELF_MID_ID"])); } }
private void DoBinding_Emp(int dept_ref_id) { string filter = string.Format(" TGT_DEPT_ID = {0} ", dept_ref_id); string sort = "TGT_EMP_NAME"; string[] groupBy = { "TGT_DEPT_ID" , "TGT_DEPT_NAME" , "TGT_EMP_ID" , "TGT_EMP_NAME" , "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" }; UltraWebGrid2.Columns[1].BaseColumnName = "TGT_EMP_NAME"; UltraWebGrid2.Columns[2].BaseColumnName = "TGT_POS_KND_NAME"; UltraWebGrid2.Columns[3].BaseColumnName = "TGT_POS_CLS_NAME"; UltraWebGrid2.Columns[4].BaseColumnName = "TGT_POS_DUT_NAME"; UltraWebGrid2.Columns[5].BaseColumnName = "TGT_EMP_ID"; DataTable dtDeptEmp = DataTypeUtility.FilterSortDataTable(DataTypeUtility.GetGroupByDataTable(DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, filter) , groupBy) , "" , sort); UltraWebGrid2.DataSource = dtDeptEmp; UltraWebGrid2.DataBind(); }