<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%><!--#include file="../CONNECTIONS/CONN.asp"--><!--#include file="../define/define.asp"--><?xml version="1.0" encoding="UTF-8"?> <sbgldatas><% set rs=server.CreateObject("ADODB.RecordSet") page=Request.QueryString ("page") sqlstr ="select device_name,type,standard,devi_check_time,buy_time,sum,status,device_no,lf_no,unit_code from sbk where scrap_flag=1 and status=1" if page=""then page=1 rs.source = sqlstr &" order by device_no desc" if rs.source<>""then rs.Open rs.Source,conn,3,1 rs.PageSize=15 rs.CacheSize = RS.PageSize for i=1to rs.PageSize *( page-1) ifnot rs.EOF then rs.MoveNext next For i=1to rs.PageSize if rs.source<>""then ifnot rs.EOF then %> <sbgldata> <unit_code><%=get_dev_unit(rs("unit_code"))%></unit_code> <facaption><%=trim(rs("device_name"))%></facaption> <type><%=rs("type")%></type> <standard><%=rs("standard")%></standard> <lfno><%=rs("lf_no")%></lfno> <buytime><%=rs("buy_time")%></buytime> <sum><%=rs("sum")%></sum> <status><%=rs("status")%></status> </sbgldata> <% rs.movenext endif endif next %> </sbgldatas>
第二步: 建立HTC文件,tablist.htc
<PUBLIC:COMPONENT> <public:property name="sitedata"/> <public:property name="nodes"/> <public:property name="columns"/> <public:attach event="ondocumentready" onevent="event_ondocumentready()"/> <public:attach event="onclick" onevent="gourl()"/> <script language="jscript"> var global=window.document; var tabObj =this; var xmlconf=new ActiveXObject("MSXML2.DOMDocument"); xmlconf.async=false; var bkcolor='#C0C0FE'; var selrowIndex ; var currPage =1; function event_ondocumentready()...{ listtab(currPage); disPage(); var actButNext = document.createElement("input"); var actButPre = document.createElement("input"); var actDiv = document.createElement("div"); actDiv.border='1'; actDiv.position='absolute'; actDiv.align='right'; actButNext.type ='button'; actButNext.value='下页'; actButNext.className='input_button2'; actButPre.type='button'; actButPre.value='上页'; actButPre.className='input_button2'; actButNext.onclick=onatcNextclick; actButPre.onclick=onatcPreclick; actDiv.insertAdjacentElement("beforeEnd",actButPre); actDiv.insertAdjacentHTML("beforeEnd"," "); actDiv.insertAdjacentElement("beforeEnd",actButNext); global.body.appendChild(actDiv); } function onatcNextclick()...{ var obj = global.getElementById('mytab'); for(var i=obj.rows.length-1;i>1;i--) obj.deleteRow(i-1); listtab(currPage++); disPage(); } function onatcPreclick()...{ var obj = global.getElementById('mytab'); for(var i=obj.rows.length-1;i>1;i--) obj.deleteRow(i-1); listtab((currPage <=1) ?1 : currPage--); disPage(); } function mouseclick()...{ var elmt=event.srcElement; var to = elmt.parentNode.parentNode.parentNode; if(elmt.tagName.toUpperCase()!="TD") return; if(elmt.parentNode.style.backgroundColor != bkcolor)...{ if (selrowIndex) to.rows[selrowIndex].style.backgroundColor=''; selrowIndex = elmt.parentNode.sectionRowIndex; elmt.parentNode.style.backgroundColor=bkcolor; } } function gourl()...{ var url=event.srcElement.href; if(url) location.href=url; } function listtab(page)...{ xmlconf.load(sitedata+'?page='+page); if(xmlconf.parseError.errorCode!=0)...{ alert("无法加载部门列表!原因:"+xmlconf.parseError.reason+" 地址:"+sitedata); return; } //alert(this.rows[0].cells.length) var tn = xmlconf.selectNodes(nodes); var mytr,mytd; for (var r =0;r < tn.length;r++)...{ mytr=this.insertRow(); for(var c =0;c < columns;c++)...{ mytd=mytr.insertCell(); mytd.innerText=tn.item(r).childNodes.item(c).text; mytd.style.color="#336699"; mytd.onclick = mouseclick; mytd.style.cursor="hand"; } } } function disPage()...{ window.status='第 '+currPage+' 页'; } </script> </PUBLIC:COMPONENT>