excelUploadFormula_DesignOperation.jsp
1.69 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%@ page import="net.sf.json.JSONObject" %>
<%@ page import="java.util.*" %>
<%
String formid = Util.null2String(request.getParameter("formid"));
String isbill = Util.null2String(request.getParameter("isbill"));
String workflowid = Util.null2String(request.getParameter("workflowid"));
String nodeid = Util.null2String(request.getParameter("nodeid"));
String sql = "select * from workflow_formula_htmllayout where formid = " + formid + " and isbill=" + isbill+
" and workflowid=" + workflowid + " and nodeid=" + nodeid;
rs.executeSql(sql);
String formulaKey;
String formula;
String formulaDesc;
String triggers;
String triggerDesc;
String name;
JSONObject formulaObj = new JSONObject();
//MAIN.FORMULAB7#new#:"[main.6309]=Lower('ABDcEfghi')###[主表.z4]=Lower('ABDcEfghi')###1#6306##2#6307#_#值改变时 (触发字段： z1)##获取输入焦点时 (触发字段： z2)###公式名"
String formulaStr;
while(rs.next()) {
formulaKey = Util.null2String(rs.getString("formulakey"));
formula = Util.null2String(rs.getString("formula"));
formulaDesc = Util.null2String(rs.getString("formuladesc"));
triggers = Util.null2String(rs.getString("triggers"));
triggerDesc = Util.null2String(rs.getString("triggerdesc"));
name = Util.null2String(rs.getString("name"));
formulaStr = formula + "###" + formulaDesc + "###" + triggers + "#_#" + triggerDesc + "###" + name;
formulaObj.put(formulaKey, formulaStr);
}
out.print(formulaObj.toString());
%>