WinCE資料庫操作之CeCreateDatabaseEx

與CCeDBDatabase類資料庫相比，CeCreateDatabaseEx具有獨特的優勢，其建立路徑可以指定的特性決定了其資料可以永久儲存的固有優勢，但相比CCeDBDatabase類資料庫而言，CeCreateDatabaseEx完全應用api函數操作，其操作也相對複雜一些。

Records允許的9種資料類型：

資料類型	描述
IVal	2-byte signed integer
UiVal	2-byte unsigned integer
LVal	4-byte signed integer
UlVal	4-byte unsigned integer
FILETIME	A time and date structure
LPWSTR	0-terminated Unicode string
CEBLOB	A collection of bytes
BOOL	Boolean
Double	8-byte signed value

雖然CeCreateDatabaseEx由于直接操作api函數而使得其相對複雜，但将其封裝後最終的使用者就不會覺察，其下是我在使用過程中封裝的幾個類，僅供參考：

// InfoIndexYCBase.h: interface for the CInfoIndexYCBase class.

#if !defined(AFX_INFOINDEXYCBASE_H__4AC91339_5B2C_4BF0_A721_5E97AD849B2C__INCLUDED_)

#define AFX_INFOINDEXYCBASE_H__4AC91339_5B2C_4BF0_A721_5E97AD849B2C__INCLUDED_

#if _MSC_VER > 1000

#pragma once

#endif // _MSC_VER > 1000

class CInfoIndexYCBase

{

public:

CInfoIndexYCBase();

virtual ~CInfoIndexYCBase();

public:

CString ViewParam(void); //檢視結構體内容

protected:

enum{YCCOUNT = 13, STANDBYCOUNT = 10}; //YCCOUNT代表遙測量個數、STANDBYCOUNT代表備用參數個數

public:

//設定、擷取No

void SetNo(const CString &strNo);

const CString GetNo(void)const;

//設定、擷取SNo

void SetSNo(const CString &strSNo);

const CString GetSNo(void)const;

//設定、擷取一次、二次标志

//TRUE為一次、FALSE為二次

void SetTransFlag(const BOOL &bTransFlag);

const BOOL GetTransFlag(void)const;

//設定、擷取PT一次(不取float類型是因為含有機關)

void SetPT1(const CString &strPT1);

const CString GetPT1(void)const;

//設定、擷取PT二次

void SetPT2(const CString &strPT2);

const CString GetPT2(void)const;

//設定、擷取CT一次

void SetCT1(const CString &strCT1);

const CString GetCT1(void)const;

//設定、擷取CT二次

void SetCT2(const CString &strCT2);

const CString GetCT2(void)const;

//設定、擷取遙測量選擇标志

void SetYCSelectFlag(const BOOL *pbYCSelect, const int &nYCCount = YCCOUNT);

void GetYCSelectFlag(BOOL *pbYCSelect, const int &nYCCount = YCCOUNT);

//設定、擷取協定類型

void SetProtocolID(const int &nProtocolID);

const int GetProtocolID(void)const;

//設定、擷取點表配置步驟索引

void SetIndexConfigStep(const int &nIndexConfigStep);

const int GetIndexConfigStep(void)const;

//設定、擷取遙測量辨別碼有效标志

void SetMarkEffectFlag(const BOOL *pbMarkEffectFlag, const int &nStandbyCount = STANDBYCOUNT);

void GetMarkEffectFlag(BOOL *pbMarkEffectFlag, const int &nStandbyCount = STANDBYCOUNT);

//設定、擷取是否已配置詳細資訊标志

void SetHaveDetailInfoFlag(const BOOL &bHaveDetailInfoFlag);

BOOL GetHaveDetailInfoFlag(void);

//設定、擷取遙測量索引有效标志

void SetYCIndexEffectFlag(const BOOL *pbYCIndexEffectFlag, const int &nYCCount = YCCOUNT);

void GetYCIndexEffectFlag(BOOL *pbYCIndexEffectFlag, const int &nYCCount = YCCOUNT);

//設定、擷取遙測量算法

void SetYCArith(const int *pnYCArith, const int &nYCCount = YCCOUNT);

void GetYCArith(int *pnYCArith, const int &nYCCount = YCCOUNT);

//設定、擷取系數K

void SetCoefficientK(const float *pfCoefficientK, const int &nYCCount = YCCOUNT);

void GetCoefficientK(float *pfCoefficientK, const int &nYCCount = YCCOUNT);

//設定、擷取系數B

void SetCoefficientB(const float *pfCoefficientB, const int &nYCCount = YCCOUNT);

void GetCoefficientB(float *pfCoefficientB, const int &nYCCount = YCCOUNT);

protected:

void NewPropVal(CEPROPVAL *prgPropVal,

const int &nStartIndex,

int &nIndex);

void PropValToRecord(CEPROPVAL *prgPropVal, int &nIndex);

void DeletePropVal(void);

protected:

//将數組轉換為指定格式(Ua|Ub|Uc|Uab|Ucb|Uca|Ia|Ib|Ic|P|Q|Cos|F)

CString FormatDataToSpecialStr(const int *pnData, const int &nYCCount = YCCOUNT);

CString FormatDataToSpecialStr(const float *pfData, const int &nYCCount = YCCOUNT);

//将指定格式的字元串分離成數組

void DetachDataFromSpecialStr(const CString &strData, int *pnData, const int &nYCCount = YCCOUNT);

void DetachDataFromSpecialStr(const CString &strData, float *pfData, const int &nYCCount = YCCOUNT);

//指派，為子類重載 = 做準備

void Evaluate(const CInfoIndexYCBase &infoIndexBase);

protected:

CString m_strNo; //No

CString m_strSNo; //SNo

CString m_strTransFlag; //一次、二次标志。0為二次、1為一次

CString m_strPT1; //PT一次

CString m_strPT2; //PT二次

CString m_strCT1; //CT一次

CString m_strCT2; //CT二次

//遙測量選擇标志

//其格式為：Ua|Ub|Uc|Uab|Ucb|Uca|Ia|Ib|Ic|P|Q|Cos|F

//選中為1、否則為0

CString m_strYCSelectFlag;

CString m_strProtocolID; //協定類型：-1代表未配、0代表Finally、1代表Other、2代表CDT、3代表101、4代表103、5代表104

CString m_strIndexConfigStep; //點表資訊配置步驟索引：-1代表未配、0代表已配置基本資訊、1代表已配置詳細資訊

CString m_strMarkEffectFlag; //遙測辨別碼有效标志，0為無效、1為有效

CString m_strHaveDetailInfoFlag; //是否已配置詳細資訊标志

CString m_strYCIndexEffectFlag; //遙測索引有效标志，針對每一個遙測量是否配置索引。0為無效、1為有效

CString m_strYCArith; //遙測量算法，其格式為：Ua|Ub|Uc|Uab|Ucb|Uca|Ia|Ib|Ic|P|Q|Cos|F，未配置為-1

CString m_strCoefficientK; //系數K，其格式為：Ua|Ub|Uc|Uab|Ucb|Uca|Ia|Ib|Ic|P|Q|Cos|F

CString m_strCoefficientB; //系數B，其格式為：Ua|Ub|Uc|Uab|Ucb|Uca|Ia|Ib|Ic|P|Q|Cos|F

};

#endif // !defined(AFX_INFOINDEXYCBASE_H__4AC91339_5B2C_4BF0_A721_5E97AD849B2C__INCLUDED_)

// InfoIndexYCBase.cpp: implementation of the CInfoIndexYCBase class.

#include "stdafx.h"

#include "InfoIndexYCBase.h"

// Construction/Destruction

CInfoIndexYCBase::CInfoIndexYCBase()

{

m_strNo = _T(""); //No

m_strSNo = _T(""); //SNo

m_strTransFlag = _T(""); //一次、二次标志。0為二次、1為一次

m_strPT1 = _T(""); //PT一次

m_strPT2 = _T(""); //PT二次

m_strCT1 = _T(""); //CT一次

m_strCT2 = _T(""); //CT二次

m_strYCSelectFlag = _T("-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1"); //遙測量選擇标志

m_strProtocolID = _T("-1"); //協定類型：-1代表未配、0代表Finally、1代表Other、2代表CDT、3代表101、4代表103、5代表104

m_strIndexConfigStep = _T("-1"); //點表資訊配置步驟索引：-1代表未配、0代表已配置基本資訊、1代表已配置詳細資訊

m_strMarkEffectFlag = _T("0|0|0|0|0|0|0|0|0|0"); //遙測量辨別碼有效位

m_strHaveDetailInfoFlag = _T("0"); //是否已配置詳細資訊标志

m_strYCIndexEffectFlag = _T("0|0|0|0|0|0|0|0|0|0|0|0|0");; //遙測索引有效标志，0為無效、1為有效

m_strYCArith = _T("-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1"); //遙測量算法，格式如上

m_strCoefficientK = _T("0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0");

m_strCoefficientB = _T("0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0");

}

CInfoIndexYCBase::~CInfoIndexYCBase()

{

}

//檢視結構體内容

CString CInfoIndexYCBase::ViewParam()

{

CString str;

str = _T("No: ") + m_strNo + _T("/n");

str += _T("SNo: ") + m_strSNo + _T("/n");

str += _T("一次、二次标志: ") + m_strTransFlag + _T("/n");

str += _T("PT一次: ") + m_strPT1 + _T("/t");

str += _T("PT二次: ") + m_strPT2 + _T("/n");

str += _T("CT一次: ") + m_strCT1 + _T("/t");

str += _T("CT二次: ") + m_strCT2 + _T("/n");

str += _T("遙測量選擇标志: ") + m_strYCSelectFlag + _T("/n");

str += _T("協定類型: ") + m_strProtocolID + _T("/n");

str += _T("點表資訊配置步驟索引: ") + m_strIndexConfigStep + _T("/n");

str += _T("遙測辨別碼有效标志: ") + m_strMarkEffectFlag + _T("/n");

str += _T("是否已配置詳細資訊标志: ") + m_strHaveDetailInfoFlag + _T("/n");

str += _T("遙測索引有效标志: ") + m_strYCIndexEffectFlag + _T("/n");

str += _T("遙測量算法: ") + m_strYCArith + _T("/n");

str += _T("系數K: ") + m_strCoefficientK + _T("/n");

str += _T("系數B: ") + m_strCoefficientB + _T("/n/n");

return str;

}

//将數組轉換為指定格式(Ua|Ub|Uc|Uab|Ucb|Uca|Ia|Ib|Ic|P|Q|Cos|F)

CString CInfoIndexYCBase::FormatDataToSpecialStr(const int *pnData, const int &nYCCount)

{

ASSERT(nYCCount > 0);

CString str(_T("")), str1(_T(""));

str.Format(_T("%d"), pnData[0]);

for(register int i = 1; i < nYCCount; i++)

{

str1.Format(_T("|%d"), pnData[i]);

str += str1;

}

return str;

}

CString CInfoIndexYCBase::FormatDataToSpecialStr(const float *pfData, const int &nYCCount)

{

ASSERT(nYCCount > 0);

CString str(_T("")), str1(_T(""));

str.Format(_T("%f"), pfData[0]);

for(register int i = 1; i < nYCCount; i++)

{

str1.Format(_T("|%f"), pfData[i]);

str += str1;

}

return str;

}

//将指定格式的字元串分離成數組

void CInfoIndexYCBase::DetachDataFromSpecialStr(const CString &strData, int *pnData, const int &nYCCount)

{

ASSERT(nYCCount > 0);

CString strTemp(strData), str;

for(register int i = 0; i < nYCCount; i++)

{

str = strTemp;

if(str.Find(_T("|"), 0) != -1)

{

str.Delete(strTemp.Find(_T("|"), 0), strTemp.GetLength() - strTemp.Find(_T("|"), 0));

strTemp.Delete(0, strTemp.Find(_T("|"), 0) + 1);

}

swscanf(str, _T("%d"), &pnData[i]);

}

void CInfoIndexYCBase::DetachDataFromSpecialStr(const CString &strData, float *pfData, const int &nYCCount)

{

ASSERT(nYCCount > 0);

CString strTemp(strData), str;

for(register int i = 0; i < nYCCount; i++)

{

str = strTemp;

if(str.Find(_T("|"), 0) != -1)

{

str.Delete(strTemp.Find(_T("|"), 0), strTemp.GetLength() - strTemp.Find(_T("|"), 0));

strTemp.Delete(0, strTemp.Find(_T("|"), 0) + 1);

}

swscanf(str, _T("%f"), &pfData[i]);

}

//設定、擷取No

void CInfoIndexYCBase::SetNo(const CString &strNo)

{

m_strNo = strNo;

}

const CString CInfoIndexYCBase::GetNo()const

{

return m_strNo;

}

//設定、擷取SNo

void CInfoIndexYCBase::SetSNo(const CString &strSNo)

{

m_strSNo = strSNo;

}

const CString CInfoIndexYCBase::GetSNo()const

{

return m_strSNo;

}

//設定、擷取一次、二次标志

//TRUE為一次、FALSE為二次

void CInfoIndexYCBase::SetTransFlag(const BOOL &bTransFlag)

{

m_strTransFlag = bTransFlag ? _T("1") : _T("0");

}

const BOOL CInfoIndexYCBase::GetTransFlag()const

{

if(m_strTransFlag == _T("1"))

return TRUE;

return FALSE;

}

//設定、擷取PT一次(不取float類型是因為含有機關)

void CInfoIndexYCBase::SetPT1(const CString &strPT1)

{

m_strPT1 = strPT1;

}

const CString CInfoIndexYCBase::GetPT1()const

{

return m_strPT1;

}

//設定、擷取PT二次

void CInfoIndexYCBase::SetPT2(const CString &strPT2)

{

m_strPT2 = strPT2;

}

const CString CInfoIndexYCBase::GetPT2()const

{

return m_strPT2;

}

//設定、擷取CT一次

void CInfoIndexYCBase::SetCT1(const CString &strCT1)

{

m_strCT1 = strCT1;

}

const CString CInfoIndexYCBase::GetCT1()const

{

return m_strCT1;

}

//設定、擷取CT二次

void CInfoIndexYCBase::SetCT2(const CString &strCT2)

{

m_strCT2 = strCT2;

}

const CString CInfoIndexYCBase::GetCT2()const

{

return m_strCT2;

}

//設定、擷取遙測量選擇标志

void CInfoIndexYCBase::SetYCSelectFlag(const BOOL *pbYCSelect, const int &nYCCount)

{

m_strYCSelectFlag = FormatDataToSpecialStr(pbYCSelect, nYCCount);

}

void CInfoIndexYCBase::GetYCSelectFlag(BOOL *pbYCSelect, const int &nYCCount)

{

DetachDataFromSpecialStr(m_strYCSelectFlag, pbYCSelect, nYCCount);

}

//設定、擷取協定類型

void CInfoIndexYCBase::SetProtocolID(const int &nProtocolID)

{

m_strProtocolID.Format(_T("%d"), nProtocolID);

}

const int CInfoIndexYCBase::GetProtocolID()const

{

int nRet;

swscanf(m_strProtocolID, _T("%d"), &nRet);

return nRet;

}

//設定、擷取點表配置步驟索引

void CInfoIndexYCBase::SetIndexConfigStep(const int &nIndexConfigStep)

{

m_strIndexConfigStep.Format(_T("%d"), nIndexConfigStep);

}

const int CInfoIndexYCBase::GetIndexConfigStep()const

{

int nRet;

swscanf(m_strIndexConfigStep, _T("%d"), &nRet);

return nRet;

}

//設定、擷取遙測量辨別碼有效标志

void CInfoIndexYCBase::SetMarkEffectFlag(const BOOL *pbMarkEffectFlag, const int &nStandbyCount)

{

m_strMarkEffectFlag = FormatDataToSpecialStr(pbMarkEffectFlag, nStandbyCount);

}

void CInfoIndexYCBase::GetMarkEffectFlag(BOOL *pbMarkEffectFlag, const int &nStandbyCount)

{

DetachDataFromSpecialStr(m_strMarkEffectFlag, pbMarkEffectFlag, nStandbyCount);

}

//設定、擷取是否已配置詳細資訊标志

void CInfoIndexYCBase::SetHaveDetailInfoFlag(const BOOL &bHaveDetailInfoFlag)

{

m_strHaveDetailInfoFlag = bHaveDetailInfoFlag ? _T("1") : _T("0");

}

BOOL CInfoIndexYCBase::GetHaveDetailInfoFlag()

{

BOOL bRet = (m_strHaveDetailInfoFlag == _T("0")) ? FALSE : TRUE;

return bRet;

}

//設定、擷取遙測量索引有效标志

void CInfoIndexYCBase::SetYCIndexEffectFlag(const BOOL *pbYCIndexEffectFlag, const int &nYCCount)

{

m_strYCIndexEffectFlag = FormatDataToSpecialStr(pbYCIndexEffectFlag, nYCCount);

}

void CInfoIndexYCBase::GetYCIndexEffectFlag(BOOL *pbYCIndexEffectFlag, const int &nYCCount)

{

DetachDataFromSpecialStr(m_strYCIndexEffectFlag, pbYCIndexEffectFlag, nYCCount);

}

//設定、擷取遙測量算法

void CInfoIndexYCBase::SetYCArith(const int *pnYCArith, const int &nYCCount)

{

m_strYCArith = FormatDataToSpecialStr(pnYCArith, nYCCount);

}

void CInfoIndexYCBase::GetYCArith(int *pnYCArith, const int &nYCCount)

{

DetachDataFromSpecialStr(m_strYCArith, pnYCArith, nYCCount);

}

//設定、擷取系數K

void CInfoIndexYCBase::SetCoefficientK(const float *pfCoefficientK, const int &nYCCount)

{

m_strCoefficientK = FormatDataToSpecialStr(pfCoefficientK, nYCCount);

}

void CInfoIndexYCBase::GetCoefficientK(float *pfCoefficientK, const int &nYCCount)

{

DetachDataFromSpecialStr(m_strCoefficientK, pfCoefficientK, nYCCount);

}

//設定、擷取系數B

void CInfoIndexYCBase::SetCoefficientB(const float *pfCoefficientB, const int &nYCCount)

{

m_strCoefficientB = FormatDataToSpecialStr(pfCoefficientB, nYCCount);

}

void CInfoIndexYCBase::GetCoefficientB(float *pfCoefficientB, const int &nYCCount)

{

DetachDataFromSpecialStr(m_strCoefficientB, pfCoefficientB, nYCCount);

}

void CInfoIndexYCBase::NewPropVal( CEPROPVAL *prgPropVal,

const int &nStartIndex,

int &nIndex)

{

//No