?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Configuration;
using System.Data.OleDb;
using System.IO;


namespace 學(xué)籍管理系統(tǒng)
{
    public partial class login :DevComponents .DotNetBar .Office2007Form 
    {
        public login()
        {
            InitializeComponent();
        }

        private void login_Load(object sender, EventArgs e)
        {
           
        }

        private void buttonX2_Click(object sender, EventArgs e)
        {

            string cn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\xjgl.mdb" + ";Persist Security Info=True";
            OleDbConnection cnn = new OleDbConnection(cn);

            if (comboBox1.Text == "教務(wù)主任")
            {
                string mycom = " select *from Users where User_id=" + "'" + textBoxX2.Text.Trim() + "'";
                OleDbCommand com = new OleDbCommand(mycom, cnn);
                try
                {
                    cnn.Open();
                    com.ExecuteNonQuery();
                    OleDbDataReader dr = com.ExecuteReader();
                    if (dr.Read())
                    {
                        if (dr["User_password"].ToString().Trim() == textBoxX3.Text.Trim())
                        {
                            string userss = dr["User_name"].ToString();

                            this.Hide();
                            Main mm = new Main();
                            mm.user = userss;
                            mm.usertype = comboBox1.Text;
                            mm.Show();
                            string myss = System.DateTime.Now.ToLongDateString() + "  " + System.DateTime.Now.ToLongTimeString() + "  " + userss + "    登陸";
                            info(myss);　　　　　　　　　　// 信息寫入
                            cnn.Close();
                        }
                        else
                            MessageBox.Show("密碼錯(cuò)誤！");
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("用戶錯(cuò)誤！");
                }
            }
            else if (comboBox1.Text == "教師")
            {
                string mycom = "select *from Teacher where Tea_id=" + "'" + textBoxX2.Text.Trim() + "'";
                OleDbCommand com = new OleDbCommand(mycom, cnn);
                try
                {
                    cnn.Open();
                    com.ExecuteNonQuery();
                    OleDbDataReader dr = com.ExecuteReader();
                    if (dr.Read())
                    {
                        if (dr["Tea_password"].ToString().Trim() == textBoxX3.Text.Trim())
                        {
                            string userss = dr["Tea_name"].ToString();
                            this.Hide();
                            Main mm = new Main();
                            mm.user = userss;
                            mm.usertype = comboBox1.Text;
                            mm.Show();
                            cnn.Close();
                        }
                        else
                            MessageBox.Show("密碼錯(cuò)誤！");
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("用戶錯(cuò)誤！");
                }

            }
        }

        private void info(string infos)
        {
            string paths = Directory.GetCurrentDirectory() + "\\log.txt";
            StreamWriter sw = new StreamWriter(paths, true, Encoding.Default);
            sw.WriteLine(infos);
            sw.Close();
        }
        private void buttonX1_Click(object sender, EventArgs e)

        {
            Application.ExitThread(); 
        }

        private void labelX2_Click(object sender, EventArgs e)
        {

        }

        private void panel2_Paint(object sender, PaintEventArgs e)
        {

        }

        
    }
}