📄 searchinfo.asp

📁 对学校物资管理系统的一份设计
💻 ASP
字号:
<!--#include file = "Startup.asp"-->
<!-- #include file="Function.asp" -->
<%
call adminer()
Call ComeUrl()
page=request("page")
if instr(page,",")<>0 then
page=left(page,instr(page,",")-1)
end if 
'response.write "page="&page

wzname=replace(trim(request("wzname")),",","")
if wzname<>"" then
searhsql=searhsql&" and 名称 like '%"&wzname&"%'"
end if 

bianhao=replace(trim(request("bianhao")),",","")
if bianhao<>"" then
searhsql=searhsql&" and 编号='"&bianhao&"'"
end if 

zhuangtai=replace(trim(request("zhuangtai")),",","")
if zhuangtai<>"" then
searhsql=searhsql&" and 状态='"&zhuangtai&"'"
end if 

wzclass=replace(trim(request("wzclass")),",","")
if wzclass<>"" then
searhsql=searhsql&" and 所属分类='"&wzclass&"'"
end if 

jfcode=replace(trim(request("jfcode")),",","")
if jfcode<>"" then
searhsql=searhsql&" and 所属机房='"&jfcode&"'"
end if 

bmname=replace(trim(request("bmname")),",","")
if bmname<>"" then
searhsql=searhsql&" and 所属部门='"&bmname&"'"
end if 

shcoolname=replace(trim(request("shcoolname")),",","")
if shcoolname<>"" then
searhsql=searhsql&" and 所属校区='"&shcoolname&"'"
end if 

officename=replace(trim(request("officename")),",","")
if officename<>"" then
searhsql=searhsql&" and 所属办公室='"&officename&"'"
end if 

gongyin=replace(trim(request("gongyin")),",","")
if gongyin<>"" then
searhsql=searhsql&" and 供应商='"&gongyin&"'"
end if 

 if searhsql<>"" then
 searhsql=mid(searhsql,5,len(searhsql)-4)
 sql="select * from cangku where"&searhsql
 else
 sql="select * from cangku"
 end if 

  set rs=server.createobject("adodb.recordset")
  rs.open sql,oconn,1,2
  if rs.eof then
  response.Write("<br><br><center><font size=3>暂无数据！</font></center>")
  else
  rs.PageSize =20  '每页记录
		  totalput = rs.RecordCount '总记录数
		  pgnum=rs.Pagecount    '总页数
		  if page="" then page=1   
		  if page-pgnum>0 then page=pgnum   
		  rs.AbsolutePage=page 
		  n=0
%>
<script language="JavaScript">
function openwin(id){
window.open('wuzi_info.asp?id='+id,'','menubar=0,statusbar=0,locationbar=0,scrollbars=0,width=510,height=510 top=100,left=200')
}
</script>


<script language="JavaScript">
function openwin2(id){
window.open('peizhi.asp?id='+id,'','menubar=0,statusbar=0,locationbar=0,scrollbars=0,width=510,height=500 top=100,left=200')
}
</script>

<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 leftmargin="0" topmargin="0">
<table width="100%" height="100%" border="0">
  <tr> 
    <td align="center" valign="top">
      <table width="100%" border="0" cellspacing="0" cellpadding="3">
        <tr>
          <td>现在物资 共计<font color=#ff0000><b><%=rs.RecordCount%></b></font> 件</td>
        </tr>
      </table>
      <table width="100%"??瘠换汲??瑳O????8?8┲?琯扡敬?╅有?瘠换汲??瑳?牲猽牴牅?…㈥┲?戯摯????瑨汭?╅有?瘠换汲??敲灳湯敳眮楲整猠牴牅?攊摮猠扵????????????????????????????????????????????????????????????????????????????????湵瑣潩?敇却晡卥牴猨牴??敇却晡卥牴?删灥慬散刨灥慬散刨灥慬散吨楲?瑳??㈥?㈥?┠有㈥??桃???┠有㈥??㈥?㈥?┠有㈥??湅?畆据楴湯?????????????????????????????????呈?
⌨️ 快捷键说明

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