<%@ Page CodeBehind="006.aspx.cs" Language="c#" AutoEventWireup="false" Inherits="yn165.admin._006" %>
<%@ Import Namespace="System.Data.SqlClient"%>
<%@ Import Namespace="System.Data"%>
<HTML>
	<HEAD>
		<TITLE>创库网络(昆明)后台管理系统</TITLE>
		<% if (Session["admin_yn165"]==null || Session["admin_yn165"]==""){
		Response.Redirect("../index.aspx");
		}
		%>
		<META content="text/html; charset=gb2312" http-equiv="Content-Type">
		<META content="no-cache" http-equiv="Pragma">
		<STYLE type="text/css">INPUT { FONT-FAMILY: "宋体"; FONT-SIZE: 9pt ; text-decoration: none}
	.big { FONT-FAMILY: "宋体"; FONT-SIZE: 10.5pt; TEXT-DECORATION: none }
	A:hover { COLOR: #ff6666; FONT-FAMILY: "宋体"; TEXT-DECORATION: none }
	A { FONT-FAMILY: "宋体"; TEXT-DECORATION: none}
	TD { FONT-FAMILY: "宋体", "Arial", "Times New Roman"; FONT-SIZE: 9pt ; text-decoration: none}
	.big2 { FONT-FAMILY: "宋体"; FONT-SIZE: 10.5pt; LINE-HEIGHT: 13pt ; text-decoration: none}
	.unnamed1 { font-size: 7pt; text-decoration: none}
	.unnamed2 { font-size: 12pt; text-decoration: none}
	</STYLE>
		<!--web design:zheng guiwen E-mail:guiwen@zheng.com.cn -->
		<META content="Microsoft FrontPage 4.0" name="GENERATOR">
		<base target="bottom">
		<script language="JavaScript">
<!--
function delete_confirm(e){
	event.returnValue=confirm("确认删除?");
}

//-->
		</script>
	</HEAD>
	<BODY aLink="#000000" bgColor="#f0f0f0" link="#000000" text="#000000" vLink="#990000" leftmargin="0" topmargin="10" marginwidth="0" marginheight="0" onLoad="">
		<table width="100%" border="0" cellspacing="3" cellpadding="3">
			<tr>
				<td>
					<div align="center" class="unnamed2"><font color="#ff3300">查看代理申请</font></div>
				</td>
			</tr>
		</table>
		<table width="98%" border="0" cellspacing="1" cellpadding="4" align="center" bgcolor="#cccccc">
			<tr align="middle" bgcolor="#f0f0f0">
				
    <td width="14%">申请时间</td>
				
    <td width="13%">会员帐号</td>
				
    <td width="14%">真实姓名</td>
				
    <td width="23%">电子邮件</td>
				
    <td width="9%">申请等级</td>
				
    <td width="27%">管 理 员 操 作</td>
			</tr>
			<%
SqlConnection conn = new SqlConnection("server=211.155.254.117;database=yn165;uid=yn165;pwd=159753");
conn.Open();
string sql = "select * from agent order by agency_level DESC";
SqlCommand cmd = new SqlCommand(sql,conn);
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
%>
			<tr align="middle" bgcolor="#ffffff">
				
    <td width="14%"><%=reader.GetValue(13)%></td>
				
    <td width="13%"><%=reader.GetValue(1)%></td>
				
    <td width="14%"><%=reader.GetValue(3)%></td>
				
    <td width="23%"><%=reader.GetValue(8)%></td>
				
    <td width="9%"><%=reader.GetValue(2)%></td>
				
    <td width="27%">
    <a href=ad_viewagent.aspx?id=<%=reader.GetValue(0)%> target=_self >查看详细信息</a> | 
    <a href=ad_delagent.aspx?id=<%=reader.GetValue(0)%> target=_self onclick="delete_confirm(this)">删除</a> 
      | <a href=ad_viewuser.aspx?account=<%=reader.GetValue(1)%> target=_self > 
      查看其会员信息</a></td>
			</tr>
			<% } 
			   reader.Close();
			   cmd.Dispose();
			   conn.Close();
			%>
		</table>
		<table width="98%" border="0" cellspacing="3" cellpadding="3" align="center">
			<tr>
				<td width="98%" align="right">首页 | 上一页 | 下一页 | 尾页</td>
				<td width="2%">&nbsp;</td>
			</tr>
		</table>
	</BODY>
</HTML>
