-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathapplydeal.asp
297 lines (255 loc) · 9.89 KB
/
applydeal.asp
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
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001" %>
<%
' *** Logout the current user.
MM_Logout = CStr(Request.ServerVariables("URL")) & "?MM_Logoutnow=1"
If (CStr(Request("MM_Logoutnow")) = "1") Then
Session.Contents.Remove("MM_Admin")
Session.Contents.Remove("MM_AdminAuthorization")
MM_logoutRedirectPage = "index.asp"
' redirect with URL parameters (remove the "MM_Logoutnow" query param).
if (MM_logoutRedirectPage = "") Then MM_logoutRedirectPage = CStr(Request.ServerVariables("URL"))
If (InStr(1, UC_redirectPage, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then
MM_newQS = "?"
For Each Item In Request.QueryString
If (Item <> "MM_Logoutnow") Then
If (Len(MM_newQS) > 1) Then MM_newQS = MM_newQS & "&"
MM_newQS = MM_newQS & Item & "=" & Server.URLencode(Request.QueryString(Item))
End If
Next
if (Len(MM_newQS) > 1) Then MM_logoutRedirectPage = MM_logoutRedirectPage & MM_newQS
End If
Response.Redirect(MM_logoutRedirectPage)
End If
%>
<!--#include file="Connections/mysql.asp" -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "未处理"
If (Request("MM_EmptyValue") <> "") Then
Recordset1__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_mysql_STRING
Recordset1_cmd.CommandText = "SELECT * FROM student.applyend WHERE state = ? ORDER BY time ASC"
Recordset1_cmd.Prepared = true
Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 200, 1, 255, Recordset1__MMColParam) ' adVarChar
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<!--#include file="Connections/data.asp" -->
<!DOCTYPE HTML>
<html>
<head>
<title>三思·预约项目</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="keywords" content="Wed Day Responsive web template, Bootstrap Web Templates, Flat Web Templates, Andriod Compatible web template,
Smartphone Compatible web template, free webdesigns for Nokia, Samsung, LG, SonyErricsson, Motorola web design" />
<script type="applijewelleryion/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<!-- Custom Theme files -->
<link href="css/style4.css" rel='stylesheet' type='text/css' />
<link href="css/notice.css" rel='stylesheet' type='text/css' />
<script src="js/jquery-1.11.1.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<style>
p {
font-size:17px;
}
a{color: #0162f4;}
a:hover{text-decoration:underline;color:#60F;}
.atable.hovertable {
font-family: verdana,arial,sans-serif;
font-size:11px;
color:#333333;
border-width: 1px;
border-color: #999999;
border-collapse: collapse;
}
.atable.hovertable th {
background-color:#c3dde0;
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}
.atable.hovertable tr {
background-color:#d4e3e5;
}
.atable.hovertable td {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}
</style>
<!--webfonts-->
<link href='http://fonts.useso.com/css?family=Lora:400,400italic|Niconne' rel='stylesheet' type='text/css'>
<!--//webfonts-->
</head>
<body style="color:#000">
<!--start-home-->
<!-- header --><!-- //header -->
<!-- banner -->
<div class="banner two">
<div class="container" >
<div class="banner-navigation" style="padding:1% 1% 1% 1%">
<a href="http://www.three-thinking.com" target="_blank">
<img src="images\logo1.png" style="background-position:center;position:relative;background-size:cover; min-height:50px; min-width:200px; width:15%;height:15%" alt=""/></a>
<a href="http://www.xidian.edu.cn" target="_blank"><img class="xd" src="images/scorelogowhite.png" style="position:relative; left:60%; background-position:left;background-size:cover; width:20%;height:20%" alt=""/></a>
<!--script-for-menu-->
<div class="clearfix"></div>
</div>
</div>
</div>
<!--typography-->
<div class="typrography">
<div class="container">
<p align="center" class = "tzxx" style="display:none; font-size:30px ">项目信息</p>
<img class="tzxx" src="images/textadmin.png" style="background-position:center;left:30%;position:relative;background-size:cover; min-height:50px; min-width:200px; width:40%;height:30%" longdesc="news.asp">
<div class="clearfix"> </div>
</div>
<div class="container" style="width:1200px">
<div class="grid_3 grid_5" >
<div id="wz" ><b>尊敬的管理员，欢迎您！</b><a href="<%= MM_Logout %>">注销</a>
<%
if Session("MM_Admin") = false or Session("MM_Admin") = "" then
%>
<script>
alert("Please log in before use this function.");
</script>
<%
Response.end()
end if
%>
</div>
</div>
<div id="list_wrap"><!--新闻内容-->
<div id="list_main">
<div class="maindiv">
<div class="atshowa">
<div class="atshowname" style="text-align:center;color:#009;font-size:23px;font-weight:bold;line-height:1.5em; font-family:'微软雅黑';margin-bottom:10px;height:auto!important">
<p>预约项目基本信息</p>
<p>
<a href="applyfind.asp" target="_blank"><input type="button" name="12" id="12" value="修改学生信息" style="font-size: 18px;
font-weight: 300 !important;
position:relative;
color: #fff;
cursor: pointer;
outline: none;
padding: 10px 15px;
width: 25%;
border: none;
background: #00BBFF ;
border-radius: 2px;
-webkit-border-radius: 2px;
-moz-border-radius: 2px;
-o-border-radius: 2px;
text-transform: uppercase;" onmouseover="this.style.background='#9900FF'" onmouseout="this.style.background='#00BBFF '" /></a>
</p>
</div>
<div class="atshowb">
</div>
<hr style="height:1px;border:none;border-top:1px solid #555555;" />
<div id="change_content1">
<div class="atshowd">
<div class="atshowcontent" style="padding-left:3%;padding-right:3%;font-size:14px;line-height:1.5em; width:97%; margin:0 auto "></div>
<table align="center" style="width: 100%; border:1px;border: 1px solid #cfcfcf;margin-bottom: 20px;font-size:16px" class="datatable">
<thead>
<tr >
<th >学号</th>
<th >姓名</th>
<th >预约时间</th>
<th >预约类型</th>
<th >手机号</th>
<th colspan="2">操作</th>
</tr>
</thead>
<tbody id = "mainbody">
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<tr style="border-bottom: 1px solid #ddd;" id = "delCell">
<form name="form1" method="post" action="applydealup.asp" onSubmit="return check()">
<input type="hidden" name="sno" id="sno" value="<%=(Recordset1.Fields.Item("sno").Value)%>">
<input type="hidden" name="type" id="type" value="<%=(Recordset1.Fields.Item("type").Value)%>">
<td align="center"><%=(Recordset1.Fields.Item("sno").Value)%></td>
<td align="center"><%=(Recordset1.Fields.Item("name").Value)%></td>
<td align="center" style="color:blue"><%=(Recordset1.Fields.Item("time").Value)%></td>
<td align="center"><%=(Recordset1.Fields.Item("type").Value)%></td>
<td align="center"><%=(Recordset1.Fields.Item("telephone").Value)%></td>
<td width="11%" align="center"><input type="submit" name="get" id="get" value="处理" style="font-size: 16px;
font-weight: 300 !important;
position:relative;
color: #fff;
cursor: pointer;
outline: none;
padding-top:2px;
width: 80%;
border: none;
background: #00BBFF ;
border-radius: 2px;
-webkit-border-radius: 2px;
-moz-border-radius: 2px;
-o-border-radius: 2px;
text-transform: uppercase;" onmouseover="this.style.background='#9900FF'" onmouseout="this.style.background='#00BBFF '" /></td>
</form>
<td width="11%" align="center"><input type="button" name="get" id="get" value="信息" onClick="window.open('applyinf.asp?sno=<%=(Recordset1.Fields.Item("sno").Value)%>');" style="font-size: 16px;
font-weight: 300 !important;
position:relative;
color: #fff;
cursor: pointer;
outline: none;
padding: 2px;
width: 80%;
border: none;
background: #3b5999;
border-radius: 2px;
-webkit-border-radius: 2px;
-moz-border-radius: 2px;
-o-border-radius: 2px;
text-transform: uppercase; margin-left:10%" onmouseover="this.style.background='#9900FF'" onmouseout="this.style.background='#3b5999 '" /></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</tbody>
</table>
<hr style="height:1px;border:none;border-top:1px solid #555555;" />
</div>
</div>
</div>
</div>
</div>
</div>
<script>
function check(){
if(confirm("您确认要执行操作吗？"))
return true;
else
return false;
}
</script>
<div align="center"class="copy_layout login" style="padding:-50%; margin-bottom:2%"> <p>Copyright 2016 <a href="http://www.three-thinking.com" target="_blank" title="三思" style="color:#000000">三思</a> 版权所有||<a href="about.asp" target="_blank" title="三思" style="color:#000000">关于三思</a>||@<a href="http://www.xidian.edu.cn/" style="color:#000000" target="_blank">西安电子科技大学 </a>threethinking版权所有|陕ICP备16002727号|<a href="http://www.miitbeian.gov.cn/" style="color:#000000" target="_blank" title="三思">工信部主页</a> </p></div>
<hr style="height:1px;border:none;border-top:1px solid #555555;" />
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>