//전체해상직원
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 DataSet GetDsGrdList(string rGubun)
{
this.PageSize = 10;
DataSet xDs = null;
try
{
string[] xParams = new string[6];
xParams[0] = "10";// this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = iSearch;
xParams[3] = ddlApprovalFlg.SelectedValue;
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",
"GetEduApprovalUserList",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION",
(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, 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);
}
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;
}
}
}
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",
"GetEduPassList",
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);
}
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);
}
private void BindUserList()
{
try
{
string[] xParams = new string[8];
xParams[0] = this.PageSize.ToString();
xParams[1] = this.CurrentPageIndex.ToString();
xParams[2] = Util.ForbidText(txtUserId.Text);
xParams[3] = ddlDeptCode.SelectedValue;
xParams[4] = Util.ForbidText(txtUserNMKor.Text).ToUpper();
xParams[5] = Util.ForbidText(txtPersonalNo.Text);
xParams[6] = ddlDutyStep.SelectedValue;
xParams[7] = iAppCD;
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md",
"GetUserList",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPR",
(object)xParams, Thread.CurrentThread.CurrentCulture);
DataTable xDtTotalCnt = xDs.Tables[0];
DataTable xDt = xDs.Tables[1];
if (Convert.ToInt32(xDtTotalCnt.Rows[0][0]) < 1)
{
this.PageInfo1.PageSize = this.PageSize;
this.PageInfo1.TotalRecordCount = 0;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.PageSize = this.PageSize;
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDtTotalCnt.Rows[0][0]);
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDtTotalCnt.Rows[0][0]) - 1;
}
grdUserList.DataSource = xDt;
grdUserList.DataBind();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
/************************************************************
* Function name : BindGrid
* Purpose : C1WebGrid 데이터 바인딩을 위한 처리
* 평가 항목 바인딩 처리
* Input : void
* Output : void
*************************************************************/
private void BindGrid()
{
try
{
string[] xParams = new string[3];
xParams[0] = this.PageSize.ToString(); // pagesize
xParams[1] = this.CurrentPageIndex.ToString(); // pageno
xParams[2] = "";
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md",
"GetApprItem",
LMS_SYSTEM.CAPABILITY,
"CLT.WEB.UI.LMS.APPR", (object)xParams, Thread.CurrentThread.CurrentCulture);
DataTable xDtTotalCnt = xDs.Tables[0];
DataTable xDt = xDs.Tables[1];
if (Convert.ToInt32(xDtTotalCnt.Rows[0][0]) < 1)
{
this.PageInfo1.PageSize = this.PageSize;
this.PageInfo1.TotalRecordCount = 0;
this.PageNavigator1.TotalRecordCount = 0;
}
else
{
this.PageInfo1.PageSize = this.PageSize;
this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDtTotalCnt.Rows[0][0]);
this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDtTotalCnt.Rows[0][0]) - 1;
}
grdList.DataSource = xDt;
grdList.DataBind();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
private DataSet GetDsGrdList(string rGubun)
{
DataSet xDs = null;
try
{
string[] xParams = new string[14];
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] = ddlInquiry.SelectedValue;
xParams[5] = ddlVslType.SelectedValue;
xParams[6] = ddlShipCode.SelectedValue;
xParams[7] = "";
xParams[8] = ddlAppDutyStep.SelectedValue;
xParams[9] = ddlRePayYN.SelectedValue;
xParams[10] = Convert.ToString(Session["USER_ID"]);
xParams[11] = Convert.ToString(Session["USER_GROUP"]);
xParams[12] = ddlVslTypeC.SelectedValue;
xParams[13] = xMenuGubun;
xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md",
"GetApprList",
LMS_SYSTEM.CAPABILITY,
"CLT.WEB.UI.LMS.APPR",
(object)xParams,
rGubun, Thread.CurrentThread.CurrentCulture);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
return(xDs);
}
private void Report_Aggrement(string rRptName)
{
try
{
string[] xPara = new string[3] {
Session["COMPANY_ID"].ToString(), Request.QueryString["open_course_id"], Session["COMPANY_KIND"].ToString()
};
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.APPLICATION.vp_s_agreement_md",
"GetAgreementReport",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION.vp_s_report", (object)xPara);
DataTable xDtCompany = xDs.Tables["t_company"];
DataTable xDtCourseResult = xDs.Tables["t_course_result"];
DataTable xDtCourse = xDs.Tables["t_course"];
DataTable xDtTextBook = xDs.Tables["t_textbook"];
DataTable xDtCourseResultCnt = xDs.Tables["t_course_result_cnt"];
int xFee = 0;
int xTotalFee = 0;
if (Convert.ToString(xDtCourse.Rows[0]["training_fee"]) != "")
{
xFee = Convert.ToInt32(xDtCourse.Rows[0]["training_fee"]);
xTotalFee = xFee * (Convert.ToString(xDtCourseResultCnt.Rows[0]["user_cnt"]) == "" ? 0 : Convert.ToInt32(xDtCourseResultCnt.Rows[0]["user_cnt"]));
}
C1WebReport1.Report.UsePrinterResolution = false;
//C1WebReport1.NavigationBar.HasGotoPageButton = true;
//C1WebReport1.EnableCallback = true;
//C1WebReport1.NavigationBar.HasExportButton = true;
//C1.Web.C1WebReport.ExportFormatsEnum formats = 0;
//formats = formats | C1.Web.C1WebReport.ExportFormatsEnum.XLS;
//C1WebReport1.NavigationBar.ExportFormats = formats;
//C1WebReport1.ExportRenderMethod = C1.Web.C1WebReport.ExportRenderMethodEnum.File;
//C1WebReport1.NavigationBar.Visible = true;
C1Report xRpt = C1WebReport1.Report;
xRpt.Load(Request.MapPath("/report/" + rRptName), "Agreement_Report");
xRpt.Fields["agree_title"].Text = string.Format("본 계약의 '{0}'(이하 '갑'이라 한다.)와 '한진해운 운항훈련원((주)유수에스엠)'(이하 '을'이라 한다.)은 '갑'의 {1}에 대한 위탁계약을 다음과 같이 체결한다.",
Convert.ToString(xDtCompany.Rows[0]["company_nm"]),
Convert.ToString(xDtCourse.Rows[0]["course_nm"]));
xRpt.Fields["agree_no1"].Text = string.Format("제1조(계약범위)\r\n '갑'이 위탁한 {0} 및 수행을 위한 다음 사항을 계약의 범위로 한다.\r\n 가. 훈련과정은 노동부로부터 지정받은 훈련과정으로 다음과 같다.",
Convert.ToString(xDtCourse.Rows[0]["course_nm"]));
xRpt.Fields["agree_no2"].Text = " 나. '갑'의 훈련요구에 따른 훈련운영에 관란 사항에 대한 협조\r\n 다. 고용보험 환급에 관한 사항 '갑'이 고용보험 환급을 받기 위해 필요한 제반 사항에 대한 협조";
xRpt.Fields["agree_no3"].Text = string.Format("제2조(계약기간 및 인원)\r\n 가. 계약기간은 {0}을 수행하는 훈련기간을 의미한다.\r\n 나. 훈련기간 및 훈련인원\r\n 1) 훈련기간 : {1}\r\n 2) 인원 : {2}명",
Convert.ToString(xDtCourse.Rows[0]["course_nm"]),
Convert.ToString(xDtCourse.Rows[0]["course_begin_dt"]) + "~" + Convert.ToString(xDtCourse.Rows[0]["course_end_dt"]),
Convert.ToString(xDtCourseResultCnt.Rows[0]["user_cnt"]));
// 과정 정보 Binding
string xTmp = null;
xRpt.Fields["agree_no1_1"].Text = Convert.ToString(xDtCourse.Rows[0]["course_nm"]);
xRpt.Fields["agree_no1_2"].Text = Convert.ToString(xDtCourse.Rows[0]["course_day_time"]);
xRpt.Fields["agree_no1_3"].Text = Convert.ToString(xDtCourse.Rows[0]["class_man_count"]);
xTmp = Convert.ToString(xDtCourse.Rows[0]["course_begin_dt"]) + "\r\n~\r\n" + Convert.ToString(xDtCourse.Rows[0]["course_end_dt"]);
xRpt.Fields["agree_no1_4"].Text = xTmp;
xTmp = null;
foreach (DataRow dr in xDtTextBook.Rows)
{
xTmp += Convert.ToString(dr["textbook_nm"]) + "/";
}
xRpt.Fields["agree_no1_5"].Text = xTmp;
xRpt.Fields["agree_no1_6"].Text = string.Format("{0:#,##0}", xFee);
xRpt.Fields["agree_no4"].Text = string.Format("제3조(계약금액 및 지급)\r\n 가. 총 계약금액은 {0}원 으로 한다.\r\n 본 금액은 1인당 {1}원이며, 훈련인원의 변경시 자동 조정된다.",
string.Format("{0:#,##0}", xTotalFee),
string.Format("{0:#,##0}", xFee));
xRpt.Fields["agree_no9"].Text = DateTime.Now.Year.ToString() + "년 " + DateTime.Now.Month.ToString() + "월 " + DateTime.Now.Day.ToString() + "일";
//xRpt.Fields["agree_no7"].Text = string.Format("갑\r\n\r\n회사명 {0}\r\n\r\n대 표 자 {1} (인)", Convert.ToString(xDtCompany.Rows[0]["company_nm"]), Convert.ToString(xDtCompany.Rows[0]["company_ceo"]));
// 과정 교육 결과 정보 Binding
Field xFSub;
C1Report xSub = new C1Report();
xFSub = xRpt.Fields["Field6"];
xSub = xFSub.Subreport;
xSub.DataSource.ConnectionString = string.Empty;
xSub.DataSource.Recordset = xDtCourseResult;
xRpt.DataSource.ConnectionString = string.Empty;
string xImgPath = @"http://" + Request.Url.Authority + "/report/sign02.gif";
xRpt.Fields["logo1"].Picture = xImgPath;
//RegistryKey xRegkey = Registry.CurrentUser;
//xRegkey = xRegkey.OpenSubKey(@"Software\Microsoft\Internet Explorer\PageSetup", true);
//string xFooter = string.Empty;
//string xHeader = string.Empty;
//string xMarginBottom = string.Empty;
//string xMarginLeft = string.Empty;
//string xMarginRight = string.Empty;
//string xMarginTop = string.Empty;
//if (xRegkey != null)
//{
// xFooter = xRegkey.GetValue("footer").ToString();
// xMarginBottom = xRegkey.GetValue("margin_bottom").ToString();
// xMarginLeft = xRegkey.GetValue("margin_left").ToString();
// xMarginRight = xRegkey.GetValue("margin_right").ToString();
// xMarginTop = xRegkey.GetValue("margin_top").ToString();
// xRegkey.SetValue("footer", "", RegistryValueKind.String);
// xRegkey.SetValue("margin_bottom", "0.78740", RegistryValueKind.String);
// xRegkey.SetValue("margin_left", "0.59055", RegistryValueKind.String);
// xRegkey.SetValue("margin_right", "0.59055", RegistryValueKind.String);
// xRegkey.SetValue("margin_top", "0.78740", RegistryValueKind.String);
//}
////Thread.Sleep(3000);
//xRegkey.SetValue("footer", xFooter, RegistryValueKind.String);
//xRegkey.SetValue("margin_bottom", xMarginBottom, RegistryValueKind.String);
//xRegkey.SetValue("margin_left", xMarginLeft, RegistryValueKind.String);
//xRegkey.SetValue("margin_right", xMarginRight, RegistryValueKind.String);
//xRegkey.SetValue("margin_top", xMarginTop, RegistryValueKind.String);
using (MemoryStream oStream = new MemoryStream())
{
xRpt.RenderToStream(oStream, FileFormatEnum.HTMLPaged, "", "Agreement_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;
}
}
}
private void Report_Aggrement_List(string rRptName)
{
try
{
string[] xPara = Request.QueryString["open_course_id"].Split('|');
if (xPara.Length > 0)
{
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.APPLICATION.vp_s_record_md",
"GetAgreementListReport",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION.vp_s_report", (object)xPara);
DataTable xDtCourseResult = xDs.Tables["t_course_result"];
DataTable xDtCourseResultSum = xDs.Tables["t_course_result_sum"];
C1Report xRpt = C1WebReport1.Report;
xRpt.Load(Request.MapPath("/report/" + rRptName), "Agreement_List_Report");
xRpt.Fields["agree_list_datetime"].Text = DateTime.Now.Year.ToString() + "년 " + DateTime.Now.Month.ToString() + "월 " + DateTime.Now.Day.ToString() + "일";
if (xDtCourseResultSum != null && xDtCourseResultSum.Rows.Count > 0)
{
xRpt.Fields["training_fee_sum"].Text = Convert.ToString(xDtCourseResultSum.Rows[0]["training_fee_sum"]);
xRpt.Fields["training_fee_tax_sum"].Text = Convert.ToString(xDtCourseResultSum.Rows[0]["training_fee_tax_sum"]);
xRpt.Fields["training_fee_total"].Text = Convert.ToString(xDtCourseResultSum.Rows[0]["training_fee_total"]);
xRpt.Fields["company_scale_fee_sum"].Text = Convert.ToString(xDtCourseResultSum.Rows[0]["company_scale_fee_sum"]);
}
// 과정 교육 결과 정보 Binding
Field xFSub;
C1Report xSub = new C1Report();
xFSub = xRpt.Fields["Field6"];
xSub = xFSub.Subreport;
xSub.DataSource.ConnectionString = string.Empty;
xSub.DataSource.Recordset = xDtCourseResult;
xRpt.DataSource.ConnectionString = string.Empty;
string xImgPath = @"http://" + Request.Url.Authority + "/report/sign01.jpg";
xRpt.Fields["logo1"].Picture = xImgPath;
using (MemoryStream oStream = new MemoryStream())
{
xRpt.RenderToStream(oStream, FileFormatEnum.HTMLPaged, "", "Agreement_List_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;
}
}
}
private void Report_Aggrement_Contract(string rRptName)
{
try
{
string[] xPara = new string[3] {
Session["COMPANY_ID"].ToString(), Request.QueryString["open_course_id"], Session["COMPANY_KIND"].ToString()
};
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.APPLICATION.vp_s_agreement_md",
"GetAgreementContractReport",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION.vp_s_report", (object)xPara);
DataTable xDtCompany = xDs.Tables["t_company"];
DataTable xDtCourseResult = xDs.Tables["t_course_result"];
DataTable xDtCourse = xDs.Tables["t_course"];
C1Report xRpt = C1WebReport1.Report;
xRpt.Load(Request.MapPath("/report/" + rRptName), "Agreement_Contract_Report");
if (xDtCourse != null && xDtCourse.Rows.Count > 0)
{
xRpt.Fields["course_nm"].Text = Convert.ToString(xDtCourse.Rows[0]["course_nm"]);
xRpt.Fields["course_begin_end_dt"].Text = Convert.ToString(xDtCourse.Rows[0]["course_begin_dt"]) + "~" + Convert.ToString(xDtCourse.Rows[0]["course_end_dt"]);
}
if (xDtCompany != null && xDtCompany.Rows.Count > 0)
{
xRpt.Fields["company_ceo"].Text = Convert.ToString(xDtCompany.Rows[0]["company_ceo"]);
xRpt.Fields["company_addr"].Text = Convert.ToString(xDtCompany.Rows[0]["company_addr"]);
xRpt.Fields["company_nm"].Text = Convert.ToString(xDtCompany.Rows[0]["company_nm"]);
xRpt.Fields["company_ceo_bottom"].Text = Convert.ToString(xDtCompany.Rows[0]["company_ceo"]) + " (인)";
}
if (xDtCourse != null && xDtCourse.Rows.Count > 0)
{
xRpt.Fields["agree_contract_text"].Text = string.Format(" 위 훈련생을 {0}({1}) 수료 후 정당한 사유가 없는 한 채용할 예정이며 훈련생에게 채용 후 근로조건(급여 및 복지 등)에 관한 사항을 설명하였음을 확인 합니다.",
Convert.ToString(xDtCourse.Rows[0]["course_nm"]),
Convert.ToString(xDtCourse.Rows[0]["course_begin_dt"]) + "~" + Convert.ToString(xDtCourse.Rows[0]["course_end_dt"]));
}
xRpt.Fields["agree_contract_datetime"].Text = DateTime.Now.Year.ToString() + "년 " + DateTime.Now.Month.ToString() + "월 " + DateTime.Now.Day.ToString() + "일";
// 과정 교육 결과 정보 Binding
Field xFSub;
C1Report xSub = new C1Report();
xFSub = xRpt.Fields["Field6"];
xSub = xFSub.Subreport;
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_Contract_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;
}
}
}
private void GetReport()
{
FileStream xNewFile = null;
try
{
string[] xPara = Request.QueryString["keys"].Split('|');
if (xPara.Length > 0)
{
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduIssuingUserReport",
LMS_SYSTEM.EDUMANAGEMENT,
"CLT.WEB.UI.LMS.EDUM"
, (object)xPara);
iDtCourseResult = xDs.Tables["table0"];
//DataTable xDtLecturer = xDs.Tables["table1"];
if (iDtCourseResult.Rows.Count > 0)
{
if (Convert.ToDouble(iDtCourseResult.Rows[0]["REPORT_TYPE_ID"].ToString()) > 10)
{
Response.Redirect("issuing_report_old.aspx?keys=" + Request.QueryString["keys"]);
}
}
//이미지저장
string xUrl = "http://" + Request.Url.Authority;
string xFilePath = "/file/tempfile/report";
string xFileFullPath = "";
for (int i = 0; i < iDtCourseResult.Rows.Count; i++)
{
xFileFullPath = "";
if (iDtCourseResult.Rows[i]["pic_file"] != DBNull.Value)
{
byte[] xImgByte = (byte[])iDtCourseResult.Rows[i]["pic_file"];
string fileName = Convert.ToString(iDtCourseResult.Rows[i]["pic_file_nm"]);
string xFilePathCurr = Server.MapPath(xFilePath + "/" + fileName);
xNewFile = new FileStream(xFilePathCurr, FileMode.Create);
xNewFile.Write(xImgByte, 0, xImgByte.Length);
xNewFile.Close();
xFileFullPath = xUrl + xFilePath + "/" + fileName;
}
iDtCourseResult.Rows[i]["pic_file_nm"] = xFileFullPath;
/* 강사명 고정
* for (int j = 0; j < xDtLecturer.Rows.Count; j++)
* {
* string xLecturerNM = Convert.ToString(iDtCourseResult.Rows[i]["LECTURER_NM"]);
* if (!string.IsNullOrEmpty(xLecturerNM))
* xLecturerNM = xLecturerNM + "|";
* iDtCourseResult.Rows[i]["LECTURER_NM"] = xLecturerNM + Convert.ToString(xDtLecturer.Rows[j]["LECTURER_NM"]);
* }
* */
iDtCourseResult.Rows[i]["REPORT_CNT"] = string.Format("{0:000#}", Convert.ToInt32(iDtCourseResult.Rows[i]["REPORT_CNT"]) + i + 1);
if (string.IsNullOrEmpty(Convert.ToString(iDtCourseResult.Rows[i]["birth_dt"])))
{
if (!string.IsNullOrEmpty(Convert.ToString(iDtCourseResult.Rows[i]["personal_no"])) && Convert.ToString(iDtCourseResult.Rows[i]["personal_no"]).Length > 6)
{
string xYear = "19";
string xCond = Convert.ToString(iDtCourseResult.Rows[i]["personal_no"]).Substring(7, 1);
if (xCond == "3" || xCond == "4" || xCond == "7" || xCond == "8")
{
xYear = "20";
}
string xBirthDay = Convert.ToString(iDtCourseResult.Rows[i]["personal_no"]).Substring(0, 6);
iDtCourseResult.Rows[i]["birth_dt"] = xYear + "" + xBirthDay.Substring(0, 2) + "." + xBirthDay.Substring(2, 2) + "." + xBirthDay.Substring(4, 2);
DateTime xBirthDt = Convert.ToDateTime(iDtCourseResult.Rows[i]["birth_dt"]);
iDtCourseResult.Rows[i]["birth_dt_eng"] = xBirthDt.ToString("MMMM", System.Globalization.CultureInfo.InvariantCulture) + " " + Convert.ToInt32(xBirthDt.ToString("dd")) + ", " + xBirthDt.ToString("yyyy");
}
}
//if (Convert.ToString(iDtCourseResult.Rows[i]["COUNTRY_KIND"]) == "KR")
//{
// iDtCourseResult.Rows[i]["COUNTRY_KIND_NM"] = "R.O.KOREA";
//}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//DateTime xBeginDt = Convert.ToDateTime(iDtCourseResult.Rows[i]["course_begin_dt"]);
//DateTime xEndDt = Convert.ToDateTime(iDtCourseResult.Rows[i]["course_end_dt"]);
//iDtCourseResult.Rows[i]["course_begin_dt_eng"] = xBeginDt.ToString("dd") + "th " + xBeginDt.ToString("MMM", System.Globalization.CultureInfo.InvariantCulture) + ", " + xBeginDt.ToString("yyyy");
//iDtCourseResult.Rows[i]["course_end_dt_eng"] = xEndDt.ToString("dd") + "th " + xEndDt.ToString("MMM", System.Globalization.CultureInfo.InvariantCulture) + ", " + xEndDt.ToString("yyyy");
//if (Convert.ToInt16(xBeginDt.ToString("yyyy")) >= 2008 && iDtCourseResult.Rows[i]["COURSE_GUBUN"].ToString() == "Y") // 국토해양부 과정이면
//{
//pnl0.Visible = true; //국토해양부 로고 표시
//pnl1.Visible = false;
//}
//else
//{
//pnl0.Visible = false; //국토해양부 로고 미표시
//pnl1.Visible = true;
//}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
string xReportDescKor = "";
string xReportDescEng = "";
switch (iDtCourseResult.Rows[i]["REPORT_TYPE_ID"])
{
case "000001":
//1. 선박조종시뮬레이터 교육
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제 Ⅰ장 표 A-Ⅰ/12, 제Ⅱ장 A-Ⅱ/1, A-Ⅱ/2 및 B-Ⅰ/12, B-V/a의 규정에 의거하여 실시한 선박조종시뮬레이터 교육 과정을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person has successfully completed a course \"Ship Handling Simulator\" in accordance with the provision of ChapterⅠ Section A-Ⅰ/12, Chapter Ⅱ Section A Tables A-Ⅱ/1, A-Ⅱ/2 and Section B-Ⅰ/12 and B-V/a of STCW Convention & Code(1978 and 2010 Amendment), applicable to issue of this certificate.";
break;
case "000002":
//2. 선박모의조종 및 선교 팀워크 교육
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제 Ⅰ장 표 A-Ⅰ/12, 제Ⅱ장 A-Ⅱ/1, A-Ⅱ/2 및 IMO Model Course 1.22의 규정에 의거하여 실시한 선박 모의조종 및 선교 팀워크 교육 과정을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person has successfully completed a course \"Ship Simulator and Bridge Teamwork\" in accordance with the provision of Chapter Ⅰ Section A-Ⅰ/12, Chapter Ⅱ Section A Tables A-Ⅱ/1, A-Ⅱ/2 of STCW Convention & Code(1978 and 2010 Amendment) and IMO Model Course 1.22, applicable to issue of this certificate.";
break;
case "000003":
//3. 엔진룸 시뮬레이터 교육
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제 Ⅲ장 표 A-Ⅲ/1의 규정에 의거하여 실시한 엔진룸 시뮬레이터 교육 과정을<br>수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person has successfully completed a course \"Engine Room Simulator\" in accordance with the provision of Chapter Ⅲ Section A Tables A-Ⅲ/1 of STCW Convention & Code (1978 and 2010 Amendment), applicable to issue of this certificate.";
break;
case "000004":
//4. 전자해도장치 교육
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제Ⅱ장 A-Ⅱ/1, A-Ⅱ/2, A-Ⅱ/3 및 IMO Model Course 1.27의 규정에 의거하여 전자해도장치 (ECDIS) 교육 과정을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person has successfully completed a course \"The operational use of Electronic Chart Display and Information System(ECDIS)\" in accordance with the provision of Chapter Ⅱ Section A Tables A-Ⅱ/1, A-Ⅱ/2 and A-Ⅱ/3 of STCW Convention and Code(1978 and 2010 Amendment) and IMO Model Course 1.27, applicable to issue of this certificate.";
break;
case "000005":
if (iDtCourseResult.Rows[i]["ME_GUBUN"].ToString() == "M") /* 직급 M 항해 E 기관 */
{
//5. 리더십 및 팀워크교육 (항해)
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제 Ⅱ장 표 A-Ⅱ/1의 규정에 의거하여 실시한 리더십 및 팀워크교육 과정 (선교자원관리 포함)을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person has successfully completed a course \"Leadership and Teamwork\"in accordance with the provision of Chapter Ⅱ Section A Tables A-Ⅱ/1 of STCW Convention and Code(1978 and 2010 Amendment), and also met requirements for Bridge Resource Management set out in Tables A-Ⅱ/1 of STCW Convention & Code(1978 and 2010 Amendment), applicable to issue of this certificate.";
}
else
{
//6. 리더십 및 팀워크교육 (기관)
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제 Ⅲ장 표 A-Ⅲ/1의 규정에 의거하여 실시한 리더십 및 팀워크교육 과정 (기관실자원관리 포함)을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person has successfully completed a course \"Leadership and Teamwork\"in accordance with the provision of Chapter Ⅲ Section A Tables A-Ⅲ/1 of STCW Convention and Code(1978 and 2010 Amendment), and also met requirements for Engine-Room Resource Management set out in Tables A-Ⅲ/1 of STCW Convention & Code(1978 and 2010 Amendment), applicable to issue of this certificate.";
}
break;
case "000006":
if (iDtCourseResult.Rows[i]["ME_GUBUN"].ToString() == "M") /* 직급 M 항해 E 기관 */
{
//7. 리더십 및 관리기술 직무교육 (항해)
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제 Ⅱ장 표 A-Ⅱ/2의 규정에 의거하여 실시한 리더십 및 관리기술 직무교육 과정을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person has successfully completed a course \"Leadership and Managerial skill\" in accordance with the provision of Chapter Ⅱ Section A Tables A-Ⅱ/2 of STCW Convention and Code (1978 and 2010 Amendment), applicable to issue of this certificate.";
}
else
{
//8. 리더십 및 관리기술 직무교육 (기관)
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제 Ⅲ장 표 A-Ⅲ/2의 규정에 의거하여 실시한 리더십 및 관리기술 직무교육 과정을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person has successfully completed a course \"Leadership and Managerial skill\" in accordance with the provision of Chapter Ⅲ Section A Tables A-Ⅲ/2 of STCW Convention and Code(1978 and 2010 Amendment), applicable to issue of this certificate.";
}
break;
case "000007":
//9. JRC ECDIS TST (901)
xReportDescKor = "";
xReportDescEng = "<table><tr><td>JAN-701/901/901M</td></tr><tr><td>JAN-701B/901B/2000</td></tr></table><!--<td rowspan=\"2\">JRC</td>-->";
break;
case "000008":
//10. JRC ECDIS TST (9201)
xReportDescKor = "";
xReportDescEng = "JAN-7201/9201";
break;
case "000009":
//11. 선박평형수관리협약교육
xReportDescKor = "위 사람은 국제해사기구의 선박평형수관리협약 제 B-6 규칙 및 대한민국 선박평형수관리법 제9조 제3항에 따른 교육 과정을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person has completed the training course according to IMO's Ballast Water Convention, Section B, Regulation B-6 and the Republic of Korea's Ballast Water Management Act, Article 9.3";
break;
case "000010":
if (iDtCourseResult.Rows[i]["COURSE_INOUT"].ToString() == "000001") /* 000001 사내 000002 사외 */
{
//12. 선박위험물관리교육 - 내부
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제 Ⅱ장 표 A-Ⅱ/1, A-Ⅱ/2, 제 Ⅶ장, MARPOL 73/78 부속서 Ⅲ 및 49 CFR 172의 규정에 의거하여 실시한 선박위험물관리교육 과정을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person had completed the training course \"Transportation of Dangerous goods\" in accordance with STCW A-Ⅱ/1, A-Ⅱ/2, IMDG Code, SOLAS 1974 amended Chapter Ⅶ, MARPOL 73/78 Annex Ⅲ and 49 CFR 172 and been qualified for cargo handling on ships carrying dangerous and hazardous substances in packaged form.";
}
else
{
//13. 선박위험물관리교육 - 외부
xReportDescKor = "위 사람은 STCW 개정협약 및 코드 제 Ⅱ장 표 A-Ⅱ/1, A-Ⅱ/2, 제 Ⅶ장, MARPOL 73/78 부속서 Ⅲ 및 49 CFR 172의 규정에 의거하여 실시한 선박위험물관리교육 과정을 수료하였음을 증명합니다.";
xReportDescEng = "This is to certify that the above person had completed the training course \"Transportation of Dangerous goods\" in accordance with STCW A-Ⅱ/1, A-Ⅱ/2, IMDG Code, SOLAS 1974 amended Chapter Ⅶ, MARPOL 73/78 Annex Ⅲ and 49 CFR 172 and been qualified for cargo handling on ships carrying dangerous and hazardous substances in packaged form.";
}
break;
default:
break;
}
iDtCourseResult.Rows[i]["REPORT_DESC_KOR"] = xReportDescKor;
iDtCourseResult.Rows[i]["REPORT_DESC_ENG"] = xReportDescEng;
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
}
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
finally
{
if (xNewFile != null)
{
xNewFile.Dispose();
}
}
}
private void GetReport()
{
FileStream xNewFile = null;
try
{
string[] xPara = Request.QueryString["keys"].Split('|');
if (xPara.Length > 0)
{
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduIssuingUserReport",
LMS_SYSTEM.EDUMANAGEMENT,
"CLT.WEB.UI.LMS.EDUM"
, (object)xPara);
iDtCourseResult = xDs.Tables["table0"];
//DataTable xDtLecturer = xDs.Tables["table1"];
//이미지저장
string xUrl = "http://" + Request.Url.Authority;
string xFilePath = "/file/tempfile/report";
string xFileFullPath = "";
for (int i = 0; i < iDtCourseResult.Rows.Count; i++)
{
xFileFullPath = "";
if (iDtCourseResult.Rows[i]["pic_file"] != DBNull.Value)
{
byte[] xImgByte = (byte[])iDtCourseResult.Rows[i]["pic_file"];
string fileName = Convert.ToString(iDtCourseResult.Rows[i]["pic_file_nm"]);
string xFilePathCurr = Server.MapPath(xFilePath + "/" + fileName);
xNewFile = new FileStream(xFilePathCurr, FileMode.Create);
xNewFile.Write(xImgByte, 0, xImgByte.Length);
xNewFile.Close();
xFileFullPath = xUrl + xFilePath + "/" + fileName;
}
iDtCourseResult.Rows[i]["pic_file_nm"] = xFileFullPath;
/* 강사명 고정
* for (int j = 0; j < xDtLecturer.Rows.Count; j++)
* {
* string xLecturerNM = Convert.ToString(iDtCourseResult.Rows[i]["LECTURER_NM"]);
* if (!string.IsNullOrEmpty(xLecturerNM))
* xLecturerNM = xLecturerNM + "|";
* iDtCourseResult.Rows[i]["LECTURER_NM"] = xLecturerNM + Convert.ToString(xDtLecturer.Rows[j]["LECTURER_NM"]);
* }
* */
iDtCourseResult.Rows[i]["REPORT_CNT"] = string.Format("{0:000#}", Convert.ToInt32(iDtCourseResult.Rows[i]["REPORT_CNT"]) + i + 1);
if (!string.IsNullOrEmpty(Convert.ToString(iDtCourseResult.Rows[i]["personal_no"])) && Convert.ToString(iDtCourseResult.Rows[i]["personal_no"]).Length > 6)
{
string xBirthDay = Convert.ToString(iDtCourseResult.Rows[i]["personal_no"]).Substring(0, 6);
iDtCourseResult.Rows[i]["birth"] = "19" + xBirthDay.Substring(0, 2) + "-" + xBirthDay.Substring(2, 2) + "-" + xBirthDay.Substring(4, 2);
}
if (Convert.ToString(iDtCourseResult.Rows[i]["COUNTRY_KIND"]) == "KR")
{
iDtCourseResult.Rows[i]["COUNTRY_KIND_NM"] = "R.O.KOREA";
}
DateTime xBeginDt = Convert.ToDateTime(iDtCourseResult.Rows[i]["course_begin_dt"]);
DateTime xEndDt = Convert.ToDateTime(iDtCourseResult.Rows[i]["course_end_dt"]);
iDtCourseResult.Rows[i]["course_begin_dt_eng"] = xBeginDt.ToString("dd") + "th " + xBeginDt.ToString("MMM", System.Globalization.CultureInfo.InvariantCulture) + ", " + xBeginDt.ToString("yyyy");
iDtCourseResult.Rows[i]["course_end_dt_eng"] = xEndDt.ToString("dd") + "th " + xEndDt.ToString("MMM", System.Globalization.CultureInfo.InvariantCulture) + ", " + xEndDt.ToString("yyyy");
if (Convert.ToInt16(xBeginDt.ToString("yyyy")) >= 2008 && iDtCourseResult.Rows[i]["COURSE_GUBUN"].ToString() == "Y") // 국토해양부 과정이면
{
pnl0.Visible = true; //국토해양부 로고 표시
pnl1.Visible = false;
}
else
{
pnl0.Visible = false; //국토해양부 로고 미표시
pnl1.Visible = true;
}
}
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
finally
{
if (xNewFile != null)
{
xNewFile.Dispose();
}
}
}
/************************************************************
* Function name : btnExcel_Click
* Purpose : 평가 항목 Excel 출력
* Input : void
* Output : void
*************************************************************/
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
string[] xParams = new string[3];
xParams[0] = null;
xParams[1] = "";
xParams[2] = "all";
DataTable xDt = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md",
"GetApprItem",
LMS_SYSTEM.CAPABILITY,
"CLT.WEB.UI.LMS.APPR", (object)xParams).Tables[1];
int xColumnCnt = 11;
string[] xExcelHeader = new string[xColumnCnt];
if (this.IsSettingKorean())
{
xExcelHeader[0] = "구분";
xExcelHeader[1] = "평가대상";
xExcelHeader[2] = "No";
xExcelHeader[3] = "역량명";
xExcelHeader[4] = "역량정의";
xExcelHeader[5] = "SEQ";
xExcelHeader[6] = "행위사례";
xExcelHeader[7] = "기준일자";
xExcelHeader[8] = "OJT";
xExcelHeader[9] = "LMS";
xExcelHeader[10] = "Others";
}
else
{
xExcelHeader[0] = "Classification";
xExcelHeader[1] = "Evaluee";
xExcelHeader[2] = "No";
xExcelHeader[3] = "Name of Competency";
xExcelHeader[4] = "Definition of Competency";
xExcelHeader[5] = "SEQ";
xExcelHeader[6] = "Description";
xExcelHeader[7] = "Date";
xExcelHeader[8] = "OJT";
xExcelHeader[9] = "LMS";
xExcelHeader[10] = "Others";
}
string[] xDtHeader = new string[xColumnCnt];
xDtHeader[0] = "step_gu";
xDtHeader[1] = "app_duty_step";
xDtHeader[2] = "app_item_seq";
xDtHeader[3] = "app_item_nm";
xDtHeader[4] = "app_item_desc";
xDtHeader[5] = "app_case_seq";
xDtHeader[6] = "app_case_desc";
xDtHeader[7] = "app_base_dt";
xDtHeader[8] = "course_ojt";
xDtHeader[9] = "course_lms";
xDtHeader[10] = "course_etc";
this.GetExcelFile(xDt, xExcelHeader, xDtHeader, "1");
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}
private void GetExcel()
{
try
{
string[] xParams = new string[6];
DataTable xDt = new DataTable();
xDt.Columns.Add("open_course_id");
int chkCnt = 0;
for (int i = 0; i < this.grdList.Items.Count; i++)
{
if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("chk_sel")).Checked)
{
chkCnt++;
DataRow xRow = xDt.NewRow();
//O.COURSE_ID ||'^'|| O.OPEN_COURSE_ID
xRow["open_course_id"] = Util.Split(grdList.DataKeys[i].ToString(), "^", 2)[1];
xDt.Rows.Add(xRow);
}
}
if (chkCnt > 0)
{
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduApprovalExcel",
LMS_SYSTEM.EDUMANAGEMENT,
"CLT.WEB.UI.LMS.EDUM",
(object)xParams,
xDt);
string xHtml = "";
int xEduCnt = 0;
xHtml = "<table border='1'>";
xHtml += "<tr><td colspan='8' style='text-align:center;font-size:20px; font-weight:bold;height:60px;'>" + txtSTART_DATE.Text.Substring(0, 7) + " 교육이수자 명단</td></tr>";
for (int i = 0; i < xDs.Tables.Count; i++)
{
if (xDs.Tables[i].Rows.Count > 0)
{
xHtml += "<tr><td colspan='8'> 교육과정 : " + Convert.ToString(xDs.Tables[i].Rows[0]["COURSE_NM"]) + "</td></tr>";
xHtml += "<tr><td colspan='8'> 교육기간 : " + Convert.ToString(xDs.Tables[i].Rows[0]["COURSE_BEGIN_DT"]) + "(" + Util.GetDayOfWeek(Convert.ToDateTime(Convert.ToString(xDs.Tables[i].Rows[0]["COURSE_BEGIN_DT"]) + " 00:00:00")) + ")~" + Convert.ToString(xDs.Tables[i].Rows[0]["COURSE_END_DT"]) + "(" + Util.GetDayOfWeek(Convert.ToDateTime(Convert.ToString(xDs.Tables[i].Rows[0]["COURSE_END_DT"]) + " 00:00:00")) + ")/ " + Convert.ToString(xDs.Tables[i].Rows[0]["COURSE_DAY"]) + " 일간/ " + Convert.ToString(xDs.Tables[i].Rows[0]["COURSE_TYPE_NM"]) + "/ " + Convert.ToString(xDs.Tables[i].Rows.Count) + "명</td></tr>";
xHtml += "<tr style='text-align:center;font-weight:bold;'><td style='background-color:#ddd;'>번호</td><td style='background-color:#ddd;'>직급</td><td style='background-color:#ddd;'>성명</td><td style='background-color:#ddd;'>소속</td><td style='background-color:#ddd;'>사번</td><td style='background-color:#ddd;'>E-MAIL</td><td style='background-color:#ddd;'>거주지</td><td style='background-color:#ddd;'>연락처</td></tr>";
for (int j = 0; j < xDs.Tables[i].Rows.Count; j++)
{
xEduCnt++;
DataRow xRow = xDs.Tables[i].Rows[j];
xHtml += "<tr><td style='text-align:center'>" + (j + 1).ToString() + "</td><td style='text-align:center'>" +
Convert.ToString(xRow["STEP_NAME"]) + "</td><td style='text-align:center'>" +
Convert.ToString(xRow["USER_NM_KOR"]) + "</td><td style='text-align:center'>" +
Convert.ToString(xRow["COMPANY_NM"]) + "</td><td style='text-align:center'> " +
Convert.ToString(xRow["USER_ID"]) + " </td><td style='text-align:center'> " +
//Convert.ToString(xRow["PERSONAL_NO"]) + " </td><td>" +
Convert.ToString(xRow["EMAIL_ID"]) + " </td><td>" +
Convert.ToString(xRow["USER_ADDR"]) + "</td><td style='text-align:center'>" + Convert.ToString(xRow["MOBILE_PHONE"]) + "</td></tr>";
}
xHtml += "<tr><td colspan='8' style='height:50px;'></td></tr>";
}
}
xHtml += "</table>";
if (xEduCnt == 0)
{
ScriptHelper.Page_Alert(this, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A062", new string[] { "자료" }, new string[] { "Data" }, System.Threading.Thread.CurrentThread.CurrentCulture));
}
else
{
this.GetExcelFileHtml(xHtml);
}
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw;
}
}
}
protected void grdList_ItemCommand(object sender, C1CommandEventArgs e)
{
try
{
if (e.CommandName == "Excel")
{
//string[] xParams = new string[6];
//DataTable xDt = new DataTable();
//xDt.Columns.Add("open_course_id");
////O.COURSE_ID ||'^'|| O.OPEN_COURSE_ID
//DataRow xRow = xDt.NewRow();
//xRow["open_course_id"] = Util.Split(grdList.DataKeys[e.Item.ItemIndex].ToString(), "^", 2)[1];
//xDt.Rows.Add(xRow);
//int xEduCnt = 0;
//string xHtml = "";
//DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
// "GetEduApprovalExcel",
// LMS_SYSTEM.APPLICATION,
// "CLT.WEB.UI.APPLICATION",
// (object)xParams,
// xDt);
//xHtml = "<table border='1'>";
//for (int i = 0; i < xDs.Tables.Count; i++)
//{
// if (xDs.Tables[i].Rows.Count > 0)
// {
// xHtml += "<tr style='text-align:center;font-weight:bold;'><td style='background-color:#ddd;'>주민등록번호</td><td style='background-color:#ddd;'>훈련생구분</td><td style='background-color:#ddd;'>성명</td><td style='background-color:#ddd;'>비용수급사업장번호</td><td style='background-color:#ddd;'>최종학력</td><td style='background-color:#ddd;'>비정규직구분</td><td style='background-color:#ddd;'>기숙사사용여부</td><td style='background-color:#ddd;'>식비사용여부</td><td style='background-color:#ddd;'>훈련구분</td><td style='background-color:#ddd;'>대체인력</td></tr>";
// for (int j = 0; j < xDs.Tables[i].Rows.Count; j++)
// {
// xEduCnt++;
// DataRow xRowTable = xDs.Tables[i].Rows[j];
// xHtml += "<tr><td style='text-align:center'>" + Convert.ToString(xRowTable["PERSONAL_NO"]) + "</td><td style='text-align:center'>" + Convert.ToString(xRowTable["T_TRAINEE_CLASS"]) + "</td><td style='text-align:center'>" + Convert.ToString(xRowTable["USER_NM_KOR"]) + "</td><td style='text-align:center'>" + Convert.ToString(xRowTable["TAX_NO"]) + "</td><td style='text-align:center'> 1 </td><td style='text-align:center'> " + Convert.ToString(xRowTable["C_TRAINEE_CLASS"]) + " </td><td style='text-align:center'>N</td><td style='text-align:center'>Y</td><td>" + Convert.ToString(xRowTable["COURSE_TYPE"]) + "</td><td></td></tr>";
// }
// }
//}
//xHtml += "</table>";
//if (xEduCnt == 0)
// ScriptHelper.Page_Alert(this, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A062", new string[] { "자료" }, new string[] { "Data" }, System.Threading.Thread.CurrentThread.CurrentCulture));
//else
// this.GetExcelFileHtml(xHtml);
string[] xParams = new string[6];
DataTable xDt = new DataTable();
xDt.Columns.Add("open_course_id");
//O.COURSE_ID ||'^'|| O.OPEN_COURSE_ID
DataRow xRow = xDt.NewRow();
xRow["open_course_id"] = Util.Split(grdList.DataKeys[e.Item.ItemIndex].ToString(), "^", 2)[1];
xDt.Rows.Add(xRow);
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduApprovalExcel",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION",
(object)xParams,
xDt);
DataTable xDtReturn = xDs.Tables[0];
int xColumnCnt = 10;
string[] xExcelHeader = new string[xColumnCnt];
if (this.IsSettingKorean())
{
xExcelHeader[0] = "주민등록번호";
xExcelHeader[1] = "훈련생구분";
xExcelHeader[2] = "성명";
xExcelHeader[3] = "비용수급사업장번호";
xExcelHeader[4] = "최종학력";
xExcelHeader[5] = "비정규직구분";
xExcelHeader[6] = "기숙사사용여부";
xExcelHeader[7] = "식비사용여부";
xExcelHeader[8] = "훈련구분";
xExcelHeader[9] = "대체인력";
}
string[] xDtHeader = new string[xColumnCnt];
xDtHeader[0] = "PERSONAL_NO";
xDtHeader[1] = "T_TRAINEE_CLASS";
xDtHeader[2] = "USER_NM_KOR";
xDtHeader[3] = "EMPOLY_INS_NO";
xDtHeader[4] = "LAST_SCHOOL";
xDtHeader[5] = "C_TRAINEE_CLASS";
xDtHeader[6] = "IS_DORMITORY";
xDtHeader[7] = "IS_MEALS";
xDtHeader[8] = "COURSE_TYPE";
xDtHeader[9] = "IS_SUBSTITUTE";
this.GetExcelFile(xDtReturn, xExcelHeader, xDtHeader, "0");
}
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}