private void bExport_Click(object sender, EventArgs e) { PwDatabase db = m_dDB.ElementAt(lbDB.SelectedIndex).Key; RefreshHandler(db); //if (!m_handler.SetDB(db, false)) return; if (!AppPolicy.Current.ExportNoKey && !m_handler.ReAskKey()) { return; } db = m_handler.OTPDB; PwGroup pg = db.RootGroup; PwExportInfo pwInfo = new PwExportInfo(pg, db, false); MessageService.ExternalIncrementMessageCount(); ShowWarningsLogger swLogger = KeePass.Program.MainForm.CreateShowWarningsLogger(); swLogger.StartLogging(KPRes.ExportingStatusMsg, true); ExportUtil.Export(pwInfo, swLogger); swLogger.SetText(string.Empty, KeePassLib.Interfaces.LogStatusType.Info); swLogger.EndLogging(); MessageService.ExternalDecrementMessageCount(); }
private void ExportData() { NZString SlipNo = new NZString(null, shtDelivery.GetValue(shtDelivery.ActiveRowIndex, (int)eColView.SLIP_NO)); string strFileName = GenerateFileName("INV_" + SlipNo.StrongValue); string strTemplateFileName = @"Report\TRN090_Invoice_Template.xls"; string strTemplatePath = Path.Combine(Application.StartupPath, strTemplateFileName); string strExportPath = SaveDialogUtil.GetBrowseFileDialogForExport(strFileName); if (!"".Equals(strExportPath)) { DeliveryController ctrl = new DeliveryController(); DataSet ds = new DataSet(); ds.Tables.Add(ctrl.Load_Invoice(SlipNo)); ExportUtil.Export(ds, strTemplatePath, strExportPath); MessageDialog.ShowInformation(this, null, new EVOFramework.Message(Messages.eInformation.INF9003.ToString()).MessageDescription); if (File.Exists(strExportPath)) { System.Diagnostics.Process.Start(strExportPath); } } }
private void bExport_Click(object sender, EventArgs e) { PwDatabase db = m_dDB.ElementAt(lbDB.SelectedIndex).Key; RefreshHandler(db); //if (!m_handler.SetDB(db, false)) return; //If configured, KeePass 2.46 will ask for the masterkey during the export //No need to ask here if (Tools.KeePassVersion < new Version(2, 46)) { if (!AppPolicy.Current.ExportNoKey && !m_handler.ReAskKey()) { return; } } db = m_handler.OTPDB; PwGroup pg = db.RootGroup; PwExportInfo pwInfo = new PwExportInfo(pg, db, false); MessageService.ExternalIncrementMessageCount(); ShowWarningsLogger swLogger = KeePass.Program.MainForm.CreateShowWarningsLogger(); swLogger.StartLogging(KPRes.ExportingStatusMsg, true); try { ExportUtil.Export(pwInfo, swLogger); swLogger.SetText(string.Empty, KeePassLib.Interfaces.LogStatusType.Info); } finally { swLogger.EndLogging(); MessageService.ExternalDecrementMessageCount(); } }
private static void ExportDatabaseFile(EcasAction a, EcasContext ctx) { string strPath = EcasUtil.GetParamString(a.Parameters, 0, true); // if(string.IsNullOrEmpty(strPath)) return; // Allow no-file exports string strFormat = EcasUtil.GetParamString(a.Parameters, 1, true); if (string.IsNullOrEmpty(strFormat)) { return; } string strGroup = EcasUtil.GetParamString(a.Parameters, 2, true); string strTag = EcasUtil.GetParamString(a.Parameters, 3, true); PwDatabase pd = Program.MainForm.ActiveDatabase; if ((pd == null) || !pd.IsOpen) { return; } PwGroup pg = pd.RootGroup; if (!string.IsNullOrEmpty(strGroup)) { char chSep = strGroup[0]; PwGroup pgSub = pg.FindCreateSubTree(strGroup.Substring(1), new char[] { chSep }, false); pg = (pgSub ?? (new PwGroup(true, true, KPRes.Group, PwIcon.Folder))); } if (!string.IsNullOrEmpty(strTag)) { pg = pg.CloneDeep(); GroupHandler gh = delegate(PwGroup pgSub) { PwObjectList <PwEntry> l = pgSub.Entries; long n = (long)l.UCount; for (long i = n - 1; i >= 0; --i) { if (!l.GetAt((uint)i).HasTag(strTag)) { l.RemoveAt((uint)i); } } return(true); }; gh(pg); pg.TraverseTree(TraversalMethod.PreOrder, gh, null); } PwExportInfo pei = new PwExportInfo(pg, pd, true); IOConnectionInfo ioc = (!string.IsNullOrEmpty(strPath) ? IOConnectionInfo.FromPath(strPath) : null); ExportUtil.Export(pei, strFormat, ioc); }
private void ExportData() { string strFileName = GenerateFileName("StockTaking"); string strTemplateFileName = @"Report\STR030_StockTaking.xls"; string strTemplatePath = Path.Combine(Application.StartupPath, strTemplateFileName); string strExportPath = SaveDialogUtil.GetBrowseFileDialogForExport(strFileName); if (!"".Equals(strExportPath)) { StockTakingDTO dto = new StockTakingDTO(); dto.STOCK_TAKING_DATE = Convert.ToDateTime(dtStockTakingDate.DateValue); dto.LOCATION_CODE = cboProcess.SelectedValue == null ? string.Empty : cboProcess.SelectedValue.ToString();//txtLocation.Text; dto.PART_NO = txtMasterNo.Text; dto.PART_TYPE = Convert.ToString(cboItemType.SelectedValue); dto.PART_SUB_TYPE = Convert.ToString(cboItemClassMinor04.SelectedValue); if (chkIncomplete.Checked) { dto.SEARCH_INCOMPLETE = 1; } else { dto.SEARCH_INCOMPLETE = 0; } if (chkDiff.Checked) { dto.SEARCH_DIFF = 1; } else { dto.SEARCH_DIFF = 0; } if (chkNoMaster.Checked) { dto.NO_MASTER = 1; } else { dto.NO_MASTER = 0; } DataSet ds = GetExportTable(dto); ExportUtil.Export(ds, strTemplatePath, strExportPath); MessageDialog.ShowInformation(this, null, new EVOFramework.Message(Messages.eInformation.INF9003.ToString()).MessageDescription); if (File.Exists(strExportPath)) { System.Diagnostics.Process.Start(strExportPath); } } }
public override void OnExport() { if (shtQueryList.ActiveRowIndex == -1) { return; } if (m_dtAllData == null) { MessageBox.Show("ให้ทำการค้นหาข้อมูลก่อน export"); return; } string strReportID = ""; strReportID = shtQueryList.Cells[shtQueryList.ActiveRowIndex, (int)eColQueryList.ID].Text; string strFileName = GenerateFileName(strReportID); string strTemplateFileName = @"Report\" + this.txtTemplate.Text; string strTemplatePath = Path.Combine(Application.StartupPath, strTemplateFileName); string strExportPath = SaveDialogUtil.GetBrowseFileDialogForExport(strFileName); if (!"".Equals(strExportPath)) { DataSet ds = new DataSet(); ds.Tables.Add(this.m_dtAllData.Copy()); //ExportUtil.Export(ds, @"c:\testExport0.xls"); if (File.Exists(strTemplatePath)) { ExportUtil.Export(ds, strTemplatePath, strExportPath, ExportUtil.Format, Convert.ToInt32(txtStartColumn.Text), Convert.ToInt32(txtStartRow.Text)); } else { ExportUtil.Export(ds, strExportPath, ExportUtil.Format, Convert.ToInt32(txtStartColumn.Text), Convert.ToInt32(txtStartRow.Text)); } MessageDialogResult mdr = MessageDialog.ShowConfirmation(this, "บันทึกเสร็จแล้ว ต้องการเปิดไฟล์หรือไม่", EVOFramework.Windows.Forms.MessageDialogButtons.YesNo); if (mdr == MessageDialogResult.Yes) { System.Diagnostics.Process.Start(strExportPath); } } }
private void ExportOnHandForAccounting() { string strFileName = GenerateFileName("IVR010"); string strTemplateFileName = @"Report\IVR010_InventorySheet.xls"; string strTemplatePath = Path.Combine(Application.StartupPath, strTemplateFileName); string strExportPath = SaveDialogUtil.GetBrowseFileDialogForExport(strFileName); if (!"".Equals(strExportPath)) { ReportBIZ bizReport = new ReportBIZ(); ReportCriteriaDTO.IVR010 objCriteria = new ReportCriteriaDTO.IVR010(); if (this.dtPeriodBegin.Value.HasValue) { objCriteria.YearMonth = this.dtPeriodBegin.Value.Value.ToString("yyyyMM"); } else { objCriteria.YearMonth = DateTime.Today.ToString("yyyyMM"); } DataSet dsIVR010 = bizReport.LoadIVR010_InventorySheet(objCriteria); ExportUtil.Export(dsIVR010, strTemplatePath, strExportPath); MessageDialog.ShowInformation(this, null, new EVOFramework.Message(Messages.eInformation.INF9003.ToString()).MessageDescription); if (File.Exists(strExportPath)) { System.Diagnostics.Process.Start(strExportPath); } } }
private static void ExportDatabaseFile(EcasAction a, EcasContext ctx) { string strPath = EcasUtil.GetParamString(a.Parameters, 0, true); // if(string.IsNullOrEmpty(strPath)) return; // Allow no-file exports string strFormat = EcasUtil.GetParamString(a.Parameters, 1, true); if (string.IsNullOrEmpty(strFormat)) { return; } PwDatabase pd = Program.MainForm.ActiveDatabase; if ((pd == null) || !pd.IsOpen) { return; } PwExportInfo pei = new PwExportInfo(pd.RootGroup, pd, true); IOConnectionInfo ioc = (!string.IsNullOrEmpty(strPath) ? IOConnectionInfo.FromPath(strPath) : null); ExportUtil.Export(pei, strFormat, ioc); }