数据库中avgHighrate类型为numeric(18,6)
_variant_t vUsername; //存储从数据库中获取的值。
_RecordsetPtr m_pRecordsetView;//Recordset
CString strOutPut;//输出字符串
vUsername= m_pRecordsetView->GetCollect("avgHighrate");
strOutPut=VariantToString(vUsername);
CString VariantToString(VARIANT var)
{
CString strValue;
_variant_t var_t;
_bstr_t bstr_t;
time_t cur_time;
CTime time_value;
COleCurrency var_currency;
double d;//临时变量 记录wReserved1 之后的数值
switch(var.vt)
{
case VT_EMPTY:
case VT_NULL:strValue=_T("");break;
case VT_UI1:strValue.Format("%d",var.bVal);break;
case VT_I2:strValue.Format("%d",var.iVal);break;
case VT_I4:strValue.Format("%d",var.lVal);break;
case VT_R4:strValue.Format("%f",var.fltVal);break;
case VT_R8:strValue.Format("%f",var.dblVal);break;
case VT_CY:
var_currency=var;
strValue=var_currency.Format(0);break;
case VT_BSTR:
var_t =var;
bstr_t=var_t;
strValue.Format("%s",(const char *)bstr_t);break;
case VT_DATE:
cur_time=var.date;
time_value=cur_time;
strValue.Format("%A,%B,%d,%Y");break;
case VT_BOOL:strValue.Format("%d",var.boolVal);break;
case 14:
d=pow(10,var.wReserved1);
strValue.Format("%f",double(var.lVal)/d);break;
default:strValue=_T("");break;
}
return strValue;
}
//其中 case 14即对应数据库中获取的类型 VT_DECIMAL
经过跟踪var 的值,发现vUserName={x.xxxxxx _VT_DECIMAL}