//전체해상직원 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); } }