?using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
//該源碼下載自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

public partial class _Default : System.Web.UI.Page 
{
     #region Web 窗體設計器生成的代碼
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// 設計器支持所需的方法 - 不要使用代碼編輯器修改
        /// 此方法的內容。
        /// </summary>
        private void InitializeComponent()
        {
            


        }
        #endregion
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Btn_Login_Click(object sender, EventArgs e)
    {

        if (TxtUser.Text.Trim() == "")
        {
            Response.Write("<script>alert('登錄名不能為空')</script>");
            return;
        }
        user userLogin = new user();
        bool isok = false;
       
        if (rb_admin.Checked)
        {     
            string sql = "select * from Tb_User_Login where isnull(userName,'')='" + TxtUser.Text.Trim() + "' and isnull(userPass,'')='" + TxtPwd.Text.Trim() + "'and isnull(userRole,'')='" + rb_admin.Text+ "'";
            SqlDataReader myReader = userLogin.Login(sql);
            if (myReader.Read())
            {
                Session["Name"] = myReader["userName"].ToString().Trim();//保存用戶名稱
                Session["Pass"] = myReader["userPass"].ToString().Trim();//保存用戶密碼
                Session["Role"] = myReader["userRole"].ToString().Trim();//保存用戶權限.		
                isok = true;
            }
            myReader.Close();
        }
       else
        { 
            string sql = "select * from Tb_User_Login where isnull(userName,'')='" + TxtUser.Text.Trim() + "' and isnull(userPass,'')='" + TxtPwd.Text.Trim() + "'and isnull(userRole,'')='" + rb_user.Text+ "'";
            SqlDataReader myReader = userLogin.Login(sql);
            if (myReader.Read())
            {
                Session["Name"] = myReader["userName"].ToString().Trim();//保存用戶名稱
                Session["Pass"] = myReader["userPass"].ToString().Trim();//保存用戶密碼
                Session["Role"] = myReader["userRole"].ToString().Trim();//保存用戶權限.		
                isok = true;
            }     
            myReader.Close();
        }



           if (!isok)
         {
             lbMessage.Text = "用戶名稱或密碼錯誤，登陸失敗!";
              return;
         }
           else
           {
             Response.Redirect("Index.aspx");
          }
    }
    protected void Btn_Cancel_Click(object sender, EventArgs e)
    {
        TxtUser.Text = "";
        TxtPwd.Text = "";
        lbMessage.Text = "";
    }
    
}