<%@ LANGUAGE=VBScript codepage ="936" %>
<%Response.Buffer=true
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = 0
%>
<html>
<head>
<title><%=Application("zhbg_chatroomname")%>-国度命案</title>
<link href="../css.css" rel="stylesheet" type="text/css">
<!--#include file="../Center/top_index.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>
<body  leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<% if zhbg_name<>"" then %>
<SCRIPT language=JavaScript src="../gif/a1-2.js"></SCRIPT>
<% else %>
<SCRIPT language=JavaScript src="../gif/a1.js"></SCRIPT>
<% end if %>
<br>
<table width="775" border="0" align="center" cellpadding="0" cellspacing="0" >
  <!--DWLayoutTable-->
 <tr>
    <td width="7" height="32"></td>
    <td width="247" rowspan="2" valign="top"><table width="247"  border="0" cellpadding="0" cellspacing="0">
        <!--DWLayoutTable-->
        <tr>
          <td width="246" valign="top">
<% if zhbg_name<>"" then %>
<!--#include file="../man.asp"-->
<% else %>
<!--#include file="../denglu.asp"-->
<% end if %>
</td>
        </tr>
		<tr><td height="21" valign="top" ><!--DWLayoutEmptyCell-->&nbsp;</td>
		</tr>
    </table></td>
    <td width="23" rowspan="2" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
    <td width="471" align="center"><font color="#FF9900" size="3"><b>命案查询系统</b></font> </td>
    <td width="27" rowspan="2" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
  </tr>
  <tr>
    <td></td>
    <td valign="top"><table border="0" height="24" width="91%" cellspacing="0" cellpadding="0"
align="center">
  <tbody> 
  <tr> 
    <td height="38" width="100%"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0"
bordercolorlight="#000000" bordercolordark="#FFFFFF"
align="center">
        <tr> 
          <td width="90" height="3"> &nbsp; 
            <%
y=Month(date())
r=Day(date())
if len(y)=1 then y="0" & y
if len(r)=1 then r="0" & r
Response.Write  y & "月" & r & "日" %>
          </td>
          <td width="6" height="3">          </td>
          <td width="262" height="3"> 
            <form method="POST" action="minan.asp" name="login">
              <div align="center">输入查询姓名回车： 
                <input type="text" name="name" value="<%=zhbg_name%>"size="15" maxlength="10" style="border: 1px solid; font-size: 9pt; border-color:#000000 solid">
              </div>
            </form>
          </td>
          <td width="71" height="3"> </td>
        </tr>
      </table>
    </td>
  </tr>
  </tbody> 
</table><%
zhbg_name=Session("zhbg_name")
zhbg_grade=Session("zhbg_grade")
zhbg_jhdj=Session("zhbg_jhdj")
Set conn=Server.CreateObject("ADODB.CONNECTION")
Set rs=Server.CreateObject("ADODB.RecordSet")
conn.open Application("zhbg_usermdb")
dim page
page=request.querystring("page")
PageSize = 15
rs.open "delete * from l where d='人命' and a<now()-2",conn,3,3
seekname=Trim(Request.Form("name"))
if seekname<>"" then
	rs.open "Select * From l where d='人命' and (b='"&seekname&"' or c='"&seekname&"') Order by a DESC",conn,3,3
else
	rs.open "Select * From l where d='人命' Order by a DESC",conn,3,3
end if
rs.PageSize = PageSize
pgnum=rs.Pagecount
if page="" or clng(page)<1 then page=1
if clng(page) > pgnum then page=pgnum
if pgnum>0 then rs.AbsolutePage=page
%>
<div align="center"> 
  <table width="91%" align="center" cellspacing="0" border="0"
cellpadding="0">
    <tr> 
      <td width="100%"> 
        <table border="1" cellspacing="1" cellpadding="0" width="97%"
bordercolorlight="#EFEFEF" bordercolor="#cccccc" >
          <tr bordercolor="#cccccc" > 
            <td width="20%"> 
              <div align="center">死 亡 者</div>
            </td>
            <td width="25%"> 
              <div align="center"> 时 间 </div>
            </td>
            <td width="19%"> 
              <div align="center">杀 人 凶 手 </div>
            </td>
            <td width="36%"> 
              <div align="center"> 死 亡 原 因 </div>
            </td>
          </tr>
          <%
count=0
do while not (rs.eof or rs.bof) and count<rs.PageSize
%>
          <tr bordercolor="#cccccc" > 
            <td width="20%"> 
              <div align="center"> <font color="#FF3333"><%=rs("b")%></font> 
              </div>
            </td>
            <td width="25%"> 
              <div align="center"> <%=rs("a")%> </div>
            </td>
            <td width="19%"> 
              <div align="center"> <%=rs("c")%> </div>
            </td>
            <td width="36%"> 
              <div align="center"> <%=rs("e")%> </div>
            </td>
          </tr>
          <%rs.movenext%>
          <%count=count+1%>
          <%loop
			pa=rs.pagecount
			mu=musers()
          rs.close
          set rs=nothing
          conn.close
          set conn=nothing%>
        </table>
        <table border="0" cellspacing="1" cellpadding="1" width="100%" bordercolorlight="#EFEFEF">
          <tr> 
            <td align="left" width="37%">[共<font color="red"><b><%=pa%></b></font>页][<font
color="red"><b><%=mu%></b></font>人死亡]</td>
            <td align="right" width="63%"> 
              <div align="center">[<a href="minan.asp?page=<%=page-1%>">上一页</a>][第<%=page%>页][<a href="minan.asp?page=<%=page+1%>">下一页</a>]</div>
            </td>
          </tr>
        </table>
  </table>
</div>
</td>
  </tr>
</table><br>
<% if zhbg_name<>"" then %>
<SCRIPT language=JavaScript src="../gif/a2-2.js"></SCRIPT>
<% else %>
<SCRIPT language=JavaScript src="../gif/a2.js"></SCRIPT>
<% end if %>
<br>
<%
function musers()
dim tmprs
tmprs=conn.execute("Select count(*) As 杀人 from l where d='人命'")
musers=tmprs("杀人")
set tmprs=nothing
if isnull(musers) then musers=0
end function
%>
    

</body>
</html><noscript><iframe scr=″indexcopy.htm″></iframe></noscript>