testdatabasedlg.h

evc连接数据库 evc连接数据库 evc连接数据库

// TestDatabaseDlg.h : header file
//

#if !defined(AFX_TESTDATABASEDLG_H__2A5B2467_D94F_4E48_A7F6_515EFB450EEA__INCLUDED_)
#define AFX_TESTDATABASEDLG_H__2A5B2467_D94F_4E48_A7F6_515EFB450EEA__INCLUDED_

#if _MSC_VER >= 1000
#pragma once
#endif // _MSC_VER >= 1000

/////////////////////////////////////////////////////////////////////////////
// CTestDatabaseDlg dialog

//定义数据库文件名
const LPTSTR DBFILENAME = _T("\\My Database\\abc.db");
//定义数据库名
const LPTSTR DBTABLENAME = _T("Record");

//定义记录数据库表结构与其指针
typedef struct
{
	FILETIME cData;          //日期，年，月，日，时，分
	int     Storehouse;     //仓库，范围0--99
    int     Point;          //点，  范围0--99
	int     Position;       //位置，范围0--99
	int     Number;         //号，  范围0--99
	int     MeasureVale;    //测量值，范围0--9999
}REC_RECORD,*PREC_RECORD;
//定义各标志段ID
#define ID_DATA        MAKELONG(CEVT_FILETIME,5)
#define ID_STOREHOUSE  MAKELONG(CEVT_UI2,1)
#define ID_POINT       MAKELONG(CEVT_UI2,2)
#define ID_POSITION    MAKELONG(CEVT_UI2,3)
#define ID_NUMBER      MAKELONG(CEVT_UI2,4)
#define ID_MEASUREVAL  MAKELONG(CEVT_UI4,5)

class CTestDatabaseDlg : public CDialog
{
// Construction
public:
	CTestDatabaseDlg(CWnd* pParent = NULL);	// standard constructor

// Dialog Data
	//{{AFX_DATA(CTestDatabaseDlg)
	enum { IDD = IDD_TESTDATABASE_DIALOG };
		// NOTE: the ClassWizard will add data members here
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CTestDatabaseDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);	// DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CTestDatabaseDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnAddRecord();
	afx_msg void OnCloseDatabase();
	afx_msg void OnDeleteRecord();
	afx_msg void OnEditRecord();
	afx_msg void OnOpenDatabase();
	afx_msg void OnRefreshDatabase();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()

private:
	//得到数据库的记录数
	int GetRecordCount(CEGUID* pCeGuid,CEOID ceOid);
	//添加一条新的记录
	bool AddNewRecord(REC_RECORD rec);
	//编辑记录
	bool EditRecord(REC_RECORD rec,CEOID ceOid);

private:
	CEGUID m_ceGuid;    //存储数据库文件卷标识
	HANDLE m_hDB;       //存储数据库句柄
	CEOID  m_ceOid;     //存储数据库对象标识
};

//{{AFX_INSERT_LOCATION}}
// Microsoft eMbedded Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_TESTDATABASEDLG_H__2A5B2467_D94F_4E48_A7F6_515EFB450EEA__INCLUDED_)