毕业设计（论文）-考勤管理系统的设计与实现.doc

() access2007vc+abstract in the corporations today, employees job of check on work attendance not only workload isvery large, but also time is very strong. along with development of database technology andprogress of corporation informations building, using computer to manage check on workattendance of corporations which it is necessary. it saves a mass of manpower and materialresources and greatly lightens workload of employees.attendance management system is a business-to-appraisal of the implementation ofinformation management, which aims is designed to achieve staff attendance data collection,information query and statistical process automation, improve personnel managementmodernization, and the convenience of staff to report to work, facilitate management statistics,the examination staff attendance.key words: attendance, access2007, database,vc+() 0 . 11. . 11.1. . 11.2. . 12. . 22.1. . 22.2. . 33. . 33.1. . 33.2. . 33.2.1. . 33.2.2. . 43.2.3. . 54. . 64.1. access2007 . 64.2. . 74.3. . 84.4. . 95. . 155.1. . 155.2. ado . 166. . 17 . 18 . 18()1. 01. 1.1. 41.2. 1 vc+6.0windowsvc+6.0vc1vc+6.0access 20072 ()2. 2 access2007 access excel 3access accessaccess access 3. 3.1. 1 2 3 4 vc+6.0pcodbc()4. vc+6.04.1. 1 2 3 4 5. 5.1. 5.2. 5.2.1. 1 ()6. personinfodepartmentattendanceabsentdutydeptpersonpay2 ,.3 entityrelationshipapproachererer46.1.1. 3.13.23.1 ()56.2. 3.2.3 erpersoninfo3.1 3.1 personid personname personsex dept job deptnodepartment3.2 3.2 deptno dept job pay attendance3.3 3.3 personid personname atdays dutydays abdays atmonth absent3.4 3.4 personid personname abdays abreason abmonth abremarks abpay duty3.5 ()6 3.5 personid personname dutydays dumonth dutypay personpay3.6 3.6 personid personname dutyno basepay dutypay abpay sumpay pmonth 7. 7.1. access2007accessaccess1 access2007attendance4.1 4.1 ()7 2 4.2 7.2. 7.3. stdafx.h#import c:program filescommon filessystemadomsado15.dll no_namespacerename(eof,adoeof)cattendanceappinitinstanceafxoleinit();hresult hr;m_pconnection.createinstance(_uuidof(connection);trym_pconnection-connectionstring=provider=microsoft.jet.oledb.4.0;datasource=attendance.mdb;m_pconnection-connectiontimeout=10;hr=m_pconnection-open(,admodeunknown);if(hr!=s_ok) ()8 afxmessagebox();catch(_com_error e)cstring errormessage;errormessage.format(!rn:%d,e.errormessage();afxmessagebox(errormessage);/extern cattendanceapp theapp; ,7.4. :_recordsetptr m_precper;m_precper.createinstance(_uuidof(recordset); /trym_precper-open(select*frompersoninfo,_variant_t(idispatch*)theapp.m_pconnection,true),adopendynamic,adlockoptimistic,adcmdtext);catch(_com_error e)cstring str;str.format(rn%s,e.errormessage);afxmessagebox(str);sqlm_precper-addnew();m_precper-putcollect(personid,(_variant_t)(dlg.m_strno);m_precper-putcollect(personname,(_variant_t)(dlg.m_strname);m_precper-putcollect(personsex,(_variant_t)(strsex); ()9 m_precper-putcollect(dept,(_variant_t)(dlg.m_strdept);m_precper-putcollect(job,(_variant_t)(dlg.m_strjob);m_precper-update();m_precper-close();m_precper-putcollect(personid,(_variant_t)(dlg.m_strno);m_precper-putcollect(personname,(_variant_t)(dlg.m_strname);m_precper-putcollect(personsex,(_variant_t)(strsex);m_precper-putcollect(dept,(_variant_t)(dlg.m_strdept);m_precper-putcollect(job,(_variant_t)(dlg.m_strjob);m_precper-update();m_precper-close();m_precper-delete(adaffectcurrent);m_precper-update();m_precper-close();7.5. 1 login4.1 4.1login id username =12 userpassword =16 cstring strname;strname.format(select userpassword from login where username=%s,m_strname);bstr bstrsql=strname.allocsysstring();try ()10 m_precordset-open(bstrsql,_variant_t(idispatch*)theapp.m_pconnection,true),adopenstatic,adlockoptimistic,adcmdtext);catch(_com_error e)cstring stropen;stropen.format(rn%d,e.errormessage);afxmessagebox(stropen);if(!m_precordset-adoeof)if(m_strpass=(_bstr_t)m_precordset-getcollect(userpassword)cdialog:onok();elseafxmessagebox();elseafxmessagebox();4.3 ()11 7.6. cstring str;str.format(select * from login where username=%s,m_strname);bstr bstrsql=str.allocsysstring();trym_precordset-open(bstrsql,_variant_t(idispatch*)theapp.m_pconnection,true),adopendynamic,adlockoptimistic,adcmdtext);catch(_com_error e)afxmessagebox(e.errormessage();if(m_p