void RefreshCourseData() { string sqlStr; sqlStr = "select * from tb_course where csemester='" + cmbSemester.Text.Trim() + "'"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvCourse.DataSource = ds.Tables[0]; dgrdvCourse.Columns[0].HeaderText = "课程号"; dgrdvCourse.Columns[0].Width = 100; dgrdvCourse.Columns[1].HeaderText = "课程名"; dgrdvCourse.Columns[1].Width = 130; dgrdvCourse.Columns[2].HeaderText = "学分"; dgrdvCourse.Columns[2].Width = 50; dgrdvCourse.Columns[3].HeaderText = "学时"; dgrdvCourse.Columns[3].Width = 50; dgrdvCourse.Columns[4].HeaderText = "课程学期"; dgrdvCourse.Columns[4].Width = 130; } else { dgrdvCourse.DataSource = null; } }
private void cmbSemester_SelectedIndexChanged_1(object sender, EventArgs e) { cmbCourse.SelectedIndex = -1; string sqlStr = "select tb_grade.sno,tb_student.sname,tb_grade.cno,tb_course.cname,tb_course.cperiod,tb_course.csemester,tb_grade.grade from tb_student inner join tb_grade on tb_student.sno = tb_grade.sno join tb_course on tb_grade.cno = tb_course.cno where tb_course.csemester='" + cmbSemester.Text.Trim() + "'"; DataSet ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvGrade.DataSource = ds.Tables[0]; dgrdvGrade.Columns[0].HeaderText = "学号"; dgrdvGrade.Columns[0].Width = 100; dgrdvGrade.Columns[1].HeaderText = "姓名"; dgrdvGrade.Columns[1].Width = 150; dgrdvGrade.Columns[2].HeaderText = "课程号"; dgrdvGrade.Columns[2].Width = 100; dgrdvGrade.Columns[3].HeaderText = "课程名"; dgrdvGrade.Columns[3].Width = 150; dgrdvGrade.Columns[4].HeaderText = "学分"; dgrdvGrade.Columns[4].Width = 100; dgrdvGrade.Columns[5].HeaderText = "开课学期"; dgrdvGrade.Columns[5].Width = 150; dgrdvGrade.Columns[6].HeaderText = "成绩"; dgrdvGrade.Columns[6].Width = 100; dgrdvGrade_RowHeaderMouseClick(null, null); } else { dgrdvGrade.DataSource = null; //MessageBox.Show("暂无该学期成绩", "提示"); } }
//更新表 void RefreshData() { string sqlStr; DataSet ds = new DataSet(); sqlStr = "select * from tb_Student"; ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvStudent.DataSource = ds.Tables[0]; dgrdvStudent.Columns[0].HeaderText = "学生学号"; dgrdvStudent.Columns[0].Width = 168; dgrdvStudent.Columns[1].HeaderText = "学生姓名"; dgrdvStudent.Columns[1].Width = 159; dgrdvStudent.Columns[2].HeaderText = "学生性别"; dgrdvStudent.Columns[2].Width = 88; dgrdvStudent.Columns[3].HeaderText = "学生年龄"; dgrdvStudent.Columns[3].Width = 88; dgrdvStudent.Columns[4].HeaderText = "学生班级"; dgrdvStudent.Columns[4].Width = 100; dgrdvStudent.Columns[5].HeaderText = "所在学院(系别)"; dgrdvStudent.Columns[5].Width = 159; dgrdvStudent_RowHeaderMouseClick(null, null); } else { dgrdvStudent.DataSource = null; } }
private void btnSelect_Click(object sender, EventArgs e) { try { if (dgrdvCourse.DataSource == null) { MessageBox.Show("没有课程可选", "提示"); return; } int n = dgrdvCourse.CurrentCell.RowIndex; int i = dgrdvclass.CurrentCell.RowIndex; string selectCno, classno; classno = dgrdvclass[0, i].Value.ToString().Trim(); selectCno = dgrdvCourse[0, n].Value.ToString().Trim(); string sqlStr; sqlStr = "select * from tb_select where classno='" + classno + "'" + "and Cno='" + selectCno + "'"; if (CDataBase.GetDataFromDB(sqlStr) != null) { MessageBox.Show("已选该课程!", "不能重选", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } sqlStr = "insert into tb_select (classNo,Cno) values ('" + classno + "','" + selectCno + "')"; CDataBase.UpdateDB(sqlStr); RefreshSelcetCourseData(); MessageBox.Show("选课成功", "提示"); } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
//删除 private void btnDelete_Click(object sender, EventArgs e) { try { if (MessageBox.Show("确定要删除“" + txtSno.Text.Trim() + "”的资料吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr = "delete from tb_grade where sno='" + txtSno.Text.Trim() + "'"; CDataBase.UpdateDB(sqlStr); int n = dgrdvGrade.CurrentCell.RowIndex; dgrdvGrade.Rows.RemoveAt(n); if (dgrdvGrade.Rows.Count == 1) { cleraAll(); dgrdvGrade.DataSource = null; } else { dgrdvGrade_RowHeaderMouseClick(null, null); } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
void RefreshData() { string sqlStr; DataSet ds = new DataSet(); sqlStr = "select * from tb_Course"; ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvCourse.DataSource = ds.Tables[0]; dgrdvCourse.Columns[0].HeaderText = "课程号"; dgrdvCourse.Columns[0].Width = 150; dgrdvCourse.Columns[1].HeaderText = "课程名"; dgrdvCourse.Columns[1].Width = 200; dgrdvCourse.Columns[2].HeaderText = "课程学分"; dgrdvCourse.Columns[2].Width = 80; dgrdvCourse.Columns[3].HeaderText = "课程学时"; dgrdvCourse.Columns[3].Width = 80; dgrdvCourse.Columns[4].HeaderText = "开课学期"; dgrdvCourse.Columns[4].Width = 150; dgrdvCourse_RowHeaderMouseClick(null, null); } else { dgrdvCourse.DataSource = null; } }
void RefreshData() { string sqlStr; sqlStr = "select tb_grade.sno,tb_student.sname,tb_grade.cno,tb_course.cname,tb_course.cperiod,tb_course.csemester,tb_grade.grade from tb_student inner join tb_grade on tb_student.sno = tb_grade.sno join tb_course on tb_grade.cno = tb_course.cno where tb_course.csemester='" + cmbSemester.Text.Trim() + "' and tb_grade.sno='" + CPublic.userInfo[0] + "'"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvGrade.DataSource = ds.Tables[0]; dgrdvGrade.Columns[0].HeaderText = "学号"; dgrdvGrade.Columns[0].Width = 50; dgrdvGrade.Columns[1].HeaderText = "姓名"; dgrdvGrade.Columns[1].Width = 80; dgrdvGrade.Columns[2].HeaderText = "课程号"; dgrdvGrade.Columns[2].Width = 70; dgrdvGrade.Columns[3].HeaderText = "课程名"; dgrdvGrade.Columns[3].Width = 100; dgrdvGrade.Columns[4].HeaderText = "学分"; dgrdvGrade.Columns[4].Width = 50; dgrdvGrade.Columns[5].HeaderText = "开课学期"; dgrdvGrade.Columns[5].Width = 100; dgrdvGrade.Columns[6].HeaderText = "成绩"; dgrdvGrade.Columns[6].Width = 50; //dgrdvGrade_RowHeaderMouseClick(null, null); } else { dgrdvGrade.DataSource = null; MessageBox.Show("暂无该学期成绩", "提示"); } }
//修改 private void btnUpdate_Click(object sender, EventArgs e) { try { if (btnUpdate.Text == "修改") { btnUpdate.Text = "确定"; btnAdd.Enabled = false; btnDelete.Enabled = false; txtSno.Enabled = false; txtCno.Enabled = false; txtGarde.Enabled = true; txtGarde.Text = ""; txtGarde.Focus(); } else { btnUpdate.Text = "修改"; btnAdd.Enabled = true; btnDelete.Enabled = true; txtSno.Enabled = false; txtCno.Enabled = false; txtGarde.Enabled = false; string sqlStr; sqlStr = "update tb_grade set grade='" + txtGarde.Text.Trim() + "'where sno='" + txtSno.Text.Trim() + "'"; CDataBase.UpdateDB(sqlStr); RefreshData(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnAll_Click(object sender, EventArgs e) { cmbCourse.SelectedIndex = -1; cmbSemester.SelectedIndex = -1; string sqlStr; sqlStr = "select tb_grade.sno,tb_student.sname,tb_grade.cno,tb_course.cname,tb_course.cperiod,tb_course.csemester,tb_grade.grade from tb_student inner join tb_grade on tb_student.sno = tb_grade.sno join tb_course on tb_grade.cno = tb_course.cno"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvGrade.DataSource = ds.Tables[0]; dgrdvGrade.Columns[0].HeaderText = "学号"; dgrdvGrade.Columns[0].Width = 100; dgrdvGrade.Columns[1].HeaderText = "姓名"; dgrdvGrade.Columns[1].Width = 150; dgrdvGrade.Columns[2].HeaderText = "课程号"; dgrdvGrade.Columns[2].Width = 100; dgrdvGrade.Columns[3].HeaderText = "课程名"; dgrdvGrade.Columns[3].Width = 150; dgrdvGrade.Columns[4].HeaderText = "学分"; dgrdvGrade.Columns[4].Width = 100; dgrdvGrade.Columns[5].HeaderText = "开课学期"; dgrdvGrade.Columns[5].Width = 150; dgrdvGrade.Columns[6].HeaderText = "成绩"; dgrdvGrade.Columns[6].Width = 100; dgrdvGrade_RowHeaderMouseClick(null, null); } else { dgrdvGrade.DataSource = null; } }
private void btnSelect_Click(object sender, EventArgs e) { try { if (txtUserName.Text.Trim() == "") { MessageBox.Show("请输入要查询用户的关键字", "提示"); txtUserName.Focus(); return; } string sqlStr = "select * from tb_user where userName='******'"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { txtUserName.Text = ""; dataGridView1.DataSource = ds.Tables[0]; SetHeadText(); } else { dataGridView1.DataSource = null; txtUserName.Text = ""; MessageBox.Show("没有该用户", "提示"); RefreshData(); SetHeadText(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { try { if (dgrdvSelectCourse.DataSource == null) { MessageBox.Show("没有可删除的选课记录!", "提示"); return; } int n = dgrdvSelectCourse.CurrentCell.RowIndex; string classNo, selectCno, selectCname; classNo = dgrdvSelectCourse[0, n].Value.ToString().Trim(); selectCno = dgrdvSelectCourse[2, n].Value.ToString().Trim(); selectCname = dgrdvSelectCourse[3, n].Value.ToString().Trim(); if (MessageBox.Show("确定要删除“" + classNo + "”的所选课程《" + selectCname + "》吗?", "删除选课记录", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr; sqlStr = "delete from tb_select where classno='" + classNo + "'" + "and Cno='" + selectCno + "'"; CDataBase.UpdateDB(sqlStr); dgrdvSelectCourse.Rows.RemoveAt(n); if (dgrdvSelectCourse.Rows.Count == 1) { dgrdvSelectCourse.DataSource = null; } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
//统计 private void btnItemize_Click(object sender, EventArgs e) { try { if (cmbCount.Text.Trim() == "") { MessageBox.Show("请输入统计条件!", "提示!"); cmbCount.Focus(); } else if (cmbCount.SelectedIndex == 5) { if (txtCountValue1.Text.Trim() == "" & txtCountValue2.Text.Trim() == "") { MessageBox.Show("请输入统计条件或统计值!", "提示!"); cmbCount.Focus(); } } string sqlStr; sqlStr = "select tb_grade.sno,tb_student.sname,tb_grade.cno,tb_course.cname,tb_course.cperiod,tb_course.csemester,tb_grade.grade from tb_student inner join tb_grade on tb_student.sno = tb_grade.sno join tb_course on tb_grade.cno = tb_course.cno where tb_course.cname='" + cmbCourse.Text.Trim() + "' and grade between '" + txtCountValue2.Text.Trim() + "' and '" + txtCountValue1.Text.Trim() + "'"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvGrade.DataSource = ds.Tables[0]; dgrdvGrade.Columns[0].HeaderText = "学号"; dgrdvGrade.Columns[0].Width = 100; dgrdvGrade.Columns[1].HeaderText = "姓名"; dgrdvGrade.Columns[1].Width = 150; dgrdvGrade.Columns[2].HeaderText = "课程号"; dgrdvGrade.Columns[2].Width = 100; dgrdvGrade.Columns[3].HeaderText = "课程名"; dgrdvGrade.Columns[3].Width = 150; dgrdvGrade.Columns[4].HeaderText = "学分"; dgrdvGrade.Columns[4].Width = 100; dgrdvGrade.Columns[5].HeaderText = "开课学期"; dgrdvGrade.Columns[5].Width = 150; dgrdvGrade.Columns[6].HeaderText = "成绩"; dgrdvGrade.Columns[6].Width = 100; dgrdvGrade_RowHeaderMouseClick(null, null); } else { dgrdvGrade.DataSource = null; txtCountValue1.Text = ""; txtCountValue2.Text = ""; MessageBox.Show("无此类信息", "提示"); cmbCourse.Focus(); RefreshData(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnAlter_Click(object sender, EventArgs e) { try { string sqlStr = "update tb_user set userPurview='" + cmbPurivew.Text.Trim() + "'" + "where userName='******'"; CDataBase.UpdateDB(sqlStr); RefreshData(); SetHeadText(); } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
//用于显示同步数据 void RefreshData() { DataSet myDs = new DataSet(); string sqlStr = "select userName,userPurview from tb_User"; myDs = CDataBase.GetDataFromDB(sqlStr); if (myDs != null) { dataGridView1.DataSource = myDs.Tables[0]; SetHeadText(); } else { dataGridView1.DataSource = null; } }
//窗体载入 private void btnRegedit_Click_1(object sender, EventArgs e) { try { if (btnRegedit.Text == "注册") { btnRegedit.Text = "确定"; ObjOpen(); } else if (txtUserName.Text.Trim() == "") { MessageBox.Show("用户名不能为空!", "提示"); txtUserName.Focus(); } else if (txtUserPasswors.Text.Trim() == "") { MessageBox.Show("用户名不能为空!", "提示"); txtUserPasswors.Focus(); } else if (!UserName(txtUserName.Text.Trim())) { MessageBox.Show("该用户已存在,请使用其他账号注册!", "提示"); txtUserName.Text = ""; ClearAll(); } else { btnRegedit.Text = "注册"; string sqlStr = "insert into tb_User values('" + txtUserName.Text.Trim() + "','" + txtUserPasswors.Text.Trim() + "','" + cmbPurview1.Text.Trim() + "','是')"; if (CDataBase.UpdateDB(sqlStr)) { MessageBox.Show(cmbPurview1.Text + " " + txtUserName.Text + "注册成功!", "注册用户"); } ClearAll(); ObjClose(); //btnCancel.Enabled = false; } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); ClearAll(); ObjClose(); } }
//修改 private void btnUpdate_Click(object sender, EventArgs e) { try { if (btnUpdate.Text.Trim() == "修改") { MessageBox.Show("学号不能修改", "注意"); btnUpdate.Text = "确定"; btnCancel2.Visible = true; btnAdd.Enabled = false; btnDelete.Enabled = false; btnClose.Enabled = false; cmbSelect.Enabled = false; btnSelect.Enabled = false; txtSelect.Enabled = false; txtName.Enabled = true; txtAge.Enabled = true; txtClass.Enabled = true; txtDept.Enabled = true; cmbSex.Enabled = true; txtName.Focus(); } else { btnUpdate.Text = "修改"; btnCancel2.Visible = false; btnAdd.Enabled = true; btnDelete.Enabled = true; btnClose.Enabled = true; cmbSelect.Enabled = true; btnSelect.Enabled = true; Objclose(); string sqlStr; sqlStr = "update tb_student set Sname='" + txtName.Text.Trim() + "',Ssex='" + cmbSex.Text.Trim() + "',Sage='" + txtAge.Text.Trim() + "',Sclass='" + txtClass.Text.Trim() + "',Sdept='" + txtDept.Text.Trim() + "'where sno='" + txtNo.Text.Trim() + "'"; CDataBase.UpdateDB(sqlStr); RefreshData(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
//进入窗体 private void FrmGrade_Load(object sender, EventArgs e) { try { txtGarde.Enabled = false; txtCountValue1.Enabled = false; txtCountValue2.Enabled = false; cmbCourse.SelectedIndex = 0; objClose(); cmbCourse.SelectedIndex = -1; string sqlStr; sqlStr = "select tb_grade.sno,tb_student.sname,tb_grade.cno,tb_course.cname,tb_course.cperiod,tb_course.csemester,tb_grade.grade from tb_student inner join tb_grade on tb_student.sno = tb_grade.sno join tb_course on tb_grade.cno = tb_course.cno"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvGrade.DataSource = ds.Tables[0]; dgrdvGrade.Columns[0].HeaderText = "学号"; dgrdvGrade.Columns[0].Width = 100; dgrdvGrade.Columns[1].HeaderText = "姓名"; dgrdvGrade.Columns[1].Width = 150; dgrdvGrade.Columns[2].HeaderText = "课程号"; dgrdvGrade.Columns[2].Width = 100; dgrdvGrade.Columns[3].HeaderText = "课程名"; dgrdvGrade.Columns[3].Width = 150; dgrdvGrade.Columns[4].HeaderText = "学分"; dgrdvGrade.Columns[4].Width = 100; dgrdvGrade.Columns[5].HeaderText = "开课学期"; dgrdvGrade.Columns[5].Width = 150; dgrdvGrade.Columns[6].HeaderText = "成绩"; dgrdvGrade.Columns[6].Width = 100; dgrdvGrade_RowHeaderMouseClick(null, null); } else { dgrdvGrade.DataSource = null; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//删除 private void btnDelete_Click(object sender, EventArgs e) { try { //RefreshData(); string userName; int n = this.dataGridView1.CurrentCell.RowIndex; userName = this.dataGridView1.Rows[n].Cells[0].Value.ToString().Trim(); if (MessageBox.Show("确认删除 " + userName + " 吗?", "删除用户", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr = "delete from tb_User where userName='******'"; CDataBase.UpdateDB(sqlStr); dataGridView1.Rows.RemoveAt(n); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
//string selectCondition; void RefreshClass() { string sqlStr; sqlStr = "select * from tb_class where classname='" + cmbClass.Text.Trim() + "'"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvclass.DataSource = ds.Tables[0]; dgrdvclass.Columns[0].HeaderText = "班级号"; dgrdvclass.Columns[0].Width = 70; dgrdvclass.Columns[1].HeaderText = "班级名"; dgrdvclass.Columns[1].Width = 90; } else { dgrdvCourse.DataSource = null; } }
private void btnDelete_Click(object sender, EventArgs e) { try { if (txtNo.Text.Trim() == "") { MessageBox.Show("木有可删除的记录", "提示"); return; } string sqlStr; sqlStr = "select * from tb_Select where cno='" + txtNo.Text.Trim() + "'"; if (CDataBase.GetDataFromDB(sqlStr) != null) { MessageBox.Show("已有该课程的选课信息,拒绝删除!", "删除出错", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (MessageBox.Show("确定删除课程“" + txtName.Text.Trim() + "”吗?", "删除课程信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { sqlStr = "delete from tb_course where cno='" + txtNo.Text.Trim() + "'"; CDataBase.UpdateDB(sqlStr); int n = dgrdvCourse.CurrentCell.RowIndex; dgrdvCourse.Rows.RemoveAt(n); if (dgrdvCourse.Rows.Count == 1) { ClearAll(); dgrdvCourse.DataSource = null; } else { dgrdvCourse_RowHeaderMouseClick(null, null); } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
void RefreshData() { string sqlStr; //int n = dgrdvGrade.CurrentCell.RowIndex; //string gardeName; //gardeName = dgrdvGrade[1, n].Value.ToString().Trim(); //lblShow.Text = "现在正在查看“" + gardeName + "”的成绩"; sqlStr = "select tb_grade.sno,tb_student.sname,tb_grade.cno,tb_course.cname,tb_course.cperiod,tb_course.csemester,tb_grade.grade from tb_student inner join tb_grade on tb_student.sno = tb_grade.sno join tb_course on tb_grade.cno = tb_course.cno where tb_course.cname='" + cmbCourse.Text.Trim() + "'"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvGrade.DataSource = ds.Tables[0]; dgrdvGrade.Columns[0].HeaderText = "学号"; dgrdvGrade.Columns[0].Width = 100; dgrdvGrade.Columns[1].HeaderText = "姓名"; dgrdvGrade.Columns[1].Width = 150; dgrdvGrade.Columns[2].HeaderText = "课程号"; dgrdvGrade.Columns[2].Width = 100; dgrdvGrade.Columns[3].HeaderText = "课程名"; dgrdvGrade.Columns[3].Width = 150; dgrdvGrade.Columns[4].HeaderText = "学分"; dgrdvGrade.Columns[4].Width = 100; dgrdvGrade.Columns[5].HeaderText = "开课学期"; dgrdvGrade.Columns[5].Width = 150; dgrdvGrade.Columns[6].HeaderText = "成绩"; dgrdvGrade.Columns[6].Width = 100; dgrdvGrade_RowHeaderMouseClick(null, null); } else { dgrdvGrade.DataSource = null; //MessageBox.Show("暂无此课程信息", "提示"); } }
private void FrmSelectCourse_Load(object sender, EventArgs e) { try { cmbSemester.SelectedIndex = 0; cmbClass.SelectedIndex = 0; string sqlStr; DataSet ds = new DataSet(); sqlStr = "select * from tb_course"; ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvCourse.DataSource = ds.Tables[0]; dgrdvCourse.Columns[0].HeaderText = "课程号"; dgrdvCourse.Columns[0].Width = 100; dgrdvCourse.Columns[1].HeaderText = "课程名"; dgrdvCourse.Columns[1].Width = 130; dgrdvCourse.Columns[2].HeaderText = "学分"; dgrdvCourse.Columns[2].Width = 50; dgrdvCourse.Columns[3].HeaderText = "学时"; dgrdvCourse.Columns[3].Width = 50; dgrdvCourse.Columns[4].HeaderText = "课程学期"; dgrdvCourse.Columns[4].Width = 130; } else { dgrdvCourse.DataSource = null; } RefreshCourseData(); RefreshClass(); RefreshSelcetCourseData(); } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
void RefreshSelcetCourseData() { string sqlStr, classCno; int i = dgrdvclass.CurrentCell.RowIndex; classCno = dgrdvclass[0, i].Value.ToString().Trim(); //sqlStr = "select tb_select.classNo,tb_class.classname,tb_select.classno,tb_course.Cname,tb_course.csemester" //+ "from tb_class inner join(tb_course inner join tb_select on tb_course.cno=tb_select.cno)" //+ "on tb_class.classno =tb_select.classno where tb_select.classno='" //+ classCno + "'"; sqlStr = "select tb_select.classNo,tb_class.classname,tb_Course.cno,tb_course.Cname,tb_course.cperiod,tb_course.csemester from tb_class inner join(tb_course inner join tb_select on tb_course.cno=tb_select.cno) on tb_class.classno =tb_select.classno where tb_select.classno='" + classCno + "'"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvSelectCourse.DataSource = ds.Tables[0]; dgrdvSelectCourse.Columns[0].HeaderText = "班级号"; dgrdvSelectCourse.Columns[0].Width = 130; dgrdvSelectCourse.Columns[1].HeaderText = "班级名"; dgrdvSelectCourse.Columns[1].Width = 130; dgrdvSelectCourse.Columns[2].HeaderText = "课程号"; dgrdvSelectCourse.Columns[2].Width = 130; dgrdvSelectCourse.Columns[3].HeaderText = "课程名"; dgrdvSelectCourse.Columns[3].Width = 130; dgrdvSelectCourse.Columns[4].HeaderText = "课程学时"; dgrdvSelectCourse.Columns[4].Width = 130; dgrdvSelectCourse.Columns[5].HeaderText = "课程学期"; dgrdvSelectCourse.Columns[5].Width = 130; } else { dgrdvSelectCourse.DataSource = null; } }
//修改 private void btnUpdata_Click(object sender, EventArgs e) //为什么课程号不能修改?——要用课程号作为修改条件 { try { if (btnUpdata.Text == "修改") { btnUpdata.Text = "确定"; btnCancel2.Visible = true; ObjOpen(); txtNo.Enabled = false; btnAdd.Enabled = false; btnDelete.Enabled = false; dgrdvCourse.Enabled = false; txtName.Focus(); } else { btnUpdata.Text = "修改"; btnCancel2.Visible = false; btnAdd.Enabled = true; btnDelete.Enabled = true; dgrdvCourse.Enabled = true; ObjClose(); string sqlStr; sqlStr = "update tb_Course set Cname='" + txtName.Text.Trim() + "',Ccredit='" + txtCredit.Text.Trim() + "',Cperiod='" + txtPeriod.Text.Trim() + "',Csemester='" + cmbSemester.Text.Trim() + "'where Cno='" + txtNo.Text.Trim() + "'"; CDataBase.UpdateDB(sqlStr); RefreshData(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnEnter_Click(object sender, EventArgs e) { try { if (txtOldPassWord.Text == "") { MessageBox.Show("请输入原密码!", "提示"); txtOldPassWord.Focus(); } else if (txtNewPassWord.Text == "") { MessageBox.Show("请输入新密码", "提示"); txtNewPassWord.Focus(); } else if (txtMatcPassWord.Text == "") { MessageBox.Show("请再次输入密码", "提示"); txtMatcPassWord.Focus(); } else if (txtNewPassWord.Text.Trim() == txtMatcPassWord.Text.Trim()) { string sql = "select userpassword from tb_User where username='******'"; DataSet ds = new DataSet(); CDataBase.conn.ConnectionString = CDataBase.connStr; CDataBase.conn.Open(); //SqlCommand cmd = new SqlCommand(sql, CDataBase.conn); //SqlDataReader sdr = cmd.ExecuteReader(); SqlDataAdapter adapter = new SqlDataAdapter(sql, CDataBase.conn); adapter.Fill(ds); if (ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim() == txtOldPassWord.Text.Trim()) { string sqlStr; CDataBase.conn.Close(); sqlStr = "update tb_User set userPassword='******'" + "where userName ='******'"; if (CDataBase.UpdateDB(sqlStr)) { MessageBox.Show("修改成功!", "提示"); } CleaAll(); } else { MessageBox.Show("原密码错误", "提示"); CleaAll(); txtOldPassWord.Focus(); } } else { MessageBox.Show("两次密码输入不一样,重新输入!", "提示"); txtNewPassWord.Text = ""; txtMatcPassWord.Text = ""; txtNewPassWord.Focus(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
//排序 private void btnSort_Click(object sender, EventArgs e) { try { //if (cmbSort.Text.Trim() == "") //{ // MessageBox.Show("请选择排序条件", "提示"); // cmbSort.Focus(); //} string sqlStr1; //, sqlStr2; sqlStr1 = "select tb_grade.sno,tb_student.sname,tb_grade.cno,tb_course.cname,tb_course.cperiod,tb_course.csemester,tb_grade.grade from tb_student inner join tb_grade on tb_student.sno = tb_grade.sno join tb_course on tb_grade.cno = tb_course.cno where tb_course.cname='" + cmbCourse.Text.Trim() + "' ORDER BY grade DESC"; //sqlStr2 = "select tb_grade.sno,tb_student.sname,tb_grade.cno,tb_course.cname,tb_course.cperiod,tb_course.csemester,tb_grade.grade from tb_student inner join tb_grade on tb_student.sno = tb_grade.sno join tb_course on tb_grade.cno = tb_course.cno where tb_course.cname='" + cmbSemester.Text.Trim() + "' ORDER BY grade DESC"; DataSet ds = new DataSet(); //if (cmbSort.SelectedIndex == 0) //{ ds = CDataBase.GetDataFromDB(sqlStr1); if (ds != null) { dgrdvGrade.DataSource = ds.Tables[0]; dgrdvGrade.Columns[0].HeaderText = "学号"; dgrdvGrade.Columns[0].Width = 100; dgrdvGrade.Columns[1].HeaderText = "姓名"; dgrdvGrade.Columns[1].Width = 150; dgrdvGrade.Columns[2].HeaderText = "课程号"; dgrdvGrade.Columns[2].Width = 100; dgrdvGrade.Columns[3].HeaderText = "课程名"; dgrdvGrade.Columns[3].Width = 150; dgrdvGrade.Columns[4].HeaderText = "学分"; dgrdvGrade.Columns[4].Width = 100; dgrdvGrade.Columns[5].HeaderText = "开课学期"; dgrdvGrade.Columns[5].Width = 150; dgrdvGrade.Columns[6].HeaderText = "成绩"; dgrdvGrade.Columns[6].Width = 100; dgrdvGrade_RowHeaderMouseClick(null, null); } } //else if (cmbSort.SelectedIndex == 1) //{ // ds = CDataBase.GetDataFromDB(sqlStr2); // if (ds != null) // { // dgrdvGrade.DataSource = ds.Tables[0]; // dgrdvGrade.Columns[0].HeaderText = "学号"; // dgrdvGrade.Columns[0].Width = 100; // dgrdvGrade.Columns[1].HeaderText = "姓名"; // dgrdvGrade.Columns[1].Width = 150; // dgrdvGrade.Columns[2].HeaderText = "课程号"; // dgrdvGrade.Columns[2].Width = 100; // dgrdvGrade.Columns[3].HeaderText = "课程名"; // dgrdvGrade.Columns[3].Width = 150; // dgrdvGrade.Columns[4].HeaderText = "学分"; // dgrdvGrade.Columns[4].Width = 100; // dgrdvGrade.Columns[5].HeaderText = "开课学期"; // dgrdvGrade.Columns[5].Width = 150; // dgrdvGrade.Columns[6].HeaderText = "成绩"; // dgrdvGrade.Columns[6].Width = 100; // dgrdvGrade_RowHeaderMouseClick(null, null); // } //} catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
//添加 private void btnAdd_Click(object sender, EventArgs e) { try { if (btnAdd.Text.Trim() == "添加") { btnAdd.Text = "确定"; btnCancel1.Visible = true; ObjOpen(); ClearAll(); RefreshData(); btnUpdata.Enabled = false; btnDelete.Enabled = false; dgrdvCourse.Enabled = false; return; } else if (txtNo.Text.Trim() == "") { MessageBox.Show("课程号不能为空", "提示"); txtNo.Focus(); return; } else if (txtName.Text.Trim() == "") { MessageBox.Show("课程名不能为空", "提示"); txtName.Focus(); return; } else if (txtCredit.Text.Trim() == "") { MessageBox.Show("课程学分不能为空", "提示"); txtCredit.Focus(); return; } else if (txtPeriod.Text.Trim() == "") { MessageBox.Show("课程学时不能为空", "提示"); txtPeriod.Focus(); return; } else if (cmbSemester.SelectedIndex == -1) { MessageBox.Show("请选择开课学期", "提示"); cmbSemester.Focus(); return; } else if (!No(txtNo.Text.Trim())) { MessageBox.Show("该课程已有", "提示"); txtNo.Text = ""; txtNo.Focus(); return; } btnCancel1.Visible = false; btnAdd.Text = "添加"; string sqlStr; sqlStr = "insert into tb_Course values('" + txtNo.Text.Trim() + "','" + txtName.Text.Trim() + "','" + txtCredit.Text.Trim() + "','" + txtPeriod.Text.Trim() + "','" + cmbSemester.Text.Trim() + "')"; CDataBase.UpdateDB(sqlStr); RefreshData(); if (MessageBox.Show("添加成功,继续添加吗?", "添加课程信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { btnCancel1.Visible = true; ClearAll(); ObjOpen(); btnAdd.Text = "确定"; } else { ObjClose(); btnUpdata.Enabled = false; btnDelete.Enabled = false; dgrdvCourse.Enabled = false; } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); ObjClose(); btnUpdata.Enabled = true; btnDelete.Enabled = true; dgrdvCourse.Enabled = true; dgrdvCourse_RowHeaderMouseClick(null, null); } }
//录入 private void btnAdd_Click(object sender, EventArgs e) { try { string sql = "select sno,cno from tb_grade where sno='" + txtSno.Text.Trim() + "' and cno='" + txtCno.Text.Trim() + "'"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sql); if (btnAdd.Text == "录入") { btnAdd.Text = "确定"; cleraAll(); txtSno.Text = ""; txtCno.Text = ""; txtGarde.Text = ""; objOpen(); btnUpdate.Enabled = false; btnDelete.Enabled = false; return; } else if (txtSno.Text == "") { MessageBox.Show("学号不能为空!", "提示"); txtSno.Focus(); return; } else if (txtCno.Text == "") { MessageBox.Show("课程号不能为空", "提示"); txtCno.Focus(); return; } else if (ds != null) { MessageBox.Show("该学生此成绩已存在,不能重复录入", "提示"); cleraAll(); txtSno.Focus(); } btnAdd.Text = "录入"; string sqlStr; sqlStr = "insert into tb_grade (Sno,Cno,grade) values ('" + txtSno.Text.Trim() + "','" + txtCno.Text.Trim() + "','" + txtGarde.Text.Trim() + "')"; CDataBase.UpdateDB(sqlStr); RefreshData(); if (MessageBox.Show("录入成功,继续录入吗?", "录入成绩", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { cleraAll(); objOpen(); btnAdd.Text = "确定"; btnAll_Click(sender, e); } else { objClose(); btnUpdate.Enabled = true; btnDelete.Enabled = true; btnAll_Click(sender, e); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); cleraAll(); objClose(); btnAdd.Enabled = true; btnUpdate.Enabled = true; btnDelete.Enabled = true; dgrdvGrade_RowHeaderMouseClick(null, null); } }
//查询 private void btnSelect_Click(object sender, EventArgs e) { try { string sqlStr = ""; if (txtSelect.Text.Trim() == "") { MessageBox.Show("请输入需要查询的" + cmbSelect.SelectedItem.ToString().Trim() + "提示"); return; } else if (cmbSelect.SelectedIndex == 0) { sqlStr = "select * from tb_Student where Sno='" + txtSelect.Text.Trim() + "'"; } else if (cmbSelect.SelectedIndex == 1) { sqlStr = "select * from tb_Student where Sname like'" + txtSelect.Text.Trim() + "%'"; } else if (cmbSelect.SelectedIndex == 2) { sqlStr = "select * from tb_Student where Ssex='" + txtSelect.Text.Trim() + "'"; } else if (cmbSelect.SelectedIndex == 3) { sqlStr = "select * from tb_Student where Sage='" + txtSelect.Text.Trim() + "'"; } else if (cmbSelect.SelectedIndex == 4) { sqlStr = "select * from tb_Student where Sclass='" + txtSelect.Text.Trim() + "'"; } else if (cmbSelect.SelectedIndex == 5) { sqlStr = "select * from tb_Student where Sdept='" + txtSelect.Text.Trim() + "'"; } else if (cmbSelect.SelectedIndex == 6) { sqlStr = "select * from tb_student"; } DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvStudent.DataSource = ds.Tables[0]; dgrdvStudent.Columns[0].HeaderText = "学生学号"; dgrdvStudent.Columns[0].Width = 168; dgrdvStudent.Columns[1].HeaderText = "学生姓名"; dgrdvStudent.Columns[1].Width = 159; dgrdvStudent.Columns[2].HeaderText = "学生性别"; dgrdvStudent.Columns[2].Width = 88; dgrdvStudent.Columns[3].HeaderText = "学生年龄"; dgrdvStudent.Columns[3].Width = 88; dgrdvStudent.Columns[4].HeaderText = "学生班级"; dgrdvStudent.Columns[4].Width = 100; dgrdvStudent.Columns[5].HeaderText = "所在学院(系别)"; dgrdvStudent.Columns[5].Width = 159; dgrdvStudent_RowHeaderMouseClick(null, null); } else { dgrdvStudent.DataSource = null; ClearAll(); MessageBox.Show("没有该条记录,请重新查询。", "提示"); RefreshData(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
//添加 private void btnAdd_Click(object sender, EventArgs e) { try { if (btnAdd.Text == "添加") { btnCancel.Visible = true; btnAdd.Text = "确定"; ClearAll(); //这句无法工作 cmbSex.SelectedIndex = -1; ObjOpen(); RefreshData(); btnUpdate.Enabled = false; btnDelete.Enabled = false; btnSelect.Enabled = false; cmbSelect.Enabled = false; txtSelect.Enabled = false; dgrdvStudent.Enabled = false; return; } else if (txtNo.Text.Trim() == "") { MessageBox.Show("学号不能为空!", "提示"); txtNo.Focus(); return; } else if (txtName.Text.Trim() == "") { MessageBox.Show("姓名不能为空!", "提示"); txtName.Focus(); return; } else if (txtClass.Text.Trim() == "") { MessageBox.Show("班级不能为空!", "提示"); txtClass.Focus(); return; } else if (cmbSex.SelectedIndex == -1) { MessageBox.Show("请选择性别", "提示"); cmbSex.Focus(); return; } else if (txtDept.Text == "") { MessageBox.Show("所属学院(系别)不能为空!", "提示"); txtDept.Focus(); return; } else if (txtAge.Text.Trim() == "") { MessageBox.Show("年龄不能为空!", "提示"); txtAge.Focus(); return; } else if (!No(txtNo.Text.Trim())) { MessageBox.Show("该学号已存在,请重新输入!", "提示"); txtNo.Focus(); return; } btnAdd.Text = "添加"; btnCancel.Visible = false; btnCancel2.Visible = false; string sqlStr; sqlStr = "insert into tb_Student values('" + txtNo.Text.Trim() + "','" + txtName.Text.Trim() + "','" + cmbSex.Text.Trim() + "','" + txtAge.Text.Trim() + "','" + txtClass.Text.Trim() + "','" + txtDept.Text.Trim() + "')"; CDataBase.UpdateDB(sqlStr); RefreshData(); if (MessageBox.Show("添加成功,继续添加吗?", "添加学生信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { btnCancel.Visible = true; ClearAll(); ObjOpen(); btnAdd.Text = "确定"; } else { Objclose(); btnUpdate.Enabled = true; btnDelete.Enabled = true; btnSelect.Enabled = true; cmbSelect.Enabled = true; txtSelect.Enabled = true; dgrdvStudent.Enabled = true; } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); ClearAll(); Objclose(); btnUpdate.Enabled = true; btnDelete.Enabled = true; btnSelect.Enabled = true; cmbSelect.Enabled = true; txtSelect.Enabled = true; dgrdvStudent.Enabled = true; dgrdvStudent_RowHeaderMouseClick(null, null); } }