public IEnumerable <Notes> GetSasuNotes(GetSasuNotesApi getSasuNotesApi) { var where = new StringBuilder(); where.Append($"cono = {getSasuNotesApi.cono}"); where.AppendFormatWithEscape(" AND notes.notestype = '{0}'", getSasuNotesApi.notestype); if (!string.IsNullOrWhiteSpace(getSasuNotesApi.primarykey)) { where.AppendFormatWithEscape(" AND notes.primarykey = '{0}'", getSasuNotesApi.primarykey); } if (!string.IsNullOrWhiteSpace(getSasuNotesApi.secondarykey)) { where.AppendFormatWithEscape(" AND notes.secondarykey = '{0}'", getSasuNotesApi.secondarykey); } if (getSasuNotesApi.pageno > 0) { where.AppendFormatWithEscape(" AND notes.pageno = '{0}'", getSasuNotesApi.pageno); } return(this.notesRepository.GetList(where.ToString(), getSasuNotesApi.batchsize, getSasuNotesApi.fldlist)); }
public IEnumerable <Notes> GetSasuNotes(GetSasuNotesApi getSasuNotesApi) { return(this.notesService.GetSasuNotes(getSasuNotesApi)); }