📄 soaddnote.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>
<%
key=request.form("key")
if not IsDate(key) then
response.write"日期格式错误！"
response.end
end if
Set Rs=Server.Createobject("adodb.recordset")
sql="select * from JinKu where intime=#"&key&"#"
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></tr>"
if rs.bof and rs.eof then
response.write"<tr bgcolor=#efefef><td align=center>对不起没有找到记录</td></tr>"
else
while not rs.eof
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("username")&"</td>"
response.write"<td align=center>"&rs("intime")&"</td>"
response.write"<td align=center><font color=red><a href=upaddnote1.asp?id="&rs("id")&">点击修改</a></font></td>"
response.write"</tr>"
rs.movenext
wend
end if
rs.close
response.write"</table>"
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -