wfrmlogeinpage.aspx.cs

来自「Teacher Manager System」· CS 代码 · 共 71 行

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

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
            Session["DbManager"] = "Data Source=CR1-A20;Initial Catalog=TMBank;Integrated Security=True";
    }

    public void DBManager(string p_strConStr)
    {
        SqlConnection l_conn = new SqlConnection();
        l_conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\" + p_strConStr + "\\Documents and Settings\\Administrator\\桌面\\TeachManagDB.mdb";

        l_conn.Open();
        string l_str = "Select * From Teacher";
        SqlCommand l_cmd = new SqlCommand();
        l_cmd.Connection = l_conn;
        l_cmd.CommandText = l_str;
        //Label1.Text = "到底是行不行,你看起來很困難捏";
        l_conn.Close();

    }
    protected void btnTestLinkDb_Click(object sender, EventArgs e)
    {
        //string l_str = txtDbServerLink.Text.ToString();
        //DBManager(l_str);
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        CCFacade l_facade = new CCFacade();
        CUser l_login = l_facade.getLoginFactory(Session["DbManager"].ToString()).getByUSERNAME(txtId.Text);
        if (l_login == null)
        {
            Response.Write("<script>alert('無此帳號');</script>");
        }
        else if (!l_login.PASSWORD.Equals(txtPasswd.Text))
        {
            Response.Write("<script>alert('帳號密碼輸入錯誤');</script>");
        }
        else
        {
            l_facade.目前使用者 = l_login;
            Session["User"] = l_facade;
            Response.Redirect("WfrmCoursePage.aspx");

        }
    }
   
    protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
    {
        String l_connectionString = @"Data Source=" + DropDownList1.SelectedValue + ";Initial Catalog=TMBank;USER ID=sa;Password=1111";

        Session["DbManager"] = l_connectionString;


    }
}