예제 #1
0
        public IEnumerable <Pick> GetPicksByZone(GetTWLPicksApi getTWLPicksApi)
        {
            var sb = new StringBuilder();

            if (!string.IsNullOrWhiteSpace(getTWLPicksApi.coNum))
            {
                sb.AppendFormatWithEscape("pick.co_num = '{0}'", getTWLPicksApi.coNum);
                if (!string.IsNullOrWhiteSpace(getTWLPicksApi.whNum))
                {
                    sb.AppendFormatWithEscape(" AND pick.wh_num = '{0}'", getTWLPicksApi.whNum);
                }
                if (!string.IsNullOrWhiteSpace(getTWLPicksApi.whZone))
                {
                    sb.AppendFormatWithEscape(" AND pick.wh_zone = '{0}'", getTWLPicksApi.whZone);
                }
            }
            var where = sb.ToString();
            return(this.pickRepository.GetList(where, getTWLPicksApi.batchsize, getTWLPicksApi.fldlist));
        }
예제 #2
0
 public IEnumerable<Pick> GetTWLZones(GetTWLPicksApi getTWLPicksApi)
 {
    return this.pickService.GetPicksByZone(getTWLPicksApi);
 }