using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace free.bbs
{
	/// <summary>
	/// Summary description for admin_lookhuiyuan.
	/// </summary>
	public class admin_lookhuiyuan : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid mydatagrid;
		SqlConnection monn;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			try
			{
				if(Session["free_quanxian"].ToString()!="0")
				{
					Response.Write("<script>alert('您无权使用！！')</script>");
					Response.Redirect("../admin/default.aspx");
				}
			}
			catch
			{
				Response.Write("<script>alert('您无权使用！！')</script>");
				Response.Redirect("../admin/default.aspx");
				
			}			bangding();
			// Put user code to initialize the page here
		}
		private void bangding()
		{
			monn=new SqlConnection(Session["str_connection"].ToString());
			DataSet mydata=new DataSet();
			string mysql="select yonghuming,xingbie,touxian,jifen,wenzhangshu,zhuceshijian,lastlogin,fatieshu from huiyuan";
			monn.Open();
			SqlDataAdapter mypeter=new SqlDataAdapter(mysql,monn);
			mypeter.Fill(mydata,"huiyuan");
			mydatagrid.DataSource=mydata.Tables["huiyuan"].DefaultView;
			mydatagrid.DataBind();
			monn.Close();
		}
		public void ChangePage(Object sender,DataGridPageChangedEventArgs e)
		{
			mydatagrid.CurrentPageIndex = e.NewPageIndex;
			bangding();
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}
