예제 #1
0
        public IEnumerable <Icsec> GetIcsecsByTypeProdAltProd(
            GetIcsecsByTypeProdAltProdRequestApi getIcsecsByTypeProdAltProdRequestApi)
        {
            var where = new StringBuilder();
            where.Append($"icsec.cono = {this.icsecRepository.Cono}");

            if (!string.IsNullOrEmpty(getIcsecsByTypeProdAltProdRequestApi.rectype))
            {
                where.AppendFormatWithEscape(" and icsec.rectype = '{0}'", getIcsecsByTypeProdAltProdRequestApi.rectype);
            }

            if (!string.IsNullOrEmpty(getIcsecsByTypeProdAltProdRequestApi.prod))
            {
                where.AppendFormatWithEscape(" and icsec.prod = '{0}'", getIcsecsByTypeProdAltProdRequestApi.prod);
            }

            if (!string.IsNullOrEmpty(getIcsecsByTypeProdAltProdRequestApi.altprod))
            {
                where.AppendFormatWithEscape(" and icsec.altprod = '{0}'", getIcsecsByTypeProdAltProdRequestApi.altprod);
            }

            return(this.icsecRepository.GetList(
                       where.ToString(),
                       getIcsecsByTypeProdAltProdRequestApi.batchsize,
                       getIcsecsByTypeProdAltProdRequestApi.fldlist));
        }
예제 #2
0
 public IEnumerable <Icsec> GetIcsecsByTypeProdAltProd(GetIcsecsByTypeProdAltProdRequestApi getIcsecsByTypeProdAltProdRequestApi)
 {
     return(this.icsecService.GetIcsecsByTypeProdAltProd(getIcsecsByTypeProdAltProdRequestApi));
 }