Beispiel #1
0
        public IEnumerable <Swsj> ListSwsjByTypePCatChargeOEType(ListSwsjByTypePCatChargeOETypeRequestApi criteria)
        {
            var where = new StringBuilder();
            where.AppendFormatWithEscape("swsj.cono = {0}", this.swsjRepository.Cono);
            if (!string.IsNullOrWhiteSpace(criteria.jobtype))
            {
                where.AppendFormatWithEscape(" AND swsj.jobtype = '{0}'", criteria.jobtype);
            }
            if (!string.IsNullOrWhiteSpace(criteria.oetype) && criteria.oetype.ToLower() != "b")
            {
                where.AppendFormatWithEscape(" AND swsj.gentype = {0}", criteria.oetype.ToLower() == "s" ? "true" : "false");
            }
            if (!string.IsNullOrWhiteSpace(criteria.prodcat))
            {
                where.AppendFormatWithEscape(" AND swsj.prodcat = '{0}'", criteria.prodcat);
            }
            if (!string.IsNullOrWhiteSpace(criteria.warrantycd) && criteria.warrantycd.ToLower() != "a")
            {
                where.AppendFormatWithEscape(" AND swsj.warrantycd = '{0}'", criteria.warrantycd.ToLower());
            }

            return(this.swsjRepository.GetList(where.ToString(), criteria.batchsize, criteria.fldlist));
        }
Beispiel #2
0
 public IEnumerable <Swsj> ListSwsjByTypePCatChargeOEType(ListSwsjByTypePCatChargeOETypeRequestApi criteria)
 {
     return(this.swsjService.ListSwsjByTypePCatChargeOEType(criteria));
 }