<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
|
<%Session.CodePage=65001%>
|
<!--#include virtual="/inc/chkadmin.gds"-->
|
<!--#include virtual="/inc/function.gds"-->
|
<script language=javascript>
|
var UnitListArray=new Array()
|
<%
|
UnitSearchTXT=trim(Request("UnitSearchTXT"))
|
OA_CompetencyID=trim(Request("OA_CompetencyID"))
|
acc1=trim(Request("page"))
|
if acc1="" then acc1=1
|
acc2=1
|
i=0
|
acc3=0
|
Set rs = Server.CreateObject("ADODB.Recordset")
|
if len(UnitSearchTXT)>0 then
|
sql="select UnitID,UnitName,UnitShort,UnitAddress from IntroducerUnitData where UnitState>0 and (UnitName like '%"&UnitSearchTXT&"%' or UnitShort like '%"&UnitSearchTXT&"%' or UnitAddress like '%"&UnitSearchTXT&"%') order by UnitID"
|
else
|
sql="select UnitID,UnitName,UnitShort,UnitAddress from IntroducerUnitData where UnitState>0 order by UnitID"
|
end if
|
rs.open Sql,objConn,1,1
|
if not rs.eof then
|
rs.pagesize=6
|
rs.absolutepage=acc1
|
acc2=rs.pagecount
|
acc3=rs.recordcount
|
end if
|
do while not rs.Eof and i<6
|
UnitID = rs("UnitID")
|
UnitName = rs("UnitName")
|
UnitShort = rs("UnitShort")
|
UnitAddress = rs("UnitAddress")
|
%>
|
UnitListArray[<%=i%>]=new Array("<%=UnitID%>","<%=UnitName%>","<%=UnitShort%>","<%=UnitAddress%>")
|
<%i=i+1
|
rs.movenext
|
loop
|
rs.close()
|
%>
|
parent.JS_UnitList(UnitListArray,<%=acc1%>,<%=acc2%>,'<%=UnitSearchTXT%>',<%=acc3%>);
|
</script>
|
<%Response.End%>
|
