ExpDBDetailOperation.jsp
4.51 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
<%@ 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 resoure = Util.fromScreen(fu.getParameter("resoure"),user.getLanguage());
String maintable = Util.fromScreen(fu.getParameter("maintable"),user.getLanguage());
String detailtable = Util.fromScreen(fu.getParameter("detailtable"),user.getLanguage());
int userid = user.getUID();
String createdate = TimeUtil.getCurrentTimeString();
char separator = Util.getSeparator() ;
if(operation.equals("add")){
RecordSet.executeSql("insert into exp_dbdetail(name,resoure,maintable,detailtable,createdate,creator) values('"+name+"','"+resoure+"','"+maintable+"','"+detailtable+"','"+createdate+"',"+userid+")");
int maxid=0;
RecordSet.executeSql("select max(id) from exp_dbdetail");
if(RecordSet.next()){
maxid = RecordSet.getInt(1);
}
String para = name +separator+ resoure +separator + maintable +separator + detailtable +separator + createdate+separator + userid;
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(maxid);
SysMaintenanceLog.setRelatedName(name);
SysMaintenanceLog.setOperateType("1");
SysMaintenanceLog.setOperateDesc("exp_dbdetail_Insert,"+para);
SysMaintenanceLog.setOperateItem("161");
SysMaintenanceLog.setOperateUserid(user.getUID());
SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
SysMaintenanceLog.setSysLogInfo();
}
else if(operation.equals("edit")){
RecordSet.execute("update exp_dbdetail set resoure = '"+resoure+"',maintable = '"+maintable+"',detailtable = '"+detailtable+"',createdate = '"+createdate+"',name = '"+name+"',creator = "+userid+" where id= "+id);
String para = id+separator+name +separator+ resoure +separator + maintable +separator + detailtable +separator + createdate+separator + userid;
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(Util.getIntValue(id));
SysMaintenanceLog.setRelatedName(name);
SysMaintenanceLog.setOperateType("2");
SysMaintenanceLog.setOperateDesc("exp_dbdetail_Update,"+para);
SysMaintenanceLog.setOperateItem("161");
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_dbdetail where id = "+tempsysid);
if(RecordSet.next()){
tempworkflowname=Util.null2String(RecordSet.getString("name")) ;
}
if(!"".equals(tempsysid)) {
RecordSet.execute("delete from exp_dbdetail where id = "+tempsysid);
String para =""+tempsysid;
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(Util.getIntValue(tempsysid));
SysMaintenanceLog.setRelatedName(tempworkflowname);
SysMaintenanceLog.setOperateType("3");
SysMaintenanceLog.setOperateDesc("exp_dbdetail_delete,"+para);
SysMaintenanceLog.setOperateItem("161");
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="ExpDBDetail.jsp?backto=<%=backto%>";
parentWin.closeDialog();
}
catch(e){
}
</script>
<%
}
else
response.sendRedirect("ExpDBDetail.jsp?backto="+backto);
%>