PlanOperation.jsp
4.95 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 language="java" contentType="text/html; charset=GBK" %>
<%@ page import="java.security.*,weaver.general.Util" %>
<%@ page import="java.util.*" %>
<%@ include file="/systeminfo/init.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
String from=Util.null2String((String)session.getAttribute("from"));
String deltype=Util.null2String(request.getParameter("type"));
String inserttype=Util.null2String(request.getParameter("inserttype"));
String edittype=Util.null2String(request.getParameter("edittype"));
if (inserttype.equals("basic")){
char separator = Util.getSeparator() ;
String planName=Util.fromScreen(request.getParameter("planName"),user.getLanguage());
String sort=Util.null2o(request.getParameter("sort"));
String headers=Util.fromScreen(request.getParameter("headers"),user.getLanguage());
String para="planid";
String id="";
rs.executeProc("GetMaxId_PRO",para);
if (rs.next()){
id = ""+rs.getInt(1);
}
rs.execute("select * from HrmPerformancePlanKind where planName='"+planName+"' ");
if (rs.next())
{
out.print("<script>alert('"+SystemEnv.getHtmlLabelName(195,user.getLanguage())+SystemEnv.getHtmlLabelName(18082,user.getLanguage())+"')</script>");
out.print("<script>history.back(-1);</script>");
return;
}
rs.execute("insert into HrmPerformancePlanKind (id,headers,planName,sort) values("+id+",'"+headers+"','"+planName+"',"+sort+")");
response.sendRedirect("PlanEdit.jsp?id="+id);
}
if (edittype.equals("basic")){
String planName=Util.fromScreen(request.getParameter("planName"),user.getLanguage());
String sort=Util.null2o(request.getParameter("sort"));
String id=Util.null2String(request.getParameter("mainid"));
String headers=Util.fromScreen(request.getParameter("headers"),user.getLanguage());
rs.execute("select * from HrmPerformancePlanKind where planName='"+planName+"' and id!="+id);
if (rs.next())
{
out.print("<script>alert('"+SystemEnv.getHtmlLabelName(195,user.getLanguage())+SystemEnv.getHtmlLabelName(18082,user.getLanguage())+"')</script>");
out.print("<script>history.back(-1);</script>");
return;
}
rs.execute("update HrmPerformancePlanKind set headers='"+headers+"',planName='"+planName+"',sort="+sort+" where id="+id);
response.sendRedirect("PlanEdit.jsp?id="+id);
}
if (inserttype.equals("detail")){
String planName=Util.fromScreen(request.getParameter("planName"),user.getLanguage());
String sort=Util.null2o(request.getParameter("sort"));
String headers=Util.fromScreen(request.getParameter("headers"),user.getLanguage());
String id=Util.null2String(request.getParameter("mainid"));
rs.execute("select * from HrmPerformancePlanKindDetail where planName='"+planName+"' and PlanId="+id);
if (rs.next())
{
out.print("<script>alert('"+SystemEnv.getHtmlLabelName(195,user.getLanguage())+SystemEnv.getHtmlLabelName(18082,user.getLanguage())+"')</script>");
out.print("<script>history.back(-1);</script>");
return;
}
rs.execute("insert into HrmPerformancePlanKindDetail(PlanId,headers,planName,sort) values("+id+",'"+headers+"','"+planName+"',"+sort+") ");
if (from.equals("1"))
{
response.sendRedirect("PlanEdit.jsp?id="+id);
}
else
{
response.sendRedirect("PlanDetailList.jsp?mainid="+id);
}
}
if (edittype.equals("detail")){
String planName=Util.fromScreen(request.getParameter("planName"),user.getLanguage());
String sort=Util.null2o(request.getParameter("sort"));
String headers=Util.fromScreen(request.getParameter("headers"),user.getLanguage());
String mainid=Util.null2String(request.getParameter("mainid"));
String id=Util.null2String(request.getParameter("id"));
rs.execute("select * from HrmPerformancePlanKindDetail where planName='"+planName+"' and PlanId="+mainid+" and id!="+id);
if (rs.next())
{
out.print("<script>alert('"+SystemEnv.getHtmlLabelName(195,user.getLanguage())+SystemEnv.getHtmlLabelName(18082,user.getLanguage())+"')</script>");
out.print("<script>history.back(-1);</script>");
return;
}
rs.execute("update HrmPerformancePlanKindDetail set headers='"+headers+"',planName='"+planName+"',sort="+sort+" where id="+id );
if (from.equals("1"))
{
response.sendRedirect("PlanEdit.jsp?id="+mainid);
}
else
{
response.sendRedirect("planDetailList.jsp?mainid="+mainid);
}
}
if (deltype.equals("detaildel"))
{
String id=Util.null2String(request.getParameter("id"));
String mainid=Util.null2String(request.getParameter("mainid"));
rs.execute("delete from HrmPerformancePlanKindDetail where id="+id);
if ((from.equals("1")||(Util.null2String(request.getParameter("from"))).equals("1")))
{
response.sendRedirect("PlanEdit.jsp?id="+mainid);
}
else
{
response.sendRedirect("PlanDetailList.jsp?mainid="+mainid);
}
}
%>