serviceReg_3Operation.jsp
6.05 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
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ include file="/integration/integrationinit.jsp" %>
<%@ page import=" com.weaver.integration.datesource.*" %>
<%@ page import=" com.weaver.integration.params.*" %>
<%@ page import=" com.weaver.integration.log.*" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page"/>
<jsp:useBean id="rs2" class="weaver.conn.RecordSet" scope="page"/>
<%
String flag="0";//0保存失败,1保存成功
boolean parseFlag = false;
//save--保存,update--修改,delete-删除
String opera=Util.null2String(request.getParameter("opera"));
String id=Util.null2String(request.getParameter("ids"));
if(!"".equals(id)&&(id.length()==(id.lastIndexOf(",")+1)))
{
id=id.substring(0,(id.length()-1));
}
String hpid=Util.null2String(request.getParameter("hpid"));
String poolid=Util.null2String(request.getParameter("poolid"));
String funname=Util.null2String(request.getParameter("funname"));
String fundesc=Util.null2String(request.getParameter("fundesc"));
String serdesc=Util.null2String(request.getParameter("serdesc"));
String regname=Util.null2String(request.getParameter("regname"));
String loadmb=Util.getIntValue(request.getParameter("loadmb")+"",0)+"";
String loadDate=Util.getIntValue(request.getParameter("loadDate")+"",0)+"";
String isParseParams = Util.null2String(request.getParameter("isParseParams"));
String sql="";
String tempid =" ";
if("save".equals(opera))
{
sql=" insert into sap_service (poolid,funname,fundesc,serdesc,regname,hpid,loadmb,loadDate)";
sql+=" values ('"+poolid+"','"+funname+"','"+fundesc+"','"+serdesc+"','"+regname+"','"+hpid+"','"+loadmb+"','"+loadDate+"')";
if(rs.execute(sql))
{
flag="1";
tempid = (SAPInterationDateSourceUtil.getMaxSapServiceNum(hpid)-1)+"";
}
SAPInterationOutUtil sou = new SAPInterationOutUtil();
LogInfo li = new LogInfo();
if("yes".equals(isParseParams)) {
//从sap获取所有的参数列表
List list = ServiceParamsUtil.changeTypeBySAPAllBean(sou.getALLParamsByFunctionName(poolid, funname, li));
//更新int_serviceParams表里面的数据
parseFlag = ServiceParamsUtil.insertServiceParams(list, tempid);
//更新int_servicecompparamslist表里面的数据
ServiceParamsUtil.insertServiceCompParms(poolid, funname, tempid, li);
}
response.sendRedirect("/integration/serviceReg/serviceReg_3New.jsp?closeDialog=close&isNew=1&id="+hpid);
return;
}else if("update".equals(opera))
{
sql=" update sap_service set poolid='"+poolid+"',funname='"+funname+"',fundesc='"+fundesc+"',serdesc='"+serdesc+"',regname='"+regname+"',loadmb='"+loadmb+"',loadDate='"+loadDate+"'";
sql+=" where id='"+id+"'";
if(rs.execute(sql))
{
flag="1";
tempid = id;
ServiceParamsUtil.delParamsByServId(tempid);
}
SAPInterationOutUtil sou = new SAPInterationOutUtil();
LogInfo li = new LogInfo();
if("yes".equals(isParseParams)) {
//从sap获取所有的参数列表
List list = ServiceParamsUtil.changeTypeBySAPAllBean(sou.getALLParamsByFunctionName(poolid, funname, li));
//更新int_serviceParams表里面的数据
parseFlag = ServiceParamsUtil.insertServiceParams(list, tempid);
//更新int_servicecompparamslist表里面的数据
ServiceParamsUtil.insertServiceCompParms(poolid, funname, tempid, li);
}
response.sendRedirect("/integration/serviceReg/serviceReg_3New.jsp?closeDialog=close&isNew=1&id="+id);
return;
}else if("delete".equals(opera))
{
sql=" delete sap_service where id in("+id+")";
if(rs.execute(sql))
{
flag="1";
tempid = id;
ServiceParamsUtil.delParamsByServId(tempid);
}
String isDialog=Util.null2String(request.getParameter("isDialog"));
if("1".equals(isDialog)){
response.sendRedirect("/integration/serviceReg/serviceReg_3New.jsp?closeDialog=close&isNew=1&id="+id);
return;
}
}else if("updatedesc".equals(opera))
{
sql=" update sap_service set serdesc='"+serdesc+"',loadmb='"+loadmb+"',loadDate='"+loadDate+"',regname='"+regname+"'";
sql+=" where id='"+id+"'";
if(rs.execute(sql))
{
flag="1";
tempid = id;
}
SAPInterationOutUtil sou = new SAPInterationOutUtil();
LogInfo li = new LogInfo();
if("yes".equals(isParseParams)) {
//从sap获取所有的参数列表
List list = ServiceParamsUtil.changeTypeBySAPAllBean(sou.getALLParamsByFunctionName(poolid, funname, li));
//更新int_serviceParams表里面的数据
parseFlag = ServiceParamsUtil.insertServiceParams(list, tempid);
//更新int_servicecompparamslist表里面的数据
ServiceParamsUtil.insertServiceCompParms(poolid, funname, tempid, li);
}
response.sendRedirect("/integration/serviceReg/serviceReg_3New.jsp?closeDialog=close&isNew=1&id="+id);
return;
}else if("refresh".equals(opera))
{
//删除int_serviceParams,int_serviceCompParamsList表里面的数据
flag="1";
tempid = id;
rs.execute("delete int_servParamModeDis where servid in("+tempid+")");
ServiceParamsUtil.delParamsByServId(tempid);
}
SAPInterationOutUtil sou = new SAPInterationOutUtil();
LogInfo li = new LogInfo();
if("yes".equals(isParseParams)) {
//从sap获取所有的参数列表
List list = ServiceParamsUtil.changeTypeBySAPAllBean(sou.getALLParamsByFunctionName(poolid, funname, li));
//更新int_serviceParams表里面的数据
parseFlag = ServiceParamsUtil.insertServiceParams(list, tempid);
//更新int_servicecompparamslist表里面的数据
ServiceParamsUtil.insertServiceCompParms(poolid, funname, tempid, li);
}
%>
<script type="text/javascript">
<!--
if(<%=flag%>==1)
{
alert("<%=SystemEnv.getHtmlLabelName(30700,user.getLanguage())%>!");
}else
{
alert("<%=SystemEnv.getHtmlLabelName(30651,user.getLanguage())%>!");
}
<%if("delete".equals(opera)) {%>
window.location.href="/integration/serviceReg/serviceReg_3list.jsp?hpid="+<%=hpid%>;
<%}else {%>
window.location.href="/integration/serviceReg/serviceReg_3New.jsp?isNew=1&id="+<%=tempid%>;
<%}%>
//-->
</script>