konto usunięte
Acg N. .
konto usunięte
Acg N. .
konto usunięte
BarcodeLib.Barcode.DoEncode(BarcodeLib.TYPE.UPC_SUPPLEMENTAL_5DIGIT, row.Cells[10].Value.ToString(), true, 50, 25);
Acg N. .
public int GenerateCatalog(bool generatePDF, bool skipTOC)Adrian Olszewski edytował(a) ten post dnia 29.11.10 o godzinie 12:03
{
OracleConnection conn = new OracleConnection( "Data Source=" + this.dbConfig.DBName +
";User Id=" + this.dbConfig.user +
";Password=" + this.dbConfig.pwd +
";Integrated Security=no;");
OracleDataAdapter odaMain = new OracleDataAdapter(Resource1.SQL_MAIN, conn);
....
....
try
{
odaMain.Fill(dsMain);
....
}
catch (OracleException oraex)
{
switch (oraex.Code)
{
....
}
}
string DBVersion = GetDBVersion(conn);
conn.Close();
conn.Dispose();
// ważne! nazwy zrodla danych w definicji raportu i w kodzie musza byc takie same.
dsMain.Tables[0].TableName = "DataSet1_TablesDescription";
....
// w trybie "cichym" nic wiecej nie trzeba
LocalReport report = new LocalReport();
// wczytujemy raport z pliku (ale boze byc rownie dobrze z zasobow, ze strumienia)
Stream s = new FileStream(@"Report.rdlc", FileMode.Open);
report.LoadReportDefinition(s);
s.Close();
// najlepiej niech nazwa subraportu i jego pliku beda takie same.
s = new FileStream(@"TableRelationship.rdlc", FileMode.Open);
report.LoadSubreportDefinition(@"TableRelationship", s);
s.Close();
report.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource(dsMain.Tables[0].TableName, dsMain.Tables[0]));
....
// to zdarzenie mozna podpiac tylko z kodu
report.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
report.SetParameters(new ReportParameter("DBVersion", DBVersion));
// eksport do pliku
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
string format = "";
if (generatePDF)
{
....
fileName = "KatalogTabel_" + DBVersion + ".pdf";
format = "PDF";
}
else
{
....
fileName = "KatalogTabel_" + DBVersion + ".doc";
format = "Word";
}
....
// pdf, xls, doc, jpg, bmp, png, emf...
byte[] bytes = report.Render( format, null, out mimeType, out encoding,
out extension, out streamids, out warnings);
FileStream fs = new FileStream(this.fileName, FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
....
}
....
void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e)
{
e.DataSources.Clear();
// jak o tym zapomnisz, sypnie bledem, ze brak zrodla danych.
// musisz tu podac WSZYSTKIE zrodla danych, dla raportu glownego i wszystkich subraportow!
e.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource(dsMain.Tables[0].TableName, dsMain.Tables[0]));
....
}
Acg N. .
using System;
using System.Collections.Generic;
using System.Text;
using System.Drawing.Imaging;
using System.IO;
using System.Drawing.Printing;
using Microsoft.Reporting.WinForms;
namespace .........
{
class PrintingProvider
{
private int currentPageIndex;
private IList<Stream> streams;
private LocalReport report;
decimal marginLeft;
decimal MarginTop;
string printerName;
public PrintingProvider(LocalReport report, decimal marginLeft, decimal MarginTop, string printerName)
{
this.report= report;
this.marginLeft = marginLeft;
this.marginTop = marginTop;
this.printerName = printerName;
}
private Stream CreateStream(string name, string fileNameExtension, Encoding encoding,
string mimeType, bool willSeek)
{
MemoryStream memStream = new MemoryStream();
streams.Add(memStream);
return memStream;
}
private void Export()
{
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>21cm</PageWidth>" +
" <PageHeight>29.7cm</PageHeight>" +
" <MarginTop>" + this.marginTop.ToString("n2").Replace(",", ".") + "mm</MarginTop>" +
" <MarginLeft>" + this.marginLeft.ToString("n2").Replace(",", ".") + "mm</MarginLeft>" +
" <MarginRight>0.0in</MarginRight>" +
" <MarginBottom>0.0in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
streams = new List<Stream>();
this.report.Render("Image", deviceInfo, CreateStream, out warnings);
foreach (Stream stream in streams)
stream.Position = 0;
}
private void Print()
{
if (streams == null || streams.Count == 0)
return;
PrintDocument printDoc = new PrintDocument();
printDoc.PrinterSettings.PrinterName = this.PrinterName;
if (!printDoc.PrinterSettings.IsValid)
{
...... // brak drukarki
return;
}
printDoc.PrintPage += new PrintPageEventHandler(PrintPage);
printDoc.DocumentName = "..........";
printDoc.PrintController = new StandardPrintController();
printDoc.Print();
}
public void PrintIt()
{
this.Export();
this.currentPageIndex = 0;
this.Print();
}
private void PrintPage(object sender, PrintPageEventArgs ev)
{
Metafile pageImage = new Metafile(streams[currentPageIndex]);
ev.Graphics.DrawImage(pageImage, ev.PageBounds);
currentPageIndex++;
ev.HasMorePages = (currentPageIndex < streams.Count);
}
}
}
пропозиції роботи
report.AddTrustedCodeModuleInCurrentAppDomain("System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a");
report.AddTrustedCodeModuleInCurrentAppDomain("I25, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null");
konto usunięte
Maciej
Hehl
w teorii Automatyk i
Robotyk (po wydziale
mechanicznym), ...
Maciej Hehl edytował(a) ten post dnia 30.11.10 o godzinie 19:05
private Stream CreateStream(string name, string fileNameExtension, Encoding encoding, string mimeType, bool willSeek)
{
MemoryStream memStream = new MemoryStream();
streams.Add(memStream);
return memStream;
}
konto usunięte
Acg N. .
Maciej Hehl:
Czy mogę tak nieśmiało zapytać do czego służą argumenty w tej funkcji?
Maciej Hehl edytował(a) ten post dnia 30.11.10 o godzinie 19:05
private Stream CreateStream(string name, string fileNameExtension, Encoding encoding, string mimeType, bool willSeek)
{
MemoryStream memStream = new MemoryStream();
streams.Add(memStream);
return memStream;
}
namespace Microsoft.Reporting.WinForms
{
// Summary:
// Provides a stream to the ReportViewer control for rendering.
//
// Parameters:
// name:
// The name of the stream.
//
// extension:
// The file name extension to use if a file stream is being created.
//
// encoding:
// An Encoding enumerator value specifying the character encoding of the stream.
// This may be null if the stream does not contain characters.
//
// mimeType:
// A string containing the MIME type of the stream.
//
// willSeek:
// A Boolean value indicated whether the stream needs to support seeking. If
// the value is false, the stream will be forward-only and will be sent to the
// client in chunks as it is created. If the value is true, the stream may be
// written in any order.
//
// Returns:
// A Stream object to which the ReportViewer control can write data.
public delegate Stream CreateStreamCallback(string name, string extension, Encoding encoding, string mimeType, bool willSeek);
}
konto usunięte
Workbook Add(
[In, Optional] object Template
);
Workbook workbook = excelApplication.Workbooks.Add(Missing.Value);
Maciej
Hehl
w teorii Automatyk i
Robotyk (po wydziale
mechanicznym), ...
Adrian Olszewski:
Taka jest sygnatura delegaty CreateStreamCallback. ...
Następna dyskusja:
