var day= getDay(getToday());
var userVO = getUserById(getWebUser().getId());//获取用户对象
var dept = userVO.getDepartments();//获取用户所属部门,这里返回的是用户所属的所有部门
var name="";
for(var iter = dept.iterator();iter.hasNext();)
{
var value1 = iter.next();
name +=value1.getName()+";"
}
name;
if(day<='05'){
"select ITEM_ZB_NAME , ITEM_ZB_DW, ITEM_PART_QIANT, ITEM_ZB_XINGZ,DOMAINID,ID from TLK_A指标库添加 where ITEM_ZB_TYPE like '%考核%' ";
}else{
"select ITEM_ZB_NAME , ITEM_PART_QIANT, ITEM_ZB_DW, ITEM_ZB_XINGZ,DOMAINID,ID from TLK_A指标库添加 where ITEM_ZB_TYPE like '%查不出来%' ";
}
SQL程序是这样写的,试图4列的脚本下面这样的getItemValueAsString("ZB_NAME");var userVO = getUserById(getWebUser().getId());//获取用户对象
var dept = userVO.getDepartments();//获取用户所属部门,这里返回的是用户所属的所有部门
var name="";
for(var iter = dept.iterator();iter.hasNext();)
{
var value1 = iter.next();
name +=value1.getName()+";"
}
name;
getItemValueAsString("ZB_DW");getItemValueAsString("ZB_XINGZ");麻烦你帮我看看哪里有错 |