📄 daoyou.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!--#include file="mfk_body.asp"-->
<html>
<head>
<title><%=title1%>--导游人员</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
call pagestart
%>
<table width="755" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="27"><img src="skins/mfk_skin(<%=skin%>)/mfk_lefttitle1.gif"></td>
<td width="701" background="skins/mfk_skin(<%=skin%>)/mfk_midtitle1.gif"> </td>
<td width="27"><img src="skins/mfk_skin(<%=skin%>)/mfk_righttitle1.gif"></td>
</tr>
</table>
<table width="755" border="0" align="center" cellpadding="0" cellspacing="0" class="lefttablebox">
<tr>
<td height="30"><table width="195" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30"> </td>
<td width="165">导 游 人 员 库</td>
</tr>
</table></td>
</tr>
<tr>
<td height="286" valign="top" class="tablebg"><table width="751" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="center" class="lefttable1">
<td height="26" colspan="2">姓名/性别</td>
<td width="57">身高</td>
<td width="60">年龄</td>
<td width="140">工作旅行社</td>
<td width="140">导游景区(城市)</td>
<td width="144">导游语种</td>
<td width="100">导游证件</td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from daoyou order by dtop desc,id desc"
rs.open sql,conn,1,2
if rs.eof or rs.bof then
response.write ("<tr><td height=26 colspan=8 align=center>暂时没有导游人员资料！</td></tr>")
else
rs.pagesize=14
dim page
page=trim(request("page"))
if page<>"" then
page=cint(page)
else
page=1
end if
pagec=rs.pagecount
if page>pagec then
page=pagec
end if
rs.absolutepage=page
colori=1
a=0
do while not rs.eof and a<rs.pagesize
if colori>2 then colori=1
%>
<tr <%if colori=2 then response.write(" class=""table1""")%>>
<td width="80" height="26" align="center"><a href="listdaoyou.asp?id=<%=rs("id")%>" title="<img src='<%=rs("dphoto")%>'>"><%=rs("dname")%></a></td>
<td width="30" align="center"><%=rs("dsex")%></td>
<td align="center"><%=rs("dshenggao")%>/CM</td>
<td align="center"><%=rs("dage")%>/岁</td>
<td><%=rs("ddanwei")%></td>
<td><%=rs("dadd")%></td>
<td><%=rs("dyuzhong")%></td>
<td align="center"><%=rs("dzhengjian")%></td>
</tr>
<%
rs.movenext
a=a+1
colori=colori+1
loop
end if
closers(rs)
%>
</table></td>
</tr>
<tr>
<td height="30" align="center" class="titletable">
<%
response.write ("<a href=?page=1>首页</a> ")
if page>1 then
response.write ("<a href=?page="&page-1&">上一页</a> ")
else
response.write("上一页 ")
end if
if page<pagec then
response.write("<a href=?page="&page+1&">下一页</a> ")
else
response.write("下一页 ")
end if
response.write ("<a href=?page="&pagec&">尾页</a> ")
response.write ("当前："&page&"/"&pagec&"")
%> </td>
</tr>
</table>
<table width="755" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="7"><img src="skins/mfk_skin(<%=skin%>)/mfk_lefttitle1_1.gif"></td>
<td width="741" background="skins/mfk_skin(<%=skin%>)/mfk_midtitle1_1.gif"> </td>
<td width="7"><img src="skins/mfk_skin(<%=skin%>)/mfk_righttitle1_1.gif"></td>
</tr>
</table>
<table width="755" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="4"></td>
</tr>
</table>
<%
call pageend
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -