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