回复 2# tomzxd 这个问题 用公式好像没办法解决,我是这样搞定的,写了一个类似于JAVA链接类,然后再页面中调用这个类,附上页面的代码参考,希望对你有帮助
try {
var yj=getComponent("inputTextarea1").getValue(); //获取审批意见
var tlname = getComponent("teamlead").getValue(); //获取项目经理
var singname=session.getEffectiveUserName();
print(singname);
var sql = "update sfcrepairmain set teamleadidea = '2',teamleadyj=" + "'"+ yj +"'"+",tlcreatedate=getdate(),tlname ="+"'"+ singname +"'"+"where sysserialno = '" + ssn + "'"+ "and createdate = '"+ createdate+"'";
if(sql) {
var st = dbUtil.getConnection().createStatement();
var c=st.executeUpdate(sql);
//var c = @JdbcExecuteQuery('mssql',sql)
@InfoMessage("Record updated: "+c);
getComponent("radioGroup2").setValue("2");
context.reloadPage();
st.close();
//context.redirectToHome();
//return false;
} else {
@ErrorMessage("Please, enter an id");
}
}catch(e){
@ErrorMessage(e);
}