copyofAFN天线滤波器绑定查询

最新推荐文章于 2025-12-21 21:47:42 发布

原创最新推荐文章于 2025-12-21 21:47:42 发布 · 227 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#java #服务器 #前端

select SN AS 天线序列号，[TOP] as TOP 滤波器内部序列号,
(SELECT CustomerSN from CustomerSN b where b.sn=a.[TOP]
--AND 1=1${if(len(TOP滤波器客户序列号)==0,"","and CustomerSN=('"+TOP滤波器客户序列号+”’)")})asTOP滤波器客户序列号，
BOTTOM as BOTTOM 滤波器内部序列号,
（SELECT CustomerSN from CustomerSN b where b.sn=a.[BOTTOM]
--AND 1=1${if(len(BOTTOM滤波器客户序列号)==0,"","
and CustomerSN=('"+BOTTOM滤波器序列号+"')")})
as BOTTOM滤波器客户序列号，
CreatedTime as 绑定时间，CreatName as绑定人员，ModifiedTime as修改时间,ModifierName as 修改人员,
(case when Status='0'then'0:已解绑'else'其他'end)as状态 from AntennaSN a where 1=1${if(len(天线序列号)==0,"","and SN IN('" +replace(天线序列号,",","','")+"')","")}
AND 1=1${if(len(TOP滤波器)==0,"","and[TOP]in ('" +replace(TOP滤波器内部序列号,",","','")+"')","")}
AND 1=1${if(len(BOTTOM滤波器内部序列号)==0,"","and BOTTOM in('"+replace(BOTTOM滤波器内部序列号,",","','")+"')","")}
order by CreatedTime