⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 xx_lookgoodsunit.asp

📁 生成防伪码,并导出为EXCEL表格,可查寻
💻 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>出货单|<a href="XX_MakeReport.asp?listnum=<%=request("listnum")%>" target="_blank">生成报表</a></td></tr></table>
<center><%
listnum=Request("listnum")
Set Rs=Server.Createobject("adodb.recordset")
Sql="Select * from XX_shoplist where listnum="&listnum&" 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></tr>"
if rs.bof and rs.eof then
response.write"<tr bgcolor=#efefef><td align=center>对不起没有找到记录!</td></tr>"
else
page=request("page")

rs.pagesize=20'每页显示记录数
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("spnum")&"</td>"
response.write"<td align=center>"&rs("zsk")&"</td>"
response.write"<td align=center>"&rs("spname")&"</td>"
response.write"<td align=center>"&rs("spys")&"</td>"
response.write"<td align=center>"&rs("spgg")&"</td>"
response.write"<td align=center>"&rs("unit")&"</td>"
response.write"<td align=center>"&rs("spsl")&"</td>"
response.write"<td align=center>"&rs("spyb")&"</td>"
response.write"<td align=center>"&rs("meno")&"</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"首页&nbsp;"
response.write"上一页&nbsp;"
else
response.write"<a href=XX_LookGoodsUnit.asp?listnum="&request("listnum")&">首页&nbsp;</a>"
response.write"<a href=XX_LookGoodsUnit.asp?page="&page-1&"&listnum="&request("listnum")&">上一页&nbsp;</a>"
end if

if Allpage-page<>0 then
response.write"<a href=XX_LookGoodsUnit.asp?page="&page+1&"&listnum="&request("listnum")&">下一页&nbsp;</a>"
response.write"<a href=XX_LookGoodsUnit.asp?page="&Allpage&"&listnum="&request("listnum")&">尾页&nbsp;</a>"
else
response.write"下一页&nbsp;"
response.write"尾页&nbsp;"
End if
response.write"</td></tr></table>"
'打开入库记录游标,取得数据以便修改

%></center>
</body></html>
<script javascript=javascript>
function check(){
if (document.addform.listnum.value=="")
{
alert ("请输入货单号。");
document.addform.listnum.value='';
document.addform.listnum.focus();
return false;
}
if (document.addform.listuser.value=="")
{
alert ("请输入送货对象。");
document.addform.listuser.value='';
document.addform.listuser.focus();
return false;
}
var istrue;
istrue=confirm('您确定无误要入库是吗?');
if(istrue) {
  return true;
 }
else {
 return false;
 }
}



</script>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -