${if(len(STRU_CODE) == 0, "", "AND A.BMEM_ID LIKE '%" + STRU_CODE + "%'")}
${if(len(ORDER_ID) == 0, "", " AND A.ORDER_ID LIKE '%" + ORDER_ID + "%'")}
${if(len(SMEM_ID) == 0, "", " AND A.SMEM_ID LIKE '%" + SMEM_ID + "%'")}
${if(len(SNAME) == 0, "", " AND A.SNAME LIKE '%" + SNAME + "%'")}
${if(len(BMEM_ID) == 0, "", " AND A.BMEM_ID LIKE '%" + BMEM_ID + "%'")}
${if(len(BNAME) == 0, "", " AND A.BNAME LIKE '%" + BNAME + "%'")}
${if(len(BEGIN_DATE) == 0, "", " AND A.DOWN_DATE >= '" + BEGIN_DATE + "'")}
${if(len(END_DATE) == 0, "", " AND A.DOWN_DATE <= '" + END_DATE + "'")}
需要这样的格式写,以及传的参数需要'${comId}'这样的格式
标签:传参,软中,LIKE,len,ORDER,sql,DATE,ID,BMEM From: https://www.cnblogs.com/lihao-manongyimei/p/17319001.html