private void GetCommand(SqlCommand command, bool inlcudeHiddenFields = true, bool isSchemaOnly = false, bool useUserFilter = true, string sortField = null, string sortDir = null)
{
_report.MigrateToNewReport();
_summaryReport = JsonConvert.DeserializeObject <SummaryReport>(_report.ReportDef);
command.CommandType = CommandType.Text;
command.CommandTimeout = SystemSettings.GetReportTimeout();
switch (_report.ReportDefType)
{
case ReportType.Chart:
_summaryReportSql.GetSummarySql(command, _summaryReport, isSchemaOnly, null, false, true);
break;
case ReportType.Summary:
_summaryReportSql.GetSummarySql(command, _summaryReport, isSchemaOnly, _report.ReportID, useUserFilter, false);
break;
default:
break;
}
Report.AddCommandParametersForExport(command, _report.Collection.LoginUser);
command.CommandText = $" /* ReportID: {_report.ReportID.ToString()} OrganizationID: {_report.OrganizationID.ToString()} */ " + command.CommandText;
}
public static void GetSummarySql(LoginUser loginUser, SqlCommand command, SummaryReport summaryReport, bool isSchemaOnly, int?reportID, bool useUserFilter, bool useDefaultOrderBy)
{
SummaryReportSql summaryReportSql = new SummaryReportSql(loginUser);
summaryReportSql.GetSummarySql(command, summaryReport, isSchemaOnly, reportID, useUserFilter, useDefaultOrderBy);
}
