protected void Page_Load(object sender, EventArgs e)
{
try
{
using (MemoryStream ms = new MemoryStream())
{
PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem());
ASPxGridViewExporter export = (ASPxGridViewExporter)Session["exporter"];
export.Styles.Header.Wrap = DevExpress.Utils.DefaultBoolean.True;
export.MaxColumnWidth = 180;
pcl.Component = export;
pcl.Margins.Left = pcl.Margins.Right = 10;
pcl.Landscape = true;
pcl.CreateDocument(false);
pcl.PrintingSystem.Document.AutoFitToPagesWidth = 0;
pcl.ExportToPdf(ms);
WriteResponse(this.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Inline.ToString());
}
}
catch (Exception ex)
{
cm.log.Error("Kontrolka : generowanie pdf :" + ex.Message);
}
}
protected void ASPxMenu1_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e)
{
if (e.Item.Name == "ExportXLSItem")
{
ServerGridViewExporter.ExportXlsToResponse("DailyMemoryUsed.xls");
}
else if (e.Item.Name == "ExportXLSXItem")
{
ServerGridViewExporter.ExportXlsxToResponse("DailyMemoryUsed.xlsx");
}
else if (e.Item.Name == "ExportPDFItem")
{
//ServerGridViewExporter.Landscape = true;
using (MemoryStream ms = new MemoryStream())
{
PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem());
pcl.Component = ServerGridViewExporter;
pcl.Margins.Left = pcl.Margins.Right = 50;
pcl.Landscape = true;
pcl.CreateDocument(false);
pcl.PrintingSystem.Document.AutoFitToPagesWidth = 1;
pcl.ExportToPdf(ms);
WriteResponse(this.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Attachment.ToString());
//ServerGridViewExporter.WritePdfToResponse();
}
}
}
private void btOnizleEpostaGonder_Click(object sender, EventArgs e)
{
gridView5.ViewCaption = "Gün Sonu " + ilktarih.Text + " - " + sontarih.Text;
gridView5.OptionsView.ShowViewCaption = true;
PrintableComponentLink printableLink = new PrintableComponentLink(new PrintingSystem());
printableLink.Component = gcGunSonuOzet;
printableLink.Landscape = true;
printableLink.PaperKind = System.Drawing.Printing.PaperKind.A5Rotated;
printableLink.CreateDocument(Printing);
string dosyaadi = DB.exeDizini + "\\gunsonu.pdf";
printableLink.ExportToPdf(dosyaadi);
//ShowRibbonPreviewDialog(printableLink);
//System.Diagnostics.Process process = new System.Diagnostics.Process();
//process.StartInfo.FileName = filePath;
//process.Start();
DB.epostagonder(lUEKullanicilar.EditValue.ToString(), "Gün Sonu Raporu", dosyaadi, "Gün Sonu Raporu");
formislemleri.Mesajform("E-Posta Gönderildi.", "S", 200);
printableLink.Dispose();
gridView5.OptionsView.ShowViewCaption = false;
}
protected void _print(object sender, EventArgs e)
{
using (MemoryStream ms = new MemoryStream())
{
PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem());
//listaBieglych.Columns[0].Visible = false;
ASPxGridViewExporter1.FileName = "Wykaz biegłych";
pcl.Component = ASPxGridViewExporter1;
pcl.Margins.Left = pcl.Margins.Right = 50;
pcl.Landscape = true;
pcl.CreateDocument(false);
pcl.PrintingSystem.Document.AutoFitToPagesWidth = 1;
pcl.ExportToPdf(ms);
WriteResponse(this.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Inline.ToString());
}
// ASPxGridViewExporter1..GridView = ASPxGridView2;
/*PxGridViewExporter1.PrintSelectCheckBox = true;
* ASPxGridViewExporter1.Landscape = true;
*
*
* ASPxGridViewExporter1.Landscape = true;
*
* ASPxGridViewExporter1.WritePdfToResponse();
*/
//listaBieglych.Columns["Column"].Visible = true;
}
protected void EventSettings_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e)
{
if (e.Item.Name == "ExportXLSItem")
{
if (startDate.Value != "")
{
ServerGridViewExporter.FileName = "EventsHistory" + "_" + startDate.Value;
ServerGridViewExporter.WriteXlsToResponse();
}
else
{
ServerGridViewExporter.FileName = "EventsHistory" + "_" + DateTime.Now.ToString();
ServerGridViewExporter.WriteXlsToResponse();
}
}
else if (e.Item.Name == "ExportXLSXItem")
{
if (startDate.Value != "")
{
ServerGridViewExporter.FileName = "EventsHistory" + "_" + startDate.Value;
ServerGridViewExporter.WriteXlsxToResponse();
}
else
{
ServerGridViewExporter.FileName = "EventsHistory" + "_" + DateTime.Now.ToString();
ServerGridViewExporter.WriteXlsxToResponse();
}
}
else if (e.Item.Name == "ExportPDFItem")
{
if (startDate.Value != "")
{
ServerGridViewExporter.FileName = "EventsHistory" + "_" + startDate.Value;
//ServerGridViewExporter.WriteXlsxToResponse();
}
else
{
ServerGridViewExporter.FileName = "EventsHistory" + "_" + DateTime.Now.ToString();
//ServerGridViewExporter.WriteXlsxToResponse();
}
ServerGridViewExporter.Landscape = true;
using (MemoryStream ms = new MemoryStream())
{
PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem());
pcl.Component = ServerGridViewExporter;
pcl.Margins.Left = pcl.Margins.Right = 50;
pcl.Landscape = true;
pcl.CreateDocument(false);
pcl.PrintingSystem.Document.AutoFitToPagesWidth = 1;
pcl.ExportToPdf(ms);
WriteResponse(this.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Attachment.ToString());
//ServerGridViewExporter.WritePdfToResponse();
}
}
}
private void btnExport_Click(object sender, EventArgs e)
{
SetPrintStyle();
string filePath = "Test.pdf";
PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem());
pcl.Component = this.schedulerControl1;
pcl.CreateDocument();
pcl.ExportToPdf(filePath);
// Use the code below to open the file in an associated application.
if (File.Exists(filePath))
{
System.Diagnostics.Process process = new System.Diagnostics.Process();
process.StartInfo.FileName = filePath;
process.Start();
}
}
private void btnExportPdf_Click(object sender, EventArgs e)
{
string FileName = mTempPath + @"\" + GenRendom() + ".pdf";
mlink = new PrintableComponentLink()
{
PrintingSystemBase = new PrintingSystemBase(),
Component = xList,
Landscape = true,
PaperKind = PaperKind.A4,
Margins = new Margins(20, 20, 50, 20),
};
mlink.CreateMarginalHeaderArea += link_CreateMarginalHeaderArea;
mlink.ExportToPdf(FileName);
//xList.ExportToPdf(FileName);
System.Diagnostics.Process.Start(FileName);
}
Stream GetPdfStream()
{
MemoryStream ms = new MemoryStream();
IWorkbook workBook = SpreadsheetExtension.GetCurrentDocument("Spreadsheet");
workBook.SaveDocument(ms, DocumentFormat.Xlsm);
ms.Position = 0;
Workbook docServer = new Workbook();
docServer.LoadDocument(ms, DocumentFormat.Xlsm);
ms.Position = 0;
PrintableComponentLink link = new PrintableComponentLink(new PrintingSystem());
link.Component = docServer;
link.ExportToPdf(ms);
ms.Position = 0;
return(ms);
}
protected void ASPxButton2_Click(object sender, EventArgs e)
{
using (MemoryStream ms = new MemoryStream())
{
PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem());
pcl.Component = ASPxGridViewExporter3;
pcl.Margins.Left = pcl.Margins.Right = 0;
pcl.Margins.Top = 50;
pcl.Landscape = true;
pcl.CreateDocument(true);
pcl.PrintingSystem.Document.AutoFitToPagesWidth = 1;
PageHeaderFooter phf = pcl.PageHeaderFooter as PageHeaderFooter;
phf.Header.Content.Clear();
//phf.Header.Content.AddRange(new string[] { leftColumn, middleColumn, rightColumn });
phf.Header.LineAlignment = BrickAlignment.Far;
pcl.ExportToPdf(ms);
WriteResponse(this.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Attachment.ToString());
}
}
protected void Button_Click(object sender, EventArgs e)
{
PrintableComponentLink link = new PrintableComponentLink(new PrintingSystem());
link.Component = Exporter;
using (MemoryStream ms = new MemoryStream()) {
int height = 20;
link.CreateReportHeaderArea += (s, args) => {
args.Graph.DrawString("Report Header Text", Color.Empty, new RectangleF(Point.Empty, new SizeF(args.Graph.ClientPageSize.Width, height)), BorderSide.Top);
args.Graph.DrawRect(new RectangleF(new Point(0, height), new SizeF(args.Graph.ClientPageSize.Width, height)), BorderSide.Top, Color.Empty, Color.Empty);
};
link.CreateReportFooterArea += (s, args) => {
args.Graph.DrawRect(new RectangleF(Point.Empty, new SizeF(args.Graph.ClientPageSize.Width, height)), BorderSide.Bottom, Color.Empty, Color.Empty);
args.Graph.DrawString("Report Footer Text", Color.Empty, new RectangleF(new Point(0, height), new SizeF(args.Graph.ClientPageSize.Width, height)), BorderSide.Bottom);
};
link.CreateDocument(false);
link.ExportToPdf(ms);
WriteDataToResponse(ms.ToArray(), ExportType.PDF);
}
}
private void printChart_Click(object sender, EventArgs e)
{
PrintingSystem exportChart = new PrintingSystem();
PrintableComponentLink chartLink = new PrintableComponentLink(exportChart);
chartLink.Component = this.inventoryChart;
PageHeaderFooter header = new PageHeaderFooter(new PageHeaderArea(
new string[] { "Inventory report", "", "Printed on [Date Printed][Time Printed]" },
new Font("Verdana", 12.0f),
BrickAlignment.Far), null);
chartLink.PageHeaderFooter = header;
System.IO.Stream chartDocStream;
if (this.inventoryChart.Series["ProductUnits"].Visible)
{
this.inventoryChart.Annotations[0].Visible = false;
}
chartLink.CreateDocument();
if (this.inventoryChart.Series["ProductUnits"].Visible)
{
this.inventoryChart.Annotations[0].Visible = true;
}
SaveFileDialog saveChartDialog = new SaveFileDialog();
saveChartDialog.Filter = "PDF files (*.pdf)|*.pdf";
saveChartDialog.FilterIndex = 1;
saveChartDialog.RestoreDirectory = true;
if (saveChartDialog.ShowDialog() == DialogResult.OK)
{
if ((chartDocStream = saveChartDialog.OpenFile()) != null)
{
chartLink.ExportToPdf(chartDocStream);
chartDocStream.Close();
}
}
}
protected void ASPxButton1_Click(object sender, EventArgs e)
{
PrintableComponentLink link = new PrintableComponentLink(new PrintingSystem());
link.Component = ASPxGridViewExporter1;
using (MemoryStream ms = new MemoryStream())
{
link.CreateDocument(false);
BrickEnumerator brickEnum = link.PrintingSystem.Document.Pages[0].GetEnumerator();
float maxWidth = 0;
while (brickEnum.MoveNext())
{
maxWidth = maxWidth > brickEnum.CurrentBrick.Rect.X + brickEnum.CurrentBrick.Rect.Width ? maxWidth : brickEnum.CurrentBrick.Rect.X + brickEnum.CurrentBrick.Rect.Width;
}
float freeSpace = (link.PrintingSystem.Document.Pages[0]).PageSize.Width - maxWidth;
if (freeSpace > 600)
{
link.Margins.Left = (int)(freeSpace / 6);
link.CreateDocument(false);
}
link.ExportToPdf(ms);
WriteDataToResponse(ms.ToArray(), ExportType.PDF);
}
}
private void exportSatis(string dil, bool eMail = false)
{
int tstID = (int)tstGridView.GetFocusedRowCellValue(colTSTIDt);
rprTklfTableAdapter.Fill(teklifDataSet.RPR_TKLF, tstID, dil);
TeklifDataSet.RPR_TKLFRow rprTklfRow = (TeklifDataSet.RPR_TKLFRow)teklifDataSet.RPR_TKLF.Rows[0];
string tklfTE = "Teklif";
if (dil == "T")
{
colORGf.Caption = "Çıkış";
colDSTf.Caption = "Varış";
colBRMf.Caption = "Birim";
colTRNTIMEf.Caption = "Transit Süre";
colSKDY.Caption = "KDV%";
colSDVZf.Caption = "Para Birim";
colSFYTf.Caption = "Fiyat";
colSFYT1f.Caption = "Min";
colSFYT2f.Caption = "-45";
colSFYT3f.Caption = "+45";
colSFYT4f.Caption = "+100";
colSFYT5f.Caption = "+250";
colSFYT6f.Caption = "+300";
colSFYT7f.Caption = "+500";
colSFYT8f.Caption = "+1000";
colSFYTE.Caption = "Fiyat";
colSFYT1E.Caption = "Min";
colSFYT2E.Caption = "-45";
colSFYT3E.Caption = "+45";
colSFYT4E.Caption = "+100";
colSFYT5E.Caption = "+250";
colSFYT6E.Caption = "+300";
colSFYT7E.Caption = "+500";
colSFYT8E.Caption = "+1000";
}
else
{
tklfTE = "Tender";
colORGf.Caption = "Origin";
colDSTf.Caption = "Destination";
colBRMf.Caption = "Unit";
colTRNTIMEf.Caption = "Transit Time";
colSKDY.Caption = "%VAT";
colSDVZf.Caption = "Currency";
colSFYTf.Caption = "Rate";
colSFYT1f.Caption = "Min";
colSFYT2f.Caption = "-45";
colSFYT3f.Caption = "+45";
colSFYT4f.Caption = "+100";
colSFYT5f.Caption = "+250";
colSFYT6f.Caption = "+300";
colSFYT7f.Caption = "+500";
colSFYT8f.Caption = "+1000";
colSFYTE.Caption = "Rate";
colSFYT1E.Caption = "Min";
colSFYT2E.Caption = "-45";
colSFYT3E.Caption = "+45";
colSFYT4E.Caption = "+100";
colSFYT5E.Caption = "+250";
colSFYT6E.Caption = "+300";
colSFYT7E.Caption = "+500";
colSFYT8E.Caption = "+1000";
}
if (colG9.GroupIndex == 0)
{
tsfGridView.CollapseAllGroups();
//tsfGridView.OptionsView.ShowFooter = true;
tsfGridView.OptionsPrint.ExpandAllGroups = false;
tsfGridView.OptionsPrint.PrintFooter = true;
//tsfGridView.OptionsPrint.AutoWidth = false;
tsfGridView.OptionsPrint.AutoWidth = true;
}
else
{
tsfGridView.ExpandAllGroups();
//tsfGridView.OptionsView.ShowFooter = false;
tsfGridView.OptionsPrint.ExpandAllGroups = true;
tsfGridView.OptionsPrint.PrintFooter = false;
//tsfGridView.OptionsPrint.AutoWidth = false;
tsfGridView.OptionsPrint.AutoWidth = true;
//tsfGridView.BestFitColumns();
}
RichEditDocumentServer richServer = new RichEditDocumentServer();
richServer.RtfText = rprTklfRow.ALTNOT;
//richServer.Document.AppendText(" SENER");
if (!rprTklfRow.IsDTYNOTNull())
{
if (string.IsNullOrEmpty(richServer.Text))
{
richServer.RtfText = rprTklfRow.DTYNOT;
}
else
{
richServer.Document.AppendRtfText(rprTklfRow.DTYNOT);
}
}
tsfGridView.OptionsPrint.RtfReportFooter = richServer.RtfText;
tsfGridView.OptionsPrint.RtfPageFooter = rprTklfRow.FOOTER;
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink link = new PrintableComponentLink(ps);
link.Component = tsfGridControl;
link.PaperKind = System.Drawing.Printing.PaperKind.A4;
link.Landscape = false;
link.Margins.Left = 10;
link.Margins.Right = 10;
link.Margins.Top = 10;
link.Margins.Bottom = 10;
// tsfGridView.OptionsPrint.RtfPageHeader =
tsfGridView.OptionsPrint.RtfReportHeader =
rprTklfRow.USTNOT
.Replace("@TSTID@", rprTklfRow.TSTID.ToString())
.Replace("@FIRMA@", rprTklfRow.FIRMA)
.Replace("@TLPTRH@", rprTklfRow.TLPTRHS)
.Replace("@TKLTRH@", rprTklfRow.TKLTRHS)
.Replace("@GCRTRH@", rprTklfRow.GCRTRHS)
.Replace("@ROT@", rprTklfRow.ROT)
.Replace("@MOT@", rprTklfRow.MOT)
.Replace("@PTM@", rprTklfRow.PTM)
.Replace("@DTM@", rprTklfRow.DTM)
.Replace("@HORGS@", rprTklfRow.HORGS)
.Replace("@HDSTS@", rprTklfRow.HDSTS)
.Replace("@MORGS@", rprTklfRow.MORGS)
.Replace("@MDSTS@", rprTklfRow.MDSTS)
.Replace("@MALCINSI@", rprTklfRow["MALCINSI"].ToString())
.Replace("@INFO@", rprTklfRow.INFO);
link.CreateDocument();
if (eMail)
{
if (string.IsNullOrWhiteSpace(rprTklfRow.EMAILS))
{
XtraMessageBox.Show("eMail adresi bulunamadı", "eMail Teklif", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
Cursor = Cursors.WaitCursor;
try
{
MainDataSet.SMTPRow SMTP = Program.MF.SMTP();
MailMessage mail = new MailMessage();
// Create a new memory stream and export the report into it as PDF.
MemoryStream ms = new MemoryStream();
link.ExportToPdf(ms);
// Create a new attachment and put the PDF report into it.
ms.Seek(0, System.IO.SeekOrigin.Begin);
Attachment att = new Attachment(ms, string.Format("{0}-{1}.pdf", tklfTE, tstID), "application/pdf");
mail.Attachments.Add(att);
mail.To.Add(rprTklfRow.EMAILS);
mail.Subject = rprTklfRow.EMAILSUBJECT;
mail.Body = rprTklfRow.EMAILBODY;
mail.IsBodyHtml = true;
mail.From = new MailAddress(SMTP.MAIL_FROM_ADDRESS, SMTP.MAIL_FROM_DISPLAY_NAME);
SmtpClient smtp = new SmtpClient(SMTP.CLIENT_HOST);
smtp.Credentials = new System.Net.NetworkCredential(SMTP.CREDENTIALS_USER_NAME, SMTP.CREDENTIALS_USER_PASSWORD);
smtp.EnableSsl = SMTP.ENABLE_SSL == "T" ? true : false;
smtp.Port = SMTP.PORT;
smtp.Send(mail);
int len = (int)ms.Length;
byte[] img = new byte[len];
ms.Read(img, 0, len);
//teklifQueriesTableAdapter.DOC_INS2("TST", tstID, "Teklif", ".pdf", "TKLF", Program.USR, len, img);
teklifQueriesTableAdapter.DOC_INS2("TST", tstID, string.Format("Teklif {0}", tstGridView.GetFocusedRowCellValue(colRVSNOt)), ".pdf", "TKLF", Program.USR, len, img);
// Close the memory stream.
ms.Close();
ms.Flush();
rptInfo rpti = new rptInfo();
rpti.put("TKLF", "TST", tstID, Program.USR, "F", "eMail Teklif");
Program.MF.reportDone(rpti, false);
}
catch (Exception ex)
{
MessageBox.Show(this, "Error sending eMail.\n" + ex.ToString());
}
finally
{
Cursor = Cursors.Default;
}
}
else
{
link.ShowPreviewDialog();
if (XtraMessageBox.Show("İşlem tamamlandı mı?", "Print", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
MemoryStream ms = new MemoryStream();
link.ExportToPdf(ms);
ms.Seek(0, System.IO.SeekOrigin.Begin);
int len = (int)ms.Length;
byte[] img = new byte[len];
ms.Read(img, 0, len);
ms.Close();
teklifQueriesTableAdapter.DOC_INS2("TST", tstID, string.Format("Teklif {0}", tstGridView.GetFocusedRowCellValue(colRVSNOt)), ".pdf", "TKLF", Program.USR, len, img);
rptInfo rpti = new rptInfo();
rpti.put("TKLF", "TST", tstID, Program.USR, "F", "eMail Teklif");
Program.MF.reportDone(rpti, false);
}
}
}
