Пример #1
0
        public IEnumerable <Icseps> GetListByPk(IcsepsGetListByPkRequestApi icsepsGetListByPkRequestApi)
        {
            var sb = new StringBuilder();

            sb.AppendFormatWithEscape("icseps.cono = {0}", this.repository.Cono);
            if (string.IsNullOrEmpty(icsepsGetListByPkRequestApi.whse))
            {
                sb.AppendFormatWithEscape(" AND icseps.whse = '{0}'", icsepsGetListByPkRequestApi.whse);
            }
            sb.AppendFormatWithEscape(" AND icseps.runno = {0}", icsepsGetListByPkRequestApi.runno);
            if (string.IsNullOrEmpty(icsepsGetListByPkRequestApi.prod))
            {
                sb.AppendFormatWithEscape(" AND icseps.prod = '{0}'", icsepsGetListByPkRequestApi.prod);
            }
            if (string.IsNullOrEmpty(icsepsGetListByPkRequestApi.serialno))
            {
                sb.AppendFormatWithEscape(" AND icseps.serialno = '{0}'", icsepsGetListByPkRequestApi.serialno);
            }
            sb.AppendFormatWithEscape(" AND icseps.unavailfl = {0}", icsepsGetListByPkRequestApi.unavailfl);
            var where = sb.ToString();
            return(this.repository.GetList(where, icsepsGetListByPkRequestApi.batchsize, icsepsGetListByPkRequestApi.fldlist));
        }
Пример #2
0
 public IEnumerable <Icseps> GetListByPk(IcsepsGetListByPkRequestApi icsepsGetListByPkRequestApi)
 {
     return(this.service.GetListByPk(icsepsGetListByPkRequestApi));
 }