protected override IWriter GetWriter(ReportFormats format)
{
if (format != ReportFormats.Excel)
{
return(null);
}
return(new OptimizationEfficiencyExcludeOleExcelWriter());
}
protected override IWriter GetWriter(ReportFormats format)
{
if (format == ReportFormats.Excel)
{
return(new SupplierExcelWriter());
}
return(null);
}
protected override IWriter GetWriter(ReportFormats format)
{
if (format == ReportFormats.Excel)
{
return(new PricesOfCompetitorsWriter(Connection, _reportParams, ReportCaption));
}
return(null);
}
protected void TryInitReport <T>(string fileName = "test.xls", ReportFormats format = ReportFormats.Excel)
{
if (report == null)
{
report = (BaseReport)Activator.CreateInstance(typeof(T), (MySqlConnection)session.Connection, properties);
report.Format = format;
report.ReportCaption = "test report";
}
}
protected override IWriter GetWriter(ReportFormats format)
{
if (format != ReportFormats.Excel)
{
return(null);
}
return(new PharmacyMixedOleWriter());
}
protected override IWriter GetWriter(ReportFormats format)
{
if (format == ReportFormats.DBF)
{
throw new ReportException("Не умею готовить отчет в dbf");
}
return(new LeakOffersNativeWriter());
}
public Report(string reportServerPath, string reportPath, ReportFormats format, NetworkCredential credentials, Dictionary <string, string> reportParams)
{
_httpWReq = null;
_httpWResp = null;
Params = reportParams ?? new Dictionary <String, String>();
ReportServerPath = reportServerPath;
ReportPath = reportPath;
Format = format;
Credentials = credentials;
}
/// <summary>
///
/// </summary>
/// <param name="reportServerPath">ex. http://desktop-51p1738/ReportServer_SSRS</param>
/// <param name="reportPath">ex. ReportFormats.Pdf</param>
/// <param name="reportFormats">ex. BasicReport or BusinessReports/BasicReport</param>
/// <param name="credentials">ex. new NetworkCredential("log", "pass")</param>
/// <param name="reportParams">Dictionary, where [parameterName, parameterValue]></param>
/// <returns>Report bytes in chosen format.</returns>
public byte[] GetReportBytes(string reportPath, ReportFormats reportFormat, NetworkCredential credentials, Dictionary <string, string> reportParams)
{
using (Report report = new Report(ReportServerPath, reportPath, reportFormat, credentials, reportParams))
{
using (var ms = new MemoryStream())
{
report.Render().CopyTo(ms);
return(ms.ToArray());
}
}
}
public static ReportFormat ByCode(ReportFormats code)
{
switch (code)
{
case ReportFormats.Html: return Html;
case ReportFormats.MHtml: return Html; //<<======================
case ReportFormats.Pdf: return Pdf;
case ReportFormats.Xlsx: return Xlsx;
case ReportFormats.Docx: return Docx;
default: return null;
}
}
/// <summary>
/// Selects a Report Writter.
/// </summary>
public static ReportWritter GetReportWritter(System.IO.StreamWriter file, ReportFormats reportFormat = ReportFormats.ExcelReport)
{
ReportWritter reportWritter;
if (reportFormat == ReportFormats.ExcelReport)
{
reportWritter = new ExcelWritter(file);
}
else
{
reportWritter = new CSVWritter(file);
}
return reportWritter;
}
/// <summary>
/// Selects a Report Writter.
/// </summary>
public static ReportWritter GetReportWritter(System.IO.StreamWriter file, ReportFormats reportFormat = ReportFormats.ExcelReport)
{
ReportWritter reportWritter;
if (reportFormat == ReportFormats.ExcelReport)
{
reportWritter = new ExcelWritter(file);
}
else
{
reportWritter = new CSVWritter(file);
}
return(reportWritter);
}
/// <summary>
///
/// </summary>
/// <param name="reportServerPath">ex. http://desktop-51p1738/ReportServer_SSRS</param>
/// <param name="reportPath">ex. ReportFormats.Pdf</param>
/// <param name="reportFormats">ex. BasicReport or BusinessReports/BasicReport</param>
/// <param name="reportParams">Dictionary, where [parameterName, parameterValue]></param>
/// <returns>Report bytes in chosen format.</returns>
public byte[] GetReportBytes(string reportPath, ReportFormats reportFormat, List <ReportParameter> reportParams)
{
if (reportPath.Count(p => p == '/') == 1)
{
reportPath = reportPath.Replace("/", "");
}
using (Report report = new Report(ReportServerPath, reportPath, reportFormat, Credentials, reportParams.ToDictionary(p => p.Name, p => p.Value)))
{
using (var ms = new MemoryStream())
{
report.Render().CopyTo(ms);
return(ms.ToArray());
}
}
}
public void Save(DataGridView DG1, string Address, ReportFormats RF)
{
switch (RF)
{
case ReportFormats.Excel:
ToExcel(DG1).SaveAs(Address);
break;
case ReportFormats.PDF:
ToExcel(DG1).ExportAsFixedFormat(Excel.XlFixedFormatType.xlTypePDF, new FileInfo(Address).FullName);
break;
case ReportFormats.Word:
break;
}
;
}
public static ReportFormat ByCode(ReportFormats code)
{
switch (code)
{
case ReportFormats.Html: return(Html);
case ReportFormats.MHtml: return(Html); //<<======================
case ReportFormats.Pdf: return(Pdf);
case ReportFormats.Xlsx: return(Xlsx);
case ReportFormats.Docx: return(Docx);
default: return(null);
}
}
protected virtual IWriter GetWriter(ReportFormats format)
{
return(null);
}
protected override IWriter GetWriter(ReportFormats format)
{
return(new CostDynamicWriter());
}
public Responses.RenderResponse RenderReport(string reportPath,
Dictionary <string, string> parameters,
string dataSourceName,
bool overrideCredentials = true,
ReportFormats format = ReportFormats.PDF)
{
//Set the format
string reportFormat = null;
switch (format)
{
case ReportFormats.XML:
reportFormat = "XML";
break;
case ReportFormats.NULL:
reportFormat = "NULL";
break;
case ReportFormats.CSV:
reportFormat = "CSV";
break;
case ReportFormats.IMAGE:
reportFormat = "IMAGE";
break;
case ReportFormats.PDF:
reportFormat = "PDF";
break;
case ReportFormats.HTML40:
reportFormat = "HTML4.0";
break;
case ReportFormats.HTML32:
reportFormat = "HTML3.2";
break;
case ReportFormats.MHTML:
reportFormat = "MHTML";
break;
case ReportFormats.EXCEL:
reportFormat = "EXCEL";
break;
case ReportFormats.Word:
reportFormat = "Word";
break;
default:
reportFormat = "PDF";
break;
}
//Create the communication channel
var channelFactory = CreateReportExecutionServiceFactory();
var client = channelFactory.CreateChannel();
//Setup the parameters
Execution.ParameterValue[] reportParameters = null;
if (parameters != null)
{
reportParameters = new Execution.ParameterValue[parameters.Count];
for (int i = 0; i < reportParameters.Length; i++)
{
reportParameters[i] = new Execution.ParameterValue();
reportParameters[i].Name = parameters.Keys.ElementAt(i);
reportParameters[i].Value = parameters.Values.ElementAt(i);
}
}
else
{
reportParameters = new Execution.ParameterValue[0];
}
var loadedReport = client.LoadReport(new LoadReportRequest
{
Report = reportPath
});
if (overrideCredentials) /* °\(^▿^)/° (ノ°ο°)ノ */
{
//**These lines are for setting the datasource of the report before rendering it**
ReportServer.Execution.DataSourceCredentials datasetCredential = new ReportServer.Execution.DataSourceCredentials();
datasetCredential.DataSourceName = dataSourceName;
datasetCredential.UserName = _DataSourceUserName;
datasetCredential.Password = _DataSourcePassword;
ReportServer.Execution.DataSourceCredentials[] credentials = new ReportServer.Execution.DataSourceCredentials[1];
credentials[0] = datasetCredential;
client.SetExecutionCredentials(new SetExecutionCredentialsRequest(loadedReport.ExecutionHeader, new Execution.TrustedUserHeader(), credentials));
}
//Just set the parameters if there are some
if (reportParameters.Length > 0)
{
try
{
client.SetExecutionParameters(new SetExecutionParametersRequest
{
Parameters = reportParameters,
ExecutionHeader = loadedReport.ExecutionHeader,
ParameterLanguage = "en-us"
});
}catch (Exception e)
{
if (e.Message.Contains("dataSource"))
{
reportParameters = reportParameters.Where(r => r.Name != "dataSource").ToArray();
client.SetExecutionParameters(new SetExecutionParametersRequest
{
Parameters = reportParameters,
ExecutionHeader = loadedReport.ExecutionHeader,
ParameterLanguage = "en-us"
});
}
}
}
//Build the render request
var request = new RenderRequest()
{
Format = reportFormat,
ExecutionHeader = loadedReport.ExecutionHeader
};
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("es-ES");
//Render the report
var renderedReport = client.Render(request);
//Close de communication channel
channelFactory.Close();
var result = new Responses.RenderResponse();
result.Content = renderedReport.Result;
result.ContentType = renderedReport.MimeType;
result.Extension = renderedReport.Extension;
return(result);
}
public static async Task <ReportExportResult> ExportReportToFormatAsync(ReportViewerModel model, ReportFormats format, int?startPage = 0, int?endPage = 0)
{
return(await ExportReportToFormatAsync(model, format.GetName(), startPage, endPage));
}
public static ReportExportResult ExportReportToFormat(ReportViewerModel model, ReportFormats format, int?startPage = 0, int?endPage = 0)
{
return(ExportReportToFormat(model, format.GetName(), startPage, endPage));
}
public byte[] GetReport(string path, List <ReportParameter> parameters, ReportFormats format)
{
ReportClient client = new ReportClient(Config.ReportingServiceServerPath);
return(client.GetReportBytes(path, format, parameters));
}
