rwl(提问者) 回复 CD20160914SELECT * FROM pipei where 1=1 and
billing_time >= \'${sdate}\' and billing_time <= \'${edate}\'
${if (len(invoff_fapoff)==0,\"\",\"and invoff_fapoff in (\'\"+invoff_fapoff+\"\')\")}
${if (len(fappaytitle_fappay)==0,\"\",\"and fappaytitle_fappay in (\'\"+fappaytitle_fappay+\"\')\")}
${if (len(billname_fapaytitle)==0,\"\",\"and billname_fapaytitle in (\'\"+billname_fapaytitle+\"\')\")}