OfsSendOperation.jsp
5.68 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
<%@ page import="weaver.general.Util,java.util.*" %>
<%@ page import="weaver.workflow.request.todo.RequestUtil,weaver.workflow.request.todo.OfsSendInfoComInfo,org.apache.commons.lang.*" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
String operate = Util.null2String(request.getParameter("operate"));
String sysid = Util.null2String(request.getParameter("sysid"));
OfsSendInfoComInfo comInfo = new OfsSendInfoComInfo();
if(operate.equals("reg")){//注册信息
String sysdesc = Util.null2String(request.getParameter("sysdesc"));
String syscode = Util.null2String(request.getParameter("syscode"));
String classimpl = Util.null2String(request.getParameter("classimpl"));
String isvalid = Util.null2String(request.getParameter("isvalid"));
String serverurl = Util.null2String(request.getParameter("serverurl"));
String sql = "";
if(sysid.equals("")){
sql = "insert into ofs_sendinfo (sysdesc,syscode,classimpl,isvalid,serverurl) values (?,?,?,?,?)";
rs.executeUpdate(sql,sysdesc,syscode,classimpl,Util.getIntValue(isvalid,0),serverurl);
rs.executeQuery("select max(id) from ofs_sendinfo");
rs.next();
sysid = rs.getString(1);
}else{
sql = "update ofs_sendinfo set sysdesc=?,syscode=?,classimpl=?,isvalid=?,serverurl=? where id=?";
rs.executeUpdate(sql,sysdesc,syscode,classimpl,Util.getIntValue(isvalid,0),serverurl,sysid);
}
int weaverTableRows = Util.getIntValue(request.getParameter("weaverTableRows"));
String __weaverDeleteRows = Util.null2String(request.getParameter("__weaverDeleteRows"));
rs.executeUpdate("delete from ofs_sendinfodetail where mainid=?",sysid);
for(int i = 0 ; i < weaverTableRows ; i++){
String paramname = Util.null2String(request.getParameter("paramname_"+i));
String paramvalue = Util.null2String(request.getParameter("paramvalue_"+i));
if(!paramname.equals("")) {
rs.executeUpdate("insert into ofs_sendinfodetail (mainid,paramname,paramvalue) values (?,?,?)", sysid, paramname, paramvalue);
}
}
response.sendRedirect("OfsSendEdit.jsp?reflush=1&sysid="+sysid);
}
if(operate.equals("delete")){
rs.executeUpdate("delete from ofs_sendinfo where id=?",sysid);
rs.executeUpdate("delete from ofs_sendinfodetail where mainid=?",sysid);
rs.executeUpdate("delete from ofs_senduser where mainid=?",sysid);
rs.executeUpdate("delete from ofs_senduserdetail where mainid=?",sysid);
rs.executeUpdate("delete from ofs_sendworkflow where mainid=?",sysid);
comInfo.removeCache();
response.sendRedirect("OfsSendList.jsp");
}
if(operate.equals("ajaxdata")){
out.clear();
String syscode = Util.null2String(request.getParameter("syscode"));
String sql = "select 1 from ofs_sendinfo where syscode=?";
if(!sysid.equals("")){
sql = "select 1 from ofs_sendinfo where syscode=? and id!="+sysid;
}
rs.executeQuery(sql,syscode);
if(rs.next()){
out.println("1");
}else{
out.println("0");
}
}
if(operate.equals("dowf")){
String workflowids = Util.null2String(request.getParameter("workflowids"));
ArrayList idsarray = Util.TokenizerString(workflowids,",");
for(int i = 0 ; i < idsarray.size() ; i++){
String tempwfid = idsarray.get(i).toString();
rs.executeQuery("select workflowid from ofs_sendworkflow where mainid="+sysid+" and workflowid="+tempwfid);
if(!rs.next()){
rs.executeUpdate("insert into ofs_sendworkflow (mainid,workflowid) values ("+sysid+","+tempwfid+")");
}
}
comInfo.removeCache();
response.sendRedirect("OfsSendWF.jsp?sysid="+sysid);
}
if(operate.equals("dowfdel")){
String dataid = Util.null2String(request.getParameter("dataid"));
ArrayList wfids = Util.TokenizerString(dataid,",");
rs.executeUpdate("delete from ofs_sendworkflow where mainid=? and workflowid in ("+StringUtils.join(wfids,",")+")",sysid);
comInfo.removeCache();
response.sendRedirect("OfsSendWF.jsp?sysid="+sysid);
}
if(operate.equals("douser")){
String sharetype = Util.null2String(request.getParameter("sharetype"));
String relatedshareid = Util.null2String(request.getParameter("relatedshareid"));
String rolelevel = Util.null2String(request.getParameter("rolelevel"));
String seclevel = Util.null2String(request.getParameter("seclevel"));
String seclevel2 = Util.null2String(request.getParameter("seclevel2"));
if(sharetype.equals("5")) relatedshareid = "-1";
ArrayList objids = Util.TokenizerString(relatedshareid,",");
for(int i = 0 ; i < objids.size() ; i++) {
int objid = Util.getIntValue(objids.get(i).toString());
rs.executeUpdate("insert into ofs_senduser (mainid,type,objid,rolelevel,seclevel,seclevel1) values (?,?,?,?,?,?)",sysid,sharetype,objid,rolelevel,seclevel,seclevel2);
}
comInfo.removeCache();
response.sendRedirect("OfsSendResource.jsp?sysid="+sysid);
}
if(operate.equals("douserdel")){
String dataid = Util.null2String(request.getParameter("dataid"));
ArrayList uids = Util.TokenizerString(dataid,",");
rs.executeUpdate("delete from ofs_senduser where mainid=? and id in ("+StringUtils.join(uids,",")+")",sysid);
comInfo.removeCache();
response.sendRedirect("OfsSendResource.jsp?sysid="+sysid);
}
%>