错误信息:;
字段一:var user=getWebUser().getName();
var doc=getCurrentDocument();
var author=doc.getAuthor().getId();
var sql="select a.name as item_name,a.id as item_phbmid,a.domainid from t_department a,t_user_department_set b where a.id = b.departmentid and b.userid = '" + author + "'";
var bm = findBySQL(sql);
var request = $WEB.getParamsTable().getHttpRequest();
request.getSession().setAttribute("phbm",bm.getItemValueAsString("phbmid"));
var b=getCurrentDocument().getCreated();
var month= format(b,"yyyy-MM");
var a = bm.getItemValueAsString("name")+"填报"+month+"月配合部门预警指标";
a;
字段二:
var datas=getItemValue("填写信息");
var myArray=new Array();
myArray=splitString(datas,"报");
for(var n = 0 ;n<=1; n++){
myArray[n]
};
var request = $WEB.getParamsTable().getHttpRequest();
request.getSession().setAttribute("zbrq",myArray[1].substring(0,7));
字段三:
var qtbm=getItemValueAsString("牵头部门");
var rtn=getParameter("bm");
if(qtbm!=null && qtbm.trim().length()<=0)
{
qtbm=rtn;
}
var request = $WEB.getParamsTable().getHttpRequest();
request.getSession().setAttribute("phyjqt",qtbm);
qtbm;
视图过滤用存储过程:var zb_qtbm ="";
var zb_bm="";
var zb_rq="";
var p_mc1=""; //作者部门id
var p_mc2="";//日期
var p_mc3="";//牵头部门
var request = $WEB.getParamsTable().getHttpRequest();
var a =getSession();
println("++a++"+a);
println("+++request"+request);
if(request != null && a != null){
zb_bm=request.getSession().getAttribute("phbm");
zb_rq =request.getSession().getAttribute("zbrq");
zb_qtbm=request.getSession().getAttribute("phyjqt");
}
//获取当前登录用户对象和创建时间
if(zb_bm != null && zb_bm !=""){
p_mc1 = zb_bm;
}
if(zb_rq != null&&zb_rq !="" ){
p_mc2=zb_rq;
}
if(zb_qtbm != null&& zb_qtbm !=""){
p_mc3=zb_qtbm;
}
var doc =getParentDocument();
var qj= doc.getItemValueAsString("牵头部门门");
println("++++qj++++"+qj);
"call SP_phyj.pro_phyj(string:"+p_mc1+",string:"+p_mc2+",string:"+p_mc3+",out:package)"; |