基于C++的企業(yè)考勤管理系統(tǒng)的設(shè)計(jì)代碼

1、題目12 “公司員工考勤管理系統(tǒng)設(shè)計(jì)”1、問(wèn)題描述某公司需要存儲(chǔ)雇員的編號(hào)、姓名、性別、所在部門(mén)，級(jí)別，并進(jìn)行工資的計(jì)算。其中，雇員分為經(jīng)理、技術(shù)人員、銷(xiāo)售人員和銷(xiāo)售經(jīng)理。定義一個(gè)將小時(shí)換成天數(shù)的類(lèi)。轉(zhuǎn)換規(guī)則：8小時(shí)轉(zhuǎn)換為一天，12小時(shí)轉(zhuǎn)換為1.5天。可進(jìn)行天數(shù)的加、減。定義一個(gè)記錄員工生病、休假時(shí)間的類(lèi)。其中包括：?jiǎn)T工生病沒(méi)工作的天數(shù)、生病可以不工作的最多天數(shù)、員工已經(jīng)帶薪休假的天數(shù)、員工可以帶薪休假的天數(shù)。公司規(guī)定帶薪休假不能超過(guò)24小時(shí)。生病可以不工作的最多不能超過(guò)16小時(shí)。設(shè)計(jì)一程序能夠?qū)救藛T的休假情況進(jìn)行管理，應(yīng)用到繼承、抽象類(lèi)、虛函數(shù)、虛基類(lèi)、多態(tài)和文件的輸入/輸出等內(nèi)容。2、

2、功能要求（1）添加功能：程序能夠任意添加上述四類(lèi)人員的記錄，可提供選擇界面供用戶選擇所要添加的人員類(lèi)別，要求員工的編號(hào)要唯一，如果添加了重復(fù)編號(hào)的記錄時(shí)，則提示數(shù)據(jù)添加重復(fù)并取消添加。還可以添加帶薪休假和生病休假的記錄，每條記錄中必須包含員工編號(hào)和姓名。（2）查詢功能：可根據(jù)編號(hào)、姓名等信息對(duì)已添加的員工信息和休假信息進(jìn)行查詢，如果未找到，給出相應(yīng)的提示信息，如果找到，則顯示相應(yīng)的記錄信息；（3）顯示功能：可顯示當(dāng)前系統(tǒng)中所有記錄，每條記錄占據(jù)一行。（4）編輯功能：可根據(jù)查詢結(jié)果對(duì)相應(yīng)的記錄進(jìn)行修改，修改時(shí)注意編號(hào)的唯一性。（5）刪除功能：主要實(shí)現(xiàn)對(duì)已添加的人員記錄和休假記錄進(jìn)行刪除。如果當(dāng)前

3、系統(tǒng)中沒(méi)有相應(yīng)的人員記錄，則提示“記錄為空！”并返回操作。（6）統(tǒng)計(jì)功能：能根據(jù)多種參數(shù)進(jìn)行人員的統(tǒng)計(jì)。例如，統(tǒng)計(jì)四類(lèi)人員數(shù)量以及總數(shù)，統(tǒng)計(jì)任一員工的休假天數(shù)等信息。（7）保存功能：可將當(dāng)前系統(tǒng)中各類(lèi)人員記錄和休假記錄存入文件中，存入方式任意。（8）讀取功能：可將保存在文件中的信息讀入到當(dāng)前系統(tǒng)中，供用戶進(jìn)行使用。3、問(wèn)題的解決方案根據(jù)系統(tǒng)功能要求，可以將問(wèn)題解決分為以下步驟：（1）應(yīng)用系統(tǒng)分析，建立該系統(tǒng)的功能模塊框圖以及界面的組織和設(shè)計(jì)；（2）分析系統(tǒng)中的各個(gè)實(shí)體及它們之間的關(guān)系；（3）根據(jù)問(wèn)題描述，設(shè)計(jì)系統(tǒng)的類(lèi)層次；（4）完成類(lèi)層次中各個(gè)類(lèi)的描述；（5）完成類(lèi)中各個(gè)成員函數(shù)的定義；（6）

4、完成系統(tǒng)的應(yīng)用模塊；（7）功能調(diào)試；（8）完成系統(tǒng)總結(jié)報(bào)告。#import"msado15.dll" no_namespace rename("EOF,"adoEOF")class CADOConnectionprivate:Static void InitADO();Static void UnInitADO();protected:_ConnectionPtr m_Connection;public:BOOL IsOpen();_ConnectionPtr GetConnection();Cstring GetSQLConstr(CStri

5、ng IP,CString DBName);BOOL Open(CString ConStr);CADOConnection();VirtualCADOConnection();CADOConnection*GetConnection();Int ConCount = 0;CADOConnection g_Connection;CADOConnection*GetConnection()Return & g_Connection;CADOConnection：CADOConnection（）InitADO();m_Connection.CreateInstance("ADOD

6、B.Connection");CADOConnection：CADOConnection（）If(IsOpen();m_Connection->Close();m_Connection = NULL;UnInitADO();Void CADOConnection:InitADO()If(ConCount + = 0)CoInitialize(NULL);void CADOConnection:UnInitADO()if(ConCount = 0)CoUninitialize();BOOL CADOConnection:Open(CString ConStr)if(IsOpen(

7、)m_Connection->Close();m_Connection->Open(_bstr_t)ConStr,","adModeUnknown);return IsOpen();CString CADOConnection:GetSQLConStr(CString IP,CString DBName)CString Str;Str.Format("Provider = SQLOLEDB.1;Persist Security Info = False;User ID = sa;Initial Catalog = %s;Data Source = %s

8、",DBName,IP);return Str;_ConnectionPtr CADOConnection:GetConnection()return m_Connection:BOOL CADOConnection:IsOpen()long State;m_Connection->get_State(&State);if(State = adStateOpen)return true;return false;class CADODataSetprotected:_RecoedsetPtr m_DataSet;CADOConnection *m_Connectionp

9、ublic:void Delete();int GetRecordNo();void move(int nIndex);void Save();void SetFieldValue(CString FieldName,_variant_t Value);void AddNew();BOOL Next();FieldsPtr GetFields();int GetRecordCount();void SetConnetion(CADOConnection *pCon);BOOL Open(CString SQLStr);CADODataSet();virtual CADODataSet();pr

10、ivate:BOOL IsOpen();CADODataSet：CADODataSet()m_DataSet.CreateInstance("ADODB.Recordset");CADODataSet：CADODataSet()if(IsOpen()m_DataSet->Close();m_DataSet = NULL;m_Connection = NULL;void CADODataSet:SetConnection(CADOConnection *pCon)m_Connection = pCon;int CADODataSet:GetRecordCount()if

11、(IsOpen()return m_DataSet->GetRecordCount();elsereturn 0;BOOL CADODataSet:Open(CString SQLStr)if(IsOpen)m_DataSet->Close();BOOL CADODataSet:IsOpen()long State;m_DataSet->get_State(&State);if(State = adStateOpen)return true;return false;FieldsPtr CADODataSet:GetFields()return m_DataSet-&

12、gt;GetFields();BOOL CADODataSet:Next()if(m_DataSet->adoEOF)retuen false;m_DataSet->MoveNext();return true;void CADODataSet:AddNew()m_DataSet->AddNew();void CADODataSet:SetFieldValue(CString FieldName,_variant_t Value0)m_DataSet->PutCollect(_bstr_t)FieldName,Value);void CADODataSet:Save()

13、m_DataSet->Upsate();void CADODataSet:Move(int nIndex)m_DataSet->MoveFirst();m_DataSet->Move(nIndex);int CADODataSet:GetRecordNO()return m_DataSet->AbsolutePositon;void CADODataSet:Delete()m_DateSet->Delete(adAffectCurent);BOOL CPersonApp:InitInstance()AfxEnableControlContainer();#ifde

14、f_AFXDLLEnable3dControls();#elseEnable3dControlsStatic(); #endifLoadSkin();BOOLbCon=GetConnection()->Open(GetConnection()->GetSQLConStr("","tb_person");CLoginDialog logindlg;if(logindlg.DoModal()! = IDOK)return false;CPersonDlg dlg;m_pMainWnd =& dlg;int nRespon

15、se = dlg.DoModal();if(nResponse = IDOK)else if(nResponse = IDCANCEL)return FALSE; BOOL CLoginDialog:OnInitDialog()CDialog:OnInitDialog();m_DataSet.SetConnection(GetConnection();m_DataSet.Open("Select * From Tab_User");int count = m_DataSet.GetRecordCount();for(int i = 0;i < count;i+)m_U

16、serList.AddString(_bstr_t)m_DataSet.GetFields()->ItemL"UserName"->Value);m_DataSet.Next();m_UserList.SetCurSel(0);return TRUE;void CLoginDialog:OnLogin()CString sql,user,pass;m_UserList.GetWindowText(user);m_passWord.GetWindowText(pass);sql.Format("Select * From tab_user Where U

17、serName = '%s' and PassWord = '%s'",user,pass);m_DataSet.Open(sql);if(m_DataSet.GetRecordCount() = 1):SetUserName(user);this->OnOk(); elseAfxMessageBox;void CUserManage:UpdateGrid() m_DataSet.Open("Select * From tab_User"); m_grid.DeleteAllItems(); for(int = 0;i <

18、; m_DataSet.GetRecordCount();i+) m_grid.InsertItem(i,(_bstr_t)m_DataSet.GetFields()->ItemL"UserName"->Value);int no = m_DataSet.GetRecordNo();m_grid.SetItemData(i,no);m_DataSet.Next(); BOOL CUserManage:OnInitDialog() CDialog:OnInitDialog();m_grid.SetExtendedStyle(LVS_EX_FULLROWSELECT

19、|LVS_EX_GRIDLINES);m_grid.InsertColumn(0,"用戶名");m_grid.SetColumnWidth(0,150);m_DataSet.SetConnection(:GetConnection();UpdateGrid();return TRUE; void CUserManage:OnAppend() CUserEdit useredit;if (useredit.DoModal() = IDOK)m_DataSet.AddNew();m_DataSet.SetFieldValue("UserName",(_bst

20、r_t));m_DataSet.Save();UpdateGrid();void CUserManage:OnEdit() CUserEdit useredit;int no = m_grid.GetItemData(m_grid.GetSelectionMark();m_DataSet.move(no-1); = (char *)(_bstr_t)m_DataSet.GetFields()->ItemL"UserName"->Value;if (useredit.DoModal() = IDOK)m_Data

21、Set.SetFieldValue("UserName",(_bstr_t));m_DataSet.Save();UpdateGrid();void CUserManage:OnDelete() if (MessageBox("是否刪除此記錄！","提示",MB_YESNO|MB_ICONWARNING) = IDYES)int no = m_grid.GetItemData(m_grid.GetSelectionMark();m_DataSet.move(no-1);m_DataSet.Delete();m

22、_DataSet.Save();UpdateGrid();void CDeptManage:GetNode(HTREEITEM pNode,int nPid)HTREEITEM node;CADODataSet DataSet;DataSet.SetConnection(:GetConnection();CString str;str.Format("Select * From tab_Dept where pid = %d,nPid ");DataSet.Open(str);int count = DataSet.GetRecordCount();int ID;_vari

23、ant_t value;for(int i = 0;i < count;i+)node = m_tree.InsertItem(bstr_t)DataSet.GetFields()->Item"DeptName"->Value,pNode);value = (_vaiant_t)DataSet.GetFields()->Item"ID"->Value;ID = Val;m_tree.SetItemData(node,ID);GetNode(node,ID);DataSet.Next();void CDept

24、Manage:UpdateDept()m_tree.DeleteAllItems();GetNode(TVI_ROOT,0);void CDeptManage:GetNode(HTREEITEM pNode,int nPid)HTREEITEM node;CADODataSet DataSet;DataSet.SetConnection(:GetConnection();CString str;str.Format("Select * From tab_Dept where pid = %d",nPid);DataSet.Open(str);int count = Data

25、Set.GetRecordCount();int ID;_variant_t value;for (int i = 0;i<count;i+)node = m_tree.InsertItem(_bstr_t)DataSet.GetFields()->Item"DeptName"->Value,pNode);value = (_variant_t)DataSet.GetFields()->Item"ID"->Value;ID = Val;m_tree.SetItemData(node,ID);GetNode(

26、node,ID);DataSet.Next();void CDeptManage:OnAdd() CDeptEdit deptedit;if (deptedit.DoModal() = IDOK)HTREEITEM pNode = m_tree.GetSelectedItem();int pID;if (deptedit.isroot)pID = 0;elsepID = m_tree.GetItemData(pNode);CADODataSet dataset;dataset.SetConnection(:GetConnection();dataset.Open("Select to

27、p 1 * From tab_Dept");dataset.AddNew();dataset.SetFieldValue("DeptName",(_variant_t));dataset.SetFieldValue("memo",(_variant_t)deptedit.memo);dataset.SetFieldValue("PID",(long)pID);dataset.Save();UpdateDept();void CDeptManage:OnEdit() CDeptEdit deptedi

28、t;deptedit.visible = false;HTREEITEM pNode = m_tree.GetSelectedItem();if (pNode = 0)return;int pID = m_tree.GetItemData(pNode);CADODataSet dataset;dataset.SetConnection(:GetConnection();CString str;str.Format("Select * From tab_Dept where id = %d",pID);dataset.Open(str); = (ch

29、ar *)(_bstr_t)dataset.GetFields()->ItemL"DeptName"->Value;deptedit.memo = (char *)(_bstr_t)dataset.GetFields()->Item"memo"->Value;if (deptedit.DoModal() = IDOK)dataset.SetFieldValue("DeptName",(_variant_t));dataset.SetFieldValue("memo"

30、,(_variant_t)deptedit.memo);dataset.Save();UpdateDept();void CDeptManage:OnDelete() HTREEITEM pNode = m_tree.GetSelectedItem();if (pNode = 0)return;if (MessageBox("是否刪除此記錄！","提示",MB_YESNO|MB_ICONWARNING) = IDYES)int pID = m_tree.GetItemData(pNode);CADODataSet dataset;dataset.SetC

31、onnection(:GetConnection();CString str;str.Format("Select * From tab_Dept where id = %d",pID);dataset.Open(str);dataset.Delete();dataset.Save();UpdateDept();void CPersonManage:OnSelchangedTreedept(NMHDR * pNMHDR,LRESULT * pResult)NM_TREEVIEW * pNMTreeView = (NM_TREEVIEW*)pNMHDR;m_DeptID =

32、m_tree.GetItemData(pNMTreeView->itemNew.hItem);UpdatePerson();*pResult = 0;void CPersonManage:UpdatePerson()m_list.DeleteAllItems();CADODataSet DataSet;DataSet.SetConnection(:GetConnection();CString str;if(m_DeptID = -1)str.Format("Select * From tab_Employees");elsestr.Format("Sele

33、ct * From tab_Employees where Dept = %d",m_DeptID); DataSet.Open(str);int count = DataSet.GetRecordCount();int n = 0;_variant_t value;for(int i = 0;i<count;i+)int index = 1;m_list.InsertItem(n,(_bstr_t)DataSet.GetFields()->Item"Emp_Id"->Value);value = DataSet.GetFields()->

34、Item"AutoID"->Value;m_list.SetItemData(n,value,lVal);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Emp_NAME"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Sex"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.

35、GetFields()->Item"Nationality"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Birth"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Political_Party"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.Ge

36、tFields()->Item"Culture_Level"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Marital_Condition"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Id_Card"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSe

37、t.GetFields()->Item"Office_phone"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Mobile"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"HireDate"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFi

38、elds()->Item"Duty"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Memo"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Files_Keep_Org"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->

39、Item"Hukou"->Value);m_list.SetItemText(n,index+,(_bstr_t)DataSet.GetFields()->Item"Family_Place"->Value);n +;DataSet.Next();BOOL CPersonManage:OnInitDialog() CDialog:OnInitDialog();m_DeptID = -1;UpdateDept();int i = 0;m_list.InsertColumn(i,"人員編號(hào)");m_list.SetCol

40、umnWidth(i+,80);m_list.InsertColumn(i,"人員名稱");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"性別");m_list.SetColumnWidth(i+,50);m_list.InsertColumn(i,"民族");m_list.SetColumnWidth(i+,50);m_list.InsertColumn(i,"出生日期");m_list.SetColumnWidth(i+,100);m_list.Ins

41、ertColumn(i,"政治面貌");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"文化程度");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"婚姻狀況");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"身份證號(hào)");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"辦公

42、電話");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"手機(jī)電話");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"到崗日期");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"職務(wù)");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"備注");m_list.SetColu

43、mnWidth(i+,100);m_list.InsertColumn(i,"家庭住址");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"檔案所在地");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"戶口所在地");m_list.SetColumnWidth(i+,100);m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);UpdatePer

44、son();return TRUE; BOOL CPersonManage:OnInitDialog() CDialog:OnInitDialog();m_DeptID = -1;UpdateDept();int i = 0;m_list.InsertColumn(i,"人員編號(hào)");m_list.SetColumnWidth(i+,80);m_list.InsertColumn(i,"人員名稱");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"性別");m_list.Set

45、ColumnWidth(i+,50);m_list.InsertColumn(i,"民族");m_list.SetColumnWidth(i+,50);m_list.InsertColumn(i,"出生日期");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"政治面貌");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"文化程度");m_list.SetColumnWidth(i+,100);m_li

46、st.InsertColumn(i,"婚姻狀況");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"身份證號(hào)");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"辦公電話");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"手機(jī)電話");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,&q

47、uot;到崗日期");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"職務(wù)");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"備注");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"家庭住址");m_list.SetColumnWidth(i+,100);m_list.InsertColumn(i,"檔案所在地");m_list.

48、SetColumnWidth(i+,100);m_list.InsertColumn(i,"戶口所在地");m_list.SetColumnWidth(i+,100);m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);UpdatePerson();return TRUE; void CPersonManage:OnEdit() if (m_list.GetSelectionMark() = -1)return;int id = m_list.GetItemData(m_list.GetSelecti

49、onMark();CPersonEdit personedit;CADODataSet dataset;dataset.SetConnection(:GetConnection();CString str;str.Format("select * from tab_Employees where autoid = %d",id);dataset.Open(str);personedit.m_id = (char *)(_bstr_t)dataset.GetFields()->Item"Emp_Id"->Value;personedit.m_n

50、ame = (char *)(_bstr_t)dataset.GetFields()->Item"Emp_NAME"->Value;personedit.m_sex = (char *)(_bstr_t)dataset.GetFields()->Item"Sex"->Value;personedit.m_nationality = (char *)(_bstr_t)dataset.GetFields()->Item"Nationality"->Value;CString birth = (char

51、*)(_bstr_t)dataset.GetFields()->Item"Birth"->Value;if (!birth.IsEmpty()/設(shè)置日期數(shù)據(jù)int yy=atoi(birth.Left(4);int mm=atoi(birth.Mid(6,2);int dd=atoi(birth.Mid(9,2);CTime tbirth(yy,mm,dd,0,0,0);personedit.m_birth = tbirth;personedit.m_farty = (char *)(_bstr_t)dataset.GetFields()->Item&qu

52、ot;Political_Party"->Value;personedit.m_culture = (char *)(_bstr_t)dataset.GetFields()->Item"Culture_Level"->Value;personedit.m_marital = (char *)(_bstr_t)dataset.GetFields()->Item"Marital_Condition"->Value;personedit.m_card = (char *)(_bstr_t)dataset.GetField

53、s()->Item"Id_Card"->Value;personedit.m_office = (char *)(_bstr_t)dataset.GetFields()->Item"Office_phone"->Value;personedit.m_mobile = (char *)(_bstr_t)dataset.GetFields()->Item"Mobile"->Value;CString hire = (char *)(_bstr_t)dataset.GetFields()->Item

54、"HireDate"->Value;if (!hire.IsEmpty()/設(shè)置日期數(shù)據(jù)int yy=atoi(hire.Left(4);int mm=atoi(hire.Mid(6,2);int dd=atoi(hire.Mid(9,2);CTime thire(yy,mm,dd,0,0,0);personedit.m_hire = thire;personedit.m_duty = (char *)(_bstr_t)dataset.GetFields()->Item"Duty"->Value;personedit.m_memo =

55、(char *)(_bstr_t)dataset.GetFields()->Item"Memo"->Value;personedit.m_files = (char *)(_bstr_t)dataset.GetFields()->Item"Files_Keep_Org"->Value;personedit.m_hukou = (char *)(_bstr_t)dataset.GetFields()->Item"Hukou"->Value;personedit.m_family = (char *)(

56、_bstr_t)dataset.GetFields()->Item"Family_Place"->Value;personedit.m_DeptData= dataset.GetFields()->Item"Dept"->Value;if (personedit.DoModal() = IDOK)dataset.SetFieldValue("Emp_Id",(_bstr_t)personedit.m_id);dataset.SetFieldValue("Emp_NAME",(_bstr_t)

57、personedit.m_name);dataset.SetFieldValue("Sex",(_bstr_t)personedit.m_sex);dataset.SetFieldValue("Nationality",(_bstr_t)personedit.m_nationality);dataset.SetFieldValue("Birth",(_bstr_t)personedit.m_birth.Format("%Y-%m-%d");dataset.SetFieldValue("Political_Party",(_bstr_t)personedit.m_farty);dataset.SetFieldValue("Culture_Level",(_bstr_t)personedit.m_culture);dataset.SetFieldValue("Marital_Condition",(_bstr_t)personedit.m_marital);dataset.SetFieldValue("Id_Card",(_bstr_t)personedit.m_card);dataset.Set