public IEnumerable <Kpsg> GetGroupsByGroupNameAndSequenceNumber(GetGroupsByGroupNameAndSequenceNumberRequestApi getGetGroupsByGroupNameAndSequenceNumberRequestApi) { var where = new StringBuilder(); where.Append($"kpsg.cono = {this.kpsgRepository.Cono}"); if (!string.IsNullOrEmpty(getGetGroupsByGroupNameAndSequenceNumberRequestApi.groupname)) { where.AppendFormatWithEscape(" AND kpsg.groupname = '{0}'", getGetGroupsByGroupNameAndSequenceNumberRequestApi.groupname); } else { where.AppendFormat(" AND kpsg.groupname = ''"); } if (getGetGroupsByGroupNameAndSequenceNumberRequestApi.seqno != 0) { where.AppendFormatWithEscape(" AND kpsg.seqno = {0}", getGetGroupsByGroupNameAndSequenceNumberRequestApi.seqno); } return(this.kpsgRepository.GetList( where.ToString(), true, getGetGroupsByGroupNameAndSequenceNumberRequestApi.batchsize, getGetGroupsByGroupNameAndSequenceNumberRequestApi.fldlist)); }
public IEnumerable <Kpsg> GetGroupsByGroupNameAndSequenceNumber(GetGroupsByGroupNameAndSequenceNumberRequestApi getGroupsByGroupNameAndSequenceNumberRequestApi) { return(this.kpsgService.GetGroupsByGroupNameAndSequenceNumber(getGroupsByGroupNameAndSequenceNumberRequestApi)); }