${has(apid)?(" and apid=" + apid):""}
${has(status)?(" and sign_status=" + status):""}
这两句,似乎没错误。但其余的${}比这两句复杂,是不是调一下,这样写有没有问题:
select subscriberid,sign_name,sign_phone,apid,sign_card,Operate_Type,sign_status,createdate
from SubscriberInfo where 1=1
${has(apid)?(" and apid=" + apid):""}
${has(status)?(" and sign_status=" + status):""}