<!--#include file="inc/conn.asp" -->
<html>
<head>
<title>测量设备查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style/style.css" rel="stylesheet" type="text/css">
<style>
body {
background-color:#FFFFFF;
}
</style>
<script language="javascript">
function collapse(img, objName)
{
var obj;
obj = document.getElementById(objName);
if (img.src.indexOf('open') != -1)
{
img.src = img.src.replace('open', 'close');
obj.style.display = 'none';
}
else
{
img.src = img.src.replace('close', 'open');
obj.style.display = '';
}
}function collapseall(img)
{
var obj;
if (img.src.indexOf('open') != -1)
{
img.src = img.src.replace('open', 'close');
for (x=1;x<=20;x++)
{
obj = document.getElementById("celiangshebeishiyan"+x);
if (obj)
{
obj.style.display = 'none';
}
}
}
else
{
img.src = img.src.replace('close', 'open');
for (x=1;x<=20;x++)
{
obj = document.getElementById("celiangshebeishiyan"+x);
if (obj)
{
obj.style.display = '';
}
}
}
}
</script><script language=javascript>
function preview() { 
bdhtml=window.document.body.innerHTML; 
sprnstr="<!--startprint-->"; 
eprnstr="<!--endprint-->"; 
prnhtml=bdhtml.substr(bdhtml.indexOf(sprnstr)+17); 
prnhtml=prnhtml.substring(0,prnhtml.indexOf(eprnstr)); 
window.document.body.innerHTML=prnhtml; 
window.print(); 
window.document.body.innerHTML=bdhtml; 
         }
</script>
</head>

解决方案 »

  1.   

    <body>
    <script>
    function CheckAll(form)  {
      for (var i=0;i<form.elements.length;i++)    {
        var e = form.elements[i];
        if (e.name != 'chkall')       e.checked = form.chkall.checked; 
       }
      }
    </script>
    <%
    if fla2="0" and session("baipu_id")<>"1" then
    %>
    <br><center><img src="images/note.gif" align="absmiddle">&nbsp;<font color="#FF0000">你不具备此权限,请与管理员联系!</font></center>
    <%  
      response.end
    end if'取得当前页码
    currentpage=request("page")
    'response.write currentpage
    'response.end
    if currentpage<1 or currentpage="" then
      currentpage="1"
    end if%>
    <table width="100%" border="0" cellpadding="0" cellspacing="2" align="center">
     
    </table>
    <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">
    <tr>
    <td><img src="images/r_1.gif" alt="" width="6" height="27" /></td>
    <td width="100%" background="images/r_0.gif">
      <table cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td>&nbsp;测量设备查询</td>
      <td align="right">&nbsp;</td>
        </tr>
      </table>
    </td>
    <td><img src="images/r_2.gif" alt="" /></td>
    </tr>
    <tr>
    <td></td>
    <td>
    <!--startprint-->
    <table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1">
    <form name="form1" action="celiangshebei/celiangshebei_del.asp">
      <input type="hidden" name="startdate" value="<%=nowstartdate%>">
      <input type="hidden" name="enddate" value="<%=nowenddate%>">
      <input type="hidden" name="ku" value="<%=nowku%>">
      <input type="hidden" name="keyword" value="<%=nowkeyword%>">
      <input type="hidden" name="order1" value="<%=request("order1")%>">
      <input type="hidden" name="order2" value="<%=request("order2")%>">
      <input type="hidden" name="order3" value="<%=request("order3")%>">
      <input type="hidden" name="order4" value="<%=request("order4")%>">
      <input type="hidden" name="order5" value="<%=request("order5")%>">
      <input type="hidden" name="order6" value="<%=request("order6")%>">
      <input type="hidden" name="order7" value="<%=request("order7")%>">
      <tr align="center">
        <td class="category" width="10"><img src="images/folder_close.gif" width="18" height="9" style="cursor:hand" onClick="collapseall(this)" /></td>
        <td class="category" height="30">
      <a href="celiangshebei/celiangshebeishiyan.asp?order1=<%if request("order1")="asc" then%>desc<%else%>asc<%end if%>&page=<%=currentpage%>&startdate=<%=nowstartdate%>&enddate=<%=nowenddate%>&ku=<%=nowku%>&keyword=<%=nowkeyword%>" class="title">专业类别<%if request("order1")="asc" then%><img src="images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a> </td>
    <td class="category">
      <a href="celiangshebei/celiangshebeishiyan.asp?order2=<%if request("order2")="asc" then%>desc<%else%>asc<%end if%>&page=<%=currentpage%>&startdate=<%=nowstartdate%>&enddate=<%=nowenddate%>&ku=<%=nowku%>&keyword=<%=nowkeyword%>" class="title">测量设备名称<%if request("order2")="asc" then%><img src="images/up2.gif" width="12" height="7" hspace="2" border="0" align="absmiddle">
      <%else%><img src="images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a>    </td>
    <td class="category">
      <a href="celiangshebei/celiangshebeishiyan.asp?order3=<%if request("order3")="asc" then%>desc<%else%>asc<%end if%>&page=<%=currentpage%>&startdate=<%=nowstartdate%>&enddate=<%=nowenddate%>&ku=<%=nowku%>&keyword=<%=nowkeyword%>" class="title">型号规格<%if request("order3")="asc" then%><img src="images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a> </td>
    <td class="category">
      <a href="celiangshebei/celiangshebeishiyan.asp?order4=<%if request("order4")="asc" then%>desc<%else%>asc<%end if%>&page=<%=currentpage%>&startdate=<%=nowstartdate%>&enddate=<%=nowenddate%>&ku=<%=nowku%>&keyword=<%=nowkeyword%>" class="title">测量范围
      <%if request("order4")="asc" then%><img src="images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
    <td class="category">
      <a href="celiangshebei/celiangshebeishiyan.asp?order5=<%if request("order5")="asc" then%>desc<%else%>asc<%end if%>&page=<%=currentpage%>&startdate=<%=nowstartdate%>&enddate=<%=nowenddate%>&ku=<%=nowku%>&keyword=<%=nowkeyword%>" class="title">准确度
      <%if request("order5")="asc" then%><img src="images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a> </td>
    <td class="category">
      <a href="celiangshebei/celiangshebeishiyan.asp?order6=<%if request("order6")="asc" then%>desc<%else%>asc<%end if%>&page=<%=currentpage%>&startdate=<%=nowstartdate%>&enddate=<%=nowenddate%>&ku=<%=nowku%>&keyword=<%=nowkeyword%>" class="title">制造厂家
      <%if request("order6")="asc" then%><img src="images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a> </td>
    <td class="category">
      <a href="celiangshebei/celiangshebeishiyan.asp?order7=<%if request("order7")="asc" then%>desc<%else%>asc<%end if%>&page=<%=currentpage%>&startdate=<%=nowstartdate%>&enddate=<%=nowenddate%>&ku=<%=nowku%>&keyword=<%=nowkeyword%>" class="title">出厂编号
      <%if request("order7")="asc" then%><img src="images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a> </td>
    <td class="category">修改</td>
        <td class="category">删除</td>
      </tr>
      

  2.   

      <%
      set rs_clsb =server.createobject("ADODB.RecordSet")
      sql_clsb="select * from clsb"  if request("order1")<>"" then
        sql_clsb=sql_clsb&" order by zylb "&request("order1")
      elseif request("order2")<>"" then
        sql_clsb=sql_clsb&" order by clsbmc "&request("order2")
      elseif request("order3")<>"" then
        sql_clsb=sql_clsb&" order by xhgg "&request("order3") 
      elseif request("order4")<>"" then
        sql_clsb=sql_clsb&" order by clfw "&request("order4") 
      elseif request("order5")<>"" then
        sql_clsb=sql_clsb&" order by zqd "&request("order5") 
      elseif request("order6")<>"" then
        sql_clsb=sql_clsb&" order by sccj "&request("order6")
      elseif request("order7")<>"" then
        sql_clsb=sql_clsb&" order by sbbh "&request("order7")
      else
        sql_clsb=sql_clsb  
      end if

      rs_clsb.open sql_clsb,conn,1,1
      if not rs_clsb.eof then
      rs_clsb.pagesize=20
      rs_clsb.absolutepage=currentpage
      for currentrec=1 to rs_clsb.pagesize
        if rs_clsb.eof then
          exit for
        end if
      %>
      <tr onMouseOver="this.className='highlight'" onMouseOut="this.className=''">
        <td align="center"><img src="images/folder_close.gif" width="18" height="9" style="cursor:hand" onClick="collapse(this,'celiangshebeishiyan<%=currentrec%>')"/></td>
    <td align="center" height="25"><%=rs_clsb("zylb")%></td>
    <td align="center"><%=rs_clsb("clsbmc")%></td>
    <td align="center"><%=rs_clsb("xhgg")%></td>
    <td align="center"><%=rs_clsb("clfw")%></td>
    <td align="center"><%=rs_clsb("zqd")%></td>
    <td align="center"><%=rs_clsb("sccj")%></td>
    <td align="center"><%=rs_clsb("sbbh")%></td>
    <td align="center"><div align="absmiddle" style="cursor:hand;"><a href="#" onClick="javascript:var win=window.open('buy_modi.asp?id=<%=rs_clsb("id")%>','修改','width=853,height=470,top=176,left=161,toolbar=no,location=no,directories=no,status=no,menubar=no,resizable=no,scrollbars=yes'); win.focus()">录入</a></div></td>
        <td align="center"><input type="checkbox" name="ID" value="<%=rs_clsb("id")%>" style="border:0"></td>
      </tr>
       <tr id="celianshebei1<%=currentrec%>" style="display:none;">
        <td colspan="16" class="category">
      <table align="center" cellpadding="4" cellspacing="1" class="grid" border="1" width="100%">
    <tr align="center">
      <td height="30">附件</td>
      <td >使用地点</td>
      <td>使用人</td>
      <td>设备领取日期</td>
      <td>检定方式</td>
      <td>检定周期</td>
      <td>检定月份</td>
      <td>ABC</td>
    </tr>   
        <tr>
      <td align="center"><%=rs_clsb("fj")%></td>
      <td align="center"><%=rs_clsb("sydd")%></td>
      <td align="center"><%=rs_clsb("syr")%></td>
      <td align="center"><%=rs_clsb("sblqrq")%></td>
      <td align="center"><%=rs_clsb("jdfs")%></td>
      <td align="center"><%=rs_clsb("jdzq")%></td>
      <td align="center"><%=rs_clsb("jdyf")%></td>
      <td align="center"><%=rs_clsb("abc")%></td>
    </tr>
      </table>
      </tr>
      <%
        rs_clsb.movenext
      next
      else
      %>
      <tr align="center" onMouseOver="this.className='highlight'" onMouseOut="this.className=''">
        <td colspan="16" height="25" align="center" style="color:red"><b>没有找到记录</b></td>
      </tr>
      <%
      end if
      %>
      
      
      
      <%
      if rs_clsb.recordcount>0 then 
      %> 
      <tr>
        <td colspan="16" height="30" class="category">
    <table cellpadding=0 cellspacing=0 width="100%">
    <tr>
    <td width="20%" align="left" style="color:#FF0000;">&nbsp;双击查看打印单</td>  
    <td width="80%" align="right">
    &nbsp;&nbsp;
          <%=rs_clsb.recordcount%>&nbsp;条信息&nbsp; 共&nbsp;<%=rs_clsb.pagecount%>&nbsp;页&nbsp;
      <%
      nowstart=currentpage-3
      if nowstart<1 then
        nowstart=1
      end if
      nowend=currentpage+3
      if nowend>rs_clsb.pagecount then
        nowend=rs_clsb.pagecount
      end if
      response.write "&nbsp;<a href='?startdate="&nowstartdate&"&enddate="&nowenddate&"&ku="&nowku&"&keyword="&nowkeyword&"&page=1&order1="&request("order1")&"&order2="&request("order2")&"&order3="&request("order3")&"&order4="&request("order4")&"&order5="&request("order5")&"&order6="&request("order6")&"&order7="&request("order7")&"' class='page'>最前页</a>&nbsp;"
      for ipage=nowstart to nowend
        if cstr(ipage)=cstr(currentpage) then
          response.write "&nbsp;<span style='font-weight:bold;color:#5858E6'>" & ipage &"</span>&nbsp;"
        else
          response.write "&nbsp;[&nbsp;<a href='?startdate="&nowstartdate&"&enddate="&nowenddate&"&ku="&nowku&"&keyword="&nowkeyword&"&page="&ipage&"&order1="&request("order1")&"&order2="&request("order2")&"&order3="&request("order3")&"&order4="&request("order4")&"&order5="&request("order5")&"&order6="&request("order6")&"&order7="&request("order7")&"' class='page'>" & ipage &"</a>&nbsp;]&nbsp;"
        end if
      next
      response.write "&nbsp;<a href='?startdate="&nowstartdate&"&enddate="&nowenddate&"&ku="&nowku&"&keyword="&nowkeyword&"&page="&rs_clsb.pagecount&"&order1="&request("order1")&"&order2="&request("order2")&"&order3="&request("order3")&"&order4="&request("order4")&"&order5="&request("order5")&"&order6="&request("order6")&"&order7="&request("order7")&"' class='page'>最后页</a>&nbsp;"
    %>
        <select name="page" onChange="form1.action='?';form1.submit();">
    <%
    for x=1 to rs_clsb.pagecount
    %>
      <option value="<%=x%>"<%if currentpage=trim(cstr(x)) then%> selected="selected"<%end if%>><%=x%></option>
    <%
    next
    %>
    </select>
    <input name="chkall" type="checkbox" id="chkall" value="select" onClick="CheckAll(this.form)" style="border:0"> 全选
    <input type="submit" value="删 除" onClick="return confirm('此操作无法恢复!!!请慎重!!!\n\n确定要删除所选择的入库记录吗?')" class="button">
      </tr></table></td></tr>
    <%end if%> 
    </form>   
    </table>
    <!--endprint-->
    </td>
    <td></td>
    </tr>
    <tr>
    <td><img src="images/r_4.gif" alt="" /></td>
    <td></td>
    <td><img src="images/r_3.gif" alt="" /></td>
    </tr>
    </table>
    </body>
    </html>
      

  3.   

    真复杂,大概这样理解吧<script type="text/javascript">
    function restatic(i){
    var menu=document.getElementById(i);
    if(menu.style.display=="none"){
    menu.style.display="block"
    }else{
    menu.style.display="none"
    }
    }
    </script>
      

  4.   

    jquery里有show和hide方法  类似于style.display="block"和"none"展开和折叠就是控制那个dom该显示那个隐藏
      

  5.   

    LZ  WEB基本功不扎实
    建议多研究一下XHTML CSS JS这些客户端常用东西,否则在技术方面发展有困难
    明白这些之后,展/折就很简单了