?? adorecordset.cpp
字號:
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
_variant_t vt;
vt.vt = VT_UI4;
vt.ulVal = value;
return PutCollect(index, vt);
}
BOOL CAdoRecordSet::PutCollect(LPCTSTR strFieldName, const DWORD &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if (GetFieldType(strFieldName) != adUnsignedBigInt)
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
_variant_t vt;
vt.vt = VT_UI4;
vt.ulVal = value;
return PutCollect(strFieldName, vt);
}
BOOL CAdoRecordSet::PutCollect(long index, const float &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if (GetFieldType(index) != adSingle)
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
return PutCollect(index, _variant_t(value));
}
BOOL CAdoRecordSet::PutCollect(LPCTSTR strFieldName, const float &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if (GetFieldType(strFieldName) != adSingle)
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
return PutCollect(strFieldName, _variant_t(value));
}
BOOL CAdoRecordSet::PutCollect(long index, const double &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if (GetFieldType(index) != adDouble)
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
return PutCollect(index, _variant_t(value));
}
BOOL CAdoRecordSet::PutCollect(LPCTSTR strFieldName, const double &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if (GetFieldType(strFieldName) != adDouble)
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
return PutCollect(strFieldName, _variant_t(value));
}
BOOL CAdoRecordSet::PutCollect(long index, const COleDateTime &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if ( GetFieldType(index) != adDate
&& GetFieldType(index) != adDBDate
&& GetFieldType(index) != adDBTime
&& GetFieldType(index) != adDBTimeStamp)
{
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
}
#endif
_variant_t vt;
vt.vt = VT_DATE;
vt.date = value;
return PutCollect(index, vt);
}
BOOL CAdoRecordSet::PutCollect(LPCTSTR strFieldName, const COleDateTime &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if ( GetFieldType(strFieldName) != adDate
&& GetFieldType(strFieldName) != adDBDate
&& GetFieldType(strFieldName) != adDBTime
&& GetFieldType(strFieldName) != adDBTimeStamp)
{
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
}
#endif
_variant_t vt;
vt.vt = VT_DATE;
vt.date = value;
return PutCollect(strFieldName, vt);
}
BOOL CAdoRecordSet::PutCollect(long index, const COleCurrency &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if (GetFieldType(index) != adCurrency)
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
if (value.m_status == COleCurrency::invalid) return FALSE;
_variant_t vt;
vt.vt = VT_CY;
vt.cyVal = value.m_cur;
return PutCollect(index, vt);
}
BOOL CAdoRecordSet::PutCollect(LPCTSTR strFieldName, const COleCurrency &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if (GetFieldType(strFieldName) != adCurrency)
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
if (value.m_status == COleCurrency::invalid) return FALSE;
_variant_t vt;
vt.vt = VT_CY;
vt.cyVal = value.m_cur;
return PutCollect(strFieldName, vt);
}
BOOL CAdoRecordSet::PutCollect(long index, const CString &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if (! (GetFieldType(index) == adVarChar
|| GetFieldType(index) == adChar
|| GetFieldType(index) == adLongVarChar
|| GetFieldType(index) == adVarWChar
|| GetFieldType(index) == adWChar
|| GetFieldType(index) == adLongVarWChar))
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
_variant_t vt;
vt.vt = value.IsEmpty() ? VT_NULL : VT_BSTR;
vt.bstrVal = value.AllocSysString();
return PutCollect(index, vt);
}
BOOL CAdoRecordSet::PutCollect(LPCTSTR strFieldName, const CString &value)
{
ASSERT(m_pRecordset != NULL);
#ifdef _DEBUG
if (! (GetFieldType(strFieldName) == adVarChar
|| GetFieldType(strFieldName) == adChar
|| GetFieldType(strFieldName) == adLongVarChar
|| GetFieldType(strFieldName) == adVarWChar
|| GetFieldType(strFieldName) == adWChar
|| GetFieldType(strFieldName) == adLongVarWChar))
TRACE(_T("Warning: 你要存貯的字段與變量的數據類型不符; 文件: %s; 行: %d\n"), __FILE__, __LINE__);
#endif
_variant_t vt;
vt.vt = value.IsEmpty() ? VT_NULL : VT_BSTR;
vt.bstrVal = value.AllocSysString();
return PutCollect(strFieldName, vt);
}
/*########################################################################
------------------------------------------------
讀取字段的值
------------------------------------------------
########################################################################*/
BOOL CAdoRecordSet::GetCollect(long index, COleDateTime &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartodate(m_pRecordset->GetCollect(_variant_t(index)));
return TRUE;
}
catch (_com_error e)
{
value.SetStatus(COleDateTime::null);
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(LPCTSTR strFieldName, COleDateTime &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartodate(m_pRecordset->GetCollect(_variant_t(strFieldName)));
return TRUE;
}
catch (_com_error e)
{
value.SetStatus(COleDateTime::null);
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(long index, COleCurrency &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartocy(m_pRecordset->GetCollect(_variant_t(index)));
return TRUE;
}
catch (_com_error e)
{
value.m_status = COleCurrency::null;
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(LPCTSTR strFieldName, COleCurrency &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartocy(m_pRecordset->GetCollect(_variant_t(strFieldName)));
return TRUE;
}
catch (_com_error e)
{
value.m_status = COleCurrency::null;
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(long index, bool &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartobool(m_pRecordset->GetCollect(_variant_t(index)));
return TRUE;
}
catch (_com_error e)
{
value = false;
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(LPCSTR strFieldName, bool &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartobool(m_pRecordset->GetCollect(_variant_t(strFieldName)));
return TRUE;
}
catch (_com_error e)
{
value = false;
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(long index, BYTE &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartoby(m_pRecordset->GetCollect(_variant_t(index)));
return TRUE;
}
catch (_com_error e)
{
value = 0;
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(LPCSTR strFieldName, BYTE &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartoby(m_pRecordset->GetCollect(_variant_t(strFieldName)));
return TRUE;
}
catch (_com_error e)
{
value = 0;
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(long index, short &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartoi(m_pRecordset->GetCollect(_variant_t(index)));
return TRUE;
}
catch (_com_error e)
{
value = 0;
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(LPCSTR strFieldName, short &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartoi(m_pRecordset->GetCollect(_variant_t(strFieldName)));
return TRUE;
}
catch (_com_error e)
{
value = 0;
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(long index, int &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = (int)vartol(m_pRecordset->GetCollect(_variant_t(index)));
return TRUE;
}
catch (_com_error e)
{
value = 0;
return FALSE;
}
return FALSE;
}
BOOL CAdoRecordSet::GetCollect(LPCSTR strFieldName, int &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = (int)vartol(m_pRecordset->GetCollect(_variant_t(strFieldName)));
return TRUE;
}
catch (_com_error e)
{
value = 0;
return FALSE;
}
}
BOOL CAdoRecordSet::GetCollect(long index, long &value)
{
ASSERT(m_pRecordset != NULL);
try
{
value = vartol(m_pRecordset->GetCollect(_variant_t(index)));
return TRUE;
}
catch (_com_error e)
{
value = 0;
return FALS?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -