frmmain.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.Drawing.Printing;

using System.Data.Sql;
using System.Data.SqlClient;


namespace Students1
{
    using StudentLibrary.Business;
    public partial class frmMain : Form
    {
        private int iCurrentRow = -1;
        private float fCurrentScore = -1;
        private string id;
        
        
        public frmMain(string id)
        {
            InitializeComponent();
            this.id=id;
        }

        private void frmMain_Load(object sender, EventArgs e)
        {
            if (id == "s")
            {
                this.lstClass.Enabled = false;
                this.lstCourse.Enabled = false;
                this.lstStudent.Enabled = false;
                this.dataGrid1.Enabled = false;
                this.班级管理ToolStripMenuItem.Enabled = false;
            }
            GetClass();//获取班级信息
            CreateScoreTemp();//创建成绩列表
            CreateStudentTemp(); //
            CreateCourseTemp();

        }
        /// <summary>
        /// 
        /// 获取班级信息
        /// </summary>
        public void GetClass()
        {
            lstClass.Items.Clear();
            this.statusBar1.Text = "正在获取班级信息，请稍等……";
           
            Classs classs=new Classs();
            DataSet dataset = new DataSet();
            try
            {
                

                dataset = classs.SelectClass( -1, "");
                
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            //添加班级列
            ColumnHeader columnHeader = new ColumnHeader();
            columnHeader.Text = "班级";
            lstClass.Columns.Add(columnHeader);

            //添加班级编号列
            columnHeader = new ColumnHeader();
            columnHeader.Text = "班级编号";
            lstClass.Columns.Add(columnHeader);
            
            lstClass.Columns[0].Width = lstClass.Width;
            lstClass.Columns[1].Width =0;

            string[] sItems = new string[2];
            for(int i = 0; i < dataset.Tables[0].Rows.Count; i ++)
            {
                DataRow row = dataset.Tables[0].Rows[i]; 
                sItems[0] = row["ClassName"].ToString();
                sItems[1] = row["ClassId"].ToString();
               
                ListViewItem item = new ListViewItem(sItems, 0);//
                lstClass.Items.Add(item);
            }

            this.statusBar1.Text = "查询完毕";
           
        }

        //创建课程列表
        private void CreateCourseTemp()
        {
            ColumnHeader columnHeader = new ColumnHeader();
            columnHeader.Text = "课程名称";
            columnHeader.Width = lstCourse.Width/2;
            lstCourse.Columns.Add(columnHeader);

            columnHeader = new ColumnHeader();
            columnHeader.Text = "CourseId";
            columnHeader.Width =lstCourse.Width/2;
            lstCourse.Columns.Add(columnHeader);
        }

        //创建成绩列表
        private void CreateScoreTemp()
        {
            DataGridTableStyle tableStyle = new DataGridTableStyle();

            DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
            columnStyle.MappingName = "StudentId";
            columnStyle.HeaderText = "StudentId";
            columnStyle.Width = 0;
            columnStyle.ReadOnly = true;
            tableStyle.GridColumnStyles.Add(columnStyle);

            columnStyle = new DataGridTextBoxColumn();
            columnStyle.MappingName = "CourseId";
            columnStyle.HeaderText = "CourseId";
            columnStyle.Width = 0;
            columnStyle.ReadOnly = true;
            tableStyle.GridColumnStyles.Add(columnStyle);

            columnStyle = new DataGridTextBoxColumn();
            columnStyle.MappingName = "ScoreId";
            columnStyle.HeaderText = "ScoreId";
            columnStyle.Width = 0;
            columnStyle.ReadOnly = true;
            tableStyle.GridColumnStyles.Add(columnStyle);

            columnStyle = new DataGridTextBoxColumn();
            columnStyle.MappingName = "StudentName";
            columnStyle.HeaderText = "姓名";
            columnStyle.ReadOnly = true;
            columnStyle.Width = dataGrid1.Width / 4 - 10;
            tableStyle.GridColumnStyles.Add(columnStyle);

            columnStyle = new DataGridTextBoxColumn();
            columnStyle.MappingName = "ClassName";
            columnStyle.HeaderText = "班";
            columnStyle.ReadOnly = true;
            columnStyle.Width = dataGrid1.Width / 4 - 10;
            tableStyle.GridColumnStyles.Add(columnStyle);

            columnStyle = new DataGridTextBoxColumn();
            columnStyle.MappingName = "SubjectName";
            columnStyle.HeaderText = "科目";
            columnStyle.ReadOnly = true;
            columnStyle.Width = dataGrid1.Width / 4 - 10;
            tableStyle.GridColumnStyles.Add(columnStyle);

            columnStyle = new DataGridTextBoxColumn();
            columnStyle.MappingName = "Score";
            columnStyle.HeaderText = "成绩";
            columnStyle.Width = dataGrid1.Width / 4 - 10;
            tableStyle.GridColumnStyles.Add(columnStyle);

            tableStyle.RowHeadersVisible = false;//隐藏表头
            tableStyle.MappingName = "Score";

            dataGrid1.TableStyles.Add(tableStyle);
            /////////////////////////////////
            
            

        }

        //创建学生列表
        private void CreateStudentTemp()
        {
            //创建表头
            ColumnHeader columnHeader = new ColumnHeader();
            columnHeader.Text = "姓名";
            lstStudent.Columns.Add(columnHeader);

            columnHeader = new ColumnHeader();
            columnHeader.Text = "StudentId";
            lstStudent.Columns.Add(columnHeader);

            columnHeader = new ColumnHeader();
            columnHeader.Text = "学号";
            lstStudent.Columns.Add(columnHeader);

            columnHeader = new ColumnHeader();
            columnHeader.Text = "性别";
            lstStudent.Columns.Add(columnHeader);

            columnHeader = new ColumnHeader();
            columnHeader.Text = "出生年月";
            lstStudent.Columns.Add(columnHeader);

            columnHeader = new ColumnHeader();
            columnHeader.Text = "班级";
            lstStudent.Columns.Add(columnHeader);

            columnHeader = new ColumnHeader();
            columnHeader.Text = "备注";
            lstStudent.Columns.Add(columnHeader);
            for (int i = 0; i < lstStudent.Columns.Count; i++)
            {
                lstStudent.Columns[i].Width = lstStudent.Width / lstStudent.Columns.Count;
            }
            lstStudent.Columns[4].Width =lstStudent.Columns[4].Width *2;
            lstStudent.Columns[1].Width = 0;

        }
        //获取学生信息
        private void GetStudent()
        {
            lstStudent.Items.Clear();
            int iClassId = -1;
            try
            {
                iClassId = Convert.ToInt32(lstClass.SelectedItems[0].SubItems[1].Text.ToString());//获取班级Id
            }
            catch { }

          
            Students students = new Students();
            DataSet dataset = new DataSet();
            try
            {

                dataset = students.SelectStudent(-1, "", "", iClassId);
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
                Application.Exit();
            }


            for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
            {
                DataRow row = dataset.Tables[0].Rows[i];
                string[] sItems = new string[7];
                sItems[0] = row["StudentName"].ToString();
                sItems[1] = row["StudentId"].ToString();
                sItems[2] = row["StudentNo"].ToString();
                sItems[3] = row["Gender"].ToString() == "0" ? "男" : "女";
                sItems[4] = row["Birthday"].ToString();
                sItems[5] = row["ClassName"].ToString();
                sItems[6] = row["Remark"].ToString();
                ListViewItem item = new ListViewItem(sItems, 1);
                lstStudent.Items.Add(item);
            }
            
            students.Dispose();
        }

        //获取分数信息
        private void GetScore()
        {
            Scores scores = new Scores();
            DataSet dataset = new DataSet();

            int iClassId = -1;
            int iCourseId = -1;
            int iStudentId = -1;

            try
            {
                iClassId = Convert.ToInt32(lstClass.SelectedItems[0].SubItems[1].Text);
            }
            catch
            { }
            try
            {
                iCourseId = Convert.ToInt32(lstCourse.SelectedItems[0].SubItems[1].Text);

            }
            catch { }
            try
            {
                iStudentId = Convert.ToInt32(lstStudent.SelectedItems[0].SubItems[1].Text);
            }
            catch { }