SELECT 客户,现场,线体,设备名,分类,关键指标 

FROM dbo.设备关键指标达成情况跟踪表 

WHERE 1=1

${IF(LEN(参数名1)=0,"","AND 客户='"+参数名1+"'")}

${IF(LEN(参数名2)=0,"","AND 现场='"+参数名2+"'")}

${IF(LEN(参数名3)=0,"","AND 线体='"+参数名3+"'")}

${IF(LEN(参数名4)=0,"","AND 设备名='"+参数名4+"'")}

${IF(LEN(参数名5)=0,"","AND 分类='"+参数名5+"'")}

${IF(LEN(参数名6)=0,"","AND 关键指标='"+参数名6+"'")}

GROUP BY 客户,现场,线体,设备名,分类,关键指标