private void Form_PrintButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
using (PrintingSystem printingSystem = new PrintingSystem())
{
using (PrintableComponentLink link = new PrintableComponentLink(printingSystem))
{
link.Component = wb;
link.CreateDocument();
link.ShowPreviewDialog();
}
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
public DevNormalPrinting(ArrayList _arrLabel, ArrayList _arrValue,
ArrayList _arrLabel1, ArrayList _arrValue1, ArrayList _arrValue2, ArrayList _arrValue3,
PrintingSystem aPrintDocument)
{
//
// TODO: Add constructor logic here
//
arrLabel = _arrLabel;
arrValue = _arrValue;
arrLabel1 = _arrLabel1;
arrValue1 = _arrValue1;
arrValue2 = _arrValue2;
arrValue3 = _arrValue3;
this.ps = aPrintDocument;
aPrintDocument.PageSettings.TopMargin = 100;
aPrintDocument.PageSettings.TopMargin = 100;
ps.PageMargins.Top = 100;
TopMargin = ps.PageMargins.Top;
BottomMargin = ps.PageMargins.Bottom;
PageWidth = ps.PageBounds.Width - ps.PageMargins.Right - ps.PageMargins.Left;//Convert.ToInt32(ps.PageSettings.UsablePageSize.Width);
PageHeight = ps.PageBounds.Height - TopMargin - BottomMargin;//Convert.ToInt32(ps.PageSettings.UsablePageSize.Height);
//PageWidth = Convert.ToInt32(ps.PageSettings.UsablePageSize.Width);
//PageHeight = Convert.ToInt32(ps.PageSettings.UsablePageSize.Height);
//TopMargin = ps.PageMargins.Top;
//BottomMargin = ps.PageMargins.Bottom;
}
public static void PrintControl(IWin32Window owner, PictureEdit control)
{
using PrintingSystem ps = new PrintingSystem();
Link link = new Link(ps);
ps.Links.Add(link);
link.CreateDetailArea += (s, e) =>
{
Rectangle rect = new Rectangle(Point.Empty, control.Image.Size);
PrintCellHelperInfo info = new PrintCellHelperInfo(
Color.Empty,
e.Graph.PrintingSystem,
control.EditValue,
control.Properties.Appearance,
control.Text,
rect,
e.Graph);
e.Graph.DrawBrick((Brick)control.Properties.GetBrick(info), rect);
};
using (new WaitCursor())
{
link.CreateDocument(ps);
}
using var printTool = new PrintTool(ps);
printTool.ShowRibbonPreview(owner, control.LookAndFeel);
}
private void exportToolStripMenuItem_Click(object sender, EventArgs e)
{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = kPI_SET_RPRGridControl;
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = false;
link.Margins.Left = 50;
link.Margins.Right = 50;
link.Margins.Top = 50;
link.Margins.Bottom = 50;
var Font = new Font("Tahoma", 10, FontStyle.Bold);
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
phf.Header.Content.AddRange(new string[] { "", "KPI Set", "" });
phf.Header.LineAlignment = BrickAlignment.Far;
phf.Header.Font = Font;
phf.Footer.Content.AddRange(new string[] { "[Date Printed] [Time Printed]", "", Program.USR });
phf.Footer.LineAlignment = BrickAlignment.Near;
link.CreateDocument();
link.ShowPreview();
}
private void exportToolStripMenuItem_Click(object sender, EventArgs e)
{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = pPGridControl;
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = false;
link.Margins.Left = 50;
link.Margins.Right = 50;
link.Margins.Top = 50;
link.Margins.Bottom = 50;
var Font = new Font("Tahoma", 12, FontStyle.Bold);
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
string mdlH = string.Format("BODVED OYUNCU LİSTESİ");
phf.Header.Content.AddRange(new string[] { "", mdlH, "" });
phf.Header.LineAlignment = BrickAlignment.Far;
phf.Header.Font = Font;
phf.Footer.Content.AddRange(new string[] { "[Date Printed] [Time Printed]", "masatenisi.online", "©Şener DEMİRAL" });
phf.Footer.LineAlignment = BrickAlignment.Near;
link.CreateDocument();
link.ShowPreview();
}
private void faturaListesiToolStripMenuItem_Click(object sender, EventArgs e)
{
//colTAGS.Visible = false;
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = afbGridControl;
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = false;
link.Margins.Left = 50;
link.Margins.Right = 50;
link.Margins.Top = 50;
link.Margins.Bottom = 50;
var Font = new Font("Tahoma", 12, FontStyle.Bold);
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
string mdlH = string.Format("FATURALAR");
phf.Header.Content.AddRange(new string[] { "", mdlH, "" });
phf.Header.LineAlignment = BrickAlignment.Far;
phf.Header.Font = Font;
phf.Footer.Content.AddRange(new string[] { "[Date Printed] [Time Printed]", "", Program.USR });
phf.Footer.LineAlignment = BrickAlignment.Near;
link.CreateDocument();
link.ShowPreview();
}
/// <summary>
/// ExportPdf
/// </summary>
public void ExportPdf()
{
if (PrintingSystem == null)
{
DialogBox.Msg("报表内容为空。");
}
else
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "PDF file(*.pdf)|*.pdf";
//saveFileDialog.Filter = "BMP file(*.bmp)|*.bmp";
saveFileDialog.RestoreDirectory = true;
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
try
{
//// Get its Image export options.
//ImageExportOptions imageOptions = this.XR.ExportOptions.Image;
//// Set Image-specific export options.
//imageOptions.Format = System.Drawing.Imaging.ImageFormat.Bmp;
//this.XR.ExportToImage(saveFileDialog.FileName);
PrintingSystem.ExportToPdf(saveFileDialog.FileName);
}
catch (Exception ex)
{
DialogBox.Msg(ex.Message);
}
}
}
}
private void ShowDefaultReport(IPrintable e, bool isPrint)
{
PrintingSystem p = new PrintingSystem();
p.ShowMarginsWarning = false;
p.PreviewFormEx.KeyUp += new KeyEventHandler(PreviewFormEx_KeyUp);
PrintableComponentLink i = new PrintableComponentLink(p);
i.CreateDocument(p);
i.Component = e;
i.Landscape = _data.DrTable["isLand"] == DBNull.Value || bool.Parse(_data.DrTable["isLand"].ToString());
i.PaperKind = PaperKind.A4;
i.RtfReportFooter = "Tổng Cộng";
i.Margins = new System.Drawing.Printing.Margins(25, 25, 25, 25);
i.CreateReportHeaderArea += new CreateAreaEventHandler(i_CreateReportHeaderArea);
i.CreateReportFooterArea += new CreateAreaEventHandler(i_CreateReportFooterArea);
gridViewReport.ColumnPanelRowHeight = 30;
gridViewReport.OptionsPrint.UsePrintStyles = true;
i.CreateDocument();
i.ShowPreview(this.gridControlReport.LookAndFeel);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
//if (DevExpress.XtraPrinting.PrintHelper.IsPrintingAvailable)
//{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = orderGrid;
link.Landscape = true;
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
phf.Header.Content.Clear();
phf.Header.Content.AddRange(new string[] { "", "订单明细列表", "" });
phf.Header.Font = new System.Drawing.Font("宋体", 16, System.Drawing.FontStyle.Regular);
phf.Header.LineAlignment = BrickAlignment.Center;
phf.Footer.Content.Clear();
phf.Footer.Content.AddRange(new string[] { "", String.Format("打印时间: {0:g}", DateTime.Now), "" });
link.CreateDocument();
link.ShowPreview();
//}
//else
//{
// XtraMessageBox.Show("打印机不可用...", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
}
void ExportTo(string index, string fileName, PrintingSystem ps)
{
if(!String.IsNullOrEmpty(fileName))
try {
Cursor.Current = Cursors.WaitCursor;
if(index.Contains("PDF")) ps.ExportToPdf(fileName);
else if(index.Contains("HTML")) ps.ExportToHtml(fileName);
else if(index.Contains("MHT")) ps.ExportToMht(fileName);
else if(index.Contains("RTF")) ps.ExportToRtf(fileName);
else if(index.Contains("XLS")) ps.ExportToXls(fileName);
else if(index.Contains("XLSX")) ps.ExportToXlsx(fileName);
else if(index.Contains("CSV")) ps.ExportToCsv(fileName);
else if(index.Contains("Text")) ps.ExportToText(fileName);
else if(index.Contains("Image"))
ps.ExportToImage(fileName, formats[saveFileDialog1.FilterIndex]);
Cursor.Current = Cursors.Default;
if(XtraMessageBox.Show(Properties.Resources.OpentFileQuestion, Properties.Resources.Export, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) {
Process process = new Process();
try {
process.StartInfo.FileName = saveFileDialog1.FileName;
process.Start();
} catch {
}
}
} catch {
ShowExportErrorMessage();
} finally {
Cursor.Current = Cursors.Default;
}
}
public void ShowForm(string ReportName, PrintingSystem ps)
{
if (BaseWinFramework.mdiRibbonControl != null)
{
if (CurrentForm == null || CurrentForm.IsDisposed)
{
CurrentForm = new frmPreview();
}
frmPreview p = (frmPreview)CurrentForm;
p.ShowForm(BaseWinFramework._MdiParent,
ReportName, ps);
}
else
{
if (CurrentForm == null || CurrentForm.IsDisposed)
{
CurrentForm = new frmPreview2();
}
frmPreview2 p = (frmPreview2)CurrentForm;
p.ShowForm(BaseWinFramework._MdiParent,
ReportName, ps);
}
}
private void ShowCustomizePreview(IPrintable ctrl, bool isLanscape)
{
// Create a PrintingSystem component.
PrintingSystem ps = new PrintingSystem();
// Create a link that will print a control.
PrintableComponentLink Print = new PrintableComponentLink(ps);
// Specify the control to be printed.
Print.Component = ctrl;
// Set the paper format.
Print.PaperKind = System.Drawing.Printing.PaperKind.A4;
Print.Landscape = isLanscape;
Print.Margins = new System.Drawing.Printing.Margins(40, 40, 40, 40);
string dbName = Config.GetValue("DbName").ToString();
if (dbName.Contains("DEMO"))
{
ps.Watermark.Text = "Hoa Tiêu Demo";
ps.Watermark.TextTransparency = 150;
}
// Subscribe to the CreateReportHeaderArea event used to generate the report header.
Print.CreateReportHeaderArea +=
new CreateAreaEventHandler(Print_CreateReportHeaderArea);
Print.CreateReportFooterArea += new CreateAreaEventHandler(Print_CreateReportFooterArea);
// Generate the report.
Print.CreateDocument();
// Show the report.
Print.ShowPreview();
}
private void printToolStripMenuItem_Click(object sender, EventArgs e)
{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = avdGridControl;
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = false;
link.Margins.Left = 50;
link.Margins.Right = 50;
link.Margins.Top = 50;
link.Margins.Bottom = 50;
var Font = new Font("Tahoma", 12, FontStyle.Bold);
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
string reportHeader = string.Format("Muhasebe Fişi {0}, {1}, {2}", avbRow.AVBID, avbvGridControl.GetCellDisplayText(rowTUR, 0), avbvGridControl.GetCellDisplayText(rowTRH, 0));
phf.Header.Content.AddRange(new string[] { "", reportHeader, "" });
phf.Header.LineAlignment = BrickAlignment.Far;
phf.Header.Font = Font;
phf.Footer.Content.AddRange(new string[] { "[Date Printed] [Time Printed]", "", Program.USR });
phf.Footer.LineAlignment = BrickAlignment.Near;
link.CreateDocument();
link.ShowPreview();
}
private void btnPrint_Click(object sender, EventArgs e)
{
PrintingSystem client = new PrintingSystem(new UserPrinterHTML());
//Call to Start method with proper object.
client.Print(new RegisterCBAUserRequestDTO());
}
public override void CreateDocument(PrintingSystem ps)
{
if (ps != null)
{
base.CreateDocument();
}
}
private void exportToolStripMenuItem_Click(object sender, EventArgs e)
{
//opmaGridControl.ShowPrintPreview();
//return;
PrintingSystem ps = new PrintingSystem();
// Create a link that will print a control.
PrintableComponentLink link = new PrintableComponentLink(ps);
// Specify the control to be printed.
link.Component = opmaGridControl;
// Set the paper format.
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = true;
link.Margins.Left = 50;
link.Margins.Right = 50;
link.Margins.Top = 50;
link.Margins.Bottom = 50;
// Subscribe to the CreateReportHeaderArea event used to generate the report header.
//link.CreateMarginalHeaderArea += link_CreateMarginalHeaderArea;
//link.CreateMarginalFooterArea += link_CreateMarginalFooterArea;
// Generate the report.
link.CreateDocument();
// Show the report.
link.ShowPreview();
}
private void galleryControlGallery1_ItemClick(object sender, DevExpress.XtraBars.Ribbon.GalleryItemClickEventArgs e)
{
string index = string.Format("{0}", e.Item.Tag);
FrmMain frm = BackstageView.Ribbon.FindForm() as FrmMain;
if (frm == null)
{
return;
}
if (index.Contains("PDF"))
{
saveFileDialog1.Filter = Properties.Resources.PDFFilter;
}
else if (index.Contains("HTML"))
{
saveFileDialog1.Filter = Properties.Resources.HTMLFilter;
}
else if (index.Contains("MHT"))
{
saveFileDialog1.Filter = Properties.Resources.MHTFilter;
}
else if (index.Contains("RTF"))
{
saveFileDialog1.Filter = Properties.Resources.RTFFilter;
}
else if (index.Contains("XLS"))
{
saveFileDialog1.Filter = Properties.Resources.XLSFilter;
}
else if (index.Contains("XLSX"))
{
saveFileDialog1.Filter = Properties.Resources.XLSXFilter;
}
else if (index.Contains("CSV"))
{
saveFileDialog1.Filter = Properties.Resources.CSVFilter;
}
else if (index.Contains("Text"))
{
saveFileDialog1.Filter = Properties.Resources.TextFilter;
}
else if (index.Contains("Image"))
{
saveFileDialog1.Filter = Properties.Resources.ImageFilter;
}
saveFileDialog1.Filter += "|" + Properties.Resources.AllFilesFilter;
saveFileDialog1.FilterIndex = 0;
saveFileDialog1.FileName = frm.CurrentModuleName;
if (saveFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = frm.CurrentExportComponent;
link.CreateDocument();
ExportTo(index, saveFileDialog1.FileName, ps);
}
protected void Dispose(bool Disposing)
{
if (!IsDisposed)
{
if (Disposing)
{
//if (this.waitDialog != null)
//{
// this.waitDialog.Dispose();
// this.waitDialog = null;
//}
this.saveFileDialog.Dispose();
this.saveFileDialog = null;
this.printCompageLink.Dispose();
this.printCompageLink = null;
this.printSystem.Dispose();
this.printSystem = null;
//this._exportView.Dispose();
//this._exportView = null;
}
}
IsDisposed = true;
}
private void galleryControlGallery1_ItemClick(object sender, DevExpress.XtraBars.Ribbon.GalleryItemClickEventArgs e) {
string index = string.Format("{0}", e.Item.Tag);
frmMain frm = BackstageView.Ribbon.FindForm() as frmMain;
if(frm == null) return;
if(index.Contains("PDF"))
saveFileDialog1.Filter = Properties.Resources.PDFFilter;
else if(index.Contains("HTML"))
saveFileDialog1.Filter = Properties.Resources.HTMLFilter;
else if(index.Contains("MHT"))
saveFileDialog1.Filter = Properties.Resources.MHTFilter;
else if(index.Contains("RTF"))
saveFileDialog1.Filter = Properties.Resources.RTFFilter;
else if(index.Contains("XLS"))
saveFileDialog1.Filter = Properties.Resources.XLSFilter;
else if(index.Contains("XLSX"))
saveFileDialog1.Filter = Properties.Resources.XLSXFilter;
else if(index.Contains("CSV"))
saveFileDialog1.Filter = Properties.Resources.CSVFilter;
else if(index.Contains("Text"))
saveFileDialog1.Filter = Properties.Resources.TextFilter;
else if(index.Contains("Image"))
saveFileDialog1.Filter = Properties.Resources.ImageFilter;
saveFileDialog1.Filter += "|" + Properties.Resources.AllFilesFilter;
saveFileDialog1.FilterIndex = 0;
saveFileDialog1.FileName = frm.CurrentModuleName;
if(saveFileDialog1.ShowDialog() != DialogResult.OK) return;
Cursor.Current = Cursors.WaitCursor;
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = frm.CurrentExportComponent;
link.CreateDocument();
ExportTo(index, saveFileDialog1.FileName, ps);
}
//Constructor
public clsDevExpressFormPrinting(System.Windows.Forms.Control f,PrintingSystem pd)
{
//DevExpress.XtraPrinting.PrintingSystem pd = new PrintingSystem();
this.ps = pd;
this.ps.PageSettings.LeftMargin = 70;
this.ps.PageSettings.RightMargin = 70;
_f = f;
_TextBoxLikeControl = new ArrayList();
_DelegatesforControls = new ArrayList();
_Pen = new Pen(Color.Black);
// add build-in types and functions
AddTextBoxLikeControl("ComboBox");
AddTextBoxLikeControl("DateTimePicker");
AddTextBoxLikeControl("DateTimeSlicker");
AddTextBoxLikeControl("NumericUpDown");
AddDelegateToPrintControl("TextBox", new ControlPrinting(PrintTextBox));
AddDelegateToPrintControl("System.Windows.Forms.Label", new ControlPrinting(PrintLabel));
AddDelegateToPrintControl("System.Windows.Forms.LinkLabel", new ControlPrinting(PrintLabel));
AddDelegateToPrintControl("System.Windows.Forms.CheckBox", new ControlPrinting(PrintCheckBox));
//AddDelegateToPrintControl("System.Windows.Forms.RadioButton", new ControlPrinting(PrintRadioButton));
AddDelegateToPrintControl("System.Windows.Forms.GroupBox", new ControlPrinting(PrintGroupBox));
//AddDelegateToPrintControl("System.Windows.Forms.Panel", new ControlPrinting(PrintPanel));
AddDelegateToPrintControl("System.Windows.Forms.TabControl", new ControlPrinting(PrintTabControl));
AddDelegateToPrintControl("System.Windows.Forms.PictureBox", new ControlPrinting(PrintPictureBox));
AddDelegateToPrintControl("System.Windows.Forms.ListBox", new ControlPrinting(PrintListBox));
AddDelegateToPrintControl("System.Windows.Forms.DataGrid", new ControlPrinting(PrintDataGrid));
AddDelegateToPrintControl("DevExpress.XtraEditors.SpinEdit", new ControlPrinting(PrintTextBox));
AddDelegateToPrintControl("DevExpress.XtraGrid.GridControl", new ControlPrinting(PrintDataGrid));
}
public static void ExportXls(GridControl gridControl1, string title)
{
var ps = new PrintingSystem();
var link = new PrintableComponentLink(ps);
link.PaperKind = System.Drawing.Printing.PaperKind.A4Rotated;
ps.Links.Add(link);
link.Component = gridControl1;
var phf = (PageHeaderFooter)link.PageHeaderFooter;
phf.Header.Content.Clear();
phf.Header.Content.AddRange(new[] { "", title, "" });
phf.Header.Font = new Font("微软雅黑", 22, FontStyle.Bold);
phf.Header.LineAlignment = BrickAlignment.Center;
phf.Footer.Content.Clear();
phf.Footer.Content.AddRange(new[] { "", "", String.Format("打印时间: {0:g}", DateTime.Now) });
phf.Footer.Font = new Font("微软雅黑", 16, FontStyle.Regular);
link.ShowRibbonPreview(UserLookAndFeel.Default);
var dialog = new SaveFileDialog {
Filter = @"Excel文件|*.xls"
};
DialogResult result = dialog.ShowDialog();
if (result == DialogResult.OK)
{
ps.ExportToXls(dialog.FileName);
}
}
private void toolStripMenuItemPvtExport_Click(object sender, EventArgs e)
{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = pivotGridControl1;
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = true;
link.Margins.Left = 50;
link.Margins.Right = 50;
link.Margins.Top = 50;
link.Margins.Bottom = 50;
var Font = new Font("Tahoma", 12, FontStyle.Bold);
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
string mdlH = string.Format("KPI House");
phf.Header.Content.AddRange(new string[] { "", mdlH, "" });
phf.Header.LineAlignment = BrickAlignment.Far;
phf.Header.Font = Font;
phf.Footer.Content.AddRange(new string[] { "[Date Printed] [Time Printed]", "", Program.USR });
phf.Footer.LineAlignment = BrickAlignment.Near;
link.CreateDocument();
link.ShowPreview();
}
/// <summary>
/// Show a print preview document for a <see cref="GridControl"/> and adds a standard header.
/// </summary>
/// <param name="title">Document title.</param>
/// <param name="grid">Grid control.</param>
public void PrintPreview(string title, DevExpress.XtraPrinting.Preview.DocumentViewer docViewer, DevExpress.XtraGrid.GridControl grid)
{
if (grid == null)
{
return;
}
PrintableComponentLink link = new PrintableComponentLink(new DevExpress.XtraPrinting.PrintingSystem());
link.Component = grid;
link.Images.Add(Properties.Resources.IMG_LOGO_PRINT);
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
phf.Header.Font = new System.Drawing.Font("Segoe UI", 12, System.Drawing.FontStyle.Bold);
phf.Header.Content.Clear();
phf.Header.Content.AddRange(new string[] { title, "", "[Image 0]" });
phf.Header.LineAlignment = BrickAlignment.Center;
phf.Footer.Font = new System.Drawing.Font("Segoe UI", 10, System.Drawing.FontStyle.Regular);
phf.Footer.Content.Clear();
phf.Footer.Content.AddRange(new string[] { "[Date Printed] [Time Printed]", "", "Page [Page # of Pages #]" });
phf.Footer.LineAlignment = BrickAlignment.Center;
PrintingSystem ps = new PrintingSystem();
ps.Links.Add(link);
link.CreateDocument();
docViewer.DocumentSource = ps;
}
private void button1_Click(object sender, EventArgs e)
{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = pivotGridControl1;
PageSettings pageSettings = pivotGridControl1.OptionsPrint.PageSettings.ToPageSettings();
link.PaperKind = pageSettings.PaperSize.Kind;
if (pageSettings.PaperSize.Width != 0 && pageSettings.PaperSize.Height != 0)
{
link.CustomPaperSize = new Size(pageSettings.PaperSize.Width, pageSettings.PaperSize.Height);
}
link.PaperName = pageSettings.PaperSize.PaperName;
link.Landscape = pageSettings.Landscape;
link.Margins = pageSettings.Margins;
link.ShowPreviewDialog(this);
PivotGridPageSettings pivotSettings = pivotGridControl1.OptionsPrint.PageSettings;
pivotSettings.PaperKind = link.PaperKind;
if (pivotSettings.PaperKind == PaperKind.Custom)
{
pivotSettings.PaperWidth = link.CustomPaperSize.Width;
pivotSettings.PaperHeight = link.CustomPaperSize.Height;
}
pivotSettings.Landscape = link.Landscape;
pivotSettings.Margins = link.Margins;
link.Dispose();
ps.Dispose();
}
public ActionResult ExportPivotChart()
{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink pclPivot = new PrintableComponentLink(ps);
pclPivot.Component = PivotGridExtension.CreatePrintableObject(GetPivotGridSettings(), GetSalesPersonData());
PrintableComponentLink pclChart = new PrintableComponentLink(ps);
using (MemoryStream chartLayout = new MemoryStream())
{
GetChartSettings().SaveToStream(chartLayout);
MVCxChartControl chart = new MVCxChartControl();
chart.LoadFromStream(chartLayout);
chart.DataSource = PivotGridExtension.GetDataObject(GetPivotGridSettings(), GetSalesPersonData(), true);
chart.Width = 900;
chart.Height = 400;
chart.DataBind();
pclChart.Component = ((IChartContainer)chart).Chart;
}
CompositeLink compositeLink = new CompositeLink(ps);
compositeLink.Links.AddRange(new object[] { pclPivot, pclChart });
compositeLink.CreateDocument();
MemoryStream stream = new MemoryStream();
compositeLink.PrintingSystem.ExportToXls(stream);
stream.Position = 0;
ps.Dispose();
return(File(stream, "application/ms-excel", "PivotWithChart.xls"));
}
public DevNormalPrinting(ArrayList _arrLabel, ArrayList _arrValue,
ArrayList _arrLabel1, ArrayList _arrValue1,
ArrayList _arrValue2,
ArrayList _arrValue3,
ArrayList _arrValue4,
PrintingSystem aPrintDocument)
{
//
// TODO: Add constructor logic here
//
sClass = true;
arrLabel = _arrLabel;
arrValue = _arrValue;
arrLabel1 = _arrLabel1;
arrValue1 = _arrValue1;
arrValue2 = _arrValue2;
arrValue3 = _arrValue3;
arrValue4 = _arrValue4;
this.ps = aPrintDocument;
aPrintDocument.PageSettings.TopMargin = 100;
aPrintDocument.PageSettings.TopMargin = 100;
ps.PageSettings.TopMargin = 100;
TopMargin = ps.PageMargins.Top;
BottomMargin = ps.PageMargins.Bottom;
PageWidth = ps.PageBounds.Width - ps.PageMargins.Right - ps.PageMargins.Left; //Convert.ToInt32(ps.PageSettings.UsablePageSize.Width);
PageHeight = ps.PageBounds.Height - TopMargin - BottomMargin; //Convert.ToInt32(ps.PageSettings.UsablePageSize.Height);
//PageWidth = Convert.ToInt32(ps.PageSettings.UsablePageSize.Width);
//PageHeight = Convert.ToInt32(ps.PageSettings.UsablePageSize.Height);
//TopMargin = ps.PageMargins.Top;
//BottomMargin = ps.PageMargins.Bottom;
}
private void exportToolStripMenuItem_Click(object sender, EventArgs e)
{
//if (!Program.MF.EntryCheck("Ops.Proje.Export", isSilent: true))
// return;
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = prtGridControl;
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = true;
link.Margins.Left = 50;
link.Margins.Right = 50;
link.Margins.Top = 50;
link.Margins.Bottom = 50;
var Font = new Font("Tahoma", 10, FontStyle.Bold);
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
phf.Header.Content.AddRange(new string[] { "", "Projeler", "" });
phf.Header.LineAlignment = BrickAlignment.Far;
phf.Header.Font = Font;
phf.Footer.Content.AddRange(new string[] { "[Date Printed] [Time Printed]", "", Program.USR });
phf.Footer.LineAlignment = BrickAlignment.Near;
link.CreateDocument();
link.ShowPreview();
}
private void Form1_Load(object sender, EventArgs e)
{
PrintingSystem ps = new PrintingSystem();
documentViewer1.PrintingSystem = ps;
// Draw a simple text brick.
ps.Begin();
ps.Graph.DrawString("Some Text", new RectangleF(0, 20, 200, 20));
ps.End();
// Obtain its Export options.
ExportOptions options = ps.ExportOptions;
// Hide the "Never Embedded Fonts" option, if required.
if (options.GetOptionVisibility(ExportOptionKind.PdfNeverEmbeddedFonts) != false)
{
options.SetOptionVisibility(ExportOptionKind.PdfNeverEmbeddedFonts, false);
}
// Hide all Document Options for PDF export.
options.SetOptionsVisibility(new ExportOptionKind[] { ExportOptionKind.PdfDocumentApplication,
ExportOptionKind.PdfDocumentAuthor, ExportOptionKind.PdfDocumentKeywords,
ExportOptionKind.PdfDocumentSubject, ExportOptionKind.PdfDocumentTitle }, false);
}
private void exportToolStripMenuItem_Click(object sender, EventArgs e)
{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = accMizanGridControl;
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = false;
link.Margins.Left = 50;
link.Margins.Right = 50;
link.Margins.Top = 50;
link.Margins.Bottom = 50;
var Font = new Font("Tahoma", 12, FontStyle.Bold);
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
string mdlH = string.Format("MİZAN {0:dd.MM.yy} - {1:dd.MM.yy}", dateEdit1.DateTime, dateEdit2.DateTime.AddDays(-1));
phf.Header.Content.AddRange(new string[] { "", mdlH, "" });
phf.Header.LineAlignment = BrickAlignment.Far;
phf.Header.Font = Font;
phf.Footer.Content.AddRange(new string[] { "[Date Printed] [Time Printed]", "", Program.USR });
phf.Footer.LineAlignment = BrickAlignment.Near;
link.CreateDocument();
link.ShowPreview();
}
protected void Button1_Click(object sender, EventArgs e)
{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link1 = new PrintableComponentLink();
link1.Component = ASPxPivotGridExporter1;
link1.PrintingSystem = ps;
Link link2 = new Link();
link2.CreateDetailArea += new CreateAreaEventHandler(link2_CreateDetailArea);
link2.PrintingSystem = ps;
CompositeLink compositeLink = new CompositeLink();
compositeLink.Links.AddRange(new object[] { link2, link1 });
compositeLink.PrintingSystem = ps;
compositeLink.CreateDocument();
compositeLink.PrintingSystem.ExportOptions.Pdf.DocumentOptions.Author = "Test";
using (MemoryStream stream = new MemoryStream())
{
compositeLink.PrintingSystem.ExportToPdf(stream);
Response.Clear();
Response.Buffer = false;
Response.AppendHeader("Content-Type", "application/pdf");
Response.AppendHeader("Content-Transfer-Encoding", "binary");
Response.AppendHeader("Content-Disposition", "attachment; filename=test.pdf");
Response.BinaryWrite(stream.ToArray());
Response.End();
}
ps.Dispose();
}
private static void DoPrint(List <t_trade> trds)
{
var ps = new PrintingSystem();
ps.Document.Pages.Clear();
ps.ShowMarginsWarning = false;
ps.ClearContent();
var whr = trds.Select(k => k.Guid.ToString()).Aggregate((s1, s2) => s1 + "','" + s2);
using (var db = new Database()) {
var vtrds = db.Fetch <t_trade>(string.Format(" where guid in ('{0}')", whr));
var orders = db.Fetch <t_order>(string.Format(" where tradeguid in ('{0}')", whr));
vtrds.ForEach(trd => {
var prtinfo = new PrintInfo();
prtinfo.Trade = trd;
prtinfo.Orders = orders.Where(odr => odr.TradeGuid == trd.Guid).ToList();
var rptfh = new rptFH();
rptfh.BindPrintData(prtinfo);
rptfh.CreateDocument();
ps.Document.Pages.AddRange(rptfh.Pages);
});
}
ps.Print();
}
/// <summary>
/// DevExpress通用导出Excel,支持多个控件同时导出在同一个Sheet表
/// eg:ExportToXlsx("",gridControl1,gridControl2);
/// 将gridControl1和gridControl2的数据一同导出到同一张工作表
/// </summary>
/// <param name="title">文件名</param>
/// <param name="panels">控件集</param>
public static void ExportToExcel(string title, GridControl panels)
{
var saveFileDialog = new SaveFileDialog();
saveFileDialog.FileName = title;
saveFileDialog.Title = "导出Excel";
saveFileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx|Excel文件(*.xls)|*.xls";
DialogResult dialogResult = saveFileDialog.ShowDialog();
if (dialogResult == DialogResult.Cancel)
{
return;
}
string FileName = saveFileDialog.FileName;
var ps = new PrintingSystem();
CompositeLink link = new CompositeLink(ps);
ps.Links.Add(link);
link.Links.Add(CreatePrintableLink(panels));
link.Landscape = true;//横向
//判断是否有标题，有则设置
//link.CreateDocument(); //建立文档
try
{
int count = 1;
//在重复名称后加（序号）
while (File.Exists(FileName))
{
if (FileName.Contains(")."))
{
int start = FileName.LastIndexOf("(");
int end = FileName.LastIndexOf(").") - FileName.LastIndexOf("(") + 2;
FileName = FileName.Replace(FileName.Substring(start, end), string.Format("({0}).", count));
}
else
{
FileName = FileName.Replace(".", string.Format("({0}).", count));
}
count++;
}
if (FileName.LastIndexOf(".xlsx") >= FileName.Length - 5)
{
XlsxExportOptions options = new XlsxExportOptions();
link.ExportToXlsx(FileName, options);
}
else
{
XlsExportOptions options = new XlsExportOptions();
link.ExportToXls(FileName, options);
}
if (DevExpress.XtraEditors.XtraMessageBox.Show("保存成功，是否打开文件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(FileName);//打开指定路径下的文件
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message);
}
}
/// <summary>
/// Complete data retrieval
/// </summary>
/// <returns></returns>
DialogResult CompleteRetrieval()
{
PrintingSystem ps = (PrintingSystem)Instance.PrintControl.PrintingSystem;
PrintableComponentLink pcl = ps.Links[0] as PrintableComponentLink;
DataTableManager dtm = Qm.DataTableManager;
if (!dtm.RowRetrievalComplete)
{ // be sure we have the complete set of rows
MoleculeGridControl mg = Qm.MoleculeGrid;
Qm.MoleculeGrid = null; // don't update the grid itself
DialogResult dr = dtm.CompleteRetrieval();
Qm.MoleculeGrid = mg;
if (dr == DialogResult.Cancel)
{
return(dr);
}
}
if (Qm.DataTable.Rows.Count != PreviewRowCount)
{
pcl.CreateDocument(); // recreate the document with full set of rows
}
return(DialogResult.OK);
}
public static void ExportToExcel(string title, params IPrintable[] panels)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.FileName = title;
saveFileDialog.Title = string.Format("{0} Excel", UnitField.Export);
saveFileDialog.Filter = "Excel (*.xlsx)|*.xlsx|Excel(*.xls)|*.xls";
if (saveFileDialog.ShowDialog() == DialogResult.Cancel)
{
return;
}
string text = saveFileDialog.FileName;
PrintingSystem expr_43 = new PrintingSystem();
CompositeLink compositeLink = new CompositeLink(expr_43);
expr_43.Links.Add(compositeLink);
for (int i = 0; i < panels.Length; i++)
{
IPrintable printable = panels[i];
compositeLink.Links.Add(ExportToExcelHelper.CreatePrintableLink(printable));
}
compositeLink.Landscape = true;
try
{
int num = 1;
while (File.Exists(text))
{
if (text.Contains(")."))
{
int startIndex = text.LastIndexOf("(", StringComparison.Ordinal);
int length = text.LastIndexOf(").", StringComparison.Ordinal) - text.LastIndexOf("(", StringComparison.Ordinal) + 2;
text = text.Replace(text.Substring(startIndex, length), string.Format("({0}).", num));
}
else
{
text = text.Replace(".", string.Format("({0}).", num));
}
num++;
}
if (text.LastIndexOf(".xlsx", StringComparison.Ordinal) >= text.Length - 5)
{
XlsxExportOptions options = new XlsxExportOptions();
compositeLink.ExportToXlsx(text, options);
}
else
{
XlsExportOptions options2 = new XlsExportOptions();
compositeLink.ExportToXls(text, options2);
}
if (XtraMessageBox.Show(UnitField.ExportOK, UnitField.SystemMessage, MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
{
Process.Start(text);
}
}
catch (Exception arg_16F_0)
{
XtraMessageBox.Show(arg_16F_0.Message);
}
}
void CreateDocument() {
PrintingSystem ps = new PrintingSystem();
if(true.Equals(printControl1.Tag))
ps.StartPrint -= new PrintDocumentEventHandler(OnStartPrint);
printControl1.PrintingSystem = ps;
ps.StartPrint += new PrintDocumentEventHandler(OnStartPrint);
printControl1.Tag = true;
CreateLink(ps);
this.pageButtonEdit.EditValue = 1;
UpdatePagesInfo();
}
public override void CreateDocument(PrintingSystem ps)
{
if(ps != null)
{
BrickGraphics g = ps.Graph;
g.BackColor = Color.White;
g.BorderColor = Color.Black;
g.Font = g.DefaultFont;
g.StringFormat = g.StringFormat.ChangeLineAlignment(StringAlignment.Near);
base.CreateDocument(ps);
}
}
public DevExpressClassPrinting(PrintingSystem ps, ArrayList _arrLabel, ArrayList _arrValue)
: base(ps)
{
printingSystem = ps;
arrLabel = _arrLabel;
arrValue = _arrValue;
PageWidth = ps.PageSettings.UsablePageSize.Width;
PageHeight = ps.PageSettings.UsablePageSize.Height;
TopMargin = ps.PageMargins.Top;
BottomMargin = ps.PageMargins.Bottom;
CreateDocument(ps);
}
void CreateLink(PrintingSystem ps) {
frmMain frm = BackstageView.Ribbon.FindForm() as frmMain;
bool showMemo = memoStyle.Checked && frm.CurrentRichEdit != null;
if(showMemo) {
Link link = new Link(ps);
link.RtfReportHeader = frm.CurrentRichEdit.RtfText;
link.PaperKind = GetPaperKind();
link.Landscape = GetLandscape();
link.Margins = GetMargins();
link.CreateDocument();
} else {
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = frm.CurrentPrintableComponent;
link.PaperKind = GetPaperKind();
link.Landscape = GetLandscape();
link.Margins = GetMargins();
link.CreateDocument();
}
}
/// <summary>
/// Initializes a new instance of the <see cref="XtraPrintService"/> class.
/// </summary>
/// <param name="printable">The printable.</param>
public XtraPrintService(IPrintable printable)
{
printSystem = new PrintingSystem();
printSystem.ShowMarginsWarning = false;
PrintableComponentLink pcl = new PrintableComponentLink(printSystem);
pcl.CreateMarginalHeaderArea += new CreateAreaEventHandler(pcl_CreateMarginalHeaderArea);
pcl.CreateMarginalFooterArea += new CreateAreaEventHandler(pcl_CreateMarginalFooterArea);
pcl.Component = printable;
printSystem.Links.Add(pcl);
PrinterSettingsUsing pst = new PrinterSettingsUsing();
pst.UseMargins = false;
pst.UsePaperKind = false;
printSystem.PageSettings.PaperKind = PaperKind.A4;
printSystem.PageSettings.PaperName = "A4";
printSystem.PageSettings.LeftMargin = 5;
printSystem.PageSettings.RightMargin = 5;
printSystem.PageSettings.AssignDefaultPrinterSettings(pst);
}
public static void DevPrint(GridControl gc,String printHeader)
{
var ps = new PrintingSystem();
var link = new PrintableComponentLink(ps);
ps.Links.Add(link);
link.Component = gc;//这里可以是可打印的部件
var phf = link.PageHeaderFooter as PageHeaderFooter;
if (phf != null)
{
phf.Header.Content.Clear();
phf.Header.Content.AddRange(new[] { "", printHeader, "" });
phf.Header.Font = new System.Drawing.Font("宋体", 14, System.Drawing.FontStyle.Bold);
phf.Header.LineAlignment = BrickAlignment.Center;
}
link.CreateDocument(); //建立文档
ps.PreviewFormEx.Show();
}
public ReportCenter(IPrintable Printable, string ReportName, string Condition)
{
printSystem = new PrintingSystem();
mReportName = ReportName;
mCondition = Condition;
PrintableComponentLink pcl = new PrintableComponentLink();
pcl.CreateMarginalHeaderArea += new DevExpress.XtraPrinting.CreateAreaEventHandler(link_CreateMarginalHeaderArea);
pcl.CreateMarginalFooterArea += new DevExpress.XtraPrinting.CreateAreaEventHandler(link_CreateMarginalFooterArea);
pcl.Component = Printable;
printSystem.Links.Add(pcl);
pcl.CreateDocument();
PrinterSettingsUsing pst = new PrinterSettingsUsing();
pst.UseMargins = true;
//pst.UsePaperKind = false;
printSystem.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
printSystem.PageSettings.PaperName = "A4";
printSystem.PageSettings.LeftMargin = 30;
printSystem.PageSettings.RightMargin = 30;
printSystem.PageSettings.AssignDefaultPrinterSettings(pst);
}
protected virtual void OnPreview()
{
if (Printer == null) return;
SplashScreenManager.ShowForm(typeof (EasyWaitForm));
var ps = new PrintingSystem();
var link = new PrintableComponentLink(ps);
link.Component = Printer;
link.PaperKind = PaperKind.A4;
link.CreateReportHeaderArea += printableComponentLink_CreateReportHeaderArea;
link.CreateReportFooterArea += printableComponentLink_CreateReportFooterArea;
link.Margins.Bottom = link.Margins.Left = link.Margins.Right = link.Margins.Top = 50;
link.CreateDocument();
link.ShowPreview();
SplashScreenManager.CloseForm();
}
private void btnOpenReport_ItemClick(object sender, ItemClickEventArgs e)
{
//DevExpress.XtraPrinting.Preview.Prev
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "Reports|*.prnx";
ofd.Multiselect = false;
if (ofd.ShowDialog() == DialogResult.OK)
{
PrintingSystem print = new PrintingSystem();
print.LoadDocument(ofd.FileName);
// Create an instance of the preview dialog.
PrintPreviewFormEx preview = new PrintPreviewFormEx();
// Load the report document into it.
preview.PrintingSystem = print;
// Show the preview dialog.
preview.ShowDialog();
}
}
public void ExportData()
{
using (var dialog = new SaveFileDialog())
{
dialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
dialog.FileName = string.Format("ActiveLibraries({0}).xlsx", DateTime.Now.ToString("MMddyy-hmmtt"));
dialog.Filter = "Excel files|*.xlsx";
dialog.Title = "Export Active Libraries";
if (dialog.ShowDialog() != DialogResult.OK) return;
var options = new XlsxExportOptions();
options.SheetName = Path.GetFileNameWithoutExtension(dialog.FileName);
options.TextExportMode = TextExportMode.Text;
options.ExportHyperlinks = true;
options.ShowGridLines = true;
options.ExportMode = XlsxExportMode.SingleFile;
var groupControls = xtraTabControlLibraries.TabPages.OfType<IGroupControl>().Reverse();
var parts = new Dictionary<string, string>();
using (var form = new FormProgress())
{
FormMain.Instance.ribbonControl.Enabled = false;
Enabled = false;
form.laProgress.Text = "Exporting data...";
form.TopMost = true;
form.Show();
Application.DoEvents();
var thread = new Thread(() =>
{
foreach (var groupControl in groupControls)
{
var tempFile = Path.Combine(Path.GetTempPath(), String.Format("{0}.xlsx", Guid.NewGuid()));
BeginInvoke(new Action(() =>
{
using (var printingSystem = new PrintingSystem())
{
groupControl.GetPrintLink().CreateDocument(printingSystem);
printingSystem.ExportToXlsx(tempFile, options);
}
}));
parts.Add(groupControl.GroupName, tempFile);
}
ActivityExportHelper.ExportCommonData(dialog.FileName, parts);
});
thread.Start();
while (thread.IsAlive)
{
Thread.Sleep(100);
Application.DoEvents();
}
form.Close();
Enabled = true;
FormMain.Instance.ribbonControl.Enabled = true;
}
if (File.Exists(dialog.FileName))
Process.Start(dialog.FileName);
}
}
public override void CreateDocument(PrintingSystem ps)
{
if (ps != null)
{
base.CreateDocument();
}
}
protected virtual void OnExportXls()
{
if (Printer == null) return;
var ps = new PrintingSystem();
var link = new PrintableComponentLink(ps);
link.Component = Printer;
link.CreateReportHeaderArea += printableComponentLink_CreateReportHeaderArea;
link.PaperKind = PaperKind.A4;
link.Margins.Bottom = link.Margins.Left = link.Margins.Right = link.Margins.Top = 50;
link.CreateDocument();
var fileName = string.Empty;
var save = new SaveFileDialog();
save.Filter = "Exel 2003 (*.xls)|*.xls";
if (save.ShowDialog() == DialogResult.OK)
fileName = save.FileName;
if (string.IsNullOrEmpty(fileName)) return;
link.ExportToXls(fileName);
}
private void ChangeClickBrick(object sender, EventArgs e)
{
Brick brick = sender as Brick;
if(brick.Value.Equals("Main")) {
PSTab.SelectedTabPageIndex = 0;
return;
}
int i = brick.Value.Equals(0) ? 1 : 0;
brick.Value = i;
((ImageBrick)brick).Image = imageList1.Images[i];
pc.InvalidateBrick(brick);
string tpName = "Orders[" + brick.ID + "]";
if(i == 1) {
XtraTabPage tp = new XtraTabPage();
tp.Text = tpName;
tp.Tag = brick.ID;
PSTab.TabPages.Add(tp);
PrintingSystem ps = new PrintingSystem();
ps.SetCommandVisibility(PrintingSystemCommand.ClosePreview, CommandVisibility.None);
MyPrintControl pcNew = new MyPrintControl();
pcNew.ChangeClickBrick += new EventHandler(ChangeClickBrick);
pcNew.Dock = DockStyle.Fill;
pcNew.PrintingSystem = ps;
tp.Controls.Add((System.Windows.Forms.Control)pcNew);
PSTab.SelectedTabPageIndex = FindTabPageIndex(tpName, PSTab);
//this.Focus();
} else {
PSTab.TabPages.RemoveAt(FindTabPageIndex(tpName, PSTab));
PSTab.SelectedTabPageIndex = 0;
}
}
private void nbiPrintPreviewBars_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
using(DevExpress.XtraPrinting.Preview.PrintPreviewFormEx form = new DevExpress.XtraPrinting.Preview.PrintPreviewFormEx()) {
PrintingSystem ps = new PrintingSystem();
XtraReport1 report = new XtraReport1();
form.PrintControl.PrintingSystem = ps;
report.PrintingSystem = ps;
report.CreateDocument();
form.ShowDialog();
}
}
/// <summary>
/// 数据表格打印预览
/// </summary>
/// <param name="ListGrid">数据表格</param>
/// <param name="strHead">表头显示信息</param>
public static void PrintView(DevExpress.XtraGrid.GridControl ListGrid,DevExpress.XtraGrid.Views.Grid.GridView gridView, string strHead)
{
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
//"Report file creating","Read Data, Please waiting..."
DevExpress.Utils.WaitDialogForm frmWait = new DevExpress.Utils.WaitDialogForm("正在获取数据，请稍候...", "表格报表");
frmWait.Show();
//以下以前的一种用法，现在改为可加上表头信息的印方式
//if (DevExpress.XtraPrinting.PrintHelper.IsPrintingAvailable)
// DevExpress.XtraPrinting.PrintHelper.ShowPreview(ListGrid);
//else
// //"XtraPrinting Library is not found..."
// DevExpress.XtraEditors.XtraMessageBox.Show(common.GetLanguageWord("MESSAGE", "M0028"), "", MessageBoxButtons.OK, MessageBoxIcon.Information);
//以下为采用新的打印方式
string middleColumn = strHead;
string rightColumn = string.Format("打印时间:{0:g}", DateTime.Now);
PrintableComponentLink link = new PrintableComponentLink(new PrintingSystem());
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
phf.Header.Content.Clear();
phf.Header.Font = new Font("宋体", 12, FontStyle.Bold);
phf.Header.Content.AddRange(new string[] { "打印用户:" + Common._personname, middleColumn, rightColumn });
phf.Footer.Content.AddRange(new string[] { "", "页次[页 #/#]", "" });
gridView.OptionsPrint.AutoWidth = false; //<- 2012-09-18 add
link.Component = ListGrid;
//link.CreateMarginalHeaderArea += new CreateAreaEventHandler(Link_CreateMarginalHeaderArea);
DevExpress.LookAndFeel.UserLookAndFeel lookfeel = new DevExpress.LookAndFeel.UserLookAndFeel(ListGrid);
lookfeel.ParentLookAndFeel = ListGrid.LookAndFeel;
PrintingSystem printSystem = new PrintingSystem();
PrinterSettingsUsing pst = new PrinterSettingsUsing();
pst.UseMargins = true;
pst.UsePaperKind = true;
printSystem.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
printSystem.PageSettings.PaperName = "A4";
printSystem.PageSettings.LeftMargin = 1;
printSystem.PageSettings.RightMargin = 1;
printSystem.PageSettings.Landscape = true;
printSystem.PageSettings.AssignDefaultPrinterSettings(pst);
link.PaperKind = printSystem.PageSettings.PaperKind;
link.Margins = printSystem.PageSettings.Margins;
link.Landscape = printSystem.PageSettings.Landscape;
link.CreateDocument();
link.ShowPreview(lookfeel);
Cursor.Current = currentCursor;
frmWait.Dispose();
frmWait = null;
}
public void ExportData()
{
using (var dialog = new SaveFileDialog())
{
dialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
dialog.FileName = string.Format("quickSITES & Emails({0}).xlsx", DateTime.Now.ToString("MMddyy-hmmtt"));
dialog.Filter = "Excel files|*.xlsx";
dialog.Title = "Export quickSites & Emails";
if (dialog.ShowDialog() != DialogResult.OK) return;
var options = new XlsxExportOptions();
options.SheetName = Path.GetFileNameWithoutExtension(dialog.FileName);
options.TextExportMode = TextExportMode.Text;
options.ExportHyperlinks = true;
options.ShowGridLines = true;
options.ExportMode = XlsxExportMode.SingleFile;
var parts = new Dictionary<string, string>();
using (var form = new FormProgress())
{
FormMain.Instance.ribbonControl.Enabled = false;
Enabled = false;
form.laProgress.Text = "Exporting data...";
form.TopMost = true;
form.Show();
Application.DoEvents();
var thread = new Thread(() =>
{
var tempFile = Path.Combine(Path.GetTempPath(), String.Format("{0}.xlsx", Guid.NewGuid()));
BeginInvoke(new Action(() =>
{
using (var printingSystem = new PrintingSystem())
{
var printLink = new PrintableComponentLink
{
Landscape = true,
PaperKind = PaperKind.A4,
Component = gridControlRecords
};
printLink.CreateReportHeaderArea += OnCreateReportHeaderArea;
printLink.CreateDocument(printingSystem);
printingSystem.ExportToXlsx(tempFile, options);
}
}));
parts.Add("quickSITES & Emails", tempFile);
ActivityExportHelper.ExportCommonData(dialog.FileName, parts);
});
thread.Start();
while (thread.IsAlive)
{
Thread.Sleep(100);
Application.DoEvents();
}
form.Close();
Enabled = true;
FormMain.Instance.ribbonControl.Enabled = true;
}
if (File.Exists(dialog.FileName))
Process.Start(dialog.FileName);
}
}
private void m_cmd_xuat_bao_cao_Click(object sender, EventArgs e)
{
try
{
PrintingSystem ps = new PrintingSystem();
compositeLink.PrintingSystem = ps;
//
PrintableComponentLink link1 = new PrintableComponentLink();
PrintableComponentLink link2 = new PrintableComponentLink();
link2.Component = m_grc;
link1.Component = m_chart;
//
compositeLink.Links.Add(link1);
compositeLink.Links.Add(link2);
compositeLink.PaperKind = System.Drawing.Printing.PaperKind.A3Rotated;
compositeLink.BreakSpace = 40;
//
compositeLink.Landscape = false;
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "xls files (*.xls)|*.xls|All files (*.*)|*.*";
saveFileDialog1.RestoreDirectory = true;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
compositeLink.ExportToXls(saveFileDialog1.FileName);
DevExpress.XtraEditors.XtraMessageBox.Show("Lưu báo cáo thành công!");
}
compositeLink.ShowPreview();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void InitPrinting(ref PrintingSystem pd)
{
pd.PageSettings.TopMargin = 100;
pd.PageMargins.Top = 100;
pd.PageSettings.BottomMargin = 100;
pd.PageMargins.Bottom = 100;
_traceLog = new System.Text.StringBuilder();
_indent = 0;
// Calculate Form position for printing
switch (Orientation)
{
case OrientationENum.Automatic:
// I changed here the pd.DefaultPageSettings.Bounds.Width with the pd.PageSettings.Bounds.Width
//Also the pd.DefaultPageSettings.Margins.Right with the pd.PageSettings.Margins.Right
//And the pd.DefaultPageSettings.Margins.Left with the pd.PageSettings.Margins.Left
if (_f.Size.Width > (pd.PageSettings.Bounds.Width - pd.PageSettings.Margins.Right - pd.PageSettings.Margins.Left))
pd.PageSettings.Landscape = true;
break;
case OrientationENum.Lanscape:
pd.PageSettings.Landscape = true;
break;
case OrientationENum.Portrait:
pd.PageSettings.Landscape = false;
break;
}
// Set page area
Single pageTop = pd.PageSettings.Margins.Top;
Single pageBottom = pd.PageSettings.Bounds.Height - pd.PageSettings.Margins.Bottom;
Single pageLeft = pd.PageSettings.Margins.Left;
Single pageRight = pd.PageSettings.Bounds.Width - pd.PageSettings.Margins.Right;
if (TopMargin != 0)
pageTop = TopMargin;
if (BottomMargin != 0)
pageTop = BottomMargin;
//ps.PageMargins. = new Margins(80, 80, 100, 60);
ps.PageSettings.RightMargin = 80;
ps.PageSettings.LeftMargin = 80;
ps.PageSettings.TopMargin = 100;
ps.PageSettings.BottomMargin = 100;
//ps.PageMargins.Bottom = 60;
//ps.PageMargins.Left = 80;
//ps.PageMargins.Right = 80;
//// Calculate left position of print
switch (this.HAlignment)
{
case HorizontalAlignment.Left:
_xform = pageLeft;
break;
case HorizontalAlignment.Center:
_xform = (pd.PageSettings.Bounds.Width - _f.Size.Width) / 2;
break;
case HorizontalAlignment.Right:
_xform = pageRight - _f.Size.Width;
break;
}
_MultiPage = new MultiPageManagement(pageTop, pageBottom, pageLeft, pageRight, _f.Font, PageNumbering, PageNumberingFormat);
}
public print(PrintingSystem ps)
{
CreateDocument(ps);
}
private void ExportToEx(String filename, string ext)
{
StartExport();
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
if (_exportView == null)
{
EndExport();
XtraMessageBox.Show("Đối tượng kết xuất chưa xác định");
return;
}
//DevExpress.XtraPrinting.IPrintingSystem ps = DevExpress.XtraPrinting.PrintHelper.GetCurrentPS();
DevExpress.XtraPrinting.IPrintingSystem ps = new PrintingSystem();
ps.AfterChange += new DevExpress.XtraPrinting.ChangeEventHandler(Export_ProgressEx);
if (ext == "rtf") _exportView.ExportToRtf(filename);
if (ext == "pdf") _exportView.ExportToPdf(filename);
if (ext == "mht") _exportView.ExportToMht(filename);
if (ext == "htm") _exportView.ExportToHtml(filename, new HtmlExportOptions("utf-8"));
if (ext == "txt") _exportView.ExportToText(filename, new TextExportOptions(" ", Encoding.Unicode));
if (ext == "xls")
{
_exportView.ExportToXls(filename, new XlsExportOptions(TextExportMode.Value, true));
}
#pragma warning disable 618,612
if (ext == "xlsOld")
{
_exportView.ExportToExcelOld(filename);
}
#pragma warning restore 618,612
if (ext == "xlsx")
{
_exportView.ExportToXlsx(filename, new XlsxExportOptions(TextExportMode.Value, true));
}
ps.AfterChange -= new DevExpress.XtraPrinting.ChangeEventHandler(Export_ProgressEx);
Cursor.Current = currentCursor;
EndExport();
}
private void nbiPrintPreviewRibbon_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
using(DevExpress.XtraPrinting.Preview.PrintPreviewRibbonFormEx form = new DevExpress.XtraPrinting.Preview.PrintPreviewRibbonFormEx()) {
PrintingSystem ps = new PrintingSystem();
form.PrintControl.PrintingSystem = ps;
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = gridControl1;
link.CreateDocument();
form.ShowDialog();
}
}
private static void DoPrint(List<t_trade> trds)
{
var ps = new PrintingSystem();
ps.Document.Pages.Clear();
ps.ShowMarginsWarning = false;
ps.ClearContent();
var whr = trds.Select(k => k.Guid.ToString()).Aggregate((s1, s2) => s1 + "','" + s2);
using (var db = new Database()) {
var vtrds = db.Fetch<t_trade>(string.Format(" where guid in ('{0}')", whr));
var orders = db.Fetch<t_order>(string.Format(" where tradeguid in ('{0}')", whr));
vtrds.ForEach(trd => {
var prtinfo = new PrintInfo();
prtinfo.Trade = trd;
prtinfo.Orders = orders.Where(odr => odr.TradeGuid == trd.Guid).ToList();
var rptfh = new rptFH();
rptfh.BindPrintData(prtinfo);
rptfh.CreateDocument();
ps.Document.Pages.AddRange(rptfh.Pages);
});
}
ps.Print();
}
private void btnPrint_Click(object sender, EventArgs e)
{
var ps = new PrintingSystem();
var pcl = new PrintableComponentLink(ps);
pcl.CreateReportHeaderArea += PclCreateReportHeaderArea;
pcl.Component = gridAdjustments;
pcl.Landscape = true;
pcl.CreateDocument();
ps.PreviewFormEx.ShowDialog();
}
