RequestOperation.jsp
2.93 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="java.util.*" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.sql.Timestamp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<%
char flag = 2 ;
String ProcPara = "";
String method = Util.null2String(request.getParameter("method"));
String ProjID=Util.null2String(request.getParameter("ProjID"));
String taskid=Util.null2String(request.getParameter("taskid"));
String requestid=Util.null2String(request.getParameter("requestid"));
String type=Util.null2String(request.getParameter("type"));
String workflowid = "";
String sql = "SELECT workflowid FROM workflow_requestbase WHERE requestid="+Util.getIntValue(requestid,-1);
RecordSet.executeSql(sql);
workflowid = RecordSet.next() ? RecordSet.getString("workflowid") : "0";
if (method.equals("add"))
{
String tempsql="";
tempsql="select * from Prj_Request where prjid='"+ProjID+"' and taskid='"+taskid+"' and requestid='"+requestid+"'";
RecordSet.executeSql(tempsql);
if(!RecordSet.next()){
ProcPara = ProjID ;
ProcPara += flag + taskid ;
ProcPara += flag + requestid ;
ProcPara += flag + workflowid ;
RecordSet.executeProc("Prj_Request_Insert",ProcPara);
tempsql="update workflow_requestbase set prjids='"+ProjID+"' where requestid="+requestid;
RecordSet.executeSql(tempsql);
}
/**
if(type.equals("1"))
response.sendRedirect("/proj/plan/ViewTask.jsp?log=n&taskrecordid="+taskid);
else if(type.equals("2"))
response.sendRedirect("/proj/process/ViewTask.jsp?log=n&taskrecordid="+taskid);
**/
String redirectUrl="/proj/process/DspTaskReference.jsp?ProjID="+ProjID+"&taskrecordid="+taskid+"&src=req";
//response.sendRedirect(redirectUrl);
%>
<script language=javascript>
try{
this.opener.location = "<%=redirectUrl%>";
window.close();
}catch(e){}
</script>
<%
}
if (method.equals("del"))
{
String ids = Util.null2String(request.getParameter("id"));
String ProjID1="";
String taskid1="";
if(ids.startsWith(",")){
ids=ids.substring(1,ids.length());
}
if(ids.endsWith(",")){
ids=ids.substring(0,ids.length()-1);
}
String[]idarr=ids.split(",");
for(int i=0;i<idarr.length;i++){
String id=idarr[i];
String tempsql="select prjid,requestid,taskid from Prj_Request where id="+id;
RecordSet.executeSql(tempsql);
RecordSet.next();
String tempprjid = RecordSet.getString("prjid");
String temptaskid = RecordSet.getString("taskid");
ProjID=tempprjid;
taskid=temptaskid;
tempsql="delete from Prj_Request where id="+id;
RecordSet.executeSql(tempsql);
}
/**
if(type.equals("1"))
response.sendRedirect("/proj/plan/ViewTask.jsp?log=n&taskrecordid="+taskid);
else if(type.equals("2"))
response.sendRedirect("/proj/process/ViewTask.jsp?log=n&taskrecordid="+taskid);
**/
response.sendRedirect("/proj/process/DspTaskReference.jsp?ProjID="+ProjID1+"&taskrecordid="+taskid1+"&src=req");
}
%>