ProjMaterialProcessOperation.jsp
2.78 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.Timestamp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="Util" class="weaver.general.Util" scope="page" />
<%
char flag = 2;
String ProcPara = "";
String CurrentUser = ""+user.getUID();
String SubmiterType = ""+user.getLogintype();
String ClientIP = request.getRemoteAddr();
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);
String method = Util.null2String(request.getParameter("method"));
String taskrecordid=Util.null2String(request.getParameter("taskrecordid"));
String recordid=Util.null2String(request.getParameter("recordid"));
RecordSet.executeProc("Prj_TaskProcess_SelectByID",taskrecordid);
RecordSet.next();
String projid=RecordSet.getString("prjid");
String taskid=RecordSet.getString("taskid");
String version="|"+RecordSet.getString("version")+"|";
String material=Util.null2String(request.getParameter("material"));
String unit=Util.null2String(request.getParameter("unit"));
String begindate=Util.null2String(request.getParameter("begindate"));
String enddate=Util.null2String(request.getParameter("enddate"));
String quantity=Util.null2String(request.getParameter("quantity"));
String cost=Util.null2String(request.getParameter("cost"));
if(quantity.equals("")) quantity = "0" ;
if(cost.equals("")) cost = "0" ;
if(method.equals("add"))
{
ProcPara = projid;
ProcPara += flag+taskid;
ProcPara += flag+material;
ProcPara += flag+unit;
ProcPara += flag+"2";
ProcPara += flag+begindate;
ProcPara += flag+enddate;
ProcPara += flag+quantity;
ProcPara += flag+cost;
RecordSet.executeProc("Prj_MaterialProcess_Insert",ProcPara);
response.sendRedirect("/proj/plan/ViewTaskProcess.jsp?log=n&taskrecordid="+taskrecordid);
return;
}
if(method.equals("edit"))
{
ProcPara = recordid;
ProcPara += flag+material;
ProcPara += flag+unit;
ProcPara += flag+begindate;
ProcPara += flag+enddate;
ProcPara += flag+quantity;
ProcPara += flag+cost;
RecordSet.executeProc("Prj_MaterialProcess_Update",ProcPara);
response.sendRedirect("/proj/plan/ViewTaskProcess.jsp?log=n&taskrecordid="+taskrecordid);
return;
}
if(method.equals("delete"))
{
ProcPara = recordid;
RecordSet.executeProc("Prj_MaterialProcess_Delete",ProcPara);
response.sendRedirect("/proj/plan/ViewTaskProcess.jsp?log=n&taskrecordid="+taskrecordid);
return;
}
%>