loginTemplateTempOperation.jsp
4.5 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
<%@ page language="java" contentType="text/html; charset=utf-8" %>
<%@ page import="java.security.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="weaver.general.*" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="org.apache.commons.fileupload.*" %>
<%@ include file="/page/maint/common/initNoCache.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="baseBean" class="weaver.general.BaseBean" scope="page" />
<%
String method = Util.null2String(request.getParameter("method"));
if(method.equals("update")){
String tbname = Util.null2String(request.getParameter("tbname"));
String field = Util.null2String(request.getParameter("field"));
String value = Util.null2String(request.getParameter("value"));
String updateSql = "update "+tbname+"Temp set "+field+" = '"+value+"'";
rs.execute(updateSql);
//baseBean.writeLog("------------updateSql:"+updateSql);
}else if(method.equals("commit&enable")){
String id = Util.null2String(request.getParameter("loginTemplateId"));
doCommitTempDateAndEnable("SystemLoginTemplate",id);
}else if(method.equals("commit")){
String id = Util.null2String(request.getParameter("loginTemplateId"));
doCommitTempDate("SystemLoginTemplate",id);
}else if(method.equals("delete")){
String id = Util.null2String(request.getParameter("loginTemplateId"));
//doCommitTempDate("SystemLoginTemplate",id);
String updateSql = "delete from SystemLoginTemplate where logintemplateid="+id;
rs.execute(updateSql);
}
%>
<%!
public void doCommitTempDate(String table,String id){
RecordSet rs = new RecordSet();
RecordSet rs2 = new RecordSet();
rs.execute("select * from "+table+"Temp where logintemplateid="+id);
if(rs.next()){
String commitSql = "update "+table+" set logintemplatename='"+rs.getString("logintemplatename")+"'"
+",logintemplatetitle='"+rs.getString("logintemplatetitle")+"'"
+",templatetype='"+rs.getString("templatetype")+"'"
+",imageid='"+rs.getString("imageid")+"'"
+",modeid='"+rs.getString("modeid")+"'"
+",imageid2='"+rs.getString("imageid2")+"'"
+",menuId='"+rs.getString("menuId")+"'"
+",menuType='"+rs.getString("menuType")+"'"
+",menuTypeId='"+rs.getString("menuTypeId")+"'"
+",defaultshow='"+rs.getString("defaultshow")+"'"
+",leftmenuid='"+rs.getString("leftmenuid")+"'"
+",leftmenustyleid='"+rs.getString("leftmenustyleid")+"'"
+",lasteditdate='"+TimeUtil.getCurrentDateString()+"'";
if("SystemLoginTemplate".equalsIgnoreCase(table)){//add by wshen 新增记住用户名密码操作
commitSql+=",isRememberPW="+Util.getIntValue(rs.getString("isRememberPW"),0);
commitSql+=",domainName='"+Util.null2String(rs.getString("domainName"))+"'";
commitSql+=",recordcode='"+Util.null2String(rs.getString("recordcode"))+"'";
}
commitSql+=" where logintemplateid="+id;
rs2.execute(commitSql);
}
}
public void doCommitTempDateAndEnable(String table,String id){
RecordSet rs = new RecordSet();
RecordSet rs2 = new RecordSet();
rs.execute("select * from "+table+"Temp where logintemplateid="+id);
if(rs.next()){
String commitSql = "update "+table+" set logintemplatename='"+rs.getString("logintemplatename")+"'"
+",logintemplatetitle='"+rs.getString("logintemplatetitle")+"'"
+",templatetype='"+rs.getString("templatetype")+"'"
+",modeid='"+rs.getString("modeid")+"'"
+",imageid='"+rs.getString("imageid")+"'"
+",imageid2='"+rs.getString("imageid2")+"'"
+",menuId='"+rs.getString("menuId")+"'"
+",menuType='"+rs.getString("menuType")+"'"
+",menuTypeId='"+rs.getString("menuTypeId")+"'"
+",defaultshow='"+rs.getString("defaultshow")+"'"
+",leftmenuid='"+rs.getString("leftmenuid")+"'"
+",leftmenustyleid='"+rs.getString("leftmenustyleid")+"'"
+",lasteditdate='"+TimeUtil.getCurrentDateString()+"'";
if("SystemLoginTemplate".equalsIgnoreCase(table)){//add by wshen 新增记住用户名密码操作
commitSql+=",isRememberPW="+Util.getIntValue(rs.getString("isRememberPW"),0);
commitSql+=",domainName='"+Util.null2String(rs.getString("domainName"))+"'";
commitSql+=",recordcode='"+Util.null2String(rs.getString("recordcode"))+"'";
}
commitSql+=" where logintemplateid="+id;
rs2.execute(commitSql);
}
rs2.execute("update SystemLoginTemplate set iscurrent='0' where iscurrent='1'");
rs2.execute("update SystemLoginTemplate set iscurrent='1' where logintemplateid="+id);
}
%>