我想定义一个下拉树查询,但是父级下面的内容怎么都一样 图片有我添加的数据集 和参数 能否帮我解决一下
SELECT * FROM `0513` where 1=1 and ${if(len(Area)==0,""," CITYCODE = '"+treelayer(Area)+"'")}
and whetherConfirmOffer = '${whetherConfirmOffer}'
${if(whetherConfirmOffer == 1,"and CONFIRMTIME > '"+cstart+"' and CONFIRMTIME '"+rstart+"' and receiveTime < '"+rend+"'")}