public IEnumerable <Sastn> GetSastnList(GetSastnListRequestApi getGetSastnListRequestApi)
{
var where = new StringBuilder();
// First query - based on sastn.codeval. It should be numeric search criteria for this first query
// since sastn.codeval is an interger (but no Progress error occurs if alpha-numeric data is sent).
where.Append($"sastn.cono = {this.sastnRepository.Cono}");
if (!string.IsNullOrEmpty(getGetSastnListRequestApi.codeiden))
{
where.AppendFormatWithEscape(" AND sastn.codeiden = '{0}'", getGetSastnListRequestApi.codeiden);
}
if (!string.IsNullOrEmpty(getGetSastnListRequestApi.codeval))
{
where.AppendFormatWithEscape(" AND sastn.codeval >= '{0}'", getGetSastnListRequestApi.codeval);
}
return(this.sastnRepository.GetList(where.ToString(), getGetSastnListRequestApi.batchsize, getGetSastnListRequestApi.fldlist));
}
public IEnumerable <Sastn> GetSastnList(GetSastnListRequestApi GetSastnListRequestApi)
{
return(this.sastnService.GetSastnList(GetSastnListRequestApi));
}
