PlanRevisionOperation.jsp
3.43 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
<%@ page language="java" contentType="text/html; charset=GBK" %>
<%@ include file="/systeminfo/init.jsp" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.hrm.performance.*" %>
<%@ page import="weaver.general.*" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs2" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs3" class="weaver.conn.RecordSet" scope="page" />
<%
String imagefilename = "/images/hdHRM.gif";
String titlename = "";
String needfav ="1";
String needhelp ="";
String years=Util.null2String(request.getParameter("years"));
String months=Util.null2String(request.getParameter("months"));
String quarters=Util.null2String(request.getParameter("quarters"));
String weeks=Util.null2String(request.getParameter("weeks"));
String type=Util.null2String(request.getParameter("type"));
int id = Util.getIntValue(request.getParameter("id"));
String operateType = Util.null2String(request.getParameter("operateType"));
rs.executeSql("SELECT modifyStatus FROM workPlan WHERE id="+id+"");
if(rs.next()){
if(operateType.equals("1")){
//툽硫====================================================================================
if(rs.getString("modifyStatus").equals("1")){//警속
rs2.executeSql("UPDATE workPlan SET status='6',modifyStatus='' WHERE id="+id+"");
}else if(rs.getString("modifyStatus").equals("2")){//긍서
rs2.executeSql("UPDATE workPlan SET modifyStatus='' WHERE id="+id+"");
rs2.executeSql("DELETE FROM WorkplanRevisionLog WHERE id="+id+"");
}else if(rs.getString("modifyStatus").equals("3")){//뇜
rs2.executeSql("DELETE FROM workPlan WHERE id="+id+"");
}
}else{
//藁쀼====================================================================================
if(rs.getString("modifyStatus").equals("1")){//警속
rs2.executeSql("DELETE FROM workPlan WHERE id="+id+"");
}else if(rs.getString("modifyStatus").equals("2")){//긍서
rs2.executeSql("UPDATE workPlan SET modifyStatus='' WHERE id="+id+"");
rs2.executeSql("SELECT * FROM WorkplanRevisionLog WHERE id="+id+"");
if(rs2.next()){
rs3.executeSql("UPDATE workPlan SET name='"+rs2.getString("name")+"',oppositeGoal="+rs2.getInt("oppositeGoal")+",planProperty="+rs2.getInt("planProperty")+",isremind="+rs2.getInt("isremind")+",waketime="+rs2.getInt("waketime")+",principal='"+rs2.getString("principal")+"',cowork='"+rs2.getString("cowork")+"',upPrincipal='"+rs2.getString("upPrincipals")+"',downPrincipal='"+rs2.getString("downPrincipals")+"',rbeginDate='"+rs2.getString("rbegindate")+"',rbeginTime='"+rs2.getString("rbegintime")+"',rendDate='"+rs2.getString("renddate")+"',rendTime='"+rs2.getString("rendtime")+"',begindate='"+rs2.getString("begindate")+"',begintime='"+rs2.getString("begintime")+"',enddate='"+rs2.getString("enddate")+"',endtime='"+rs2.getString("endtime")+"',crmid='"+rs2.getString("crmid")+"',docid='"+rs2.getString("docid")+"',projectid='"+rs2.getString("projectid")+"',requestid='"+rs2.getString("requestid")+"',description='"+rs2.getString("description")+"',teamRequest='"+rs2.getString("teamRequest")+"',percent_n='"+rs2.getString("percent_n")+"' WHERE id="+id+"");
}
rs2.executeSql("DELETE FROM WorkplanRevisionLog WHERE id="+id+"");
}else if(rs.getString("modifyStatus").equals("3")){//뇜
rs2.executeSql("UPDATE workPlan SET modifyStatus='' WHERE id="+id+"");
}
}
}
response.sendRedirect("MyPlan.jsp?years="+years+"&months="+months+"&quarters="+quarters+"&weeks="+weeks+"&type="+type+"");
%>