畢業(yè)設(shè)計（論文）考勤管理系統(tǒng)的設(shè)計與實現(xiàn)

1、() 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

2、 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 collect

3、ion,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.

4、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 v

5、c+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.

6、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. access2007accessacce

7、ss1 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.je

8、t.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. :_recor

9、dsetptr 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

10、_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_p

11、recper-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-u

12、pdate();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_preco

13、rdset-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()

14、;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