test.jsp
4.88 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
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" trimDirectiveWhitespaces="true"%>
<%@page import="weaver.formmode.exttools.impexp.exp.service.ExpDataService" trimDirectiveWhitespaces="true"%>
<%@page import="weaver.conn.RecordSet"%>
<%@page import="weaver.formmode.exttools.impexp.entity.XmlBean"%>
<%@page import="weaver.formmode.exttools.impexp.db.DatabaseUtils"%>
<%@page import="weaver.formmode.exttools.impexp.common.StringUtils"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
RecordSet rs1 = new RecordSet();
String dbtype = rs1.getDBType();
DatabaseUtils databaseUtils = new DatabaseUtils();
boolean modeinfo_isdelete = databaseUtils.existsColumn("modeinfo","isdelete");
boolean modetreefield_isdelete = databaseUtils.existsColumn("modetreefield","isdelete");
String nullString = "isnull";
if("oracle".equals(dbtype)){
nullString = "nvl";
}
String modeinfo_sqlwhere = "",modetreefield_sqlwhere = "";
if(modeinfo_isdelete){
modeinfo_sqlwhere = " and "+nullString+"(isdelete,'0')<>'1'";
}
if(modetreefield_isdelete){
modetreefield_sqlwhere = " and "+nullString+"(isdelete,'0')<>'1'";
}
rs1.executeSql("select * from modetreefield where 1=1 "+modetreefield_sqlwhere);
RecordSet rs2 = new RecordSet();
rs2.executeSql("select * from modeinfo where 1=1 "+modeinfo_sqlwhere);
RecordSet rs3 = new RecordSet();
rs3.executeSql("select * from mode_impexp_log order by id desc");
%>
<html>
<head>
<script type="text/javascript" src="/formmode/exttools/js/jquery-1.8.3.min_wev8.js"></script>
</head>
<body>
<div>
应用<input type="button" value="导出" id="appexp"/><br>
<%while(rs1.next()){ %>
<%=rs1.getString("treefieldname") %><input type="radio" value="<%=rs1.getString("id") %>" name="appid"/>
<%} %>
</div>
<br>
<div>
模块<input type="button" value="导出" id="modeexp"/><br>
<%while(rs2.next()){ %>
<%=rs2.getString("modename") %>(<%=rs2.getString("id") %>)<input type="radio" value="<%=rs2.getString("id") %>" name="modeid"/>
<%} %>
</div>
<br>
<div>
<form name=frmMain method=post action="/formmode/exttools/impexpAction.jsp" enctype="multipart/form-data" target="upload_faceico">
<input type="hidden" id="id" name="id"/>
<input type="hidden" id="ptype" name="ptype">
<input type="file" value="上传附件" name="filename"/><br><br>
<input type="button" value="导入应用" id="appimp"/>
<input type="button" value="导入模块" id="modeimp"/>
</form>
<iframe id="upload_faceico" name="upload_faceico" style="display: none;"></iframe>
</div>
<div>
<%while(rs3.next()){
int type = rs3.getInt("type");
int datatype = rs3.getInt("datatype");
int userid = rs3.getInt("creator");
String createdate = rs3.getString("createdate");
String createtime = rs3.getString("createtime");
int logid = rs3.getInt("id");
String fileid = StringUtils.null2String(rs3.getString("fileid"));
%>
<%="人员"+userid+" 在 "+createdate+" "+createtime+" "+(type==0?"导出":"导入")+" "+(datatype==0?"应用":"模块") %><a href="javascript:loadDetails('<%=logid %>');">详细</a>
<%if(!"".equals(fileid)){ %>
<a href="/weaver/weaver.file.FileDownload?fileid=<%=fileid %>&download=1" target="_blank">下载</a>
<%} %>
<br>
<%} %>
</div>
<div>
<textarea rows="50" cols="100" id="logdetail"></textarea>
</div>
</body>
<script type="text/javascript">
$(function(){
$("#appexp").click(function(){
var appid = $("input[name='appid']:checked").val();
if(appid==undefined){
alert("请选择应用!");
}else{
doExp(appid,0);
}
});
$("#modeexp").click(function(){
var modeid = $("input[name='modeid']:checked").val();
if(modeid==undefined){
alert("请选择模块!");
}else{
doExp(modeid,1);
}
});
$("#appimp").click(function(){
var appid = $("input[name='appid']:checked").val();
if(appid==undefined){
alert("请选择应用!");
}else{
$("#ptype").val(0);
$("#id").val(appid);
doImp();
}
});
$("#modeimp").click(function(){
var appid = $("input[name='appid']:checked").val();
if(appid==undefined){
alert("请选择应用!");
}else{
$("#ptype").val(1);
$("#id").val(appid);
doImp();
}
});
});
function doExp(id,ptype){
window.open("/formmode/exttools/impexpAction.jsp?id="+id+"&ptype="+ptype+"&type=0");
}
function doImp(){
var id = $("#id").val();
var ptype = $("#ptype").val();
document.frmMain.action = "/formmode/exttools/impexpAction.jsp?id="+id+"&ptype="+ptype+"&type=1";
document.frmMain.submit();
}
function loadDetails(logid){
$.ajax({
type:"post",
url:"/formmode/exttools/impexpAction.jsp",
data:{type:2,logid:logid},
dataType:"text",
success:function(data){
$("#logdetail").html(data);
}
});
}
</script>
</html>