通过远程 已解决;
代码如下,供大家参考:
var value1=format(getToday(),"yyyy-MM-dd");
var sql="select a.id,'"+getDomainid()+"' as domainid,b.title as item_title,b.content as item_content,a.isinbox,a.isread,a.senddate,a.receiverid from ccobpm.dbo.t_personalmessage a,ccobpm.dbo.t_messagebody b where a.bodyid=b.id and b.title='还证提醒' and convert(varchar(10),senddate,120) like '"+value1+"%' and a.isinbox='1' and a.isread='0' and a.receiverid='"+getWebUser().getId()+"'";
println(sql+" ======sql====");
sql; |