{
btnAdd.Text = \确¨?¤定?§\; ObjOpen(); ClearAll(); RefreshData();
btnUpdate.Enabled = false; btnDelete.Enabled = false; btnClose.Enabled = false; cmbSelect.Enabled = false; txtSelect.Enabled = false; btnSelect.Enabled = false; btnAll.Enabled = false; dgrdvStudent.Enabled = false; return; }
else if (txtNo.Text.Trim() == \) {
MessageBox.Show(\编ਤ号?不?能¨1为a空?!\, \提?¨￠示o?\); txtNo.Focus(); return; }
else if (txtName.Text.Trim() == \) {
MessageBox.Show(\姓?名?不?能¨1为a空?!\, \提?¨￠示o?\); txtName.Focus(); return; }
else if (cmbSex.SelectedIndex == -1) {
MessageBox.Show(\请?先¨¨选?择?性?别àe再¨′添?¨a加¨?!\, \提?¨￠示o?\);
cmbSex.Focus(); return; }
else if (txtAge.Text == \) {
MessageBox.Show(\请?输o?入¨?年¨o龄￠?!\, \提?¨￠示o?\); txtAge.Focus(); return; }
else if (txtDept.Text.Trim() == \) {
MessageBox.Show(\请?输o?入¨?学?ì院o!\, \提?¨￠示o?\); txtDept.Focus();
8
return; }
else if (!No(txtNo.Text.Trim())) {
MessageBox.Show(\该?编ਤ号?已??存??在¨2!\, \提?¨￠示o?\); txtNo.Text = \; txtNo.Focus(); return; }
btnAdd.Text = \添?¨a加¨?\; string sqlStr1, sqlStr2;
string psw = CPublic.GetMd5Str(txtNo.Text.Trim());
sqlStr1 = \ + txtNo.Text.Trim() + \ + txtName.Text.Trim() +
\ + cmbSex.Text.Trim() + \ + txtAge.Text.Trim() + \ + txtDept.Text.Trim() + \;
sqlStr2 = \ + txtNo.Text.Trim() + \ + psw.Trim() +
\作á??者?用??户?ì','是o?')\; CDataBase.UpdateDB(sqlStr1); CDataBase.UpdateDB(sqlStr2); RefreshData();
if (MessageBox.Show(\添?¨a加¨?成¨|功|!继¨?续?添?¨a加¨?吗e?\, \添?¨a加¨?书o¨|籍?\, MessageBoxButtons.YesNo,
MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) {
ClearAll(); ObjOpen();
btnAdd.Text = \确¨?¤定?§\; } else {
ObjClose();
btnUpdate.Enabled = true; btnDelete.Enabled = true; btnClose.Enabled = true; cmbSelect.Enabled = true; txtSelect.Enabled = true; btnSelect.Enabled = true; btnAll.Enabled = true; dgrdvStudent.Enabled = true; } }
9
catch (Exception ex) {
CDataBase.conn.Close(); MessageBox.Show(ex.Message); ClearAll(); ObjClose();
btnUpdate.Enabled = true; btnDelete.Enabled = true; btnClose.Enabled = true; cmbSelect.Enabled = true; txtSelect.Enabled = true; btnSelect.Enabled = true; btnAll.Enabled = true; dgrdvStudent.Enabled = true;
dgrdvStudent_RowHeaderMouseClick(null, null); } }
修改：
private void btnUpdate_Click(object sender, EventArgs e) { try {
if (btnUpdate.Text.Trim() == \修T改?\) {
btnUpdate.Text = \确¨?¤定?§\; btnAdd.Enabled = false; btnDelete.Enabled = false; btnClose.Enabled = false; cmbSelect.Enabled = false; txtSelect.Enabled = false; btnSelect.Enabled = false; btnAll.Enabled = false; txtName.Enabled = true; txtAge.Enabled = true; cmbSex.Enabled = true; txtDept.Enabled = true; txtName.Focus(); } else {
btnUpdate.Text = \修T改?\; btnAdd.Enabled = true; btnDelete.Enabled = true; btnClose.Enabled = true;
10
cmbSelect.Enabled = true; txtSelect.Enabled = true; btnSelect.Enabled = true; btnAll.Enabled = true; ObjClose(); string sqlStr;
sqlStr = \ + txtName.Text.Trim() + \ +
cmbSex.Text.Trim() + \ + txtAge.Text.Trim() + \ +
txtDept.Text.Trim() + \ + 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 {
if (txtNo.Text.Trim() == \) {
MessageBox.Show(\没?有?D可¨|删|?除y的ì?记?录?!\, \提?¨￠示o?\); return; }
string sqlStr;
sqlStr = \ + txtNo.Text.Trim() + \;
if (CDataBase.GetDataFromDB(sqlStr) != null) {
MessageBox.Show(\已??有?D该?书o¨|籍?信?息?é,不?能¨1删|?除y该?书o¨|籍?!\, \删|?除y出?错?¨a\,
MessageBoxButtons.OK, MessageBoxIcon.Error); return; }
else if (MessageBox.Show(\确¨?¤定?§要?a删|?除y书o¨|籍?“??\ + txtName.Text.Trim() + \吗e?\, \删|?除y书o¨|籍?\,
MessageBoxButtons.YesNo, MessageBoxIcon.Question,
11
