docNumberOperation.jsp
3.89 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="java.net.URLEncoder" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="Util" class="weaver.general.Util" scope="page" />
<jsp:useBean id="log" class="weaver.systeminfo.SysMaintenanceLog" scope="page" />
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%
if(!HrmUserVarify.checkUserRight("SendDoc:Manage", user)){
response.sendRedirect("/notice/noright.jsp");
return;
}
%>
<%
char flag = 2;
String ProcPara = "";
String method = Util.null2String(request.getParameter("method"));
String showOrder = Util.fromScreen(request.getParameter("showOrder"),user.getLanguage());
if(null == showOrder || "".equals(showOrder.trim())) {
showOrder = "0.0";
}
if(method.equals("add"))
{
String name=Util.convertInput2DB(Util.null2String(request.getParameter("name")));
String desc=Util.convertDB2Input(Util.null2String(request.getParameter("desc")));
if(isExistLevel(RecordSet,name,"")) {
// data cannot be duplicate
response.sendRedirect("docNumberAdd.jsp?isclose=0&existFlag=1&name0="+URLEncoder.encode(name,"UTF-8")+"&desc0="+URLEncoder.encode(desc,"UTF-8")+"&showOrder0="+showOrder);
return;
}
ProcPara = "insert into DocSendDocNumber(name,desc_n,showOrder) values('"+name+"','"+desc+"','"+showOrder+"')";
RecordSet.executeSql(ProcPara);
RecordSet.executeSql("select max(id) from DocSendDocNumber");
if(RecordSet.next()){
log.insSysLogInfo(user, RecordSet.getInt(1), name, ProcPara, "339", "1", 0, request.getRemoteAddr());
}
response.sendRedirect("docNumberAdd.jsp?isclose=1");
return;
}
if(method.equals("edit"))
{
String id=Util.null2String(request.getParameter("id"));
String name=Util.convertDB2Input(Util.null2String(request.getParameter("name")));
String desc=Util.convertDB2Input(Util.null2String(request.getParameter("desc")));
if(isExistLevel(RecordSet,name,id)) {
// data cannot be duplicate
response.sendRedirect("docNumberAdd.jsp?isclose=0&existFlag=1&id="+id+"&name0="+URLEncoder.encode(name,"UTF-8")+"&desc0="+URLEncoder.encode(desc,"UTF-8")+"&showOrder0="+showOrder);
return;
}
ProcPara = "update DocSendDocNumber set ";
ProcPara += "name='" + name + "', ";
ProcPara += "showOrder='" + showOrder + "', ";
ProcPara += "desc_n='" + desc + "' ";
ProcPara += " where id = " + id ;
RecordSet.executeSql(ProcPara);
log.insSysLogInfo(user, Util.getIntValue(id), name, ProcPara, "339", "2", 0, request.getRemoteAddr());
response.sendRedirect("docNumberAdd.jsp?isclose=1");
return;
}
String IDs =Util.null2String(request.getParameter("IDs"));
if(method.equals("delete"))
{
/* if(IDs != null)
{
for(int i=0;i<IDs.length;i++)
{
ProcPara = "delete DocSendDocNumber where id = " + IDs[i];
RecordSet.executeSql(ProcPara);
}
}*/
ProcPara = "delete DocSendDocNumber where id in( " + IDs + ")";
RecordSet.executeSql("select id,name from DocSendDocNumber where id in ("+IDs+")");
while(RecordSet.next()){
log.insSysLogInfo(user, RecordSet.getInt(1), RecordSet.getString(2), ProcPara, "339", "3", 0, request.getRemoteAddr());
}
RecordSet.executeSql(ProcPara);
response.sendRedirect("docNumber.jsp");
return;
}
%>
<%!
private boolean isExistLevel(weaver.conn.RecordSet recordSet,String name,String id) {
String sql = "";
name = Util.null2String(name).trim();
if("".equals(id)) {
sql = "select id,name from DocSendDocNumber where name='"+name+"'";
} else {
sql = "select id,name from DocSendDocNumber where name='"+name+"' and id !='"+id+"'";
}
recordSet.executeSql(sql);
return recordSet.next() ? true : false;
}
%>