📄 sys_showallask.asp

📁 直接解压即可都是asp源码超经典的啊
💻 ASP
字号:


<!--#include file="conn.asp"-->
<% 
id=session("userid")
username=session("username")
if id="" or username="" then
response.Redirect("adminloginerror.asp")
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from adminuser where username='"& username &"' and id=" & id &""
rs.open sql,conn,3,3
if rs.eof then
response.Redirect("adminloginerror.asp")
else
%>
<html>

<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">


<body style="background-color: #D6DFF7">
<br>
  <div align="center">
    <center>
  <table width="90%" border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
  <form name="form1" method="post" action="sys_showsearchask.asp">
    <tr> 
      <td><div align="center" class="f1">客 户 提 问 搜 索</div></td>
    </tr>
    <tr> 
      <td><div align="center">请输入业务跟踪号： 
          <input name="keyword" type="text" id="keyword2" size="20">
          <input type="submit" name="Submit" value="搜索">
        </div></td>
    </tr>
	</form>
  </table>
    </center>
</div>
<br>
<div align="center">
  <center>
<table width="98%" border="1" cellpadding="5" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
  <tr> 
    <td background="images/admin/admin_bg_1.gif"><div align="center">以 下 为 已 回 复 的 客 户 提 问 历 史 记 录</div></td>
  </tr>
  <tr> 
    <td bordercolor="#FFFFFF"> 
      <%
	  myself=request.servervariables("path_info")
	   	  typ=request.QueryString("ask")
	Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from ask where typ="& typ &" and reask='已回复' order by id desc"
rs.open sql,conn,3,3
if rs.eof then
response.write"<div align=center class=f1>暂时没有已回复的客户提问记录</div>"
else
rs.Pagesize=10
page=clng(request("page"))

if page<1 or page=empty then page=1
if page>rs.pagecount then page=rs.pagecount
rs.Absolutepage=page
do while not rs.eof
%>
      <table width="100%" border="0" cellspacing="0" cellpadding="5">
        <tr> 
          <td>业务跟踪号：<a href=sys_showask.asp?ywid=<%=rs("ywid")%> class=f1><%=rs("ywid")%></a></td>
          <td width="20%"><%=rs("reask") %></td>
        </tr>
      </table>
	  <% 
	  i=i+1
		  if i>8 then exit do
	  rs.movenext
		      loop
			  end if
			  %>
      <br>
      <div align="center">
        <center>
      <table width="100%" border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
        <tr> 
          <form action=<%=myself%> method=get>
            <td> 
              <%
if page<>1 then %>
              <div align="center"><a href=<%=myself%>?page=1>第一页</a> <a href=<%=myself%>?page=<%=(page-1)%>>上一页</a> 
                <%
end if
if page<>rs.pagecount then
%>
                <a href=<%=myself%>?page=<%=(page+1)%>>下一页</a> <a href=<%=myself%>?page=<%=rs.pagecount%>>最后一页</a> 
                <% end if %>
                <font style="font-size:9pt">&nbsp;输入页次:</font> 
                <input type=text name=page22 size=3 class="border">
                <font style="font-size:9pt">页次:</font><font color=red style="font-size:9pt"><%=page%>/<%=rs.pagecount%></font> 
                共有记录<font color=red style="font-size:9pt"><%=rs.recordcount %></font>条</div></td>
          </form>
        </tr>
      </table>
      
        </center>
      </div>
      
    </td>
  </tr>
</table>
  </center>
</div>
<br>
</body>
</html>
<% 
end if
rs.close
set rs=nothing
set conn=nothing
%>
⌨️ 快捷键说明

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