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));
}