ExpLocalDetailOperation.jsp
4.95 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
<%@ page buffer="4kb" autoFlush="true" errorPage="/notice/error.jsp" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<%@ page import="weaver.file.FileUpload" %>
<jsp:useBean id="SysMaintenanceLog" class="weaver.systeminfo.SysMaintenanceLog" scope="page" />
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<%
if(!HrmUserVarify.checkUserRight("intergration:expsetting", user)){
response.sendRedirect("/notice/noright.jsp");
return;
}
FileUpload fu = new FileUpload(request);
String isDialog = Util.null2String(fu.getParameter("isdialog"));
String backto = Util.null2String(fu.getParameter("backto"));//返回类型
String operation = Util.fromScreen(fu.getParameter("operation"),user.getLanguage());
String id = Util.fromScreen(fu.getParameter("id"),user.getLanguage());
String name = Util.fromScreen(fu.getParameter("name"),user.getLanguage());
String path = Util.fromScreen(fu.getParameter("path"),user.getLanguage());
int userid = user.getUID();
String createdate = TimeUtil.getCurrentTimeString();
char separator = Util.getSeparator() ;
if(operation.equals("add")){
String insertsql="insert into exp_localdetail(name,path,createdate,creator) values(?,?,?,?)";
List<List> insertParamsList= new ArrayList<List>();
List<Object> paramList = new ArrayList();
paramList.add(name);
paramList.add(path);
paramList.add(createdate);
paramList.add(userid);
insertParamsList.add(paramList);
RecordSet.executeBatchSql(insertsql,insertParamsList);
//RecordSet.executeSql("insert into exp_localdetail(name,path,createdate,creator) values('"+name+"','"+path+"','"+createdate+"',"+userid+")");
int maxid=0;
RecordSet.executeSql("select max(id) from exp_localdetail");
if(RecordSet.next()){
maxid = RecordSet.getInt(1);
}
String para = name +separator+ path +separator + createdate +separator + userid ;
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(maxid);
SysMaintenanceLog.setRelatedName(name);
SysMaintenanceLog.setOperateType("1");
SysMaintenanceLog.setOperateDesc("exp_localdetail_Insert,"+para);
SysMaintenanceLog.setOperateItem("160");
SysMaintenanceLog.setOperateUserid(user.getUID());
SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
SysMaintenanceLog.setSysLogInfo();
}
else if(operation.equals("edit")){
String updatesql="update exp_localdetail set createdate = ?,name = ?,path = ?,creator = ? where id= ? ";
List<List> updateParamsList= new ArrayList<List>();
List<Object> paramList = new ArrayList();
paramList.add(createdate);
paramList.add(name);
paramList.add(path);
paramList.add(userid);
paramList.add(path);
paramList.add(id);
updateParamsList.add(paramList);
RecordSet.executeBatchSql(updatesql,updateParamsList);
//RecordSet.execute("update exp_localdetail set createdate = '"+createdate+"',name = '"+name+"',path = '"+path+"',creator = "+userid+" where id= "+id);
String para = id+separator+name +separator+ path +separator + createdate +separator + userid ;
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(Util.getIntValue(id));
SysMaintenanceLog.setRelatedName(name);
SysMaintenanceLog.setOperateType("2");
SysMaintenanceLog.setOperateDesc("exp_localdetail_Update,"+para);
SysMaintenanceLog.setOperateItem("160");
SysMaintenanceLog.setOperateUserid(user.getUID());
SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
SysMaintenanceLog.setSysLogInfo();
}
else if(operation.equals("delete")){
List ids = Util.TokenizerString(id,",");
if(null!=ids&&ids.size()>0) {
for(int i = 0;i<ids.size();i++) {
String tempsysid = Util.null2String((String)ids.get(i));
String tempworkflowname="";
RecordSet.execute("select * from exp_localdetail where id = "+tempsysid);
if(RecordSet.next()){
tempworkflowname=Util.null2String(RecordSet.getString("name")) ;
}
if(!"".equals(tempsysid))
{
RecordSet.execute("delete from exp_localdetail where id = "+tempsysid);
String para =""+tempsysid;
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(Util.getIntValue(tempsysid));
SysMaintenanceLog.setRelatedName(tempworkflowname);
SysMaintenanceLog.setOperateType("3");
SysMaintenanceLog.setOperateDesc("exp_localdetail_delete,"+para);
SysMaintenanceLog.setOperateItem("160");
SysMaintenanceLog.setOperateUserid(user.getUID());
SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
SysMaintenanceLog.setSysLogInfo();
}
}
}
}
if("1".equals(isDialog)){
%>
<script language=javascript >
try{
//var parentWin = parent.getParentWindow(window);
var parentWin = parent.parent.getParentWindow(parent);
parentWin.location.href="ExpLocalDetail.jsp?backto=<%=backto%>";
parentWin.closeDialog();
}
catch(e){
}
</script>
<%
}
else
response.sendRedirect("ExpLocalDetail.jsp?backto="+backto);
%>