📄 mainform.cs
字号:
majorTextBox.Text = "";
classComboBox.Text = "";
stuNumberComboBox.DropDownStyle = ComboBoxStyle.DropDown;
stuNumberComboBox.Text = "";
stuNewRecord = true;
}
//添加成绩
private void addScore(string stuNumber, string stuName, string couNumber)
{
string score = "";
string sql = "insert into stuScore (stuNumber,stuName,couNumber,score) values(" +
"'" + stuNumber + "'," +
"'" + stuName + "'," +
"'" + couNumber + "'," +
"'" + score + "')";
data.Execute(sql);
}
//保存学生信息
private void saveStudent(object sender, EventArgs e)
{
if (checkInfor() == 1)
{
string sql;
string sql1 = "update stuScore set stuNumber= '" +
stuNumberComboBox.Text + "' where stuNumber = '" + stuNumber + "'";
if (stuNewRecord == true)
{
sql = "insert into stuInfor (stuNumber,stuName,college,major,class) values(" +
"'" + stuNumberComboBox.Text + "'," +
"'" + nameTextBox.Text + "'," +
"'" + sex + "'," +
"'" + collegeComboBox.Text + "'," +
"'" + majorTextBox.Text + "'," +
"'" + classComboBox.Text + "')";
}
else
{
sql = "update stuInfor set " +
"stuNumber = '" + stuNumberComboBox.Text + "'," +
"stuName = '" + nameTextBox.Text + "'," +
" college = '" + collegeComboBox.Text + "'," +
" major = '" + majorTextBox.Text + "'," +
" class = '" + classComboBox.Text + "' where stuNumber = '" + stuNumber + "'";
int s = data.ExecuteSql(sql1);
stuNumber = stuNumberComboBox.Text;
}
try
{
int rowAffected = data.ExecuteSql(sql);
if (rowAffected == 1)
{
classComboBox.Items.Add(classComboBox.Text);
if (stuNewRecord == false)
{
stuNumberComboBox.Items.Remove(stuNumber);
classComboBox.Items.Remove(classes);
}
stuNumberComboBox.Items.Add(stuNumberComboBox.Text);
}
}
catch (OleDbException ex)
{
MessageBox.Show("该学生的信息已存在!", "出现错误",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// data.Con.Close();
if (stuNewRecord == false)
{
classComboBox.SelectedIndex = classComboBox.Items.Count - 1;
// stuNumberComboBox.SelectedIndex = stuNumberComboBox.Items.Count - 1;
}
//classComboBox.SelectedIndex = classComboBox.Items.Count - 1;
// stuNumberComboBox.SelectedIndex = stuNumberComboBox.FindString(stuNumber);
//stuNumberComboBox.SelectedIndex = stuNumberComboBox.Items.Count - 1;
if (stuNewRecord == true)
{
stuNewRecord = false;
classComboBox.SelectedIndex = classComboBox.Items.Count - 1;
stuNumberComboBox.SelectedIndex = stuNumberComboBox.Items.Count - 1;
OleDbDataReader sdr;
string sql2 = "select couNumber from course";
sdr = data.GetReader(sql2);
while (sdr.Read())
{
addScore(stuNumberComboBox.Text, nameTextBox.Text, sdr["couNumber"].ToString());
}
sdr.Close();
data.Con.Close();
}
GetScore();
GetStudent();
}
else
{
MessageBox.Show("信息不全!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//查询学生信息
private void queryStudent(object sender, EventArgs e)
{
OleDbDataReader sdr;
string sql = "select * from stuInfor where stuNumber='" + findStuToolStripTextBox.Text + "'";
sdr = data.GetReader(sql);
if (sdr.Read())
{
string stu = sdr["stuNumber"].ToString();
string class1 = sdr["class"].ToString();
collegeComboBox.Text = sdr["college"].ToString();
classComboBox.Text = class1;
stuNumberComboBox.Text = stu;
}
else
{
MessageBox.Show("你所查找的学生信息不存在!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
sdr.Close();
data.Con.Close();
}
//删除学生
private void deleteStudent(object sender, EventArgs e)
{
string sql = "delete from stuInfor where stuNumber = '" + stuNumberComboBox.Text + "'";
string sql1 = "delete from stuScore where stuNumber = '" + stuNumberComboBox.Text + "'";
try
{
int rowAffected = data.ExecuteSql(sql);
if (rowAffected == 1)
{
int rowAffected1 = data.ExecuteSql(sql1);
stuNumberComboBox.Items.Remove(stuNumberComboBox.Text);
if (stuNumberComboBox.Items.Count > 0)
{
stuNumberComboBox.SelectedIndex = 0;
}
else
{
nameTextBox.Text = "";
majorTextBox.Text = "";
classComboBox.Text = "";
stuNumberComboBox.DropDownStyle = ComboBoxStyle.DropDown;
stuNumberComboBox.Text = "";
}
GetStudent();
//GetStuClass(collegeComboBox, classComboBox);
// GetStudent();
}
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message, "出现错误",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
data.Con.Close();
}
//退出
private void exit(object sender, EventArgs e)
{
Application.Exit();
}
private void findStudent(object sender, EventArgs e)
{
stuNumberComboBox.SelectedIndex = stuNumberComboBox.FindString(stuDataGridView.CurrentRow.Cells[0].Value.ToString());
}
private void findCourse(object sender, EventArgs e)
{
couNumberComboBox.SelectedIndex = couNumberComboBox.FindString(couDataGridView.CurrentRow.Cells[0].Value.ToString());
}
private void getSex(object sender, EventArgs e)
{
sex = Convert.ToString(((RadioButton)sender).Tag);
}
private void classChanged(object sender, EventArgs e)
{
stuNumberComboBox.DropDownStyle = ComboBoxStyle.DropDown;
stuNumberComboBox.Text = "";
majorTextBox.Text = "";
nameTextBox.Text = "";
GetStuNumber(collegeComboBox, classComboBox, stuNumberComboBox);
//couComboBox.SelectedIndex = -1;
scoTextBox.Text = "";
//stuNumberComboBox.SelectedIndex = stuNumberComboBox.FindString(stuNumber);
classes = classComboBox.Text;
GetStudent();
}
private void updateScore2(object sender, EventArgs e)
{
string sql = "update stuScore ,course set " +
" stuScore.score = '" + scoTextBox.Text + "' where course.couName='" +
couComboBox.Text + "' and stuScore.stuNumber = '" +
stuNumberComboBox.Text + "' and stuScore.couNumber=course.couNumber";
try
{
int rowAffected = data.ExecuteSql(sql);
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message, "出现错误",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
data.Con.Close();
GetScore();
}
private void 导出信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.DefaultExt = "*.xls";
saveFile.Filter = "XLS Files(*.xls)|*.xls|All Files|*.*";
if (saveFile.ShowDialog() == DialogResult.OK && saveFile.FileName.Length > 0)
{
OleDbDataReader sdr;
string sql2 = "select couNumber from course";
sdr = data.GetReader(sql2);
while (sdr.Read())
{
string couNumber = sdr["couNumber"].ToString();
string qq = Convert.ToString("d2d");
//int qq = 55588;
string sql = "INSERT INTO [sheet1$] VALUES (" + qq + ",2565,'5356','54555')";
//string sql = "INSERT INTO [sheet1$] VALUES ('" + couNumber + "')";
try
{
data.SaveFP2toExcel(saveFile.FileName, sql);
}
catch (OleDbException ex)
{
}
}
sdr.Close();
data.Con.Close();
}
}
private void addStudent(string stuNumber1, string stuName, string sex, string college, string major, string classes, string address, string telNumber, string birthday)
{
string sql = "insert into stuInfor (stuNumber,stuName,sex,college,major,class,address,telNumber,birthday) values(" +
"'" + stuNumber1 + "'," +
"'" + stuName + "'," +
"'" + sex + "'," +
"'" + college + "'," +
"'" + major + "'," +
"'" + classes + "'," +
"'" + address + "'," +
"'" + telNumber + "'," +
"'" + birthday + "')";
data.Execute(sql);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
GetStuScore2();
}
private void dataGridView2_Click(object sender, EventArgs e)
{
couComboBox.SelectedIndex = couComboBox.FindString(scoDataGridView.CurrentRow.Cells[0].Value.ToString());
}
private int checkInfor()
{
int checkOK = 1;
if (nameTextBox.Text.Equals(""))
{
checkOK = 0;
}
if (stuNumberComboBox.Text.Equals(""))
{
checkOK = 0;
}
if (classComboBox.Text.Equals(""))
{
checkOK = 0;
}
if (majorTextBox.Text.Equals(""))
{
checkOK = 0;
}
return checkOK;
}
private void comboBox1_SelectedIndexChanged_1(object sender, EventArgs e)
{
DataSet scoDataSet1 = new DataSet();
string couSql = "select S.stuNumber,S.stuName,C.couName ,S.score from stuScore S,course C where C.couName='" + comboBox1.Text + "' and S.couNumber=C.couNumber";
scoDataSet1 = data.getData(couSql);
scoDataAdapter1 = new OleDbDataAdapter(data.command);
scoDataAdapter1.Fill(scoDataSet1, "course");
scoBindingSource1.DataSource = scoDataSet1.Tables["course"];
// dataGridView1.DataSource = scoBindingSource1;
data.Con.Close();
}
private void 关于ToolStripMenuItem_Click(object sender, EventArgs e)
{
About about = new About();
about.ShowDialog();
}
private void stuGroupBox_Enter(object sender, EventArgs e)
{
}
private void label2_Click(object sender, EventArgs e)
{
}
private void collegeLabel_Click(object sender, EventArgs e)
{
}
private void classLabel_Click(object sender, EventArgs e)
{
}
private void majorLabel_Click(object sender, EventArgs e)
{
}
private void numLabel_Click(object sender, EventArgs e)
{
}
private void nameLabel_Click(object sender, EventArgs e)
{
}
private void label1_Click(object sender, EventArgs e)
{
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -