private void DataListBinding_P() { Biz_QuestionObjects questionObjects = new Biz_QuestionObjects(EST_ID, Q_OBJ_ID); Q_OBJ_NAME = questionObjects.Q_Obj_Name; Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects(); DataSet ds = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, ""); if (ds.Tables.Count == 0) { return; } DataTable dt = DataTypeUtility.GetGroupByDataTable(ds.Tables[0], new string[] { "Q_DFN_ID" }); string q_dfn_ids = DataTypeUtility.GetSplitString(dt, "Q_DFN_ID", ","); if (q_dfn_ids.Length > 0) { DefineDataBinding_P(q_dfn_ids); } NoDefineDataBinding_P(ds); }
private void DataListBinding_P() { if (_tgt_pos_biz_use_yn.Equals("N")) { Biz_QuestionObjects questionObjects = new Biz_QuestionObjects(EST_ID, Q_OBJ_ID); Q_OBJ_NAME = questionObjects.Q_Obj_Name; } else { Q_OBJ_NAME = "직무평가"; } Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects(); DataTable dtSubject = null; if (_tgt_pos_biz_use_yn.Equals("N")) { dtSubject = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, "").Tables[0]; double weight_total = DataTypeUtility.GetToDouble(dtSubject.Compute("SUM(WEIGHT)", "1 = 1")); for (int i = 1; i <= dtSubject.Rows.Count; i++) { dtSubject.Rows[i - 1]["WEIGHT"] = DataTypeUtility.GetToDouble(dtSubject.Rows[i - 1]["WEIGHT"]) / weight_total * 100; } } else { dtSubject = questionSubjects.GetQuestionSubject(COMP_ID, EST_ID, TGT_EMP_ID, "").Tables[0]; double weight_total = DataTypeUtility.GetToDouble(dtSubject.Compute("SUM(WEIGHT)", "1 = 1")); for (int i = 1; i <= dtSubject.Rows.Count; i++) { dtSubject.Rows[i - 1]["NUM"] = i; dtSubject.Rows[i - 1]["WEIGHT"] = DataTypeUtility.GetToDouble(dtSubject.Rows[i - 1]["WEIGHT"]) / weight_total * 100; } } DataTable dt = DataTypeUtility.GetGroupByDataTable(dtSubject, new string[] { "Q_DFN_ID" }); string q_dfn_ids = DataTypeUtility.GetSplitString(dt, "Q_DFN_ID", ","); if (!q_dfn_ids.Equals("")) { DefineDataBinding_P(q_dfn_ids); } NoDefineDataBinding_P(dtSubject); }
private void DataListBinding() { Biz_QuestionObjects questionObjects = new Biz_QuestionObjects(EST_ID, Q_OBJ_ID); Q_OBJ_NAME = questionObjects.Q_Obj_Name; TOTALPOINT = 0; Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects(); DataSet ds = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, ""); if (ds.Tables.Count == 0) { return; } DataTable dt = DataTypeUtility.GetGroupByDataTable(ds.Tables[0], new string[] { "Q_DFN_ID" }); string q_dfn_ids = DataTypeUtility.GetSplitString(dt, "Q_DFN_ID", ","); if (!q_dfn_ids.Equals("")) { DefineDataBinding(q_dfn_ids); } NoDefineDataBinding(ds); //POINT_ORG = Math.Round(TOTALPOINT * 0.01, 2); POINT_ORG = Math.Round(TOTALPOINT / 3, 1); if (POINT_ORG == 0) { ltrTotalPoint.Text = "미평가"; } else { ltrTotalPoint.Text = POINT_ORG.ToString("###.0") + " / 100"; } }
private void DataListBinding(DataTable dtPrjData) { Biz_QuestionObjects questionObjects = new Biz_QuestionObjects(EST_ID, Q_OBJ_ID); Q_OBJ_NAME = questionObjects.Q_Obj_Name; TOTALPOINT = 0; Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects(); DataSet ds = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, ""); if (ds.Tables.Count == 0) { return; } DataTable dt = DataTypeUtility.GetGroupByDataTable(ds.Tables[0], new string[] { "Q_DFN_ID" }); string q_dfn_ids = DataTypeUtility.GetSplitString(dt, "Q_DFN_ID", ","); if (!q_dfn_ids.Equals("")) { DefineDataBinding(q_dfn_ids); } NoDefineDataBinding(ds); //MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data(); //DataTable dtEstData = bizEstData.GetEstData(COMP_ID // , EST_ID // , ESTTERM_REF_ID // , ESTTERM_SUB_ID // , ESTTERM_STEP_ID // , "" // , EST_EMP_ID // , TGT_EMP_ID); //MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data(); //DataTable dtPrjData = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID // , 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 // , ""); //POINT_ORG = Math.Round(TOTALPOINT * 0.01, 2); //POINT_ORG = Math.Round(TOTALPOINT / 3, 1); POINT_ORG = DataTypeUtility.GetToDouble(dtPrjData.Rows[0]["POINT"]); if (POINT_ORG == 0) { ltrTotalPoint.Text = "미평가"; } else { ltrTotalPoint.Text = POINT_ORG.ToString("###.0") + " / 100"; } }