EditWorkflowbrowser.jsp
4.06 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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<%@ page import="weaver.general.Util" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="weaver.systeminfo.workflowbill.WorkFlowBillUtil"%>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page"/>
<jsp:useBean id="bci" class="weaver.workflow.field.BrowserComInfo" scope="page" />
<%
if(Util.getIntValue(user.getSeclevel(),0)<20){
response.sendRedirect("ManageWorkflowbill.jsp");
}
%>
<html>
<head>
<LINK href="/css/BacoSystem_wev8.css" type=text/css rel=STYLESHEET>
</head>
<body>
<DIV class=HdrTitle>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=left width=55><IMG height=24 src="/images/hdDOC_wev8.gif"></TD>
<TD align=left><SPAN id=BacoTitle class=titlename>编辑: 工作流单据浏览框</SPAN></TD>
<TD align=right> </TD>
<TD width=5></TD>
<tr>
</TBODY>
</TABLE>
</div>
<DIV class=HdrProps>
</DIV>
<FORM style="MARGIN-TOP: 0px" name=workflowbrowseredit method=post action="WorkflowbrowserOperation.jsp">
<BUTTON class=btn id=btnSave accessKey=S name=btnSave type=submit><U>S</U>-保存</BUTTON>
<BUTTON class=btn id=btnClear accessKey=R name=btnClear type=reset><U>R</U>-重新设置</BUTTON>
<BUTTON class=btn id=btnBack accessKey=B name=btnBack onclick="backSubmit()"><U>D</U>-返回</BUTTON>
<br>
<TABLE class=Form>
<COLGROUP> <COL width="20%"> <COL width="80%"><TBODY>
<TR class=Section>
<TH colSpan=5>浏览框信息</TH>
</TR>
<TR class=Separator>
<TD class=sep1 colSpan=5></TD>
</TR>
<%
String sid = request.getParameter("id");
int id = Util.getIntValue(sid,0);
WorkFlowBillUtil wf = new WorkFlowBillUtil();
/*String sql = "select * from workflow_browserurl where id = "+id;
rs.executeSql(sql);
while(rs.next()){
int labelid = Util.getIntValue(rs.getString("labelid"),0);
String label = wf.getLabelByLabelId(labelid);
String dbtype = rs.getString("fielddbtype");
String url = rs.getString("browserurl");
String table = rs.getString("tablename");
String colum = rs.getString("columname");
String keycolum = rs.getString("keycolumname");
String linkurl = rs.getString("linkurl"); */
while(bci.next()){
int labelid = Util.getIntValue(bci.getBrowserlabelid(sid),0);
String label = wf.getLabelByLabelId(labelid);
String dbtype = bci.getBrowserdbtype(sid);
String url = bci.getBrowserurl(sid);
String table = bci.getBrowsertablename(sid);
String colum = bci.getBrowsercolumname(sid);
String keycolum = bci.getBrowserkeycolumname(sid);
String linkurl = bci.getLinkurl(sid);
%>
<TR>
<TD>ID</TD>
<TD Class=Field><%=id%></TD>
<INPUT type=hidden name="id" value=<%=id%>>
</TR>
<TR>
<TD>描叙</TD>
<TD Class=Field><INPUT class=FieldxLong name=label value=<%=label%> ></TD>
</TR>
<TR>
<TD>描叙id</TD>
<TD Class=Field><INPUT class=FieldxLong name=labelid value=<%=labelid%> ></TD>
</TR>
<TR>
<TD>URL</TD>
<TD Class=Field><INPUT class=FieldxLong name=url value=<%=url%>> </TD>
</TR>
<TR>
<TD>数据库类型</TD>
<TD Class=Field><INPUT class=FieldxLong name=dbtype value=<%=dbtype%>> </TD>
</TR>
<TR>
<TD>对应表名</TD>
<TD Class=Field><INPUT class=FieldxLong name=table value=<%=table%>> </TD>
</TR>
<TR>
<TD>表对应字段</TD>
<TD Class=Field><INPUT class=FieldxLong name=colum value=<%=colum%>> </TD>
</TR>
<TR>
<TD>表关键字段</TD>
<TD Class=Field><INPUT class=FieldxLong name=keycolum value=<%=keycolum%>> </TD>
</TR>
<TR>
<TD>链接URL</TD>
<TD Class=Field><INPUT class=FieldxLong name=linkurl value=<%=linkurl%>></TD>
</TR>
<%
break;
}
bci.removeBrowserCache();
%>
</TABLE>
<br>
<input type=hidden name=operation value=editWorkflowbrowser>
<script language="javascript">
function backSubmit(){
location = "ViewWorkflowbrowser.jsp?id=<%=id%>";
}
</script>
</FORM>
</body>
</html>