Gorm错误

来源：互联网发布：淘宝盗图申诉原图制作编辑：程序博客网时间：2024/05/28 09:31

groovy.lang.MissingPropertyException: No such property: skuId for class: grails.orm.HibernateCriteriaBuilder
at com.zy.wms.aftersale.ReturnOnShelfInfo$_search_closure1$$EQKQrfqf.doCall(ReturnOnShelfInfo.groovy:46)
at com.zy.wms.aftersale.ReturnOnShelfInfo$$EQKQrfqf.search(ReturnOnShelfInfo.groovy:56)
at com.zy.wms.warehouse.GoodsStockDetailController.returnOnShelfInfoListData(GoodsStockDetailController.groovy:638)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

static search(params){        def searchClosure = {            if (params.qOrderStartDate) {                ge('gmtCreated', DateUtils.getSecondFromDateString(params.qOrderStartDate as String, "MM/dd/yyyy"))            }            if (params.qOrderEndDate) {                lt('gmtCreated', DateUtils.getSecondFromDateString(params.qOrderEndDate as String, "MM/dd/yyyy") + 86400)            }            if(params.qStatus) {                eq('status',params.qStatus as Integer)            }            if(params.qReturnOnShelfQTypeText){                if(params.qReturnOnShelfQType=='1'){                    eq('onShelfSn',params.qReturnOnShelfQTypeText)                }else if(params.qReturnOnShelfQType=='2'){                    returnOnShelfGoods(eq(skuId,params.qReturnOnShelfQTypeText))                }            }            if(params.qDepotId){                eq('depotId',params.qDepotId as Long)            }        }        def c = ReturnOnShelfInfo.createCriteria()        return c.list(params,searchClosure)    }

解决后代码：

static search(params){        def searchClosure = {            if (params.qOrderStartDate) {                ge('gmtCreated', DateUtils.getSecondFromDateString(params.qOrderStartDate as String, "MM/dd/yyyy"))            }            if (params.qOrderEndDate) {                lt('gmtCreated', DateUtils.getSecondFromDateString(params.qOrderEndDate as String, "MM/dd/yyyy") + 86400)            }            if(params.qStatus) {                eq('status',params.qStatus as Integer)            }            if(params.qReturnOnShelfQTypeText){                if(params.qReturnOnShelfQType=='1'){                    eq('onShelfSn',params.qReturnOnShelfQTypeText)                }                if(params.qReturnOnShelfQType=='2'){                    returnOnShelfGoods {                        eq("skuId",params.qReturnOnShelfQTypeText as Long)                    }                }            }            if(params.qDepotId){                eq('depotId',params.qDepotId as Long)            }        }        def c = ReturnOnShelfInfo.createCriteria()        return c.list(params,searchClosure)    }

阅读全文

0 0