计划作务:VeryDateJob.java
泛微系统表 : 登录页模板表SystemLoginTemplate
建模表:锁定前端日期 uf_nice_qian_duan
select top 1 b.FQianDuan
from SystemLoginTemplate a
inner join uf_nice_qian_duan b on a.loginTemplateId = b.FQianDuan
where b.FStartDate <= convert(varchar(10),Getdate(),120)
and b.FEndDate >= convert(varchar(10),Getdate(),120)
and b.FState = 1 and b.FQianDuan is not null and b.FQianDuan <> ''
----------------------------------------------------------------------------------------------------------
select * from uf_nice_qian_duan