数据库概论课程设计实验报告书职工考勤系统与文明礼仪伴我行汇编.docx
《数据库概论课程设计实验报告书职工考勤系统与文明礼仪伴我行汇编.docx》由会员分享,可在线阅读,更多相关《数据库概论课程设计实验报告书职工考勤系统与文明礼仪伴我行汇编.docx(7页珍藏版)》请在冰豆网上搜索。
数据库概论课程设计实验报告书职工考勤系统与文明礼仪伴我行汇编
《数据库概论》课程设计实验报告书(职工考勤系统)与《文明礼仪伴我行》汇编
《数据库概论》课程设计实验报告书(职工考勤系统)
=CS_NOCLOSE;returnparameters;}}privatevoidlogininbtn_Click(objectsender,EventArgse){10stringuserName=string.Empty;stringpassword=string.Empty;SqlConnectioncon=newSqlConnection(@Server=(local);IntegratedSecurity=True;Database=职工考勤系统);(来自:
..)con.Open(*);SqlCommandsqlm=newSqlCommand(select*from管理员表whereManagerID='+LoginnameText.Text+',con);SqlDataReaderreader=sqlm.ExecuteReader(*);reader.Read(*);userName=;password=;if(userName==LoginnameText.Text){if(password==PasswordText.Text){this.Hide(*);Menumenu=newMenu(*);menu.ShowDialog(*);this.Close(*);}else{MessageBox.Show(密码错误!
提示,MessageBoxButtons.OK,MessageBoxIcon.Warning);PasswordText.Text=;}}else{MessageBox.Show(登录名错误!
提示,MessageBoxButtons.OK,MessageBoxIcon.Warning);PasswordText.Text=;}}privatevoidresetpasswordbtn_Click(objectsender,EventArgse){if(LoginnameText.Text==||PasswordText.Text==){MessageBox.Show(请将登录名、密码填写完整!
提示,MessageBoxButtons.OK,MessageBoxIcon.Warning);}else{ChangePasswordchapa=newChangePassword(*);chapa.ShowDialog(*);}}privatevoidcancelbtn_Click(objectsender,EventArgse){11DialogResultsss=MessageBox.Show(请确认要退出本软件!
请确认要退出!
MessageBoxButtons.YesNo);if(sss==DialogResult.Yes){Application.Exit(*);}}修改密码窗体代码:
privatevoidYesButton_Click(objectsender,EventArgse){if(OldPasswordText.Text!
=,提示,MessageBoxButtons.OK,MessageBoxIcon.Warning);}elseif(NewPasswordText.Text!
=RePasswordText.Text){MessageBox.Show(两次密码不一致!
提示,MessageBoxButtons.OK,MessageBoxIcon.Warning);}else{SqlConnectioncon=newSqlConnection(@Server=(local);IntegratedSecurity=True;Database=职工考勤系统);con.Open(*);SqlDataAdaptersqlda=newSqlDataAdapter(select*from管理员表,con);SqlCommandsqlm=newSqlCommand(update管理员表set+ManagerPassword=@ManagerPasswordwhereManagerID='+;andManagerPassword='+;,con);,NewPasswordText.Text);sqlda.UpdateCommand=sqlm;;MessageBox.Show(修改成功!
提示,MessageBoxButtons.OK,MessageBoxIcon.Warning);this.Close(*);}}privatevoidCancelButton_Click(objectsender,EventArgse){this.Close(*);},EventArgse){WorkerManageworkermanage=newWorkerManage(*);workermanage.ShowDialog(*);}privatevoidAttendManageButton_Click(objectsender,EventArgse){AttendManageattendmanage=newAttendManage(*);13attendmanage.ShowDialog(*);}privatevoidWorkerLeaveButton_Click(objectsender,EventArgse){WorkerLeaveworkerleave=newWorkerLeave(*);workerleave.ShowDialog(*);}privatevoidOutWorkManageButton_Click(objectsender,EventArgse){OutWorkManageoutworkmanage=newOutWorkManage(*);outworkmanage.ShowDialog(*);}privatevoidAddWorkManageButton_Click(objectsender,EventArgse){AddWorkManageaddworkmanage=newAddWorkManage(*);addworkmanage.ShowDialog(*);}privatevoidSalaryManageButton_Click(objectsender,EventArgse){SalaryManagesalarymanage=newSalaryManage(*);salarymanage.ShowDialog(*);}
《数据库概论》课程设计实验报告书(职工考勤系统)
privatevoidWorkerManage_Load(objectsender,EventArgse){this.人员信息表TableAdapter.Fill(this.职工考勤系统DataSet.人员信息表);bindingNavigator1.BindingSource=人员信息表BindingSource;,人员信息表BindingSource,WorkerName);,人员信息表BindingSource,WorkerID);,人员信息表BindingSource,Birthday);,人员信息表BindingSource,Sex);,人员信息表BindingSource,NativePlace);,人员信息表BindingSource,Phone);,人员信息表BindingSource,EnterTime);,人员信息表BindingSource,Branch);,人员信息表BindingSource,WorkerPosition);,人员信息表BindingSource,BaseSalary);bindingNavigator1.DeleteItem=null;}privatevoid保存SToolStripButton_Click(objectsender,EventArgse){if(this.Validate(*)){人员信息表BindingSource.EndEdit(*);人员信息表TableAdapter.Update(职工考勤系统DataSet.人员信息表);}else{MessageBox.Show(this,验证错误,保存失败,MessageBoxButtons.OK,MessageBoxIcon.Warning);}}privatevoidbindingNavigatorDeleteItem_Click(objectsender,EventArgse){if(MessageBox.Show(确定要删除这条记录吗?
删除确认,MessageBoxButtons.OKCancel,MessageBoxIcon.Information)==DialogResult.OK){人员信息表BindingSource.RemoveCurrent(*);人员信息表BindingSource.EndEdit(*);人员信息表TableAdapter.Update(职工考勤系统DataSet.人员信息表);15}},EventArgse){this.考勤记录表TableAdapter.Fill(this.职工考勤系统DataSet.考勤记录表);bindingNavigator1.BindingSource=考勤记录表BindingSource;,考勤记录表BindingSource,WorkerName);,考勤记录表BindingSource,WorkerID);,考勤记录表BindingSource,StartTime);,考勤记录表BindingSource,ArriveTime);,考勤记录表BindingSource,EndTime);,考勤记录表BindingSource,Condition);bindingNavigator1.DeleteItem=null;}privatevoid保存SToolStripButton_Click(objectsender,EventArgse)16{if(this.Validate(*)){考勤记录表BindingSource.EndEdit(*);考勤记录表TableAdapter.Update(职工考勤系统DataSet.考勤记录表);}else{MessageBox.Show(this,验证错误,保存失败,MessageBoxButtons.OK,MessageBoxIcon.Warning);}}privatevoidbindingNavigatorDeleteItem_Click(objectsender,EventArgse){if(MessageBox.Show(确定要删除这条记录吗?
删除确认,MessageBoxButtons.OKCancel,MessageBoxIcon.Information)==DialogResult.OK){考勤记录表BindingSource.RemoveCurrent(*);考勤记录表BindingSource.EndEdit(*);考勤记录表TableAdapter.Update(职工考勤系统DataSet.考勤记录表);}}privatevoidtoolStripButton3_Click(objectsender,EventArgse){WorkerChooseworkerchoose=newWorkerChoose(*);workerchoose.table=考勤记录表;workerchoose.ShowDialog(*);}privatevoidtoolStripButton2_Click(objectsender,EventArgse){HistoryChoosehistorychoose=newHistoryChoose(*);historych