Пример #1
0
        public IEnumerable <Shpmst> GetTWLShpmst(string coNum, string whNum, int manifestId, int batchsize = 0, string fldlist = "")
        {
            var getTWLShpmstApi = new GetTWLShpmstApi()
            {
                coNum      = coNum,
                whNum      = whNum,
                manifestId = manifestId,
                batchsize  = batchsize,
                fldlist    = fldlist
            };

            return(this.shpmstService.GetTWLShpmst(getTWLShpmstApi));
        }
Пример #2
0
        public IEnumerable <Shpmst> GetTWLShpmst(GetTWLShpmstApi getTWLShpmstApi)
        {
            var sb = new StringBuilder();

            if (!string.IsNullOrWhiteSpace(getTWLShpmstApi.coNum))
            {
                sb.AppendFormatWithEscape("shpmst.co_num = '{0}'", getTWLShpmstApi.coNum);
                if (!string.IsNullOrWhiteSpace(getTWLShpmstApi.whNum))
                {
                    sb.AppendFormatWithEscape(" AND shpmst.wh_num = '{0}'", getTWLShpmstApi.whNum);
                }
                if (!string.IsNullOrWhiteSpace(getTWLShpmstApi.carrierId))
                {
                    sb.AppendFormatWithEscape(" AND shpmst.carrier_id = '{0}'", getTWLShpmstApi.carrierId);
                }
                if (getTWLShpmstApi.manifestId > 0)
                {
                    sb.AppendFormatWithEscape(" AND shpmst.manifest_id = '{0}'", getTWLShpmstApi.manifestId);
                }
            }
            var where = sb.ToString();
            return(this.shpmstRepository.GetList(where, getTWLShpmstApi.batchsize, getTWLShpmstApi.fldlist));
        }
Пример #3
0
 public IEnumerable <Shpmst> GetTWLShpmst(GetTWLShpmstApi getTWLShpmstApi)
 {
     return(this.shpmstService.GetTWLShpmst(getTWLShpmstApi));
 }