internal static void ExportNotes(Form1 form, ExportTypeEnum exportType) { XtraTabControl pagesTabControl = form.pagesTabControl; CustomRichTextBox pageTextBox = ProgramUtil.GetPageTextBox(pagesTabControl.SelectedTabPage); String content; switch (exportType) { case ExportTypeEnum.Xml: if (TabManager.IsCurrentTabInUse(form)) { form.TabIdentity = TabManager.AddNewPage(form, form.TabIdentity); pageTextBox = ProgramUtil.GetPageTextBox(pagesTabControl.SelectedTabPage); } content = FileUtil.ReadToEndWithStandardEncoding(Path.Combine(ConstantUtil.ApplicationExecutionPath(), ConstantUtil.noFile)); //Row number check WindowManager.CheckLineNumbersForTextLenght(form, content); pageTextBox.SelectedText = content; TextManager.RefreshUndoRedoExternal(form); break; case ExportTypeEnum.Txt: try { XmlDocument xmldoc = new XmlDocument(); xmldoc.Load(Path.Combine(ConstantUtil.ApplicationExecutionPath(), ConstantUtil.noFile)); XmlNodeList noteNodeList = xmldoc.GetElementsByTagName("note"); foreach (XmlNode noteNode in noteNodeList) { if (TabManager.IsCurrentTabInUse(form)) { form.TabIdentity = TabManager.AddNewPage(form, form.TabIdentity); pageTextBox = ProgramUtil.GetPageTextBox(pagesTabControl.SelectedTabPage); } content = noteNode.ChildNodes[0].InnerText + ConstantUtil.newLine + ConstantUtil.newLine + noteNode.ChildNodes[1].InnerText; //Row number check WindowManager.CheckLineNumbersForTextLenght(form, content); pageTextBox.SelectedText = content; TextManager.RefreshUndoRedoExternal(form); } } catch (XmlException exception) { ManageError(form, exception); } break; } }
private MemoryStream AddMaterialToZip(string[] typesString, ElsevierMaterials.Models.Domain.Export.Material material, ElsevierMaterials.Models.Domain.Export.Exporter exporter) { MemoryStream msMaterial = new MemoryStream(); msMaterial.Seek(0, SeekOrigin.Begin); using (ZipFile zip = new ZipFile()) { foreach (var item in typesString) { IList <ElsevierMaterials.Models.Domain.Export.Property> properties = material.Properties; ExportTypeEnum exportType = (ExportTypeEnum)int.Parse(item); bool hasAtLeatsOnePropertyForExport = false; ExportType ep = exporter.ExportTypes.Where(m => m.ExportTypeId == exportType).FirstOrDefault(); IList <TMPropertyTypeEnum> propertiesForSelectedExport = ep.Properties; foreach (var prop in material.Properties) { int notMappedPropertyId = prop.ElsBasicInfo.SourceTypeId != 0 ? prop.ElsBasicInfo.SourceTypeId : prop.ElsBasicInfo.TypeId; TMPropertyTypeEnum propertyId = MapElsPropertyId(notMappedPropertyId, (SourceTypeEnum)material.MaterialInfo.SourceId); if (propertiesForSelectedExport.Contains(propertyId)) { hasAtLeatsOnePropertyForExport = true; break; } } if (hasAtLeatsOnePropertyForExport) { MemoryStream mz = getZipStream(int.Parse(item), properties, material); mz.Seek(0, SeekOrigin.Begin); if (exportType == ExportTypeEnum.Esi) { zip.AddEntry("ESI ProCAST.zip", mz); } else if (exportType == ExportTypeEnum.Siemens) { zip.AddEntry("Siemens NX.zip", mz); } else { zip.AddEntry(exportType + ".zip", mz); } } } zip.Save(msMaterial); } return(msMaterial); }
/// <summary> /// On Click Generate Button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnGenerate_Click(object sender, EventArgs e) { if (chkBoxFlipFilter.Checked) { var result = MessageBox.Show("Flip Filter is ticked, this will show only excluded items, Do you want to continue", "Warning", MessageBoxButtons.YesNo); if (result == System.Windows.Forms.DialogResult.No) { return; } } btnGenerate.Enabled = false; if (_cobieWorker == null) { _cobieWorker = new COBieLiteWorker(); _cobieWorker.Worker.ProgressChanged += WorkerProgressChanged; _cobieWorker.Worker.RunWorkerCompleted += WorkerCompleted; } //get Excel File Type ExportTypeEnum excelType = GetExcelType(); //set filters RoleFilter filterRoles = SetRoles(); if (!chkBoxNoFilter.Checked) { _assetfilters.ApplyRoleFilters(filterRoles); _assetfilters.FlipResult = chkBoxFlipFilter.Checked; } //set parameters var args = new Params { ModelFile = txtPath.Text, TemplateFile = txtTemplate.Text, Roles = filterRoles, ExportType = excelType, FlipFilter = chkBoxFlipFilter.Checked, OpenExcel = chkBoxOpenFile.Checked, FilterOff = chkBoxNoFilter.Checked, ExtId = chkBoxIds.Checked ? EntityIdentifierMode.IfcEntityLabels : EntityIdentifierMode.GloballyUniqueIds, SysMode = SetSystemMode(), Filter = chkBoxNoFilter.Checked ? new OutPutFilters() : _assetfilters, ConfigFile = ConfigFile.FullName, Log = chkBoxLog.Checked, }; //run worker _cobieWorker.Run(args); }
protected void lnkSelectAll_Click(object sender, EventArgs e) { ExportTypeEnum exportType = ExportSettings.ExportType; DateTime timeStamp = ExportSettings.TimeStamp; ExportSettings.ExportType = ExportTypeEnum.All; ExportSettings.TimeStamp = DateTimeHelper.ZERO_TIME; ExportSettings.LoadDefaultSelection(false); SaveSettings(); ExportSettings.ExportType = exportType; ExportSettings.TimeStamp = timeStamp; lblInfo.Text = GetString("ImportObjects.AllSelected"); }
public bool ApplySettings() { txtFileName.Text = txtFileName.Text.Trim(); // Validate the file name string result = ImportExportHelper.ValidateExportFileName(Settings, txtFileName.Text); if (string.IsNullOrEmpty(result)) { if (Path.GetExtension(txtFileName.Text).ToLower() != ".zip") { txtFileName.Text = txtFileName.Text.TrimEnd('.') + ".zip"; } // Set current user information Settings.CurrentUser = CMSContext.CurrentUser; Settings.SiteId = SiteId; Settings.DefaultProcessObjectType = ProcessObjectEnum.Selected; // Additional setings Settings.SetSettings(ImportExportHelper.SETTINGS_BIZFORM_DATA, true); Settings.SetSettings(ImportExportHelper.SETTINGS_CUSTOMTABLE_DATA, true); Settings.SetSettings(ImportExportHelper.SETTINGS_FORUM_POSTS, true); Settings.SetSettings(ImportExportHelper.SETTINGS_BOARD_MESSAGES, true); Settings.SetSettings(ImportExportHelper.SETTINGS_GLOBAL_FOLDERS, true); Settings.SetSettings(ImportExportHelper.SETTINGS_SITE_FOLDERS, true); Settings.SetSettings(ImportExportHelper.SETTINGS_COPY_ASPX_TEMPLATES_FOLDER, true); ExportTypeEnum exportType = (SiteId != 0) ? ExportTypeEnum.Site : ExportTypeEnum.All; // Init default values if (radNone.Checked) { // None objects Settings.TimeStamp = DateTimeHelper.ZERO_TIME; Settings.ExportType = ExportTypeEnum.None; } else if (radAll.Checked) { // All objects Settings.TimeStamp = DateTimeHelper.ZERO_TIME; Settings.ExportType = exportType; } else if (radDate.Checked) { if (dtDate.SelectedDateTime != DateTimeHelper.ZERO_TIME) { if (!dtDate.IsValidRange()) { lblError.Text = GetString("general.errorinvaliddatetimerange"); return(false); } else { // From specified date Settings.TimeStamp = dtDate.SelectedDateTime; Settings.ExportType = exportType; } } else { lblError.Text = GetString("ExportSite.SelectDateTime"); return(false); } } else { // From previous export int historyId = ValidationHelper.GetInteger(lstExports.SelectedValue, 0); if (historyId == 0) { lblError.Text = GetString("ExportSite.SelectExportHistory"); return(false); } else { ExportHistoryInfo history = ExportHistoryInfoProvider.GetExportHistoryInfo(historyId); if (history != null) { // Load history settings SiteExportSettings settings = new SiteExportSettings(CMSContext.CurrentUser); settings.SetInfo(ImportExportHelper.INFO_HISTORY_NAME, history.ExportFileName); settings.SetInfo(ImportExportHelper.INFO_HISTORY_DATE, history.ExportDateTime); settings.LoadFromXML(history.ExportSettings); settings.TargetPath = Settings.TargetPath; settings.PersistentSettingsKey = Settings.PersistentSettingsKey; Settings = settings; ExportHistory = true; } else { lblError.Text = GetString("ExportSite.ErrorLoadingExportHistory"); return(false); } } } // Keep current file name Settings.TargetFileName = txtFileName.Text; } else { lblError.Text = result; return(false); } return(true); }
public ExportType FillExportType(ExportTypeEnum type) { ExportType typeObj = new ExportType(); typeObj.ExportTypeId = type; switch (type) { case ExportTypeEnum.All: typeObj.IdString = "allTabHead"; typeObj.Title = "All"; typeObj.Href = "#allTab"; typeObj.IdKey = "all"; break; case ExportTypeEnum.Radioss: typeObj.IdString = "altairTabHead"; typeObj.Title = "OptiStruct"; typeObj.Href = "#altairTab"; typeObj.IdKey = "altair"; typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalYield); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalTensile); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueStrengthCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueStrengthExponent); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueDuctilityExponent); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueDuctilityCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueCyclicStrengthExponent); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueCyclicStrengthCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueNf_maxENDiagram); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueA); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueB); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueNf_maxSNDiagram); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueLimit); typeObj.Properties.Add(TMPropertyTypeEnum.StressStrain); break; case ExportTypeEnum.Abaqus: typeObj.IdString = "abaqusTabHead"; typeObj.Title = "Abaqus"; typeObj.Href = "#abaqusTab"; typeObj.IdKey = "abaqus"; typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); typeObj.Properties.Add(TMPropertyTypeEnum.PlasticStrainStress); break; case ExportTypeEnum.Excel: typeObj.IdString = "ExcelTabHead"; typeObj.Title = "Excel"; typeObj.Href = "#ExcelTab"; typeObj.IdKey = "Excel"; typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalElongation); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalYield); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalTensile); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); break; case ExportTypeEnum.KTMXml: typeObj.IdString = "KTMXmlTabHead"; typeObj.Title = "KTM XML"; typeObj.Href = "#KTMXmlTab"; typeObj.IdKey = "KTMXml"; break; case ExportTypeEnum.FEMAP: typeObj.IdString = "FEMAPTabHead"; typeObj.Title = "FEMAP"; typeObj.Href = "#FEMAPTab"; typeObj.IdKey = "FEMAP"; typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); break; case ExportTypeEnum.SolidWorks: typeObj.IdString = "solidWorksTabHead"; typeObj.Title = "SolidWorks"; typeObj.Href = "#solidWorksTab"; typeObj.IdKey = "solidWorks"; typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalYield); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalTensile); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); break; case ExportTypeEnum.SolidEdge: typeObj.IdString = "solidEdgeTabHead"; typeObj.Title = "SolidEdge"; typeObj.Href = "#solidEdgeTab"; typeObj.IdKey = "solidEdge"; typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalYield); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalTensile); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalElongation); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); break; case ExportTypeEnum.Esi: typeObj.IdString = "esiTabHead"; typeObj.Title = "ESI ProCAST"; typeObj.Href = "#esiTab"; typeObj.IdKey = "esi"; typeObj.Properties.Add(TMPropertyTypeEnum.StressStrain); typeObj.Properties.Add(TMPropertyTypeEnum.ChemicalCompositions); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalElongation); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalYield); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalTensile); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); break; case ExportTypeEnum.ESIPamCrash: typeObj.IdString = "esiPamCrashTabHead"; typeObj.Title = "ESI Pam-Crash"; typeObj.Href = "#esiPamCrashTab"; typeObj.IdKey = "esiPamCrash"; typeObj.Properties.Add(TMPropertyTypeEnum.StressStrain); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); break; case ExportTypeEnum.EsiVPS: typeObj.IdString = "esiVpsTabHead"; typeObj.Title = "ESI VPS"; typeObj.Href = "#esiVpsTab"; typeObj.IdKey = "esiVps"; break; case ExportTypeEnum.ANSYS: typeObj.IdString = "ansysTabHead"; typeObj.Title = "ANSYS"; typeObj.Href = "#ansysTab"; typeObj.IdKey = "ansys"; typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PlasticStrainStress); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueCyclicStrengthExponent); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueCyclicStrengthCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueStrengthCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueStrengthExponent); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueDuctilityExponent); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueDuctilityCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueStressPoints); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalTensile); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalYield); break; case ExportTypeEnum.Siemens: typeObj.IdString = "siemensTabHead"; typeObj.Title = "Siemens NX"; typeObj.Href = "#siemensTab"; typeObj.IdKey = "siemens"; typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalTensile); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalYield); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueCyclicStrengthExponent); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueCyclicStrengthCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueStrengthCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueStrengthExponent); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueDuctilityExponent); typeObj.Properties.Add(TMPropertyTypeEnum.FatigueDuctilityCoefficient); break; case ExportTypeEnum.LsDyna: typeObj.IdString = "lsDynaTabHead"; typeObj.Title = "LS-DYNA"; typeObj.Href = "#lsDynaTab"; typeObj.IdKey = "lsDyna"; typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PlasticStrainStress); break; case ExportTypeEnum.NASTRAN: typeObj.IdString = "nastranTabHead"; typeObj.Title = "MSC Nastran"; typeObj.Href = "#nastranTab"; typeObj.IdKey = "nastran"; typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); break; case ExportTypeEnum.AutodeskNastran: typeObj.IdString = "autodeskNastranTabHead"; typeObj.Title = "Autodesk Nastran"; typeObj.Href = "#autodeskNastranTab"; typeObj.IdKey = "autodeskNastran"; typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); typeObj.Properties.Add(TMPropertyTypeEnum.MechanicalTensile); break; case ExportTypeEnum.PTCCreo: typeObj.IdString = "ptcCreoTabHead"; typeObj.Title = "PTC Creo"; typeObj.Href = "#ptcCreoTab"; typeObj.IdKey = "ptcCreo"; typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalModulusOfElasticity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalPoissonCoefficient); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalDensity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalMeanCoeffThermalExpansion); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalThermalConductivity); typeObj.Properties.Add(TMPropertyTypeEnum.PhysicalSpecificThermalCapacity); break; } return(typeObj); }
private void ExportFile(ExportTypeEnum exportType) { String extension; switch (exportType) { case ExportTypeEnum.SQL: extension = ResultType == ResultTypeEnum.Original ? ".txt" : ".sql"; break; case ExportTypeEnum.Markdown: extension = ".md"; break; case ExportTypeEnum.OrgMode: extension = ".org"; break; default: toolStripStatusLabel.Text = $"Error: Unknown export type ..."; return; } String filePath = logFile.FilePath + extension; try { String text = ""; switch (exportType) { case ExportTypeEnum.SQL: text = "-- Guptaora.log" + Environment.NewLine; break; case ExportTypeEnum.Markdown: text = "# Guptaora.log" + Environment.NewLine + Environment.NewLine; break; case ExportTypeEnum.OrgMode: text = GetOrgModeHeader() + Environment.NewLine; text += "* Guptaora.log" + Environment.NewLine; break; } int idx = 1; foreach (LogEntry logEntry in logFile.Entries.Where(entry => entry.Type == LogFile.COMPILE)) { var logEntryIdentifier = $"{idx} - {logEntry.TimeStampString}"; switch (exportType) { case ExportTypeEnum.SQL: text += $"-- {logEntryIdentifier}"; text += System.Environment.NewLine; text += System.Environment.NewLine; break; case ExportTypeEnum.Markdown: text += $"## Statement {logEntryIdentifier}"; text += Environment.NewLine; text += Environment.NewLine; text += ResultType == ResultTypeEnum.Original ? "```text" : "```sql"; text += Environment.NewLine; break; case ExportTypeEnum.OrgMode: text += $"** Statement {logEntryIdentifier}"; text += Environment.NewLine; text += Environment.NewLine; text += ResultType == ResultTypeEnum.Original ? "#+BEGIN_SRC text" : "#+BEGIN_SRC sql"; text += Environment.NewLine; break; } if (ResultType == ResultTypeEnum.Pretty) { text += PrettifySql(logEntry.Data); } else if (ResultType == ResultTypeEnum.Standard) { text += logEntry.Data.Trim(); } else { text += logEntry.DataOriginal; } switch (exportType) { case ExportTypeEnum.SQL: text += ";"; text += System.Environment.NewLine; text += System.Environment.NewLine; break; case ExportTypeEnum.Markdown: text += System.Environment.NewLine; text += "```"; text += System.Environment.NewLine; text += System.Environment.NewLine; break; case ExportTypeEnum.OrgMode: text += ";"; text += System.Environment.NewLine; text += "#+END_SRC"; text += System.Environment.NewLine; text += System.Environment.NewLine; break; } idx++; } File.WriteAllText(filePath, text); MessageBox.Show($"File '{filePath}' created successfully.", "Logazar - Export", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { toolStripStatusLabel.Text = $"Error: {ex.Message}"; MessageBox.Show($"Error while creating file '{filePath}':" + Environment.NewLine + ex.Message, "Logazar - Export", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// 将dataTable数据输出至指定文件或数据库 /// </summary> private void _ExportOtherType(string filename, ExportTypeEnum type) { if (_data == null) { raise_ExportState(new ExportArgs("没有数据,无法执行数据导出。", -2)); return; } switch (type) { case ExportTypeEnum.Text: export_txt(filename, "\t"); break; case ExportTypeEnum.Xml: export_xml(filename); break; case ExportTypeEnum.officeXML: //export_officeXML(filename); break; case ExportTypeEnum.Excel: ThreadPool.QueueUserWorkItem(new WaitCallback(ve_Excel), filename); break; case ExportTypeEnum.CSV: export_txt(filename, ","); break; default: //这儿可以添加通过反射载入的其他数据导入格式 //接口格式如下 //datatable,linkstring,dataschema -->return bool raise_ExportState(new ExportArgs("未指定导出格式", -1)); break; } }
public void ExportQueryString(IDbConnection con, string tn, ExportTypeEnum et, bool replace) { throw new NotImplementedException(); }
/// <summary> /// 将dataTable数据输出至指定文件或数据库 /// </summary> public void ExportOtherType(string filename, ExportTypeEnum type) { _ExportOtherType(filename, type); }