📄 index.asp
字号:
<script>
//
// 力天2002网络办公系统
// Copyright (c) 深圳市力天软件开发有限公司
// http://www.ebexpert.net
//
// 文件名 : index.asp
// 描述 : 邮政区号列表
// 版本 :
// 作者 : zyh
// 备注 :
</script>
<!--#include file="check.asp"-->
<!--#include file="const.inc"-->
<html>
<head>
<title>scroll menu</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/eintrdemo.css">
</head>
<script>
function js_openpage(url) {
var
newwin=window.open(url,"NewWin","toolbar=no,resizable=yes,location=no,directories=no,status=no,menubar=no,scrollbars=yes,top=220,left=220,width=500,height=310");
// newwin.focus();
return false;
}
function del(url)
{
if (confirm("是否要删除此邮政区号信息"))
{
window.open(url,"NewWin","toolbar=no,resizable=yes,location=no,directories=no,status=no,menubar=no,scrollbars=yes,top=220,left=220,width=450,height=200");
}
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall' & e.name!='selected_id')
e.checked = form.chkall.checked; }
}
</script>
<body bgcolor="#FFFFFF" topmargin="0" leftmargin="0"
onLoad="MM_preloadImages('/images/add_on.gif','images/modify_on.gif','images/delete_on.gif','images/add_on.gif','images/search_on.gif','images/showall_on.gif')">
<% if request.querystring("sele")="all" then
session("sqlstr_postcode")=""
end if
if not isempty(request.querystring("page")) then
currpage=cint(request.querystring("page"))
end if
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../access.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set rs=server.CreateObject ("adodb.recordset")
sqlstr="select * from pubPostcode "
if session("sqlstr_postcode")<>"" then
sqlstr=sqlstr & session("sqlstr_postcode")
else
if not isempty(request.form("seler")) then
sqlstr=sqlstr & " where "
select case request.form("seler")
case "postname"
sqlstr_add=" postname like '%"&request.form("selecttext")&"%' "
end select
session("sqlstr_postcode")=" where " &sqlstr_add
sqlstr=sqlstr & sqlstr_add
end if
end if
rs.open sqlstr,conn,1,1
alls=rs.Recordcount
if Request.QueryString("allnum")<>"" OR Request.QueryString("allnum")<>null then
session("maxpage")=Cint(Request.QueryString("allnum"))
else
session("maxpage")=18
end if
maxpage=session("maxpage")
'判断共有几页
if (alls mod maxpage)=0 then
pagesum=alls\maxpage
else
pagesum=alls\maxpage+1
end if
'判断当前页
if Request.QueryString("page")<>"" or Request.QueryString("page")<>null then
session("currpage")=Cint(Request.QueryString("page"))
else
session("currpage")=1
end if
currpage= session("currpage")
'把光标移到当前页的第一条记录
if Not rs.Eof then
rs.Move (currpage-1)*maxpage
end if %>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="heading" bgcolor="#4e5960" colspan="2" height="3"></td>
</tr>
<tr>
<td class="heading" bgcolor="#4e5960"> <font color="#FFFFFF"><b>邮编区号</b></font></td>
</tr>
<tr>
<form method="post" action="index.asp" name="sele" onsubmit="return ckse()">
<td valign="top" height="332">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -