在帆软中sql的if语句以及传参的格式

${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}'这样的格式