数据库原理与设计大作业源代码

1、rivate void radBtnOk_Click(object sender, EventArgs e)tryif (radTxtBoxUser.Text.Trim() = )this.radLbInfo.Text = 请输入您的用户名！;else if (radTxtBoxPsw.Text.Trim() = )this.radLbInfo.Text = 请输入您的密码！;elsecommandUnit com = new commandUnit();stringstr =select * from UserInfo where loginNo= + radTxtBoxUser.Text.

2、ToString() + ;DataTable table = com.GetDataSet(str);if (table.Rows.Count 0)_currentUser = radTxtBoxUser.Text;_currentPsw = radTxtBoxPsw.Text;IsLogin = true;this.Close();elsethis.radLbInfo.Text = 密码错误！;radTxtBoxPsw.Text = ;catch (System.Exception ex)(2) 图5-3 (3) radTxtBoxNewPsw.Text.Trim() = radTxtBo

3、xEnterPsw.Text.Trim() = )string currPwd = RFrmLogin.CurrentPsw;if (currPwd = radTxtBoxOldPsw.Text.Trim()commandUnit com = new commandUnit();stringstr =update UserInfo set passWord = +radTxtBoxEnterPsw.Text.ToString() + where loginNo = +RFrmLogin.CurrentUser + ;if (com.ExecuteCommand(str) 0)MessageBo

4、x.Show(密码修改成功！。, 提醒,MessageBoxButtons.OK, MessageBoxIcon.Information);elseMessageBox.Show(, 提醒, MessageBoxButtons.OK, MessageBoxIcon.Information);elseMessageBox.Show(两次密码输入不一致！, 提醒,MessageBoxButtons.OK, MessageBoxIcon.Information);elseMessageBox.Show(输入密码错误！, 提醒,MessageBoxButtons.OK, MessageBoxIcon.

5、Information);(4) 5-5if (radComBoxPower.Text = null |radComBoxPower.Text.Trim() = )commandUnit com = new commandUnit();radTxtBoxOldPsw.Text.ToString() + ;if (com.ExecuteCommand(str) 0)MessageBox.Show(权限修改失败，请联系管理员！。, 提(5) 5-6 e)bool isSuccess = false;commandUnit com = new commandUnit();EmployeeModel

6、emp;for (int j = 0; j radWithGV.RowCount; j+)emp = new EmployeeModel();#region 同步数据if (radWithGV.Rowsj.Tag != null)emp = radWithGV.Rowsj.Tag asEmployeeModel;elseemp.EmployeeNo =radWithGV.Rowsj.CellsemployeeNo.Value.ToString();emp.Name =radWithGV.Rowsj.Cellsname.Value.ToString();emp.Sex =radWithGV.Ro

7、wsj.Cellssex.Value.ToString();emp.IdCard =radWithGV.Rowsj.CellsidCard.Value.ToString();emp.Duty =radWithGV.Rowsj.Cellsduty.Value.ToString();emp.Note =radWithGV.Rowsj.Cellsnote.Value.ToString();emp.IsNew = true;#endregionif (emp.IsNew)string str = select * from EmployeeInfowhere employeeNo = + emp.Em

8、ployeeNo + ;DataTable dtable = com.GetDataSet(str);if (dtable.Rows.Count 0)_isSaved = true;isSuccess = true;emp.IsNew = false;radWithGV.Rowsj.Tag = emp;elseMessageBox.Show(该员工已存在，请审核信息！);else if (emp.IsModified)string strSql = update EmployeeInfo setname=+emp.Name+,sex=+emp.Sex+,idCard=+emp.IdCard+

9、,duty = +emp.Duty +,note = + emp.Note + where employeeNo = + emp.EmployeeNo + ;if (com.ExecuteCommand(strSql) 0)_isSaved = true;isSuccess = true;emp.IsModified = false;radWithGV.Rowsj.Tag = emp;elsecontinue;if (isSuccess)MessageBox.Show(保存成功！);elseMessageBox.Show(数据非法！);catch (System.Exception ex)throw ex;(6) 主要实现代码如下：protectedoverridevoidtSBtnDelete_Click(objectsender,EventArgsDutyModel employee = this.radWithGV.CurrentRow.Tag asDutyModel;if (employee != null) if (!employee.IsNew)commandUnit com = new commandUnit();string numRow = + numRow + ;if (com.ExecuteCommand(str) 0)this