addunitdlg.cpp

access dao 数据库

// addunitdlg.cpp : 实现文件
//

#include "stdafx.h"
#include "kaoqing.h"
#include "addunitdlg.h"
#include ".\addunitdlg.h"


// addunitdlg 对话框

IMPLEMENT_DYNAMIC(addunitdlg, CDialog)
addunitdlg::addunitdlg(CWnd* pParent /*=NULL*/)
	: CDialog(addunitdlg::IDD, pParent)
	, unitname(_T(""))
{
}

addunitdlg::~addunitdlg()
{
}

void addunitdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT1, unitname);
	DDX_Control(pDX, IDC_LIST1, unitlistbox);
	DDX_Control(pDX, IDC_EDIT1, unitnameet);
	DDX_Control(pDX, IDOK, dwbt);
}


BEGIN_MESSAGE_MAP(addunitdlg, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
END_MESSAGE_MAP()


// addunitdlg 消息处理程序

void addunitdlg::OnBnClickedOk()
{UpdateData (true);
unitname.Remove (' ');
UpdateData (false);
if(unitname==_T("")) return;

CDaoRecordset unitrec;
kaoqingbu.Open (".\\kqbook.mdb",0,0,";PWD=caolinjie1226loveyou");//打开数据库
unitrec.m_pDatabase=&kaoqingbu;
unitrec.Open (dbOpenDynaset, _T("select * from [工地登记表]"));
try
{unitrec.AddNew ();
unitrec.SetFieldValue(0,CString(unitname));
unitrec.Update ();
}

catch( CDaoException* e )
{
    AfxMessageBox("该考勤单位已经存在");
	e->Delete( );
	
    unitrec.Close ();
	kaoqingbu.Close ();
	unitnameet.SetFocus ();
	return;
 }

unitlistbox.AddString (unitname);

unitrec.Close ();kaoqingbu.Close ();
 AfxMessageBox("添加成功");
	
	OnOK();
}

BOOL addunitdlg::OnInitDialog()
{
	CDialog::OnInitDialog();

CDaoRecordset unitrec;
kaoqingbu.Open (".\\kqbook.mdb",0,0,";PWD=caolinjie1226loveyou");//打开数据库
unitrec.m_pDatabase=&kaoqingbu;
unitrec.Open (dbOpenDynaset, _T("select * from [工地登记表]"));

if(unitrec.IsBOF ()) {unitrec.Close ();kaoqingbu.Close (); return true;}

while (!unitrec.IsEOF ())
	{unitlistbox.AddString (CString(V_BSTRT(&unitrec.GetFieldValue( 0 ))));
	 unitrec.MoveNext ();
	 
	}
unitrec.Close ();kaoqingbu.Close ();




	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应返回 FALSE
}