classinfolistform.cs

一个不错的文档

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();
        }
    }
}