//修改 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 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); } }
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 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); } }
//窗体载入 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 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); } }
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); } }
//修改 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 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 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); } }
//添加 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 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); } }