private DataSet GetDsGrdList(string rGubun)
{
DataSet xDs = null;
try
{
string[] xParams = new string[6];
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = Util.ForbidText(txtSTART_DATE.Text);
xParams[3] = Util.ForbidText(txtEND_DATE.Text);
xParams[4] = ddlCourseType.SelectedValue;
xParams[5] = Util.ForbidText(txtCourseNM.Text);
xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduApprovalList",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION",
xParams,
rGubun, Thread.CurrentThread.CurrentCulture);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
return(xDs);
}
//전체해상직원
private DataSet GetDsGrdUserList(string rGubun)
{
//ScriptHelper.ScriptStartup(this, "vp_a_appraisal_competency_detail_wpg", "<script>ChangeLayer('2');</script>");
DataSet xDs = null;
try
{
string[] xParams = new string[4];
xParams[0] = "100";
xParams[1] = this.PageNavigator2.CurrentPageIndex.ToString();
xParams[2] = iCourseID;
xParams[3] = iOpenCourseID;
xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduUserList",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION",
(object)xParams,
rGubun);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
return(xDs);
}
private bool bSaveFile()
{
bool bReturn = false;
try
{
string xFileName = "";
byte[] xFileByte = null;
FileUpload file = this.fileUplaod;// ((FileUpload)((C1.Web.C1WebGrid.C1GridItem)this.grdList.Items[i]).FindControl("fileUplaod"));
if (file.FileBytes.Length > 0)
{
xFileName = file.FileName.Replace(" ", "_").Replace("..", "_");
xFileByte = file.FileBytes;
SBROKER.GetString("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"SetFileAtt",
LMS_SYSTEM.MANAGE,
"CLT.WEB.UI.LMS.MANAGE",
xFileByte,
xFileName,
txtID.Text.ToUpper().Replace("'", "''"));
}
file.Dispose();
bReturn = true;
}
catch (Exception ex)
{
bReturn = false;
}
return(bReturn);
}
/************************************************************
* Function name : BindHitCnt
* Purpose : 공지사항 조회시 조회숫자 Count 메서드
*
* Input : string rSeq (공지사항 번호)
* Output : void
*************************************************************/
#region public void BindHitCnt(string rSeq)
public void BindHitCnt(string rSeq)
{
try
{
//SetNoticeHitCnt
string xRtn = Boolean.FalseString;
string xScriptMsg = string.Empty;
xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMUNITY.vp_y_community_notice_md",
"SetNoticeHitCnt",
LMS_SYSTEM.COMMUNITY,
"CLT.WEB.UI.LMS.COMMUNITY.edu_notice_detail",
(object)rSeq);
if (xRtn == Boolean.FalseString)
{
//xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');</script>";
ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture));
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : btnSearch_Click
* Purpose : 기간별 개설과정 조회버튼
* Input : void
* Output : void
*************************************************************/
#region protected void btnSearch_Click(object sender, EventArgs e)
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(this.txtCus_From.Text))
{
ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "조회기간" }, new string[] { "Date From" }, Thread.CurrentThread.CurrentCulture));
return;
}
else if (string.IsNullOrEmpty(this.txtCus_To.Text))
{
ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "조회기간" }, new string[] { "Date To" }, Thread.CurrentThread.CurrentCulture));
return;
}
string[] xParams = new string[2];
xParams[0] = this.txtCus_From.Text;
xParams[1] = this.txtCus_To.Text;
this.ddlCus_Date.ClearSelection();
DataTable xDt = new DataTable();
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_m_sms_md",
"GetCourseDate",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION", (object)xParams, Thread.CurrentThread.CurrentCulture);
WebControlHelper.SetDropDownList(this.ddlCus_NM, xDt, "course_nm", "course_id");
//this.ddlCus_NM.Items.FindByValue("11030001").Selected = true;
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}
/******************************************************************************************
* Function name : BindData
* Purpose :
* Input : void
* Output : void
******************************************************************************************/
#region private void BindData()
private void BindData()
{
try
{
string[] xParams = new string[1];
DataTable xDt = null;
if (ViewState["COURSE_ID"].ToString() == string.Empty)
{
return;
}
xParams[0] = ViewState["COURSE_ID"].ToString();
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_course_md",
"GetCourseSubjectList",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", ViewState["COURSE_ID"].ToString());
foreach (DataRow dr in xDt.Rows)
{
this.lstItemList.Items.Add(dr[0].ToString());
}
this.lblItemsCount.Text = this.lstItemList.Items.Count.ToString();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private void BindDDLApproval()
{
try
{
// 평가대상
if (!Util.IsNullOrEmptyObject(ddlStepGu.SelectedValue))
{
string[] xParams = new string[1];
xParams[0] = ddlStepGu.SelectedValue;
DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md",
"GetDtApprTarget",
LMS_SYSTEM.CAPABILITY,
"CLT.WEB.UI.LMS.APPR", (object)xParams, Thread.CurrentThread.CurrentCulture);
WebControlHelper.SetDropDownList(this.ddlAppDutyStep, xDt, "D_KNM", "D_CD", WebControlHelper.ComboType.NullAble);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/******************************************************************************************
* Function name : ddlInOut_SelectIndexChange
* Purpose :
* Input : void
* Output : void
******************************************************************************************/
protected void ddlInOut_SelectIndexChange(object sender, EventArgs e)
{
try
{
string xInOut = this.ddlInOut.SelectedItem.Value;
string[] xParams = new string[1];
DataTable xDt = null;
xParams[0] = string.Empty;
if (xInOut == "000001")
{
//사내
xParams[0] = "0008";
}
else if (xInOut == "000002")
{
//사외
xParams[0] = "0009";
}
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetCommonCodeInfo",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
WebControlHelper.SetDropDownList(this.ddlPlace, xDt, WebControlHelper.ComboType.NullAble);
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}
/************************************************************
* Function name : btnExcel_Click
* Purpose : 조회 조건에 대한 결과를 Excel로 출력하는 처리
* Input : void
* Output : void
*************************************************************/
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
DataTable xDt = null;
string[] xParams = new string[4];
// 조회조건이 있을 경우 처리
xParams = new string[9];
xParams[0] = string.Empty;
xParams[1] = string.Empty;
xParams[2] = this.txtTextBookNM.Text; // textbook_nm
xParams[3] = this.ddlTextBookType.SelectedItem.Value.Replace("*", ""); // textbook_type
xParams[4] = this.ddlCourseGroup.SelectedItem.Value.Replace("*", ""); // course_group
xParams[5] = this.ddlCourseField.SelectedItem.Value.Replace("*", ""); // course_field
xParams[6] = this.ddlTextBookLang.SelectedItem.Value.Replace("*", ""); // textbook_lang
xParams[7] = this.txtBeginDt.Text; // ins_begin_dt
xParams[8] = this.txtEndDt.Text; // ins_end_dt
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_textbook_md",
"GetTextBookInfoForExcel",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams);
string[] xHeader = new string[9];
if (this.IsSettingKorean())
{
xHeader[0] = "No.";
xHeader[1] = "분류";
xHeader[2] = "교재명";
xHeader[3] = "저자";
xHeader[4] = "출판사";
xHeader[5] = "언어";
xHeader[6] = "등록자";
xHeader[7] = "등록일자";
xHeader[8] = "사용여부";
}
else
{
xHeader[0] = "No.";
xHeader[1] = "Type";
xHeader[2] = "TextBook Name";
xHeader[3] = "Author";
xHeader[4] = "Publisher";
xHeader[5] = "Language";
xHeader[6] = "Ins User";
xHeader[7] = "Ins Date";
xHeader[8] = "Usage";
}
this.GetExcelFile(xDt, xHeader);
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}
string xMenuGubun = string.Empty; //사용자 그룹에 대한 화면 Menu 권한
#region 기타 프로시저 그룹 [Core Logic]
private DataSet GetDsGrdList(string rGubun)
{
DataSet xDs = null;
try
{
string[] xParams = new string[7];
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = Util.ForbidText(txtUserNMKor.Text);
xParams[3] = Util.ForbidText(txtUserId.Text);
xParams[4] = ddlDutyStep.SelectedValue;
xParams[5] = Util.ForbidText(txtPersonalNo.Text);
xParams[6] = xMenuGubun;
xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduTrainigRecordList",
LMS_SYSTEM.EDUMANAGEMENT,
"CLT.WEB.UI.LMS.EDUM",
(object)xParams,
rGubun, Thread.CurrentThread.CurrentCulture);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
return(xDs);
}
/******************************************************************************************
* Function name : BindData
* Purpose : 넘겨받은 grade에 해당하는 데이터를 페이지의 컨트롤에 바인딩 처리
* Input : void
* Output : void
******************************************************************************************/
private void BindData()
{
try
{
string[] xParams = new string[1];
DataTable xDt = null;
xParams[0] = ViewState["grade"].ToString();
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md",
"GetApprCodeInfo",
LMS_SYSTEM.CAPABILITY,
"CLT.WEB.UI.LMS.APPR", (object)xParams);
if (xDt != null && xDt.Rows.Count > 0)
{
DataRow dr = xDt.Rows[0];
this.txtGrade.Text = dr["grade"].ToString();
this.txtGradeNM.Text = dr["grade_nm"].ToString();
this.txtScore.Text = dr["score"].ToString();
this.txtGradeDesc.Text = dr["grade_desc"].ToString();
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private void InitControl()
{
try
{
string[] xParams = new string[2];
string xSql = string.Empty;
// 직급코드 Dutystep
xParams[1] = "Y";
DataTable xDtDutyStep = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetDutystepCodeInfo",
LMS_SYSTEM.MANAGE,
"CLT.WEB.UI.LMS.MANAGE"
, (object)xParams
, Thread.CurrentThread.CurrentCulture
);
WebControlHelper.SetDropDownList(this.ddlDutyStep, xDtDutyStep, "step_name", "duty_step", WebControlHelper.ComboType.NullAble);
this.SetGridClear(this.grdList, this.PageNavigator1, this.PageInfo1);
//btnDel.OnClientClick = "return confirm('" + MsgInfo.GetMsg("A119", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture) + @"');";
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private void Report_Mypage_Certificate(string rRptName)
{
try
{
string xOpencourse = Request.QueryString["open_course_id"];
string xUser = Request.QueryString["user_id"];
if (string.IsNullOrEmpty(xUser))
{
string[] xPara = xOpencourse.Split('|');
iDtCourseResult = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_s_record_md",
"GetAgreementCertificateReport",
LMS_SYSTEM.EDUMANAGEMENT,
"CLT.WEB.UI.LMS.EDUM", (object)xPara, "");
}
else
{
iDtCourseResult = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MYPAGE.vp_p_training_md",
"GetTrainingReport",
LMS_SYSTEM.EDUMANAGEMENT,
"CLT.WEB.UI.LMS.EDUM", xOpencourse, xUser, "");
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private void BindDropDownList()
{
try
{
string[] xParams = new string[1];
string xSql = string.Empty;
DataTable xDt = null;
// UserGroupCode
xParams[0] = "0041";
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetCommonCodeInfo",
LMS_SYSTEM.MANAGE,
"CLT.WEB.UI.LMS.MANAGE", (object)xParams, Thread.CurrentThread.CurrentCulture);
WebControlHelper.SetDropDownList(this.ddlCourseField, xDt, 0, false);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private void BindGrid()
{
try
{
// OpenCourse 관련 DataBinding 처리
string[] xParams = new string[4];
xParams[0] = "3"; // Count
xParams[1] = "7"; // new icon 일자
xParams[2] = Convert.ToString(Session["company_kind"]); //
xParams[3] = Convert.ToString(Session["user_group"]);
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.MAIN.vp_m_main_md",
"GetRecentOpenCourseInfoCountBy",
LMS_SYSTEM.MAIN,
"CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
SetGrid(xDs.Tables[1], EduNoticeList);
SetGrid(xDs.Tables[0], NoticeList);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindDropDownList
* Purpose : DropDownList 데이터 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
#region private void BindDropDownList()
private void BindDropDownList()
{
try
{
string[] xParams = new string[1];
string xSql = string.Empty;
DataTable xDt = null;
//language
xParams[0] = "0017";
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetCommonCodeInfo",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
WebControlHelper.SetDropDownList(this.ddlLang, xDt);
//classification
xParams[0] = "0042";
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetCommonCodeInfo",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
WebControlHelper.SetDropDownList(this.ddlClassification, xDt);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : btnDel_Click
* Purpose : 평가 코드 삭제
* Input : void
* Output : void
*************************************************************/
protected void btnDel_Click(object sender, EventArgs e)
{
try
{
DataTable xDt = new DataTable();
xDt.Columns.Add("grade");
for (int i = 0; i < this.grdList.Items.Count; i++)
{
if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("chk_sel")).Checked)
{
DataRow xRow = xDt.NewRow();
xRow["GRADE"] = this.grdList.DataKeys[i].ToString();
xDt.Rows.Add(xRow);
}
}
string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md",
"SetApprCodeDelete",
LMS_SYSTEM.CAPABILITY,
"CLT.WEB.UI.LMS.CURR", xDt);
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}
/************************************************************
* Function name : btnExcel_Click
* Purpose :
* Input : void
* Output : void
*************************************************************/
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
string[] xParams = null;
DataTable xDt = null;
//if (string.IsNullOrEmpty(this.txtContentsNM.Text) && string.IsNullOrEmpty(this.txtRemark.Text) && this.ddlContentsLang.SelectedItem.Text == "*" && this.ddlContentsType.SelectedItem.Text == "*")
// 조회조건이 있을 경우 처리
xParams = new string[9];
xParams[0] = string.Empty;
xParams[1] = string.Empty;
xParams[2] = this.ddlGroup.SelectedValue.Replace("*", "");
xParams[3] = this.ddlField.SelectedValue.Replace("*", "");
xParams[4] = this.ddlType.SelectedValue.Replace("*", "");
xParams[5] = this.ddlVslType.SelectedValue.Replace("*", "");
xParams[6] = this.ddlLang.SelectedValue.Replace("*", "");
xParams[7] = this.txtCourseNm.Text;
xParams[8] = this.ddlUse.SelectedValue.Replace("*", "");
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_course_md",
"GetCourseList_Excel",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.CURR", (object)xParams);
string[] xHeader = new string[9];
if (this.IsSettingKorean())
{
xHeader[0] = "No.";
xHeader[1] = "과정유형";
xHeader[2] = "과정코드";
xHeader[3] = "과정명";
xHeader[4] = "유효기간";
xHeader[5] = "언어";
xHeader[6] = "선종";
xHeader[7] = "Usage";
xHeader[8] = "등록일자";
}
else
{
xHeader[0] = "No.";
xHeader[1] = "Course Type";
xHeader[2] = "Course Code";
xHeader[3] = "Course Name";
xHeader[4] = "Expired period";
xHeader[5] = "Language";
xHeader[6] = "Vessel Type";
xHeader[7] = "Usage";
xHeader[8] = "Reg. Date";
}
this.GetExcelFile(xDt, xHeader);
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}
private void BindDDLTypeC()
{
try
{
// 평가대상
string[] xParams = new string[2];
xParams[0] = "Y";
xParams[1] = ddlVslType.SelectedValue;
DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetVCommonVslTypeC",
LMS_SYSTEM.CAPABILITY,
"CLT.WEB.UI.LMS.APPR", (object)xParams);
WebControlHelper.SetDropDownList(this.ddlVslTypeC, xDt, "TYPE_C_DESC", "TYPE_C_CD");
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
public void BIndGrid()
{
try
{
string[] xParams = new string[1];
xParams[0] = Request.QueryString["rSMSGroupNo"].ToString();
DataTable xDt = new DataTable();
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_m_sms_md",
"GetSMSListDetail",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION", (object)xParams);
this.txtContent.Text = xDt.Rows[0]["sent_sms"].ToString();
this.C1WebGrid1.DataSource = xDt;
this.C1WebGrid1.DataBind();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private void Report_Aggrement_Certificate(string rRptName)
{
try
{
string[] xPara = Request.QueryString["open_course_id"].Split('|');
if (xPara.Length > 0)
{
string xImgPath = @"http://" + Request.Url.Authority + "/report/sign01.jpg";
DataTable xDtCourseResult = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_s_record_md",
"GetAgreementCertificateReport",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION.vp_s_report", (object)xPara, xImgPath);
//xDtCourseResult.Columns.Add("logo1");
//xDtCourseResult.Columns["logo1"].DefaultValue = xImgPath;
//xDtCourseResult.Rows[0]["logo1"] = xImgPath;
C1Report xRpt = C1WebReport1.Report;
xRpt.Load(Request.MapPath("/report/" + rRptName), "Agreement_Certificate_Report");
// 과정 교육 결과 정보 Binding
Field xFSub;
C1Report xSub = new C1Report();
xFSub = xRpt.Fields["Field6"];
xSub = xFSub.Subreport;
xSub.Sections.Detail.OnFormat = "fImage.Picture = logo1";
xSub.DataSource.ConnectionString = string.Empty;
xSub.DataSource.Recordset = xDtCourseResult;
xRpt.DataSource.ConnectionString = string.Empty;
using (MemoryStream oStream = new MemoryStream())
{
xRpt.RenderToStream(oStream, FileFormatEnum.HTMLPaged, "", "Agreement_Certificate_Report.htm");
xRpt.Dispose();
oStream.Position = 0;
string xScrptStr = string.Empty;
xScrptStr += "<script language=\"javascript\">window.onload = function(){window.print();}</script>";
System.Text.ASCIIEncoding encoding = new System.Text.ASCIIEncoding();
string htmlWrite = encoding.GetString(oStream.ToArray());
htmlWrite += xScrptStr;
Response.Clear();
Response.Write(htmlWrite);
Response.End();
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/*************************************************************
* Function name : BindDropDownList
* Purpose : DropDownList Bind 메서드
*
* Input : void
* Output : void
*************************************************************/
#region BindDropDownList()
public void BindDropDownList()
{
try
{
string[] xParams = new string[2];
string xSql = string.Empty;
DataTable xDt = null;
// 회사구분 (그룹사, 사업자 위수탁)
xParams[0] = "0061";
xParams[1] = "Y";
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetCommonCodeInfo",
LMS_SYSTEM.COMMUNITY,
"CLT.WEB.UI.LMS.COMMUNITY", (object)xParams, Thread.CurrentThread.CurrentCulture);
WebControlHelper.SetDropDownList(this.ddlNoticeType, xDt);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : ddlCus_NM_OnSelectedIndexChanged
* Purpose : 과정선택 DropDownList 이벤트
* Input : void
* Output : void
*************************************************************/
#region protected void ddlCus_NM_OnSelectedIndexChanged(object sender, EventArgs e)
protected void ddlCus_NM_OnSelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (this.ddlCus_NM.SelectedItem.Value == "*")
{
return;
}
string[] xParams = new string[3];
xParams[0] = ddlCus_NM.SelectedItem.Value;
xParams[1] = this.txtCus_From.Text;
xParams[2] = this.txtCus_To.Text;
DataTable xDt = new DataTable();
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_m_sms_md",
"GetOpenCourseDate",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION", (object)xParams);
WebControlHelper.SetDropDownList(this.ddlCus_Date, xDt, "course_date", "open_course_id");
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}
private DataSet GetDsGrdList(string rGubun, int rPageIndex)
{
DataSet xDs = null;
try
{
string[] xParams = new string[6];
xParams[0] = this.PageSize.ToString();
//xParams[1] = this.CurrentPageIndex.ToString();
xParams[1] = rPageIndex.ToString();
xParams[2] = iSearch;
string[] rSearch = Util.Split(iSearch, "^", 2);
xParams[4] = rSearch[0];
xParams[5] = rSearch[1];
xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduPassUserList",
LMS_SYSTEM.EDUMANAGEMENT,
"CLT.WEB.UI.LMS.EDUM",
(object)xParams,
rGubun, Thread.CurrentThread.CurrentCulture);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
return(xDs);
}
private DataSet GetDsGrdList(string rGubun)
{
DataSet xDs = null;
try
{
string[] xParams = new string[7];
xParams[0] = "100";
xParams[1] = PageNavigator1.CurrentPageIndex.ToString();
string[] rSearch = Util.Split(Util.Request("search"), "^", 2);
xParams[2] = rSearch[0];
xParams[3] = rSearch[1];
xParams[4] = ddllNationality.SelectedValue;
xParams[5] = rdoInsu_Y.Checked ? "Y" : "N";
xParams[6] = ddlRank.SelectedValue;
xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduList",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION",
(object)xParams,
rGubun);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
return(xDs);
}
public bool CheckData()
{
try
{
string xExcessChk = Boolean.TrueString;
// 직책 or 직급이 수강신청 대상에 해당하는 경우를 찾는다.
string[] xChkParams = new string[2];
xChkParams[0] = Request.QueryString["OPEN_COURSE_ID"].ToString();
xChkParams[1] = Session["USER_ID"].ToString();
xExcessChk = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPLICATION.vp_s_received_md",
"GetCompareRcvCount",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION", (object)xChkParams);
if (xExcessChk == Boolean.TrueString)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(true);
}
}
private void InitControl2()
{
try
{
string[] xParams = new string[1];
//교육불가사유코드(0011)
if (Util.IsNullOrEmptyObject(iDtNonApproval))
{
//course type
xParams = new string[2];
xParams[0] = "0011";
xParams[1] = "Y";
iDtNonApproval = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetCommonCodeInfo",
LMS_SYSTEM.CURRICULUM,
"CLT.WEB.UI.LMS.EDU", (object)xParams, Thread.CurrentThread.CurrentCulture);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private DataTable GetDtGrdList(string rGubun)
{
DataTable xDt = new DataTable();
try
{
string[] xParams = new string[7];
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = Util.ForbidText(txtSTART_DATE.Text);
xParams[3] = Util.ForbidText(txtEND_DATE.Text);
xParams[4] = ddlCourseType.SelectedValue;
xParams[5] = Util.ForbidText(txtUserNMKor.Text);
xParams[6] = Util.ForbidText(txtCourseNM.Text);
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduIssuingHistory",
LMS_SYSTEM.EDUMANAGEMENT,
"CLT.WEB.UI.LMS.EDUM",
(object)xParams,
rGubun, Thread.CurrentThread.CurrentCulture);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
return(xDt);
}
/************************************************************
* Function name : BindDropDownList
* Purpose : DropDownList 데이터 바인딩을 위한 처리
* Input : void
* Output : void
*************************************************************/
#region BindDropDownList()
private void BindDropDownList()
{
try
{
string[] xParams = new string[2];
string xSql = string.Empty;
DataTable xDt = null;
// 직급(직위) 해당 직급은 법인사 관리자에게만 해당되며, 인사시스템에서 사용하는 직급이아님!(사장, 과장, 부장 등...)
xParams[0] = "0023";
xParams[1] = "Y";
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetCommonCodeInfo",
LMS_SYSTEM.MANAGE,
"CLT.WEB.UI.LMS.MANAGE", (object)xParams, Thread.CurrentThread.CurrentCulture);
WebControlHelper.SetDropDownList(this.ddlComapnyduty, xDt);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private DataTable GetDtApprCode()
{
DataTable xDt = null;
try
{
if (iDt != null)
{
xDt = iDt;
}
else
{
string[] xParams = new string[1];
xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md",
"GetApprCode_Excel",
LMS_SYSTEM.CAPABILITY,
"CLT.WEB.UI.LMS.APPR",
(object)xParams);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
return(xDt);
}
