Пример #1
0
        public IEnumerable <Prodcat> GetTWLProdcats(GetTWLProdcatsApi getTWLProdcatsApi)
        {
            var sb = new StringBuilder();

            if (!string.IsNullOrWhiteSpace(getTWLProdcatsApi.coNum))
            {
                sb.AppendFormatWithEscape("prodcat.co_num = '{0}'", getTWLProdcatsApi.coNum);
                if (!string.IsNullOrWhiteSpace(getTWLProdcatsApi.whNum))
                {
                    sb.AppendFormatWithEscape(" AND prodcat.wh_num = '{0}'", getTWLProdcatsApi.whNum);
                    if (!string.IsNullOrWhiteSpace(getTWLProdcatsApi.prodcat))
                    {
                        sb.AppendFormatWithEscape(" AND prodcat.prodcat = '{0}'", getTWLProdcatsApi.prodcat);
                    }
                }
            }
            var where = sb.ToString();
            return(this.prodcatRepository.GetList(where, getTWLProdcatsApi.batchsize, getTWLProdcatsApi.fldlist));
        }
Пример #2
0
 public IEnumerable <Prodcat> GetTWLProdcats(GetTWLProdcatsApi getTWLProdcatsApi)
 {
     return(this.prodcatService.GetTWLProdcats(getTWLProdcatsApi));
 }