public IEnumerable <Icsec> GetIcsecsByTypeKeyNoProdCustShipTo(
GetIcsecsByTypeKeyNoProdCustShipToRequestApi getIcsecsByTypeKeyNoProdCustShipToRequestApi)
{
var where = new StringBuilder();
where.Append($"icsec.cono = {this.icsecRepository.Cono}");
if (!string.IsNullOrEmpty(getIcsecsByTypeKeyNoProdCustShipToRequestApi.rectype))
{
where.AppendFormatWithEscape(" and icsec.rectype = '{0}'", getIcsecsByTypeKeyNoProdCustShipToRequestApi.rectype);
}
if (!string.IsNullOrEmpty(getIcsecsByTypeKeyNoProdCustShipToRequestApi.prod))
{
where.AppendFormatWithEscape(" and icsec.prod = '{0}'", getIcsecsByTypeKeyNoProdCustShipToRequestApi.prod);
}
if (getIcsecsByTypeKeyNoProdCustShipToRequestApi.keyno != decimal.MinValue)
{
where.AppendFormatWithEscape(" and icsec.keyno = {0}", getIcsecsByTypeKeyNoProdCustShipToRequestApi.keyno);
}
if (getIcsecsByTypeKeyNoProdCustShipToRequestApi.custno != decimal.MinValue)
{
where.AppendFormatWithEscape(" and icsec.custno = {0}", getIcsecsByTypeKeyNoProdCustShipToRequestApi.custno);
}
if (!string.IsNullOrEmpty(getIcsecsByTypeKeyNoProdCustShipToRequestApi.shipto))
{
where.AppendFormatWithEscape(" and icsec.shipto = '{0}'", getIcsecsByTypeKeyNoProdCustShipToRequestApi.shipto);
}
return(this.icsecRepository.GetList(
where.ToString(),
getIcsecsByTypeKeyNoProdCustShipToRequestApi.batchsize,
getIcsecsByTypeKeyNoProdCustShipToRequestApi.fldlist));
}
public bool GetIcsecsByTypeKeyNoProdCustShipTo(GetIcsecsByTypeKeyNoProdCustShipToRequestApi getIcsecsByTypeKeyNoProdCustShipToRequestApi)
{
List <Icsec> icsecEntities = this.icsecService.GetIcsecsByTypeKeyNoProdCustShipTo(getIcsecsByTypeKeyNoProdCustShipToRequestApi).ToList();
return(icsecEntities != null && icsecEntities.Count > 0);
}
