Exemple #1
0
        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));
        }
Exemple #2
0
 public IEnumerable <Kpsg> GetGroupsByGroupNameAndSequenceNumber(GetGroupsByGroupNameAndSequenceNumberRequestApi getGroupsByGroupNameAndSequenceNumberRequestApi)
 {
     return(this.kpsgService.GetGroupsByGroupNameAndSequenceNumber(getGroupsByGroupNameAndSequenceNumberRequestApi));
 }