/******************************************************************************************
* 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;
}
}
}