formscoresearch.cs

学生管理系统Csharp2005 学生管理系统Csharp2005 学生管理系统Csharp2005

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 StudentManager.DbLayer;

namespace StudentManager
{
    public partial class FormScoreSearch : Form
    {
        public FormScoreSearch()
        {
            InitializeComponent();
        }

        private void splitContainer1_Panel1_Paint(object sender, PaintEventArgs e)
        {

        }

        private void labelScore_Click(object sender, EventArgs e)
        {

        }

        /// <summary>
        /// 读取课程表中的数据，并绑定导下拉框中
        /// </summary>
        void InitData()
        {
            string sql = "select * from [Course]";

            Database db = new Database();
            SqlDataReader dr = db.GetDataReader(sql);
            comboBoxCourse.Items.Clear();

            while (dr.Read())
            {
                comboBoxCourse.Items.Add(GetSafeData.ValidateDataReader_S(dr, "CName"));
            }

            if (comboBoxCourse.Items.Count > 0)
                comboBoxCourse.SelectedIndex = 0;
        }

        /// <summary>
        /// 查询数据
        /// </summary>
        void Query()
        {
            if (textBoxScore1.Text == "")
                textBoxScore1.Text = "0";

            if (textBoxScore2.Text == "")
                textBoxScore1.Text = "100";

            try
            {
                if (Convert.ToInt32(textBoxScore1.Text) > Convert.ToInt32(textBoxScore1.Text))
                {
                    MessageBox.Show("请正确输入成绩范围！");
                    return;
                }
            }
            catch
            {
                MessageBox.Show("请正确输入成绩数据类型！");
                return;
            }

            if (comboBoxCourse.SelectedItem == null)
            {
                MessageBox.Show("请选择课程名称！");
                return;
            }


            string sql = "";
            sql += "select [Student].SNo,SName,Score from [Student],[Course],[Student_Course] ";
            sql += " where [Student_Course].Score >= " + textBoxScore1.Text;
            sql += " and [Student_Course].Score <= " + textBoxScore2.Text;
            sql += " and [Course].CName = " + SqlStringConstructor.GetQuotedString(comboBoxCourse.SelectedItem.ToString());
            sql += "and [Student].SNo= [Student_Course].Sno ";
            sql += "and [Course].CNo= [Student_Course].Cno ";

            Database db = new Database();
            DataTable dt = db.GetDataTable(sql);
            dataGridViewPreView.DataSource = dt;
        }

        /// <summary>
        /// 页面加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FormScoreSearch_Load(object sender, EventArgs e)
        {
            InitData();
        }

        /// <summary>
        /// “查询”按钮单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void buttonSearch_Click(object sender, EventArgs e)
        {
            Query();
        }

        private void dataGridViewPreView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }
    }
}