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

📄 pcrpt.asp

📁 月光机器管理器
💻 ASP
字号:
🔍 
<!--#include file="pcdb.asp"-->

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb_2312-80">
<style type="text/css">
<!--
.font {   font-size: 9pt ; line-height:13pt;

	    }

A:link  	{color:#0033CC; font-style: normal; text-decoration: none; cursor: hand}

A:visited  	{color:#0033CC; font-style: normal; text-decoration: none}

A:active  	{color:  rgb(255,0,0); font-style: normal; text-decoration: none}

A:hover 	{color:#408080; font-style:bold; text-decoration: underline}	 

	  

-->
</style>
<title>计算机设备汇总</title>
</head>

<BODY bgcolor="White" text="#000000" style="margin-left:3px;margin-top: 3px" topmargin="0" leftmargin="0" marginheight="0" marginwidth="0" link="#0072E3" vlink="#0072E3" >

<%
query= " "
%>

<h1 align="center"><font size="6" color="#0080ff">计算机设备汇总</font></h1>
<h1 align="right"><font size="2" color="#0080ff">信息部制</font></h1>

<table width="100%" cellspacing="0" cellpadding="5" border="1">
  <tr>
    <th bgcolor="#7c79ff" colspan="10"><span class="font"><p align="left">&nbsp; 条件：
			<% if Request.Form("使用人")<>"" then %>
             使用人∩{ 
            <%
			Response.Write Request.Form("使用人") & "}" 
			query=query+" 使用人 like '%"+Request.Form("使用人")+"%' and"
			%>
            <% end if %>
            
            <% if Request.Form("部门")<>"" then %>
              部门∩{ 
            <%
			Response.Write Request.Form("部门") &"}"
			query=query+" 部门 like '%"+Request.Form("部门")+"%' and"
			%>

            <% end if %>
            <% if Request.Form("编号")<>"" then %>
              编号∩{ 
            <% 
			Response.Write Request.Form("编号") &"}"
			query=query+" 编号 like '%"+Request.Form("编号")+"%' and"
			%>
            <% end if %>
             
             设备状态 =
            <%
			Response.Write Request.Form("设备状态") 
			if Request.Form("设备状态")<>"全部" then
			query=query+" 设备状态 = '"+Request.Form("设备状态")+"' "
			end if
			%>

            
             &nbsp; </span></P></th>
  </tr>
  <tr ALIGN="left">
    <th bgcolor="#a6d2d2"><span class="font">序号</span></th>
    <th bgcolor="#a6d2d2"><span class="font">编号</span></th>
    <th bgcolor="#a6d2d2"><span class="font">使用人</span></th>
    <th bgcolor="#a6d2d2"><span class="font">部门</span></th>
    <th bgcolor="#a6d2d2"><span class="font">设备状态</span></th>
  </tr>
    <DIV align=center>
    <%
    
if (right(trim(query),3)="and") then  query= left(trim(query),len(trim(query))-3)
if trim(query) <>"" then query=" where " + query
sql= "SELECT * FROM 设备资源 " + query + " order by 编号 " '以编号排序

Set rs=Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
alls=rs.Recordcount

IF RS.BOF or RS.EOF THEN
		Response.Write "无记录"
else  '跳至最后

cc=1
Do While (Not RS.EOF  )
    
    Response.Write "  <tr ALIGN=""left""> " + chr(13) 
	Response.Write "  <td bgcolor=""#E0EFE9""><span class=""font""> "
    Response.Write cc
    cc=cc+1
	
	Response.Write "  <td bgcolor=""#E0EFE9""><span class=""font""> "
    Response.Write rs("编号")
	Response.Write "  &nbsp;</span></td> " + chr(13)

	Response.Write "  <td bgcolor=""#E0EFE9""><span class=""font""> "
    Response.Write rs("使用人")
	Response.Write "  &nbsp;</span></td> " + chr(13)

	Response.Write "  <td bgcolor=""#E0EFE9""><span class=""font""> "
    Response.Write rs("部门")
	Response.Write "  &nbsp;</span></td> " + chr(13)

	Response.Write "  <td bgcolor=""#E0EFE9""><span class=""font""> "
    Response.Write rs("设备状态")
	Response.Write "  &nbsp;</span></td> " + chr(13)

 
    rs.MoveNext
	
Loop


	rs.Close
END IF

    Response.Write "  </table><p>　</p></body></html>"


%>
    &nbsp;</DIV>
</table>
<DIV align=center>
</FONT>
</body>
</html>

⌨️ 快捷键说明

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