private void buttonPrint_Click(object sender, EventArgs e)
{
bool resultValidateForm = validateForm();
if (!resultValidateForm)
{
return;
}
fRMMain.showWaitingForm("กำลังทำการเปิดหน้าปริ้น");
ReportPrintTool pt = new ReportPrintTool(new MiniReport());
// Get the Print Tool's printing system.
PrintingSystemBase ps = pt.PrintingSystem;
fRMMain.showWaitingForm("กำลังทำการเปิดหน้าปริ้น");
// Show a report's Print Preview.
pt.ShowPreviewDialog();
// Zoom the print preview, so that it fits the entire page.
ps.ExecCommand(PrintingSystemCommand.ViewWholePage);
// Invoke the Hand tool.
ps.ExecCommand(PrintingSystemCommand.HandTool, new object[] { true });
// Hide the Hand tool.
ps.ExecCommand(PrintingSystemCommand.HandTool, new object[] { false });
}
protected void Button1_Click(object sender, EventArgs e)
{
PrintingSystemBase ps = new PrintingSystemBase();
ps.ExportOptions.Pdf.DocumentOptions.Author = "Test";
PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(ps);
link1.Component = ASPxPivotGridExporter1;
PrintableComponentLinkBase link2 = new PrintableComponentLinkBase(ps);
WebChartControl1.DataBind();
link2.Component = ((IChartContainer)WebChartControl1).Chart;
CompositeLinkBase compositeLink = new CompositeLinkBase(ps);
compositeLink.Links.AddRange(new object[] { link1, link2 });
using (MemoryStream stream = new MemoryStream()) {
compositeLink.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 void ConfigurePrintingSystem(PrintingSystemBase printingSystem)
{
SetHtmlOptions(printingSystem.ExportOptions.Html);
SetPdfOptions(printingSystem.ExportOptions.Pdf);
SetXlsOptions(printingSystem.ExportOptions.Xls);
SetGeneralOptions(printingSystem.ExportOptions.PrintPreview);
}
public ActionResult ExportTo()
{
var ps = new PrintingSystemBase();
var headerImageLink = new LinkBase(ps);
headerImageLink.CreateDetailArea += headerImageLink_CreateDetailArea;
var link1 = new PrintableComponentLinkBase(ps);
GridViewSettings categoriesGridSettings = new GridViewSettings();
categoriesGridSettings.Name = "gvCategories";
categoriesGridSettings.KeyFieldName = "CategoryID";
categoriesGridSettings.Columns.Add("CategoryID");
categoriesGridSettings.Columns.Add("CategoryName");
categoriesGridSettings.Columns.Add("Description");
link1.Component = GridViewExtension.CreatePrintableObject(categoriesGridSettings, MyModel.GetCategories());
var compositeLink = new CompositeLinkBase(ps);
compositeLink.Links.AddRange(new object[] { headerImageLink, link1 });
compositeLink.CreateDocument();
FileStreamResult result = CreateExcelExportResult(compositeLink);
ps.Dispose();
return(result);
}
protected void ExportButton_Click(object sender, EventArgs e)
{
PrintingSystemBase ps = new PrintingSystemBase();
PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(ps);
link1.Component = GridExporter;
PrintableComponentLinkBase link2 = new PrintableComponentLinkBase(ps);
Chart.DataBind();
link2.Component = ((IChartContainer)Chart).Chart;
CompositeLinkBase compositeLink = new CompositeLinkBase(ps);
compositeLink.Links.AddRange(new object[] { link1, link2 });
compositeLink.CreateDocument();
using (MemoryStream stream = new MemoryStream()) {
compositeLink.PrintingSystemBase.ExportToXls(stream);
Response.Clear();
Response.Buffer = false;
Response.AppendHeader("Content-Type", "application/xls");
Response.AppendHeader("Content-Transfer-Encoding", "binary");
Response.AppendHeader("Content-Disposition", "attachment; filename=test.xls");
Response.BinaryWrite(stream.ToArray());
Response.End();
}
ps.Dispose();
}
private void sbExport_Click(object sender, EventArgs e)
{
var sfd = new SaveFileDialog();
sfd.Filter = "Excel File (*.xlsx)|*.xlsx";
if (sfd.ShowDialog(this) == DialogResult.OK)
{
var printingSystem = new PrintingSystemBase();
var compositeLink = new CompositeLinkBase();
compositeLink.PrintingSystemBase = printingSystem;
var link = new PrintableComponentLinkBase();
link.Component = gcRawData;
compositeLink.Links.Add(link);
link = new PrintableComponentLinkBase();
link.Component = gcSummary;
compositeLink.Links.Add(link);
var options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.SingleFilePageByPage;
compositeLink.CreatePageForEachLink();
compositeLink.ExportToXlsx(sfd.FileName, options);
System.Diagnostics.Process.Start(sfd.FileName);
}
}
private void ChangeReportSettings(object sender)
{
PrintingSystemBase ps = sender as PrintingSystemBase;
bool isLocationChanged = false;
int newPageWidth =
ps.PageBounds.Width - ps.PageMargins.Left - ps.PageMargins.Right;
int currentPageWidth =
this.PageWidth - this.Margins.Left - this.Margins.Right;
int shift = currentPageWidth - newPageWidth;
foreach (Band _band in base.Bands)
{
foreach (XRControl _control in _band.Controls)
{
isLocationChanged = true;
_control.Location =
new Point((_control.Location.X - shift), _control.Location.Y);
}
}
if (isLocationChanged == true)
{
Margins.Top = ps.PageMargins.Top;
Margins.Bottom = ps.PageMargins.Bottom;
Margins.Left = ps.PageMargins.Left;
Margins.Right = ps.PageMargins.Right;
PaperKind = ps.PageSettings.PaperKind;
PaperName = ps.PageSettings.PaperName;
Landscape = ps.PageSettings.Landscape;
CreateDocument();
}
}
private static void PrintViaLink(RichEditDocumentServer srv)
{
if (!srv.IsPrintingAvailable)
{
return;
}
using (PrintingSystemBase ps = new PrintingSystemBase())
using (PrintableComponentLinkBase link = new PrintableComponentLinkBase(ps)) {
link.Component = srv;
// Disable warnings.
ps.ShowMarginsWarning = false;
ps.ShowPrintStatusDialog = false;
// Find a printer containing 'Canon' in its name.
string printerName = String.Empty;
for (int i = 0; i < PrinterSettings.InstalledPrinters.Count; i++)
{
string pName = PrinterSettings.InstalledPrinters[i];
if (pName.Contains("PDF"))
{
printerName = pName;
break;
}
}
//Run document creaion
link.CreateDocument();
// Print to the specified printer.
PrintToolBase tool = new PrintToolBase(ps);
tool.Print(printerName);
}
}
/// <summary>
/// Exports the grid to excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
SaveFileDialog saveDlg = new SaveFileDialog {
Filter = "Microsoft Excel| *.xls|PDF (.pdf)|*.pdf"
};
if (DialogResult.OK == saveDlg.ShowDialog())
{
PrintingSystemBase ps = new PrintingSystemBase();
DevExpress.XtraPrintingLinks.PrintableComponentLinkBase link = new DevExpress.XtraPrintingLinks.PrintableComponentLinkBase(ps);
link.CreateMarginalHeaderArea += new CreateAreaEventHandler(Link_CreateMarginalHeaderAreaVital);
link.Component = gridItemsChoice;
link.Landscape = true;
link.CreateDocument();
if (saveDlg.FilterIndex == 1)
{
link.PrintingSystemBase.ExportToXls(saveDlg.FileName);
}
else if (saveDlg.FilterIndex == 2)
{
link.PrintingSystemBase.ExportToPdf(saveDlg.FileName);
}
}
}
/// <summary>
/// 프린트 미리보기 화면 세팅
/// </summary>
/// <param name="pb"></param>
private void PrintInit(PrintingSystemBase pb)
{
try
{
pb.SetCommandVisibility(PrintingSystemCommand.Open, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.Save, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.Thumbnails, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.Watermark, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.Parameters, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.Background, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.FillBackground, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.ExportCsv, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.ExportGraphic, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.ExportMht, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.ExportRtf, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.ExportXps, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.ExportTxt, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.SendFile, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.MultiplePages, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.Customize, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.EditPageHF, CommandVisibility.None);
pb.SetCommandVisibility(PrintingSystemCommand.Find, CommandVisibility.None);
}
catch { }
}
public Printing(object tb, XtraReport _rptTmp)
{
db = tb;
rptTmp = _rptTmp;
PrintingSystemBase ps = rptTmp.PrintingSystem;
ps.StartPrint += Ps_StartPrint;
}
/// <summary>
/// 프린트 미리보기 화면 세팅
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_PrintInitialize(object sender, DevExpress.XtraGrid.Views.Base.PrintInitializeEventArgs e)
{
try
{
PrintingSystemBase pb = e.PrintingSystem as PrintingSystemBase;
this.PrintInit(pb);
}
catch { }
}
private void gridView1_PrintInitialize(object sender, DevExpress.XtraGrid.Views.Base.PrintInitializeEventArgs e)
{
PrintingSystemBase pb = e.PrintingSystem as PrintingSystemBase;
pb.PageSettings.RightMargin = 5;
pb.PageSettings.TopMargin = 5;
pb.PageSettings.LeftMargin = 5;
pb.PageSettings.BottomMargin = 5;
pb.PageSettings.Landscape = true;
}
// Override the XRControl.PutStateToBrick method.
protected override void PutStateToBrick(VisualBrick brick, PrintingSystemBase ps)
{
// Call the PutStateToBrick method of the base class.
base.PutStateToBrick(brick, ps);
// Get the Panel brick which represents the current progress receiveBar control.
PanelBrick panel = (PanelBrick)brick;
panel.BackColor = Color.Transparent;
int width = Convert.ToInt32(Math.Round(panel.Rect.Width));
int height = Convert.ToInt32(Math.Round(panel.Rect.Height));
Bitmap bitmap = new Bitmap(width, height);
bitmap.SetResolution(300, 300);
GdiGraphics gBmp = new GdiGraphics(Graphics.FromImage(bitmap), ps);
//int colorWidth = Convert.ToInt32(Math.Round(width * (Position / MaxValue)));
//int colorWid = Convert.ToInt32(Math.Round((MaxValue-width) * (Position / MaxValue)));
gBmp.FillEllipse(new SolidBrush(panel.Style.ForeColor), new Rectangle(0, 0, width, height));
//gBmp.FillRectangle(new SolidBrush(panel.Style.ForeColor), new Rectangle(0, 0, colorWidth, height));
// gBmp.FillRectangle(new SolidBrush(panel.Style.BackColor), new Rectangle(0,colorWidth, colorWid, height));
//String drawString = Position.ToString();
////
//drawString += " %";
//Font drawFont = new Font("Frutiger LT Arabic 55", 9);
//SolidBrush drawBrush = new SolidBrush(Color.Black);
//StringFormat drawFormat = new StringFormat();
//drawFormat.Alignment = StringAlignment.Center;
//drawFormat.LineAlignment = StringAlignment.Center;
//gBmp.DrawString(drawString, drawFont, drawBrush, new Rectangle(0, 0, width, height), drawFormat);
gBmp.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.AntiAlias;
ImageBrick image = new ImageBrick();
image.Rect = new RectangleF(0, 0, panel.Rect.Width, panel.Rect.Height);
image.SizeMode = ImageSizeMode.Squeeze;
image.Image = bitmap;
image.BackColor = Color.Transparent;
image.Sides = BorderSide.None;
panel.Bricks.Add(image);
panel.BackColor = Color.Transparent;
}
private void toExcel()
{
XlsxExportOptions opt = new XlsxExportOptions();
opt.ExportMode = XlsxExportMode.SingleFilePageByPage;
string FileName = "C:\\CORRECT\\XLS\\" + Reportenombre + ".xlsx";
opt.SheetName = "NEW";
//gridView1.ExportToXlsx(FileName);
gridView1.OptionsPrint.ExpandAllDetails = true;
gridView1.OptionsPrint.PrintDetails = true;
gridView1.OptionsPrint.ExpandAllGroups = true;
//gridView2.OptionsPrint.ExpandAllDetails = true;
//gridView2.OptionsPrint.PrintDetails = true;
gridView1.ZoomView();
//CompositeLink conp = new CompositeLink();
var printingSystem = new PrintingSystemBase();
var compositeLink = new CompositeLinkBase();
compositeLink.PrintingSystemBase = printingSystem;
var link1 = new PrintableComponentLinkBase();
link1.Component = gridControl1;
//var link2 = new PrintableComponentLinkBase();
//link2.Component = grid2;
compositeLink.Links.Add(link1);
// compositeLink.Links.Add(link2);
var options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.SingleFilePageByPage;
compositeLink.CreatePageForEachLink();
compositeLink.ExportToXlsx(FileName, options);
//conp.ExportToXlsx(FileName, opt);
//gridView1.ExportToXlsx(FileName,opt);
//gridControl1.DefaultView
Microsoft.Office.Interop.Excel.Application excell;
Microsoft.Office.Interop.Excel.Workbook workbook;
excell = new Excel.Application();
excell.Visible = true;
workbook = excell.Workbooks.Open(FileName);
}
private void buttonPrint_Click(object sender, EventArgs e)
{
bool resultValidateForm = validateForm();
if (!resultValidateForm)
{
return;
}
MiniReport mini = new MiniReport();
mini.dateTimeThai.Text = "";
mini.inDocumentNumber.Text = inDocumentNumber.Text;
mini.customerName.Text = customerName.Text;
mini.address.Text = address.Text;
mini.phone.Text = phone.Text;
mini.productName.Text = productName.Text;
mini.company.Text = companyName.Text;
mini.productType.Text = productType.Text;
mini.dtProductEndDate.Text = dtProductEndDate.Text;
if (radioButtonInWarranty.Checked)
{
mini.warranty.Text = "ในประกัน";
mini.chargebacks.Text = "0";
}
else
{
mini.warranty.Text = "นอกประกัน";
mini.chargebacks.Text = textEditChargebacks.Text;
}
mini.symptom.Text = symptom.Text.Trim() == "" ? "-" : symptom.Text.Trim();
mini.equipment.Text = equipment.Text.Trim() == "" ? "-" : equipment.Text.Trim();
mini.detail2.Text = detail.Text.Trim() == "" ? "-" : detail.Text.Trim();
fRMMain.showWaitingForm("กำลังทำการเปิดหน้าปริ้น");
ReportPrintTool pt = new ReportPrintTool(mini);
// Get the Print Tool's printing system.
PrintingSystemBase ps = pt.PrintingSystem;
fRMMain.closeWaitingForm();
// Show a report's Print Preview.
pt.ShowPreviewDialog();
// Zoom the print preview, so that it fits the entire page.
ps.ExecCommand(PrintingSystemCommand.ViewWholePage);
// Invoke the Hand tool.
ps.ExecCommand(PrintingSystemCommand.HandTool, new object[] { true });
// Hide the Hand tool.
ps.ExecCommand(PrintingSystemCommand.HandTool, new object[] { false });
}
protected override void PutStateToBrick(VisualBrick brick, PrintingSystemBase ps)
{
base.PutStateToBrick(brick, ps);
PanelBrick panel = (PanelBrick)brick;
VisualBrick progressBar = new VisualBrick(this);
progressBar.Sides = BorderSide.None;
progressBar.BackColor = panel.Style.ForeColor;
progressBar.Rect = new RectangleF(0, 0, panel.Rect.Width * (Position / MaxValue),
panel.Rect.Height);
panel.Bricks.Add(progressBar);
}
private void _gdMAIN_VIEW_PrintInitialize(object sender, DevExpress.XtraGrid.Views.Base.PrintInitializeEventArgs e)
{
PrintingSystemBase pb = e.PrintingSystem as PrintingSystemBase;
//가로 회전
pb.PageSettings.Landscape = true;
//여백
pb.PageMargins.Left = 10;
pb.PageMargins.Right = 10;
pb.PageMargins.Top = 10;
pb.PageMargins.Bottom = 10;
}
protected override void PutStateToBrick(VisualBrick brick, PrintingSystemBase ps)
{
base.PutStateToBrick(brick, ps);
float itemHeight = GetItemHeight(brick.Rect);
RectangleF r = GetGraphicsRect(brick.Rect, itemHeight);
double scale = GetScale();
for (int i = 0; i <= controlData.GetUpperBound(0); i++)
{
DrawPopulationInfo((PanelBrick)brick, r, (string)controlData[i, 0], (double)controlData[i, 1], scale);
r.Offset(0, itemHeight);
}
}
protected override void PutStateToBrick(VisualBrick brick, PrintingSystemBase ps)
{
base.PutStateToBrick(brick, ps);
PanelBrick panelBrick = (PanelBrick)brick;
Graphics gr = Graphics.FromHwnd(new IntPtr(0));
gr.PageUnit = GraphicsUnit.Document;
RectangleF rect = RectangleF.Empty;
try {
if (displayTitle && !string.IsNullOrEmpty(TitleText) && titleFont != null)
{
rect.Size = gr.MeasureString(TitleText, titleFont, (int)panelBrick.Rect.Width);
TextBrick textBrick = CreateTextBrick(panelBrick);
textBrick.Rect = rect;
textBrick.ForeColor = TitleColor;
textBrick.Font = TitleFont;
textBrick.Text = TitleText;
}
if (!string.IsNullOrEmpty(this.Text))
{
TextBrick textBrick2 = CreateTextBrick(panelBrick);
textBrick2.ForeColor = this.ForeColor;
textBrick2.Font = this.Font;
textBrick2.Text = this.Text;
if (this.contextTextAlignment == ContextTextAlignmentEnum.NextToTitleText)
{
float width = Math.Max(0, panelBrick.Rect.Width - rect.Width);
SizeF size = gr.MeasureString(this.Text, this.Font, (int)width);
textBrick2.Rect = new RectangleF(rect.Right + 10f, rect.Top, width, size.Height);
}
else
{
StringFormat sf = new StringFormat();
sf.LineAlignment = GraphicsConvertHelper.ToVertStringAlignment(this.TextAlignment);
sf.Alignment = GraphicsConvertHelper.ToHorzStringAlignment(this.TextAlignment);
SizeF size = gr.MeasureString(this.Text, this.Font, (int)panelBrick.Rect.Width, sf);
textBrick2.Rect = new RectangleF(rect.Left, rect.Bottom + 10f, panelBrick.Rect.Width, size.Height);
textBrick2.StringFormat = new BrickStringFormat(sf);
}
}
}
catch {
}
finally {
gr.Dispose();
}
}
public override void PutStateToBrick(VisualBrick brick, PrintingSystemBase ps)
{
if (brick is PanelBrick)
{
float actualHeight = 0f;
brick.PrintingSystem = ps;
CreateHeaders((PanelBrick)brick, ref actualHeight);
CreateDetails((PanelBrick)brick, ref actualHeight);
CorrectBrickBounds(brick, actualHeight);
}
}
public static void GetShpenzimet(DateTime start, DateTime end)
{
string path = System.IO.Path.GetFullPath(@"Reporting\Raport Shpenzimesh.txt");
XtraReport report = new XtraReport();
report = XtraReport.FromFile(path, true);
ReportPrintTool pt = new ReportPrintTool(report);
PrintingSystemBase ps = pt.PrintingSystem;
report.PrintingSystem.SetCommandVisibility(DevExpress.XtraPrinting.PrintingSystemCommand.Parameters, DevExpress.XtraPrinting.CommandVisibility.None);
report.DataSource = GetAll.GetShpenzimet(start, end);
report.DataMember = "CustomSqlQuery";
report.DisplayName = "Invoice";
report.ShowPreview();
}
public static void GetFaturaByNo(long FaturaNo)
{
string path = System.IO.Path.GetFullPath(@"Reporting\GjeneroFaturen.txt");
XtraReport report = new XtraReport();
report = XtraReport.FromFile(path, true);
ReportPrintTool pt = new ReportPrintTool(report);
PrintingSystemBase ps = pt.PrintingSystem;
report.PrintingSystem.SetCommandVisibility(DevExpress.XtraPrinting.PrintingSystemCommand.Parameters, DevExpress.XtraPrinting.CommandVisibility.None);
report.DataSource = GetAll.GetFaturaByNr(FaturaNo);
report.DataMember = "CustomSqlQuery";
report.DisplayName = "Invoice";
report.ShowPreview();
}
public static void GetSales(DateTime start, DateTime end, Klienti klienti)
{
string path = System.IO.Path.GetFullPath(@"Reporting\Shitjet.txt");
XtraReport report = new XtraReport();
report = XtraReport.FromFile(path, true);
report.FindControl("lbInvoice", true).Text = "Raport Shitjesh " + klienti.Emri;
ReportPrintTool pt = new ReportPrintTool(report);
PrintingSystemBase ps = pt.PrintingSystem;
report.PrintingSystem.SetCommandVisibility(DevExpress.XtraPrinting.PrintingSystemCommand.Parameters, DevExpress.XtraPrinting.CommandVisibility.None);
report.DataSource = GetAll.GetSales(start, end, klienti.ID);
report.DataMember = "CustomSqlQuery";
report.DisplayName = "Invoice";
report.ShowPreview();
}
protected override void PutStateToBrick(VisualBrick brick, PrintingSystemBase ps)
{
if (this.LineStyle != System.Drawing.Drawing2D.DashStyle.Custom)
{
base.PutStateToBrick(brick, ps);
}
else
{
PanelBrick panel = (PanelBrick)brick;
panel.BackColor = Color.Transparent;
panel.Sides = BorderSide.None;
int i;
if (this.LineDirection == LineDirection.Horizontal)
{
for (i = 0; i < Convert.ToInt32(panel.Rect.Width / (this.Dash + this.Space)); i++)
{
LineBrick dashBrick = new LineBrick();
dashBrick.Sides = BorderSide.None;
dashBrick.BackColor = panel.Style.ForeColor;
dashBrick.Rect = new RectangleF(i * (this.Dash + this.Space), panel.Rect.Height / 2 - this.LineWidth / 2, this.dash, this.LineWidth);
panel.Bricks.Add(dashBrick);
}
LineBrick endBrick = new LineBrick();
endBrick.Sides = BorderSide.None;
endBrick.BackColor = panel.Style.ForeColor;
endBrick.Rect = new RectangleF(i * (this.Dash + this.Space), panel.Rect.Height / 2 - this.LineWidth / 2, panel.Rect.Width - i * (this.Dash + this.Space), this.LineWidth);
panel.Bricks.Add(endBrick);
}
else if (this.LineDirection == LineDirection.Vertical)
{
for (i = 0; i < Convert.ToInt32(panel.Rect.Height / (this.Dash + this.Space)); i++)
{
LineBrick dashBrick = new LineBrick();
dashBrick.Sides = BorderSide.None;
dashBrick.BackColor = panel.Style.ForeColor;
dashBrick.Rect = new RectangleF(panel.Rect.Width / 2 - this.LineWidth / 2, i * (this.Dash + this.Space), this.LineWidth, this.Dash);
panel.Bricks.Add(dashBrick);
}
LineBrick endBrick = new LineBrick();
endBrick.Sides = BorderSide.None;
endBrick.BackColor = panel.Style.ForeColor;
endBrick.Rect = new RectangleF(panel.Rect.Width / 2 - this.LineWidth / 2, i * (this.Dash + this.Space), this.LineWidth, panel.Rect.Height - i * (this.Dash + this.Space));
panel.Bricks.Add(endBrick);
}
}
}
void ExporToStream(string html, Stream stream)
{
using (RichEditDocumentServer server = new RichEditDocumentServer()) {
server.HtmlText = html;
string text = "<b>SOME SAMPLE TEXT</b>";
AddHeaderToDocument(server.Document, text);
AddFooterToDocument(server.Document, text);
using (PrintingSystemBase ps = new PrintingSystemBase()) {
using (PrintableComponentLinkBase pcl = new PrintableComponentLinkBase(ps)) {
pcl.Component = server;
pcl.CreateDocument();
ps.ExportToPdf(stream);
}
}
}
}
private void button2_Click(object sender, EventArgs e)
{
// Create a PrintingSystem instance.
PrintingSystemBase ps = new PrintingSystemBase();
// Load the document from a stream.
ps.LoadDocument(stream);
// Create an instance of the preview dialog.
PrintPreviewFormEx preview = new PrintPreviewFormEx();
// Load the report document into it.
preview.PrintingSystem = ps;
// Show the preview dialog.
preview.ShowDialog();
}
public void ExcelDnData()
{
if (gridView1.RowCount == 0)
{
MessageBox.Show("저장할 데이터가 없습니다. 조회 후 다운로드 가능합니다.");
return;
}
else
{
string FileName = this.Text + "(" + DateTime.Now.ToString("yyyyMMdd") + ").xlsx";
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.Filter = "Excel파일(*.xlsx)|*.xlsx";
saveFile.FileName = FileName;
saveFile.RestoreDirectory = true;
if (saveFile.ShowDialog() == DialogResult.OK)
{
PrintingSystemBase ps = new PrintingSystemBase(); // 프린트 형식에 각각 컨트롤을 링크로 만들어서 같은 엑셀 파일에 뿌리기
CompositeLinkBase cl = new CompositeLinkBase();
cl.PrintingSystemBase = ps;
PrintableComponentLinkBase pcl1 = new PrintableComponentLinkBase(); // 첫번째 그래프 들어갈 링크
pcl1.Component = chartControl_Pie;
PrintableComponentLinkBase pcl2 = new PrintableComponentLinkBase(); // 두번째 그래프 들어갈 링크
pcl2.Component = chartControl_Bar;
PrintableComponentLinkBase pcl3 = new PrintableComponentLinkBase(); // 세번째 그리드 들어갈 링크
pcl3.Component = gridControl1;
XlsxExportOptions options = new XlsxExportOptions();
options.ExportMode = XlsxExportMode.DifferentFiles;
cl.Links.Add(pcl1);
cl.Links.Add(pcl2);
cl.Links.Add(pcl3);
cl.CreateDocument(); // 각각의 링크를 합쳐서 한개의 문서로 만들어줌
cl.ExportToXlsx(saveFile.FileName, new XlsxExportOptionsEx {
ExportType = ExportType.WYSIWYG
}); // 데이터 있는 만큼만 그리드 그림
//gridView1.ExportToXlsx(saveFile.FileName, new XlsxExportOptionsEx { ExportType = ExportType.WYSIWYG });
}
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
ReportPrintTool pt = new ReportPrintTool(new MiniReport());
// Get the Print Tool's printing system.
PrintingSystemBase ps = pt.PrintingSystem;
// Show a report's Print Preview.
pt.ShowPreviewDialog();
// Zoom the print preview, so that it fits the entire page.
ps.ExecCommand(PrintingSystemCommand.ViewWholePage);
// Invoke the Hand tool.
ps.ExecCommand(PrintingSystemCommand.HandTool, new object[] { true });
// Hide the Hand tool.
ps.ExecCommand(PrintingSystemCommand.HandTool, new object[] { false });
}
private void ConfigureExport(ASPxGridView grid)
{
PrintingSystemBase ps = new PrintingSystemBase();
ps.ExportOptions.Xlsx.SheetName = "Tipos de Documentos";
ps.XlSheetCreated += ps_XlSheetCreated;
PrintableComponentLinkBase link1 = new PrintableComponentLinkBase(ps);
link1.PaperName = "DatosGenerales";
link1.Component = Exporter;
CompositeLinkBase compositeLink = new CompositeLinkBase(ps);
compositeLink.Links.AddRange(new object[] { link1 });
compositeLink.CreatePageForEachLink();
ps.Dispose();
grid.Settings.ShowColumnHeaders = true;
}
