Exemple #1
0
        public IEnumerable <Sasr> GetSasrDetails(GetSasrDetailsRequestApi getGetSasrDetailsRequestApi)
        {
            var where = new StringBuilder();
            where.Append($"sasr.cono = {this.sasrRepository.Cono}");

            if (!string.IsNullOrEmpty(getGetSasrDetailsRequestApi.whse))
            {
                where.AppendFormatWithEscape(" AND sasr.whse = '{0}'", getGetSasrDetailsRequestApi.whse);
            }
            else
            {
                where.AppendFormat(" AND sasr.whse = ''");
            }

            if (!string.IsNullOrEmpty(getGetSasrDetailsRequestApi.shipvia))
            {
                where.AppendFormatWithEscape(" AND sasr.shipvia = '{0}'", getGetSasrDetailsRequestApi.shipvia);
            }

            if (!string.IsNullOrEmpty(getGetSasrDetailsRequestApi.zone))
            {
                where.AppendFormatWithEscape(" AND sasr.zone = '{0}'", getGetSasrDetailsRequestApi.zone);
            }

            return(this.sasrRepository.GetList(
                       where.ToString(),
                       getGetSasrDetailsRequestApi.batchsize,
                       getGetSasrDetailsRequestApi.fldlist));
        }
Exemple #2
0
 public IEnumerable <Sasr> GetSasrDetails(GetSasrDetailsRequestApi GetSasrDetailsRequestApi)
 {
     return(this.sasrService.GetSasrDetails(GetSasrDetailsRequestApi));
 }