SELECT * from ${if(ls="否","(SELECT count(*) as 来单 from ${if(len(qy)=0&&len(fb)=0,"dm_sj_ld",if(len(qy)<>0&&len(fb)=0,"dm_sj_ld","dm_sj_ld_sjs"))} where xldrq BETWEEN '${startdate}' and '${enddate}'${if(len(qy)=0,"and 1=1","and qyjc2='"+qy+"'")}${if(len(fb)=0,"and 1=1","AND fbjc2=N'"+fb+"'")}${if(len(qd)=0,"and 1=1","AND qdgsbm in (N'"+qd+"')")})a","(SELECT count(*) as 交订 from ${if(len(qy)=0&&len(fb)=0,"dm_sj_jd",if(len(qy)<>0&&len(fb)=0,"dm_sj_jd","dm_sj_jd_sjs"))} where xjdrq BETWEEN '${startdate}' and '${enddate}' ${if(len(qy)=0,"and 1=1","and qyjc2='"+qy+"'")}${if(len(fb)=0,"and 1=1","AND fbjc2=N'"+fb+"'")}${if(len(qd)=0,"and 1=1","AND qdgsbm in (N'"+qd+"')")})b")}
