// MyDBWork.cpp: implementation of the CMyDBWork class.
//
//////////////////////////////////////////////////////////////////////
#include "stdafx.h"
#include "MyDBWork.h"
//#include <icrsint.h>
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif
//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
CMyDBWork::CMyDBWork()
{
m_pConn = NULL;
m_pRecord = NULL;
char szPath[MAX_BUFF]; memset(szPath, 0, MAX_BUFF);
m_WriteLog.GetLogPath(szPath, MAX_BUFF);
if (strlen(szPath) > 0) {
strcat(szPath, "DBError\\");
m_WriteLog.SetLogPath(szPath);
}
SetConnStr();
HRESULT hr = CoInitialize(NULL);
if (FAILED(hr)){
m_WriteLog.WriteLog("CoInitialize fail\n", strlen("CoInitialize fail\n"), LOG_ERR);
}
}
CMyDBWork::~CMyDBWork()
{
CoUninitialize();
}
bool CMyDBWork::CollectMsg(const char *szColumnName, long &lTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column(szColumnName);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
lTemp = RusultGet.lVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(const char *szColumnName, BYTE &btTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column(szColumnName);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
btTemp = RusultGet.bVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(const char *szColumnName, DWORD &dwTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column(szColumnName);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
dwTemp = RusultGet.ulVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(const char *szColumnName, UINT &iTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column(szColumnName);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
iTemp = RusultGet.ulVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(const char *szColumnName, int &iTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column(szColumnName);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
iTemp = RusultGet.intVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(const char *szColumnName, float &fTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column(szColumnName);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
fTemp = RusultGet.fltVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(const char *szColumnName, double &dbTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column(szColumnName);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
dbTemp = RusultGet.dblVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(const char *szColumnName, char &chTemp){
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column(szColumnName);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
chTemp = char(RusultGet.bstrVal[0]);
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s\n", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(const char *szColumnName, char *szBuff, int nBuffSize)
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column(szColumnName);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
WideCharToMultiByte(CP_ACP, 0, RusultGet.bstrVal, -1, szBuff, nBuffSize, NULL, NULL);
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(ULONG nIndex, long &lTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column((long)nIndex);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
lTemp = RusultGet.lVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(ULONG nIndex, BYTE &btTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column((long)nIndex);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
btTemp = RusultGet.bVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(ULONG nIndex, DWORD &dwTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column((long)nIndex);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
dwTemp = RusultGet.ulVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(ULONG nIndex, UINT &iTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
_variant_t Column((long)nIndex);
_variant_t RusultGet = m_pRecord->Fields->GetItem(Column)->Value;
iTemp = RusultGet.ulVal;
bResult = true;
}
catch(_com_error e){
char szLog[MAX_BUFF]; memset(szLog, 0, MAX_BUFF);
sprintf(szLog, "%s", (char *)(e.Description()));
m_WriteLog.WriteLog(szLog, strlen(szLog), LOG_ERR);
}
}
return bResult;
}
bool CMyDBWork::CollectMsg(ULONG nIndex, int &iTemp )
{
bool bResult = false;
if (adStateClosed != m_pRecord->State) {
try{
- 1
- 2
- 3
前往页