ViewSql.jsp
3.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
<%@ page import="weaver.general.Util" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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/hdReport_wev8.gif"></TD>
<TD align=left><SPAN id=BacoTitle class=titlename><%=SystemEnv.getHtmlLabelName(2121, user.getLanguage())%>: <%=SystemEnv.getHtmlLabelName(385, user.getLanguage())%> SQL</SPAN></TD>
<TD align=right> </TD>
<TD width=5></TD>
<tr>
<TBODY>
</TABLE>
</div>
<DIV class=HdrProps></DIV>
<FORM style="MARGIN-TOP: 0px" name=workflowbillViewSqlform method=post action="WorkflowbillOperation.jsp">
<BUTTON class=btn id=btnBack accessKey=D name=btnBack onclick="backSubmit()"><U>D</U>-<%=SystemEnv.getHtmlLabelName(1290, user.getLanguage())%></BUTTON>
<br>
<TABLE class=Form>
<COLGROUP> <COL width="20%"> <COL width="80%"><TBODY>
<TR class=Section>
<TH colSpan=2><%=SystemEnv.getHtmlLabelName(129307, user.getLanguage())%></TH>
</TR>
<TR class=Separator>
<TD class=sep1 colSpan=2></TD>
</TR>
<input type=hidden name=operation>
<%
String id = Util.null2String(request.getParameter("id"));
rs.executeProc("SystemRights_SelectByID",id);
rs.next() ;
String righttype = rs.getString("righttype");
String rightdesc = Util.toScreen(rs.getString("rightdesc"),user.getLanguage());
String insertSql = "insert into SystemRights (id,rightdesc,righttype) values (" + id + ",'" + rightdesc + "','"+ righttype + "') <br>GO<br><br>" ;
rs.executeProc("SystemRightsLanguage_SByID",id);
while(rs.next()) {
String rightname = Util.toScreen(rs.getString("rightname"),user.getLanguage());
String therightdesc = Util.toScreen(rs.getString("rightdesc"),user.getLanguage());
String languageid= rs.getString("languageid") ;
insertSql += "insert into SystemRightsLanguage (id,languageid,rightname,rightdesc) values ("+id+","+languageid+",'"+rightname+"','"+therightdesc+"') <br>GO<br>";
}
insertSql += "<br>" ;
rs.executeSql("select * from SystemRightDetail where rightid="+id);
while( rs.next() ) {
String rightdetailname = Util.toScreen(rs.getString("rightdetailname"),user.getLanguage()) ;
String rightdetail = Util.toScreen(rs.getString("rightdetail"),user.getLanguage()) ;
String rightid = Util.null2String(rs.getString("id")) ;
insertSql += "insert into SystemRightDetail (id,rightdetailname,rightdetail,rightid) values ("+rightid+",'"+rightdetailname+"','"+rightdetail+"',"+id+") <br>GO<br>";
}
%>
<TR>
<TD Class=Field bgcolor="#00ccbb" colspan=2>
<%=insertSql%>
</TD>
</TR>
</table>
</body>
<script language=javascript>
function backSubmit(){
location = 'ViewRight.jsp?id=<%=id%>';
}
</script>
</html>