ProcessingOperation.jsp
2.49 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
<%@ 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" />
<%
String method = request.getParameter("method");
String id=Util.null2String(request.getParameter("id"));
String prjid=Util.null2String(request.getParameter("prjid"));
String planid=Util.null2String(request.getParameter("planid"));
String title=Util.null2String(request.getParameter("title"));
String content=Util.null2String(request.getParameter("content"));
String type=Util.null2String(request.getParameter("type"));
String docid=Util.null2String(request.getParameter("docid"));
String parentids=Util.null2String(request.getParameter("parentids"));
String CurrentUser = ""+user.getUID();
Date newdate = new Date() ;
long datetime = newdate.getTime() ;
Timestamp timestamp = new Timestamp(datetime) ;
String CurrentDate = (timestamp.toString()).substring(0,4) + "-" + (timestamp.toString()).substring(5,7) + "-" +(timestamp.toString()).substring(8,10);
String CurrentTime = (timestamp.toString()).substring(11,13) + ":" + (timestamp.toString()).substring(14,16) + ":" +(timestamp.toString()).substring(17,19);
if(method.equals("archive")){
char flag=2;
String para = id + flag + "1"+flag + CurrentDate + flag + CurrentTime
+ flag + CurrentUser;
RecordSet.executeProc("Prj_Processing_Archive",para);
if(RecordSet.getFlag()!=1)
{
response.sendRedirect("/proj/DBError.jsp?type=Archive");
return;
}
}
else if (method.equals("add"))
{
char flag=2;
String para = prjid + flag + planid + flag + title
+ flag + content + flag + type+ flag + docid+flag + parentids +flag + CurrentDate + flag + CurrentTime
+ flag + CurrentUser;
out.print(para);
RecordSet.executeProc("Prj_Processing_Insert",para);
if(RecordSet.getFlag()!=1)
{
response.sendRedirect("/proj/DBError.jsp?type=Insert");
return;
}
}
else if(method.equals("edit"))
{
char flag=2;
String para = id + flag + title
+ flag + content + flag + type+ flag + docid+flag + CurrentDate + flag + CurrentTime
+ flag + CurrentUser;
out.print(para);
RecordSet.executeProc("Prj_Processing_Update",para);
if(RecordSet.getFlag()!=1)
{
response.sendRedirect("/proj/DBError.jsp?type=Update");
return;
}
}
else
{
response.sendRedirect("/CRM/DBError.jsp?type=Unknown");
return;
}
response.sendRedirect("/proj/process/ViewProcessing.jsp?ProjID="+prjid);
%>