GZRYFWJ(提问者)select A.SQDSID,c.cinvcode,c.cinvname+\'\'+c.cinvaddcode+\'\'+cinvstd+\'\'+B.cfree1 AS NAME from
FWJ_AZSQD_HZ A INNER JOIN FWJ_AZSQDS B ON A.SQDSID=B.AUTOID
LEFT JOIN ufdata_001_2019..inventory c ON B.CINVCODE=C.CINVCODE
where 1=1 AND c.cinvcode is not null AND
( c.cinvcode =\'0\'
${if(len(cinv) == 0,\" and A.SQDSID=\'0\' \",\" OR A.SQDSID in ( \'\" + cinv + \"\')\")}
)
现在我通过传递参数来显示啦,下拉框选择多个商品时,复选框里就不能显示 啦