控件1的名称是 lotId_ 控件2的名称是lotId_2
参数${if(len(lotid) == 0,"","and LOT.lotId in ('" + lotId_+ "','" + lotid1 + "')")}
这个查询条件要怎么写啊 各位大佬
分两个写有问题。
where 0=1
${if(len(lotid_)>0,"or LOT.lotId in ('"+lotId_+"')",'')}
${if(len(lotid_2)>0,"or LOT.lotId in ('"+lotId_2+"')",'')}
我看你是文本框,模糊查询也可以了?试一试
where 1=1
and ( LOT.lotId like '%${lotId1}%' or LOT.lotId like '%${lotId2}%' )
${if(len(lotid_) == 0,if(len(lotid_2) == 0,"","and LOT.lotId = '" + lotId_2+ "'"), "and LOT.lotId = '" + lotId_+ "'or LOT.lotId='"+lotId_2+"'")} 这样应该可以了 大哥,你这参数有点乱啊