CustomBrowserOperation.jsp
4.67 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="ReportComInfo" class="weaver.workflow.report.ReportComInfo" scope="page" />
<%
if (!HrmUserVarify.checkUserRight("ModeSetting:All", user)) {
response.sendRedirect("/notice/noright.jsp");
return;
}
String operation = Util.null2String(request.getParameter("operation"));
char separator = Util.getSeparator() ;
if(operation.equals("customadd"))
{
String Customname = "" + Util.null2String(request.getParameter("Customname"));
String modeid = "" + Util.getIntValue(request.getParameter("modeid"), 0);
String Customdesc = "" + Util.fromScreen3(request.getParameter("Customdesc"),user.getLanguage());
RecordSet.execute("INSERT INTO mode_custombrowser(modeid,customname,customdesc) VALUES ( "+ modeid + ", '" + Customname + "','"+Customdesc+"')");
RecordSet.executeSql("select max(id) as id from mode_custombrowser");
RecordSet.next();
String queryid = RecordSet.getString("id");
String para = queryid ;
RecordSet.executeProc("mode_C_BrowserDspField_Init",para);
response.sendRedirect("/formmode/browser/CustomBrowserEdit.jsp?id="+queryid);
}
else if(operation.equals("customedit")){//保存对表单中流程的修改
String id = ""+Util.getIntValue(request.getParameter("id"), 0);
String Customname = "" + Util.null2String(request.getParameter("Customname"));
String Customdesc = "" + Util.fromScreen3(request.getParameter("Customdesc"),user.getLanguage());
String modeid = Util.null2String(request.getParameter("modeid"));//如果模式id修改了，而且表单不一样，则删除原先的数据。
String defaultsql = "" + Util.fromScreen(request.getParameter("defaultsql"),user.getLanguage());
String sql = "";
/**
sql = "select * from modeinfo where id = "+modeid+" and formid in(select formid from mode_CustomSearch a,modeinfo b where a.modeid = b.id and a.id = "+id+")";
rs.executeSql(sql);
if(!rs.next()){
sql = "delete from mode_CustomBrowserDspField where customid = " + id;
rs.executeSql(sql);
}
**/
RecordSet.execute("update mode_custombrowser set Customname='"+Customname+"',Customdesc='"+Customdesc+"',defaultsql='"+defaultsql+"',modeid='"+modeid+"' where id="+id);
response.sendRedirect("/formmode/browser/CustomBrowserEdit.jsp?id="+id);
}
else if(operation.equals("customdelete"))
{
int id = Util.getIntValue(request.getParameter("id"));
int modeid = Util.getIntValue(request.getParameter("modeid"));
String sql = "";
sql = "delete from mode_custombrowser where id=" + id;
rs.execute(sql);
sql = "delete from mode_custombrowserDspField where customid = " + id;
rs.executeSql(sql);
response.sendRedirect("/formmode/browser/CustomBrowser.jsp?modeid="+modeid);
}
else if(operation.equals("formfieldadd"))
{
int tmpcount=Util.getIntValue(request.getParameter("tmpcount"), 0);
String id = Util.null2String(request.getParameter("id"));
RecordSet.executeSql("delete from mode_custombrowserDspField where customid="+id);
for(int i=0;i<=tmpcount;i++)
{
String fieldid = "" + Util.getIntValue(request.getParameter("fieldid_"+i),0);
String dsporder = ""+Util.getIntValue(request.getParameter("dsporder_" + i),0);
String isquery = Util.null2String(request.getParameter("isquery_" + i));
String isshows = Util.null2String(request.getParameter("isshows_" + i));
String queryorder = ""+Util.getIntValue(request.getParameter("queryorder_" + i),0);
String istitle = ""+Util.getIntValue(request.getParameter("istitles_" + i),0);
if (isquery.equals("")) {
isquery = "0";
}
if (isshows.equals("")) {
isshows = "0";
}
if (istitle.equals("")) {
istitle = "0";
}
if(isquery.equals("1")||isshows.equals("1"))
{
String para = id + separator + fieldid + separator + isquery + separator+ isshows + separator + dsporder + separator +queryorder + separator + istitle;
RecordSet.executeProc("mode_C_BrowserDspField_Insert",para);
}
}
response.sendRedirect("/formmode/browser/CustomBrowserEdit.jsp?id="+id);
}
else if(operation.equals("deletefield"))
{
String id = Util.null2String(request.getParameter("id"));
String fieldID = "" + Util.getIntValue(request.getParameter("theid"), 0);
RecordSet.execute("delete from mode_custombrowserDspField where id="+fieldID+" and customid="+id);
response.sendRedirect("/formmode/browser/CustomBrowserEdit.jsp?id="+id);
}
%>