weihudepartmen.cs

程序设计语言上机考试系统

        }
        #endregion

        
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            for (int i = 0; i < dataGridView1.Rows.Count; i++)
                dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.White;
            dataGridView1.CurrentRow.DefaultCellStyle.BackColor = Color.LightSlateGray;
            dataGridView1.CurrentRow.Selected = true;
        }

        private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            for (int i = 0; i < dataGridView2.Rows.Count; i++)
                dataGridView2.Rows[i].DefaultCellStyle.BackColor = Color.White;
            dataGridView2.CurrentRow.DefaultCellStyle.BackColor = Color.LightSlateGray;
            dataGridView2.CurrentRow.Selected = true;
        }

        private void dataGridView3_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            for (int i = 0; i < dataGridView3.Rows.Count; i++)
                dataGridView3.Rows[i].DefaultCellStyle.BackColor = Color.White;
            dataGridView3.CurrentRow.DefaultCellStyle.BackColor = Color.LightSlateGray;
            dataGridView3.CurrentRow.Selected = true;
        }
        #region 显示所有信息
        /// <summary>
        /// 显示所有信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSearch_Click(object sender, EventArgs e)
        {
            DataSet myds = boperate.getds("select department as 院系名称 ,profession as 专业 from profession ", M_str_table1);
            dataGridView2.DataSource = myds.Tables[0];
            if (myds.Tables[0].Rows.Count > 0)
                btnpDelete.Enabled = true;
            else
                btnpDelete.Enabled = false;
        }
        #endregion

        #region 关闭
        private void btnQuit_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        #endregion

        #region 删除班级信息
        /// <summary>
        /// 删除班级信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnCDelete_Click(object sender, EventArgs e)
        {
            string classname = Convert.ToString(dataGridView3[1, dataGridView3.CurrentCell.RowIndex].Value).Trim();
            try
            {
                DataSet myds = boperate.getds("select * from student where class = '" + classname + "'", "student");
                if (myds.Tables[0].Rows.Count > 0)
                {
                    MessageBox.Show("该班级中已存在学生信息，不允许清除。如果要清除班级信息，请先清除相应班的学生信息");
                }
                else
                {
                    if (MessageBox.Show("确定要删除选中的班级吗?", "删除确定", MessageBoxButtons.YesNo) == DialogResult.Yes)
                    {
                        boperate.getcom("delete from class where class = '" + classname + "'");
                        MessageBox.Show("删除数据成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
            }
            combCprofession_SelectedIndexChanged(sender, e);
        }
        #endregion

        #region 添加班级信息
        /// <summary>
        /// 添加班级信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnCAdd_Click(object sender, EventArgs e)
        {
            str = richClass.Text.Trim().Replace("''", "'");
            string[] str1 = boperate.Split(str,"，");
            if (cn.State == ConnectionState.Closed)
                cn.Open();
            for (int i = 0; i < str1.Length; i++)
            {
                SqlCommand cmd = new SqlCommand("select * from class where class = '" + str1[i].ToString().Trim() + "'", cn);
                if (null != cmd.ExecuteScalar())
                    MessageBox.Show("表中已存在该班级", "提示");
                else
                {
                    if (str1[i] != "")
                    {
                        sql = "insert into class(Profession,class)values('" + combCprofession.Text.Trim() + "','" + str1[i].ToString().Trim() + "')";
                        boperate.getcom(sql);
                    }
                }
            }
            MessageBox.Show("班级信息添加成功", "提示");
            combCprofession_SelectedIndexChanged( sender,  e);
            richClass.Clear();
            if (cn.State == ConnectionState.Open)
                cn.Close();
        }
        #endregion
        #region 班级标签中选择院系
        /// <summary>
        /// 选择院系
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void comCDepartment_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (comCDepartment.Text.Trim() != "")
            {
                opAndvalidate.cboxBind("select department,Profession from Profession where department = '" + comCDepartment.Text.Trim() + "'", "Profession", "Profession", combCprofession);
            }
        }
        #endregion

        #region 班级标签中选择专业
        /// <summary>
        /// 选择专业
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void combCprofession_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (combCprofession.Text.Trim() != "")
            {
                DataSet myds = boperate.getds("select Profession as 专业 , class as 班级 from class where profession ='" + combCprofession.Text.ToString().Trim() + "'", M_str_table2);
                dataGridView3.DataSource = myds.Tables[0];
                if (myds.Tables[0].Rows.Count > 0)
                    btnCDelete.Enabled = true;
                else
                    btnCDelete.Enabled = false;
            }
        }
        #endregion

        #region 删除选中的多行数据
        private void tSMItemDelete_Click(object sender, EventArgs e)
        {
            //删除专业表中选中的多条信息
            if (dataGridView2.SelectedRows.Count != 0)
            {
               DeleteProf();
               combBdepartment_SelectedIndexChanged(sender, e);
            }
            //删除学院表中选中的多条信息
            if (dataGridView1.SelectedRows.Count != 0)
            {
                DeleteDepart();
                WeihuDepartmen_Load(sender, e);
            }
            //删除班级表中选中的多条信息
            if (dataGridView3.SelectedRows.Count != 0)
            {
                DeleteClass();
                comCDepartment_SelectedIndexChanged(sender, e);
            }
            MessageBox.Show("删除数据成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
        #endregion

        #region 删除专业表中选中的多条信息
        public void DeleteProf()
        {
            //删除选中的多条数据
            if (MessageBox.Show("确实要删除选择信息吗？", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
            {
                //将选中的行的index存在数组selectindex中
                int[] selectindex = new int[dataGridView2.SelectedRows.Count];
                for (int i = 0, j = 0; i < dataGridView2.Rows.Count; i++)
                {
                    if (dataGridView2.Rows[i].Selected)
                        selectindex[j++] = Convert.ToInt32(dataGridView2.Rows[i].Index.ToString());
                }
                //从selectindex数组中index值最大的行开始，依次删除选中的行
                for (int i = dataGridView2.SelectedRows.Count-1 ; i >= 0; i--)
                    boperate.getcom("delete from profession where profession ='" + Convert.ToString(dataGridView2.Rows[selectindex[i]].Cells[1].Value).Trim() + "'");
            }
            
        }
        #endregion

        #region 删除学院表中选中的多条信息
        public void DeleteDepart()
        {
            //删除选中的多条数据
            if (MessageBox.Show("确实要删除选择信息吗？", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
            {
                //将选中的行的index存在数组selectindex中
                int[] selectindex = new int[dataGridView1.SelectedRows.Count];
                for (int i = 0, j = 0; i < dataGridView1.Rows.Count; i++)
                {
                    if (dataGridView1.Rows[i].Selected)
                        selectindex[j++] = Convert.ToInt32(dataGridView1.Rows[i].Index.ToString());
                }
                //从selectindex数组中index值最大的行开始，依次删除选中的行
                for (int i = dataGridView1.SelectedRows.Count-1; i >= 0; i--)
                    boperate.getcom("delete from department where department ='" + Convert.ToString(dataGridView1.Rows[selectindex[i]].Cells[0].Value).Trim() + "'");
            }

        }
        #endregion

        #region 删除班级表中选中的多条信息
        public void DeleteClass()
        {
            //删除选中的多条数据
            if (MessageBox.Show("确实要删除选择信息吗？", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
            {
                //将选中的行的index存在数组selectindex中
                int[] selectindex = new int[dataGridView3.SelectedRows.Count];
                for (int i = 0, j = 0; i < dataGridView3.Rows.Count; i++)
                {
                    if (dataGridView3.Rows[i].Selected)
                        selectindex[j++] = Convert.ToInt32(dataGridView3.Rows[i].Index.ToString());
                }
                //从selectindex数组中index值最大的行开始，依次删除选中的行
                for (int i = dataGridView3.SelectedRows.Count-1 ; i >= 0; i--)
                    boperate.getcom("delete from class where class ='" + Convert.ToString(dataGridView3.Rows[selectindex[i]].Cells[1].Value).Trim() + "'");
            }

        }
        #endregion
    }
}