資源簡(jiǎn)介
用ADO+MFC+ACCESS實(shí)現(xiàn)的小型人事管理系統(tǒng)~實(shí)現(xiàn)員工信息錄入,修改,條件查詢(xún),按照word和excel格式導(dǎo)出查詢(xún)結(jié)果記錄集。以及系統(tǒng)權(quán)限限制管理。對(duì)于mfc+ado操作access數(shù)據(jù)庫(kù)的使用是個(gè)很好的教程~結(jié)構(gòu)簡(jiǎn)單清晰~注釋全面詳細(xì)~

代碼片段和文件信息
//?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?“當(dāng)前現(xiàn)有的單位“???LVCFMT_LEFT?165);
m_ListShow.InsertColumn(1?“當(dāng)前現(xiàn)有的部門(mén)“???LVCFMT_LEFT?168);
ShowComAndDepartInfo();
return?TRUE;??//?return?TRUE?unless?you?set?the?focus?to?a?control
??????????????//?EXCEPTION:?OCX?Property?Pages?should?return?FALSE
}
/*********************************************************************
函數(shù)說(shuō)明: ??顯示已經(jīng)存在的【單位】
函數(shù)參數(shù): ??
*********************************************************************/
void?AddNewComAndDepartDlg::ShowExistentCompany(CComboBox?*pCombox)
{
CADOOperation?ADOdbo;
CString?strComp;
ADOdbo.OpenTable(“Search_Table“); //?打開(kāi)【搜索】表
if?(ADOdbo.IsLastRow())
{
ADOdbo.CloseTable();
return;
}
//?得到單位名
pCombox->ResetContent();
pCombox->AddString(“請(qǐng)選擇已有的單位“);
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
?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件??????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個(gè)文件信息
評(píng)論
共有 條評(píng)論