資源簡介
用ADO+MFC+ACCESS實現的小型人事管理系統~實現員工信息錄入,修改,條件查詢,按照word和excel格式導出查詢結果記錄集。以及系統權限限制管理。對于mfc+ado操作access數據庫的使用是個很好的教程~結構簡單清晰~注釋全面詳細~

代碼片段和文件信息
//?AddNewComAndDepartDlg.cpp?:?implementation?file
//
#include?“stdafx.h“
#include?“ministryperson.h“
#include?“AddNewComAndDepartDlg.h“
#ifdef?_DEBUG
#define?new?DEBUG_NEW
#undef?THIS_FILE
static?char?THIS_FILE[]?=?__FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
//?AddNewComAndDepartDlg?dialog
AddNewComAndDepartDlg::AddNewComAndDepartDlg(CWnd*?pParent?/*=NULL*/)
:?CDialog(AddNewComAndDepartDlg::IDD?pParent)
{
//{{AFX_DATA_INIT(AddNewComAndDepartDlg)
//?NOTE:?the?ClassWizard?will?add?member?initialization?here
//}}AFX_DATA_INIT
}
void?AddNewComAndDepartDlg::DoDataExchange(CDataExchange*?pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(AddNewComAndDepartDlg)
DDX_Control(pDX?IDC_ACDS_LIST?m_ListShow);
DDX_Control(pDX?IDC_COMBO_ACAD_SELECTCOM?m_Cmb_ACAD_SelectCom);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(AddNewComAndDepartDlg?CDialog)
//{{AFX_MSG_MAP(AddNewComAndDepartDlg)
ON_BN_CLICKED(IDC_BUTTON_ACDS_STATUS1?OnButtonAcdsStatus1)
ON_BN_CLICKED(IDC_BUTTON_ACDS_STATUS2?OnButtonAcdsStatus2)
ON_BN_CLICKED(IDC_BUTTON_ACDS_SAVE1?OnButtonAcdsSave1)
ON_BN_CLICKED(IDC_BUTTON_ACDS_SAVE2?OnButtonAcdsSave2)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
//?AddNewComAndDepartDlg?message?handlers
BOOL?AddNewComAndDepartDlg::OnInitDialog()?
{
CDialog::OnInitDialog();
//?TODO:?Add?extra?initialization?here
//?顯示已有的單位信息
m_ListShow.SetExtendedstyle(LVS_EX_FLATSB?|?
LVS_EX_GRIDLINES?|?
LVS_EX_FULLROWSELECT?|?
LVS_EX_ONECLICKACTIVATE);
m_ListShow.InsertColumn(0?“當前現有的單位“???LVCFMT_LEFT?165);
m_ListShow.InsertColumn(1?“當前現有的部門“???LVCFMT_LEFT?168);
ShowComAndDepartInfo();
return?TRUE;??//?return?TRUE?unless?you?set?the?focus?to?a?control
??????????????//?EXCEPTION:?OCX?Property?Pages?should?return?FALSE
}
/*********************************************************************
函數說明: ??顯示已經存在的【單位】
函數參數: ??
*********************************************************************/
void?AddNewComAndDepartDlg::ShowExistentCompany(CComboBox?*pCombox)
{
CADOOperation?ADOdbo;
CString?strComp;
ADOdbo.OpenTable(“Search_Table“); //?打開【搜索】表
if?(ADOdbo.IsLastRow())
{
ADOdbo.CloseTable();
return;
}
//?得到單位名
pCombox->ResetContent();
pCombox->AddString(“請選擇已有的單位“);
ADOdbo.MoveFirst();
ADOdbo.GetItemContentStr(“Search_Company“?CADOOperation::ADO_TYPE_STRING?&strComp);
pCombox->AddString(strComp);
DWORD?dwRecCount?=?(ADOdbo.GetRecordCount()?-?1);
ADOdbo.CloseTable();
CString?SQL;
SQL.Format(“SELECT?Search_Company?FROM?Search_Table?WHERE?1=1“);
ADOdbo.OpenRecordset(SQL);
ADOdbo.MoveFirst();
for?(DWORD?i?=?2;?i?<=?dwRecCount;?i++)
{
CString?strCompOne;
ADOdbo.MoveTo(i?-?1);
ADOdbo.GetItemContentStr(“Search_Company“?CADOOperation::ADO_TYPE_STRING?&strComp);
s
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????12588??2008-12-10?11:42??MinistryPerson\AddNewComAndDepartDlg.cpp
?????文件???????1684??2008-10-19?21:55??MinistryPerson\AddNewComAndDepartDlg.h
?????文件??????24677??2008-11-23?18:04??MinistryPerson\ADOOperation.cpp
?????文件???????2148??2008-10-29?21:36??MinistryPerson\ADOOperation.h
?????文件???????1507??2008-09-05?09:52??MinistryPerson\ADOView.cpp
?????文件????????684??2008-09-05?09:27??MinistryPerson\ADOView.h
?????文件???????8298??2008-10-21?22:07??MinistryPerson\AllTogetherMainDlg.cpp
?????文件???????1704??2008-10-12?17:25??MinistryPerson\AllTogetherMainDlg.h
?????文件??????25385??2008-11-19?22:24??MinistryPerson\BasicInfoDlg.cpp
?????文件???????2470??2008-11-19?22:04??MinistryPerson\BasicInfoDlg.h
?????文件???????1098??2008-11-01?23:13??MinistryPerson\BmpButton.cpp
?????文件???????1232??2008-11-01?23:13??MinistryPerson\BmpButton.h
?????文件??????10889??2008-12-22?20:07??MinistryPerson\DemissionInfoDlg.cpp
?????文件???????2078??2008-12-08?12:03??MinistryPerson\DemissionInfoDlg.h
?????文件???????5336??2008-09-25?15:44??MinistryPerson\EditableListCtrl.cpp
?????文件???????1783??2008-09-25?12:12??MinistryPerson\EditableListCtrl.h
?????文件?????155803??2008-11-23?17:50??MinistryPerson\excel9.cpp
?????文件??????40992??2008-11-23?17:50??MinistryPerson\excel9.h
?????文件?????638976??1999-03-20?05:00??MinistryPerson\EXCEL9.OLB
?????文件??????17504??2008-11-13?20:42??MinistryPerson\FamilyInforDlg.cpp
?????文件???????2437??2008-10-15?21:56??MinistryPerson\FamilyInforDlg.h
?????文件???????1315??2008-10-19?21:57??MinistryPerson\FuncFilterInfoDlg.cpp
?????文件???????1299??2008-10-19?21:57??MinistryPerson\FuncFilterInfoDlg.h
?????文件???????7193??2008-11-08?13:48??MinistryPerson\FuncOper.cpp
?????文件???????1251??2008-11-08?13:47??MinistryPerson\FuncOper.h
?????文件??????23420??2008-12-10?11:54??MinistryPerson\FuncOutPosInfoDlg.cpp
?????文件???????2243??2008-12-10?11:12??MinistryPerson\FuncOutPosInfoDlg.h
?????文件??????26349??2008-12-10?11:53??MinistryPerson\FuncPayProtectDlg.cpp
?????文件???????2710??2008-12-09?22:53??MinistryPerson\FuncPayProtectDlg.h
?????文件??????22635??2008-12-10?11:55??MinistryPerson\FuncRemoveInfoDlg.cpp
............此處省略113個文件信息
評論
共有 條評論