public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = HCSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); DataRow[] _dr = null; int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); StringBuilder _navPage = new StringBuilder(); _ds = HCSStaffDB.GetListHCSHospital(_paramSearch); _dr = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]); _recordCount = _ds.Tables[0].Rows.Count; _recordCountPrimary = _ds.Tables[0].Rows.Count; _list = HCSStaffMasterDataUI.HospitalOfHealthCareServiceUI.SectionMainUI.GetList(_loginResult, _dr); _navPage = Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), HCSStaffUtil.PAGE_MASTERDATAHOSPITALOFHEALTHCARESERVICE_MAIN, (int)(_paramSearch["RowPerPage"])); _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", _navPage); return(_searchResult); }
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = HCSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); DataRow[] _dr = null; int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); StringBuilder _navPage = new StringBuilder(); _ds = HCSStaffDB.GetListHCSStudentRecords( _loginResult["Username"].ToString(), _loginResult["Userlevel"].ToString(), _loginResult["SystemGroup"].ToString(), _paramSearch ); _dr = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]); _recordCount = _ds.Tables[0].Rows.Count; _recordCountPrimary = _ds.Tables[0].Rows.Count; _list = HCSStaffOurServicesUI.HealthInformationUI.SectionMainUI.GetList(_loginResult, _dr); _navPage = Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), HCSStaffUtil.PAGE_OURSERVICESHEALTHINFORMATION_MAIN, (int)(_paramSearch["RowPerPage"])); _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", _navPage); return(_searchResult); }
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = HCSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); _ds = HCSStaffDB.GetListHCSDownloadLog( _loginResult["Username"].ToString(), _loginResult["Userlevel"].ToString(), _loginResult["SystemGroup"].ToString(), HCSStaffUtil.SUBJECT_SECTION_STATISTICSDOWNLOADHEALTHCARESERVICEFORMVIEWCHART, _paramSearch ); _recordCount = _ds.Tables[2].Rows.Count; _recordCountPrimary = int.Parse((_ds.Tables[0].Rows[0])[0].ToString()); _recordCountSecondary = int.Parse((_ds.Tables[1].Rows[0])[0].ToString()); _list = HCSStaffOurServicesUI.StatisticsDownloadHealthCareServiceFormUI.ViewChartUI.SectionMainUI.GetList(_loginResult, _ds); _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", new StringBuilder()); return(_searchResult); }
public static Dictionary <string, object> GetSearch(string _page, Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = HCSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); DataRow[] _dr = null; string _reportName = String.Empty; int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); StringBuilder _navPage = new StringBuilder(); if (_page == HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE_MAIN) { _reportName = HCSStaffUtil.SUBJECT_SECTION_STATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE; } if (_page == HCSStaffUtil.PAGE_OURSERVICESSTATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE_MAIN) { _reportName = HCSStaffUtil.SUBJECT_SECTION_STATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE; } _ds = HCSStaffDB.GetListHCSDownloadLog( _loginResult["Username"].ToString(), _loginResult["Userlevel"].ToString(), _loginResult["SystemGroup"].ToString(), _reportName, _paramSearch ); if (_reportName.Equals(HCSStaffUtil.SUBJECT_SECTION_STATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL1VIEWTABLE)) { _dr = _ds.Tables[2].Select(); _recordCount = _ds.Tables[2].Rows.Count; _recordCountPrimary = int.Parse((_ds.Tables[0].Rows[0])[0].ToString()); _recordCountSecondary = int.Parse((_ds.Tables[1].Rows[0])[0].ToString()); if (_recordCountPrimary > 0) { _list.AppendLine(HCSStaffOurServicesUI.StatisticsDownloadHealthCareServiceFormUI.ViewTableUI.SectionMainUI.GetList(_page, _loginResult, _dr).ToString()); _navPage.AppendLine("<div class='navpage'><div class='navpage-layout'></div></div>"); } } if (_reportName.Equals(HCSStaffUtil.SUBJECT_SECTION_STATISTICSDOWNLOADHEALTHCARESERVICEFORMLEVEL2VIEWTABLE)) { _dr = _ds.Tables[2].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]); _recordCount = _ds.Tables[2].Rows.Count; _recordCountPrimary = int.Parse((_ds.Tables[0].Rows[0])[0].ToString()); _recordCountSecondary = int.Parse((_ds.Tables[1].Rows[0])[0].ToString()); _list.AppendLine(HCSStaffOurServicesUI.StatisticsDownloadHealthCareServiceFormUI.ViewTableUI.SectionMainUI.GetList(_page, _loginResult, _dr).ToString()); _navPage.AppendLine(Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), _page, (int)(_paramSearch["RowPerPage"])).ToString()); } _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", _navPage); return(_searchResult); }
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); }