where 1=1 ${if(len(城市) == 0,"","and a.source_name in ( '" + 城市 + "')")} ${if(len(事业部) == 0,"","and a.type1 in ( '" + 事业部 + "')")} ${if(len(库龄结构) == 0,"","and a.kc_type in ( '" + 库龄结构 + "')")} ${if(len(效期结构) == 0,"","and a.xq_type in ( '" + 效期结构 + "')")} ${if(len(预算单元) == 0,"","and a.org_name in ( '" + 预算单元 + "')")} ${if(len(库存金额大于) == 0,"","and a.kc_amt >= ( '" + 库存金额大于 + "')")} ${if(len(商品id) == 0,"","and a.product_code in ( '" + 商品id + "')")} |
1min目标场景问卷
立即参与
