直接在sql中判断一下参数是不是烟台了

where 1=1

${if(cs="烟台","and 字段名称 in('烟台','西安')","and 字段名称='"+cs+"'")}

select sum(je) from a 

where year='${year}' 

${if(yq='烟台',"and yq in('烟台','西安')","and yq='"+yq+"'")}

方法1：

where 1=1

and year = '${year}'

and （ case when '${yuanqu}' = '烟台' then yuanqu = '烟台' or yuanqu = '西安' else yuanqu = '${yuanqu}' end)

方法2：(union一个西安的，然后把union的西安改成烟台，这样烟台就多了一个西安的值，原来的西安的值也还在)

select year,'烟台',金额 from a where yuanqu = '西安'

union all

select * from a