admin.aspx.cs

来自「Haokoo.net免费域名系统 (C#+VS.net版)软件介绍： 在此系统中」· CS 代码 · 共 249 行

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

namespace Haokoo.domain
{
	/// <summary>
	/// admin 的摘要说明。
	/// </summary>
	public class admin : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Message;
		protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RF_Domain;
		protected System.Web.UI.WebControls.RequiredFieldValidator RF_Pwd;
		protected System.Web.UI.WebControls.TextBox txtKeyword;
		protected System.Web.UI.WebControls.Button btSearch;
		protected System.Web.UI.WebControls.DataList MyDomainList;
		protected System.Web.UI.WebControls.Label lbl_currentPage;
		protected System.Web.UI.WebControls.Label lbl_totalPage;
		protected System.Web.UI.WebControls.Label lbl_totalRecordset;
		protected System.Web.UI.WebControls.LinkButton lb_frist;
		protected System.Web.UI.WebControls.LinkButton lb_prev;
		protected System.Web.UI.WebControls.LinkButton lb_next;
		protected System.Web.UI.WebControls.LinkButton lb_last;
		protected System.Web.UI.WebControls.TextBox toPageValue;
		protected System.Web.UI.WebControls.Button cmd_goto;
		protected System.Web.UI.WebControls.Panel MyPanel;
		protected System.Web.UI.HtmlControls.HtmlGenericControl MyTitle;
		protected System.Web.UI.HtmlControls.HtmlTable tabLogin;
		protected System.Web.UI.HtmlControls.HtmlInputText txtUser;
		protected System.Web.UI.HtmlControls.HtmlInputText txtPwd;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
	

		SqlConnection Myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
		int PageSize,CurrentPage,TotalRows,TotalPages;
		public string Keyword;

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if((string)Session["admin_user"]=="" || (string)Session["admin_pass"]=="" || Session["admin_user"]==null || Session["admin_pass"]==null)
			{
				tabLogin.Visible=true;
				MyPanel.Visible=false;
				MyTitle.InnerHtml="管理员登录";
			}
			else
			{
				tabLogin.Visible=false;
				MyPanel.Visible=true;
				MyTitle.InnerHtml="Haokoo.net免费域名系统后台管理";
				Message.Text="";
			}
				
			Keyword=txtKeyword.Text;
			PageSize=20; //设置每页显示记录数
			TotalRows=MyTotalRows();//'总记录数
			TotalPages=MyTotalPages();// '总页数
	
			if(!IsPostBack)
			{	
				CurrentPage=0;
				ReBind();
			}	
		}

		private void ReBind()
		{
			int StartIndex;			
			StartIndex=CurrentPage*PageSize;
	
			string SqlStr="select d.*,t.typeName from Domain_main d,Domain_type t where d.typename=t.id";
			if (Keyword!="" && Keyword!=null) SqlStr +=" And d.MyDomain like '%" + Keyword + "%'";
			SqlStr +=" order by regdate desc";
		
			SqlDataAdapter Mycommand=new SqlDataAdapter(SqlStr,Myconn);
			DataSet ds= new DataSet();
			Mycommand.Fill(ds,StartIndex,PageSize,"domain_main");

			MyDomainList.DataSource=ds.Tables["domain_main"].DefaultView;
			MyDomainList.DataBind();
			ViewState["Current_Page"]=CurrentPage;
			ShowBar();
		}
				
		private void ShowBar()
		{
			lbl_currentPage.Text=(CurrentPage+1).ToString();
			lbl_totalPage.Text=TotalPages.ToString();
			lbl_totalRecordset.Text=TotalRows.ToString();
			toPageValue.Text=lbl_currentPage.Text;
	
			if (CurrentPage==0)
			{
				lb_frist.Enabled =false;
				lb_prev.Enabled =false;
				lb_next.Enabled  =true;
				lb_last.Enabled =true;
			}
			else if(CurrentPage==TotalPages-1)
			{
				lb_frist.Enabled =true;
				lb_prev.Enabled =true;
				lb_next.Enabled =false;
				lb_last.Enabled =false;
			}
			else
			{
				lb_frist.Enabled =true;	
				lb_prev.Enabled =true;
				lb_next.Enabled =true;
				lb_last.Enabled =true;
			}
	
			if (TotalPages<=1)
			{
				lb_frist.Enabled =false;
				lb_prev.Enabled =false;
				lb_next.Enabled =false;
				lb_last.Enabled =false;
			}
		}

		private int MyTotalRows()
		{
			string SqlStr="select count(*) from Domain_Main";
			if (Keyword!="" && Keyword!=null) SqlStr +=" Where MyDomain like '%" + Keyword + "%'";

			SqlCommand MyCommand=new SqlCommand(SqlStr,Myconn);
			Myconn.Open();
			int _TotalRows=(int)MyCommand.ExecuteScalar();
			Myconn.Close();

			return _TotalRows;
		}

		private int MyTotalPages()
		{
			if((TotalRows % PageSize)==0)			
				return TotalRows/PageSize;
			else
				return ((TotalRows/PageSize)+1);
			
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);			
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Page_OnClick(object sender,CommandEventArgs e)
		{
			CurrentPage=(int)ViewState["Current_Page"];
			string cmd=e.CommandName;

			switch(cmd)
			{
				case "Next": 
					if (CurrentPage<(TotalPages-1)) CurrentPage+=1;
					break;
				case "Prev": 
					if (CurrentPage>0) CurrentPage-=1;
					break;
				case "Frist":
   					CurrentPage=0;
					break;
				case "Last":
   					CurrentPage=TotalPages-1;
					break;
				case "Goto":
   					string toPage;
					toPage=toPageValue.Text;
					if (toPage!="" && toPage!=null && TotalPages>0)
					{
						CurrentPage=Int32.Parse(toPage)-1;
						if (CurrentPage<0)
							CurrentPage=0;
						else if(CurrentPage>(TotalPages-1))
						{
							CurrentPage=TotalPages-1;
						}
					}
					break;
				case "Search":
					CurrentPage=0;
					break;
			}
			ReBind();

		}

		private void Submit1_ServerClick(object sender, System.EventArgs e)
		{
			string Admin_user=txtUser.Value;
			string Admin_pwd=txtPwd.Value;
			if (Admin_user==ConfigurationSettings.AppSettings["admin_user"])
			{
				if(Admin_pwd==ConfigurationSettings.AppSettings["admin_pwd"])
				{
					Session["admin_user"]=Admin_user;
					Session["admin_pass"]=Admin_pwd;
					MyTitle.InnerHtml="Haokoo.net免费域名系统后台管理";
					Response.Redirect("admin.aspx");
				}
				else
				{		
					Message.Text="登录失败，您的密码错误！";
					Session["admin_user"]="";
					Session["admin_pass"]="";
				}
			}
			else
			{	
				Message.Text="非法登录，您没有管理员权限！";
				Session["admin_user"]="";
				Session["admin_pass"]="";
			}
		}
	}
}