public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RPT001_WorkPlaceLightIntensityReport_2 rpt = new RPT001_WorkPlaceLightIntensityReport_2();
rpt.Site = this.Site;
return(rpt);
}
public void PrintReport()
{
try
{
if (this.WPL_ID == 0)
{
return;
}
if (this.HasResultDayAndNight)
{
using (ReportDocument rpt = new RPT001_WorkPlaceLightIntensityReport_2())
{
rpt.SetParameterValue("@p_ID", WPL_ID);
rpt.SetDatabaseLogon(OISDataInfo.DatabaseInfomation.USERNAME, OISDataInfo.DatabaseInfomation.PASSWORD, OISDataInfo.DatabaseInfomation.DATASOURCE, OISDataInfo.DatabaseInfomation.DATABASENAME);
SetConnection(rpt);
using (PrintDialog p = new PrintDialog())
{
p.AllowPrintToFile = false;
p.AllowCurrentPage = true;
p.AllowSomePages = true;
if (p.ShowDialog() == DialogResult.OK)
{
PageSettings ps = new PageSettings(p.PrinterSettings);
rpt.PrintToPrinter(p.PrinterSettings, ps, false);
}
}
CloseConnection(rpt);
}
}
else
{
using (ReportDocument rpt = new RPT001_WorkPlaceLightIntensityReport_1())
{
rpt.SetParameterValue("@p_ID", WPL_ID);
rpt.SetDatabaseLogon(OISDataInfo.DatabaseInfomation.USERNAME, OISDataInfo.DatabaseInfomation.PASSWORD, OISDataInfo.DatabaseInfomation.DATASOURCE, OISDataInfo.DatabaseInfomation.DATABASENAME);
SetConnection(rpt);
using (PrintDialog p = new PrintDialog())
{
p.AllowPrintToFile = false;
p.AllowCurrentPage = true;
p.AllowSomePages = true;
if (p.ShowDialog() == DialogResult.OK)
{
PageSettings ps = new PageSettings(p.PrinterSettings);
rpt.PrintToPrinter(p.PrinterSettings, ps, false);
}
}
CloseConnection(rpt);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void PreviewDialog()
{
try
{
if (this.HasResultDayAndNight)
{
using (ReportDocument rpt = new RPT001_WorkPlaceLightIntensityReport_2())
{
rpt.SetParameterValue("@p_ID", WPL_ID);
rpt.SetDatabaseLogon(OISDataInfo.DatabaseInfomation.USERNAME, OISDataInfo.DatabaseInfomation.PASSWORD, OISDataInfo.DatabaseInfomation.DATASOURCE, OISDataInfo.DatabaseInfomation.DATABASENAME);
SetConnection(rpt);
using (ReportViewer dlg = new ReportViewer(rpt))
{
dlg.ShowDialog(null);
}
CloseConnection(rpt);
}
}
else
{
using (ReportDocument rpt = new RPT001_WorkPlaceLightIntensityReport_1())
{
rpt.SetParameterValue("@p_ID", WPL_ID);
rpt.SetDatabaseLogon(OISDataInfo.DatabaseInfomation.USERNAME, OISDataInfo.DatabaseInfomation.PASSWORD, OISDataInfo.DatabaseInfomation.DATASOURCE, OISDataInfo.DatabaseInfomation.DATABASENAME);
SetConnection(rpt);
using (ReportViewer dlg = new ReportViewer(rpt))
{
dlg.ShowDialog(null);
}
CloseConnection(rpt);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Export(ExportFormatType exportFormat)
{
try
{
string tmpFileName;
string ReportNumber = "";
if (result != null)
{
ReportNumber = result.REPORTNUMBER + " " + result.CUSTOMER_NAME;
}
switch (exportFormat)
{
case ExportFormatType.PortableDocFormat:
tmpFileName = FilesUtil.GetTmpPdfFileName(ReportNumber);
break;
case ExportFormatType.WordForWindows:
case ExportFormatType.EditableRTF:
tmpFileName = FilesUtil.GetTmpDocFileName(ReportNumber);
break;
case ExportFormatType.Excel:
tmpFileName = FilesUtil.GetTmpXlsFileName(ReportNumber);
break;
default:
tmpFileName = FilesUtil.GetTmpPdfFileName(ReportNumber);
break;
}
if (this.HasResultDayAndNight)
{
using (ReportDocument rpt = new RPT001_WorkPlaceLightIntensityReport_2())
{
rpt.SetParameterValue("@p_ID", WPL_ID);
rpt.SetDatabaseLogon(OISDataInfo.DatabaseInfomation.USERNAME, OISDataInfo.DatabaseInfomation.PASSWORD, OISDataInfo.DatabaseInfomation.DATASOURCE, OISDataInfo.DatabaseInfomation.DATABASENAME);
SetConnection(rpt);
rpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4;
rpt.ExportToDisk(exportFormat, tmpFileName);
Process.Start(tmpFileName);
CloseConnection(rpt);
}
}
else
{
using (ReportDocument rpt = new RPT001_WorkPlaceLightIntensityReport_1())
{
rpt.SetParameterValue("@p_ID", WPL_ID);
rpt.SetDatabaseLogon(OISDataInfo.DatabaseInfomation.USERNAME, OISDataInfo.DatabaseInfomation.PASSWORD, OISDataInfo.DatabaseInfomation.DATASOURCE, OISDataInfo.DatabaseInfomation.DATABASENAME);
SetConnection(rpt);
rpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4;
rpt.ExportToDisk(exportFormat, tmpFileName);
Process.Start(tmpFileName);
CloseConnection(rpt);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
