private void FormatParameters(DataDynamics.ActiveReports.ActiveReport rpt, ReportParameterCollection parameters)
{
foreach (ReportParameter param in parameters)
{
rpt.AddNamedItem(param.ParameterName, param.ParameterValue);
}
}
public void ShowReport(string fileName, Form parentForm)
{
try
{
Cursor tmp = this.Cursor;
ResourceManager res = new ResourceManager("mz.erp.ui.forms.localization", this.GetType().Assembly);
_viewer.Localize = res;
//Cursor = Cursors.WaitCursor;
MdiParent = parentForm;
string path = this.getPath(fileName);
if (File.Exists(path))
{
StreamReader sr = new StreamReader(path);
DataDynamics.ActiveReports.ActiveReport rpt = new DataDynamics.ActiveReports.ActiveReport();
rpt.LoadLayout(sr.BaseStream);
//DataDynamics.ActiveReports.DataSources.SqlDBDataSource sqlDS = (DataDynamics.ActiveReports.DataSources.SqlDBDataSource)rpt.DataSource;
//sqlDS.ConnectionString = dbhelper.Connection.GetConnection().ConnectionString;
//rpt.DataSource = sqlDS;
//rpt.AddNamedItem("Empresa",Variables.GetValueString("Sistema.NombreEmpresa"));
rpt.Run();
_viewer.Document = rpt.Document;
Show();
}
else
{
Errores.MessageFileNotFound();
}
}
catch (Exception e) {; }
}
private void ShowReport(string fileName, Form parentForm)
{
try
{
Cursor tmp = this.Cursor;
ResourceManager res = new ResourceManager("mz.erp.ui.forms.localization", this.GetType().Assembly);
_viewer.Localize = res;
//Cursor = Cursors.WaitCursor;
MdiParent = parentForm;
string path = this.getPath(fileName);
if (File.Exists(path))
{
StreamReader sr = new StreamReader(path);
DataDynamics.ActiveReports.ActiveReport rpt = new DataDynamics.ActiveReports.ActiveReport();
rpt.LoadLayout(sr.BaseStream);
rpt.Run();
_viewer.Document = rpt.Document;
ShowDialog();
}
else
{
Errores.MessageFileNotFound();
}
}
catch (Exception e) {; }
}
private void FormatParameters(DataDynamics.ActiveReports.ActiveReport rpt, object [] parameters)
{
string p = "Param";
int i = 1;
foreach (object param in parameters)
{
rpt.AddNamedItem(p + i, param);
i++;
}
}
private void ShowReport(System.Data.DataTable table, string fileName, Form parentForm, ReportParameterCollection parameters, bool show, bool print, bool printSetup, bool printProgress)
{
ResourceManager res = new ResourceManager("mz.erp.ui.forms.localization", this.GetType().Assembly);
_viewer.Localize = res;
try
{
string path = this.getPath(fileName);
MdiParent = parentForm;
if (File.Exists(path))
{
StreamReader sr = new StreamReader(path);
DataDynamics.ActiveReports.ActiveReport rpt = new DataDynamics.ActiveReports.ActiveReport();
rpt.LoadLayout(sr.BaseStream);
DataDynamics.ActiveReports.DataSources.SqlDBDataSource sqlDS = (DataDynamics.ActiveReports.DataSources.SqlDBDataSource)rpt.DataSource;
rpt.DataSource = table;
rpt.AddNamedItem("Empresa", _uiController.Empresa);
rpt.AddNamedItem("DireccionEmpresa", _uiController.DireccionEmpresa);
rpt.AddNamedItem("TelefonoEmpresa", _uiController.TelefonoEmpresa);
rpt.AddNamedItem("Usuario", _uiController.Usuario);
FormatParameters(rpt, parameters);
rpt.Run();
_viewer.Document = rpt.Document;
if (show)
{
Show();
}
if (print)
{
//Deprecated
//rpt.Document.Print(printSetup, printProgress);
rpt.Document.Print(printSetup, printProgress, false);
}
}
else
{
Errores.MessageFileNotFound();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public void ShowReport(System.Data.DataTable table, string fileName, Form parentForm, object[] parameters)
{
ResourceManager res = new ResourceManager("mz.erp.ui.forms.localization", this.GetType().Assembly);
_viewer.Localize = res;
try
{
string path = this.getPath(fileName);
MdiParent = parentForm;
if (File.Exists(path))
{
StreamReader sr = new StreamReader(path);
DataDynamics.ActiveReports.ActiveReport rpt = new DataDynamics.ActiveReports.ActiveReport();
rpt.LoadLayout(sr.BaseStream);
DataDynamics.ActiveReports.DataSources.SqlDBDataSource sqlDS = (DataDynamics.ActiveReports.DataSources.SqlDBDataSource)rpt.DataSource;
rpt.DataSource = table.DefaultView;
Console.WriteLine("Vivi");
rpt.AddNamedItem("Empresa", Variables.GetValueString("Sistema.NombreEmpresa"));
FormatParameters(rpt, parameters);
rpt.Run();
_viewer.Document = rpt.Document;
Show();
}
else
{
Errores.MessageFileNotFound();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
/*
* private void ShowReport(System.Data.DataView table,string fileName, Form parentForm ,ReportParameterCollection parameters, bool show, bool print, bool printSetup, bool printProgress, bool askPrint)
* {
*
* ResourceManager res = new ResourceManager("mz.erp.ui.forms.localization", this.GetType().Assembly);
* _viewer.Localize = res;
* try
* {
*
*
* string path = this.getPath(fileName);
* MdiParent = parentForm;
* if ( File.Exists( path ) )
* {
*
* StreamReader sr = new StreamReader( path );
* DataDynamics.ActiveReports.ActiveReport rpt = new DataDynamics.ActiveReports.ActiveReport();
*
*
*
* rpt.LoadLayout( sr.BaseStream );
*
* DataDynamics.ActiveReports.DataSources.SqlDBDataSource sqlDS = (DataDynamics.ActiveReports.DataSources.SqlDBDataSource)rpt.DataSource;
* rpt.DataSource = table;
* rpt.AddNamedItem("Empresa", _uiController.Empresa);
* rpt.AddNamedItem("DireccionEmpresa", _uiController.DireccionEmpresa);
* rpt.AddNamedItem("TelefonoEmpresa", _uiController.TelefonoEmpresa);
* rpt.AddNamedItem("Usuario", _uiController.Usuario);
*
*
* rpt.AddNamedItem("CUITEmpresa",Variables.GetValueString("Sistema.CUITEmpresa"));
* rpt.AddNamedItem("CategoriaIvaEmpresa",Variables.GetValueString("Sistema.CategoriaIvaEmpresa"));
* rpt.AddNamedItem("IngresosBrutosEmpresa",Variables.GetValueString("Sistema.IngresosBrutosEmpresa"));
* rpt.AddNamedItem("InicioActividadesEmpresa",Variables.GetValueString("Sistema.InicioActividadesEmpresa"));
* rpt.AddNamedItem("Logo",Variables.GetValueString("Reportes.Logo"));
*
*
* rpt.AddNamedItem("CategoriaIvaEmpresa", Variables.GetValueString("Sistema.CategoriaDeIvaEmpresa"));
* rpt.AddNamedItem("CUITEmpresa", Variables.GetValueString("Sistema.CUITEmpresa"));
* rpt.AddNamedItem("IngresosBrutosEmpresa", Variables.GetValueString("Sistema.IngresosBrutosEmpresa"));
* rpt.AddNamedItem("InicioActividadesEmpresa", Variables.GetValueString("Sistema.InicioActividadesEmpresa"));
* rpt.AddNamedItem("Logo", Variables.GetValueString("Reportes.Logo"));
*
*
* FormatParameters(rpt,parameters);
*
* rpt.Run();
*
* _viewer.Document = rpt.Document;
* if(show)
* Show();
* else
* {
* if(print)
* if(askPrint)
* {
* if(MessageBox.Show("Desea Imprimir?","Impresión", System.Windows.Forms.MessageBoxButtons.YesNo,System.Windows.Forms.MessageBoxIcon.Question).Equals(DialogResult.Yes))
* //Deprecated
* //rpt.Document.Print(printSetup, printProgress);
* rpt.Document.Print(printSetup,printProgress,false);
* }
* else
* //Deprecated
* //rpt.Document.Print(printSetup, printProgress);
* rpt.Document.Print(printSetup,printProgress,false);
* }
*
* }
* else
* {
* Errores.MessageFileNotFound();
* }
* }
* catch(Exception e )
* {
*
* Console.WriteLine(e.Message);
*
* }
* }
*/
/*Se Modifico, pasar al codigo nuevo*/
private void ShowReport(System.Data.DataView table, string fileName, Form parentForm, ReportParameterCollection parameters, bool show, bool print, bool printSetup, bool printProgress, bool askPrint, bool customPrinter, string PrinterName, short copies)
{
ResourceManager res = new ResourceManager("mz.erp.ui.forms.localization", this.GetType().Assembly);
_viewer.Localize = res;
try
{
string path = this.getPath(fileName);
MdiParent = parentForm;
if (File.Exists(path))
{
StreamReader sr = new StreamReader(path);
DataDynamics.ActiveReports.ActiveReport rpt = new DataDynamics.ActiveReports.ActiveReport();
rpt.LoadLayout(sr.BaseStream);
DataDynamics.ActiveReports.DataSources.SqlDBDataSource sqlDS = (DataDynamics.ActiveReports.DataSources.SqlDBDataSource)rpt.DataSource;
rpt.DataSource = table;
rpt.AddNamedItem("Empresa", _uiController.Empresa);
rpt.AddNamedItem("DireccionEmpresa", _uiController.DireccionEmpresa);
rpt.AddNamedItem("TelefonoEmpresa", _uiController.TelefonoEmpresa);
rpt.AddNamedItem("Usuario", _uiController.Usuario);
rpt.AddNamedItem("CUITEmpresa", Variables.GetValueString("Sistema.CUITEmpresa"));
rpt.AddNamedItem("CategoriaIvaEmpresa", Variables.GetValueString("Sistema.CategoriaIvaEmpresa"));
rpt.AddNamedItem("IngresosBrutosEmpresa", Variables.GetValueString("Sistema.IngresosBrutosEmpresa"));
rpt.AddNamedItem("InicioActividadesEmpresa", Variables.GetValueString("Sistema.InicioActividadesEmpresa"));
rpt.AddNamedItem("Logo", Variables.GetValueString("Reportes.Logo"));
FormatParameters(rpt, parameters);
rpt.Run(false);
_viewer.Document = rpt.Document;
/*
* System.Drawing.Printing.PrinterSettings ps = new System.Drawing.Printing.PrinterSettings();
* ps.PrinterName = "HP LaserJet 1020 en PCADRIANA";
* rpt.Document.Printer.PrinterSettings = ps;
* rpt.Document.Printer.PrinterName = "HP LaserJet 1020 en PCADRIANA";
*
*
* rpt.Document.Printer.PrinterSettings.PrinterName = "HP LaserJet 1020 en PCADRIANA";
* rpt.Document.Printer.PrinterName = "HP LaserJet 1020 en PCADRIANA";
*/
if (show)
{
Show();
}
else
{
if (print)
{
/*
* PrintDialog pd = new PrintDialog();
* System.Drawing.Printing.PrinterSettings.StringCollection printerCollection = System.Drawing.Printing.PrinterSettings.InstalledPrinters;
* pd.Document = rpt.Document.Printer;
* pd.Document.DefaultPageSettings.PrinterSettings.PrinterName = @"\\PCADRIANA\HP LaserJet 1020";
*/
//pd.Document.PrinterSettings.
//pd.Document.Print();
if (askPrint)
{
if (MessageBox.Show("Desea Imprimir?", "Impresión", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question).Equals(DialogResult.Yes))
{
if (customPrinter)
{
rpt.Document.Printer.PrinterSettings.PrinterName = PrinterName; //@"\\PCADRIANA\HP LaserJet 1020";
}
else
if (_uiController.AllowImpresoraPorTipoDeComprobante)
{
rpt.Document.Printer.PrinterSettings.PrinterName = _uiController.ImpresoraPorTipoDeComprobante;
}
//rpt.Document.Printer.PrinterSettings.PrinterName = PrinterName;
rpt.Document.Printer.PrinterSettings.Copies = copies;
//German 20100713 - Tarea 793
if (_uiController.BandejaPersonalizada)
{
if (_uiController.Bandeja != null && _uiController.Bandeja != string.Empty)
{
//rpt.Document.Printer.PrinterSettings.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.Bandeja, rpt.Document);
rpt.Document.Printer.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.Bandeja, rpt.Document);
}
}
else
{
if (_uiController.AllowBandejaPorTipoDeComprobante)
{
if (_uiController.BandejaPorTipoDeComprobante != null && _uiController.BandejaPorTipoDeComprobante != string.Empty)
{
//rpt.Document.Printer.PrinterSettings.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.BandejaPorTipoDeComprobante, rpt.Document);
rpt.Document.Printer.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.BandejaPorTipoDeComprobante, rpt.Document);
}
}
}
//Fin German 20100713 - Tarea 793
//Deprecated
//rpt.Document.Print(printSetup, printProgress);
rpt.Document.Print(printSetup, printProgress, false);
}
}
else
{
if (customPrinter)
{
rpt.Document.Printer.PrinterSettings.PrinterName = PrinterName; //@"\\PCADRIANA\HP LaserJet 1020";
}
else
if (_uiController.AllowImpresoraPorTipoDeComprobante)
{
rpt.Document.Printer.PrinterSettings.PrinterName = _uiController.ImpresoraPorTipoDeComprobante;
}
rpt.Document.Printer.PrinterSettings.Copies = copies;
//German 20100713 - Tarea 793
if (_uiController.BandejaPersonalizada)
{
if (_uiController.Bandeja != null && _uiController.Bandeja != string.Empty)
{
//rpt.Document.Printer.PrinterSettings.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.Bandeja, rpt.Document);
rpt.Document.Printer.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.Bandeja, rpt.Document);
}
}
else
{
if (_uiController.AllowBandejaPorTipoDeComprobante)
{
if (_uiController.BandejaPorTipoDeComprobante != null && _uiController.BandejaPorTipoDeComprobante != string.Empty)
{
//rpt.Document.Printer.PrinterSettings.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.BandejaPorTipoDeComprobante, rpt.Document);
rpt.Document.Printer.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.BandejaPorTipoDeComprobante, rpt.Document);
}
}
}
//Fin German 20100713 - Tarea 793
//Deprecated
//rpt.Document.Print(printSetup, printProgress);
rpt.Document.Print(printSetup, printProgress, false);
}
}
}
}
else
{
Errores.MessageFileNotFound();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public void ShowReport(System.Data.DataTable table, string fileName, Form parentForm, ReportParameterCollection parameters, bool show, bool print, bool printSetup, bool printProgress, bool askPrint, bool customPrinter, string PrinterName, short copies)
{
ResourceManager res = new ResourceManager("mz.erp.ui.forms.localization", this.GetType().Assembly);
_viewer.Localize = res;
try
{
string path = this.getPath(fileName);
MdiParent = parentForm;
if (File.Exists(path))
{
StreamReader sr = new StreamReader(path);
DataDynamics.ActiveReports.ActiveReport rpt = new DataDynamics.ActiveReports.ActiveReport();
rpt.LoadLayout(sr.BaseStream);
DataDynamics.ActiveReports.DataSources.SqlDBDataSource sqlDS = (DataDynamics.ActiveReports.DataSources.SqlDBDataSource)rpt.DataSource;
rpt.DataSource = table;
rpt.AddNamedItem("Empresa", Variables.GetValueString("Sistema.NombreEmpresa"));
FormatParameters(rpt, parameters);
rpt.Run();
_viewer.Document = rpt.Document;
if (show)
{
Show();
}
else
{
if (print)
{
if (askPrint)
{
if (MessageBox.Show("Desea Imprimir?", "Impresión", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question).Equals(DialogResult.Yes))
{
if (customPrinter)
{
rpt.Document.Printer.PrinterSettings.PrinterName = PrinterName; //@"\\PCADRIANA\HP LaserJet 1020";
}
else
if (_uiController.AllowImpresoraPorTipoDeComprobante)
{
rpt.Document.Printer.PrinterSettings.PrinterName = _uiController.ImpresoraPorTipoDeComprobante;
}
rpt.Document.Printer.PrinterSettings.Copies = copies;
//German 20100713 - Tarea 793
if (_uiController.BandejaPersonalizada)
{
if (_uiController.Bandeja != null && _uiController.Bandeja != string.Empty)
{
//rpt.Document.Printer.PrinterSettings.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.Bandeja, rpt.Document);
rpt.Document.Printer.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.Bandeja, rpt.Document);
}
}
else
{
if (_uiController.AllowBandejaPorTipoDeComprobante)
{
if (_uiController.BandejaPorTipoDeComprobante != null && _uiController.BandejaPorTipoDeComprobante != string.Empty)
{
//rpt.Document.Printer.PrinterSettings.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.BandejaPorTipoDeComprobante, rpt.Document);
rpt.Document.Printer.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.BandejaPorTipoDeComprobante, rpt.Document);
}
}
}
//Fin German 20100713 - Tarea 793
//Deprecated
//rpt.Document.Print(printSetup, printProgress);
rpt.Document.Print(printSetup, printProgress, false);
}
}
else
{
if (customPrinter)
{
rpt.Document.Printer.PrinterSettings.PrinterName = PrinterName; //@"\\PCADRIANA\HP LaserJet 1020";
}
else
if (_uiController.AllowImpresoraPorTipoDeComprobante)
{
rpt.Document.Printer.PrinterSettings.PrinterName = _uiController.ImpresoraPorTipoDeComprobante;
}
rpt.Document.Printer.PrinterSettings.Copies = copies;
//German 20100713 - Tarea 793
if (_uiController.BandejaPersonalizada)
{
if (_uiController.Bandeja != null && _uiController.Bandeja != string.Empty)
{
//rpt.Document.Printer.PrinterSettings.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.Bandeja, rpt.Document);
rpt.Document.Printer.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.Bandeja, rpt.Document);
}
}
else
{
if (_uiController.AllowBandejaPorTipoDeComprobante)
{
if (_uiController.BandejaPorTipoDeComprobante != null && _uiController.BandejaPorTipoDeComprobante != string.Empty)
{
//rpt.Document.Printer.PrinterSettings.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.BandejaPorTipoDeComprobante, rpt.Document);
rpt.Document.Printer.DefaultPageSettings.PaperSource = GetPrinterTray(_uiController.BandejaPorTipoDeComprobante, rpt.Document);
}
}
}
//Fin German 20100713 - Tarea 793
//Deprecated
//rpt.Document.Print(printSetup, printProgress);
rpt.Document.Print(printSetup, printProgress, false);
}
}
}
}
else
{
Errores.MessageFileNotFound();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}