Beispiel #1
0
        public IEnumerable <Slsp> GetSlspListByKeys(GetSlspListByKeysRequestApi getGetSlspListByKeysRequestApi)
        {
            var where = new StringBuilder();
            where.Append($"slsp.cono = {this.slspRepository.Cono}");

            if (!string.IsNullOrEmpty(getGetSlspListByKeysRequestApi.imptype))
            {
                where.AppendFormatWithEscape(" AND slsp.imptype = '{0}'", getGetSlspListByKeysRequestApi.imptype);
            }

            if (!string.IsNullOrEmpty(getGetSlspListByKeysRequestApi.slgroup))
            {
                where.AppendFormatWithEscape(" AND slsp.slgroup = '{0}'", getGetSlspListByKeysRequestApi.slgroup);
            }

            if (!string.IsNullOrEmpty(getGetSlspListByKeysRequestApi.whse))
            {
                where.AppendFormatWithEscape(" AND slsp.whse = '{0}'", getGetSlspListByKeysRequestApi.whse);
            }

            return(this.slspRepository.GetList(
                       where.ToString(),
                       getGetSlspListByKeysRequestApi.batchsize,
                       getGetSlspListByKeysRequestApi.fldlist));
        }
Beispiel #2
0
 public IEnumerable <Slsp> GetSlspListByKeys(GetSlspListByKeysRequestApi GetSlspListByKeysRequestApi)
 {
     return(this.slspService.GetSlspListByKeys(GetSlspListByKeysRequestApi));
 }