batchmodifyOperation.jsp
4.25 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
106
107
108
109
110
111
112
113
114
115
116
<%@page import="weaver.formmode.setup.ModeSetUtil"%>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*,weaver.general.GCONST" %>
<%@ page import="weaver.conn.*" %>
<%@page import="com.weaver.formmodel.util.StringHelper" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/formmode/checkright4setting.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="modeSetUtil" class="weaver.formmode.setup.ModeSetUtil" scope="page" />
<%
String modeid = Util.null2String(request.getParameter("modeid"));
String id = Util.null2String(request.getParameter("id"));
String formid = Util.null2String(request.getParameter("formid"));
String name = Util.null2String(request.getParameter("name"));
String remark = Util.null2String(request.getParameter("remark"));
String saveflag = Util.null2String(request.getParameter("saveflag"));
String deleteflag = Util.null2String(request.getParameter("deleteflag")); //删除标志zwbo
String[] feildids = request.getParameterValues("feildid");
String[] changetypes = request.getParameterValues("changetype");
String[] defaultvalues = request.getParameterValues("defaultvalue");
if("".equals(id)){//创建
RecordSetTrans rst = new RecordSetTrans();
try{
rst.setAutoCommit(false);
String sqlmain="insert into mode_batchmodify(name,remark,modeid,formid)values('"+name+"','"+remark+"',"+StringHelper.empty2Null(modeid)+","+StringHelper.empty2Null(formid)+")";
rst.executeSql(sqlmain);
rst.executeSql("select max(id) as id from mode_batchmodify");
int mainid = 0;
if(rst.next()){
mainid=rst.getInt(1);
}
id=mainid+"";
String sqldetail="";
for(int i=0;i<feildids.length;i++){
if(feildids[i]==null||"".equals(feildids[i])){
continue;
}
sqldetail = "insert into mode_batchmodifydetail(mainid,feildid,changetype,feildvalue)values("
+mainid+","+StringHelper.empty2Null(feildids[i])+","+StringHelper.empty2Null(changetypes[i])+",'"+defaultvalues[i]+"')";
rst.executeSql(sqldetail);
}
rst.commit();
}catch(Exception e){
e.printStackTrace();
rst.rollback();
}
}else{//修改或删除
if(deleteflag.equals("0")){
//修改操作
RecordSetTrans rst = new RecordSetTrans();
try{
rst.setAutoCommit(false);
String sqlmain="update mode_batchmodify set name='"+name+"',remark='"+remark+"',modeid="+StringHelper.empty2Null(modeid)+",formid="+StringHelper.empty2Null(formid)+" where id="+StringHelper.empty2Null(id);
rst.executeSql(sqlmain);
String deldetailsql="delete from mode_batchmodifydetail where mainid ="+StringHelper.empty2Null(id);
rst.executeSql(deldetailsql);
String sqldetail="";
for(int i=0;i<feildids.length;i++){
if(feildids[i]==null||"".equals(feildids[i])){
continue;
}
sqldetail = "insert into mode_batchmodifydetail(mainid,feildid,changetype,feildvalue)values("
+StringHelper.empty2Null(id)+","+StringHelper.empty2Null(feildids[i])+","+StringHelper.empty2Null(changetypes[i])+",'"+defaultvalues[i]+"')";
rst.executeSql(sqldetail);
}
rst.commit();
}catch(Exception e){
e.printStackTrace();
rst.rollback();
}
}else if(deleteflag.equals("1")){
//删除操作zwbo
RecordSetTrans rst = new RecordSetTrans();
try{
rst.setAutoCommit(false);
String sqlmain="delete mode_batchmodify where id= ? ";
rst.executeUpdate(sqlmain,id);
String deldetailsql="delete from mode_batchmodifydetail where mainid =?";
rst.executeUpdate(deldetailsql,id);
rst.commit();
}catch(Exception e){
e.printStackTrace();
rst.rollback();
}
}
}
%>
<script>
//var parentWin = parent.parent.getParentWindow(parent);
//var dialog = parent.parent.getDialog(parent);
<%
if(deleteflag.equals("1")){//删除操作zwbo
%>
strname=" ";
var returnjson = {id:'',name:strname};
parent.closeWinAFrsh(returnjson);
<%
}
else if(saveflag.equals("1")){//保存并使用
%>
var strname = '<%=name%>';
strname="<a href=\""+"javascript:modifyfeild(<%=id%>)\">"+strname+"</a>";
var returnjson = {id:'<%=id%>',name:strname};
parent.closeWinAFrsh(returnjson);
<%
}else{//保存并关闭
%>
parent.closeWinAFrsh();
<%
}
%>
</script>