CompanyOperation.jsp
4.25 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
<%@ page import="weaver.general.Util" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@page import="weaver.hrm.common.database.dialect.DbDialectFactory"%>
<%@page import="weaver.hrm.common.database.dialect.DialectUtil"%>
<%@page import="org.apache.commons.lang3.StringUtils"%> <%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="CompanyVirtualComInfo" class="weaver.hrm.companyvirtual.CompanyVirtualComInfo" scope="page" />
<jsp:useBean id="SysMaintenanceLog" class="weaver.systeminfo.SysMaintenanceLog" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
String cmd = Util.null2String(request.getParameter("cmd"));
String id = Util.null2String(request.getParameter("id"));
//String companyname = Util.fromScreen(request.getParameter("companyname"),user.getLanguage());
//String companydesc = Util.fromScreen(request.getParameter("companydesc"),user.getLanguage());
String virtualtype = Util.fromScreen(request.getParameter("virtualtype"),user.getLanguage());
String virtualtypedesc = Util.fromScreen(request.getParameter("virtualtypedesc"),user.getLanguage());
String companyname = virtualtype;
String companydesc = virtualtype;
int showorder = Util.getIntValue(request.getParameter("showorder"),0);
String sql = "";
if(cmd.equals("edit")){
sql = " update HrmCompanyVirtual set companyname='"+companyname+"', companydesc='"+companydesc+"',"+
" virtualtype='"+virtualtype+"', virtualtypedesc='"+virtualtypedesc+"', showorder='"+showorder+"' "+
" where id = "+id;
rs.executeSql(sql);
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(Util.getIntValue(id));
SysMaintenanceLog.setRelatedName(companyname);
SysMaintenanceLog.setOperateType("2");
SysMaintenanceLog.setOperateDesc(sql);
SysMaintenanceLog.setOperateItem("412");
SysMaintenanceLog.setOperateUserid(user.getUID());
SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
SysMaintenanceLog.setSysLogInfo();
CompanyVirtualComInfo.removeCompanyCache();
response.sendRedirect("HrmCompanyEdit.jsp?isclose=1&id="+id);
}else if(cmd.equals("save")){
if(DialectUtil.isMySql(rs.getDBType())){
sql="select min(id) as id from HrmCompanyVirtual ";
rs.executeSql(sql);
if(rs.next()){
id=(rs.getInt("id")-1)+"";
}
if(StringUtils.isBlank(id)) id = "-1" ;
sql = " insert into HrmCompanyVirtual (id,companyname, companydesc, virtualtype,virtualtypedesc, showorder)"+
" values("+id+",'"+companyname+"','"+companydesc+"','"+virtualtype+"','"+virtualtypedesc+"',"+showorder+")";
rs.executeSql(sql);
}else{
sql = " insert into HrmCompanyVirtual (companyname, companydesc, virtualtype,virtualtypedesc, showorder)"+
" values('"+companyname+"','"+companydesc+"','"+virtualtype+"','"+virtualtypedesc+"',"+showorder+")";
rs.executeSql(sql);
sql="select min(id) as id from HrmCompanyVirtual ";
rs.executeSql(sql);
if(rs.next()){
id=rs.getString("id");
}
}
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(Util.getIntValue(id));
SysMaintenanceLog.setRelatedName(companyname);
SysMaintenanceLog.setOperateType("1");
SysMaintenanceLog.setOperateDesc(sql);
SysMaintenanceLog.setOperateItem("412");
SysMaintenanceLog.setOperateUserid(user.getUID());
SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
SysMaintenanceLog.setSysLogInfo();
CompanyVirtualComInfo.removeCompanyCache();
response.sendRedirect("HrmCompanyAdd.jsp?isclose=1&id="+id);
}else if(cmd.equals("del")){
sql = " select companyname from HrmCompanyVirtual where id = "+id;
rs.executeSql(sql);
if(rs.next()){
companyname = rs.getString("companyname");
}
sql = " delete from HrmCompanyVirtual where id = "+id;
rs.executeSql(sql);
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(Util.getIntValue(id));
SysMaintenanceLog.setRelatedName(companyname);
SysMaintenanceLog.setOperateType("3");
SysMaintenanceLog.setOperateDesc(sql);
SysMaintenanceLog.setOperateItem("412");
SysMaintenanceLog.setOperateUserid(user.getUID());
SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
SysMaintenanceLog.setSysLogInfo();
CompanyVirtualComInfo.removeCompanyCache();
response.sendRedirect("HrmCompanyDsp.jsp?cmd=del");
}
%>