📄 addnote.asp
字号:
<!--#include file=conn.asp-->
<!--#include file=function.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>
<form name=soform action="SoAddnote.asp" method="post">
<table width="100%" border="0"><tr><td align=center>输入进库日期：<input name=key type="text" class="inputa"> <input name="ok" type="submit" value="点击查询" class=inputb></td></tr></table></form>
<%
Set Rs=Server.Createobject("adodb.recordset")
Sql="Select * from JinKu order by id desc"
Rs.Open Sql,Conn,1,1
response.write"<table border=1 width=100% cellpadding=0 cellspacing=0 bordercolorlight=#cccccc bordercolordark=#ffffff>"
response.write"<tr bgcolor=#efefef><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><td align=center>入库时间</td><td align=center>修改记录</td></tr>"
if rs.bof and rs.eof then
response.write"<tr bgcolor=#efefef><td align=center>对不起没有找到记录！</td></tr>"
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=#efefef><td align=center>"&rs("ID")&"</td>"
response.write"<td align=center>"&rs("pinpai")&"</td>"
response.write"<td align=center>"&rs("guige")&"</td>"
response.write"<td align=center>"&rs("xinghao")&"</td>"
response.write"<td align=center>"&rs("shuliang")&"条</td>"
response.write"<td align=center>"&rs("danjia")&"元</td>"
response.write"<td align=center>"&rs("summoney")&"元</td>"
response.write"<td align=center>"&rs("username")&"</td>"
response.write"<td align=center>"&rs("intime")&"</td>"
response.write"<td align=center><font color=red><a href=addnote.asp?id="&rs("id")&">点击修改</a></font></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=addnote.asp>首页 </a>"
response.write"<a href=addnote.asp?page="&page-1&">上一页 </a>"
end if
if Allpage-page<>0 then
response.write"<a href=addnote.asp?page="&page+1&">下一页 </a>"
response.write"<a href=addnote.asp?page="&Allpage&">尾页 </a>"
else
response.write"下一页 "
response.write"尾页 "
End if
response.write"</td></tr></table>"
'打开入库记录游标，取得数据以便修改
%>
<br>
<!--#include file=upaddnote.asp-->
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -