private void BindEstJob(int comp_id, string est_id) { if (!est_id.Equals("")) { Biz_JobEstMaps jobEstMap = new Biz_JobEstMaps(); _dtEstJobMap = jobEstMap.GetJobEstMap(comp_id, est_id, "").Tables[0]; } Biz_JobInfos jobInfo = new Biz_JobInfos(); UltraWebGrid2.DataSource = jobInfo.GetJobInfos("N"); UltraWebGrid2.DataBind(); }
private void DoLoading(int comp_id, string est_id, int estterm_ref_id, int estterm_sub_id) { UltraWebGrid1.Clear(); Biz_JobEstMaps biz = new Biz_JobEstMaps(); DataSet ds = biz.GetJobEstMap(comp_id , est_id , estterm_ref_id , estterm_sub_id , ""); UltraWebGrid1.DataSource = ds.Tables[0]; UltraWebGrid1.DataBind(); }
private void BindEstJob(string est_id) { UltraWebGrid1.Clear(); Biz_JobEstMaps biz = new Biz_JobEstMaps(); DataSet ds = biz.GetJobEstMap(COMP_ID , est_id , ESTTERM_REF_ID , ESTTERM_SUB_ID , ""); UltraWebGrid1.DataSource = ds.Tables[0]; UltraWebGrid1.DataBind(); //lblRowCount.Text = ds.Tables[0].Rows.Count.ToString(); }
public static void BindEstJobMapNotIn(DropDownList ddl, int comp_id, string est_id, bool isBlank) { Biz_JobEstMaps jobEstMap = new Biz_JobEstMaps(); DataSet ds = jobEstMap.GetJobEstMap(comp_id, est_id, ""); ddl.DataValueField = "EST_JOB_ID"; ddl.DataTextField = "EST_JOB_NAME"; ddl.DataSource = ds; ddl.DataBind(); if (isBlank) { ListItem itemA = new ListItem("----------", ""); ddl.Items.Insert(0, itemA); } }
private bool SaveEstJobEstMap() { Biz_JobEstMaps jobEstMap = new Biz_JobEstMaps(); DataTable dataTable = jobEstMap.GetDataTableSchema(); 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"] = TreeView1.SelectedValue; dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; } return(jobEstMap.SaveJobEstMap(dataTable, COMP_ID, TreeView1.SelectedValue)); }
protected void ibnSave_Click(object sender, ImageClickEventArgs e) { string est_id = txtEstID.Text; string up_est_id = hdfUpEstID.Value; string est_name = txtEstName.Text; string header_color = txtHeaderColor.Text; string grade_confirm_yn = WebUtility.GetByValueRadioButtonList(rblGradeConfirmYN); string bias_yn = WebUtility.GetByValueRadioButtonList(rblBiasYN); string bias_dept_use_id = WebUtility.GetByValueRadioButtonList(rblBiasDeptUseID); string tgt_send_type = WebUtility.GetByValueRadioButtonList(rblTgtSendType); string tgt_opinion_yn = null; string feedback_yn = null; if (bias_yn.Equals("N")) { bias_dept_use_id = "N"; } if (tgt_send_type.Equals("OPN")) { tgt_opinion_yn = "Y"; feedback_yn = "N"; } else if (tgt_send_type.Equals("FBK")) { tgt_opinion_yn = "N"; feedback_yn = "Y"; } else { tgt_opinion_yn = "N"; feedback_yn = "N"; } int estterm_sub = CheckBoxListCommon.GetCheckNum(cblEstTermSub); int estterm_step = CheckBoxListCommon.GetCheckNum(cblEstTermStep); string fixed_weight_use_yn = WebUtility.GetByValueRadioButtonList(rblFixedWeightUseYN); double fixed_weight = DataTypeUtility.GetToDouble(txtFixedWeight.Text); int point_ctrl_step = WebUtility.GetIntByValueDropDownList(ddlPointCtrlStep); int grade_ctrl_step = WebUtility.GetIntByValueDropDownList(ddlGradeCtrlStep); string owner_type = WebUtility.GetByValueRadioButtonList(rblOwnerType); string est_style = WebUtility.GetByValueRadioButtonList(rblEstStyle); string link_est_id = hdfLinkEstID.Value; string weight_type = WebUtility.GetByValueRadioButtonList(rblWeightType); string scale_type = WebUtility.GetByValueRadioButtonList(rblScaleType); string status_style_id = WebUtility.GetByValueDropDownList(ddlStatusStyleID); string q_style_id = WebUtility.GetByValueDropDownList(ddlQuestionStyleID); string bias_type_id = WebUtility.GetByValueDropDownList(ddlBiasTypeID); string q_item_desc_use_yn = WebUtility.GetByValueRadioButtonList(rblQItemDescUseYN); string q_tgt_pos_biz_use_yn = WebUtility.GetByValueRadioButtonList(rblQTgtPosBizUseYN); string all_step_visible_yn = WebUtility.GetByValueRadioButtonList(rblAllStepVisibleYN); string emp_com_dept_yn = WebUtility.GetByValueRadioButtonList(rblEmpComDeptYN); string use_yn = WebUtility.GetByValueRadioButtonList(rblUseYN); string visible_past_point_yn = WebUtility.GetByValueRadioButtonList(rblVisiblePastPointYN); string est_qtt_mbo_yn = WebUtility.GetByValueRadioButtonList(rblEstQTTMBOYN); string mbo_score_estimate_yn = WebUtility.GetByValueRadioButtonList(rblMboScoreEstimateYN); string dashboard_type = (rblDashBoardTYPE.SelectedItem.Value != "N" ? ddlDashBoardTYPE.SelectedItem.Value : "N"); string previousstep_yn = (ddlQuestionStyleID.SelectedItem.Value == "BLK" ? "N" : ddlPreviousStempYN.SelectedItem.Value.ToString()); if (visible_past_point_yn.Equals("")) { visible_past_point_yn = "Y"; } if (est_qtt_mbo_yn.Equals("")) { est_qtt_mbo_yn = "N"; } if (mbo_score_estimate_yn.Equals("")) { mbo_score_estimate_yn = "N"; } Biz_EstInfos estInfo = new Biz_EstInfos(); Biz_JobEstMaps jobEstMap = new Biz_JobEstMaps(); if (PageWriteMode == WriteMode.New) { bool bDuplicate = estInfo.IsExists(COMP_ID, est_id); if (bDuplicate) { ltrScript.Text = JSHelper.GetAlertScript("존재하는 평가 ID 입니다."); } bool bResult = estInfo.AddEstInfoAddMaps(COMP_ID , est_id , up_est_id , est_name , header_color , grade_confirm_yn , bias_yn , bias_dept_use_id , tgt_opinion_yn , feedback_yn , estterm_sub , estterm_step , fixed_weight_use_yn , fixed_weight , point_ctrl_step , grade_ctrl_step , owner_type , est_style , link_est_id , weight_type , scale_type , status_style_id , q_style_id , q_item_desc_use_yn , q_tgt_pos_biz_use_yn , all_step_visible_yn , emp_com_dept_yn , bias_type_id , visible_past_point_yn , est_qtt_mbo_yn , mbo_score_estimate_yn , dashboard_type , previousstep_yn , use_yn , DateTime.Now , EMP_REF_ID); bool isOK1 = SaveEstTermSubMap(); bool isOK2 = SaveEstTermStepMap(); bool isOK3 = SaveEstJobEstMap(); DoSavIng_OuterDataProcInfo(); if (bResult) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다."); GridBinding(COMP_ID); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다."); return; } } else if (PageWriteMode == WriteMode.Modify) { bool bResult = estInfo.ModifyEstInfoModifyMaps(COMP_ID , est_id , up_est_id , est_name , header_color , grade_confirm_yn , bias_yn , bias_dept_use_id , tgt_opinion_yn , feedback_yn , estterm_sub , estterm_step , fixed_weight_use_yn , fixed_weight , point_ctrl_step , grade_ctrl_step , owner_type , est_style , link_est_id , weight_type , scale_type , status_style_id , q_style_id , q_item_desc_use_yn , q_tgt_pos_biz_use_yn , all_step_visible_yn , emp_com_dept_yn , bias_type_id , visible_past_point_yn , est_qtt_mbo_yn , mbo_score_estimate_yn , dashboard_type , previousstep_yn , use_yn , DateTime.Now , EMP_REF_ID); bool isOK1 = SaveEstTermSubMap(); bool isOK2 = SaveEstTermStepMap(); bool isOK3 = SaveEstJobEstMap(); DoSavIng_OuterDataProcInfo(); if (bResult) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 수정되었습니다."); //GridBinding(); ButtonStatusModify(); ViewOne(COMP_ID, hdfEstID.Value); } else { ltrScript.Text = JSHelper.GetAlertScript("수정되지 않았습니다."); return; } } }