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

namespace 學籍管理系統
{
    public partial class user : DevComponents .DotNetBar .Office2007Form 
    {
        public user()
        {
            InitializeComponent();
        }

        private void panelEx2_Click(object sender, EventArgs e)
        {

        }
        //通用檢索函數
        private void constring(string command,string name)
        {
            string cn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\xjgl.mdb" + ";Persist Security Info=True";
            OleDbConnection cnn = new OleDbConnection(cn);
            string updatas = command;
            OleDbCommand com = new OleDbCommand(updatas, cnn);
            try
            {

                cnn.Open();
                com.ExecuteNonQuery();
                cnn.Close();

                if (name == "Tea")
                {
                    TeaData();
                }
                else if (name == "Admin")
                {
                    AdminData();
                }
                cls();
            }
            catch (Exception)
            {
                MessageBox.Show("輸入的不正確！");
            }
            finally
            {
                cnn.Close();
            }
        }
        private DataTable dt;
        private OleDbDataAdapter da;
        private void AdminData()
        {
           
            string cn = "provider=Microsoft.jet.oledb.4.0;data source=" + Application.StartupPath + "\\xjgl.mdb" + ";persist security info=true";
            OleDbConnection cnn = new OleDbConnection(cn);
            string sel = "select User_id as 用戶ID,User_name as 姓名,User_password as 密碼 from Users";
            OleDbCommand com = new OleDbCommand(sel, cnn);
            da = new OleDbDataAdapter();
            dt=new DataTable ();
            da.SelectCommand = com;
            da.Fill(dt);
            dataGridView1.DataSource = dt;
        }
 
        private void TeaData()
        {
           
            string cn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\xjgl.mdb" + ";Persist Security Info=True";
            OleDbConnection cnn = new OleDbConnection(cn);
            string sel = "select Tea_id as 教師ID,Tea_name as 姓名,Tea_password as 密碼 from Teacher";
            OleDbCommand com = new OleDbCommand(sel, cnn);
            da = new OleDbDataAdapter();
            dt = new DataTable();
            da.SelectCommand = com;
            da.Fill(dt);
            dataGridView1.DataSource = dt;

        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBox1.Checked == true)
            {
                mm.Text = "111";
            }
            else
            {
                mm.Text = "";
            }
        }
        private void cls()
        {
            yh.Text = "";
            yhid.Text = "";
            mm.Text = "";
            checkBox1.Checked = false;

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

        }

        private void user_Load(object sender, EventArgs e)
        {

        }

        private void button2_Click(object sender, EventArgs e)
        {
            TeaData();
            yhlx.Text = "教師";
            cls();
        }

        private void buttonItem4_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            AdminData();
            yhlx.Text = "管理員";
            cls();
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            yhid.Text = dt.Rows[e.RowIndex][0].ToString();
            yh.Text = dt.Rows[e.RowIndex][1].ToString();
            mm.Text = dt.Rows[e.RowIndex][2].ToString();
        }

        private void buttonItem1_Click(object sender, EventArgs e)
        {
          
            if (yhlx.Text == "教師")
            {
                string inserts = "insert into Teacher Values('" + yhid.Text.Trim() + "','" + yh.Text.Trim() + "','" + mm.Text.Trim() + "')";
                constring(inserts, "Tea");
            }
            else if (yhlx.Text == "管理員")
            {
                string inserts = "insert into Users values('" + yhid.Text.Trim() + "','" + yh.Text.Trim() + "','" + mm.Text.Trim() + "')";
                constring(inserts, "Admin"); ;
            }
        }

        private void buttonItem2_Click(object sender, EventArgs e)
        {
        
            if (yhlx.Text == "教師")
            {
                string updates = "update Teacher set Tea_name='" + yh.Text.Trim() + "',Tea_password='" + mm.Text.Trim() + "'where Tea_id='" + yhid.Text.Trim() + "'";
                constring(updates, "Tea");
            }
            else if (yhlx.Text == "管理員")
            {
                string updates = "update Users set User_name='" + yh.Text.Trim() + "',User_password='" + mm.Text.Trim() + "' where User_id='" + yhid.Text.Trim() + "'";
                constring(updates, "Admin");
            }
        }

        private void buttonItem3_Click(object sender, EventArgs e)
        {
          
            if (yhlx.Text == "教師")
            {
                string deletes = "delete from Teacher where Tea_id='" + yhid.Text.Trim() + "'";
                constring(deletes, "Tea");
            }
            else if (yhlx.Text == "管理員")
            {
                string deletes = "delete from Users where User_id='" + yhid.Text.Trim() + "'";
                constring(deletes, "Admin");
            }
        }
    }
}