Пример #1
0
        public IEnumerable <Cmst> GetCmstListByIDCodeValDesc(GetCmstListByIDCodeValDescRequestApi getGetCmstListByIDCodeValDescRequestApi)
        {
            var where = new StringBuilder();
            where.Append($"cmst.codeiden = '{getGetCmstListByIDCodeValDescRequestApi.codeiden}'");

            if (!string.IsNullOrEmpty(getGetCmstListByIDCodeValDescRequestApi.codeval))
            {
                where.AppendFormatWithEscape(" AND cmst.codeval BEGINS '{0}'", getGetCmstListByIDCodeValDescRequestApi.codeval);
            }

            if (!string.IsNullOrEmpty(getGetCmstListByIDCodeValDescRequestApi.descrip))
            {
                where.AppendFormatWithEscape(" AND cmst.descrip BEGINS '{0}'", getGetCmstListByIDCodeValDescRequestApi.descrip);
            }

            if (!string.IsNullOrEmpty(getGetCmstListByIDCodeValDescRequestApi.slsrep))
            {
                where.AppendFormatWithEscape(" AND cmst.slsrep BEGINS '{0}'", getGetCmstListByIDCodeValDescRequestApi.slsrep);
            }

            return(this.cmstRepository.GetList(
                       where.ToString(),
                       getGetCmstListByIDCodeValDescRequestApi.batchsize,
                       getGetCmstListByIDCodeValDescRequestApi.fldlist));
        }
Пример #2
0
 public IEnumerable <Cmst> GetCmstListByIDCodeValDesc(GetCmstListByIDCodeValDescRequestApi GetCmstListByIDCodeValDescRequestApi)
 {
     return(this.cmstService.GetCmstListByIDCodeValDesc(GetCmstListByIDCodeValDescRequestApi));
 }