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

📄 smsinfor.asp

📁 机票预定系统 各个模块的设计-ticket reservation systems detailed design system modules of the design
💻 ASP
字号:
<!--#include file="include/conn.asp"-->
<!--#include file="CheckSystem.asp"-->
<%
checkmanager(session("ManagerName"))'调用函数,验证管理员是正常登陆
if trim(request("action"))="delete" then
	k=request("deleteid")
	deleteid=split(request("deleteid"))
	for i=0 to ubound(deleteid)
	deleteid(i)=replace(deleteid(i),",","")
	sql="delete from SmsInfor where Id ="&deleteid(i)
	conn.execute(sql)
	next
	action=""
	msg_ok="群组删除成功!id共"&i&"个,分别是"&k
end if
'-----------------以上是册除代码
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>后台管理机票系统</title>
<link href="include/css.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" type="text/css" href="style/comm.css" />
<link rel="stylesheet" type="text/css" href="style/skin0.css" />
</head>
<script language="javascript">
function call(){
//添加记录或修改记录时所跳转的页面
window.location.href="SmsInforMod.asp";
return false;
}
function dele(){
//删除记录所用的函数
if(!confirm('已经确认需要删除选中的信息吗?')) return false;
ZXLform.submit();
}
function sltall(){
var nn=self.document.all.item("deleteid");
for(j=0;j<nn.length;j++){
self.document.all.item("deleteid",j).checked=true;
  }
}
function escall(){
var nn=self.document.all.item("deleteid");
for(j=0;j<nn.length;j++){
self.document.all.item("deleteid",j).checked=false;
  }
}
</script>
<body>
<div class="txt_title">常用短信定义</div>
<TABLE width="98%" cellPadding=0 cellSpacing=1>
      <form name="ZXLform" action="SmsInfor.asp" method="post" >
          <TR bgColor=#C3E7F9>
            <TH height="30">序号</TH>
			<TH width="15%">标识</TH> 
            <TH width="63%"> 内容 </TH>
            <TH width="7%" >修改</TH>
            <TH width="7%">操作</TH>
          </TR>
	<%
	dim szSQL
    set oRst=Server.CreateObject("AdoDb.recordset")
	szSQL="select * from SmsInfor  order by ID desc"
	oRst.Open szSQL,conn,1,1
		  '--------------------分页
		if oRst.eof then%>
		 <TR bgColor=#EEEEEE>
          <Td height="25" colspan="5">当前没有内容</Td>
		  </TR>
			<%
		else
		if request.QueryString("pageno")="" then
			pageno=1
		else
			pageno=cint(request.QueryString("pageno"))
		end if
		recordcounts=oRst.recordcount
		pagesiz=15
		oRst.pagesize=15
		pagecounts=oRst.pagecount
		if pageno<1 then
 			pageno=1
 		end if
 		if pageno>pagecounts-1 then
			pageno=pagecounts
 		end if
		oRst.absolutepage=pageno
        i=0
		while not oRst.eof  and pagesiz>0			
           i=i+1
           bc="bgcolor='#eff3f7'"
           if i mod 2=0 then bc="bgcolor='#FFFFFF'"
				Id=oRst("Id")
				infor=oRst("infor")
				flagstr=oRst("flagstr")
				createtime=oRst("createtime")
		  %>
          <TR <%=bc%> >
            <TD width="8%" height="25" align=center ><%=i%></TD>
			<TD><%=flagstr%></TD>
            <TD title="<%=infor%>"><%=left(infor,20)%></TD>
            <TD align="center"><a href="SmsInforMod.asp?Id=<%=Id%>">修改</a></TD>
            <TD align="center"><input name="deleteid" type="checkbox" id="deleteid" value="<%=Id%>">            </TD>
          </TR>
          <%
			oRst.MoveNext
			pagesiz=pagesiz-1
			wend
		end if
		%>
        <TR bgColor=#EEEEEE>
          <Td height="30" colspan="5">
             <input type="button" name="AddnewBunk" onClick="javascript:call();" value="添加自定义短信">
             <input type="hidden" name="action" value="delete">
             <input name="button" type="button" onClick="return dele()" value="删除">
    <a href onClick="sltall()" onMouseDown="sltall()">全选</a><a href onClick="escall()" onMouseDown="escall()">/全不选</a>&nbsp;&nbsp;共有<span style="color:red;"><%=recordcounts%></span>条;每页显示<font style="color:red;">15</font>条;转到第
                  <select name="select" id="pa" onChange="window.location.href='?pageno='+document.all.pa.value;">
                    <% for i=1 to pagecounts 
					  if i=pageno then
					  response.write("<option value="&i&" selected>"&i&"</option>")
					  else
					  response.write("<option value="&i&">"&i&"</option>")
					  end if
					 next
					%>
                  </select>
                  页</Td>
        </TR>
      </form>
</TABLE>
</body>
</html>


⌨️ 快捷键说明

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