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

📄 bookmngfsh.asp

📁 旅游在线报名的系统包括地域管理
💻 ASP
字号:
<!--#include file="../conndb.asp"-->
<!--#include file="isAdmin.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>报名管理</title>
<link href="../style.css" rel="stylesheet">
<script language="javascript">
function AreaWin(url) {
  var oth="toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,left=200,top=200";
  oth = oth+",width=620,height=430";
  var AreaWin=window.open(url,"AreaWin",oth);
  AreaWin.focus();
  return false;
}
function SelectChk()
{
	var s=false;
	var bookid,n=0;
	var strid,strurl;
	var nn = self.document.all.item("book")
	for (j=0;j<nn.length;j++)
	{
		if (self.document.all.item("book",j).checked)
		{
			n = n + 1;
			s=true;
			bookid = self.document.all.item("book",j).id+"";
			if(n==1)
			{
				strid = bookid;
			}
			else
			{
				strid = strid + "," + bookid;
			}
		}
	}

	strurl = "BookDelt.asp?id=" + strid;
	if(!s)	{
		alert("请选择要删除的报名信息!");
		return false;
	}
	if ( confirm("你确定要删除这些报名信息吗?")) {
	    form1.action=strurl;
	    form1.submit();
	}
}
function sltAll()
{
	var nn = self.document.all.item("book");
	for(j=0;j<nn.length;j++)
	{
		self.document.all.item("book",j).checked = true;
	}
}
function sltNull()
{
	var nn = self.document.all.item("book");
	for(j=0;j<nn.length;j++)
	{
		self.document.all.item("book",j).checked = false;
	}
}
</script>
</head>
<body link="#000080" vlink="#080080">
<form id="form1" name="form1" method="POST">
<%
  Dim rs
  Set rs = Server.CreateObject("ADODB.RecordSet")
  '显示报名信息
  sql = "SELECT b.*, l.LineName FROM Book b, Line l WHERE b.Flag=1 And b.LineId=l.LineId ORDER BY b.BookId DESC"
  rs.Open sql, Conn, 1, 1
%>
<p align=center><font style='FONT-SIZE:12pt' color="#000080"><b>已处理的报名信息</b></font></p>
<table align=center border="1" cellspacing="0" width="100%" bordercolorlight="#4DA6FF" bordercolordark="#ECF5FF">
  <tr>
   <td width="12%" align="center" bgcolor="#BEDCFA"><strong>报名日期</strong></td>
   <td width="40%" align="center" bgcolor="#BEDCFA"><strong>线路名称</strong></td>
   <td width="16%" align="center"  bgcolor="#BEDCFA"><strong>报名人</strong></td>
   <td width="24%" align="center"  bgcolor="#BEDCFA"><strong>联系方式</strong></td>
   <td width="12%" align="center"  bgcolor="#BEDCFA"><strong>选择</strong></td>
  </tr>
<%
  Do While Not rs.Eof
%>
  <tr>
    <td align="center"><%=rs("PostDate")%></td>
	<td><a href="/travel/LineView.asp?lid=<%=rs("LineId")%>" target="_blank">
	<%=rs("LineName")%></a></td>
    <td align="center"><a href="BookView.asp?bid=<%=rs("BookId")%>" onclick="return AreaWin(this.href)">
    <%=rs("BookPerson")%></a></td>
    <td align="center"><%=rs("Telephone")%>&nbsp;&nbsp;<%=rs("Mobile")%></td>
    <td align="center"><input type="checkbox" name="book" id="<%=rs("BookId")%>"></td>
  </tr>
  <%
    rs.MoveNext()
  Loop
  rs.Close
%>
</table>
<p align="center">
		<input type="button" value="全 选" onclick="sltAll()" name=button1>
		 &nbsp;&nbsp;<input type="button" value="清 空" onclick="sltNull()" name=button2>
 		 &nbsp;&nbsp;<input type="submit" value="删 除" name="tijiao" onclick="SelectChk()">
<input type=hidden name="book"></p>
</form>
</body>
</html>

⌨️ 快捷键说明

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