WebSiteOperation.jsp
5.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
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
<%@ page import="weaver.general.Util" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="Util" class="weaver.general.Util" scope="page" />
<%
String sqlStr = "" ;
String method = Util.null2String(request.getParameter("method"));
if(method.equals("add"))
{
String name=Util.null2String(request.getParameter("name"));
String linkKey=Util.null2String(request.getParameter("linkKey"));
String newsId=Util.fromScreen2(request.getParameter("newsId"),user.getLanguage());
String type=Util.fromScreen2(request.getParameter("type"),user.getLanguage());
name=name.trim();
linkKey=linkKey.trim();
sqlStr = "select id from webSite where linkKey = '" + Util.fromScreen2(linkKey,user.getLanguage()) + "'";
RecordSet.executeSql(sqlStr);
if (RecordSet.next()) {response.sendRedirect("/web/data/WebSite.jsp?error=1&name="+name+"&linkKey="+linkKey+"&newsId="+newsId+"&type="+type);}
else {
sqlStr = "insert into webSite(name,linkKey,newsId,type) values(";
sqlStr +="'"+Util.fromScreen2(name,user.getLanguage())+"'," ;
sqlStr +="'"+Util.fromScreen2(linkKey,user.getLanguage())+"'," ;
sqlStr +=newsId+"," ;
sqlStr +="'"+type+"'" ;
sqlStr +=")";
RecordSet.executeSql(sqlStr);
sqlStr = "select max(id) from webSite " ;
String id = "" ;
RecordSet.executeSql(sqlStr);
if(RecordSet.next()) id = RecordSet.getString(1) ;
if (type.equals("7")) //调查表 begin
{
Calendar todaycal = Calendar.getInstance ();
String reportdate = Util.add0(todaycal.get(Calendar.YEAR), 4) +"-"+
Util.add0(todaycal.get(Calendar.MONTH) + 1, 2) +"-"+
Util.add0(todaycal.get(Calendar.DAY_OF_MONTH) , 2) ;
String inprepname = "" ;
String rsearchname = "" ;
String inputid = "" ;
sqlStr = "select inprepname from T_SurveyItem where inprepid="+newsId ;
RecordSet.executeSql(sqlStr) ;
if(RecordSet.next())
inprepname = Util.fromScreen2(RecordSet.getString("inprepname"),user.getLanguage()) ;
rsearchname = inprepname +"~"+ reportdate;
sqlStr = " INSERT INTO T_ResearchTable (inprepid,rsearchname,rsearchdate,countfrom,countemial,state) VALUES("+newsId+",'"+rsearchname+"','"+reportdate+"',"+"0,0"+",0)" ;
RecordSet.executeSql(sqlStr);
sqlStr = "select max(inputid) from T_ResearchTable where inprepid="+newsId ;
RecordSet.executeSql(sqlStr);
if(RecordSet.next()) inputid = RecordSet.getString(1) ;
sqlStr = "update webSite set researchId = "+inputid+" where id="+id ;
RecordSet.executeSql(sqlStr);
} //调查表 end
response.sendRedirect("/web/data/WebSite.jsp");
}
return;
}
String webIDs[]=request.getParameterValues("webIDs");
if(method.equals("delete"))
{
if(webIDs != null)
{
for(int i=0;i<webIDs.length;i++)
{
sqlStr = "DELETE FROM webSite where id=" + webIDs[i];
RecordSet.executeSql(sqlStr);
}
}
response.sendRedirect("/web/data/WebSite.jsp");
return;
}
if(method.equals("edit"))
{
String id=Util.null2String(request.getParameter("id"));
String name=Util.null2String(request.getParameter("name"));
String linkKey=Util.null2String(request.getParameter("linkKey"));
String newsId=Util.fromScreen2(request.getParameter("newsId"),user.getLanguage());
String type=Util.fromScreen2(request.getParameter("type"),user.getLanguage());
name=name.trim();
linkKey=linkKey.trim();
sqlStr = "select id from webSite where linkKey = '" + Util.fromScreen2(linkKey,user.getLanguage()) + "'";
RecordSet.executeSql(sqlStr);
if (RecordSet.next() && (!id.equals(RecordSet.getString("id"))))
response.sendRedirect("/web/data/WebSite.jsp?id="+id+"&error=1&name="+name+"&linkKey="+linkKey+"&newsId="+newsId+"&type="+type);
else {
sqlStr = "select newsId from webSite where id = " + id ;
RecordSet.executeSql(sqlStr);
RecordSet.next();
String newsIdTemp = RecordSet.getString("newsId");
sqlStr = "UPDATE webSite set " ;
sqlStr += " name = '" + Util.fromScreen2(name,user.getLanguage()) + "' , " ;
sqlStr += " linkKey = '" + Util.fromScreen2(linkKey,user.getLanguage()) + "' , " ;
sqlStr += " newsId = " + newsId + " , ";
sqlStr += " type = '" + type + "' " ;
sqlStr += " where id = " + id ;
RecordSet.executeSql(sqlStr);
if ((!newsIdTemp.equals(newsId))&&(type.equals("7"))) //调查表 begin
{
Calendar todaycal = Calendar.getInstance ();
String reportdate = Util.add0(todaycal.get(Calendar.YEAR), 4) +"-"+
Util.add0(todaycal.get(Calendar.MONTH) + 1, 2) +"-"+
Util.add0(todaycal.get(Calendar.DAY_OF_MONTH) , 2) ;
String inprepname = "" ;
String rsearchname = "" ;
String inputid = "" ;
sqlStr = "select inprepname from T_SurveyItem where inprepid="+newsId ;
RecordSet.executeSql(sqlStr) ;
if(RecordSet.next())
inprepname = Util.fromScreen2(RecordSet.getString("inprepname"),user.getLanguage()) ;
rsearchname = inprepname +"~"+ reportdate;
sqlStr = " INSERT INTO T_ResearchTable (inprepid,rsearchname,rsearchdate,countfrom,countemial,state) VALUES("+newsId+",'"+rsearchname+"','"+reportdate+"',"+"0,0"+",0)" ;
RecordSet.executeSql(sqlStr);
sqlStr = "select max(inputid) from T_ResearchTable where inprepid="+newsId ;
RecordSet.executeSql(sqlStr);
if(RecordSet.next()) inputid = RecordSet.getString(1) ;
sqlStr = "update webSite set researchId = "+inputid+" where id="+id ;
RecordSet.executeSql(sqlStr);
} //调查表 end
response.sendRedirect("/web/data/WebSite.jsp");
}
return;
}
%>