LayoutDtlQuerySetOperation.jsp
4.15 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@page import="weaver.formmode.service.CustomSearchService"%>
<%@page import="org.apache.lucene.util.StringHelper"%>
<%@page import="weaver.systeminfo.SystemEnv"%>
<%@page import="weaver.workflow.workflow.BillComInfo"%>
<%@page import="weaver.formmode.service.CommonConstant"%>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ taglib uri="/browserTag" prefix="brow"%>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
if(!HrmUserVarify.checkUserRight("ModeSetting:All", user)){
response.sendRedirect("/notice/noright.jsp");
return;
}
%>
<%
int id = Util.getIntValue(request.getParameter("id"), 0);
String searchconditiontype = "1";
String defaultsql = "" + Util.fromScreen(request.getParameter("defaultsql"),user.getLanguage());
defaultsql=defaultsql.replaceAll("<br>", "");
String javafileAddress = Util.null2String(request.getParameter("javafileAddress"));
String javafilename = Util.null2String(request.getParameter("javafilename"));
String action = Util.null2String(request.getParameter("action"));
String type = Util.null2String(request.getParameter("type"));
String modeId = Util.null2String(request.getParameter("modeId"));
String formId = Util.null2String(request.getParameter("formId"));
String layoutid = Util.null2String(request.getParameter("layoutid"));
String[] searchConditionTypeArr = request.getParameterValues("searchConditionType");
if(searchConditionTypeArr != null && searchConditionTypeArr.length > 0){
searchconditiontype = searchConditionTypeArr[0];
}
int isecme = Util.getIntValue(request.getParameter("isecme"),0);
int feaid = Util.getIntValue(request.getParameter("feaid"),0);
int tableid = Util.getIntValue(request.getParameter("tableid"),0);
String sql = "";
int ecmeModeid = 0;
if(isecme == 1 ){
sql = "select * from ecme_feainfo where id = ?";
rs.executeQuery(sql,feaid);
if(rs.next()){
ecmeModeid = rs.getInt("modeid");
}
}
if("save".equals(action)){
if(id>0){//修改
if(isecme == 1 ){
sql = "update ecme_layout_querySql set queryType='"+searchconditiontype+"',sqlConetent='"+defaultsql+"',javaFileName='"+javafilename+"',javafileAddress='"+javafileAddress+"' where id = '"+id+"'";
}else{
sql = "update mode_layout_querySql set queryType='"+searchconditiontype+"',sqlConetent='"+defaultsql+"',javaFileName='"+javafilename+"',javafileAddress='"+javafileAddress+"' where id = '"+id+"'";
}
}else{//新增
if(isecme == 1 ){
sql = "insert into ecme_layout_querySql(modeid,feaid,layoutid,tableid,queryType,sqlConetent,javaFileName,javafileAddress) values('"+ecmeModeid+"','"+feaid+"','"+layoutid+"','"+tableid+"','"+searchconditiontype+"','"+defaultsql+"','"+javafilename+"','"+javafileAddress+"')";
}else{
sql = "insert into mode_layout_querySql(modeid,formid,layoutid,detailtype,queryType,sqlConetent,javaFileName,javafileAddress) values('"+modeId+"','"+formId+"','"+layoutid+"','"+type+"','"+searchconditiontype+"','"+defaultsql+"','"+javafilename+"','"+javafileAddress+"')";
}
}
rs.executeSql(sql);
String close = Util.null2String(request.getParameter("close"));
if("1".equals(close)){
%>
<script language="javascript">
parent.getDialog(window).close();
</script>
<%
return;
}else{
if(isecme ==1 ){
sql = "select * from ecme_layout_querySql where modeid = '"+ecmeModeid+"' and feaid='"+feaid+"' and layoutid ='"+layoutid+"' and tableid='"+tableid+"' order by id desc";
}else{
sql = "select * from mode_layout_querySql where modeid = '"+modeId+"' and formId='"+formId+"' and layoutid ='"+layoutid+"' and detailtype='"+type+"' order by id desc";
}
rs.executeSql(sql);
if(rs.next()){
id = Util.getIntValue(rs.getString("id"), 0);
}
response.sendRedirect("/formmode/setup/LayoutDtlQuerySet.jsp?layoutid="+layoutid+"&type="+type+"&modeId="+modeId+"&formId="+formId+"&id="+id+"&success=1&isecme="+isecme+"&feaid="+feaid+"tableid="+tableid);
}
}else if("clear".equals(action)){
if(isecme == 1 ){
sql = "delete from ecme_layout_querySql where id = '"+id+"'";
}else{
sql = "delete from mode_layout_querySql where id = '"+id+"'";
}
rs.executeSql(sql);
%>
<script language="javascript">
parent.getDialog(window).close();
</script>
<%
}
%>