/****************************************************************************************** * Function name : BindData * Purpose : 넘겨받은 contents_id에 해당하는 데이터를 페이지의 컨트롤에 바인딩 처리 * Input : void * Output : void ******************************************************************************************/ #region private void BindData() private void BindData() { try { string[] xParams = new string[1]; DataTable xDt = null; if (ViewState["OPEN_COURSE_ID"].ToString() == string.Empty) { return; } xParams[0] = ViewState["OPEN_COURSE_ID"].ToString(); xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_opencourse_md", "GetOpencourseInfo", LMS_SYSTEM.CURRICULUM, "CLT.WEB.UI.LMS.CURR", (object)xParams); if (xDt != null && xDt.Rows.Count > 0) { DataRow dr = xDt.Rows[0]; //VIEWSTATE에 입력되는 정보 저장 ViewState["COURSE_ID"] = dr["COURSE_ID"].ToString(); ViewState["COURSE_YEAR"] = dr["COURSE_YEAR"].ToString(); ViewState["COURSE_SEQ"] = dr["COURSE_SEQ"].ToString(); ViewState["EDUCATIONAL_ORG"] = dr["EDUCATIONAL_ORG"].ToString(); ViewState["TRAINING_FEE"] = dr["TRAINING_FEE"].ToString(); ViewState["COURSE_TYPE"] = dr["COURSE_TYPE"].ToString(); ViewState["PASS_SCORE"] = dr["PASS_SCORE"].ToString(); ViewState["TRAINING_SUPPORT_FEE"] = dr["TRAINING_SUPPORT_FEE"].ToString(); ViewState["TRAINING_SUPPORT_COMP_FEE"] = dr["TRAINING_SUPPORT_COMP_FEE"].ToString(); ViewState["COURSE_BEGIN_APPLY_DT"] = dr["COURSE_BEGIN_APPLY_DT"].ToString(); ViewState["COURSE_END_APPLY_DT"] = dr["COURSE_END_APPLY_DT"].ToString(); ViewState["COURSE_BEGIN_DT"] = dr["COURSE_BEGIN_DT"].ToString(); ViewState["COURSE_END_DT"] = dr["COURSE_END_DT"].ToString(); ViewState["RES_BEGIN_DT"] = dr["RES_BEGIN_DT"].ToString(); ViewState["RES_END_DT"] = dr["RES_END_DT"].ToString(); ViewState["MIN_MAN_COUNT"] = dr["MIN_MAN_COUNT"].ToString(); ViewState["MAX_MAN_COUNT"] = dr["MAX_MAN_COUNT"].ToString(); ViewState["COMPANY_ACCEPT"] = dr["COMPANY_ACCEPT"].ToString(); ViewState["STD_PROGRESS_RATE"] = dr["STD_PROGRESS_RATE"].ToString(); ViewState["STD_FINAL_EXAM"] = dr["STD_FINAL_EXAM"].ToString(); //ViewState["STD_REPORT"] = dr["STD_REPORT"].ToString(); //현재는 사용하지 않는 필드 임 ViewState["USE_FLG"] = dr["USE_FLG"].ToString(); ViewState["COURSE_GUBUN"] = dr["COURSE_GUBUN"].ToString(); // 국토해양부 과정 여부 ViewState["RES_NO"] = dr["RES_NO"].ToString(); ViewState["COURSE_INOUT"] = dr["COURSE_INOUT"].ToString(); ViewState["COURSE_PLACE"] = dr["COURSE_PLACE"].ToString(); ViewState["MANAGER"] = dr["MANAGER"].ToString(); this.txtCourseID.Value = dr["COURSE_ID"].ToString(); this.txtCourseNM.Value = dr["COURSE_NM"].ToString(); WebControlHelper.SetSelectItem_DropDownList(this.ddlYear, dr["COURSE_YEAR"].ToString()); this.txtSeq.Text = dr["COURSE_SEQ"].ToString(); WebControlHelper.SetSelectItem_DropDownList(this.ddlInstitution, dr["EDUCATIONAL_ORG"].ToString()); WebControlHelper.SetSelectItem_DropDownList(this.ddlInOut, dr["COURSE_INOUT"].ToString()); string[] xinout = new string[1]; DataTable dtInOut = null; xinout[0] = string.Empty; if (dr["COURSE_INOUT"].ToString() == "000001") { //사내 xinout[0] = "0008"; } else if (dr["COURSE_INOUT"].ToString() == "000002") { //사외 xinout[0] = "0009"; } dtInOut = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md", "GetCommonCodeInfo", LMS_SYSTEM.CURRICULUM, "CLT.WEB.UI.LMS.CURR", (object)xinout, Thread.CurrentThread.CurrentCulture); WebControlHelper.SetDropDownList(this.ddlPlace, dtInOut, WebControlHelper.ComboType.NullAble); WebControlHelper.SetSelectItem_DropDownList(this.ddlPlace, dr["COURSE_PLACE"].ToString()); //this.txtPlace.Text = dr["COURSE_PLACE"].ToString(); this.txtEduFee.Text = dr["TRAINING_FEE"].ToString(); this.txtVat.Text = string.Format("{0:##0.0}", Convert.ToInt32(dr["TRAINING_FEE"].ToString() == string.Empty ? "0" : dr["TRAINING_FEE"].ToString()) * 0.1); //WebControlHelper.SetSelectItem_DropDownList(this.ddlClassification, dr["COURSE_TYPE"].ToString()); string[] xClass = dr["COURSE_TYPE"].ToString().Split('|'); for (int k = 0; k < this.dtlClassification.Items.Count; k++) { ((CheckBox)this.dtlClassification.Items[k].FindControl("chkClass")).Checked = false; } for (int i = 0; i < xClass.GetLength(0); i++) { for (int k = 0; k < this.dtlClassification.Items.Count; k++) { if (xClass[i] == ((Label)this.dtlClassification.Items[k].FindControl("lblClassId")).Text) { ((CheckBox)this.dtlClassification.Items[k].FindControl("chkClass")).Checked = true; } } } this.txtScore.Text = dr["PASS_SCORE"].ToString(); this.txtSupportFee.Text = dr["TRAINING_SUPPORT_FEE"].ToString(); this.txtSupportCompFee.Text = dr["TRAINING_SUPPORT_COMP_FEE"].ToString(); this.txtApplyBeginDt.Text = dr["COURSE_BEGIN_APPLY_DT"].ToString(); this.txtApplyEndDt.Text = dr["COURSE_END_APPLY_DT"].ToString(); this.txtBeginDt.Text = dr["COURSE_BEGIN_DT"].ToString(); this.txtEndDt.Text = dr["COURSE_END_DT"].ToString(); this.txtResBeginDt.Text = dr["RES_BEGIN_DT"].ToString(); this.txtResEndDt.Text = dr["RES_END_DT"].ToString(); this.txtMinCount.Text = dr["MIN_MAN_COUNT"].ToString(); this.txtMaxCount.Text = dr["MAX_MAN_COUNT"].ToString(); this.txtManager.Text = dr["MANAGER"].ToString(); string[] xComp = dr["COMPANY_ACCEPT"].ToString().Split('|'); //초기화 후 for (int k = 0; k < this.dtlCompany.Items.Count; k++) { ((CheckBox)this.dtlCompany.Items[k].FindControl("chkCompany")).Checked = false; } for (int i = 0; i < xComp.GetLength(0); i++) { for (int k = 0; k < this.dtlCompany.Items.Count; k++) { if (xComp[i] == ((Label)this.dtlCompany.Items[k].FindControl("lblCompanyId")).Text) { ((CheckBox)this.dtlCompany.Items[k].FindControl("chkCompany")).Checked = true; } } } this.txtProgressRate.Text = dr["STD_PROGRESS_RATE"].ToString(); this.txtFinalTest.Text = dr["STD_FINAL_EXAM"].ToString(); this.txtTotalScore.Text = Convert.ToString(Convert.ToInt32(dr["STD_PROGRESS_RATE"].ToString() == string.Empty ? "0" : dr["STD_PROGRESS_RATE"].ToString()) + Convert.ToInt32(dr["STD_FINAL_EXAM"].ToString() == string.Empty ? "0" : dr["STD_FINAL_EXAM"].ToString())); this.rdoUsage.SelectedValue = dr["USE_FLG"].ToString(); this.rdoCourseGubun.SelectedValue = dr["COURSE_GUBUN"].ToString(); // 국토해양부 과정여부 //if (dr["USE_FLG"].ToString() == "Y") // this.rdoUsage.Items[0].Selected = true; //else // this.rdoUsage.Items[1].Selected = true; this.txtResNm.Value = dr["RES_SUB"].ToString(); this.txtResId.Value = dr["RES_NO"].ToString(); } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/************************************************************ * Function name : EditMode * Purpose : DataTable의 Edit 모드 처리... * Input : String rUser_ID * Output : void *************************************************************/ private void EditMode(string rUser_ID) { try { string[] xParams = new string[1]; xParams[0] = rUser_ID; DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md", "GetUserEdit", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", (object)xParams); if (xDt.Rows.Count == 0) { return; } DataRow xDr = xDt.Rows[0]; //this.txtID.Text = xDr["user_id"].ToString().ToLower(); this.txtID.Text = xDr["user_id"].ToString(); this.txtuser_nm_kor.Text = xDr["user_nm_kor"].ToString(); this.txtuser_nm_eng_first.Text = xDr["user_nm_eng_first"].ToString(); this.txtuser_nm_eng_last.Text = xDr["user_nm_eng_last"].ToString(); WebControlHelper.SetSelectItem_DropDownList(this.ddlComapnyduty, xDr["duty_step"].ToString()); txtEmail.Text = xDr["email_id"].ToString(); txtPhone.Text = xDr["office_phone"].ToString(); txtMobilePhone.Text = xDr["mobile_phone"].ToString(); hidCompany_id.Value = xDr["company_id"].ToString(); txtCompany.Text = xDr["company_nm"].ToString(); hidCompany_id.Value = xDr["company_id"].ToString(); txtZipCode.Text = xDr["user_zip_code"].ToString(); string[] xAddr = xDr["user_addr"].ToString().Split('|'); int xCount = 0; foreach (string xAddrs in xAddr) { if (xCount == 0) { this.txtAddr1.Text = xAddrs.Trim(); } else { this.txtAddr2.Text = xAddrs.Trim(); } xCount++; } if (xDr["sms_yn"].ToString() == "Y") { this.rbSMS_y.Checked = true; this.rbSMS_n.Checked = false; } else { this.rbSMS_y.Checked = false; this.rbSMS_n.Checked = true; } if (xDr["mail_yn"].ToString() == "Y") { this.rbMail_y.Checked = true; this.rbMail_n.Checked = false; } else { this.rbMail_y.Checked = false; this.rbMail_n.Checked = true; } this.txtAcquisition.Text = xDr["enter_dt"].ToString(); this.txtBirth_dt.Text = xDr["birth_dt"].ToString(); WebControlHelper.SetSelectItem_DropDownList(ddlDept, xDr["dept_code"].ToString()); txtDept.Text = xDr["dept_name"].ToString(); if (xDr["dept_code"].ToString() != xDr["dept_name"].ToString()) { txtDept.ReadOnly = true; } if (xDr["pic_file"] != DBNull.Value && !string.IsNullOrEmpty(xDr["pic_file"].ToString())) { try { int nFind = xDr["pic_file_nm"].ToString().IndexOf("."); if (nFind > 0) { string mimeType = "image/" + xDr["pic_file_nm"].ToString().Substring(nFind + 1); string base64 = Convert.ToBase64String((byte[])xDr["pic_file"]); img_pic_file.ImageUrl = string.Format("data:{0};base64,{1}", mimeType, base64); Unit xUnit = img_pic_file.Width; if (xUnit.Value > 150) { img_pic_file.Width = 150; } } } catch { } } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/************************************************************* * Function name : Edit * Purpose : 회원사 Edit 메서드 * Input : void * Output : void *************************************************************/ #region EDIT(string rSeq) public void EDIT(string rSeq) { try { if (Request.QueryString["LECTURER_ID"] == null) { return; } string[] xParams = new string[1]; xParams[0] = Request.QueryString["LECTURER_ID"].ToString(); DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_lecturer_md", "GetLecturerInfo", LMS_SYSTEM.CURRICULUM, "CLT.WEB.UI.LMS.CURR", (object)xParams); DataRow xDr = xDt.Rows[0]; this.txtLecturerNm.Text = xDr["lecturer_nm"].ToString().ToUpper(); this.txtLecturerEngNm.Text = xDr["lecturer_nm_eng"].ToString(); this.txtBirthDt.Text = xDr["birth_date"].ToString(); WebControlHelper.SetSelectItem_DropDownList(this.ddlGrade, xDr["grade"].ToString()); WebControlHelper.SetSelectItem_DropDownList(this.ddlDutyStep, xDr["duty_step"].ToString()); this.txtJob.Text = xDr["job"].ToString(); this.txtOrgNm.Text = xDr["org_nm"].ToString(); this.txtEducation.Text = xDr["education"].ToString(); this.txtMajor.Text = xDr["major"].ToString(); this.txtCompanyNm.Text = xDr["company_nm"].ToString(); this.txtPhone.Text = xDr["tel_no"].ToString(); this.txtMobile.Text = xDr["mobile_phone"].ToString(); this.txtEmail.Text = xDr["email"].ToString(); this.txtBank.Text = xDr["acc_bank"].ToString(); this.txtAccount.Text = xDr["account"].ToString(); this.txtZipCode.Text = xDr["zip_code"].ToString(); string xAddr = xDr["company_addr"].ToString(); string[] xAddrs = xAddr.Split('|'); int xCnount = 0; foreach (string address in xAddrs) { if (xCnount == 0) { this.txtAddr1.Text = address.Trim(); } else if (xCnount == 1) { this.txtAddr2.Text = address.Trim(); } xCnount++; } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/****************************************************************************************** * Function name : BindData * Purpose : 넘겨받은 contents_id에 해당하는 데이터를 페이지의 컨트롤에 바인딩 처리 * Input : void * Output : void ******************************************************************************************/ #region private void BindData() private void BindData() { try { string[] xParams = new string[1]; DataTable xDt = null; xParams[0] = ViewState["QUESTION_ID"].ToString(); xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_assess_md", "GetAssessInfo", LMS_SYSTEM.CURRICULUM, "CLT.WEB.UI.LMS.CURR", (object)xParams); if (xDt != null && xDt.Rows.Count > 0) { DataRow dr = xDt.Rows[0]; //VIEWSTATE에 입력되는 정보 저장 ViewState["QUESTION_KIND"] = dr["QUESTION_KIND"].ToString(); ViewState["QUESTION_LANG"] = dr["QUESTION_LANG"].ToString(); ViewState["QUESTION_TYPE"] = dr["QUESTION_TYPE"].ToString(); ViewState["COURSE_GROUP"] = dr["COURSE_GROUP"].ToString(); ViewState["COURSE_FIELD"] = dr["COURSE_FIELD"].ToString(); ViewState["QUESTION_SCORE"] = dr["QUESTION_SCORE"].ToString(); ViewState["QUESTION_ANSWER"] = dr["QUESTION_ANSWER"].ToString(); ViewState["QUESTION_CONTENT"] = dr["QUESTION_CONTENT"].ToString(); ViewState["QUESTION_EXAMPLE"] = dr["QUESTION_EXAMPLE"].ToString(); ViewState["QUESTION_DESC"] = dr["QUESTION_DESC"].ToString(); ViewState["USE_FLG"] = dr["USE_FLG"].ToString(); ViewState["TEMP_SAVE_FLG"] = dr["TEMP_SAVE_FLG"].ToString(); ViewState["COURSE_LIST"] = dr["COURSE_LIST"].ToString(); ViewState["SUBJECT_LIST"] = dr["SUBJECT_LIST"].ToString(); //data binding WebControlHelper.SetSelectItem_DropDownList(this.ddlClassification, dr["QUESTION_KIND"].ToString()); //classification WebControlHelper.SetSelectItem_DropDownList(this.ddlLang, dr["QUESTION_LANG"].ToString()); //language WebControlHelper.SetSelectItem_DropDownList(this.ddlGroup, dr["COURSE_GROUP"].ToString()); //group WebControlHelper.SetSelectItem_DropDownList(this.ddlField, dr["COURSE_FIELD"].ToString()); //field WebControlHelper.SetSelectItem_DropDownList(this.ddlScore, dr["QUESTION_SCORE"].ToString()); //score this.txtQuestion.Text = dr["QUESTION_CONTENT"].ToString(); this.txtExplan.Text = dr["QUESTION_DESC"].ToString(); int xQuestionType = Convert.ToInt16(dr["QUESTION_TYPE"].ToString() == string.Empty ? "0" : dr["QUESTION_TYPE"].ToString()); //exam type에 따라 화면 컨트롤 변경 for (int i = 0; i < this.rdoExamType.Items.Count; i++) { if (this.rdoExamType.Items[i].Value == xQuestionType.ToString()) { this.rdoExamType.SelectedIndex = i; this.rdoExamType_SelectedIndexChanged(new object(), new EventArgs()); } } //각 answer, example display string[] xQList = dr["QUESTION_ANSWER"].ToString().Split('凸'); string[] xExampleList = dr["QUESTION_EXAMPLE"].ToString().Split('凸'); if (this.dtlQ.Items.Count > 1) { for (int i = 0; i < this.dtlQ.Items.Count; i++) { for (int k = 1; k < xQList.GetLength(0); k++) { if (Convert.ToInt32(xQList[k]) == i + 1) { ((CheckBox)this.dtlQ.Items[i].FindControl("chkQ")).Checked = true; } } ((TextBox)this.dtlExample.Items[i].FindControl("txtExample")).Text = xExampleList[i + 1]; } } else { for (int i = 0; i < this.dtlExample.Items.Count; i++) { ((TextBox)this.dtlExample.Items[i].FindControl("txtExample")).Text = xExampleList[i + 1]; } } //COURSE LIST if (ViewState["COURSE_LIST"].ToString() != string.Empty) { xParams = new string[1]; xParams[0] = "'" + ViewState["COURSE_LIST"].ToString().Replace("凸", "','") + "'"; string[] xCList = ViewState["COURSE_LIST"].ToString().Split('凸'); xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_assess_md", "GetAssessCourseInfo", LMS_SYSTEM.CURRICULUM, "CLT.WEB.UI.LMS.CURR", (object)xParams); for (int i = 0; i < xCList.Length; i++) { foreach (DataRow drC in xDt.Rows) { if (xCList[i] == drC[1].ToString()) { this.lstCourseItemList.Items.Add(drC[0].ToString()); break; } } } } //SUBJECT LIST if (ViewState["SUBJECT_LIST"].ToString() != string.Empty) { xParams = new string[1]; xParams[0] = "'" + ViewState["SUBJECT_LIST"].ToString().Replace("凸", "','") + "'"; string[] xSList = ViewState["SUBJECT_LIST"].ToString().Split('凸'); xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_assess_md", "GetAssessSubjectInfo", LMS_SYSTEM.CURRICULUM, "CLT.WEB.UI.LMS.CURR", (object)xParams); for (int i = 0; i < xSList.Length; i++) { foreach (DataRow drS in xDt.Rows) { if (xSList[i] == drS[1].ToString()) { this.lstSubjectItemList.Items.Add(drS[0].ToString()); } } } } } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/****************************************************************************************** * Function name : BindData * Purpose : 넘겨받은 textbook_id에 해당하는 데이터를 페이지의 컨트롤에 바인딩 처리 * Input : void * Output : void ******************************************************************************************/ private void BindData() { try { string[] xParams = new string[1]; DataTable xDt = null; xParams[0] = ViewState["TEXTBOOK_ID"].ToString(); xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_textbook_md", "GetTextBookInfoByID", LMS_SYSTEM.CURRICULUM, "CLT.WEB.UI.LMS.CURR", (object)xParams); if (xDt != null && xDt.Rows.Count > 0) { // 향후 변경여부 검사를 위해 ViewState에 입력되는 정보 저장 ViewState["TEXTBOOK_TYPE"] = xDt.Rows[0]["textbook_type"].ToString(); ViewState["TEXTBOOK_LANG"] = xDt.Rows[0]["textbook_lang"].ToString(); ViewState["COURSE_GROUP"] = xDt.Rows[0]["course_group"].ToString(); ViewState["COURSE_FIELD"] = xDt.Rows[0]["course_field"].ToString(); ViewState["TEXTBOOK_NM"] = xDt.Rows[0]["textbook_nm"].ToString(); ViewState["PUBLISHER"] = xDt.Rows[0]["publisher"].ToString(); ViewState["AUTHOR"] = xDt.Rows[0]["author"].ToString(); ViewState["PRICE"] = xDt.Rows[0]["price"].ToString(); ViewState["TEXTBOOK_INTRO"] = xDt.Rows[0]["textbook_intro"].ToString(); ViewState["TEXTBOOK_DESC"] = xDt.Rows[0]["textbook_desc"].ToString(); ViewState["TEXTBOOK_FILE_NM"] = xDt.Rows[0]["textbook_file_nm"].ToString(); ViewState["TEMP_SAVE_FLG"] = xDt.Rows[0]["temp_save_flg"].ToString(); ViewState["PUB_DT"] = xDt.Rows[0]["pub_dt"].ToString(); // TextBook Type 설정 WebControlHelper.SetSelectItem_DropDownList(this.ddlTextBookType, xDt.Rows[0]["textbook_type"].ToString()); // TextBook Lang 설정 WebControlHelper.SetSelectItem_DropDownList(this.ddlTextBookLang, xDt.Rows[0]["textbook_lang"].ToString()); // Course Group 설정 WebControlHelper.SetSelectItem_DropDownList(this.ddlCourseGroup, xDt.Rows[0]["course_group"].ToString()); // Course Field 설정 WebControlHelper.SetSelectItem_DropDownList(this.ddlCourseField, xDt.Rows[0]["course_field"].ToString()); // 기타 TextBox 설정 this.txtTextBookNM.Text = xDt.Rows[0]["textbook_nm"].ToString(); this.txtPublisher.Text = xDt.Rows[0]["publisher"].ToString(); this.txtAuthor.Text = xDt.Rows[0]["author"].ToString(); this.txtPrice.Text = xDt.Rows[0]["price"].ToString(); this.txtTextBookIntro.Text = xDt.Rows[0]["textbook_intro"].ToString(); this.txtTextBookDesc.Text = xDt.Rows[0]["textbook_desc"].ToString(); this.txtFileNM.Value = xDt.Rows[0]["textbook_file_nm"].ToString(); this.txtPubDt.Text = xDt.Rows[0]["pub_dt"].ToString(); } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }