📄 kehunote.asp
字号:
<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<html><head><link href="css.css" rel="stylesheet" type="text/css">
<title>三角进销存--客户列表</title></head>
<body>
<table width="100%" class="inputb"><tr><td align="center">客户列表</td></tr></table>
<br>
<%
Set Rs=Server.createobject("adodb.recordset")
Sql="select * from Kehu"
Rs.open Sql,conn,1,1
response.write"<table width=100% border=1 cellpadding=0 cellspacing=0 bordercolorlight=#cccccc bordercolordark=#ffffff>"
response.write"<tr bgcolor=#cccfff><td align=center>客户编号</td><td align=center>公司名称</td><td align=center>联系地址</td><td align=center>联系电话</td><td align=center>移动电话</td><td align=center>负责人</td><td align=center>修改</td><td align=center>删除</td></tr>"
if rs.bof and rs.eof then
response.write"暂无客户记录！"
Else
page=request("page")
rs.pagesize=10'每页显示记录数
j=rs.pagesize
Allrecord=rs.Recordcount '得到记录总数
Allpage=rs.pagecount '得到页总数
if not isnumeric(page) or page="" then
page=1
else page=clng(page)
end if
if page<1 then
page=1
elseif page>Allpage then
page=allpage
end if
rs.absolutepage=page
for i=1 to j
response.write"<tr bgcolor=#f1f1f1><td align=center>"&rs("id")&"</td>"
response.write"<td align=center>"&rs("name")&"</td>"
response.write"<td align=center>"&rs("address")&"</td>"
response.write"<td align=center>"&rs("tel")&"</td>"
response.write"<td align=center>"&rs("shouji")&"</td>"
response.write"<td align=center>"&rs("laozong")&"</td>"
response.write"<td align=center><a href=kehunote.asp?id="&rs("id")&">点击修改</a></td>"
response.write"<td align=center><a href=DelKehu.asp?id="&rs("id")&">点击删除</a></td>"
response.write"</tr>"
rs.movenext
if rs.eof then exit for
next
End if
rs.close
response.write"</table>"
response.write"<table border=0 width=100% ><tr>"
response.write"<td align=center>"
if page<2 then
response.write"首页 "
response.write"上一页 "
else
response.write"<a href=kehunote.asp>首页 </a>"
response.write"<a href=kehunote.asp?page="&page-1&">上一页 </a>"
end if
if Allpage-page<>0 then
response.write"<a href=kehunote.asp?page="&page+1&">下一页 </a>"
response.write"<a href=kehunote.asp?page="&Allpage&">尾页 </a>"
else
response.write"下一页 "
response.write"尾页 "
End if
response.write"</td></tr></table>"
response.write"<br>"
response.write"<table width=100% class=inputb><tr><td align=center>修改客户信息</td></tr></table>"
response.write"<center>"
response.write"<form name=kehuform action='kehunote1.asp' method='post'>"
response.write"<table width=300>"
id=request("id")
if not isnumeric(id) or id="" then
response.write"请选择要修改的客户！"
response.end
end if
Sqlstr="select * from kehu where id="&id
rs.open sqlstr,conn,1,1
response.write"<input name='kehuid' type=hidden value="&rs("id")&">"
response.write"<tr><td>公司名称：<input name=name type=text class=inputa value="&rs("name")&"></td></tr>"
response.write"<tr><td>联系地址：<input name=address type=text class=inputa value="&rs("address")&"></td></tr>"
response.write"<tr><td>联系电话：<input name=tel type=text class=inputa value="&rs("tel")&"></td></tr>"
response.write"<tr><td>移动电话：<input name=shouji type=text class=inputa value="&rs("shouji")&"></td></tr>"
response.write"<tr><td>负 责 人：<input name=laozong type=text class=inputa value="&rs("laozong")&"></td></tr>"
response.write"<tr><td><input name=submit type=submit class=inputb value=确定修改> <input name=submit1 type=reset class=inputb value=清除重写></tr></tr>"
response.write"</table>"
response.write"</form>"
response.write"</center>"
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -