public IEnumerable <Sapb> GetSapbByReportFunction(GetSapbByReportFunctionRequestApi getSapbByReportFunctionRequestApi)
{
var where = new StringBuilder();
// Need to allow company 0 so don't default in current company
if (getSapbByReportFunctionRequestApi.cono > 0)
{
where.Append($"sapb.cono = {getSapbByReportFunctionRequestApi.cono}");
}
if (!string.IsNullOrWhiteSpace(getSapbByReportFunctionRequestApi.currproc))
{
if (where.ToString().Length > 0)
{
where.AppendFormat(" AND ");
}
where.AppendFormatWithEscape("sapb.currproc = '{0}'", getSapbByReportFunctionRequestApi.currproc);
}
if (!string.IsNullOrWhiteSpace(getSapbByReportFunctionRequestApi.reportnm))
{
if (where.ToString().Length > 0)
{
where.AppendFormat(" AND ");
}
where.AppendFormatWithEscape("sapb.reportnm BEGINS '{0}'", getSapbByReportFunctionRequestApi.reportnm);
}
return(this.sapbRepository.GetList(where.ToString(), getSapbByReportFunctionRequestApi.batchsize, getSapbByReportFunctionRequestApi.fldlist));
}
public IEnumerable <Sapb> GetSapbByReportFunction(GetSapbByReportFunctionRequestApi getSapbByReportFunctionRequestApi)
{
return(this.sapbService.GetSapbByReportFunction(getSapbByReportFunctionRequestApi));
}
