public IEnumerable <Icamue> GetIcamueList(GetIcamueListRequestApi getGetIcamueListRequestApi) { var where = new StringBuilder(); where.Append($"icamue.cono = {this.icamueRepository.Cono}"); where.AppendFormatWithEscape(" AND icamue.activefl = {0}", getGetIcamueListRequestApi.activefl); if (!string.IsNullOrEmpty(getGetIcamueListRequestApi.whse)) { where.AppendFormatWithEscape(" AND icamue.whse = '{0}'", getGetIcamueListRequestApi.whse); } if (!string.IsNullOrEmpty(getGetIcamueListRequestApi.buyer)) { where.AppendFormatWithEscape(" AND icamue.buyer = '{0}'", getGetIcamueListRequestApi.buyer); } if (!string.IsNullOrEmpty(getGetIcamueListRequestApi.prod)) { where.AppendFormatWithEscape(" AND icamue.prod = '{0}'", getGetIcamueListRequestApi.prod); } if (!string.IsNullOrEmpty(getGetIcamueListRequestApi.frozentype)) { where.AppendFormatWithEscape(" AND icamue.frozentype = '{0}'", getGetIcamueListRequestApi.frozentype); } if (!string.IsNullOrEmpty(getGetIcamueListRequestApi.exceptlist)) { where.AppendFormatWithEscape(" AND can-do('{0}',icamue.exctype)", getGetIcamueListRequestApi.exceptlist); } return(this.icamueRepository.GetList( where.ToString(), getGetIcamueListRequestApi.batchsize, getGetIcamueListRequestApi.fldlist)); }
public IEnumerable <Icamue> GetIcamueList(GetIcamueListRequestApi GetIcamueListRequestApi) { return(this.icamueService.GetIcamueList(GetIcamueListRequestApi)); }