SELECT  *    FROM    
[dbo].[WZ_DETAIL]                    
    where 1=1
 ${if(len(参数1)==0,""," and c_name  like '%"+参数1+"%'")}
 ${if(len(参数2)==0,""," and wz_name  like '%"+参数2+"%'")}
  ${if(len(参数3)==0,""," and descshort like '%"+参数3+"%'")}
 ${if(len(参数4)==0,""," and desclong like '%"+参数4+"%'")}

   SELECT  *    FROM    [dbo].[WZ_DETAIL]                    

    where

        c_name like '%${cs}%'

      and  wz_name like '%${cs1}%'

       and  descshort like '%${cs2}%'

        and desclong like '%${cs3}%'

SELECT  *    FROM    [dbo].[WZ_DETAIL]                    

    where

        c_name like '%${xxxx1}%'

      and  wz_name like '%${xxxx2}%'

       and  descshort like '%${xxxx3}%'

        and desclong like '%${xxxx4}%'

==========

SELECT  *    FROM    [dbo].[WZ_DETAIL]                    

    where 1=1

       ${if(len(xxxx1)=0,""," and c_name like '%"+xxxx1+"%'")}

       ${if(len(xxxx2)=0,""," and  wz_name like '%"+xxxx2+"%'")}

        ${if(len(xxxx3)=0,""," and  descshort like '%"+xxxx3+"%'")}

         ${if(len(xxxx4)=0,""," anddesclong like '%"+xxxx4+"%'")}

SELECT * FROM [dbo].[WZ_DETAIL]

WHERE (c_name LIKE '%${param}%' OR '${param}' IS NULL)

  AND (wz_name LIKE '%${param}%' OR '${param}' IS NULL)

------------

SELECT * FROM [dbo].[WZ_DETAIL]

WHERE 1=1

${if(len(param) == 0,"","AND c_name LIKE '%" + param + "%'")}

${if(len(param) == 0,"","AND wz_name LIKE '%" + param + "%'")}

${if(len(param) == 0,"","AND descshort LIKE '%" + param + "%'")}

${if(len(param) == 0,"","AND desclong LIKE '%" + param + "%'")}