private void ExportPDFClick(object sender, EventArgs e) { SaveFileDialog sfd = new SaveFileDialog(); sfd.Filter = String.Format("{0} (*{1})|*{1}", "PDF FIles", ".pdf"); if (sfd.ShowDialog() == DialogResult.OK) { ExportToPDF exporter = new ExportToPDF(this.radGridView1); exporter.FileExtension = "pdf"; exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; exporter.ExportVisualSettings = true; exporter.PageTitle = "My Page Title"; exporter.SummariesExportOption = SummariesOption.DoNotExport; exporter.FitToPageWidth = true; exporter.Scale = 1.2f; exporter.TableBorderThickness = 1; exporter.PdfExportSettings.PageHeight = 210; exporter.PdfExportSettings.PageWidth = 297; exporter.PdfExportSettings.Author = "Telerik"; exporter.HTMLCellFormatting += new Telerik.WinControls.UI.Export.HTML.HTMLCellFormattingEventHandler (exporter_HTMLCellFormatting); exporter.RunExport(sfd.FileName); MessageBox.Show("Export completed"); } }
private void OnExportClick(object sender, RoutedEventArgs e) { var dialog = new SaveFileDialog { DefaultExt = "pdf", Filter = "Diagram files|*.pdf|All Files (*.*)|*.*", #if WPF FileName = "Diagram.pdf" #else DefaultFileName = "Diagram.pdf" #endif }; if (dialog.ShowDialog() == true) { var enclosingBounds = this.diagram.CalculateEnclosingBounds(); enclosingBounds = enclosingBounds.InflateRect(30); RadFixedDocument document = new RadFixedDocument(); document.Pages.Add(ExportHelper.ExportDiagram(this.diagram, enclosingBounds)); PdfFormatProvider provider = new PdfFormatProvider(); using (var output = dialog.OpenFile()) { provider.Export(document, output); } } } }
private void Generate_Click(object sender, RoutedEventArgs e) { if (StartDate.SelectedDate == null && EndDate.SelectedDate == null && Lek.Text.Equals("")) { } if ((StartDate.SelectedDate == null) || (EndDate.SelectedDate == null) || ((Lek.Text.Equals("")) && (!(bool)SviLekovi.IsChecked))) { Error.Text = ERROR2; ErrorMessage.Visibility = Visibility.Visible; } else { if (!(bool)SviLekovi.IsChecked) { foreach (Medication medic in medicationController.GetAllApprovedMeds()) { if (medic.Med.ToLower().Equals(Lek.Text.ToLower())) { medToGenerate = medic; } } MedicationConsumptionReport report = reportController.GenerateMedicalConsumptionReport((DateTime)StartDate.SelectedDate, (DateTime)EndDate.SelectedDate, medToGenerate); ExportToPDF.ExportAsPDF(report); } else { } NavigationService.Navigate(new Uri("Pages/Medications.xaml", UriKind.Relative)); } }
private void RunExportToPDF(string fileName, ref bool openExportFile) { ExportToPDF pdfExporter = new ExportToPDF(this.radGridView1); pdfExporter.PdfExportSettings.Title = "My PDF Title"; pdfExporter.PdfExportSettings.PageWidth = 297; pdfExporter.PdfExportSettings.PageHeight = 210; pdfExporter.FitToPageWidth = true; pdfExporter.HTMLCellFormatting += pdfExporter_HTMLCellFormatting; switch (this.radComboBoxSummaries.SelectedIndex) { case 0: pdfExporter.SummariesExportOption = SummariesOption.ExportAll; break; case 1: pdfExporter.SummariesExportOption = SummariesOption.ExportOnlyTop; break; case 2: pdfExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom; break; case 3: pdfExporter.SummariesExportOption = SummariesOption.DoNotExport; break; } //set export settings pdfExporter.ExportVisualSettings = true; pdfExporter.ExportHierarchy = true; pdfExporter.HiddenColumnOption = HiddenOption.DoNotExport; try { this.Cursor = Cursors.WaitCursor; pdfExporter.RunExport(fileName); RadMessageBox.SetThemeName(this.radGridView1.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to PDF", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { openExportFile = true; } } catch (IOException ex) { RadMessageBox.SetThemeName(this.radGridView1.ThemeName); RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); } finally { this.Cursor = Cursors.Default; } }
static void Main(string[] args) { Console.WriteLine("Open RunExamples.cs. In Main() method, Un-comment the example that you want to run"); Console.WriteLine("====================================================="); // Un-comment the one you want to try out //// ===================================================== //// ===================================================== //// DWG-Drawings //// ===================================================== //// ===================================================== ExportToPDF.Run(); //ExportSpecificLayoutToPDF.Run(); //// ===================================================== //// ===================================================== //// DXF-Drawings //// ===================================================== //// ===================================================== //ExportDXFToPDF.Run(); //ExportDXFSpecificLayerToPDF.Run(); //ExportDXFSpecificLayoutToPDF.Run(); //// ===================================================== //// ===================================================== //// ConvertingCAD //// ===================================================== //// ===================================================== //ConvertDrawingToRasterImage.Run(); //ListLayouts.Run(); //ConvertLayoutsToRasterImage.Run(); //SettingCanvasSizeAndMode.Run(); //SettingBackgroundAndDrawingColors.Run(); //SettingAutoLayoutScaling.Run(); //EnableTrackingForCADRendering.Run(); //SubstitutingFonts.Run(); //CADLayersToRasterImageFormats.Run(); //// ===================================================== //// ===================================================== //// Export //// ===================================================== //// ===================================================== //Export3DImagestoPDF.Run(); //CADLayoutsToPDF.Run(); // Stop before exiting Console.WriteLine("\n\nProgram Finished. Press any key to exit...."); Console.ReadKey(); }
public static void RunExportToPDF(string fileName, RadGridView radGridView) { ExportToPDF pdfExporter = new ExportToPDF(radGridView); pdfExporter.PdfExportSettings.Title = "My PDF Title"; pdfExporter.PdfExportSettings.PageWidth = 297; pdfExporter.PdfExportSettings.PageHeight = 210; pdfExporter.FitToPageWidth = true; pdfExporter.HTMLCellFormatting += pdfExporter_HTMLCellFormatting; pdfExporter.SummariesExportOption = SummariesOption.ExportAll; //set export settings //pdfExporter.ExportVisualSettings = this.radCheckBoxExportVisual.IsChecked; //pdfExporter.ExportHierarchy = this.radCheckBoxExportHierarchy.IsChecked; pdfExporter.HiddenColumnOption = HiddenOption.DoNotExport; try { //this.Cursor = Cursors.WaitCursor; pdfExporter.RunExport(fileName); RadMessageBox.SetThemeName(radGridView.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to PDF", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { try { System.Diagnostics.Process.Start(fileName); } catch (Exception ex) { string message = String.Format("The file cannot be opened on your system.\nError message: {0}", ex.Message); RadMessageBox.Show(message, "Open File", MessageBoxButtons.OK, RadMessageIcon.Error); } } } catch (IOException ex) { RadMessageBox.SetThemeName(radGridView.ThemeName); //RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); System.Windows.Forms.MessageBox.Show(ex.Message, "ERR", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { //this.Cursor = Cursors.Default; } }
private void exportToolStripMenuItem_Click(object sender, EventArgs e) { ExportToPDF worker = new ExportToPDF(); bool didItWork = worker.export(this.matchData, matchData.data_date, this.pic_logo.Image); if (didItWork) { Console.WriteLine("exported to " + worker.getExportPath()); } else { Console.WriteLine("ERROR!"); MessageBox.Show( "An Error was encountered while attempting to save the PDF. Sorry :-(\nPerhaps use the 'PrtScn' button to copy a snapshot of the screen to the clipboard and save in mspaint or a text editor???", "Error Exporting", MessageBoxButtons.OK, MessageBoxIcon.Error ); } }
protected void ButtonExportToPDF_Click(object sender, EventArgs e) { List <UserApplication> users = new List <UserApplication>(); string officeUsers = ""; if (this.DropDownApplications.SelectedValue == "---Select Application---" || this.DropDownApplications.SelectedValue == "All" || this.DropDownApplications.SelectedValue == "") { users = UsersApplicationsBLL.GetAllUsersApps(SelectApplications.All); officeUsers = "All"; } else { users = UsersApplicationsBLL.GetAllUsersApps(SelectApplications.SpecifucApplication, this.DropDownApplications.SelectedItem.Text); officeUsers = this.DropDownApplications.SelectedValue; } ExportToPDF.Users(Page.Server, users, officeUsers, this.savePdfVersion); string pdfName = "http://res.cloudinary.com/hzgrm4rdh/image/upload/" + this.savePdfVersion.Value + "/PDFs/Users_" + officeUsers + ".pdf"; Response.Redirect(pdfName); }
protected void testBtn_Click(object sender, EventArgs e) { //CreatePDF(); List <UserApplication> users = new List <UserApplication>(); string officeUsers = ""; if (this.DropDownApplications.SelectedValue == "---Select Application---" || this.DropDownApplications.SelectedValue == "All" || this.DropDownApplications.SelectedValue == "") { users = UsersApplicationsBLL.GetAllUsersApps(SelectApplications.All); officeUsers = "All"; } else { users = UsersApplicationsBLL.GetAllUsersApps(SelectApplications.SpecifucApplication, this.DropDownApplications.SelectedItem.Text); officeUsers = this.DropDownApplications.SelectedValue; } ExportToPDF.Users(Page.Server, users, officeUsers, this.savePdfVersion); Response.ContentType = "Application/pdf"; Response.AppendHeader("Content-Disposition", "attachment; filename=Users.pdf"); Response.TransmitFile(Server.MapPath("~/App_Data/Users.pdf")); Response.End(); }
public static void GetRegisForm(Dictionary <string, object> _dataRecorded) { string _formName = String.Empty; string _address = String.Empty; int _error = 0; int _template = 0; int _i = 0; bool _download1 = false; bool _download2 = false; DataSet _ds = new DataSet(); DataRow _dr = null; switch (_dataRecorded["HospitalId"].ToString()) { case "RA": _template = 2; _formName = "RARegisForm"; break; case "SI": _template = 3; _formName = "SIRegisForm"; break; } _ds = HCSDB.GetHCSRegistrationForm(_formName); if (_ds.Tables[0].Rows.Count > 0) { _dr = _ds.Tables[0].Rows[0]; _download1 = (_dr["cancelledStatus"].ToString().Equals("N") ? true : false); } _ds.Dispose(); _ds = HCSDB.GetHCSRegistrationForm("KN003Form"); if (_ds.Tables[0].Rows.Count > 0) { _dr = _ds.Tables[0].Rows[0]; _download2 = (_dr["cancelledStatus"].ToString().Equals("N") ? true : false); } _ds.Dispose(); if (_error.Equals(0) && _download1.Equals(true)) { _error = HCSDB.InsertHCSDownloadLog(_dataRecorded["PersonId"].ToString(), _formName, "Student"); } if (_error.Equals(0) && _download2.Equals(true)) { _error = HCSDB.InsertHCSDownloadLog(_dataRecorded["PersonId"].ToString(), "KN003Form", "Student"); } if (_error.Equals(0)) { ExportToPDF _e = new ExportToPDF(); _e.ExportToPDFConnect(_formName + ".pdf"); _e.PDFConnectTemplate(_myPDFFormTemplate, "pdf"); _e.PDFAddTemplate("pdf", 1, 1); if (_download1.Equals(true)) { _e.PDFAddTemplate("pdf", _template, 2); _e.FillForm(_myPDFFontNormal, 11, 0, "วันที่พิมพ์ " + Util.ConvertDateTH(Util.CurrentDate("yyyy/MM/dd")), 18, 565, 100, 0); _e.FillForm(_myPDFFontBold, 16, 0, (!_dataRecorded["StudentCode"].Equals("XXXXXXX") ? Util.GetBlank(_dataRecorded["StudentCode"].ToString(), "") : ""), 192, 572, 91, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["ProgramNameTH"].ToString(), ""), 180, 555, 106, 23); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["FacultyNameTH"].ToString(), ""), 169, 536, 118, 23); _e.FillForm(_myPDFFontBold, 16, 0, Util.GetFullName(Util.GetBlank(_dataRecorded["TitleInitialsTH"].ToString(), ""), Util.GetBlank(_dataRecorded["TitleFullNameTH"].ToString(), ""), Util.GetBlank(_dataRecorded["FirstName"].ToString(), ""), Util.GetBlank(_dataRecorded["MiddleName"].ToString(), ""), Util.GetBlank(_dataRecorded["LastName"].ToString(), "")), 18, 478, 260, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 1 ? _dataRecorded["IdCard"].ToString().Substring(0, 1) : ""), 23, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 2 ? _dataRecorded["IdCard"].ToString().Substring(1, 1) : ""), 54, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 3 ? _dataRecorded["IdCard"].ToString().Substring(2, 1) : ""), 69, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 4 ? _dataRecorded["IdCard"].ToString().Substring(3, 1) : ""), 84, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 5 ? _dataRecorded["IdCard"].ToString().Substring(4, 1) : ""), 100, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 6 ? _dataRecorded["IdCard"].ToString().Substring(5, 1) : ""), 131, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 7 ? _dataRecorded["IdCard"].ToString().Substring(6, 1) : ""), 147, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 8 ? _dataRecorded["IdCard"].ToString().Substring(7, 1) : ""), 162, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 9 ? _dataRecorded["IdCard"].ToString().Substring(8, 1) : ""), 177, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 10 ? _dataRecorded["IdCard"].ToString().Substring(9, 1) : ""), 193, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 11 ? _dataRecorded["IdCard"].ToString().Substring(10, 1) : ""), 224, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 12 ? _dataRecorded["IdCard"].ToString().Substring(11, 1) : ""), 239, 441, 8, 0); _e.FillForm(_myPDFFontBold, 16, 0, (Util.GetBlank(_dataRecorded["IdCard"].ToString(), "").Length >= 13 ? _dataRecorded["IdCard"].ToString().Substring(12, 1) : ""), 271, 441, 8, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["BirthDateTH"].ToString(), ""), 72, 416, 87, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["HouseNoPermanentAddress"].ToString(), ""), 56, 385, 48, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["VillageNoPermanentAddress"].ToString(), ""), 123, 385, 27, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["LaneAlleyPermanentAddress"].ToString(), ""), 189, 385, 93, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["RoadPermanentAddress"].ToString(), ""), 33, 370, 90, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["SubDistrictNameTHPermanentAddress"].ToString(), ""), 166, 370, 117, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["DistrictNameTHPermanentAddress"].ToString(), ""), 56, 355, 60, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["ProvinceNameTHPermanentAddress"].ToString(), ""), 141, 355, 56, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["PostalCodePermanentAddress"].ToString(), ""), 238, 355, 45, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["PhoneNumberPermanentAddress"].ToString(), ""), 45, 339, 95, 0); _e.FillForm(_myPDFFontBold, 12, 0, Util.GetBlank(_dataRecorded["MobileNumberPermanentAddress"].ToString(), ""), 185, 339, 97, 0); if (!_dataRecorded["OccupationNameTHFather"].ToString().IndexOf("รับราชการ").Equals(-1) || !_dataRecorded["OccupationNameTHFather"].ToString().IndexOf("พนักงาน / ลูกจ้าง ส่วนราชการ").Equals(-1) || !_dataRecorded["OccupationNameTHMother"].ToString().IndexOf("รับราชการ").Equals(-1) || !_dataRecorded["OccupationNameTHMother"].ToString().IndexOf("พนักงาน / ลูกจ้าง ส่วนราชการ").Equals(-1) || !_dataRecorded["OccupationNameTHParent"].ToString().IndexOf("รับราชการ").Equals(-1) || !_dataRecorded["OccupationNameTHParent"].ToString().IndexOf("พนักงาน / ลูกจ้าง ส่วนราชการ").Equals(-1)) { _e.FillForm(_myPDFFontBold, 14, 0, "รอเปลี่ยนสิทธิอายุ 20 ปี", 18, 22, 440, 0); } if (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["IdCard"].ToString(), ""))) { _e.FillForm(_myPDFFontBarcode, 24, 2, "*" + _dataRecorded["IdCard"] + "*", 577, 29, 245, 0); } } if (_download2.Equals(true)) { _e.PDFAddTemplate("pdf", 10, 2); _e.FillForm(_myPDFFontBold, 14, 0, Util.GetFullName(Util.GetBlank(_dataRecorded["TitleInitialsTH"].ToString(), ""), Util.GetBlank(_dataRecorded["TitleFullNameTH"].ToString(), ""), Util.GetBlank(_dataRecorded["FirstName"].ToString(), ""), Util.GetBlank(_dataRecorded["MiddleName"].ToString(), ""), Util.GetBlank(_dataRecorded["LastName"].ToString(), "")), 79, 494, 278, 0); _address += (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["VillageCurrentAddress"].ToString(), "")) ? ("หมู่บ้าน" + _dataRecorded["VillageCurrentAddress"] + " ") : ""); _address += (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["HouseNoCurrentAddress"].ToString(), "")) ? ("บ้านเลขที่ " + _dataRecorded["HouseNoCurrentAddress"] + " ") : ""); _address += (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["VillageNoCurrentAddress"].ToString(), "")) ? ("หมู่ " + _dataRecorded["VillageNoCurrentAddress"]) + " " : ""); _address += (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["LaneAlleyCurrentAddress"].ToString(), "")) ? ("ซอย " + _dataRecorded["LaneAlleyCurrentAddress"]) : ""); _e.FillForm(_myPDFFontBold, 14, 0, _address, 89, 473, 400, 0); _address = String.Empty; _address += (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["RoadCurrentAddress"].ToString(), "")) ? ("ถนน" + _dataRecorded["RoadCurrentAddress"] + " ") : ""); _address += (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["SubDistrictNameTHCurrentAddress"].ToString(), "")) ? ("ตำบล" + _dataRecorded["SubDistrictNameTHCurrentAddress"]) : ""); _e.FillForm(_myPDFFontBold, 14, 0, _address, 99, 453, 258, 0); _e.FillForm(_myPDFFontBold, 14, 0, (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["DistrictNameTHCurrentAddress"].ToString(), "")) ? ("อำเภอ" + _dataRecorded["DistrictNameTHCurrentAddress"] + "") : ""), 109, 432, 248, 0); _e.FillForm(_myPDFFontBold, 14, 0, (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["ProvinceNameTHCurrentAddress"].ToString(), "")) ? ("จังหวัด" + _dataRecorded["ProvinceNameTHCurrentAddress"] + "") : ""), 119, 412, 238, 0); if (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["PostalCodeCurrentAddress"].ToString(), ""))) { _e.FillForm(_myPDFFontBold, 14, 0, (_dataRecorded["PostalCodeCurrentAddress"].ToString().Length >= 1 ? _dataRecorded["PostalCodeCurrentAddress"].ToString().Substring(0, 1) : ""), 182, 387, 8, 0); _e.FillForm(_myPDFFontBold, 14, 0, (_dataRecorded["PostalCodeCurrentAddress"].ToString().Length >= 2 ? _dataRecorded["PostalCodeCurrentAddress"].ToString().Substring(1, 1) : ""), 199, 387, 8, 0); _e.FillForm(_myPDFFontBold, 14, 0, (_dataRecorded["PostalCodeCurrentAddress"].ToString().Length >= 3 ? _dataRecorded["PostalCodeCurrentAddress"].ToString().Substring(2, 1) : ""), 216, 387, 8, 0); _e.FillForm(_myPDFFontBold, 14, 0, (_dataRecorded["PostalCodeCurrentAddress"].ToString().Length >= 4 ? _dataRecorded["PostalCodeCurrentAddress"].ToString().Substring(3, 1) : ""), 232, 387, 8, 0); _e.FillForm(_myPDFFontBold, 14, 0, (_dataRecorded["PostalCodeCurrentAddress"].ToString().Length >= 5 ? _dataRecorded["PostalCodeCurrentAddress"].ToString().Substring(4, 1) : ""), 250, 387, 8, 0); } if (!String.IsNullOrEmpty(Util.GetBlank(_dataRecorded["ProgramAddress"].ToString(), ""))) { string[] _programAddressArray = _dataRecorded["ProgramAddress"].ToString().Split('&'); int _col = 380; int _row = 225; for (_i = 0; _i < _programAddressArray.GetLength(0); _i++) { _e.FillForm(_myPDFFontBold, 16, 0, _programAddressArray[_i], _col, _row, 363, 0); _col = _col + 10; _row = _row - 22; } } } _e.ExportToPdfDisconnect(); } }
private static Dictionary <string, object> GetProcess(Dictionary <string, object> _infoLogin, string _page, Dictionary <string, object> _paramSearch, Dictionary <string, object> _dataProcess) { Dictionary <string, object> _processResult = new Dictionary <string, object>(); Dictionary <string, object> _dataRecorded = new Dictionary <string, object>(); string _username = _infoLogin["Username"].ToString(); string _option = _dataProcess["Option"].ToString(); string _fileName = ((DateTime.Now).ToString("dd-MM-yyyy@HH-mm-ss", new CultureInfo("en-US"))); string _filePath = HttpContext.Current.Server.MapPath(HCSStaffUtil._myFileDownloadPath + "\\"); string _msgTH = String.Empty; string _msgDetail = String.Empty; string _reportName = String.Empty; int _tbIndex = 0; int _saveError = 0; int _complete = 0; int _incomplete = 0; int _i = 0; int _j = 0; bool _error = false; List <string> _valueDetailCompleteTemp = new List <string>(); List <string> _valueDetailComplte = new List <string>(); List <string> _valueDetailIncomplte = new List <string>(); if (_page.Equals(HCSStaffUtil.PAGE_DOWNLOADREGISTRATIONFORM_PROGRESS)) { _fileName = (_dataProcess["RegistrationForm"] + _fileName); _msgTH = "ดาว์นโหลดข้อมูล"; _tbIndex = 0; } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESHEALTHINFORMATION_PROGRESS)) { _fileName = (HCSStaffUtil.SUBJECT_SECTION_HEALTHINFORMATION + _fileName); _msgTH = "ส่งออกข้อมูล"; _tbIndex = 0; } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE_PROGRESS)) { _fileName = (HCSStaffUtil.SUBJECT_SECTION_STATISTICSDOWNLOADHEALTHCARESERVICEFORM + _fileName); _msgTH = "ส่งออกข้อมูล"; _reportName = HCSStaffUtil.SUBJECT_SECTION_STATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE; _tbIndex = 2; } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE_PROGRESS)) { _fileName = (HCSStaffUtil.SUBJECT_SECTION_STATISTICSDOWNLOADHEALTHCARESERVICEFORM + _fileName); _msgTH = "ส่งออกข้อมูล"; _reportName = HCSStaffUtil.SUBJECT_SECTION_STATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE; _tbIndex = 2; } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTREGISTRATION_PROGRESS)) { _fileName = (HCSStaffUtil.SUBJECT_SECTION_TERMSERVICEHCSCONSENTREGISTRATION + _fileName); _msgTH = "ส่งออกข้อมูล"; _tbIndex = 0; } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTOOCA_PROGRESS)) { _fileName = (HCSStaffUtil.SUBJECT_SECTION_TERMSERVICEHCSCONSENTOOCA + _fileName); _msgTH = "ส่งออกข้อมูล"; _tbIndex = 0; } ExportToPDF _e = new ExportToPDF(); DataTable _dt1 = new DataTable(); DataTable _dt2 = new DataTable(); DataSet _ds1 = new DataSet(); MUService _account = new MUService(); if (_option.Equals("selected")) { _tbIndex = 0; string[] _valueSelected = _paramSearch["Keyword"].ToString().Split('|'); _dt1.Columns.Add("id"); for (_i = 0; _i < _valueSelected.GetLength(0); _i++) { _dt1.Rows.Add(_valueSelected[_i]); } _ds1.Tables.Add(_dt1); } if (_option.Equals("all")) { if (_page.Equals(HCSStaffUtil.PAGE_DOWNLOADREGISTRATIONFORM_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESHEALTHINFORMATION_PROGRESS)) { _ds1 = HCSStaffDB.GetListHCSStudentRecords( _infoLogin["Username"].ToString(), _infoLogin["Userlevel"].ToString(), _infoLogin["SystemGroup"].ToString(), _paramSearch ); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE_PROGRESS)) { _ds1 = HCSStaffDB.GetListHCSDownloadLog( _infoLogin["Username"].ToString(), _infoLogin["Userlevel"].ToString(), _infoLogin["SystemGroup"].ToString(), _reportName, _paramSearch ); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTREGISTRATION_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTOOCA_PROGRESS)) { _ds1 = HCSStaffDB.GetListHCSStudentTermServiceConsent( _infoLogin["Username"].ToString(), _infoLogin["Userlevel"].ToString(), _infoLogin["SystemGroup"].ToString(), _paramSearch ); } } if (_ds1.Tables[_tbIndex].Rows.Count > 0) { if (_page.Equals(HCSStaffUtil.PAGE_DOWNLOADREGISTRATIONFORM_PROGRESS)) { _fileName += ".pdf"; _e.ExportToPDFConnectWithSaveFile(_filePath + _fileName); _e.PDFConnectTemplate(HCSStaffUtil._myPDFFormTemplate, "pdfwithsavefile"); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESHEALTHINFORMATION_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTREGISTRATION_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTOOCA_PROGRESS)) { _dt2 = HCSStaffUtil.SetColumnDataTable(_page); } _i = 0; foreach (DataRow _dr1 in _ds1.Tables[_tbIndex].Rows) { try { _error = false; _saveError = 0; if (_page.Equals(HCSStaffUtil.PAGE_DOWNLOADREGISTRATIONFORM_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESHEALTHINFORMATION_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTREGISTRATION_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTOOCA_PROGRESS)) { DataSet _ds2 = new DataSet(); if (_page.Equals(HCSStaffUtil.PAGE_DOWNLOADREGISTRATIONFORM_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESHEALTHINFORMATION_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE_PROGRESS)) { _ds2 = HCSStaffDB.GetHCSStudentRecords(_dr1["id"].ToString()); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTREGISTRATION_PROGRESS)) { _ds2 = HCSStaffDB.GetHCSStudentTermServiceConsent(_dr1["id"].ToString(), "HCS_CONSENT_REGISTRATION"); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTOOCA_PROGRESS)) { _ds2 = HCSStaffDB.GetHCSStudentTermServiceConsent(_dr1["id"].ToString(), "HCS_CONSENT_OOCA"); } if (_ds2.Tables[0].Rows.Count > 0) { DataRow _dr2 = _ds2.Tables[0].Rows[0]; if (_page.Equals(HCSStaffUtil.PAGE_DOWNLOADREGISTRATIONFORM_PROGRESS)) { _dataRecorded.Clear(); _dataRecorded = HCSStaffDownloadRegistrationFormUtil.StudentRecordsUtil.SetValueDataRecorded(_dataRecorded, _ds2); HCSStaffDownloadRegistrationFormUtil.GenerateRegistrationFormUtil _h = new HCSStaffDownloadRegistrationFormUtil.GenerateRegistrationFormUtil(); DataSet _ds3 = Util.DBUtil.ExecuteCommandStoredProcedure("sp_hcsSetDownloadLog", new SqlParameter("@personId", _dataRecorded["PersonId"]), new SqlParameter("@registrationForm", _dataProcess["RegistrationForm"]), new SqlParameter("@by", _username), new SqlParameter("@ip", Util.GetIP()) ); DataRow _dr3 = _ds3.Tables[0].Rows[0]; _saveError = (int.Parse(_dr3[0].ToString()).Equals(1) ? 0 : 1); if (_saveError.Equals(0)) { _h.GetRegistrationForm(_dataProcess["RegistrationForm"].ToString(), _dataRecorded, _e); _error = false; _msgDetail = (_dr2["studentCode"] + "-" + _dr2["idCard"]); _valueDetailCompleteTemp.Add( _dr2["id"].ToString() + ";" + DateTime.Parse(_dr3[1].ToString()).ToString("dd/MM/yyyy HH:mm:ss") + ";" + double.Parse(_dr3[2].ToString()).ToString("#,##0") ); } else { _error = true; _msgDetail = (_dr2["studentCode"] + "-" + _dr2["idCard"] + " : บันทึกข้อมูลไม่สำเร็จ"); } _ds3.Dispose(); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESHEALTHINFORMATION_PROGRESS)) { _i++; string _weight = String.Empty; string _height = String.Empty; string _bmi = String.Empty; string _bmiDate = String.Empty; string _country = String.Empty; string _travelDate = String.Empty; string _travelAbroad = String.Empty; string[] _bodyMassArray; string[] _bodyMassDetail = new string[4]; string[] _travelAbroadArray; string[] _travelAbroadDetail = new string[2]; if (!String.IsNullOrEmpty(_dr2["bodyMassDetail"].ToString())) { _bodyMassArray = _dr2["bodyMassDetail"].ToString().Split(';'); for (_j = 0; _j < _bodyMassArray.GetLength(0); _j++) { _bodyMassDetail = _bodyMassArray[_j].Split(':'); _weight += _bodyMassDetail[0]; _height += _bodyMassDetail[1]; _bmi += _bodyMassDetail[2]; _bmiDate += (_bodyMassDetail[3].Substring(6, 4) + "-" + _bodyMassDetail[3].Substring(3, 2) + "-" + _bodyMassDetail[3].Substring(0, 2)); if ((_j + 1) < _bodyMassArray.GetLength(0)) { _weight += "\r\n"; _height += "\r\n"; _bmi += "\r\n"; _bmiDate += "\r\n"; } } } if (!String.IsNullOrEmpty(_dr2["travelAbroadDetail"].ToString())) { _travelAbroadArray = _dr2["travelAbroadDetail"].ToString().Split(';'); for (_j = 0; _j < _travelAbroadArray.GetLength(0); _j++) { _travelAbroadDetail = _travelAbroadArray[_j].Split(','); _country = (_travelAbroadDetail[0].Split(':'))[0]; _travelDate = (_travelAbroadDetail[1].Substring(6, 4) + "-" + _travelAbroadDetail[1].Substring(3, 2) + "-" + _travelAbroadDetail[1].Substring(0, 2)); _travelAbroad += (_country + ", " + _travelDate); if ((_j + 1) < _travelAbroadArray.GetLength(0)) { _travelAbroad += "\r\n"; } } } _dt2.Rows.Add( _i.ToString("#,##0"), _dr2["studentCode"], _dr2["idCard"], _dr2["titlePrefixFullNameTH"], _dr2["firstName"], _dr2["middleName"], _dr2["lastName"], _dr2["titlePrefixFullNameEN"], _dr2["firstNameEN"], _dr2["middleNameEN"], _dr2["lastNameEN"], (!String.IsNullOrEmpty(_dr2["birthDate"].ToString()) ? DateTime.Parse(_dr2["birthDate"].ToString()).ToString("yyyy-MM-dd") : ""), _dr2["nationalityNameTH"], _dr2["facultyCode"], (_dr2["programCode"] + " " + _dr2["majorCode"] + " " + _dr2["groupNum"]), _dr2["hcsJoin"], _dr2["bloodTypeNameEN"], _weight, _height, _bmi, _bmiDate, _dr2["diseasesDetail"].ToString().Replace("\n", "\r\n"), _dr2["intoleranceDetail"].ToString().Replace("\n", "\r\n"), "", _travelAbroad, _dr2["impairmentsNameTH"], _dr2["impairmentsEquipment"], _dr2["childhoodNumber"], _dr2["occupationNameTHFather"], _dr2["occupationNameTHMother"], _dr2["occupationNameTHParent"] ); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE_PROGRESS)) { _i++; _dt2.Rows.Add( _i.ToString("#,##0"), _dr2["studentCode"], _dr2["idCard"], _dr2["titlePrefixFullNameTH"], _dr2["firstName"], _dr2["middleName"], _dr2["lastName"], _dr2["titlePrefixFullNameEN"], _dr2["firstNameEN"], _dr2["middleNameEN"], _dr2["lastNameEN"], _dr2["facultyCode"], (_dr2["programCode"] + " " + _dr2["majorCode"] + " " + _dr2["groupNum"]), _dr2["yearEntry"], _dr2["stdEntranceTypeNameTH"], _dr2["statusTypeNameTH"], _dr1["logForm"], DateTime.Parse(_dr1["latestDateDownload"].ToString()).ToString("dd/MM/yyyy HH:mm:ss"), double.Parse(_dr1["countDownload"].ToString()).ToString("#,##0") ); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTREGISTRATION_PROGRESS)) { _i++; _dt2.Rows.Add( _i.ToString("#,##0"), _dr2["studentCode"], _dr2["idCard"], _dr2["titlePrefixFullNameTH"], Util.GetFullName("", "", _dr2["firstName"].ToString(), _dr2["middleName"].ToString(), _dr2["lastName"].ToString()), (!String.IsNullOrEmpty(_dr2["birthDate"].ToString()) ? DateTime.Parse(_dr2["birthDate"].ToString()).ToString("yyyy-MM-dd") : ""), _dr2["facultyNameEN"], (_dr2["termStatus"].Equals("Y") ? "Agree" : (_dr2["termStatus"].Equals("N") ? "Disagree" : "No Comment")), _dr2["termNote"], (!String.IsNullOrEmpty(_dr2["termDate"].ToString()) ? DateTime.Parse(_dr2["termDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") : "") ); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTOOCA_PROGRESS)) { _i++; string _mailMU = _account.getMailAddress(("u" + _dr2["studentCode"]), "2efa3ac33e", 1).Replace(",", ", "); _dt2.Rows.Add( _mailMU, _dr2["email"], _dr2["studentCode"], _dr2["class"], _dr2["facultyNameEN"], _dr2["titlePrefixFullNameTH"], (_dr2["firstName"] + (!String.IsNullOrEmpty(_dr2["middleName"].ToString()) ? (" " + _dr2["middleName"]) : String.Empty)), _dr2["lastName"], _dr2["genderFullNameEN"], _dr2["nationalityNameEN"], _dr2["statusTypeNameTH"], (_dr2["termStatus"].Equals("Y") ? "Agree" : (_dr2["termStatus"].Equals("N") ? "Disagree" : "No Comment")), (!String.IsNullOrEmpty(_dr2["termDate"].ToString()) ? DateTime.Parse(_dr2["termDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") : ""), (!String.IsNullOrEmpty(_dr2["telephoneCurrent"].ToString()) ? _dr2["telephoneCurrent"] : _dr2["telephonePermanent"]), (!String.IsNullOrEmpty(_dr2["telephoneCurrentParent"].ToString()) ? _dr2["telephoneCurrentParent"] : _dr2["telephonePermanentParent"]) ); } } else { _error = true; _msgDetail = (_dr1["id"].ToString() + " : ไม่พบข้อมูล"); } _ds2.Dispose(); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE_PROGRESS)) { _dt2.Rows.Add( _dr1["logForm"].ToString(), _dr1["yearEntry"].ToString(), double.Parse(_dr1["countDownload"].ToString()).ToString("#,##0"), double.Parse(_dr1["countPeople"].ToString()).ToString("#,##0") ); } if (_error.Equals(false)) { _valueDetailComplte.Add(_msgDetail); _complete++; } else { _valueDetailIncomplte.Add(_msgDetail); _incomplete++; } } catch { _valueDetailIncomplte.Add(_dr1["id"].ToString() + " : ประมวลผลไม่สำเร็จ"); _incomplete++; } } if (_page.Equals(HCSStaffUtil.PAGE_DOWNLOADREGISTRATIONFORM_PROGRESS)) { _e.ExportToPdfDisconnectWithSaveFile(); } } _ds1.Dispose(); if (_complete > 0) { if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESHEALTHINFORMATION_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTREGISTRATION_PROGRESS) || _page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTOOCA_PROGRESS)) { _fileName += ".xlsx"; MemoryStream _ms = new MemoryStream(); FileStream _fs = new FileStream(_filePath + _fileName, FileMode.Create, FileAccess.Write); ExcelPackage _pk = new ExcelPackage(); ExcelWorksheet _ws = _pk.Workbook.Worksheets.Add("Sheet1"); int _maxRowCellRange = (_complete + 1);; int _maxColCellRange = _dt2.Columns.Count; int _maxRowCellHeader = 1; int _maxColCellHeader = _dt2.Columns.Count; Util.SetCellExcel(_ws, _maxRowCellRange, _maxColCellRange, _maxRowCellHeader, _maxColCellHeader); if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESHEALTHINFORMATION_PROGRESS)) { List <object> _cellContent = new List <object> { new[] { "ลำดับ", "No.", "center", "" }, new[] { "Student ID", "StudentCode", "center", "" }, new[] { "ID Card / Passport", "IdCard", "center", "" }, new[] { "คำนำหน้าภาษาไทย", "TitlePrefixTH", "", "" }, new[] { "ชื่อภาษาไทย", "FirstName", "", "" }, new[] { "ชื่อกลางภาษาไทย", "MiddleName", "", "" }, new[] { "นามสกุลภาษาไทย", "LastName", "", "" }, new[] { "คำนำหน้าภาษาอังกฤษ", "TitlePrefixEN", "", "" }, new[] { "ชื่อภาษาอังกฤษ", "FirstNameEN", "", "" }, new[] { "ชื่อกลางภาษาอังกฤษ", "MiddleNameEN", "", "" }, new[] { "นามสกุลภาษาอังกฤษ", "LastNameEN", "", "" }, new[] { "วันเกิด", "BirthDate", "center", "" }, new[] { "สัญชาติ", "Nationality", "center", "" }, new[] { "คณะ", "Faculty", "center", "" }, new[] { "หลักสูตร", "Program", "center", "" }, new[] { "สิทธิขึ้นทะเบียนสิทธิรักษาพยาบาล", "HCSJoin", "center", "" }, new[] { "หมู่เลือด", "BloodType", "center", "" }, new[] { "น้ำหนัก ( กก. )", "Weight", "center", "" }, new[] { "ส่วนสูง ( ซม. )", "Height", "center", "" }, new[] { "BMI", "BMI", "center", "" }, new[] { "BMI ข้อมูล ณ วันที่", "BMIDate", "center", "" }, new[] { "โรคประจำตัว", "Diseases", "", "true" }, new[] { "ประวัติแพ้ยา", "Intolerance", "", "true" }, new[] { "วัคซีนที่เคยรับ", "Vaccine", "", "" }, new[] { "ประวัติเดินทางไปต่างประเทศและวันที่เดินทาง", "TravelAbroad", "", "true" }, new[] { "ความบกพร่อง", "Impairments", "", "" }, new[] { "อุปกรณ์ช่วยเหลือ", "ImpairmentsEquipment", "", "" }, new[] { "เป็นบุตรลำดับที่", "ChildhoodNumber", "center", "" }, new[] { "อาชีพของบิดา", "OccupationFather", "", "" }, new[] { "อาชีพของมารดา", "OccupationMother", "", "" }, new[] { "อาชีพของผู้ปกครอง", "OccupationParent", "", "" } }; _i = 1; foreach (object _c in _cellContent) { string _header = ((string[])_c)[0]; _ws.Cells[1, _i].Value = _header; _i++; } Util.GetListDataToExcel(_cellContent, _dt2, _ws, (_maxRowCellHeader + 1)); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE_PROGRESS)) { List <object> _cellContent = new List <object> { new[] { "แบบฟอร์มบริการสุขภาพ", "HealthCareServiceForm", "", "" }, new[] { "ปีที่เข้าศึกษา", "YearEntry", "center", "" }, new[] { "จำนวนการดาวน์โหลด ( ครั้ง )", "NumberofDownload", "right", "" }, new[] { "จำนวนนักศึกษาที่ดาวน์โหลด ( คน )", "NumberofStudent", "right", "" } }; _i = 1; foreach (object _c in _cellContent) { string _header = ((string[])_c)[0]; _ws.Cells[1, _i].Value = _header; _i++; } Util.GetListDataToExcel(_cellContent, _dt2, _ws, (_maxRowCellHeader + 1)); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE_PROGRESS)) { List <object> _cellContent = new List <object> { new[] { "ลำดับ", "No.", "center", "" }, new[] { "Student ID", "StudentCode", "center", "" }, new[] { "ID Card / Passport", "IdCard", "center", "" }, new[] { "คำนำหน้าภาษาไทย", "TitlePrefixTH", "", "" }, new[] { "ชื่อภาษาไทย", "FirstName", "", "" }, new[] { "ชื่อกลางภาษาไทย", "MiddleName", "", "" }, new[] { "นามสกุลภาษาไทย", "LastName", "", "" }, new[] { "คำนำหน้าภาษาอังกฤษ", "TitlePrefixEN", "", "" }, new[] { "ชื่อภาษาอังกฤษ", "FirstNameEN", "", "" }, new[] { "ชื่อกลางภาษาอังกฤษ", "MiddleNameEN", "", "" }, new[] { "นามสกุลภาษาอังกฤษ", "LastNameEN", "", "" }, new[] { "คณะ", "Faculty", "center", "" }, new[] { "หลักสูตร", "Program", "center", "" }, new[] { "ปีที่เข้าศึกษา", "YearEntry", "center", "" }, new[] { "ระบบการสอบเข้า", "AdmissionType", "", "" }, new[] { "สถานภาพการเป็นนักศึกษา", "StudentStatus", "center", "" }, new[] { "แบบฟอร์มบริการสุขภาพ", "HealthCareServiceForm", "center", "" }, new[] { "วันที่ดาวน์โหลดล่าสุด", "LatestDateDownload", "center", "" }, new[] { "จำนวนการดาวน์โหลด ( ครั้ง )", "NumberofDownload", "center", "" } }; _i = 1; foreach (object _c in _cellContent) { string _header = ((string[])_c)[0]; _ws.Cells[1, _i].Value = _header; _i++; } Util.GetListDataToExcel(_cellContent, _dt2, _ws, (_maxRowCellHeader + 1)); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTREGISTRATION_PROGRESS)) { List <object> _cellContent = new List <object> { new[] { "ลำดับที่ ", "No.", "center", "" }, new[] { "รหัสนักศึกษา", "StudentCode", "center", "" }, new[] { "เลขบัตรประชาชน", "IdCard", "center", "" }, new[] { "คำนำหน้า", "TitlePrefixTH", "center", "" }, new[] { "ชื่อ-สกุล", "Fullname", "", "" }, new[] { "วันเกิด", "BirthDate", "center", "" }, new[] { "ส่วนงาน", "Faculty", "", "" }, new[] { "ความประสงค์", "ConsentStatus", "center", "" }, new[] { "สถานพยาบาล", "Hospital", "center", "" }, new[] { "วันที่ยินยอม", "ConsentDate", "center", "" } }; _i = 1; foreach (object _c in _cellContent) { string _header = ((string[])_c)[0]; _ws.Cells[1, _i].Value = _header; _i++; } Util.GetListDataToExcel(_cellContent, _dt2, _ws, (_maxRowCellHeader + 1)); } if (_page.Equals(HCSStaffUtil.PAGE_OURSERVICESTERMSERVICEHCSCONSENTOOCA_PROGRESS)) { List <object> _cellContent = new List <object> { new[] { "E-mail", "EmailAddress", "", "" }, new[] { "E-mail [MU]", "MuEmailAddress", "", "" }, new[] { "Student ID", "StudentCode", "center", "" }, new[] { "Class", "Class", "center", "" }, new[] { "Faculty [EN]", "Faculty", "", "" }, new[] { "Title [TH]", "TitlePrefixTH", "", "" }, new[] { "First Name [TH]", "FirstName", "", "" }, new[] { "Surname [TH]", "LastName", "", "" }, new[] { "Sex", "Gender", "center", "" }, new[] { "Nationality", "Nationality", "center", "" }, new[] { "Student Status", "StudentStatus", "center", "" }, new[] { "Status Concent Form", "ConsentStatus", "center", "" }, new[] { "Last Update [Concent]", "ConsentDate", "center", "" }, new[] { "เบอร์ผู้ปกครอง", "TelephoneParent", "", "" }, new[] { "เบอร์ นศ.", "Telephone", "", "" } }; _i = 1; foreach (object _c in _cellContent) { string _header = ((string[])_c)[0]; _ws.Cells[1, _i].Value = _header; _i++; } Util.GetListDataToExcel(_cellContent, _dt2, _ws, (_maxRowCellHeader + 1)); } _ws.Cells.AutoFitColumns(); _pk.SaveAs(_ms); _ms.WriteTo(_fs); _ms.Close(); _ms.Dispose(); _fs.Close(); _fs.Dispose(); } } if (_page.Equals(HCSStaffUtil.PAGE_DOWNLOADREGISTRATIONFORM_PROGRESS)) { _valueDetailComplte.Clear(); _valueDetailComplte = _valueDetailCompleteTemp; } _processResult.Add("Complete", _complete.ToString("#,##0")); _processResult.Add("Incomplete", _incomplete.ToString("#,##0")); _processResult.Add("DetailComplete", String.Join(",", _valueDetailComplte.ToArray())); _processResult.Add("DetailIncomplete", String.Join(",", _valueDetailIncomplte.ToArray())); _processResult.Add("DownloadFolder", HCSStaffUtil._myFileDownloadPath); _processResult.Add("DownloadFile", _fileName); return(_processResult); }