/// <summary>
/// Gets the report by id.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="parameter">The parameter.</param>
/// <returns></returns>
public BaseReport GetReportById(int reportId, ReportParameter parameter)
{
if (reportId > 0)
{
var standardReport = new StandardReport(reportId)
{
ResultDataTable = StandardReportRepository.GetReportById(reportId, parameter),
Columns = StandardReportRepository.GetReportColumns(reportId).ToList(),
ExtraHeaderCollection = StandardReportRepository.GetExtraHeaderById(reportId).ToList()
};
if (parameter.Unit != null && parameter.Unit != ConstValues.Unit_100M)
{
foreach (var c in standardReport.Columns)
{
if (c.ColumnType == null || !c.ColumnType.Equals("decimal"))
{
continue;
}
foreach (var r in standardReport.ResultDataTable.AsEnumerable())
{
if (r[c.ColumnName] != null && r[c.ColumnName].GetType() != typeof(DBNull))
{
r[c.ColumnName] = Convert.ToDecimal(SwitchAmountUnit(parameter.Unit, Convert.ToDouble(r[c.ColumnName])));
}
}
}
}
return(standardReport);
}
return(new StandardReport(reportId));
}
public BaseReport GetStructureReportById(int reportId, ReportParameter parameter)
{
if (reportId > 0)
{
var standardReport = new StandardReport(reportId)
{
ResultDataTable = StandardReportRepository.GetStructureReportById(reportId, parameter),
Columns = StandardReportRepository.GetReportColumns(reportId).ToList(),
ExtraHeaderCollection = StandardReportRepository.GetExtraHeaderById(reportId).ToList()
};
return(standardReport);
}
return(new StandardReport(reportId));
}
public void TestGetReportById()
{
var target = new StandardReportRepository();
var actual = target.GetReportById(30100,
new ReportParameter
{
StartDate =
null,
EndDate = null,
Unit = null,
TableName = "cfets_FOGCUYSpRep_FORGCURYSpot",
ColumnList = null
});
Console.WriteLine(actual);
}
/// <summary>
/// Gets the report info by id.
/// </summary>
/// <param name="id">The id.</param>
/// <returns></returns>
public ReportInfo GetReportInfoById(int id)
{
if (_reportInfoDict == null)
{
_reportInfoDict = new Dictionary <int, ReportInfo>();
var infos = StandardReportRepository.GetReportInfo();
foreach (var reportInfo in infos)
{
if (!_reportInfoDict.ContainsKey(reportInfo.ReportId))
{
_reportInfoDict.Add(reportInfo.ReportId, reportInfo);
}
}
}
if (_reportInfoDict.ContainsKey(id))
{
return(_reportInfoDict[id]);
}
return(new ReportInfo(string.Empty, string.Empty, -1, string.Empty, string.Empty, string.Empty, string.Empty));
}
