?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.SqlClient;
using System.Collections;

using MySchoolPrj.Entity;
using MySchoolPrj.DAO;

namespace SchoolManageprj
{
    public partial class ClassInfoListForm : Form
    {
        public ClassInfoListForm()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 設置查詢條件       
        /// </summary>
        public void setCMB()
        {
            //設置查找類型
            cmbFirstInfo.Items.AddRange(new string[] { "全部查找","按班主任查找"});
            //設置默認選項
            cmbFirstInfo.SelectedIndex = 0;
            //下拉框風格
            cmbFirstInfo.DropDownStyle = ComboBoxStyle.DropDownList;
            //數據可連接
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.Text;
            cmd.Connection = DBHelper.con;
            string sql = "select * from teacher";
            cmd.CommandText = sql;
            DBHelper.con.Open();
            SqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                string str = reader["teacherName"].ToString();
                cmbScondInfo.Items.Add(str);
            }
            
            reader.Close();
            DBHelper.con.Close();
            
            if(cmbScondInfo.Items.Count>0)
            cmbScondInfo.SelectedIndex = 0;
            cmbScondInfo.DropDownStyle = ComboBoxStyle.DropDownList;
            cmbScondInfo.Visible = false;
        }
        //設置Datagridview顯示
        public void setShowClassInfo()
        {
            //數據庫連接
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.Text;
            cmd.Connection = DBHelper.con;
            string sql = "select a.*,b.teacherName from classInfo a,teacher b where a.teacherid=b.teacherid";
            cmd.CommandText = sql;
            DBHelper.con.Open();
            SqlDataAdapter dat = new SqlDataAdapter();
            dat.SelectCommand = cmd;
            DataTable dt = new DataTable();
            dat.Fill(dt);
            DBHelper.con.Close();
            dgvClassInfo.DataSource = dt;
            //設置Datagridview的列頭屬性
            for (int i = 0; i < dgvClassInfo.Columns.Count; i++)
            {
                switch (dgvClassInfo.Columns[i].HeaderText)
                {
                    case "classId":
                        dgvClassInfo.Columns[i].HeaderText = "班級";
                        dgvClassInfo.Columns[i].Width = dgvClassInfo.Width / 6;
                        break;
                    case "teacherName":
                        dgvClassInfo.Columns[i].HeaderText = "教師";
                        dgvClassInfo.Columns[i].Width = dgvClassInfo.Width / 6;
                        break;
                    case "startDate":
                        dgvClassInfo.Columns[i].HeaderText="開班時間";
                        dgvClassInfo.Columns[i].Width = dgvClassInfo.Width / 6;
                        break;
                    case "studentCount":
                        dgvClassInfo.Columns[i].HeaderText = "學生人數";
                        dgvClassInfo.Columns[i].Width = dgvClassInfo.Width / 6;
                        break;
                    case "endDate":
                        dgvClassInfo.Columns[i].HeaderText = "結束時間";
                        dgvClassInfo.Columns[i].Width = dgvClassInfo.Width / 6;
                        break;
                    case "Memo":
                        dgvClassInfo.Columns[i].HeaderText = "備注";
                        dgvClassInfo.Columns[i].Width = dgvClassInfo.Width / 6;
                        break;
                    case "teacherId":
                        dgvClassInfo.Columns[i].Visible = false;
                        break;                       
                }
            }
        }
        //設置界面初始化信息
        private void ClassInfofrm_Load(object sender, EventArgs e)
        {
            setCMB();
            //整行選擇
            dgvClassInfo.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            //設置選項為只讀
            dgvClassInfo.ReadOnly = true;
            //不允許用戶增加新信息
            dgvClassInfo.AllowUserToAddRows = false;
            //隱藏列頭信息
            dgvClassInfo.RowHeadersVisible = false;
            //只能執行單項選擇
            dgvClassInfo.MultiSelect = false;
            setShowClassInfo();
            
        }
        //設置選擇類型下拉框
        private void cmbFirstInfo_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cmbFirstInfo.SelectedIndex == 0)
                cmbScondInfo.Visible = false;
            else
                cmbScondInfo.Visible = true;
        }
        //增加班級信息
        private void btnAddClassInfo_Click(object sender, EventArgs e)
        {
            ClassEditFrm cef = new ClassEditFrm();
            cef.State = State.dsAdd;
            cef.ShowDialog();            
            setShowClassInfo();
            if (dgvClassInfo.Rows.Count > 1)
            {
                int curRow = dgvClassInfo.CurrentRow.Index;
                dgvClassInfo.Rows[curRow].Selected = true;
            }
        }
        //關閉窗體
        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        //獲取選中行數據        
        public void getCurRowDate()
        {
            
            ClassInfos cif = new ClassInfos();
            DataTable dt = (DataTable)dgvClassInfo.DataSource;
            //判斷是否又選中項
            if (dgvClassInfo.Rows.Count > 0)
            {
                btnUpdataClassInfo.Enabled = true;
                int cur = dgvClassInfo.CurrentRow.Index;
                cif.ClassId = dt.Rows[cur]["classId"].ToString();
                cif.TeacherName = (string)dt.Rows[cur]["teacherName"];
                cif.StarDate = (string)dt.Rows[cur]["startDate"];
                cif.ClassCount = (int)dt.Rows[cur]["studentCount"];
                cif.EndDate = (string)dt.Rows[cur]["endDate"];
                cif.Meno = dt.Rows[cur]["Memo"].ToString();
                ClassEditFrm cef = new ClassEditFrm();
                cef.State = State.dsUpdate;
                cef.Cif = cif;
                cef.ShowDialog();
            }
            else {
                MessageBox.Show("沒有班級不能修改");
                btnUpdataClassInfo.Enabled = false;
            }
        }
        //修改班級信息
        private void btnUpdataClassInfo_Click(object sender, EventArgs e)
        {
            getCurRowDate();
            setShowClassInfo();
        }
        //獲取教師號
        public string getTeacherId()
        {
            string teacherid;
            //數據庫連接
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.Text;
            cmd.Connection = DBHelper.con;
            string sql = "select teacherId from teacher where teacherName='" + cmbScondInfo.SelectedItem.ToString() + "'";
            cmd.CommandText = sql;
            DBHelper.con.Open();
            teacherid = (string)cmd.ExecuteScalar();
            DBHelper.con.Close();
            return teacherid;
        }
        //按條件查詢
        public void setSearch()
        {
            //數據庫連接
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.Text;
            cmd.Connection = DBHelper.con;
            string sql = "select a.*,b.teacherName from classInfo a,teacher b where a.teacherid=b.teacherid ";
            if (cmbFirstInfo.SelectedIndex == 1) {
                sql+=" and a.teacherId='"+getTeacherId()+"'";
            }
            cmd.CommandText = sql;
            DBHelper.con.Open();
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable dt = new DataTable();
            da.Fill(dt);
            dgvClassInfo.DataSource = dt;
            DBHelper.con.Close();
        }
        //查詢信息
        private void btnSearchClassIfo_Click(object sender, EventArgs e)
        {
            setSearch();
        }
        
        private void tsmiUpdate_Click(object sender, EventArgs e)
        {
            getCurRowDate();
            setShowClassInfo();
        }
    }
}