Esempio n. 1
0
        public IEnumerable <Binmst> GetTWLBinsNotActive(GetTWLBinsNotActiveApi getTWLBinsNotActiveApi)
        {
            var sb = new StringBuilder();

            if (!string.IsNullOrWhiteSpace(getTWLBinsNotActiveApi.coNum))
            {
                sb.AppendFormatWithEscape("binmst.co_num = '{0}'", getTWLBinsNotActiveApi.coNum);
                if (!string.IsNullOrWhiteSpace(getTWLBinsNotActiveApi.whNum))
                {
                    sb.AppendFormatWithEscape(" AND binmst.wh_num = '{0}'", getTWLBinsNotActiveApi.whNum);
                }
                sb.AppendFormatWithEscape(" AND binmst.row_status = false");
            }
            var where = sb.ToString();
            return(this.binmstRepository.GetList(where, getTWLBinsNotActiveApi.batchsize, getTWLBinsNotActiveApi.fldlist));
        }
Esempio n. 2
0
 public IEnumerable <Binmst> GetTWLBinsNotActive(GetTWLBinsNotActiveApi getTWLBinsNotActiveApi)
 {
     return(this.binmstService.GetTWLBinsNotActive(getTWLBinsNotActiveApi));
 }