login.aspx.cs

通过对现在流行的各种销售管理软件的分析

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

namespace SellManageJane
{
	/// <summary>
	/// Login 的摘要说明。
	/// </summary>
	public class Login : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button btnSumbit;
		protected System.Web.UI.WebControls.TextBox txtUserName;
		protected System.Web.UI.WebControls.TextBox txtPwd;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.Button BtnExit;
		SqlConnection conn;
		SqlDataAdapter ada;
		DataSet ds;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			conn = new SqlConnection(ConfigurationSettings.AppSettings["connStr"].ToString());
			this.BtnExit.Attributes.Add("OnClick","JavaScript:window.close();");
		}

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

		}
		#endregion


		private void btnRegUser_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("RegUser.aspx");
		}

		private void btnSumbit_Click(object sender, System.EventArgs e)
		{
			ada = new SqlDataAdapter("select * from Admin where userName='"+ txtUserName.Text +"' and passWord='"+ txtPwd.Text +"'",conn);
			ds = new DataSet();
			ada.Fill(ds,"Admin");
			if(ds.Tables["Admin"].Rows.Count!=0)
			{
				Session["userName"] = this.txtUserName.Text;
				Session["password"] = this.txtPwd.Text;
				string type ="管理员";
				ada = new SqlDataAdapter("select * from Admin where userName='"+ txtUserName.Text +"' and passWord='"+ txtPwd.Text +"'and type = '"+ type +"' ",conn);
				ada.Fill(ds,"regAdmin");
				if(ds.Tables["regAdmin"].Rows.Count!=0)
				{
					RegisterStartupScript("msg","<script>alert('登录成功！');</script>");
					Response.Redirect("index.aspx");
				}
				else
				{
					RegisterStartupScript("msg","<script>alert('登录成功！');</script>");
					Response.Redirect("index1.aspx");
				}
			}
			else
			{
				RegisterStartupScript("msg","<script>alert('您还没注册，请先注册！');</script>");
			}
		}
	}
}