<html>
<head>
<META content=ywnt,云网互动影视管理系统 name=keywords>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>云网互动影视6.0--网吧管理</title>
<LINK href="css/css.css" type=text/css rel=stylesheet>
</head>
<BODY leftMargin=0 topMargin=0 scroll=yes MARGINHEIGHT="0" MARGINWIDTH="0">
<script language="JavaScript" src="YWNT_TMS_Inc/YWNT_TMS_Common.js"></script>
<!--#include file="../Conn.asp" -->
<!--#include file="YWNT_TMS_inc/YWNT_TMS_Function.asp" -->
<!--#include file="YWNT_TMS_inc/YWNT_TMS_Page.asp" -->
<%
'===================================================================================================================
'软件名称：云网影视管理系统
'Copyright (C) 2002-2007 ywnt.net  All rights reserved.
'产品咨询QQ：489234,2813712
'程序版权：云网互动科技有限公司
'程序开发：云网互动科技有限公司
'官方网站：http://www.ywnt.net 
'郑重声明:
'    1、免费版本请在程序首页保留版权信息，并做上本站LOGO友情连接,商业版本无此要求;
'    2、任何个人或组织不得在授权允许的情况下删除、修改、拷贝本软件及其他副本上一切关于版权的信息；
'    3、云网互动科技有限公司保留此软件的法律追究权利
'===================================================================================================================
Call CheckLogin("Wcafes")
sub EditSave()
		Set Rs=Server.CreateObject(YWNT_TMS_RS)
		sql="select * from YWNT_TMS_Wcafes where ID="&NoSqlHack(Request.Form("ID"))
		Rs.open sql,Conn,1,3
		RS("WcafesName")=NoSqlHack(Request.Form("WcafesName"))
		RS("WcafesStartIP")=NoSqlHack(Request.Form("WcafesStartIP1")&"."&Request.Form("WcafesStartIP2")&"."&Request.Form("WcafesStartIP3")&"."&Request.Form("WcafesStartIP4"))
		RS("WcafesOverIP")=NoSqlHack(Request.Form("WcafesOverIP1")&"."&Request.Form("WcafesOverIP2")&"."&Request.Form("WcafesOverIP3")&"."&Request.Form("WcafesOverIP4"))
		RS("WcafesStartIPS")=NoSqlHack(EncodeIP(Request.Form("WcafesStartIP1")&"."&Request.Form("WcafesStartIP2")&"."&Request.Form("WcafesStartIP3")&"."&Request.Form("WcafesStartIP4")))
		RS("WcafesOverIPS")=NoSqlHack(EncodeIP(Request.Form("WcafesOverIP1")&"."&Request.Form("WcafesOverIP2")&"."&Request.Form("WcafesOverIP3")&"."&Request.Form("WcafesOverIP4")))
		RS("WcafesUseDate")=NoSqlHack(Request.Form("WcafesUseDate"))
		RS("WcafesGroup")=NoSqlHack(Request.Form("WcafesGroup"))
		'RS("WcafesAdmin")=Request.Form("WcafesAdmin")
		RS("WcafesNote")=NoSqlHack(Request.Form("WcafesNote"))
		Rs.Update
		Rs.Close
		Set Rs = Nothing
		Call AddLog("修改网吧用户"&Request.Form("WcafesName"),7)
		call Admin_ShowErr("<li>网吧用户修改成功</li>","Admin_Wcafes.asp",1)
end sub
sub AddSave()
		Set Rs=Server.CreateObject(YWNT_TMS_RS)
		sql="select * from YWNT_TMS_Wcafes"
		Rs.open sql,Conn,1,3
		Rs.addnew
		RS("WcafesName")=NoSqlHack(Request.Form("WcafesName"))
		RS("WcafesStartIP")=NoSqlHack(Request.Form("WcafesStartIP1")&"."&Request.Form("WcafesStartIP2")&"."&Request.Form("WcafesStartIP3")&"."&Request.Form("WcafesStartIP4"))
		RS("WcafesOverIP")=NoSqlHack(Request.Form("WcafesOverIP1")&"."&Request.Form("WcafesOverIP2")&"."&Request.Form("WcafesOverIP3")&"."&Request.Form("WcafesOverIP4"))
		RS("WcafesStartIPS")=NoSqlHack(EncodeIP(Request.Form("WcafesStartIP1")&"."&Request.Form("WcafesStartIP2")&"."&Request.Form("WcafesStartIP3")&"."&Request.Form("WcafesStartIP4")))
		RS("WcafesOverIPS")=NoSqlHack(EncodeIP(Request.Form("WcafesOverIP1")&"."&Request.Form("WcafesOverIP2")&"."&Request.Form("WcafesOverIP3")&"."&Request.Form("WcafesOverIP4")))
		RS("WcafesRegDate")=date()
		RS("WcafesUseDate")=date()+NoSqlHack(Request.Form("WcafesUseDate"))
		RS("WcafesGroup")=NoSqlHack(Request.Form("WcafesGroup"))
		'RS("WcafesAdmin")=Request.Form("WcafesAdmin")
		RS("WcafesNote")=NoSqlHack(Request.Form("WcafesNote"))
		Rs.Update
		Rs.Close
		Set Rs = Nothing
		Call AddLog("添加网吧用户"&Request.Form("WcafesName"),7)
		call Admin_ShowErr("<li>网吧用户添加成功</li>","Admin_Wcafes.asp",1)
end sub
sub Del()
	conn.execute "delete from YWNT_TMS_Wcafes WHERE ID="&Request.QueryString("ID")
	Call AddLog("删除网吧用户",7)
	call Admin_ShowErr("<li>网吧用户删除成功！</li>",""&Request.ServerVariables("HTTP_REFERER")&"",1)
end sub
sub Audit()
	Conn.execute("Update YWNT_TMS_Wcafes set WcafesAudit=1 where ID="&request.QueryString("ID")&"")
	Call AddLog("审核网吧用户",7)
	call Admin_ShowErr("<li>网吧用户审核成功！</li>",""&Request.ServerVariables("HTTP_REFERER")&"",1)
end sub %>
<table class=table cellspacing=1 cellpadding=3 width="98%" align=center border=0>
  <tbody>
    <tr>
      <td class=xingmu>网吧管理</td>
    </tr>
    <tr>
      <td class="hback"><a href="Admin_Wcafes.asp">网吧管理首页</a> | <a href="Admin_Wcafes.asp?Action=Add">网吧添加</a> | <a href="Admin_Wcafes.asp?WcafesAudit=0">网吧审核</a></td>
    </tr>
  </tbody>
</table>
<% Action=Trim(request.QueryString("Action"))
Select Case Action
Case "Add"
	call Add()
Case "AddSave"
	call AddSave()
Case "Edit"
		Set Rs=Server.CreateObject(YWNT_TMS_RS)
		sql="select * from YWNT_TMS_Wcafes where ID="&Request.QueryString("ID")
		Rs.open sql,Conn,1,1
		YWNT_TMS_ID=RS("ID")
		YWNT_TMS_WcafesName=RS("WcafesName")
		YWNT_TMS_WcafesStartIP=RS("WcafesStartIP")
		YWNT_TMS_WcafesStartIP=split(YWNT_TMS_WcafesStartIP,".")
		YWNT_TMS_WcafesOverIP=RS("WcafesOverIP")
		YWNT_TMS_WcafesOverIP=split(YWNT_TMS_WcafesOverIP,".")
		YWNT_TMS_WcafesUseDate=RS("WcafesUseDate")
		YWNT_TMS_WcafesAdmin=RS("WcafesAdmin")
		YWNT_TMS_WcafesNote=RS("WcafesNote")
		RS.close   
      	set RS=nothing
	call Edit()
Case "EditSave"
	call EditSave()
Case "Del"
	call Del()
Case "Audit"
    call Audit()
Case else
	call List()
End Select
sub List()
Dim int_RPP
	int_RPP=GetConfig("PageNumber") '设置每页显示数目%>
<table class=table cellspacing=1 cellpadding=3 width="98%" align=center border=0>
  <tbody>
    <tr>
      <td width="5%" align="center" class=xingmu>ID</td>
      <td align="center" class=xingmu>网吧名称</td>
      <td width="22%" align="center" class=xingmu>起始IP--结束IP</td>
      <td width="10%" align="center" class=xingmu>网吧管理员</td>
      <td width="10%" align="center" class=xingmu>注册时间</td>
	  <td width="10%" align="center" class=xingmu>到期时间</td>
	  <td width="15%" align="center" class=xingmu>操作</td>
    </tr>
		<%  Set Rs = server.CreateObject(YWNT_TMS_RS)
		sql="Select ID,WcafesName,WcafesStartIP,WcafesOverIP,WcafesRegDate,WcafesUseDate,WcafesAdmin,WcafesAudit from YWNT_TMS_Wcafes "
		if Request.QueryString("WcafesAudit")="" then
		WcafesAudit=1
		end if
		Select Case WcafesAudit
		Case 0
			sql=sql&"where WcafesAudit=0 Order by ID desc"
		Case Else
			sql=sql&"where WcafesAudit=1 Order by ID desc"
		End Select
		Rs.open sql,Conn,1,1
	if Rs.eof then
	   Response.Write"<TR  class=""hback""><TD colspan=""7"" class=""hback"" height=""40"">没有记录。</TD></TR>"
	else
		Rs.PageSize=int_RPP
		cPageNo=NoSqlHack(Request.QueryString("Page"))
		If cPageNo="" Then cPageNo = 1
		If not isnumeric(cPageNo) Then cPageNo = 1
		cPageNo = Clng(cPageNo)
		If cPageNo>Rs.PageCount Then cPageNo=Rs.PageCount 
		If cPageNo<=0 Then cPageNo=1
		Rs.AbsolutePage=cPageNo 
	for i=1 to int_RPP
	 if Rs.eof Then exit For %>
    <tr>
      <td height=32 align="center" class="hback"><%=RS("ID")%></td>
      <td height=32 class="hback"><%=RS("WcafesName")%></td>
      <td height=32 align="center" class="hback"><%=RS("WcafesStartIP")%>--<%=RS("WcafesOverIP")%></td>
      <td height=32 align="center" class="hback"><%=RS("WcafesAdmin")%></td>
      <td align="center" class="hback"><%=RS("WcafesRegDate")%></td>
	  <td align="center" class="hback"><%=RS("WcafesUseDate")%></td>
	  <td align="center" class="hback"><%if WcafesAudit<>1 then%><A href="Admin_Wcafes.asp?Action=Audit&ID=<%= RS("ID") %>">审核</A>｜<%end if%><A href="Admin_Wcafes.asp?Action=Edit&ID=<%=RS("ID")%>">修改</A>｜<A href="Admin_Wcafes.asp?Action=Del&ID=<%=RS("ID")%>">删除</A></td>
    </tr>
	<%Rs.MoveNext
	next 
	end if%>
	<tr align="right">
	<td height=32 colspan="7" class="hback"><% response.Write fPageCount(Rs,cPageNo) %></td>
	</tr>
  </tbody>
</table>
<%end sub
sub Add()%>
<table class=table cellspacing=1 cellpadding=3 width="98%" align=center border=0>
 <form name="form" action="Admin_Wcafes.asp?Action=AddSave" method="post" onSubmit="return WformIP();">
  <tbody>
    <tr>
      <td colspan="2" class=xingmu>网吧添加</td>
    </tr>
    <tr>
      <td width="21%" height=32 align="right" class="hback">网吧名称：</td>
      <td height=7 class="hback"><input name="WcafesName" type="text" id="WcafesName" size="40"></td>
    </tr>
    <tr>
      <td height=32 align="right" class="hback">起始IP：</td>
      <td height=7 class="hback"><input name="WcafesStartIP1" type="text" id="WcafesStartIP1" onKeyPress="onlyNum();" size="5" maxlength="3">
        .
        <input name="WcafesStartIP2" type="text" id="WcafesStartIP2" size="5" onKeyPress="onlyNum();" maxlength="3">
        .
        <input name="WcafesStartIP3" type="text" id="WcafesStartIP3" size="5" onKeyPress="onlyNum();" maxlength="3">
        .
        <input name="WcafesStartIP4" type="text" id="WcafesStartIP4" size="5" onKeyPress="onlyNum();" maxlength="3"></td>
    </tr>
    <tr>
      <td height=32 align="right" class="hback">结束IP：</td>
      <td height=7 class="hback"><input name="WcafesOverIP1" type="text" id="WcafesOverIP1" size="5" onKeyPress="onlyNum();" maxlength="3">
.
  <input name="WcafesOverIP2" type="text" id="WcafesOverIP2" size="5" onKeyPress="onlyNum();" maxlength="3">
.
<input name="WcafesOverIP3" type="text" id="WcafesOverIP3" size="5" onKeyPress="onlyNum();" maxlength="3">
.
<input name="WcafesOverIP4" type="text" id="WcafesOverIP4" size="5" onKeyPress="onlyNum();" maxlength="3"></td>
    </tr>
    <tr>
      <td height=32 align="right" class="hback">到期时间：</td>
      <td height=16 class="hback"><select name="WcafesUseDate">
        <option value="1">一天</option>
        <option value="7">一个星期</option>
        <option value="30">一个月</option>
        <option value="92">一个季度</option>
        <option value="184">半年</option>
        <option value="365">一年</option>
        <option value="730">两年</option>
        <option value="36500">永久</option>
      </select></td>
    </tr>
    <tr>
      <td height=32 align="right" class="hback">所属会员组：</td>
      <td height=16 class="hback"><%call UsersGroupselect("WcafesGroup",0)%></td>
    </tr>
    <!--<tr>
      <td height=32 align="right" class="hback">网吧管理密码：</td>
      <td height=16 class="hback"><input name="WcafesAdmin" type="text" id="WcafesAdmin" size="40">
    </td>
    </tr>-->
    <tr>
      <td height=32 align="right" class="hback">授权说明：</td>
      <td height=16 class="hback"><textarea name="WcafesNote" cols="40" rows="5" id="WcafesNote"></textarea></td>
    </tr>
    <tr>
      <td height=32 colspan="2" align="center" class="hback"><input type="submit" name="Submit" value="添 加"></td>
    </tr>
  </tbody>
</form>
</table>
<%end sub
sub Edit()%>
<table class=table cellspacing=1 cellpadding=3 width="98%" align=center border=0>
 <form name="form" action="Admin_Wcafes.asp?Action=EditSave" method="post" onSubmit="return WformIP();">
  <tbody>
    <tr>
      <td colspan="2" class=xingmu>网吧修改</td>
    </tr>
    <tr>
      <td width="21%" height=32 align="right" class="hback">网吧名称：</td>
      <td height=7 class="hback"><input name="WcafesName" type="text" id="WcafesName" value="<%=YWNT_TMS_WcafesName%>" size="40"></td>
    </tr>
    <tr>
      <td height=32 align="right" class="hback">起始IP：</td>
      <td height=7 class="hback"><input name="WcafesStartIP1" type="text" id="WcafesStartIP1" value="<%=YWNT_TMS_WcafesStartIP(0)%>" size="5" onKeyPress="onlyNum();" maxlength="3">
        .
        <input name="WcafesStartIP2" type="text" id="WcafesStartIP2" value="<%=YWNT_TMS_WcafesStartIP(1)%>" size="5" onKeyPress="onlyNum();" maxlength="3">
        .
        <input name="WcafesStartIP3" type="text" id="WcafesStartIP3" value="<%=YWNT_TMS_WcafesStartIP(2)%>" size="5" onKeyPress="onlyNum();" maxlength="3">
        .
        <input name="WcafesStartIP4" type="text" id="WcafesStartIP4" value="<%=YWNT_TMS_WcafesStartIP(3)%>" size="5" onKeyPress="onlyNum();" maxlength="3"></td>
    </tr>
    <tr>
      <td height=32 align="right" class="hback">结束IP：</td>
      <td height=7 class="hback"><input name="WcafesOverIP1" type="text" id="WcafesOverIP1" value="<%=YWNT_TMS_WcafesOverIP(0)%>" size="5" onKeyPress="onlyNum();" maxlength="3">
.
  <input name="WcafesOverIP2" type="text" id="WcafesOverIP2" value="<%=YWNT_TMS_WcafesOverIP(1)%>" size="5" onKeyPress="onlyNum();" maxlength="3">
.
<input name="WcafesOverIP3" type="text" id="WcafesOverIP3" value="<%=YWNT_TMS_WcafesOverIP(2)%>" size="5" onKeyPress="onlyNum();" maxlength="3">
.
<input name="WcafesOverIP4" type="text" id="WcafesOverIP4" value="<%=YWNT_TMS_WcafesOverIP(3)%>" size="5" onKeyPress="onlyNum();" maxlength="3"></td>
    </tr>
    <tr>
      <td height=32 align="right" class="hback">到期时间：</td>
      <td height=16 class="hback"><input name="WcafesUseDate" type="text" id="WcafesUseDate" value="<%=YWNT_TMS_WcafesUseDate%>" size="40">        </td>
    </tr>
    <tr>
      <td height=32 align="right" class="hback">所属会员组：</td>
      <td height=16 class="hback"><%call UsersGroupEditselect("WcafesGroup",YWNT_TMS_UsersGroup,0)%></td>
    </tr>
    <!--<tr>
      <td height=32 align="right" class="hback">网吧管理密码：</td>
      <td height=16 class="hback"><input name="WcafesAdmin" type="text" id="WcafesAdmin" value="<%=YWNT_TMS_WcafesAdmin%>" size="40">
    </td>
    </tr>-->
    <tr>
      <td height=32 align="right" class="hback">授权说明：</td>
      <td height=16 class="hback"><textarea name="WcafesNote" cols="40" rows="5" id="WcafesNote"><%=YWNT_TMS_WcafesNote%></textarea></td>
    </tr>
    <tr>
      <td height=32 colspan="2" align="center" class="hback"><input name="ID" type="hidden" value="<%=YWNT_TMS_ID%>"><input type="submit" name="Submit" value="修 改"></td>
    </tr>
  </tbody>
</form>
</table>
<%end sub
call connclose()%>
</BODY></HTML>
