📄 ck_wuzi_magic.asp

📁 对学校物资管理系统的一份设计
💻 ASP
字号:
<!--#include file = "Startup.asp"-->
<!-- #include file="Function.asp" -->
<%
call adminer()
Call ComeUrl()
Call adminck()
  page=request("page")
  ssbm=replace(trim(request("ckname")),",","")
  ck="否"
  set rs=server.createobject("adodb.recordset")
  sql="select * from ckinfo where 所属仓库='"&ssbm&"' order by id desc"
  rs.open sql,oconn,1,2
  if rs.eof then
  response.Write("<br><br><center><font size=3>暂无数据！</center>")
  else
  rs.PageSize =15  '每页记录
		  totalput = rs.RecordCount '总记录数
		  pgnum=rs.Pagecount    '总页数
		  if page="" then page=1   
		  if page-pgnum>0 then page=pgnum   
		  rs.AbsolutePage=page 
		  n=0
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="common.css" type="text/css" rel="stylesheet">
<title>无标题文档</title>
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC" >
  <tr align="center" bgcolor="#E0E0E0"> 
    <td height="20"><strong> <font color="#FF0000">物资名称</font></strong></td>
    <td height="20"><strong> <font color="#FF0000">所属仓库</font></strong></td>
    <td><strong><font color="#FF0000">数量</font></strong></td>
    <td><strong><font color="#FF0000">单价</font></strong></td>
    <td><strong><font color="#FF0000">供应商</font></strong></td>
    <td><strong><font color="#FF0000">状态</font></strong></td>
    <td><strong><font color="#FF0000">入库时间</font></strong></td>
    <td><strong><font color="#FF0000">备注</font></strong></td>
    <td><font color="#FF0000"><strong>操作</strong></font></td>
  </tr>
  <%
  do while not rs.eof and n<rs.pagesize
          n=n+1
          id=rs("id")
		  s=rs("物资名称")
		  ckname=rs("所属仓库")
		  response.write "<tr align=left bgcolor=#ffffff>"
		  response.write "<td bgcolor=#ffffff align=center>"& rs("物资名称")&"</td>"
		  response.write "<td bgcolor=#ffffff align=center>"& rs("所属仓库")&"</td>"
		  response.write "<td bgcolor=#ffffff align=center>"& rs("数量")&"</td>"
		  response.write "<td bgcolor=#ffffff align=center>"& rs("单价")&"</td>"
		  response.write "<td bgcolor=#ffffff align=center>"& rs("供应商")&"</td>"
		  response.write "<td bgcolor=#ffffff align=center>"& rs("状态")&"</td>"
		  response.write "<td bgcolor=#ffffff align=center>"& rs("入库时间")&"</td>"
		  response.write "<td bgcolor=#ffffff align=center><a href=# title=查看备注 onclick=window.open('beizhu.asp?id="&id&"','备注','width=250,height=250')>备注</td>"
		  response.write "<td bgcolor=#ffffff align=center><a href=# title=出库操作 onclick=window.open('out.asp?id="&id&"&wzname="&s&"&ckname="&ckname&"','出库','width=300,height=250')>出库</td>"
		  response.write "</td>" 
		  response.write "</tr>"  
  rs.movenext
  loop
  end if
  %>
</table>
<table width="100%" border="0" cellpadding="2" cellspacing="0">
  <tr> 
    <td><strong><a href="outlist.asp?ckname=<%=ckname%>">查看出库历史记录</a></strong></td>
  </tr>
</table>
<table align=center width="80%" cellpadding="0" cellspacing="0" border="0">
  <tr> 
    <td align=center> <font color="#FF6600"><br>
      </font> 
      <% 
			if page>1 then
		  sstr=request.servervariables("query_string")
          sstr=right(sstr,len(sstr)-instr(sstr,"&"))
          'sstr=replace(sstr,restr,"")
		  else
		  sstr=request.servervariables("query_string")
		  end if 
		  
				  if totalput>rs.pagesize then %>
      [<%=rs.pagesize%>条/页 共<%=totalput%>条] 
      <%
                  if page=1 then%>
      [首 页] [上一页] 
      <% else %>
      [<a href="?page=1&<%=sstr%>">首 页</a>] [<a href="?page=<%=page-1%>&<%=sstr%>">上一页</a>] 
      <%end if%>
      <%if rs.pagecount-page=0 then%>
      [下一页] [尾 页] 
      <%else%>
      [<a href="?page=<%=page+1%>&<%=sstr%>">下一页</a>] [<a href="?page=<%=rs.pagecount%>&<%=sstr%>">尾 
      页</a>] 
      <% 
				    end if
				  else 
				  end if
				  rs.close
				  %>
    </td>
  </tr>
</table>
</body>
</html>
⌨️ 快捷键说明

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