qrCodeOperation.jsp
2.75 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util"%>
<%@ page import="weaver.system.code.*"%>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@page import="com.weaver.formmodel.util.StringHelper" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
if (!HrmUserVarify.checkUserRight("ModeSetting:All", user)) {
response.sendRedirect("/notice/noright.jsp");
return;
}
%>
<%
String modeId= Util.null2String(request.getParameter("modeId"));
int txtUserUse= Util.getIntValue(request.getParameter("txtUserUse"),0);
String targetType= Util.null2String(request.getParameter("targetType"));
String targetUrl= Util.null2String(request.getParameter("targetUrl"));
String w= Util.null2String(request.getParameter("w"));
String h= Util.null2String(request.getParameter("h"));
String baseinfo= Util.null2String(request.getParameter("baseinfo"));
String levelspacing = Util.null2String(request.getParameter("levelspacing"));
String verticalspacing = Util.null2String(request.getParameter("verticalspacing"));
String numberrows = Util.null2String(request.getParameter("numberrows"));
String numbercols = Util.null2String(request.getParameter("numbercols"));
if("".equals(levelspacing)) levelspacing = null;
if("".equals(verticalspacing)) verticalspacing = null;
if("".equals(numberrows)) numberrows = null;
if("".equals(numbercols)) numbercols = null;
rs.executeSql("select 1 from ModeQRCode where modeid="+StringHelper.empty2Null( modeId));
if (rs.next()) {
String updateSql = "update ModeQRCode set ";
updateSql += "isuse="+txtUserUse+",targetType="+StringHelper.empty2Null(targetType)+",targetUrl='"+targetUrl+"',width="+StringHelper.empty2Null(w)+",height="+StringHelper.empty2Null(h)+",qrCodeDesc='"+baseinfo+"'";
updateSql += ",levelspacing="+StringHelper.empty2Null(levelspacing)+",verticalspacing="+StringHelper.empty2Null(verticalspacing)+",numberrows="+StringHelper.empty2Null(numberrows)+",numbercols="+StringHelper.empty2Null(numbercols);
updateSql += " where modeid="+StringHelper.empty2Null(modeId);
rs.executeSql(updateSql);
} else {
String insertSql = "insert into ModeQRCode";
insertSql += "(modeid,isuse,targetType,targetUrl,width,height,qrCodeDesc,levelspacing,verticalspacing,numberrows,numbercols)";
insertSql += " values ";
insertSql += "("+StringHelper.empty2Null(modeId)+","+txtUserUse+","+StringHelper.empty2Null(targetType)+",'"+targetUrl+"',"+StringHelper.empty2Null(w)+","+StringHelper.empty2Null(h)+",'"+baseinfo+"',"+StringHelper.empty2Null(levelspacing)+","+StringHelper.empty2Null(verticalspacing)+","+StringHelper.empty2Null(numberrows)+","+StringHelper.empty2Null(numbercols)+")";
rs.executeSql(insertSql);
}
response.sendRedirect("QRCode.jsp?modeId="+modeId);
%>