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); }
protected void UltraWebGrid1_InitializeRow(object sender, RowEventArgs e) { DataRowView dr = (DataRowView)e.Data; Biz_QuestionObjects questionObjects = new Biz_QuestionObjects(hdfSearchEstID.Value, dr["Q_OBJ_ID"].ToString()); e.Row.Cells.FromKey("Q_OBJ_NAME").Value = questionObjects.Q_Obj_Name; e.Row.Cells.FromKey("Q_OBJ_TITLE").Value = questionObjects.Q_Obj_Title; }
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); }
public static void BindQuestionObject(DropDownList ddl, string strEstID, bool isBlank) { Biz_QuestionObjects questionObject = new Biz_QuestionObjects(); ddl.DataSource = questionObject.GetQuestionObjects(strEstID); ddl.DataTextField = "Q_OBJ_NAME"; ddl.DataValueField = "Q_OBJ_ID"; ddl.DataBind(); if (isBlank) { ListItem itemA = new ListItem("----------", ""); ddl.Items.Insert(0, itemA); } }
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"; } }
protected void ibnCopyQObj_Click(object sender, ImageClickEventArgs e) { Biz_QuestionObjects questionObj = new Biz_QuestionObjects(); DataTable dataTable = questionObj.GetDataTableSchema(); dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1 , "cBox" , "selchk" , new string[] { "Q_OBJ_ID" } , dataTable); if (dataTable.Rows.Count == 0) { ltrScript.Text = JSHelper.GetAlertScript("복사하려는 질의가 없습니다."); return; } foreach (DataRow dataRow in dataTable.Rows) { dataRow["EST_ID"] = hdfSearchEstID.Value; dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; } bool isOK = questionObj.CopyQuestionObject(dataTable); if (isOK) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 질의 그룹이 복사되었습니다."); BindGrid(hdfSearchEstID.Value); } else { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 복사되지 않았습니다."); } }
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { DataRowView dr = (DataRowView)e.Data; string empId = e.Row.Cells.FromKey("EMP_REF_ID").Value.ToString(); string empName = e.Row.Cells.FromKey("EMP_NAME").Value.ToString(); Biz_QuestionObjects questionObjects = new Biz_QuestionObjects("", DataTypeUtility.GetString(e.Row.Cells.FromKey("Q_OBJ_ID").Value)); e.Row.Cells.FromKey("Q_OBJ_NAME").Value = questionObjects.Q_Obj_Name; CheckBox chk; UltraGridRow row; TemplatedColumn col; row = e.Row; col = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox"); if (dr["ENABLED"].ToString().Equals("0")) { chk.Enabled = false; } }
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"; } }