excelStyleOperation.jsp
4.51 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="styleManager" class="weaver.formmode.exceldesign.StyleManager" scope="page" />
<%@ page import="net.sf.json.JSONObject" %>
<%@ page import="java.util.*" %>
<%
int styleid = Util.getIntValue(request.getParameter("styleid"),0);
String stylename = Util.null2String(request.getParameter("stylename"));
int main_row_height = Util.getIntValue(request.getParameter("main_row_height"),0);
int main_lable_width = Util.getIntValue(request.getParameter("main_lable_width"),0);
int main_label_width_select = Util.getIntValue(request.getParameter("main_label_width_select"),0);
int main_field_width = Util.getIntValue(request.getParameter("main_field_width"),0);
int main_field_width_select = Util.getIntValue(request.getParameter("main_field_width_select"),0);
String main_border = Util.null2String(request.getParameter("main_border"));
String main_label_bgcolor = Util.null2String(request.getParameter("main_label_bgcolor"));
String main_field_bgcolor = Util.null2String(request.getParameter("main_field_bgcolor"));
int detail_row_height = Util.getIntValue(request.getParameter("detail_row_height"),0);
int detail_col_width = Util.getIntValue(request.getParameter("detail_col_width"),0);
int detail_col_width_select = Util.getIntValue(request.getParameter("detail_col_width_select"),0);
String detail_border = Util.null2String(request.getParameter("detail_border"));
String detail_label_bgcolor = Util.null2String(request.getParameter("detail_label_bgcolor"));
String detail_field_bgcolor = Util.null2String(request.getParameter("detail_field_bgcolor"));
String method = Util.null2String(request.getParameter("method"));
String sql = "";
String isadd = "false";
if(method.equals("operat"))
{
if(styleid > 0)
{
sql = "update excelStyleDec set stylename='"+stylename+"',mainrowheight="+main_row_height+",mainlblwidth="+main_lable_width+",";
sql += "mainlblwidthselect="+main_label_width_select+",";
sql += "mainfieldwidth="+main_field_width+",mainfieldwidthselect="+main_field_width_select+",";
sql += "mainborder='"+main_border+"',mainlblbgcolor='"+main_label_bgcolor+"',mainfieldbgcolor='"+main_field_bgcolor+"',";
sql += "detailrowheight="+detail_row_height+",detailcolwidth="+detail_col_width+",detailcolwidthselect="+detail_col_width_select+",";
sql += "detailborder='"+detail_border+"',detaillblbgcolor='"+detail_label_bgcolor+"',detailfieldbgcolor='"+detail_field_bgcolor+"' where ";
sql += "id="+styleid;
}else
{
isadd = "true";
sql = "insert into excelStyleDec(stylename,mainrowheight,mainlblwidth,mainlblwidthselect,mainfieldwidth,mainfieldwidthselect,mainborder,mainlblbgcolor,mainfieldbgcolor,"+
"detailrowheight,detailcolwidth,detailcolwidthselect,detailborder,detaillblbgcolor,detailfieldbgcolor) values (";
sql += "'"+stylename+"',"+main_row_height+","+main_lable_width+","+main_label_width_select+","+main_field_width+","+main_field_width_select+",";
sql += "'"+main_border+"','"+main_label_bgcolor+"','"+main_field_bgcolor+"',"+detail_row_height+","+detail_col_width+","+detail_col_width_select+",";
sql += "'"+detail_border+"','"+detail_label_bgcolor+"','"+detail_field_bgcolor+"')";
}
if(sql.length() > 0)
{
RecordSet.executeSql(sql);
if(styleid > 0);
else{
String maxidsql = "select max(id) styleid from excelStyleDec";
RecordSet.executeSql(maxidsql);
if(RecordSet.first())
styleid = Util.getIntValue(RecordSet.getString("styleid"));
}
}
response.sendRedirect("/formmode/exceldesign/excelStyleDesign.jsp?isclose=on&isadd="+isadd+"&styleid="+styleid);
return;
}else if(method.equals("searchone")){
if(styleid > 0){
Map map = styleManager.searchSingleStyle(styleid);
JSONObject reval = JSONObject.fromObject(map);
response.getWriter().write(reval.toString());
}
}else if(method.equals("searchsysone")){
Map map = styleManager.getSingleSysStyle(styleid);
JSONObject reval = JSONObject.fromObject(map);
response.getWriter().write(reval.toString());
}else if(method.equals("searchall")){
LinkedHashMap map = styleManager.searchAllStyle();
JSONObject reval = JSONObject.fromObject(map);
response.getWriter().write(reval.toString());
}else if(method.equals("deleteone"))
{
sql = "delete from excelStyleDec where id="+styleid;
RecordSet.executeSql(sql);
response.getWriter().write("true");
}
%>