admin_login.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

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;
using System.Configuration;

namespace WebNews.admin
{
	public partial class admin_login : System.Web.UI.Page
	{
		protected SqlConnection SqlConnection1;		//添加数据库的操作对象
		protected SqlCommand SqlCommand1;
		protected SqlDataReader SqlDataReader1;		

	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				Session["userclass"]="";
				Session["pwd"]=""	  ;
				Session["classname"]="";
				Session["username"]="";
			}
		}		
		
		#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()
		{    

		}
		#endregion

		protected void Submit_Click(object sender, System.EventArgs e)
		{
			if (Page.IsValid) 
			{				
		　　	Session["username"]=Username.Text; 
				//验证用户密码
				SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);//取连接字符串,并建立连接
				SqlCommand1=new SqlCommand("sp_selAdmin",SqlConnection1); 
				SqlCommand1.CommandType=CommandType.StoredProcedure;
				SqlCommand1.Parameters.Add(new SqlParameter("@username", SqlDbType.Char,240));
				SqlCommand1.Parameters["@username"].Value =Username.Text;   //用户名
				SqlCommand1.Parameters.Add(new SqlParameter("@password", SqlDbType.NChar,240));
				SqlCommand1.Parameters["@password"].Value =Password.Text;   //用户名
				try
				{
					SqlConnection1.Open();
					SqlDataReader1=SqlCommand1.ExecuteReader();										
				}
				catch (SqlException e1)
				{
					Label1.Text ="数据库操作错误："+e1.Message;
				}
				if(SqlDataReader1.Read()==true)   //如果改变了用户名,就要检查是否与已有的记录相同
				{
					Session["userclass"]=SqlDataReader1["userclass"];					 
					Session["pwd"]=SqlDataReader1["password"];
					Session["classname"]=SqlDataReader1["classname"];
					Session["popedom"]=SqlDataReader1["popedom"];					
					Session["id"]=SqlDataReader1["id"];
					Session["power"]=SqlDataReader1["popedom"];  
					string	popedom=SqlDataReader1["popedom"].ToString();  
					int i=popedom.Length;
					if(popedom.IndexOf("addnews",0,i)>=0)	//验证是否有增加新闻的功能
					{
						Session["addnews"]=1;
					}
					else  Session["addnews"]=0;
					if(popedom.IndexOf("addnchk",0,i)>=0)	//验证是否有增加新闻不需审核功能的权限
					{
						Session["addnchk"]=1;
					}
					else  Session["addnchk"]=0;
					if(popedom.IndexOf("chgnews",0,i)>=0)	//验证是否有修改新闻的权限
					{
						Session["chgnews"]=1;
					}
					else  Session["chgnews"]=0;
					if(popedom.IndexOf("chknews",0,i)>=0)	//验证是否有审核新闻的权限
					{
						Session["chknews"]=1;
					}
					else  Session["chknews"]=0;
					if(popedom.IndexOf("remark",0,i)>=0)	//验证是否有管理评论的权限
					{
						Session["remark"]=1;
					}
					else  Session["remark"]=0;
			
					SqlConnection1.Close();
					Response.Redirect("admin_main.htm");	//转向admin_main.htm
				}
				else
				{
					SqlDataReader1.Close();
					SqlConnection1.Close();
					Label2.Text="用户名或密码错误";
				}
			}
		}
	}
}