NodesByWorkflowid.jsp
1.22 KB
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.ArrayList" %>
<%@page import="java.io.PrintWriter"%>
<%@page import="net.sf.json.JSONArray"%>
<%@page import="net.sf.json.JSONObject"%>
<%@page import="java.util.Map"%>
<%@page import="java.util.HashMap"%>
<%@ include file="/formmode/checkright4setting.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page"/>
<%
String workflowid = request.getParameter("workflowid");
PrintWriter writer = response.getWriter();
JSONArray array = new JSONArray();
rs.executeSql(" select b.id as triggerNodeId,a.nodeType as triggerNodeType,b.nodeName as triggerNodeName from workflow_flownode a,workflow_nodebase b where (b.IsFreeNode is null or b.IsFreeNode!='1') and a.nodeId=b.id and a.workFlowId= "+workflowid+" order by a.nodeorder,a.nodeType,a.nodeId ");
while(rs.next()) {
int temptriggerNodeId = rs.getInt("triggerNodeId");
String triggerNodeName = Util.null2String(rs.getString("triggerNodeName"));
JSONObject object2 = new JSONObject();
object2.put("name",triggerNodeName);
object2.put("value",temptriggerNodeId);
array.add(object2);
}
writer.print(array.toString());
return;
%>