获取所有项目 __FDIGNpKZD4IqfM2Ji1G __FDIGNpKZD4IqfM2Ji1G published UTF-8 post /project json 0){ for(var pageiterator = pagedatas.iterator();pageiterator.hasNext();){ var map1 = pageiterator.next();//取值 var num= map1.get("num"); } } //page.put("sql",pagesql); page.put("pageNo",pageNo); page.put("pageSize",pageSize); page.put("total",num); if(isNotNull(unitname)){ whereStr += "and item_unitname = '"+unitname+"' "; } if(isNotNull(pageNo)&&isNotNull(pageSize)){ pageStr += " limit "+(parseInt(pageNo)-1)*pageSize+","+pageSize+" "; } if(isNotNull(projectName)){ whereStr += " and a.item_projectName like '%"+projectName+"%' "; } } var sql="select a.item_projectName,"+//项目名称 "a.id,"+ "if( ISNULL(c.id),0,1) as isStart,"+ "b.item_projectNumber,"+//项目编号 "b.item_ProjectManagername,"+ "a.item_unitname "+//所属单位 "from tlk_demandManagement a inner join tlk_ProjectPlan b on a.id=b.item_demandId LEFT JOIN tlk_starsproject c on a.id=c.item_projectId and c.item_userId = '"+getWebUser().getId()+"' where a.item_subStatus=1 "+whereStr+pageStr; var datas = queryByDSName("rtproject",sql); result.put("data",datas); result.put("page",page); // result.put("sql",sql); result.put("code","200"); result.put("msg","OK"); result.put("state", true); return result; })()]]>